Business Analytics with Power Bi

Course Overview

Power BI is a business intelligence tool to bring all of your company data together in one place to visualize as a whole and gain valuable insights. You will learn how to transform your company’s data into rich visuals and organize and Stay in the know, spot trends as they happen, and push your business further. This course will help you analyze your organization data and uncover insights and trends with Power Bi. The course will use Power BI desktop client, with an introduction to the Power BI web app.

Who is this course for?

• Managers, Departmental Heads, Functional Heads, Junior Data Scientists, BI & Reporting Professionals, Analytics Professionals, IT Developers & Testers who are responsible for managing and improving functional operations.
• Anyone who aspires to take up managerial role and be responsible for managing and improving functional operations
• Anyone with a passion to data and data interpretation towards operational excellence

Duration: 2 days

Mode of Delivery: Trainer led virtual session

Prerequisite

• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of relational databases
• Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-total
• Desktop version of Microsoft Power Bi

Learning Outcome

Upon completion of the course, participants will be able to,

• Work with Data to transform, clean data and filter data, use the query editor, model data and manage relationships
• Create an interactive dashboard that allows the stakeholder to filter information
• Work with charts, slicers, tables, matrix and more for the display of information
• Presenting and sharing of the finished dashboard using Power BI Web App

Course Outline

• Day 1
  • Introduction to Power BI
  • Working with Power BI Desktop Files
  • Connecting to Data Sources with Power BI Desktop
  • Creating a Report with Visualizations
  • Doing More with Visualizations
  • Transforming and cleaning Data
  • Using the Query Editor
  • Data Modelling
  • Managing Relationships
  • Managing Report Pages
  • Changing Report View Options
  • Working with Visualizations
  • Adding Static Objects to a Report
• Day 2
  • Creating Custom Dashboards
  • Matrices, Tables, and Charts
  • Maps, Cards, Gauges, and KPIs, Slicers
  • Introduction to the Power BI Web App
  • Connecting to Data Sources with the Power BI Web App
  • Using Workspaces, Dashboards, and Reports

The training comprises Highly participative and interactive group discussions, practical exercise, critique sessions, handouts, course templates and case studies