Analyzing and Visualizing Data with Power BI

In this training course, you will learn Power BI from beginner level to advance level. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.


The primary audience for this course is BI professionals who need to analyze data utilizing Power BI. Executives and managers who have already very good knowledge of Microsoft Excel or QL Server report creators who are interested in alternative methods of presenting data.

Familiarity with Microsoft Office applications – particularly Excel or SQL

Course Outline

Module 1: Introduction to Self-Service Bi Solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
  • Power BI mobile apps

Module 2: Power BI Data

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • Import data from CSV files
  • Import data from a less structured file

Module 3: Shaping & Combining Data

  • Power BI desktop queries
  • Shaping data [Split/Merge/Extract/Format
  • Merge, joining queries
  • Append, creating a big list
  • Combine Binaries; Looping through files in a folder

Module 4: Modelling Data

  • Pivot, Unpivot
  • Relationships
  • DAX queries [Data Analytical eXpression language]
  • Calculations and measures [Logical / Time
  • Hierarchies
  • Optimizing data models

Module 5: Power BI Desktop Visualization

  • Cross-tabular reports
  • Part-to-Whole reports
  • Relationship reports
  • Trend reports
  • Rank reports
  • Different Bulletin-Chart
  • Slicing and Dicing
  • Drill Down/Up

Module 6: Creating Dashboard

  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization with Power View
  • KPIs
  • Refreshing data

Module 7: Sharing your Work

  • Publish from Power BI Desktop
  • Dashboards in Power BI
  • Share a dashboard from Power BI

Module 8: Power BI mobile app

  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded
  • Debugging code

Module9: Working with Excel PowerPivot

  • Working with Excel Dashboard using Power Pivot Table and Report
  • Working with PowerPivot
  • 10% Early Bird Discount if enrolled on or before 18 June, 2018.
  • 15% Discount on group registration of 4 or more participants
  • 20% Discount on corporate group registration of 8 or more participants

Payment can be made using Debit card/Credit Card/NEFT/Cheque.


Fees : Rs. 15000 + 18% GST

Date : 29-30 June'18

Duration : 2 Days

Location : Mumbai

© 2017 Pragati Software Pvt. Ltd. All Rights Reserved.