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

Jason has a great grasp of the subject matter and more importantly he designed that workshop in such a way that we are able to apply the things learnt for our work. This is my second workshop on PowerBI but Jason has made the content very interesting. Very blessed to have him as my trainer.

All is done well in this training

Allow me to understand Power BI much better, which increased my interest to use Power BI more at work.

Course pace is right as trainer allows time for hands on to better grasp the techniques.

Trainer is knowledgeable, can give ample examples to explain concepts. Is engaging.

Jason Khoo's Profile

Jason Khoo is a Microsoft Certified Trainer (MCT) and an ACTA-certified trainer with over 20 years of training experience. A Microsoft Certified Power BI Data Analyst Associate, he brings more than 30 years of hands-on experience in data analytics and business intelligence. He is also the Author of 4 Amazon books.

His expertise spans a wide range of areas, including Artificial Intelligence (AI), Data Science, Generative AI, Machine Learning, Digitalization, Predictive Analytics, Interactive Dashboard Design, Data Storytelling, and Data Visualization.

He is also highly skilled in developing automated, real-time reports and conducting data and visual analytics using tools such as Microsoft Excel, Power BI, and Tableau.

Throughout his career, Jason has held key roles at organizations such as Tibs (now 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.

Trans-Island Bus Services Ltd (Tibs) –Operations and Revenue Analytics, Passengers Travelling Behaviour Analytics
• Daily tracking of revenue,
• Prepare KPI for LTA,
• Fare revision analysis

Mobile One Asia Ltd (M1) – Financial analytics, Customer Call Usage Analytics
• Full company budgeting and business planning,
• Monthly Analysis,
• KPI reporting

3M – Sales, Cost and Inventory analytics
• Daily and Monthly Sales Forecasting,
• Analysis of Marketing Budget,
• Analysis of Inventory and shipments.
• Cost Analysis for new products (BOM analysis)

Virgin Mobile – Retail, Marketing, Payroll, Admin, IT, Finance Analytics
• Daily KPI reporting,
• Monthly Analysis for Finance, Payroll,
• Developed Fully Automated Business Model driven by KPI