Academy of Data Science

CERTIFICATION PROGRAM
Data Visualization with Power BI

Course Duration

Tools Covered

Learning Mode

We provide

Full Course Content

1. Introduction to Power BI

  1. Overview of BI concepts
  2. Why we need BI?
  3. Introduction to SSBI
  4. SSBI Tools
  5. Why Power BI?
  6. What is Power BI?
  7. Building Blocks of Power BI
  8. Getting started with Power BI Desktop
  9. Get Power BI Tools
  10. Introduction to Tools and Terminology
  11. Dashboard in Minutes
  12. Refreshing Power BI Service Data
  13. Interacting with your Dashboards
  14. Sharing Dashboards and Reports

2. Power BI Desktop

  1. Power BI Desktop
  2. Power BI Dashboards
  3. Power BI Q & A
  4. Extracting data from various sources
  5. Workspaces in Power BI
  6. Data Transformation
  7. Measures and Calculated Columns
  8. Query Editor 

3. Modelling with Power BI

  1. Introduction to Modelling
  2. Modelling Data
  3. Manage Data Relationship
  4. Optimize Data Models
  5. Cardinality and Cross Filtering
  6. Default Summarization & Sort by
  7. Creating Calculated Columns
  8. Creating Measures & Quick Measures

4. Data Analysis Expressions (DAX)

  1. What is DAX?
  2. Data Types in DAX
  3. Calculation Types
  4. Syntax, Functions, Context Options
  5. DAX Functions
  6. Date and Time
  7. Time Intelligence
  8. Information
  9. Logical
  10. Mathematical
  11. Statistical
  12. Text and Aggregate
  13. Measures in DAX

5.Publishing and Sharing

  1. • Introduction and Sharing Options Overview
  2.  Publish from Power BI Desktop and Publish to
    Web
  3.  Share Dashboard with Power BI Service
  4. Workspaces and Apps (Power BI Pro) and
    Content Packs (Power BI Pro)
  5. Print or Save as PDF and Row Level Security
    (Power BI Pro)
  6. Export Data from a Visualization and Publishing
    for Mobile Apps
  7. Export to PowerPoint and Sharing Options
    Summary

6. Refreshing Datasets

  1. Understanding Data Refresh
  2. Personal Gateway (Power BI Pro and 64-bit
    Windows)
  3. Replacing a Dataset and Troubleshooting
    Refreshing