Passionately developing careers since 1958.
Power BI: Data Visualization and Dashboards

Power BI: Data Visualization and Dashboards

Why Attend

Professionals are faced with the challenge of presenting data analysis on a platform where management can easily access, quickly interpret and intelligently use for decision making. Many different platforms are available but certainly Microsoft’s Power BI is one of the most useful and increasingly popular tools. In this course, we will go over several functionalities used in Power BI – Desktop version to create dashboards and present data visually. A powerful tool normally used alongside Power BI is Power Query which is mainly used to get data from external sources, transform it, prepare it for analysis and automate all this process. Typically data is loaded into Power BI using Power Query which will be covered in this course as well.

Associations
Associations
Quick Enquiry Call Me Back
Overview
Course Methodology

Live online course where participants will be able to interact with instructor (video and audio), view slides, collaborate with others, comment on discussions, complete assessments, activities and case studies. 

Course Objectives

By the end of the course, participants will be able to:

  • Understand features and capabilities of Power BI
  • Edit and transform data imported from various sources and file types using Power Query
  • Develop dynamic data visuals and dashboards using Power BI Desktop version
  • Automate data reporting and dashboarding using Power BI
Target Audience

Business professionals, business analysts, data analysts, research analysts, finance professionals, marketing and sales professionals, HR professionals, IT professionals, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art data analysis techniques to their daily business reporting and decision making.

Target Competencies
  • Creating dashboards
  • Reporting, analysis and visualization
  • Power BI Desktop Version
  • Power Query
Note

This is a hands-on training course. Participants are required to use their computers and download Power BI Desktop version.

Course Outline
  • Get and transform – Power Query
    • Get data from Excel
    • Get data from TXT or CSV files
    • Get data from web
    • Get data from folder
    • Transformation
      • Pivoting and unpivoting
      • Filtering
      • Sorting
      • Adding/removing columns
      • Adding conditional columns
  • Data visualization – Power BI
    • Power BI report view
      • Visuals
      • Fields
      • Basic charts
      • Formatting options
      • Filtering
      • Matrix visuals
      • Slicers and timelines
      • Cards
      • Q&A
      • Maps
      • Tooltip
      • Drill through
      • Bookmarks
  • Working with Data Models and DAX measures
    • Explicit and Implicit measures
    • Creating relationships between tables
    • CALCULATE and RELATED functions
    • Iterative functions e.g. SUMX, COUNTX, AVERAGEX
Schedule & Fees
HAVE A QUESTION?