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

Business Intelligence With Power BI

29-30 May, 2023, Remote Online Training - Public

IPA Training is Registered with

Venue Details

Remote Online Training - Public


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

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

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

FOCUSING ON
  • Overview on Important Aspects of Power BI
  • Using the Query Editor in Power BI
  • Creating Visualizations in Power BI
  • Data Modelling in Power BI
  • Using DAX in Power BI 
OVERVIEW
This is an in-depth 2-day course covering the important functions in the Power BI Desktop Data Modelling, Visualizations, and the Power Query Editor.
COURSE LEARNING OUTCOMES (CLO)
  1. Learn What Is Data Modelling
  2. Learn The Different Types Of Data One Faces In The Work Environment
  3. Learn How The Mechanics Of Using Power BI To Extract, Transform And Load
WHO SHOULD ATTEND

Data miners, data analysts, business intelligence executives, project managers, revenue managers, finance managers, journalists & those who are performing roles related to data mining, data analysis, data preparation for end-reports, reconciliations, data cleansing, appending & merging files of multiple systems, creating and publishing dashboards and making informed decisions from company data.

This course is suitable for participants who are intermediate Excel users or above. Participants should be already proficient in Excel before attending this course.

METHODOLOGY
Participants work on datasets ranging from conventional data to big data during the 2-day training. They undergo strict step-by-step instruction-led coaching to achieve the intended outcome of each dataset for each of the course modules. 
DAY 1
9:00

OVERVIEW ON IMPORTANT ASPECTS OF POWER BI

  • Understanding the multiple data sources under ‘Get Data’
  • Dashboards, Reports & Datasets in Workspace
  • The Report view, Data view & Relationship view on Power BI Desktop


10.45

USING THE QUERY EDITOR IN POWER BI

  • Understanding ETL- Extract, Transform & Load
  • Getting data from Data Sources
  • Merging, Appending, Combining Files

 

1:00 Lunch
2:00

USING THE QUERY EDITOR IN POWER BI (CONT’D)

  • Removing rows & columns
  • Replacing values in columns
  • Pivoting & unpivoting data
  • Formatting data in columns
  • Merging columns
  • Creating customized columns
  • Indexing columns
  • Inserting calculations in columns

 

5:00 End of Day 1
DAY 2
9:00

CREATING VISUALIZATIONS IN POWER BI

  • Adding visualizations to the Report Canvas
  • Using Data view to sort & format data
  • Designing your dashboard & creating column, bar, pie, line graphs, cards, tree maps, matrices, KPIs, tables, geographical maps, ArcGIS maps
  • Inserting slicers into the dashboard
  • Using inline hierarchies
  • Applying filters to dashboards
  • Creating desktop & mobile view layouts
  • Pinning tiles & live pages
  • Viewing & annotating pages in Power BI Mobile


1:00 Lunch
2:00

DATA MODELLING IN POWER BI

  • Concept of relational files, Data Modelling & the Data Model in Power BI
  • Cardinality, cross-filter direction
  • Understanding & creating Data Relationships

 

3:45

USING DAX IN POWER BI 

  • Creating a calculated column
  • Using Measures
  • Using New Quick Measures
  • SUM, CALCULATED, &&, RELATED, FILTER

 

5:00 End of Course