Excel for Business Analysts
About This Course
Course Objective
Upon completion of the course, learners will be to design and conduct data studies to drive organisational decisions and insights
Learning Outcomes
• LO1: Learners will be able to gain business Insights with business analytics.
• LO2: Learners will be able to manage data science project and configure data models.
• LO3: Learners will be able to manage organization capacity and run data mining models with statistical techniques.
• LO4: Learners will be able to communicate findings from data science projects and make recommendations.
What You'll Learn
• Business analytics for organizations (K1, A1)
• Exploit business data using business analytics (K2, A2)
Topic 2: Managing Data Science Projects
• CRISP-DM models for managing data science projects (K4, K5, A3)
• Excel data models and mapping your data (K8, A4)
Topic 3: Mining Data with Statistical Methods
• Statistical inference techniques (K9, A5)
• Data mining (K6, K7, A6)
Topic 4: Presenting Data Science Projects Findings
• Communicate the results of data science projects (K3, A7)
• Recommendations and making decisions (K10, A8)
Entry Requirements
Knowledge and Skills
• Able to operate computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
• Positive Learning Attitude
• Enthusiastic Learner
Experience
• Minimum of 1 year of working experience.
• Minimum 18 years old