1) Introduction to Power BI
a. What is BI (Business Intelligence)?
B. What is Self-Service BI (Business Intelligence)
C. Business Intelligence Tools
d. What is Power BI and Why Power BI
E. Architecture of Power BI
2) Components of Power BI?
A. Power BI Desktop
b. Power Query Editor
c. Power BI Service
3) Power BI Desktop
a. Overview of Power BI Desktop
b. Data Sources in Power BI Desktop
c. Connecting to a data Sources
d. Types of Connections (Import, Direct Query)
e. Visuals in Power BI
g. Custom Visuals
h. Report Themes
i. Modelling Data
j. New Columns and Measures
k. Cross Filter Direction
4) Power Query Editor
a. Clean and Transform Data
b. Merge and Append Operations
c. Custom, Conditional and Columns from examples
d. Advanced Editor
5) Data Analysis Xpressions
a. Essential Concepts of DAX
b. DAX Syntax
c. Types of DAX Functions
d. Aggregate DAX Functions
e. Logical DAX Functions
f. Date and Time DAX Functions
g. TEXT DAX Functions
h. Filter DAX Functions
i. Time Intelligence DAX Functions
6) Data Visualizations
a. Chart Visuals
b. Table and Matrix Visuals
c. Map Visuals
d. Buttons and Shapes
e. Slicers, Sync Slicers, Filter Pane
f. Page Layout and Formatting
g. Funnel, Scatter, Guage and waterfall charts
h. KPI Visuals
i. Power BI Q&A and Data insights
7) Power BI Service
a. Introduction to Power BI Service
d. Creating Workspaces
c. Workspace Settings and Access
d. Reports, Tiles and Dashboards
e. Creating Apps and giving Permissions
f. Creating Content Packs
g. Copy Reports from one workspace to another
h. Power BI Pro vs Premium
i. Share and Subscribe
8) Power BI Desktop
a. What-if Parameters
b. Variables
c. Bookmarks and Selection Pane
9) Gateways
a. On-premises Data Gateway
b. Configuring Data Gateway
c. Schedule Refresh
10) Final Project based on Sales and Marketing Analytics.