Data Analytics Using Advanced Power BI
- Analytics & Tech
- Innovation & Business Improvement
This module is conducted in-person.
3 days
Weekdays (9am - 5pm)
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.
Overview
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.
Learning Objectives
- 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
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.
Calculate Programme Fee
Fee Table
COMPANY-SPONSORED | |||
PARTICIPANT PROFILE |
SELF-SPONSORED |
SME |
NON-SME |
Singapore Citizen < 40 years old Permanent Resident LTVP+
|
$981 (After SSG Funding 70%) |
$381 (After SSG Funding 70% |
$981 (After SSG Funding 70%) |
Singapore Citizen ≥ 40 years old |
$381 (After SSG Funding 70% |
$381 (After SSG Funding 70% |
$381 (After SSG Funding 70% |
International Participant |
$3,270 (No Funding) |
$3,270 (No Funding) |
$3,270 (No Funding) |
All prices include 9% GST
Post Secondary Education Account (PSEA)
PSEA can be utilised for subsidised programmes eligible for SkillsFuture Credit support. Click here to find out more.
Self Sponsored
- SkillsFuture Credit
-
Singapore Citizens aged 25 and above may use their SkillsFuture Credits to pay for the course fees. The credits may be used on top of existing course fee funding.
This is only applicable to self-sponsored participants. Application to utilise SkillsFuture Credits can be submitted when making payment for the course via the SMU Academy TMS Portal, and can only be made within 60 days of course start date.
Please click here for more information on the SkillsFuture Credit. For help in submitting an SFC claim, you may wish to refer to our step-by-step guide on claiming SkillsFuture Credits (Individual). - Workfare Skills Support Scheme
-
From 1 July 2023, the Workfare Skills Support (WSS) scheme has been enhanced. Please click here for more details.
Company Sponsored
Enhanced Training Support for SMEs (ETSS)
- Organisation must be registered or incorporated in Singapore
- Employment size of not more than 200 or with annual sales turnover of not more than $100 million
- Trainees must be hired in accordance with the Employment Act and fully sponsored by their employers for the course
- Trainees must be Singapore Citizens or Singapore Permanent Residents
- Trainees must not be a full-time national serviceman
- Trainees will be able to enjoy ETSS funding only if the company's SME's status has been approved. To verify your SME's status, please click here.
Please click here for more information on ETSS.
Absentee Payroll
Companies who sponsor their employees for the course may apply for Absentee Payroll here. For more information, please refer to:
AP Guide (Non-SME Companies)
Declaration Guide (SME Companies)
Intake Information
This module is conducted in-person.
Course | Dates |
---|---|
INTAKE 24 | 13 - 15 Nov 2024 [Registration Closed] |
INTAKE 25 | 8 - 10 Jan 2025 [Open for Registration] |
*Online registration will close 5 calendar days before the course start date