Complete Introduction to Business Data Analysis Training Course

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

• Lifetime access to the e-learning
• In-depth blended learning
• Brightedge’s course completion certificate
• Highly experienced trainers with live examples

Overview

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.

Outline

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