Complete Introduction to Business Data Analysis
Stone River eLearning
Summary
Overview
The Complete Introduction to Business Data Analysis teaches you how to apply different methods of data analysis to turn your data into new insight and intelligence.
The ability to ask questions of your data is a powerful competitive advantage, resulting in new income streams, better decision making and improved productivity. A recent McKinsey Consulting report has identified that data analysis is one of the most important skills required in the American economy at the current time.
This course focuses on the following different methods of analysis. During the course you will understand why the form of analysis is important and also provide examples of using the analysis using Excel 2013.
The following methods of analysis are included:
- Comparison Analysis
- Trend Analysis
- Ranking Analysis
- Interactive Dashboards
- Contribution Analysis
- Variance Analysis
- Pareto Analysis
- Frequency Analysis
- Correlations
The Complete Introduction to Business Data Analysis is designed for all business professionals who want to take their ability to turn data into information to the next level. If you are an Excel user then you will want to learn the easy to use techniques that are taught in this course.
This course is presented using Excel 2013. Excel 2010 can be used for the majority of the training exercises. Small parts of the course do use Excel Power Pivot and Power View. Please note that this course does not include any complicated formulas, VBA or macros. The course utilizes drag and drop techniques to create the majority of the different data analysis techniques.
What Will I Learn?
- Transform Data into Insight and Intelligence
- Learn 8 different techniques for data analysis that can be easily implemented in Excel 2010, 2013 and 2016
- Learn to ask the right questions of your data
- Learn data analysis using easy to master drag and drop techniques - no confusing formulas, macros or VBA
- Learn Comparison, Trend and Ranking methods of analysis
- Learn Contribution and Variance methods of analysis
- Learn advanced analysis with Frequency and Pareto analysis
- Learn best practices for data analysis and data presentation
- Learn best practices for dashboards
Description
Class Curriculum
Introduction
Start
Introduction to Business Data Analysis
Preview
Importance of Data Analysis (2:57)
Start
Download the Sales Training Data Source
Start
Download the Employee Master data file
Preparing Data for Analysis
Start
Introduction to Preparing Data for Analysis
Start
Preparing Data for Analysis (5:30)
Start
Dealing with Common Data Problems (11:11)
Start
Common-Data-Problems-Completed
Data Analysis - Key Metrics
Start
Introduction to Key Metrics
Preview
Introduction to Key Metrics (2:47)
Start
Creating Key Metrics (12:50)
Start
Key Metrics with Filters (7:34)
Start
Key Metric Practical Activity
Start
Practical Activity Key Metrics (8:21)
Comparison Analysis
Start
Introduction to Comparison Analysis (2:43)
Start
Comparison Analysis Part 1 (12:29)
Start
Comparison Analysis Part2 (12:41)
Start
Comparison Practical Activity
Start
Practical Activity Comparison (8:34)
Trend Analysis
Start
Introduction to Trend Analysis (3:49)
Start
Trend Analysis Part 1 (8:16)
Preview
Trend Analysis Part 2 (9:56)
Start
Trend Practical Activity
Start
Trend Analysis Practical Activity (4:56)
Ranking Analysis
Start
Introduction to Ranking Analysis (2:05)
Start
Ranking Analysis Part 1 (9:25)
Start
Ranking Analysis Part 2 (7:24)
Start
Ranking Practical Activity
Start
Practical Activity Ranking Analysis (5:11)
Interactive Dashboard Creation
Start
Introduction to Interactive Dashboards (0:54)
Start
Interactive Dashboards 1 (10:32)
Start
Interactive Dashboards 2 (6:29)
Variance Analysis
Start
Intro to Variance Analysis (1:59)
Start
Sales-Data-Budget
Start
Variance Analysis Part 1 (10:06)
Start
Variance Analysis Part 2 (6:31)
Start
Variance Practical Activity
Start
Practical Activity Variance Analysis (6:09)
Contribution Analysis
Start
Intro to Contribution Analysis (3:45)
Start
Contribution Analysis Part 1 (7:50)
Start
Contribution Analysis Part 2 (6:44)
Start
Contribution Practical Activity
Start
Contribution Analysis Practical Activity (4:37)
Frequency Analysis
Start
Intro to Frequency Analysis (2:45)
Start
Frequency Analysis Part 1 (5:57)
Start
Frequency Analysis Part 2 (7:18)
Start
Frequency Practical Activity
Start
Practical Activity Frequency Analysis (3:57)
Correlation Analysis
Start
Intro to Correlation Analysis (2:51)
Start
Correlation Analysis (8:37)
Start
Correlation Practical Activity
Start
Practical Activty Correlation (11:38)
Pareto Analysis
Start
Intro to Pareto Analysis (1:59)
Start
Pareto Analysis (4:40)
Conclusion
Start
Conclusion
Who is this course for?
- All Business people who want to turn data into information
- Excel users who want to take their reporting and analysis to the next level
- Students who want to learn powerful methods of data analysis
Requirements
- An understanding of working with data in Excel
- Excel 2010, 2013 or 2016
Career path
Business Data Analysis
Questions and answers
You mentioned “the American economy” in your description of Complete Introduction to Business Analysis. Is the course also applicable to UK business?
Answer:We have taken that as example, if you understand the concepts , it can be applied anywhere.
This was helpful.Hi there, which courses would you recommend for a beginner in data/business analysis? I have no experience in this field at all but want a career.Tnx
Answer:The course you selected, is the right course to start with. Thanks!
This was helpful.Im interested in Complete Introduction to Business Analysis. My company will pay for it. Please get in touch ASAP to discuss about the invoice details
Answer:Please write to us help@stoneriverelearning
This was helpful.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.