The main objective of this WSQ Funded SkillsFuture Course on Power BI is to learn how to analyze and visualize data using the Microsoft Power BI Tool easily.

Data Analytics and Visualization With Power BI is a hands-on data analytics course on Microsoft’s BI tools: Power Query, the data model, DAX measures and the Power BI Service. You learn to analyse, visualise and share business reports yourself.

1. Understand Power Query to load data from any source and cleanse it
2. Learn to Create DAX Measures, and how to apply them to your job.
3. Achieve better and faster results than with existing Microsoft tools.
4. Produce valuable KPI metrics for your business that never existed before.
5. Learn the best tips & tricks to solve complex problems & create stunning work.

Logistics

This 2 Day Power BI Data Analytics and Data Visualization Training Course will be held in Singapore. Tea/Coffee, Light Snacks are provided in this training at Fortune Centre, 190 Middle Road. We are located near Rochor, Bencoolen, Bras Basah & Bugis MRT Stations. Classes run from 8:45 AM to 5:45 PM on both days.

UTAP Funding: NTUC Members can utilize UTAP to offset 50% of the remaining fees and learn Power BI at Intellisoft Systems in Singapore*.

Learn Power BI at Intellisoft, Founded by Microsoft Certified Trainer Vinai Prakash

Learn Power BI and visualize data to gain insights into your data immediately. Present data in charts and dashboards over the Power BI service, offering auto-refresh on a daily or hourly basis.

Corporate Power BI Training in Singapore

Corporate training available for 15 or more participants — conducted at your premises or ours. Contact us for a
tailored proposal. We have conducted several Corporate Training Workshops on Microsoft Power BI at MSD, MasterCard, Rolls Royce, NUH, GSK, Shell, NIIT, Manulife, SIA, Sony, SP Power, Samsung, Vodafone and several other government and private organizations in Singapore, Malaysia, Indonesia, Australia, Egypt, Zimbabwe etc.

The Public & Corporate Training workshops have been very well received, and we are the top provider of Corporate Trainers for Power BI, Python, Tableau, SQL, Advanced Excel, Power Point, Power Apps, Power Automate etc. in Singapore.

Day One: Data Visualization Fundamentals With Microsoft Power BI

Introduction 

• When and Why to Use Power BI
• Tour of the Power BI Environment

Loading Data from Hundreds of Data Sources

• Various Methods of Data Loading with Power Query
• Tradeoffs in Loading Techniques
• Best Practices of Loading & Cleaning Data in Power Query, a built-in tool within Microsoft Power BI.
• Create a Data Model of Multiple Tables within Power BI

Introduction to Formulas and DAX using Microsoft Power BI

• Named reference syntax
• Similarities to traditional Excel
• Measures (Calc Fields) vs. Calc Columns
• COUNTROWS() and DISTINCTCOUNT()
• Best practices of using Aggregator & Iterator Functions in Power BI Measure creation

Working with Multiple Tables using Power BI

• Relationships: the End of VLOOKUP?
• Data Tables vs. Lookup Tables
• Multiple Data tables in a single model
• Troubleshooting your “relationship problems”
• Exercises to cement your learning

The Magic of DAX Measures in Microsoft Power BI

• The CALCULATE() function.
• ALL(), percentage of totals, and “cancelling slicers.
• Introduction to Time Intelligence: Date/Calendar Tables
• Running totals – Year to Date,
• Change versus Prior Month/Year Etc.

What-if Analysis using Disconnected Tables and Slicers

Day Two: Advanced Data Visualization With Power BI

Recap and More DAX

• Recap of previous day
• Theory of the Vertipaq engine
• Filter() , Custom Calendars.

DAX Patterns for common problems using Power BI

• Counting things that didn’t happen (eg customers without purchases)
• Custom time intelligence patterns

Power Query

• When to use it and why
• Built-in transformations
• The “M” language
• Using Power Query to solve real-world problems.

Performance

• How to Keep Your Files Small and Your Calculations Fast
• The theory behind compression Sharing and Refreshing Workbooks
• Different Web Hosting options (SharePoint and Power BI)
• Options to refresh workbooks easily
• Creating Advanced Reports and Dashboards with Power BI

Advanced Power BI Visualizations

• A detailed review of what is different about Power BI vs Excel.
• Learn to think differently and use the visualizations available.

Publishing Dashboards to Power BI Services

• A detailed review of the cloud offering, including sharing, Q&A, Analyze in Excel, and publishing Dashboards to Mobile Apps.
• Using Power BI Mobile

Microsoft’s Best Kept Secret Unveiled

• Cube Formulas

General Q&A

93% of 1,949 Power BI learners rated this course 4 or 5 out of 5 (post-course evaluations since 2023).

Use this class to learn Power BI and get your entire team to master Power BI data visualizations, DAX, Power Query & online report publishing.

Intellisoft offers comprehensive Power BI training courses in Singapore to help individuals acquire Power BI certification Singapore. This Best Power BI course Singapore Skillsfuture program covers essential skills such as data visualization, dashboard creation, and data analysis.

Participants can expect hands-on training and practical exercises to enhance their understanding of Power BI tools and techniques. Enrol in this WSQ-funded, SkillsFuture-claimable Power BI course and you will build and publish a working Power BI dashboard in two days.