This in-depth 3-day course is an advanced program following our POWER BI DESKTOP course. POWER BI MOBILE covers the essential functions in the Power BI Desktop with additional modules for Service (Publish dashboard on Browser) and Mobile (View from Mobile Devices).

You will also learn data modelling, visualizations and the Power Query Editor.

• 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 and data visualization knowledge.
• Knowledge on POWER BI MOBILE suite.

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 program.

3 Days 900am- 500pm

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

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
Pivoting & unpivoting data
Formatting data in columns
Merging columns
Creating customized columns
Indexing columns
Inserting calculations in columns

Module 3: 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
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

Module 4: Publishing to the Power BI Service
Publish from Power BI Desktop to Power BI Service
What are Reports, Database & Dashboards?
Sharing dashboards across
Pinning Excel elements to Power BI Service
Generating Quick Insights
Using the Q&A feature
Refreshing data, Personal Gateway, Enterprise Gateway & scheduled refresh

Module 5: 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

Module 6: Using DAX in Power BI
Creating a calculated column
Using Measures
Using New Quick Measures
SUM, CALCULATED, &&, RELATED, FILTER

Module 7: Power BI Mobile
Downloading & setting up the Power BI Mobile
Viewing & annotating pages in Power BI Mobile

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