Microsoft Power BI is considered as the leader amongst the Business Intelligence platforms, way ahead of other industry giants. With seamless integration with other Microsoft products, Power BI gives organizations easy access to connect to various data sources, crunch-numbers, prepare, view, and publish interactive dashboards. Power BI comes with Power Query and Data Modeling capabilities that allow users to clean, reshape, transform and link data from various sources with just a click.

Key takeaways from the Course

  • Learn about the features of Power BI and explore how can it be integrated into the current business intelligence framework

  • Know about some key concepts specific to Power BI (measures and calculated columns) for performing your tasks

  • Create your first interactive business intelligence dashboard with Power BI

  • Storytelling and data security using PowerBI

  • Learn about transforming the data with Power Query in PowerBI

Prerequisites

This course requires no prior knowledge about PowerBI or any other data visualization tool. You will learn all of this, including how PowerBI works, from scratch!
Prerequisites

Course curriculum

  • 1
    Introduction to Business Intelligence and Dashboarding
    • Introduction to the course
    • Course Handout
    • What is Business Intelligence?
    • Components of BI
    • Quiz: Business Intelligence
  • 2
    Getting Started with Power BI
    • What is Power BI?
    • Installation of Power BI
    • Introduction to Power BI Interface
  • 3
    Building your first Power BI Report
    • Understanding the problem statement
    • Importing Data in Power BI
    • Data View and Formatting the Columns
    • Building your first Power BI Report
    • Chart Formatting and Other Visuals
    • Uploading Reports to Power BI Service
    • Quiz: Power BI Basics
  • 4
    Data Modeling in Power BI
    • What is Data Modeling?
    • Relationships and Cardinality
    • Creating Calculated Columns
    • Building Reports with Multiple Tables
  • 5
    Creating Measures using DAX
    • Introduction to Measures
    • Creating our first Measure
    • Using Measures to perform row-by-row operations
    • CALCULATE Function to create Measures
    • Time Intelligence Functions
    • Creating Reports with Measures
    • Quiz: DAX
  • 6
    Filters and Hierarchy in Power BI
    • Filters in Power BI Reports
    • Hierarchy and Drill modes
    • Quiz: Filter and Slicers
  • 7
    Parameters and What-If Analysis in Power BI
    • Introduction to Parameters
    • Parameters in Power BI
  • 8
    Elements of Data Storytelling
    • Data Storytelling
    • Shapes and Buttons
  • 9
    Data Security and Data Refresh
    • Managing Roles and RLS
    • Power BI Gateway for Data Refresh
  • 10
    Data Transformation with Power Query
    • Introduction to Power Query
    • Cleaning Data with Power Query - Part I
    • Cleaning Data with Power Query - Part II
  • 11
    Power Query Editor
    • Case Study 1 - Using Power Query to Manipulate Data
    • Case Study 2 - Transpose, Pivot and Unpivot
    • Case Study 3 - Split Column
  • 12
    Power BI Advanced Capabilities
    • Grouping
    • Forecasting
    • Use of Scatter Plot
    • How to choose Correct Visuals
    • Drill through
    • Conditional Formatting
    • Report Creation
  • 13
    Power BI Cloud
    • Basics of Power BI Cloud
  • 14
    DAX
    • Are my top 5 customers profitable?
    • West vs East
    • Same Period Last Year Analysis
  • 15
    Assessment (Project)
    • Assessment (Project)

Instructor

  • Kaushik Roy Chowdhury

    Senior Data Scientist

    Kaushik Roy Chowdhury

    Kaushik is a data science professional and trainer with more than 7 years of experience in the domain of data-driven consulting and around 3 years of experience disseminating the knowledge through teaching and training.