Complete Introduction to Business Data Analysis

Move beyond basic reports and learn data analysis. Learn to easily turn data into information, insight and intelligence
4.3 (165 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,662 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 67
  • Length 4.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

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 are the requirements?

  • An understanding of working with data in Excel
  • Excel 2010, 2013 or 2016

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Section Introduction
Article
Introduction to Data Analysis
Article
02:57

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.

Article

Please download the Sales Data file to complete the activities in the course.

Article

Please download the Employee Master data file to complete the activities in the course.

Section 2: Preparing Data for Analysis
Introduction to Section
Article
2 pages

Overview of the Preparing Data for Analysis section. In this section you will learn the best practices for preparing your data for analysis.

05:31

In this lesson you will learn the best practices for preparing data for analysis.

11:11

In this lesson you will learn to deal with common data problems that may affect your ability to do data analysis.

Article

Please download the completed common data problems data file.

Section 3: Data Analysis - Key Metrics
Key Metrics Introduction Section
Article
02:47

Introduction to creating key metric and key performance indicator calculations.

12:50

Creating key metric and key performance indicator calculations.

07:34

Creating key metric and key performance indicator calculations.

Key Metric Practical Activity
Article
08:21

The completed key metric activity

Section 4: Comparison Analysis
Introduction to Comparison Analysis Section
Article
02:43

Overview of using comparison analysis to create reports and graphs.

12:29

Using comparison analysis to create reports, graphs and tables of data analysis

12:41

Using comparison analysis to create reports, graphs and tables of data analysis

Practical Activity Comparison Analysis
Article
08:34

The completed comparison analysis practical activity

Section 5: Trend Analysis
Introduction to Trend Analysis Section
Article
03:49

In this lesson we provide an overview of the different trend analysis techniques and methods

08:16

Learn to create trend graphs and tables. Learn to apply different trend lines.

09:56

Learn to create trend graphs and tables. Learn to apply different trend lines.

Practical Activity Trend Analysis
Article
04:56

In this lesson we show how to complete the trend analysis practical activity

Section 6: Ranking Analysis
Introduction to Ranking Section
Article
02:05

Overview of ranking analysis and discussion about how to use the techniques

09:25

Ranking analysis including Top 10 analysis techniques

07:24

Ranking analysis including Top 10 analysis techniques

Practical Activity Ranking Analysis
Article
05:11

Completion of the ranking analysis activity

Section 7: Interactive Dashboard Creation
Introduction to Interactive Dashboards Section
Article
00:54

How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings

10:32

How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings

06:29

How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings

Section 8: Variance Analysis
Introduction to Variance Section
Article
Download the Sales Budget Data file
Article
01:59

Introduction and overview of variance analysis concepts

10:06

How to use and create variance analysis calculations and analysis

06:31

How to use and create variance analysis calculations and analysis

Practical Activity Variance Analysis
Article
06:09

How to complete the variance analysis practical analysis activity

Section 9: Contribution Analysis
Introduction to Contribution Analysis Section
Article
03:45

Introduction and explanation of contribution analysis

07:50

How to create different contribution analysis calculations and techniques

06:45

How to create different contribution analysis calculations and techniques

Contribution Analysis Practical Activity
Article
04:37

How to complete the contribution analysis practical activity

Section 10: Frequency Analysis
Frequency Analysis Section
Article
02:45

Introduction and overview of frequency analysis. Learn to easily create frequency histograms and groupings

05:57

Learn to create and analyze age groupings and histograms

07:18

Learn to create and analyze age groupings and histograms

Frequency Analysis Practical Activity
Article
03:57

How to complete the frequency practical activity

Section 11: Correlation Analysis
Correlation Analysis Section
Article
02:51

Introduction and overview of correlation analysis. Explains the principles and concepts of correlation analysis

Correlation Analysis
08:37
Correlation Analysis Practical Activity
Article
Article

Download the world bank data file for the practical activity

11:38

How to complete the correlation practical activity

Section 12: Pareto Analysis
Pareto Analysis Section
Article
01:59

How to perform pareto analysis

04:40

Example of pareto analysis

Section 13: Conclusion
Conclusion
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ian Littlejohn, Excel Business Intelligence and Power BI Trainer

Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and techniques making it easy for learners to harness the power of Excel PivotTables, PivotCharts, PowerPivot, Power Query, PowerView and Power BI.

Ian has been training learners on these powerful technologies for a number of years making it easy for the business user to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.

Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.

Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.

Ready to start learning?
Take This Course