Course Overview:
The Full Stack Power BI Course is designed to equip participants with comprehensive skills to leverage the full potential of Microsoft Power BI for end-to-end business intelligence solutions. This course covers a range of topics, from basic concepts to advanced techniques, enabling participants to become proficient in both the technical and business aspects of Power BI development.
Capstone Project: Participants will work on a hands-on capstone project that integrates all the skills learned throughout the course. This project will simulate a real-world scenario where participants can showcase their ability to develop end-to-end Power BI solutions.
Assessment and Certification: Participants will be assessed through quizzes, assignments, and the successful completion of the capstone project. Upon completing the course, participants will receive a certification indicating their proficiency in Full Stack Power BI.
This Full Stack Power BI Course is suitable for business analysts, data analysts, BI professionals, and anyone interested in harnessing the power of Microsoft Power BI for comprehensive business intelligence solutions. The course combines theoretical knowledge with practical applications to ensure participants are well-prepared for real-world challenges in the field of business intelligence.
-
Power Bi Instructed Led Online Course
-
Connecting to various data sources
-
2.1 Load Data from CSV in Power BI and Power BI Cloud Service
-
2.2 How to Connect PBI Desktop and Cloud Service to Microsoft SQL Server
-
2.3 How to invoke a SQL Server Stored Procedure from Power BI
-
2.4 Folder connector: Combining multiple sheets from multiple files in one-go
-
2.5 Combine Multiple csv files in one-go using folder connector in Power BI
-
2.7 Connecting to OneDrive via Power BI
-
2.8 Loading data from Github to Power BI
-
2.9 How to connect to DataVerse using Power BI
-
3.1 Types of Data Storage Modes & Import Mode in Power Bi
-
3.2 Types of Storage Mode - Direct Query in Power BI
-
3.3 Types of Storage Mode - Live Connection in Power BI
-
3.4 Types of Storage Mode - Dual Storage Mode in Power BI
-
3.5 Working with PBDIS file (Live Connection Mode)
-
3.6 What is Rest API , & how to connect to Web Page to bring in data into Power BI
-
QUIZ: Introducing Microsoft Power BI Desktop
-
Start Quiz : Profiling
-
QUIZ: Connecting & Shaping Data with Power BI Desktop
-
-
Power Query Editor
-
4.1 Data Transformation using Power Query Editor
-
5.1 Data Profiling
-
5.2 Transpose , Pivoting and Unpivoting
-
5.3 How to append datasets in Power Query
-
5.4 How to merge datasets in Power Query
-
5.5 Creating Index in Power Query Editor
-
6.0 Enable Load , Include Report Refresh in Power Query Editor
-
7.1 Query Parameter in Power Query
-
7.2 Custom Column Creation
-
7.3 Conditional Column in Power BI
-
7.4 Column from Examples in Power BI
-
7.5 Custom Function in Power BI
-
7.6 Custom Function Assignments
-
8.2 Case Study Converting multiple currencies into single currency
-
8.1 Group by and Fuzzy grouping in Power BI
-
8.3 Row Level Security , Dynamic Row Level & Object Level Security
-
8.4 Incremental Data Refresh in Power BI
-
Parameters in Power BI
-
What is a Data warehousing & Data Lake? Star Schema Snow-flake Schema
-
Power Query Assignment
-
Quiz 3: QUIZ: Cleaning, Transforming & Loading
-
-
Data Modeling
-
9.1 Introduction to Data Modeling in Power BI
-
10.1 Data Modeling | Types of Relationships
-
10.2 Active and Inactive Relationship in Power BI
-
Alternative to inactive relationship in Power BI - Role Playing Dimension
-
Types of cardinalities, Active , & Inactive relationship
-
Cross Filter Direction in Power BI
-
Quiz 4: QUIZ: Data Modeling
-
Data Modeling Assignment
-
QUIZ: Creating Table Relationships & Data Models in Power BI
-
Many to Many Relationship - Covering two Scenarios
-
Many to Many relationship Assignment
-
Custom Date Dimension Table creation using CALENDAR() & CALENDARAUTO() in Power BI
-
-
Data visualization
-
12.1 Data visualization
-
12.3 Types of Chart
-
12.4 Line Chart
-
12.5 Area Chart
-
12.6 Bar & Column Chart
-
12.7 Combo Chart
-
12.8 Pie & Doughnut Chart in Power BI
-
12.9 Scatter plots & Bubble Chart
-
12.10 Matrix Visual
-
13.1 Custom Visual - Heat map
-
13.2 Table Visual
-
13.3 Slicer
-
14.2 Types of Slicer in Power BI
-
13.4 Tree Maps
-
13.5 Ribbon Chart
-
13.6 Funnel Chart
-
13.7 Gauge chart
-
13.8 Waterfall Chart
-
13.9 Key Influencer Visual
-
16.0 Decomposition Tree , Q & A Visual
-
16.2 Drill Through and Cross Report Drill Through in Power BI
-
17.0 Bookmark in Power BI
-
17.2 Custom Tooltip in Power BI
-
18.0 Power BI Interview Questions
-
Start Quiz 6: QUIZ: Creating Reports & Dashboards
-
QUIZ: Visualizing Data with Power BI Reports
-
-
Data Analytics Expresssion (DAX)
-
18.1 Introduction to DAX
-
18.2 Calculated Column in DAX
-
18.3 Calculated Measure in DAX
-
18.4 Data types in DAX
-
18.5 Value Encoding in DAX
-
18.6 Hash Encoding in DAX
-
18.7 Run length Encoding in DAX
-
18.8 Operators and Built-in Functions
-
18.9 Rounding Functions
-
18.10 Information Functions
-
19.1 Logical Function : Switch in DAX
-
19.2 SUM and SUMX
-
19.3 Average Functions in DAX
-
19.4 Variables in DAX
-
19.5 Evaluation Context in DAX
-
19.6 CALCULATE Function in DAX
-
19.7 Evaluation Order of CALCULATE
-
19.8 Filter in DAX
-
19.9 CALCULATETABLE function in DAX
-
19.10 ALL Function in DAX
-
19.11 ALLSELECTED Function in DAX
-
20.0 ALLEXCEPT in DAX
-
20.1 KEEPFILTER & REMOVEFILTER IN DAX
-
20.2 AddColumns() in Power BI
-
20.3 CROSSFILTER in DAX
-
20.4 SELECTEDVALUE in DAX
-
20.5 Summarize, Summarizecolumns functions in DAX & how to use DAX Studio
-
20.6 DATATABLE , UNION, INTERSECT, EXCEPT, & INTERSECT IN DAX
-
20.7 LOOKUPVALUE in DAX
-
20.8 RELATED Function in DAX
-
20.9 RELATEDTABLE in DAX
-
20.10 TREATAS function in DAX
-
20.11 Rankx & TopN in DAX
-
21.1 Dynamic TopN in DAX
-
21.2 Recap of Dynamic TopN in DAX and Disconnected table
-
21.3 DataTable, GenerateSeries, & Table Functions
-
21.4 Time Intelligence Functions
-
21.5 Display last N months Sales Dynamically
-
21.6 Rolling / Moving Average, What-if Parameter in DAX
-
21.7 Capstone Project - Retail Analytics Part - 1
-
21.8 Capstone Project -1 Retail Analytics
-
21.9 Capstone Project - 2
-
21.10 Capstone Project Retail Analytics Part 2
-
2.11 Creating calculation group in tabular editor
-
Report Design in Power BI
-
Quiz 6: QUIZ: DAX Calculations
-
QUIZ: Analyzing Data with DAX Calculations
-
DAX Assignments
-
DAX Best Practices
-
-
Power BI Cloud Service
-
Microsoft SQL Server
-
Installation of SQL Server
-
Installation of SSMS
-
Introduction to Microsoft SQL Server
-
Data Types in SQL Server
-
Built in functions in SQL Server
-
Constraints in SQL Server
-
DDL & DML Hands-on
-
How to create Views in SQL Server
-
SQL Server - Hands on Session Day 2
-
SQL Queries - Hands on Session Day 3
-
How to clone or duplicate a table in SQL Server
-
What is Correlated Subquery and Plain Subquery in SQL Server
-
SET Operators in SQL Server
-
Joins in SQL Server
-
IN Operator in SQL Server
-
Exists Operator in SQL Server
-
How to find and Remove Duplicate Records in SQL
-
How to find the Nth Maximum Salary
-
Grouping sets and rollup functions in SQL Server
-
CUBE function
-
How to Pivot and Unpivot the data
-
Stored Procedure
-
Transaction Control Statements in SQL Server
-
Stored Procedure and Stored Function in SQL Server
-
Common Table Expression (CTE) in SQL Server
-
-
Power BI Interview Question & Answers
-
Power BI Sample preview questions
-
Power BI General Interview Question & Answers
-
Power BI DAX Interview Question & Answers
-
Power BI Power Pivot Interview Question & Answers
-
Power BI Power Query Interview Question & Answers
-
Power BI Power Map Interview Question & Answers
-
Power BI Additional Interview Question & Answers
-
SSIS Interview Question & Answers
-
MySQL Interview Question & Answers
-
-
Power BI Study Materials
-
DA-100 Certification Dumps
-
Data Analytics Using Python
-
Introduction to Python
-
Quiz : Python Basic
-
Quiz 1 : Introduction to Programming
-
Python Study Material
-
Quiz 2: Why Python?
-
Quiz 3: Using Arithmetic Operators in Python
-
String Manipulation in Python
-
Quiz 4: Variables
-
Boolean Data Type in Python
-
Quiz 6 : Numbers and Boolean Values in Python
-
List Data Structure in Python
-
Quiz 7: Python Strings
-
Quiz 8 : Add Comments
-
Quiz 9 : Indexing Elements
-
Tuple in Python
-
Quiz 10 : Structuring with Indentation
-
Dictionary in Python
-
Quiz 11 : Comparison Operators
-
Quiz 10 : The IF Statement
-
Sets and Conditional Programming in Python
-
Quiz 11 : A Note on Boolean Values
-
Conditional Flow and Control Structures
-
Python list
-
Quiz 12 : Lists
-
Quiz 13 : Python Functions
-
Quiz 13 : Functions
-
Functions in Python
-
Quiz 14 : Using Methods
-
Quiz 15 : Dictionaries
-
Numpy (Arrays, & Matrices) in Python
-
Quiz 16 : For Loops
-
Quiz 17 : Lists with the range() Function
-
Introduction to Pandas in Python
-
Quiz 18 : Importing Modules in Python
-
Pandas Assignments
-
Dowload Pandas Assignment Data Sets
-
Data pre processing assignments
-
Data exploration assignments
-
DATASETS
-
Pandas Quiz
-
Numpy Quiz
-
Python Set
-
Python Tuples
-
QUIZ FOR GLOBAL & LOCAL VARIABLES
-
Python Dictionary
-
While & For Loop
-
-
Azure Data Factory Introduction
-
Understanding Adf Basic Object Model
-
Azure Data Factory Deployment
-
Data Transformation