Short Course

Data Analytics

A Beginner’s Guide To Data Visualization with Power BI

Overview

Designed for individuals with little to no prior experience in data analytics or business intelligence tools, this hands-on course introduces the fundamentals of Microsoft’s powerful data visualization platform, and guides learners through the process of connecting to data sources, transforming data, and creating reports.

Who Should Attend

This course is intended for

  • Professionals from non-technical backgrounds such as marketing, finance, HR, and operations who are seeking to enhance their analytical capabilities.
  • Small business owners, project managers, and anyone looking to make data-driven decisions through clear, interactive reports

Pre-requisites

  • No pre-requisite is required
  • Participants are required to bring their own laptop PC for the practical hands-on portions of the workshop
  • Participants will require access to download and install Power BI Desktop software from Microsoft; Power BI Desktop is a Windows only software and is not available natively on MacOS
Enroll Now

2 Days

16 Hours

Course Level

Beginner

What You Will Learn

Understand the Power BI Ecosystem

Learn what Power BI is, its components, and how it fits into the world of business intelligence and data visualization.

Manage and Prepare Data for Analysis

Discover how to connect to various data sources, clean and transform raw data, and load it into Power BI for analysis.

Model Data Effectively

Gain insights into creating data models, building relationships between tables, and optimizing data structures for accurate reporting.

Explore and Visualize Data

Learn how to build interactive visuals, charts, and dashboards to explore data trends and present insights clearly and effectively.

Use DAX for Calculated Fields and Measures

Get introduced to DAX (Data Analysis Expressions) and understand how to use it to create custom calculations, enhance analysis, and add depth to reports.

Course Outline

Day 1
  • Introduction to Power BI
    • Overview of business intelligence and data visualization concepts
    • What is Power BI and why it matters
    • Components of Power BI: Desktop, Service, and Mobile
    • Understanding the Power BI interface and views
    • Power BI workflow: From data to dashboard
  • Managing and Preparing Data
    • Connecting to different data sources (Excel, CSV, SQL, etc.)
    • Introduction to Power Query Editor
    • Data transformation basics: cleaning and shaping data
    • Merging and appending data
    • Handling missing or inconsistent data
  • Modeling Data
    • Understanding data relationships
    • Creating and managing relationships between tables
    • Data model design best practices
    • Using calculated columns
Day 2
  • Exploring and Visualizing Data
    • Introduction to visualizations
    • Creating charts, tables, and slicers
    • Using filters and drill-down capabilities
    • Designing interactive dashboards
    • Publishing and sharing Power BI reports
  • Introduction to DAX (Data Analysis Expressions)
    • What is DAX and why use it
    • Creating calculated columns vs. measures
    • Basic DAX functions (SUM, AVERAGE, COUNT, etc.)
    • Using logical and text functions in DAX
    • Time intelligence basics in DAX

Trainers Profile

Peter goh

Peter Goh

Peter Goh is an experienced system administrator, developer, trainer, and consultant with over 20 years of expertise in cutting-edge software development. He specializes in creating and deploying customized applications for desktop, web, and mobile platforms. Additionally, he is an ACTA certified trainer.