SkillsFuture Singapore (SSG)

• Know the purpose and basic functions of the core Power BI components
• Use the Power BI desktop client and web app
• Connect to a data source using either the Power BI desktop client or the web app
• Model data
• Create reports and visualizations

The course is designed to equipped students with the basic skills needed to create visual reports with data analytics using Power BI. Upon course completion, learners will be able to consume and transform data using the Power BI desktop application, create models from raw data sources and configure Dashboards using the Power BI Service.

Module 1: Getting Started
Lessons • An Introduction to Power BI • Working with Power BI Desktop Files • Connecting to Data Sources with Power BI Desktop • Creating a Report with Visualizations • Doing More with Visualizations

Module 2: Working with Data
Lessons • Transforming and Sanitizing Data • Using the Query Editor • Data Modelling • Managing Relationships

Module 3: Working with Reports and Visualizations
Lessons • Managing Report Pages • Changing Report View Options • Working with Visualizations • Adding Static Objects to a Report

Module 4: A Close Look at Visualizations
Lessons • Matrixes, Tables and Charts • Maps • Cards, Gauges and KPIs • Slicers

Module 5: Introduction to the Power BI Web App
Lessons • Getting Started • Connecting to Data Sources with the Power BI Web App • Using Workspaces, Dashboards and Reports • Creating Custom Dashboards • Power BI Web App Features

• Intermediate knowledge of Microsoft Excel and Microsoft Access
• Basic knowledge of Windows OS and web browsers
Suggested Prerequisites:
• Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).