Power BI Step by Step Tutorial for Beginners & Experienced

Part 1 - What is Power BI, Linked Reports, Power BI Installation, Power Query,

• Chapter 1:- What is Business Intelligence, Power BI and Why Power BI ?
• Chapter 2:- How to Download and Install Power BI
• Chapter 3:- Interface Tour of Power BI Desktop
• Chapter 4:- Connecting to Text/CSV Source File
• Chapter 5:- Power Query Editor : Shaping up CSV Data, Working with Applied Steps, Renaming Data Table, Headers and Removing Blank Rows, Error Data, Replacing Values.
• Chapter 6:- Loading Multiple Data : Excel Data with CSV Data
• Chapter 7:- Creating Duplicating Columns For Creating Relationship in Data Model.
• Chapter 8:- Loading and Formatting Data in Stacked Bar Visual, Creating & Duplicating Pages
• Chapter 9:- Working with Clustered Bar Chart, Pie Chart, Line Chart and Funnel Chart
• Chapter 10:- Working with Slicers, Table, Donut Charts, Maps, Cards
• Chapter 11 :- Understand types of filters, Data Filters, TopN, types of filters in power bi?
• Chapter 12 :- Conditional Formatting in Charts
• Chapter 13 :- Linked Reports (Drill Through Report)
• Chapter 14 :- Working with Bookmarks and Buttons
• Chapter 15 :- Exploring Data with QnA Component
• Chapter 16 :- Connecting SQL Server Database and creating visual
• Chapter 17 :- Connecting Website URL and Creating Visuals
• Chapter 18 :- What is Power Query ?
• Chapter 19 :- Understanding Data Types and Creating Custom Tables
• Chapter 20 :- Keep rows and remove rows
• Chapter 21 :- Removing Special Characters (Rupee Symbol) From Strings (M-Function)
• Chapter 22 :- Basic Calculations (Standard and Scientific), Conditional Columns and Creating Index

Part 2 - Explain Pivot vs Unpivot, Parameters, Merge and append Queries .

• Chapter 23 :- Pivot and Unpivot
• Chapter 24 :- Working with Parameters (Simple, List, Query)
• Chapter 25 :- Merge Queries and Append Queries.

Part 3 - Joins and Join Kind, Optimize PBIX File , Database Normalization.

• Chapter 26 :- Types of Join or Types of Join Kind in Power BI.
• Chapter 27 :- How to optimize PBIX file using Load Feature.
• Chapter 28 :- Understand Database Normalization.

Part 4 - Explain Data Model, OLTP, Star Schema & Snowflake Design. Dax Function

• Chapter 29 :- What is Data Model, Fact Table, Dimension Table?
• Chapter 30 :- OLTP VS OLAP, Star Schema and SnowFlake designs.
• Chapter 31 :- Explain DAX and how to Create Measure Table.
• Chapter 32 :- Calculated Columns vs Calculated Measures.
• Chapter 33 :- Dax Function - SUM vs SUMX.

Part 5 : Maths DAX Function, Logical DAX Function, Text DAX Function in Power BI.

• Chapter 34 :- Maths DAX Functions : MIN, MAX, AVERAGE, DISTINCT, COUNT
• Chapter 35 :- Logical DAX Functions : IF, AND, OR, TRUE, FALSE, ISTEXT, ISERROR, ISBLANK, SWITCH.
• Chapter 36 :- Text DAX Functions : TRIM, LEN, LOWER, UPPER.

Get enrollment to the course - https://www.questpond.com/ordernow.php