Duration: 2 days / 16.5 hours
Time: 9am to 6pm
Course Code: CRS-Q-0039318-ICT
TPGateway Course Code: CRS-Q-0039318-ICT
Funding available for this course:
Enhanced Training Support for SMEs | NICF-SF | Post-Secondary Education Scheme (PSEA) | SkillsFuture Credit | SkillsFuture Mid-Career Enhanced Subsidy |
What Will Be Taught For This Excel Power BI Training Course?
The demand for visual analytics in business processes, for quick and informed decision-making, is ever increasing. Data is produced at an incredible rate and the ability to collect and store the data is increasing at a faster rate than the ability to analyse it. Data visualization has proved its worth as a crucial tool in today’s data focused business world. When it becomes difficult to understand complex data, resorting to the uncomplicated language of data visualization helps simplify it to an easy grasp manner.
This two-days instructor-led course provides students with the knowledge and skills analyze data with Power BI. Use Power BI Desktop to connect to data (usually multiple data sources), shape that data (with queries that build insightful, compelling data models), and use that model to create reports (which others can leverage, build upon, and share). Power BI Desktop centralizes, simplifies, and streamlines what can otherwise be a scattered, disconnected, and arduous process of designing and creating business intelligence repositories and reports.
Statement of Attainment (SOA) from SSG
Participants will receive the SOA from SSG upon completion of training and assessment.
Module 1. Identify Self-Service BI Solutions
- Introduction to business intelligence
- Introduction to data analysis
- Introduction to data visualization
- Overview of self-service BI
- Considerations of self-service BI
- Microsoft tools for self-service BI
- Labs
Module 2. Explore Power BI Data
- Using Excel as a Power BI data source
- Using databases as a Power BI data source
- The Power BI service
- Labs
Module 3. Apply Shaping and Combining Data Techniques
- Power BI desktop queries
- Shaping data
- Combining data
- Labs
Module 4. Apply Modelling Data Skillset
- Relationships
- DAX queries
- Calculations and measures
- Labs
Module 5. Develop Interactive Data Visualizations
- Creating Power BI reports
- Managing a Power BI solution
- Labs
Assessment is conducted at the end of the course. Participants must complete and be assessed as competent (Passed) for the award of SOA from SSG.
Assessment Format & Duration (only applicable for learner taking SF grant)
Assessment | Mode | Duration |
Practical Performance | Summative | 60 mins |
Written Assessment | Summative | 30 mins |
Total | 90 mins |
Who Should Attend This Excel Power BI Training?
Business User, Data Analyst or Professional who needs to observe changes in data patterns, understand the performance of their investments and illustrate it through a dashboard.
Pre-requisite
-
Working knowledge of Microsoft Office Excel.
- Participants must be able to perform the following in Excel:
- Create PivotTable
- Create Charts
- Work with formulas such as SUM, AVERAGE, COUNT, MAX, MIN, SUMIF, VLOOKUP, etc.
w/o GST | w GST | |
Course Fee | $1,000 | $1,070 |
Singapore Citizen & PR aged ≥ 21 years | $752.50 | $822.50 |
Singapore Citizen aged ≥ 40 years (SkillsFuture Mid-Career Enhancement Funding) |
$175 | $245 |
w/o GST | w GST | |
Course Fee | $1,000 | $1,070 |
Singapore Citizen & PR aged ≥ 21 years | $752.50 | $822.50 |
Singapore Citizen aged ≥ 40 years (SkillsFuture Mid-Career Enhancement Funding) |
$175 | $245 |
w/o GST | w GST | |
Course Fee | $1,000 | $1,070 |
Singapore Citizen & PR aged ≥ 21 years | $175 | $245 |
Singapore Citizen aged ≥ 40 years (SkillsFuture Mid-Career Enhancement Funding) |
$175 | $245 |
Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.
Please ensure that you have read our Terms and Conditions before submitting the enrolment form.
Please click on the course date to enrol.
- CL: Classroom Learning
- VILT: Virtual Instructor-Led Training
- GTR: Guaranteed To Run
- Sat: Saturday
- Wkn: Weekend