This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Complete Introduction to Business Data Analysis
Move beyond BASIC reports and learn DATA ANALYSIS. Easily turn data into INSIGHT and INTELLIGENCE with Microsoft Excel
Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P
Transform Data into INSIGHT and INTELLIGENCE using powerful methods of analysis, techniques and tools
Learn data analysis using easy to master drag and drop techniques - NO CONFUSING FORMULAS, macros or VBA
Learn 8 different techniques for DATA ANALYSIS that can be easily implemented in Excel (2010 - Office 365)
LIFE TIME ACCESS to course materials and practice activities from a BEST SELLING Udemy instructor
Learn to ask the RIGHT questions of your data using comparison, trend, ranking, variance, pareto and many other techniques
Learn BEST practices for data analysis and data presentation
Learn BEST practices for the design and setup of INTERACTIVE dashboards
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 320 000 enrollments & 250 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.
Preparing Data for Analysis
-
1
Introduction to Business Data AnalysisIn 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.
-
2
Introduction to Data Analysis -
3
About the Course
-
4
Download the Training Data Files
Please download the training data files to complete the activities in the course.
Data Analysis - Key Metrics
-
5
Introduction to Data Preparation
-
6
Introduction to Preparing for Data Analysis
-
7
Preparing Data for Analysis
In this lesson you will learn the best practices for preparing data for analysis.
-
8
Common Data Problems
In this lesson you will learn to deal with common data problems that may affect your ability to do data analysis.
Comparison Analysis
-
9
Introduction to Key Metrics
-
10
Introduction to Key Metrics Analysis
-
11
Creating Key Metric Calculations - Part 1
Creating key metric and key performance indicator calculations.
-
12
Creating Key Metric Calculations - Part 2
Creating key metric and key performance indicator calculations.
-
13
Key Metric Practical Activity
-
14
Key Metrics Practical Activity
The completed key metric activity
Trend Analysis
-
15
Introduction to Comparison Analysis
Overview of using comparison analysis to create reports and graphs.
-
16
Comparison Analysis - Part 1
Using comparison analysis to create reports, graphs and tables of data analysis
-
17
Comparison Analysis - Part 2
Using comparison analysis to create reports, graphs and tables of data analysis
-
18
Practical Activity Comparison Analysis
-
19
Comparison Analysis Practical Activity
The completed comparison analysis practical activity
Ranking Analysis
-
20
Introduction to Trend Analysis
In this lesson we provide an overview of the different trend analysis techniques and methods
-
21
Trend Analysis - Part 1
Learn to create trend graphs and tables. Learn to apply different trend lines.
-
22
Trend Analysis - Part 2
Learn to create trend graphs and tables. Learn to apply different trend lines.
-
23
Practical Activity Trend Analysis
-
24
Trend Analysis Practical Activity
In this lesson we show how to complete the trend analysis practical activity
Interactive Dashboard Creation
-
25
Introduction to Ranking Analysis
Overview of ranking analysis and discussion about how to use the techniques
-
26
Ranking Analysis - Part 1
Ranking analysis including Top 10 analysis techniques
-
27
Ranking Analysis - Part 2
Ranking analysis including Top 10 analysis techniques
-
28
Practical Activity Ranking Analysis
-
29
Practical Activity Ranking Analysis
Completion of the ranking analysis activity
Variance Analysis
-
30
Introduction to Interactive Dashboards
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
-
31
Interactive Dashboards - Part 1
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
-
32
Interactive Dashboards - Part 2
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
Contribution Analysis
-
33
Introduction to Variance Analysis
Introduction and overview of variance analysis concepts
-
34
Download the Sales Budget Data file
-
35
Variance Analysis - Part 1
How to use and create variance analysis calculations and analysis
-
36
Variance Analysis - Part 2
How to use and create variance analysis calculations and analysis
-
37
Practical Activity Variance Analysis
-
38
Variance Analysis Practical Activity
How to complete the variance analysis practical analysis activity
Frequency Analysis
-
39
Introduction to Contribution Analysis
Introduction and explanation of contribution analysis
-
40
Contribution Analysis - Part 1
How to create different contribution analysis calculations and techniques
-
41
Contribution Analysis - Part 2
How to create different contribution analysis calculations and techniques
-
42
Contribution Analysis Practical Activity
-
43
Contribution Analysis Practical Activity
How to complete the contribution analysis practical activity
Correlation Analysis
-
44
Introduction to Frequency Analysis
Introduction and overview of frequency analysis. Learn to easily create frequency histograms and groupings
-
45
Frequency Analysis - Part 1
Learn to create and analyze age groupings and histograms
-
46
Frequency Analysis - Part 2
Learn to create and analyze age groupings and histograms
-
47
Frequency Analysis Practical Activity
-
48
Frequency Analysis Practical Activity
How to complete the frequency practical activity
Pareto Analysis
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!