Effective Data Analysis using Excel
About This Course
1) Apply principles of data modelling and visualization to create data models to identify and predict trends and patterns.
2) Use data science techniques to perform data analysis on data sets.
3) Apply data protection and legal guidelines to support the creation of business insight reports
4) Apply DAX language to summarize data to provide business insights from data source.
5) Apply statistical techniques and formulas to produce analytical dashboards and insight reports.
6) Join multiple tables using unions to extract data analysis aligned to the domain context.
7) Create clean required dataset with functions and formulas to visualize data.
What You'll Learn
Entry Requirements
• Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3.
• Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 3.
• Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 3.
• Learners to have minimum GCE ‘O’ level or ITE certificate education
• Learner should have at least 1 year’s working experience in any industry.
• Be able to operate a computer.