This certificate course comprehensively covers the use of business analytics using Microsoft Excel. Business analytics and ‘big data’ are fast becoming a critical business differentiator. Bain and Company and the Economist Intelligence Unit/SAS found that companies with the most analytics capabilities are outperforming competitors by wide profit margins. The course covers how to use business analytics to describe, identify and predict behaviour. The course covers how to: (1) define the analytics problem, (2) acquire and blending datasets, (3) clean datasets, (4) use descriptive analytics, (5) use predictive analytics, and (6) present data and findings. The course is highly practical and uses provided sample datasets which students work on to firstly clean data and create a datawarehouse and then undertake a series of analytics tasks.
By choosing to study this ILM Certificate in Leadership and Management Business Analytics course with CMIT, students have 24×7 access to CMIT eLearning for the duration of the course. This includes a comprehensive Course Manual, Videos, Quizzes and personalised Tutor Support. The course documentation for this Business Analytics course is detailed and easy to read. You will also be able to upload assessments online and receive online feedback. You can use the eLearning system from any computer that has internet access.
Entry Requirements / Prerequisites
Students should have a ‘good working knowledge’ of Excel and have access to Excel 2016 or later. A ‘good working knowledge’ is defined as the ability to create sheets, add data, sort cells, use basic formulas, and make tables/charts.
Level 4 certificate or equivalent qualification and/or relevant life and work experiences.
As this is a Level 4 (UK) professional qualification, learners will be expected to reference their assignment work to a high academic standard.
Candidates must be fluent in English with excellent written English Skills to achieve the assessment criteria. Queries on the standard required can be directed to the college.
As this programme is delivered through distance learning, students must be capable of studying on their own initiative.
A basic working knowledge of computers and access to a computer with internet access is required to do the course.
Topics covered in this ILM Business Analytics course
Unit 1: Using business analytics
Business analytics and big data
Categories of analytics
Challenges with implementation
Unit 2: Understanding data
Secondary and primary data sources
Quantitative and qualitative data
Quantitative data types
Cross–sectional and ‘time–series’ data
Unit 3: Preparing datasets
Overview of the business analytics process
The business analytics problem
Dataset acquisition and blending
Unit 4: Exploring, mining and interpreting analytics
Presenting findings, conclusions and recommendations
Unit 5: Understanding the Organisational Culture and Context
What is the organisation environment?
PESTEL case studies
This business analytics course is assessed through a series of tutor-marked assignments.
The course is highly practical and uses provided sample datasets which students work on to firstly clean data and create a datawarehouse and then undertake a series of analytics tasks.
As part of our quality assurance, learner assessment work will be marked by an Internal Assessor, then checked by an Internal Verifier and an External Verifier.