Complete Introduction to Business Data Analysis Training Course

Current Status
Not Enrolled
Get Started

Table of Contents

Today’s businesses are more data-driven which requires more analytical skills. This introduction course is designed to enhance your skills in analyzing various aspects of a business with the help of various analysis in excel. The course covers 8 major types of analysis; comparison analysis, trend analysis, ranking analysis, variance analysis, contribution analysis, frequency analysis, correlation analysis and Pareto analysis.

Key Features

  • 1-year e-learning access


It is mandatory to keep a check on the progress of the business through various aspects. The assessment derived from all these multiple sources is known as Data Analysis. To analyze various aspects of the business, people use a tool such as excel. Introduction to Data analysis is the course to help you understand how to apply the data analysis to your business. In this course, you will learn the use of Excel to deploy various analysis techniques.


  1. Introduction
    Introduction to Business Data Analysis

    1. Importance of Data Analysis
    2. Download the Sales Training Data Source
    3. Download the Employee Master data file
  2. Preparing Data for Analysis
    1. Introduction to Preparing Data for Analysis
    2. Preparing Data for Analysis
    3. Dealing with Common Data Problems
    4. Common-Data-Problems-Completed
  3. Data Analysis – Key Metrics
    1. Introduction to Key Metrics
    2. Introduction to Key Metrics
    3. Creating Key Metrics
    4. Key Metrics with Filters
    5. Key Metric Practical Activity
    6. Practical Activity Key Metrics
  4. Comparison Analysis
    1. Introduction to Comparison Analysis
    2. Comparison Analysis Part 1
    3. Comparison Analysis Part2
    4. Comparison Practical Activity
    5. Practical Activity Comparison
  5. Trend Analysis
    1. Introduction to Trend Analysis
    2. Trend Analysis Part 1
    3. Trend Analysis Part 2
    4. Trend Practical Activity
    5. Trend Analysis Practical Activity
  6. Ranking Analysis
    1. Introduction to Ranking Analysis
    2. Ranking Analysis Part 1
    3. Ranking Analysis Part 2
    4. Ranking Practical Activity
    5. Practical Activity Ranking Analysis
  7. Interactive Dashboard Creation
    1. Introduction to Interactive Dashboards
    2. Interactive Dashboards 1
    3. Interactive Dashboards 2
  8. Variance Analysis
    1. Intro to Variance Analysis
    2. Sales-Data-Budget
    3. Variance Analysis Part 1
    4. Variance Analysis Part 2
    5. Variance Practical Activity
    6. Practical Activity Variance Analysis
  9. Contribution Analysis
    1. Intro to Contribution Analysis
    2. Contribution Analysis Part 1
    3. Contribution Analysis Part 2
    4. Contribution Practical Activity
    5. Contribution Analysis Practical Activity
  10. Frequency Analysis
    1. Intro to Frequency Analysis
    2. Frequency Analysis Part 1
    3. Frequency Analysis Part 2
    4. Frequency Practical Activity
    5. Practical Activity Frequency Analysis
  11. Correlation Analysis
    1. Intro to Correlation Analysis
    2. Correlation Analysis
    3. Correlation Practical Activity
    4. Practical Activty Correlation
  12. Pareto Analysis
    1. Intro to Pareto Analysis
    2. Pareto Analysis
  13. Conclusion
    1. Conclusion

Course Content

Expand All
Lesson Content
0% Complete 0/1 Steps
Lesson Content
0% Complete 0/1 Steps

stay informed!

Subscribe to receive exclusive content and notifications


Share this course

Share on facebook
Share on twitter
Share on linkedin

Keep in touch

Fill in your details and we’ll get back to you in no time.