POWER BI COURSE

Overview: POWER BI COURSE

I) Introduction to Power BI
1. What is BI
2. History of Power BI
3. Benefits of Power BI
4. Components
5. Power BI Desktop – Installation
6. Building Blocks
7. Demo – Sample Power BI Reports
8. Creating a Simple Report

II) Get Data & Transform Data with Power Query
1. Get and edit Data – An ETL Tool (Extract, Transform, Load)
2. Get data from Excel File
3. Get data from CSV File
4. Get data from Folder
5. Get data from SQL
6. Get data from Access
7. Get data from Website
8. Understanding Power Query Editor
9. Load vs Direct Query
10. Append Queries
11. Merge Queries
12. Filtering Rows
13. Split Columns based of Delimiter, Merge Columns
14. Eliminating Columns
14. Fixing Metadata issues
15. Creating Custom Column based on the Conditions
16. Refresh Queries
17. Introduction to M Query Language

III) Data Modelling
1. Introduction to Data Modeling
2. Creating Relationship between tables
3. Building a data model
a. Hiding columns from Reporting View
b. Sorting and Formatting
c. Creating Hierarchies
4. Create Calculated columns – M Language
5. Creating a Date Dimension
6. Create Robust Data Models Intuitively

IV) Power BI Visualizations
1. Introduction to visuals in Power BI
2. Create and customize simple visualizations
3. Recommended Charts for your data set
4. Bar Charts and Column Charts
5. Line Charts and funnel C harts
6. Pie Charts and Donut Charts
7. Tree Charts and Maps
8. Combination Charts
9. KPI and Card Charts
10. Table and Matrix Views
11. Buttons and Bookmarks
12. Adding Text box, Shapes and Images to Reports
13. Creating Stunning Dashboard & Interactive Reports in few clicks

V) Slicing and Dicing
1. Filters
2. Slicers
3. Parameters
4. Manage Interaction between objects
5. Drill down/Roll Up

VI) Introduction to DAX Language
1. Introduction to DAX Functions
2. DAX Syntax
3. DAX Data Types
4. DAX Operators
5. DAX Functions
a. Logical Functions
b. Aggregate Functions
c. Date and Time Functions
d. Text Functions
e. Mathematical Functions
f. About Calculate Function

VII) Publishing and Sharing Power BI Reports
1. Publish from Power BI Desktop
2. Dazzle Executives with real time Analytics
3. Working with Power BI Service
a. On Web
b. On Mobile/Tab
4. Export Data from a Visualization
5. Sharing Dashboards
6. Empower Stakeholders to Dazzle their Data Through Sharing
7. Refreshing Datasets
8. Manage Roles