Loading Events

Start Time :

November 23 @ 9:30 am

Finish Time :

November 25 @ 5:30 pm

Address :

1516, 2nd Floor, Wazir nagar, (Opp – Axis Bank, Defence Colony) Bhishma Pitamah Marg New Delhi, New Delhi 110003 India

Data Modeling & Visualization with Power BI

Event Description

Data Modeling & Visualization

with Power BI

 

Duration: 3 Days

Course Objectives

  • Get an understanding of Power BI and how it works in different scenarios
  • Visualize and analyze data, derive insights from Excel spreadsheets, local databases or external sources like Salesforce Data, Azure SQL Database & SQL server analysis tabular data
  • Create compelling reports, visualizations, derive real-time insights and deploy it on demand
  • Create, share, collaborate and benefit from business information with purpose-built dashboards

 

Target Audience

  • BI and Analytics Professionals
  • MIS and Reporting Professionals
  • Project Managers
  • Mid-level Functional Managers
  • Data Analysts
  • Students

 

Lab Setup

  1. Microsoft Power BI Desktop
  2. Power BI Pro Account (Recommended; License required)
  3. Microsoft Excel 2013 / 16 with Power Pivot & Power Query Add-ins Installed (Optional)
  4. Operating System: Windows 7 / 8 / 10

 

 

 

Program Outline

Day 1

Session 1: Introduction to Power BI

  • Introduction to and need for Power BI
  • Components of Power BI
  • Power BI workflow
  • Introduction to UI Objects
  • Power BI Data Model

:   Practical: Create a simple Power BI Data Model

 

Session 2 & 3: ETL Operations with Power Query

  • Connecting to different sources
  • Merge & Append Queries
  • Recording & Storing Transformations
  • Data Cleaning & Wrangling

:   Practical: Create and modify visuals in Report view

 

Session 4: Writing Functions in M Language

  • Text Functions
  • Date Functions
  • Other Useful Functions
  • DAX or M?

:   Practical: Create date keys in Power Query

 

 

Day 2

Session 1 & 2: Data Modeling in Power BI, Creating and Modifying Relationships

  • Adding tables to the model
  • Creating Relationships – Autodetect and Manual
  • Relationship Cardinality
  • Active vs. Inactive Relationships

:   Practical: Create and modify relationships in the data model

 

Session 3 & 4: DAX Functions for Calculated Columns, Measures and Tables

  • Calculated Columns – DAX vs Power Query
  • Measures
  • Understanding different contexts
  • Using variables in DAX
  • Calculated Tables
  • Date Tables

:   Practical: Add Calculated Columns and Measures to the data model

 

 

Day 3

Session 1 & 2: Creating Power BI Visuals & Reports with Hierarchies, Filters, and Drilldown Reports

  • The Report View
  • Different Visual Types
  • Fields and Visualization Panes
  • Creating & Modifying Visuals
  • Adding Filters
  • Setting Interactions
  • Working with Slicers
  • Custom Visuals & Themes

:   Practical: Create and modify visuals in Report view

:   Practical: Set filters and edit interactions between visuals in Report view

 

Session 3 & 4: Publishing and Sharing Reports

  • Reports vs. Dashboards
  • Publishing a Report
  • Accessing a Published Report
  • Power BI Mobile
  • Sharing a Report – Workspaces, Dashboards, and Apps
  • Row Level Security
  • Schedule Refresh

:   Practical: Publish a Report and create Dashboard tiles in Power BI Service

 

Event location