Power BI is a business analytics app by Microsoft. It is an interactive visualizations and business intelligence and management app designed for business users to create their own reports and dashboard.

With the app, business users can present their performance and progress updates to management more effectively as compared to simple tables of numbers.

Participants should bring a laptop installed with The latest version of Power BI (https://powerbi.microsoft.com/en-au/desktop/)

Objective

Upon completion of the course, participants will be able to:

• Extract data from multiple sources
• Transform the data
• Connect multiple data sets
• Create and organize multiple visualizations

Outline

You will learn how to create a Business Dashboard through:

1. Orientation to Power BI Interface

• The 3 major component of Power BI: Report, Data and Model

2. Understanding Data

• What is Data?
• 6 types of data you must know
• The type of data relating to business

3. Getting data from different sources

• Excel Files
• CSV
• JSON
• XML
• SQL

4. Transforming Data

• Organizing your data for modelling
• Delete Rows and Columns
• Changing Type of Data
• Filters
• Sorting Data
• Extract Data
• Unpivot Columns
• Merge Queries
• Append Queries

5. Data Modelling

• Connecting multiple sets of data
• Introduction to DAX
• Creating Measures
• Creating Calculated Columns
• Creating a Date Table

6. Common Charts and their intended purposes

• Bar Chart
• Column Chart
• Map Chart
• Pie Chart
• Bubble Chart
• Cards
• Slicers
• Drill downFocus

7. Formatting elements of the charts

• Headers
• Titles
• Background

8. 3 types of filters in Visualization

• Visual filter
• Page filters
• All Pages filter

9. Sharing your reports

• PDF
• PowerPoint
• Interactive Report on the web
• Interactive Report on Mobile

Who should attend

Managers and Executives who have no or minimal experience in data visualization

Testimonial

“Very good tool for management of sales, operations. Useful training for managers.”
Doan Tran, Alfa Laval Singapore Pte Ltd

“Good Level for beginners and well adapted to our various Excel and tool skills. Excellent training in Power BI for Dummies.
Creating interest and nice learning ambience: No one is afraid to ask “silly” questions.
Katarina, Alfa Laval Singapore Pte Ltd

"Activities are followed comfortably"

"Jason is very knowledgeable & shared Methods / Ways to Manipulate data easily in power BI & Excel"

"The interaction with the trainer and coursemate was very good, I am able to share my thought and received constructive advise and feedback"

"The Dashboard and story telling were an eye-opener for me. It will take a lot of practice for me, but it has made me look forward to trying it. "

"There was sufficient time given for adding group discussion and interacting."

"The workbook is detailed, which is helpful to assist when we learn the course. "

"The trainer is friendly and humorous, setting the atmosphere right for the day's topic. His rich experience in the area gives depth and assurance, and his stories have humanized the process of power BI for me. "

"The trainer is patient in guiding us when we are lost."

"Shared many personal experiences."

"I hope to be able to apply the techniques and skills learnt in future presentations. The manual given is comprehensive and sequentially covered in terms of easy reference and text, making it great to follow up later for future reference. Thanks to the trainer for the training session and also for the pace training and example."

"The hands-on allows us practice and will be able to apply to our workspace"

"Well paced and engaging."

"Jason is able to explain clearly and the materials are easy to follow and understand."

"I have learnt about the basic usage of Power BI and how I can use the different visualizations. In addition, as the tool is open to everyone, we are able to practice it.”

"The workbook and materials provide very clear, step-by-step guidance on how to derive the visual we want.“

The trainer was able to get the participants engaged and also able to relate real life scenarios for to better learn about power BI"

"The trainer is very patient, guiding us to use the Power BI knowledge step by step. The course material is very useful for future reference."

"The pace of the training is excellent and the trainer is knowledgeable."

"Although it was stressful with the short time given for the activity (group), but I did learn a lot from it. The workbook is great !"

"Jason is helpful and patient, willing to share his experience and give very good advice."

Speaker Profile

Jason Khoo is an ACTA certified trainer of 20 years. He is a data analytics practitioner of 30 years. During his time of employment, he has worked in Tibs (currently SMRT), MobileOne Ltd, 3M and Virgin Mobile.

During his tenure, he has worked with multiple databases, extracted and downloaded information from systems and run numerous analysis. These analyses spanned across many departments such as Finance, Sales, Marketing, Human Resources, Payroll, etc.

After his employment, he worked as a data analytics consultant for many companies, including Discovery Asia, 3M, Tanah Merah Country Club, Johnson and Johnson Vision Care, National Environmental Agency, Timberland, etc.

His data analytics skills combined with Excel allowed him to deliver many reports to the clients without them having to incur software cost. These reports include Dashboards, Top 10 charts, Risk Analysis, Business Models, KPIs, etc.

As a trainer, he is passionate about transferring his knowledge and imparting his skills to his participants. To day, he has trained thousands in his face to face workshops and had conducted talks for thousands as well.