PLEASE CLICK HERE to view upcoming event. Information here is outdated

Data Visualization & Analytics with Power BI -Basic Intermediate Level

24-25 Apr, 2025, Wyndham Grand Bangsar Kuala Lumpur

IPA Training is Registered with

Venue Details

Wyndham Grand Bangsar Kuala Lumpur
No 1, Jalan Pantai Jaya, Tower 3, 59200 Kuala Lumpur, - 59200

https://wyndhamgrand bangsarkl.com.my/


Phone : (603) 2298 1888
Fax : (603) 2298 1999

Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

FOCUSING ON
  • Introduction to Power BI
  • Connect Raw Data to Power BI
  • Transform Complex Raw Data Using Power Query
  • Enable Relational Data Model
  • Introduction to DAX Measures
  • Add Calculated Fields with DAX
  • Introduction to Power BI Visualization
  • Design Interactive Power BI Reports
OBJECTIVE

Power BI is quickly becoming the world’s most powerful self-service business intelligence platform, and an essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch -- all for free.

By the end of the course, not only will you have developed an entire business intelligence tool from the ground up using Power BI, but you will have gained the knowledge and confidence to apply these same concepts to your own Power BI projects.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Building professional-quality business intelligence reports from the ground up.
  2. Blending and transforming raw data into beautiful interactive dashboards.
  3. Designing and implementing the same B.I. tools
    used by professional analysts and data scientists.
  4. Being able to showcase your skills with two full-
    scale course projects (with step-by-step solutions).
  5. Understanding the business intelligence workflow from end-to-end.
WHO SHOULD ATTEND
Personnel who use Microsoft Excel to analyse and prepare management reports, especially Administrative, Operational and Middle Management Staff.
METHODOLOGY
* Guided Learning, group-paced, hands-on
classroom training with real life examples for business applications.
* Challenging exercises are set based on practical applications for typical organizational functions such
as HR, Admin, Production, Sales etc.
DAY 1
9:00

Introduction to Power BI

  • What is Power BI?
  • Power BI Desktop
  • Power BI Screen Interface
10.45

Connect Raw Data to Power BI

  • Intro to the Power BI Query Editor
  • Types of Power BI Data Connectors
  • Modifying, Merging & Appending Queries
  • Connecting to Folders
1:00 Lunch
2:00

Transform Complex Raw Data Using
Power Query

  • Basic Table Transformations
  • Text, Number & Date Tools
  • Index & Conditional Columns
  • Grouping & Aggregating Data
  • Pivoting & Unpivoting
3:45

Enable Relational Data Model

  • Intro to Database Normalization
  • Data (“Fact”) Tables vs. Lookup (“Dimension”) Tables
  • Creating Power BI Table Relationships
  • Relationship Cardinality
  • Connecting Multiple Data Tables
  • Filtering & Cross-Filtering
  • Hiding Fields from the Power BI Report View
5:00 End of Day 1
DAY 2
9:00

Introduction to DAX Measures

  • Intro to Data Analysis Expressions (DAX)
  • Calculated Columns vs. Measures
  • DAX Syntax & Operators
  • Common Power BI Functions
10.45

Add Calculated Fields with DAX

  • Basic Date & Time Formulas
  • Logical & Conditional Statements
  • Text, Math & Stats Functions
  • Joining Data with RELATED
  • CALCULATE, ALL & FILTER Functions
  • DAX Iterators (SUMX, AVERAGEX)
  • Time Intelligence Formulas
1:00 Lunch
2:00

Introduction to Power BI Visualization

  • Intro to the Power BI Report View
  • Adding Basic Charts to Power BI Reports
3:45

Design Interactive Power BI Reports

  • Formatting & Filtering Options
  • Matrix Visuals
  • Slicers & Timelines
  • Cards & KPIs
  • Power BI Map Visuals (Basic, Fill, ArcGIS)
  • Treemaps, Lines, Areas & Gauges
  • Editing Report interactions
  • PREVIEW: Publishing to Power BI Service
5:00 End of Course