Microsoft Power BI for beginners
This course teaches Power BI from basic to advanced level.
Microsoft Power BI for beginners free download
This course teaches Power BI from basic to advanced level.
Learn Power BI Step by Step:- Beginners
Chapter 1:- What is Power BI?
Chapter 2:- Downloading and installing Power BI.
Chapter 3:- Importing Data in Power BI.
Chapter 4:- Viewing data, fields, designer and model.
Chapter 5:- Table, bar chart and line chart components.
Chapter 6:- Formatting visualization components.
Chapter 7:- Applying Analytics.
Chapter 8:- Auto filtering.
Chapter 9:- Exporting report to PDF
Chapter 10:- Adding a calculated column.
Chapter 11:- Adding a measure column.
Chapter 12:- Adding Pages.
Chapter 13:- Stacked bar chart, Column chart components.
Chapter 14:- Legend, Axis and Values.
Chapter 15:- Apply filters using Power Query Editor.
Chapter 16:- Line Chart, Pie chart, Map and Card Components.
Chapter 17:- Slicer component.
Chapter 18:- Modeling relationship.
Chapter 19:- Publishing and sharing report online.
Chapter 20:- The Market place.
Chapter 21:- Themes.
Chapter 22:- Revising things.
Lab 2:- Connecting SQL Server with Power BI.
Chapter 23:- Downloading and installing SQL Server.
Chapter 24:- Importing CSV file data in to SQL Server.
Chapter 25:- Connecting Power BI with SQL Server.
Chapter 26:- Import and Direct Query options.
Lab 3:- Line, Area, Stacke, API, Gauge and Funnel.
Chapter 27:- Line chart, Area chart and stacked charts.
Chapter 28:- Gauge charts.
Chapter 29:- KPI, Key performance indicators.
Chapter 30:- Funnel Graph.
Lab 4 :- Star Schema and Snow flake design
Chapter 31 :- OLAP and OLTP design.
Chapter 33 :- Fact tables and dimension.
Chapter 34 :- Star schema design.
Chapter 35 :- Stressing Denormalized design.
Chapter 36 :- Redundant data issue.
Chapter 37 :- Snow flake design.
Chapter 38 :- Consuming in Power BI.
Chapter 39 :- SQL Scripts of the lessons.
Lab 5 :- DAX queries
Chapter 38 :- DAX Definition
Chapter 39 :- Cloning a table
Chapter 40 :- Applying filter
Chapter 41 :- SUM and SUMX
Chapter 42 :- FilterContext and RowContext
Chapter 43 :- Calculate :- Changing the context
Chapter 44 :- Akk and AllExcept
Chapter 45 :- SelectColumns
Chapter 46 :- Inner Join, Left Join and Cross Join
Chapter 47 :- Joins with out releationships
Chapter 48 :- Summarize, Applying group by
