Power Bi Course Curriculum:
Few of the topics that will be covered in our Power BI Training Classes in Abu Dhabi include the following:
I) Introduction to Power BI
- What is BI
- History of Power BI
- Benefits of Power BI
- Components
- Power BI Desktop – Installation
- Building Blocks
- Demo – Sample Power BI Reports
- Creating a Simple Report
II) Get Data & Transform Data with Power Query
- Get and edit Data – An ETL Tool (Extract, Transform, Load)
- Get data from Excel File
- Get data from CSV File
- Get data from Folder
- Get data from SQL
- Get data from Access
- Get data from Website
- Understanding Power Query Editor
- Load vs Direct Query
- Append Queries
- Merge Queries
- Filtering Rows
- Split Columns based of Delimiter, Merge Columns
- Eliminating Columns
- Fixing Metadata issues
- Creating Custom Column based on the Conditions
- Refresh Queries
- Introduction to M Query Language
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.