[2023] Introduction to Data Analytics with Microsoft Excel

• What is Data Analytics & Why is it so Important
• Why Do We Need Analytics? What’s Changed?
• How to Find Appropriate Datasets to work with
• How to Analyse you Data
• The importance of Mean, Mode, Median and Range of Data
• What is the difference between Normal and Non Normal Data
• How to create a histogram
• How to find and remove outliers
• Understand what is a standard deviation and relative standard deviation
• Understand the Difference Between a Run and a Control Chart?
• The basics of working with pivot tables
• Starting to Tell Our Analytical Story
• How to Visualize our data
• How to Present You data and bring the story together

Practical Activities

We will cover the following practical activities in detail through this course:

• Practical Example 1 – Mean, Mode, Median, Range & Normality
• Practical Example 2 – Distribution and Histograms
• Practical Example 3 – Standard Deviation and Relative Standard Deviation
• Practical Example 4 – A Little Data Engineering
• Practical Example 5 – Creating a Run Chart
• Practical Example 6 – Create a Control Chart
• Practical Example 7 – Create a Summary Pivot of Our Claims Data
• Practical Example 8 – Transforming Data
• Practical Example 9 – Calculated Fields, Sorting and Filtering
• Practical Example 10 – Lets Engineer Some QCD Data
• Practical Example 11 – Lets Answer Our Analytical Questions with Pivots
• Practical Example 12 – Visualizing Our Data
• Practical Example 13 – Lets Pull our Strategic Level Analysis Together
• Practical Example 14 – Lets Pull our Tactical Level Analysis Together
• Practical Example 15 – Lets Pull our Operational Level Analysis Together
• Practical Example 16 – Lets Add Our Key Findings
• Practical Example 17 – Lets Add Our Recommendations