Introduction to Data Analysis using Excel and Power BI
Funding Validity Period
25 April 2023
-
24 April 2027
Course Overview
Skills Acquired
By the end of this course, learners will be able to:
- Apply Excel functions and formulas to create statistical techniques like mean, median and regression analysis.
- Identify various trends and patterns from data sets using techniques for statistical analysis.
- Apply Statistical Functions for Data Analysis
- Identify Data Requirement with Stakeholder for Further Analysis
Learning Modules
Learning Unit 1 – Understand Data Analysis Process and Using Functions for Statistical Analysis
- What is Data Analysis
- Benefits of Data Analytics
- The Data Analysis Cycle
- Data Protection Laws and Data Anonymity
- The 4 Types of Data Analysis
- The Types of Data
- What are Statistics?
- The Statistical Functions in Excel
- Importing Data from Different Data Sources into Excel
- Using Functions to Prepare Data for Statistical Analysis
- Creating interactive dashboards to illustrate patterns and trends
- Introduction to Power BI Desktop
- Navigating around Power BI
- Creating statistical visuals
- Creating conditional formatting to highlight patterns
- Creating trendlines and slicers
- Introduction to basic DAX function and formulas
- Creating KPIs, Scorecards, Gauge visualisation
- Publishing Power BI reports to Power BI Analysis Services
Who is this course for
This training is relevant to PMETs who are new to data analysis and is keen to expand their knowledge of Excel to include the use of data analysis functions and dashboards as well as apply data visualization tools for interactive data
Academic prerequisites
- Learners must be able to read, write, speak and listen to English at secondary school level
- Learners to have minimum GCE ‘O’ level or ITE certificate education
- Learners must be able to operate a personal computer, use keyboard and mouse
- Learners must have basic Excel knowledge
Course Fees
| Fees | Small Medium Enterprises (SMEs) | Non Small Medium Enterprises | Singaporean Employees aged 40 years and above |
|---|---|---|---|
| Full Fee | $580.00 | $580.00 | $580.00 |
| 9% GST (on full course fee) | $52.20 | $52.20 | $52.20 |
| Funding Amount | $406.00 (70% off course fee) | $290.00 (50% off course fee) | $406.00 (70% off course fee) |
| Nett Fee Payable (incl. GST) | $226.20 | $342.20 | $226.20 |
- SME: Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
- Non-SME (MCES): Employee is Singaporean aged 40 years and above
- Eligible for Absentee Payroll Funding
- Eligible for SkillsFuture Enterprise Credit (SFEC)
| Fees | Singapore Citizens (40 years and above) | Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) |
|---|---|---|
| Full Fee | $580.00 | $580.00 |
| 9% GST (on full course fee) | $52.20 | $52.20 |
| Funding Amount | $406.00 (70% off course fee) | $290.00 (50% off course fee) |
| Nett Fee Payable (incl. GST) | $226.20 | $342.20 |
- MCES: Singaporean aged 40 years and above
- Normal: Singaporean / PR aged 21 years and above
- Eligible for UTAP funding
- Eligible for SkillsFuture Credit
- Eligible for PSEA Funds
Introduction to Data Analysis using Excel and Power BI
Course Highlight
Course Duration
16 HRS
Training Time
9am - 6pm
Mode of Training
Classroom
Course Reference Number
TGS-2023020424
Claude Cowork for Business Automation
16 HRS Course
Learn More
Build Apps in a Day with Vibe Coding
8 HRS Course
Learn More
Blockchain & Digital Assets for Business
16 HRS Course
Learn More
Smart with Google Workspace and AI
16 HRS Course
Learn More
Systems Thinking for Professional Growth
16 HRS Course
Learn More
Mastering Excel with AI and CoPilot
8 HRS Course
Learn More
Mastering Data Analysis with Python
16 HRS Course
Learn More
Finance for Non-financial Managers
16 HRS Course
Learn More