Course Content
Introduction to Power BI
0/3
Introduction to Power BI
04:33
Download Course Files
SQL Handwritten Notes
Different Visualizations in Power BI
0/9
Creating a Bar Plot
09:58
Creating Pie Chart
03:32
Creating Ribbon Chart
02:37
Creating Scatter Plot
04:10
Creating Waterfall Chart
04:41
Creating Funnel Chart
01:59
Creating Line & Area Plot
05:12
Creating Matrix & Conditional Formatting
06:09
Creating Decomposition Tree
02:26
Different Cards in Power BI
0/3
Creating KPI Card
03:13
Creating Gauge Card
04:21
Creating Slicer
03:22
Advanced Visualisation Features in Power BI
0/7
Creating DrillDowns & Drill-Throughs
Editing Pages
Creating Buttons & Actions
Creating Bookmarks
Analytics & Forecasting using Time Series Data
Getting Data & Visualisation using R Scripting
Assignment on Advanced Visualization Features
Advanced Visualisations in Power BI
0/2
Creating Animated Bar Plot
02:37
Creating Sunburst Chart
02:34
Python with Power BI
0/4
Setting up Python with Power BI
Transforming Data using Python
Using Python Visualisation in Power BI
Machine Learning in Power BI
Filters in Power BI
0/2
Different Filters in Power BI
04:07
Include & Exclude Operations
02:37
Power Query in Power BI
0/9
Introduction to Power Query
06:11
Groupby & Replace in Power Query
01:52
Merge and Append Operations
02:36
Prefix & Suffix Operations
02:43
Pivot in Power Query
03:51
Editing Rows
Changing Data Types
Creating Conditional Columns
Practice Assignment on Power Query
Advanced Power Query
0/7
Performance: Enable/Disable Load & Refresh Reports
References versus Duplicating
Mathematical Operations
Using Parameters to Dynamically Transform Data
M Formula Language
M Language: Values, Lists & Tables
M Language Functions & More Advanced Functions
Data Models in Power BI
0/5
What is Data Model & Why Data Model?
Create and Edit Relationship
Different Types of Relationships Like One-to-One, One-to-Many, Many-to-One, Many-to-Many
Cross-Filter Directions
Activate and Deactivate Relationships
DAX Expressions in Power BI
0/4
Introduction to DAX Expressions
03:05
Creating DAX Measures
03:06
Creating DAX Columns
03:06
More DAX Expressions
02:52
Advanced DAX Calculations
0/4
Performing CALCULATE, FILTER, ALL, ALLSELECT, ALLEXPECT
Creating YTD, QTD, MTD using DAX
Creating SUMX, Aggregate, COUNT
Assignment on DAX
KPIs & Business Story Telling
0/4
Stay with Empathy, Business Acumen and Identify the Business Requirements
Identify the KPIs
KPIs in Different Industries
How to Select the Right Visualisation
Mini Projects
0/3
Mini Project on Transforming Data
Mini Project on Dashboard using Power BI
Mini Project on Data Models
End-to-End Power BI Job-Ready Dashboard
0/1
End-to-End Power BI Project Demonstration
01:43:44
Power BI Server
0/6
Publishing Power BI Dashboard into Server
06:39
Understanding Power BI Server
Understanding Datasets and Reports
Data Gateway
Getting Quick Insights
Understanding Power BI Mobile App
Row-Level Security
0/5
What is Row-Level Security
Creating Row-Level Security
Row Level Security on Cloud
Dynamic Row-Level Security on Data Models
Assignment on Row-Level Security
MySQL End-to-End
0/2
Data Analysis using MySQL
01:29:40
Different Joins using MySQL
01:22:47
Working on Real-Time Projects under BEPEC
0/3
Power BI Project-1
Power BI Project-2
Power BI Project-3
Introduction to MySQL
0/1
Introduction to MySQL
23:29
Creating Database in MySQL
0/2
Creating Database in MySQL
19:23
Different DDL Commands and Index
07:51
Deep Dive in MySQL Interface
0/1
Deep Dive into MySQL Interface
15:42
Queries in MySQL
0/1
Queries in MySQL
29:03
Clauses in MySQL
0/3
Clauses in MySQL – 1
18:39
Clauses in MySQL – 2
23:31
Clauses in MySQL – 3
31:31
Data Handling with MySQL
0/2
Data Handling with MySQL – 1
41:21
Data Handling with MySQL – 2
41:22
MySQL Aggregation Functions
0/1
Aggregation Functions in MySQL
16:45
Advanced MySQL
0/15
Data Integrity & Referential Integrity
04:39
Data Normalisation
03:04
First & Second Normal Form
07:19
Functional Dependency, Transitive Dependency & 3rd Normal Form
08:48
Boyce Codd Normal Form
09:02
Denormalization
03:48
Temporary Table, CTE, Recursive CTE
10:40
When to Use TT, CTE, R CTE
02:19
SubQuery in MySQL
02:42
Views in MySQL
02:50
Stored Functions
12:13
Stored Procedures
02:59
Triggers in MySQL
04:57
Create Events in MySQL
04:23
Different Functions in MySQL
05:04
Mastering Python[Zero to Hero]
0/16
Python Learning Roadmap
15:14
Introduction to Python
05:25
Basics of Python
03:50
Python Arithmetic Operators
04:44
Python Variables
04:43
Python Data Structures
05:58
Python Control Flow
06:16
Python Functions
03:48
Python Libraries
04:05
Different List Commands
28:21
Conditional Statements
27:14
Loops in Python
User-Defined Functions in Python
Output Operations in Python
Introduction to OOPS
01:17:52
Inheritance, Encapsulation
01:34:40
Real-Time Projects on Data Analytics
0/1
Data Analytics Real-Time Project
Job-Ready Power BI Developer & Advanced MySQL Program
Previous
Next
0% Complete

Need help? Speak with our Career Specialist +919121516181

BEPEC Solutions Pvt.Ltd. majorly a consulting and talent upskilling firm. We apply the right technology to solve business problems with the help of Analytics, AI, Cloud Computing, Edge AI, Explainable AI, ML, DL, RPA, e.t.c. across multiple verticals like BFSI, CPG, Retail, Healthcare, Manufacturing, Telecom, Insurance, e.t.c. 

Products

  • Full Stack Data Analytics
  • Full Stack Data Science
  • Full Stack AI/ML
  • Mastering Deep Learning
  • Mastering Python
  • Mastering SQL & Power BI

Company

Connect

Learn