Complete Introduction to Business Data Analysis

- Description
- Curriculum
- FAQ
- Reviews
If you want to learn simple, effective techniques to create impactful Excel Dashboards and Data Analysis, this course is ideal. Updated with full high definition video, this course teaches you practical skills you can apply in your work environment immediately. Just take a look at the recent comments and reviews!
WHAT STUDENTS ARE SAYING:
-
“Presentation is great! Very practical solutions for everyday business analysis challenges.”
-
“I walked away with a lot much practical knowledge. Really excited to apply this knowledge in my work. I have taken other courses from Ian and never disappointed.”
-
“One of the best courses I have taken on Udemy!!! Very easy to understand, not long and drawn out and focuses on what is relevant in the work place. Will definitely recommend it to my team.”
-
“Really enjoyed the course, so many practical tips, which are easily explained. Thanks”
ABOUT THE TRAINER
In this course, you will learn the BEST techniques and tools for turning data into MEANINGFUL analysis using Excel
This course is lead by Ian Littlejohn – an international trainer, consultant and data analyst with over 200 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5.
**** Life-time access to course materials and practice activities. ****
ABOUT THE COURSE
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.
During the course you will understand why the form of analysis is important and also provide examples of analysis using Excel.
The following methods of analysis are included:
-
Key Metrics
-
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 in Office 365. However, the course is also suitable for:
-
Excel 2013
-
Excel 2016
-
Excel 2019
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.
-
1Introduction to Business Data AnalysisVideo lesson
In this lesson we discuss the overview of the course and also review the different types of data analysis that you will learn in this course.
-
2Introduction to Data AnalysisText lesson
-
3About the CourseVideo lesson
-
4Download the Training Data FilesText lesson
Please download the training data files to complete the activities in the course.
-
5Introduction to Data PreparationVideo lesson
-
6Introduction to Preparing for Data AnalysisText lesson
-
7Preparing Data for AnalysisVideo lesson
In this lesson you will learn the best practices for preparing data for analysis.
-
8Common Data ProblemsVideo lesson
In this lesson you will learn to deal with common data problems that may affect your ability to do data analysis.
-
9Introduction to Key MetricsVideo lesson
-
10Introduction to Key Metrics AnalysisText lesson
-
11Creating Key Metric Calculations - Part 1Video lesson
Creating key metric and key performance indicator calculations.
-
12Creating Key Metric Calculations - Part 2Video lesson
Creating key metric and key performance indicator calculations.
-
13Key Metric Practical ActivityText lesson
-
14Key Metrics Practical ActivityVideo lesson
The completed key metric activity
-
15Introduction to Comparison AnalysisVideo lesson
Overview of using comparison analysis to create reports and graphs.
-
16Comparison Analysis - Part 1Video lesson
Using comparison analysis to create reports, graphs and tables of data analysis
-
17Comparison Analysis - Part 2Video lesson
Using comparison analysis to create reports, graphs and tables of data analysis
-
18Practical Activity Comparison AnalysisText lesson
-
19Comparison Analysis Practical ActivityVideo lesson
The completed comparison analysis practical activity
-
20Introduction to Trend AnalysisVideo lesson
In this lesson we provide an overview of the different trend analysis techniques and methods
-
21Trend Analysis - Part 1Video lesson
Learn to create trend graphs and tables. Learn to apply different trend lines.
-
22Trend Analysis - Part 2Video lesson
Learn to create trend graphs and tables. Learn to apply different trend lines.
-
23Practical Activity Trend AnalysisText lesson
-
24Trend Analysis Practical ActivityVideo lesson
In this lesson we show how to complete the trend analysis practical activity
-
25Introduction to Ranking AnalysisVideo lesson
Overview of ranking analysis and discussion about how to use the techniques
-
26Ranking Analysis - Part 1Video lesson
Ranking analysis including Top 10 analysis techniques
-
27Ranking Analysis - Part 2Video lesson
Ranking analysis including Top 10 analysis techniques
-
28Practical Activity Ranking AnalysisText lesson
-
29Practical Activity Ranking AnalysisVideo lesson
Completion of the ranking analysis activity
-
30Introduction to Interactive DashboardsVideo lesson
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
-
31Interactive Dashboards - Part 1Video lesson
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
-
32Interactive Dashboards - Part 2Video lesson
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
-
33Introduction to Variance AnalysisVideo lesson
Introduction and overview of variance analysis concepts
-
34Download the Sales Budget Data fileText lesson
-
35Variance Analysis - Part 1Video lesson
How to use and create variance analysis calculations and analysis
-
36Variance Analysis - Part 2Video lesson
How to use and create variance analysis calculations and analysis
-
37Practical Activity Variance AnalysisText lesson
-
38Variance Analysis Practical ActivityVideo lesson
How to complete the variance analysis practical analysis activity
-
39Introduction to Contribution AnalysisVideo lesson
Introduction and explanation of contribution analysis
-
40Contribution Analysis - Part 1Video lesson
How to create different contribution analysis calculations and techniques
-
41Contribution Analysis - Part 2Video lesson
How to create different contribution analysis calculations and techniques
-
42Contribution Analysis Practical ActivityText lesson
-
43Contribution Analysis Practical ActivityVideo lesson
How to complete the contribution analysis practical activity
-
44Introduction to Frequency AnalysisVideo lesson
Introduction and overview of frequency analysis. Learn to easily create frequency histograms and groupings
-
45Frequency Analysis - Part 1Video lesson
Learn to create and analyze age groupings and histograms
-
46Frequency Analysis - Part 2Video lesson
Learn to create and analyze age groupings and histograms
-
47Frequency Analysis Practical ActivityText lesson
-
48Frequency Analysis Practical ActivityVideo lesson
How to complete the frequency practical activity
