Power BI Course: Data Visualisation

Course Outline

Module 1: Introduction to Self-Service BI Solutions

• Lesson 1: Introduction to Business Intelligence
• Lesson 2: Introduction to Data Analysis
• Lesson 3: Introduction to Data Visualization
• Lesson 4: Overview of Self-Service BI
• Lesson 5: Considerations for Self-Service BI
• Lesson 6: Microsoft Tools for Self-Service BI
• Review Questions

Module 2: Explore what Power BI can do for you

• Lesson 1: What can I do with Power BI service as a consumer?
• Lesson 2: View content in Power BI service
• Lesson 3: Explore with dashboards, reports, and apps in Power BI
• Lesson 4: Collaborate and share in Power BI
• Lesson 5: Find and view dashboards and reports
• Lesson 6: Limitation of Power BI
• Review Questions

Module 3: Analyze data with Power BI

• Lesson 1: Filter data with Power BI
• Lesson 2: View your data
• Lesson 3: Ask questions of your data
• Lesson 4: Apply filters to reports
• Review Questions

Module 4: Get started building with Power BI

• Lesson 1: Introduction to building Power BI
• Lesson 2: Use Power BI
• Lesson 3: Building blocks of Power BI
• Lesson 4: Tour and use the Power BI service
• Review Questions

Module 5: Power BI Data

• Lesson 1: Overview of Power BI Desktop
• Lesson 2: Explore Power BI Desktop
• Lesson 3: Connect to data source
• Lesson 4: Get data from Excel
• Lesson 5: Transform data to include in a report
• Lesson 6: Combine data from multiple sources
• Lesson 7: Clean data to include in a report
• Review Questions

Module 6: Modeling Data

• Lesson 1: Introduction to modeling your data
• Lesson 2: How to manage your data relationships
• Lesson 3: Create calculated columns
• Lesson 4: Optimize data models
• Lesson 5: Create calculated measures
• Lesson 6: Create calculated tables
• Lesson 7: Explore time-based data
• Review Questions

Module 7: Interactive Data Visualizations

• Lesson 1: Introduction to visuals in Power BI
• Lesson 2: Create and customize simple visualizations
• Lesson 3: Create slicers
• Lesson 4: Map visualizations
• Lesson 5: Matrices and tables
• Lesson 6: Create scatter, waterfall, and funnel charts
• Lesson 7: Modify colors in charts and visuals
• Lesson 8: Page layout and formatting
• Review Questions

Module 8: Exploring Data in Power BI

• Lesson 1: Introduction to the Power BI service
• Lesson 2: Quick insights in Power BI
• Lesson 3: Create and configure a dashboard
• Lesson 4: Ask questions of your data with natural language
• Lesson 5: Create custom Q&A suggestions
• Lesson 6: Share dashboards with your organization
• Lesson 7: Display visuals and tiles in full screen
• Lesson 8: Edit tile details and add widgets
• Lesson 9: Get more space on your dashboard
• Lab
• Review Questions

Module 9: Publish and share in Power BI

• Lesson 1: Introduction to content packs, security, and groups
• Lesson 2: Publish Power BI Desktop reports
• Lesson 3: Print and export dashboards and reports
• Lesson 4: Introducing Power BI Mobile
• Lesson 5: Create workspaces in Power BI
• Lesson 6: Build apps
• Lesson 7: Use apps
• Lesson 8: Integrate OneDrive for Business with Power BI
• Lesson 9: Publish to web
• Review Questions

Module 10: Introduction to DAX

• Lesson 1: Introduction to DAX
• Lesson 2: DAX calculation types
• Lesson 3: DAX functions
• Lesson 4: Using variables in DAX expressions
• Lesson 5: Table relationships and DAX
• Lesson 6: DAX tables and filtering
• Review Questions

Statement of Attainment & Certification

Participants who fulfil all requirements will receive a Statement of Attainment (SOA) issued by the SkillsFuture Singapore (SSG), and the Avantus Certificate of Attendance for Data Visualisation with Microsoft Power BI.

For other related courses, please visit Design Software or Microsoft Office.