WSQ EFFECTIVE DATA ANALYSIS USING EXCEL | TGS-2023020187
COURSE OVERVIEW
This course will equip learners with data analysis skills using Excel by applying the various formulae and functions available in Excel as well as using Power Pivot to connect to different and multiple data sources for statistical analysis.
TARGET AUDIENCE (OPERATIONAL, SUPERVISORY & MANAGERIAL)
This training is relevant to PMETs who are aspiring to move away from just creating spreadsheets onto a data analytics scale using a tool that they are relatively familiar with.
COURSE OBJECTIVES
By the end of this course, learners will be able to:
- Apply principles of data modelling and visualization to create data models to identify and predict trends and patterns.
- Use data science techniques to perform data analysis on data sets.
- Apply data protection and legal guidelines to support the creation of business insight reports
- Apply DAX language to summarize data to provide business insights from data source.
- Apply statistical techniques and formulas to produce analytical dashboards and insight reports.
- Join multiple tables using unions to extract data analysis aligned to the domain context.
- Create clean required dataset with functions and formulas to visualize data.
COURSE CONTENT
- UNDERSTANDING DATA MODELLING AND VISUALIZATION TO PERFORM DATA ANALYSIS
- USING EXCEL FUNCTIONS TO APPLY TECHNIQUES ON DATA SETS FOR DATA ANALYSIS
- USING POWER PIVOT FOR DATA MODELLING AND APPLYING DATA INTEGRITY
- USING DAX FOR ANALYSIS TO PROVIDE BUSINESS INSIGHTS
- USING STATISTICAL TECHNIQUES AND DATA ANALYSIS TOOL PAK FOR CREATION OF DASHBOARD REPORTS
- USING EXCEL FUNCTIONS AND QUERIES TO EXTRACT DATA FOR DATA ANALYSIS
- TRANSFORMING DATA FOR DATA ANALYSIS USING EXCEL FUNCTIONS AND FORMULAE
COURE DURATION: 2days (16hrs) | 9am-6pm
LOCATION: 150 Orchard Road (MRT: Somerset Exit via D)
SCHEDULE:
- 08 09 Apr 2024 (Mon & Tue)
- 06 & 07 May 2024 (Mon & Tue)
- 13 & 14 June 2024 (Thu & Fri)
COURSE FEE
COURSE FEE AFTER FUNDING CAN BE CLAIMED THROUGH:
- SkillsFuture Credit: Singaporeans aged 25 and above can use their credits to pay for course fees.
- Eligible Singapore Citizens can use their Skills Future Credit Mid-Career Enhanced Subsidy (MCES), Special funding $500 to offset course fees payable after funding.
- UTAP: NTUC members enjoy 50% unfunded course fee support for up to $500 per year
- Training Commitment Award-$200/year after completing 4 WSQ modules (4 SOAs)
- PSEA (Post-Secondary Education Account): Singaporeans aged 17 to 30 may use their account’s funds for fee payment. (Please Call PSEA Hotline 62600777 to check your balance
- SkillsFuture Enterprise Credits (SFEC): Eligible employers will receive a one-off S$10,000 credit to cover up to 90% of out-of-pocket expenses on qualifying costs for supportable initiatives
ABSENTEE PAYROLL:
Company-sponsored (NON-SME/SME) eligible to apply absentee payroll capped at $4.5 -$7.5/hr
NOTE: All WSS training allowance, WSQ funding, Absentee payroll, regulatory online approval are subject to eligibility (terms & conditions apply)
Course register online by clicking this link: Online Registration
For further enquiries, please contact: 8879 9216 or 91143867
Reach out to us via our other channels: More Contact Channels