20–21 Oct2 days
- Time
- 09:00 – 17:00
$1,200 nettRegister
Data Analytics · SZCPBI01
Power BI: Transform and Analyse Data
Transform data, connect tables and build an interactive Power BI dashboard in two days.
✓ Beginner level✓ Lunch, snacks and refreshments provided
Course overview
Why learn Power BI?
Power BI is a widely used data-visualisation application and sits well inside the Microsoft ecosystem. In two days you will transform data, create models and build visualisations that help stakeholders make decisions.
Outcomes
- Apply the right Power BI visuals in different business and analytical contexts
- Create features that make a dashboard interactive
- Create calculated columns in data models using DAX formulas
- Create measures in data models using DAX formulas
- Load and transform data using Power Query
- Create relationships between different data tables
This course is suitable for
- Beginners who are new to analytics
- Lifelong learners upgrading their skills in a more data-driven workplace
- People who want to apply data analytics in daily work
Course dates and venue
Upcoming public runs.
Unconfirmed runs may be held at Village Hotel Bugis or Goldhill Plaza. We'll confirm the exact location before class.
5–6 Oct2 days
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$1,200 nettRegister
Course fees and funding
Fees and funding
Course fee: $1,200 nett
The course fee is $1,200 nett. Contact us with any questions about payment or registration.
Course syllabus
Visuals, models and Power Query.
1.Build visuals and dashboard interactivity
- Visuals and their data and styling configurations
- Filters
- Drillthroughs
2.Model data
- DAX formulas
- Measures
- Time intelligence
- Data tables
- Relationships, cardinality and cross-filters
3.Load and transform data
- Power Query
Pre-requisites
Before you attend
- Bring a laptop with unrestricted internet access and Power BI installed
- Good English proficiency (GCE O-Level English B4 and above, or WSQ Workplace Literacy Level 7 and above)
- Basic information and communication technology (ICT) skills
- No programming knowledge required
Course instructor
Who you'll learn from.
Eleanor Chin
Analytics at Yum! Brands | Former analytics at P&G
Training methodology
End-goal driven learning.
Start with the end goal
Every foundation course begins with a practical project, from automating a task to building a simple app.
Learn only what matters
Only the topics that serve the end goal, so every lesson applies.
Verified reviews