Data Visualization & Analytics with Power BI -Basic Intermediate Level

28-29 Oct, 2024, Wyndham Grand Bangsar Kuala Lumpur

IPA Training is Registered with

Learn from the Best

Kelvin Ng
Microsoft Office 2016 Master Specialist
Microsoft Certified Trainer

Kelvin Ng Choo Kent is a highly experienced digital arts instructor and master trainer with more than 17 years of experience in the office automation consultation, graphic design, animation and print production arena. He is a graduate of Malaysian Institute of Art (MIA) And holds the distinction of being certified as Adobe Certified Expert (ACE), Microsoft Office 2016 Master Specialist MCP & MCT, Certified practitioner of Neuro-Semantics, Certified practitioner of Neuro-Linguistic programming & Certified practitioner of Hypnosis & Time-Lines.

Microsoft Certification

  • MICROSOFT CERTIFIED TRAINER (MCT) SINCE 2012
  • MICROSOFT OFFICE 2016 MASTER SPECIALIST (MOS)
  • MICROSOFT OFFICE EXCEL 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE WORD 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE POWERPOINT 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE ACCESS 2016 SPECIALIST (MOS)

Professional Qualifications

  • PSMB APPROVED TRAINER
  • CERTIFIED ETHICAL HACKER (CEH)
  • ADOBE CERTIFIED EXPERT (ACE)
  • CERTIFIED PRACTITIONER OF NEURO-SEMANTICS
  • CERTIFIED PRACTITIONER OF NEURO-LINGUISTIC PROGRAMMING
  • CERTIFIED PRACTITIONER OF HYPNOSIS & TIME- LINES


AREA OF EXPERTISE
Office Tools
Microsoft Office Suite (2003, 2007, 2010, 2013, 2016), Adobe Acrobat, Microsoft Visio


Soft Skill
Effective Presentation, Train The Trainer, Microsoft Office Business Application Coaching, Effective Communication


Graphic Design

Adobe Photoshop, Adobe Illustrator, Adobe Indesign, Quarkxpress, Adobe Pagemaker, Corel Draw, Corel Photo Paint

His Clientele



Venue Details

Wyndham Grand Bangsar Kuala Lumpur
1, Jalan Pantai Jaya Tower 3, Kuala Lumpur, 59200 MY,
Phone : +60322981888

https://wyndhamgrand bangsarkl.com.my/

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

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