Download Training Directory (2021) Download Now

Jun 2021

Data Visualisation using Microsoft Power BI For Intermediate Users

Course Information

Start Date25 Jun 2021, Friday
End Date25 Jun 2021, Friday
Time9am to 5pm
VenueHoliday Inn Orchard City Centre 11 Cavenagh Rd, Singapore 229616
Fee$680 (excluding GST)
ContactRoshini | 6720 3333 | training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream


Microsoft Power BI is a cloud-based business analytics tool that requires no capital expenditure or infrastructure support regardless of the size of the business. It aims to provide end-users with interactive visualisations and business intelligence capabilities with an easy-to-use interface to create reports and dashboards. Power BI is also capable of seamless integration with existing applications, extracting business intelligence rapidly and accurately, publishing reports securely, and its lack of memory and speed constraints.

This Intermediate Power BI training course builds on the Data Visualisation Using Microsoft Power BI For Beginners course, teaching the advanced dashboard skills you need for building more sophisticated data visualisations. During this course, you will connect to various data sources, shape and combine data, work with reports, and create more sophisticated dashboards.

Course Highlights
  • Transform a poorly formed data source into a clean source
  • Connect to diverse data sources and transform data
  • Create a variety of more advanced visuals
  • Use a variety of DAX functions to create more complex measures, columns and tables
  • Apply custom visuals, animation, and analytics
  • Build more sophisticated Power BI dashboards and reports
  • Perform advanced analysis on Power BI
Target Audience
[IMPORTANT] Prerequisites

Participants are required to bring an internet-enabled laptop and the latest version of Power BI installed. An installation guide will be sent prior to the course date.

Course Outline

Module 1: Quick recap on basics in Power BI

  • How to load data (Excel, CSV)
  • How to load multiple tables
  • Common visualisations used

Module 2: Profiling the initial dataset provided

  • Identify data anomalies
  • Examine data structures
  • Interrogate column properties
  • Interrogate data statistics

Module 3: Clean, transform, and load the data

  • Resolve inconsistencies, unexpected or null values, and data quality issues
  • Identify and create appropriate keys for joins
  • Evaluate and transform column data types
  • Loading unique data types like JSON

Module 4: Create measures by using DAX

  • Use DAX to build complex measures
  • Use CALCULATE to manipulate filters

Module 5: Create reports

  • Add visualization items to reports
  • Choose an appropriate visualization type
  • Format and configure visualizations

Module 6: Enrich reports for usability

  • Configure bookmarks
  • Create custom tooltips
  • Configure navigation for a report
  • configure Sync Slicers
  • Use drillthrough and cross filter

Module 7: Enhance reports to expose insights

  • Apply conditional formatting
  • Apply slicers and filters
  • Perform top N analysis
  • Create reference lines by using Analytics pane
  • personalize visuals

Module 8: Perform advanced analysis

  • Identify outliers
  • Conduct Time Series analysis
  • Use the Key Influencers to explore dimensional variances