img
iTrainingExpert Logo

Power BI Desktop

Description

Microsoft POWER BI DESKTOP is a data visualization tool that can be used to connect information from various sources and compile them into insightful business reports for more effective decision-making.

It's easy to use and doesn't require any expertise in analytics or coding. Power BI Desktop is the main tool for creating reports and dashboards with Power BI. You can create and edit datasets, reports and interactive visualizations while customizing them based on a user's needs.

In this 2-Day session, participants shall receive a comprehensive rundown of the basic functions in POWER BI and POWER QUERY EDITOR for efficient data modelling.

  • Understanding "ETL"; Extract, Transform & Load features for data management and extraction.
  • Knowing how specific data files correlate.
  • Column management and organization skills in Power Query.
  • Detailed dashboard design knowledge.

Data miners, data analysts, business intelligence executives, project managers, revenue managers, finance managers and tech/economist journalists.

Essentially, all personnel whose roles are related to data mining, data analysis, data preparation for end-reports, reconciliations, data cleansing, appending & merging files of multiple systems or creating and publishing dashboards.

Participants should already be proficient in Excel at an INTERMEDIATE level before attending this program.

2 Day 9.00 am - 5.00 pm

9.00AM - 10.30AM
Module 1. 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.30AM - 10.45AM Break

10.45AM - 1.00PM 
Module 2. Using the Query Editor in Power BI

  • Understanding ETL- Extract, Transform & Load
  • Getting data from data sources
  • Merging, Appending, Combining Files
  • Removing rows & columns
  • Replacing values in columns

1.00PM - 2.00PM Lunch

2.00PM - 3.30PM
Module 3. Using the Query Editor in Power BI (Continuation from Module 2.)

  • Pivoting & unpivoting data
  • Formatting data in columns
  • Merging columns
  • Creating customized columns
  • Indexing columns
  • Inserting calculations in columns

3.30PM - 3.45PM Break

3.45PM - 5.00PM
Module 4. 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, treemaps, matrices, KPIs, tables, geographical maps, ArcGIS maps

DAY 2: 9:00AM - 5:00PM

9.00AM - 10.30AM
Module 5. Creating visualizations in Power BI (Continuation from Module 4.)

  • Inserting slicers into the dashboard
  • Using inline hierarchies

10.30AM - 10.45AM Break

10.45AM - 1.00PM
Module 6. Creating visualizations in Power BI (Continuation from Module 5.)

  • Applying filters to dashboards
  • Creating desktop & mobile view layouts
  • Pinning tiles & live pages
  • Viewing & annotating pages in Power BI Mobile

1.00PM - 2.00PM Lunch

2.00PM - 3.30PM 
Module 7. 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.30PM - 3.45PM Break

3.45PM - 5.00PM 
Module 8. Using DAX in Power BI

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

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.

This course covers the installation of Power BI Desktop.

SETUP REQUIREMENTS

Required setup before the training:
1. Participants are to download and install Power BI Desktop on their training machines from https://powerbi.microsoft.com/en-us/getting-started-with-power-bi/.

Please note this is crucial because the participants.
Power BI Desktop is expected to be running on the first day of the training.

2. If the participant has 2 computer monitors, it is advisable that both monitors are used for the training.
The training is data and graphics-intensive; and multiple screens will be opened by the participant during training.

3. Participants will be requested to share their screens on quite a number of online assignments.
The trainer encourages all participants to switch on their cameras to increase the participative rate of the training as the learning is carried out workshop-style.

VINCENT CHIN
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer

Vincent has held financial, continuous improvement, and I.T. positions in the banking, shared services and hospitality industries. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Certified Trainer, Microsoft Office Specialist, and HRD Corp accredited trainer.
His previous roles include being an internal change consultant of a global team, a financial shared-services local head, and a finance regional head. He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA, and process improvement. 

Vincent brings to you his 20+ years of work and training experience in multiple industries where he was in charge of financial and business reengineering functions.
He also develops complex VBA applications regularly in process improvement projects which require his expertise.

One of his highest achievements in the role of Financial Controller for several multinational conglomerates was being able to turn a loss-making company into a profitable one within the year. Vincent has also managed a portfolio of business improvement projects with realized benefits of USD2 million in the prior year in an international bank

Vincent has trained employees from Genting Group, Dell, Motorola, Technip, CIMB, Malakoff, Digi, IBM, Starwood Hotels & Resorts, Petronas ICT, and HSBC.
Vincent adapts a highly practical approach in his training and relates topics he conducts to real-life scenarios. Because he is a no-nonsense person, his solid background in financial operations and process re-engineering experience aid him to create a unique training methodology that mimics closely the solutions that are needed in his participants’ organizations. 

OR 

Other professional trainers in this field. 
To contact Vincent , please call +6012 6869 628, +603 8074 9056, +603 -8082 3707 or info@itrainingexpert.com

Before attending the course, I feel like I want to learn more about Microsoft.
After the course, I feel knowledgeable about Microsoft and the formulas that can be used in Microsoft applications.
The trainer is good, easy to communicate with, and easy to understand._Mohd Shahrul Aman, BMW Credit M Sdn Bhd

I learned a lot during the training session. After the course, I can apply some key features. Mr. Riduan is very knowledgeable in Excel and attentive._Herdawati, Measat Satellite Sdn Bhd

Normal Fee Early Bird Group Fee
Sign up 1 pax Sign up 1 pax Sign up 3 pax or more
Pay 1 day(s) before course starts Pay 14 day(s) before course starts Pay 14 day(s) before course starts
MYR 3490 per pax MYR 2890 per pax MYR 2790 per pax
USD 1030 per pax USD 850 per pax USD 820 per pax

Upon successful completion of this program, you will receive a Certificate of Achievement.

1. Online Payment by Credit card: You can opt to register and pay online with our latest payment integration system through our website.

2. Bank Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.

3. HRD Corp Claimable Courses Skim Bantuan Latihan Khas - Applicable to Malaysian Employer Only

We'd happy to help.
Feel free to talk to us today, however most suitable for you.
Mobile call/ whatsapp: +6012 6869 628 | +6018 2175 123
Office: +603 8074 9056
Email: info@itrainingexpert.com
Website: www.itrainingexpert.com

 

USD 1030

Available Sessions

Session Location Register
29 - 30 May 2025 SELANGOR, Malaysia Register
14 - 15 Jul 2025 SELANGOR, Malaysia Register
30 - 31 Oct 2025 SELANGOR, Malaysia Register

Share to your friends