Dashboards using Power BI / Excel



Next batch: Feb 2, 2019

Price: CAD 600

Program Overview

Power BI is Excel + Access + VBA + Tableau and can also integrate with tools like SQL, R and Python. Power BI has an amazing ability to automate workflows and hence can do the same task as VBA or advanced excel with much lesser time. Power BI improves the ability of analysts to draw insights from raw data. Power BI has the capability to improve the efficiency in data preparation, data modeling, analysis and reporting and hence organizations – both small and large tend to use this tool to compete better on data. All capabilities of Power BI are also available on the latest versions of Excel. Power BI addresses the limitations of traditional Pivot Tables and hence improve your data analysis capabilities.

Course Coverage

  • Introduction to Power Query
  • Data Cleaning basics
  • Joins
  • Need for Normalization
  • Pivoting
  • Unpivoting
  • Introduction to Data Model
  • Pivot tables and relationships
  • Hierarchy
  • Calculated Columns and Measures
  • Thresholds and Banding
  • KPIs
  • Time Features in Power BI
  • Data Visualization Basics
  • Visualization Elements for different data types
  • Reports and Dashboards with Power BI

Trainer Profile

Srikanth Balasubramanian has about 14 years of experience in training, consulting and software. He is a corporate trainer and an analytics consultant for Fortune 500 and MNC firms like VISA, Credit Suisse, Cisco, Honeywell, NXP, Metro, KPMG, PWC Analytics Advisory,Skoruz& Brillio technologies. He also has an extensive Machine Learning and Data Analytics consulting experience with SME firms like Merit Group and RVS Group, where he helped them set up new lines of business based on analytics despite constrained budgets and resources. He has a strong understanding of issues in analytics in the retail, marketing, and finance areas and hasend-to-end capabilities to link analytical models to business goals and outcomes. He works closely with mid-career and senior folks in MNCs around the globe; USA, Singapore, Hong Kong, and India.

Program Details

  • Saturdays 9 am to 6 pm ET
  • Discounted Fee: CAD 600 plus any applicable taxes
  • Course Duration: 24 hours [ Feb 2, Feb 9 and Feb 16, 2019]
  • Choice is yours – Attend online or in class
  • Address for Classroom Sessions: 5200 Dixie Rd #114, Mississauga, ON L4W 1E3
Ask an expert