Data Analytics Using Advanced Power BI

This 3-day course really takes a deep dive into advanced level skills. Starting with how the languages of R and M can be used to extend the standard data extraction and transformation capabilities of Power BI.

Participants will then understand complex data modelling scenarios and how Power BI can overcome them. Participants will also learn about several advanced data visualisation techniques that can take their reports and dashboards beyond the basics.

• Architect an up-to-date “Business Intelligence (BI)” solution in their organisation

• Connect any type of data to MS Power BI

• Apply advanced “Extract, Transform, and Load (ETL)” to build data models in MS Power BI

• Select and use specialist ETL tools to support and automate data flows into MS Power BI

• Apply information design concepts to create objective-orientated BI solutions

• Select and execute appropriate visualisations within MS Power BI

• Create a dashboard to explore data and answer queries using MS Power BI

• Run advanced analytics using the DAX language and supporting Python scripts

• Publish tailored and secure BI solutions to stakeholders using MS Power BI

• Distribute and integrate MS Power BI outputs within other tools and platforms

Who Should Attend

This course is designed for professionals engaged in data analytics and reporting, including project managers, analysts, and IT teams.

Prerequisites

• Participants should have attended the course Data Analytics Using Power BI.

Assessment:

As part of the requirement for SkillsFuture Singapore, there will be an assessment conducted at the end of the course. The mode of assessment, which is up to the trainer’s discretion, may be an online quiz, a presentation or based on classroom exercises.

Participants are required to attain a minimum of 75% attendance and pass the associated assessment in order to receive a digital Certificate of Completion issued by Singapore Management University.