IT07B04: ANALYZING AND VISUALIZING DATA WITH POWER BI (SF)
ANALYZING AND VISUALIZING DATA WITH POWER BI (SF)
Course Duration
Mode of Assessment
Students must complete written question and practical performance assessments during class.
Who Should Attend
- Report Creators
- Data Analysts
- Business Intelligence professionals
What's In It for Me
Self-service BI, an end-user’s ability to analyse data and create complex visual reports without the aid of someone with technical expertise, has been a growing demand in many companies as it drives productivity and efficiency. The course will walk you through the powerful features of Self-service BI using a data analytical tool.
Course Overview
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.
Course Schedule
Next available schedule
Course Objectives
Upon course completion, learners will be able to:
- Perform Power BI desktop data transformation.
- Describe Power BI desktop modelling.
- Create a Power BI desktop visualization.
- Implement the Power BI service.
- Describe how to connect to Excel data.
- Describe how to collaborate with Power BI data.
- Connect directly to data stores.
- Describe the Power BI analytic and visual API. • Describe the Power BI mobile app.
Pre-requisites
Required Prerequisites:
- Familiarity with Microsoft Office applications – particularly Excel.
Suggested Prerequisites:
- Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
- Some exposure to basic programming constructs (such as looping and branching).
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
- Hardware & Software
This course will be conducted as a Virtual Live Class (VLC) via Zoom platform. Participants must own a zoom account and have a laptop or a desktop with “Zoom Client for Meetings” installed. This can be downloaded from https://zoom.us/download
System Requirement |
Must Have: Please ensure that your computer or laptop meets the following requirements.
Good to Have:
Not Recommended: |
Course Outline
Module 1: Get Started with Microsoft Data Analytics
Lessons
- Data Analytics and Microsoft
- Getting Started with Power BI
Module 2: Prepare Data in Power BI
Lessons
- Get data from various data sources
- Optimize performance
- Resolve data errors
Module 3: Clean, Transform, and Load Data in Power BI
Lessons
- Data shaping
- Enhance the data structure
- Data Profiling
Module 4: Design a Data Model in Power BI
Lessons
- Introduction to data modeling
- Working with tables
- Dimensions and Hierarchies
Module 5: Create Model Calculations using DAX in Power BI
Lessons
- Introduction to DAX
- DAX context
- Advanced DAX
Module 6: Optimize Model Performance
Lessons
- Optimze the model for performance
- Optimize DirectQuery Models
- Create and manage Aggregations
Module 7: Create Reports
Lessons
- Design a report
- Enhance the report
Module 8: Create Dashboards
Lessons
- Create a Dashboard
- Real-time Dashboards
- Enhance a Dashboard
Module 9: Create Paginated Reports in Power BI
Lessons
- Paginated report overview
- Create Paginated reports
Certificate Obtained and Conferred by
- Certificate of Completion from NTUC LearningHub
Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from NTUC LearningHub.
- Statement of Attainment (SOA) from SkillsFuture Singapore
After passing the assessment(s), participants will receive a SOA from SkillsFuture Singapore, certifying that they have achieved the following Competency Standard(s):
- ICT-DIT-3006-1.1 Data Visualization
- External Certification
NA
Additional Details
Medium of Instruction: English
Trainer to trainee ratio: 1:20
Mode of Delivery: Virtual Live Class (VLC) via Zoom or Physical class (F2F)
Courseware: Learner’s Resources on Canvas, E-courseware on Microsoft Learn
Price
Course Fee and Government Subsidies |
||||||
|
Individual Sponsored |
Company Sponsored |
||||
Non-SME |
SME |
|||||
Before GST |
After GST |
Before GST |
After GST |
Before GST |
After GST |
|
Full Course Fee (For Foreigners and those not eligible for subsidies) |
$1,800.00 |
$1,962.00 |
$1,800.00 |
$1,962.00 |
$1,800.00 |
$1,962.00 |
For Singapore Citizens aged 39 and below and For all Singapore Permanent Residents (The minimum age for individual sponsored trainees is 21 years) |
$900.00 |
$1,062.00 |
$900.00 |
$1,062.00 |
$540.00 |
$702.00 |
For Singapore Citizens aged 40 years and above |
$540.00 |
$702.00 |
$540.00 |
$702.00 |
$540.00 |
$702.00 |
Funding Eligibility Criteria
Individual Sponsored Trainee |
Company Sponsored Trainee |
|
|
Remarks
Company Sponsored Trainee |
|
SkillsFuture Credit:
PSEA:
|
Absentee Payroll (AP) Funding:
|
Terms & Conditions apply. NTUC LearningHub reserves the right to make changes or improvements to any of the products described in this document without prior notice.
Prices are subject to other LHUB miscellaneous fees.
Batch ID | Course Period | Course Title | Funding Available |
Duration (Hours) |
Session (Hours) |
Venue | Available Seats |
Online Payment |
---|
What Others Also Enrolled In
DATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI
View detail