Introduction to Data Analytics with Microsoft Excel

سرفصل های دوره

Master data analysis through Excel with advanced hands on practical training

1. Introduction

1. Get to Know a little about me and my experience

2. Course Overview

1. What Will This Course Cover

2. How to Get an Office 365 Trial for Free

3.1 Introduction to Data Analytics Insight Template.pptx

3.2 practical example dataset final.zip

3. Additional Resources.html

3. What is Data Analytics

1. Is Analytics Right for Me

2. What is Data Analytics

3. Think About Data

4. What is Qualitative v Quantitative Data

5. What is Data Analytics.html

4. Finding Your Data

1. Finding Your Data

2. Finding Your Data.html

5. Analysing Your Data Part 1

1. Mean, Mode, Median & Range of Data

2. Normal v Non-Normal Data

3. What is an Outlier

4. Data We Will Be Using as Part of This Course

5. Data Intimacy

6. Practical Example 1 - Mean, Mode, Median, Range & Normality

7. Practical Activity

8. Mean, Mode, Median, Range & Normality.html

6. Analysing Your Data Part 2

1. What will this section cover

2. Distribution and Histograms

3. Standard Deviation & RSD

4. What is a Run Chart & Data Engineering

5. Practical Example 5 - Creating a Run Chart

6. Practical Example 6 - Create a Control Chart

7. Working with Pivot Tables

1. What will this section cover

2. Why do we use Pivot tables

3. Practical Example 7 - Create a Summary Pivot of Our Claims Data

4. Create a Summary Pivot of Our Claims Data.html

5. Transforming Data with the Pivot Builder

6. Practical Example 8 - Transforming Data

7. Transforming Data.html

8. Using Calculated Fields, Sorting and Filtering

9. Practical Example 9 - Calculated Fields, Sorting and Filtering

10. Calculated Fields, Sorting and Filtering.html

11. Data Engineering 2.0

12. Practical Example 10 - Lets Engineer Some QCD Data

13. Lets Engineer Some QCD Data.html

8. Start Telling Our Analytical Story

1. The Start of Our Story

2. Practical Exercise 11 - Part 1 - Quality Performance

3. Quality Performance.html

4. Practical Exercise 11 - Part 2 - Cost Performance

5. Cost Performance.html

6. Practical Exercise 11 - Part 3 - Performance By Day

7. Performance By Day.html

8. Practical Exercise 11 - Part 4 - PaidDenial Rate Over The Month

9. PaidDenial Rate Over The Month.html

10. Practical Exercise 11 - Part 5 - PaidDenial Rate By Day of Week

11. PaidDenial Rate By Day of the Week.html

12. Practical Exercise 11 - Part 6 - PaidDenial Outcome Impact on Quality

13. PaidDenial Outcome Impact on Quality.html

14. Practical Exercise 11 - Part 7 - PaidDenial Outcome Impact on Costs

15. PaidDenial Outcome Impact on Costs.html

16. Practical Exercise 11 - Part 8 - Volume of Claims by Claim Type

17. Volume of Claims by Claim Type.html

18. Practical Exercise 11 - Part 9 - Claim Type Impact on Quality

19. Claim Type Impact on Quality.html

20. Practical Exercise 11 - Part 10 - Claim Type Impact on PaidDenial Rate

21. Claim Type Impact on PaidDenial Rate.html

22. Practical Exercise 11 - Part 11 - Claim Type Impact on Costs

23. Claims Type Impact on Costs.html

24. Practical Exercise 11 - Part 12 - PaidDenial Rates per Individual

25. PaidDenial Rates per Individual.html

26. Practical Exercise 11 - Part 13 - Quality Performance per Individual

27. Quality Performance per Individual.html

28. Practical Exercise 11 - Part 14 - Cost Performance per Individual

29. Cost Performance per Individual.html

30. Practical Exercise 11 - Part 15 - Individual Delivery Performance By Day of the

31. Individual Delivery Performance By Day of the Week.html

9. Data Visualization

1. Data Visualization

2. Practical Example 12 - Visualizing Our Data

10. Presenting Your Data

1. Bringing the Story Together

2. Practical Example 13 - Lets Pull our Strategic Level Analysis Together

3. Practical Example 14 - Lets Pull our Tactical Level Analysis Together

4. Practical Example 15 - Lets Pull our Operational Level Analysis Together

5. Practical Example 16 - Lets Add Our Key Findings

6. Practical Example 17 - Lets Add Our Recommendations

11. And Thats a Wrap

1. Course Wrap Up

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training