Overview

Power BI is a radically new cloud-based tool for business enterprises which are overwhelmed with the amount of data at hand and until now did not have a cost-effective tool to extract insights from it. Power BI is a suite of interactive data visualisation business analytics tools that deliver insights throughout your organisation. You can use Power BI to connect to hundreds of data sources, simplify data preparation, and drive ad hoc analysis. It is also a collection of data connectors, apps, and software services, which are used to get data from different source, transforms data, and produce beautiful reports.

Course Methodology

Clear explanation of theories coupled with hands-on exercises for a firm grasp of Power BI through:

  • Practical Examples
  • Case Studies
  • Short Exercises
  • Group Discussions

Who Should Attend

Clear explanation of theories coupled with hands-on exercises for a firm grasp of Power BI through:

  • Directors
  • General Managers
  • Finance Managers
  • Business Analysts
  • BI Professionals
  • Sales Managers
  • HR Managers
  • Data Analytics Managers
  • Business Owners
  • Anyone who deals with business, management and financial reporting

Course Curriculum

Power BI Visualisation - Project 1 - Analysing data

  • Download & Install Power BI Desktop
  • Sign up as individual (Need official Email ID)
  • Understanding Power BI Dashboard
  • Importing data in Power BI
  • Sample Dashboard
  • Creating Interactive Slicer
  • Create Pie & Donut Chart
  • Adding Cards (showing most important thing in the report)
  • How to create Horizontal Bar Chart with Filter Option of Top 5
  • Creating Target Line in a Column Chart
  • Tables in Power BI reports and Dashboard
  • Conditional Formatting with Icon
  • Tree Maps in Power BI
  • Understanding how visuals interact in a Power BI report (Edit Interaction)

Data Preparation using Power Query

  • How to download Power Query add-in for Excel 2010-2013 – (In 2016 it’s by Default)
  • How to access Power Query and how does it look like?
  • How to change Data Type & Why is it important?
  • How to Remove Columns and then bring it back?
  • What is “Use First Row as Headers”?
  • How to Remove Duplicate or Blank Rows?
  • How to Split Column in 10 different ways
  • What is Advanced Editor?
  • How to update Query Source?
  • Power Query is Case Sensitive

Power Query Projects

  • How to analyse a HR Survey data from Google Forms?
  • How to analyse data of Expense Allowance from a CrossTab?

Exploring data

  • Creating Interactive dashboard
  • Ask questions of your data with natural language
  • Create custom Q&A suggestions

Publishing and sharing online

  • Print and export dashboards and reports
  • Manually republish and refresh your data
  • Installing and Viewing Dashboard in Power BI Mobile
  • Publish to web
  • Share dashboards with your organization

Gallery

Course Materials