III) Data Modelling
- Introduction to Data Modeling
- Creating Relationship between tables
- Building a data model
a. Hiding columns from Reporting View
b. Sorting and Formatting
c. Creating Hierarchies - Create Calculated columns – M Language
- Creating a Date Dimension
IV) Power BI Visualizations
- Introduction to visuals in Power BI
- Create and customize simple visualizations
- Recommended Charts for your data set
- Bar charts and Column Charts
- Line Charts and funnel charts
- Pie Charts and Donut Chart
- Tree Charts and Maps
- Combination charts
- KPI and Card Charts
- Table and Matrix Views
- Buttons and Bookmarks
- Adding Text box, Shapes and Images to Reports
- Creating Stunning Dashboard & Interactive Reports in few clicks
V) Slicing and Dicing
- Filters
- Slicers
- Parameters
- Manage Interaction between objects
- Drill down/Roll Up
VI) Introduction to DAX Language
- Introduction to DAX Functions
- DAX Syntax
- DAX Data Types
- DAX Operators
- DAX Functions
a. Logical Functions
b. Aggregate Functions
c. Date and Time Functions - d. Text Functions
e. Mathematical Functions
f. About Calculate Function
g. Working with Complex DAX Formula
VII) Publishing and Sharing Power BI Reports
- Publish from Power BI Desktop
- Working with Power BI Service
a. On Web
b. On Mobile/Tab - Modify Reports in Power I Service
- Export Data from a Visualization
- Create Dashboards based on Multiple Reports
- Sharing Dashboards and Reports
- Empower Stakeholders to Dazzle their Data Through Sharing
- Refreshing Datasets
- Setup Power BI Gateway to refresh Local Data
- Manage Roles.