Power BI Step by Step Tutorial for Beginners and Experienced
Videos with Essential Source Codes
Course Content
- 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
- Chapter 23 :- Pivot and Unpivot
- Chapter 24 :- Working with Parameters (Simple, List, Query)
- Chapter 25 :- Merge Queries and Append Queries.
- 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.
- 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.
- 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.
- Chapter 37 :- Filter DAX Functions - Value, Filter, Calculate & Related.
- Chapter 38 : Explain ALL, ALLExcept
- Chapter 39 : AllSelected Table Joins-Crossjoin, Union, Except & Intersect?
- Chapter 40 :- What are Fields, Numeric Range (What-if) Parameter in Power BI?
- Chapter 41 :- Date and Time : DateAdd vs ParallelPeriod
- Chapter 42 :- What is LookupValue DAX Function in Power BI?
- Chapter 43 :- Date & Time : Datesbetween, DatesinPeriod, DatesQTD, DatesMTD, DatesYTD.
- Chapter 44 :- Understand DAX Variables(VAR).
- Chapter 45 :- Power DAX USERELATIONSHIP, TREATAS.
- Chapter 46 :- TotalMTD vs DatesMTD, TotalQTD vs DatesQTD and TotalYTD vs DatesYTD (DAX).
- Chapter 47 :- Understanding SAMEPERIODLASTYEAR function and SAMEPERIODLASTYEAR vs PARALLELPERIOD (DAX).
- Chapter 48 :- Import Query vs Direct Query in Power BI.
- Chapter 49 :- Understand RELATED and RELATEDTABLE in Power BI Dax.
- Chapter 50 :- Understand DAX TOPN and how to dynamically calculate Top N Values.
- Chapter 51 :- How to rank using DAX RANKX in Power BI?
World-class training and development programs developed by top teachers
Whats Included
- World-class training teacher
- Bench has zero learning curve
- We handle the rest.