The Complete Introduction To Business Data Analysis
Tags: Data Analysis
Move beyond BASIC reports and learn data ANALYSIS. Learn to easily turn data into information, insight and intelligence
Last updated 2022-01-10 | 4.6
- 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
What you'll learn
* Requirements
* An understanding of working with data in Excel* Excel (2010 - Office 365)
* Some examples will require Excel Power Pivot and Power View - which are only available on Windows
* Excel on Mac may not have access to all techniques
Description
If you want to learn simple, effective techniques to create impactful Excel Dashboards and Data Analysis, this course is ideal. Updated in 2021 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!
"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"
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 125 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. ****
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.
Who this course is 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
Course content
13 sections • 53 lectures
Introduction to Business Data Analysis Preview 02:09
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.
Introduction to Data Analysis Preview 00:57
About the Course Preview 01:55
Download the Training Data Files Preview 00:04
Please download the training data files to complete the activities in the course.
Introduction to Data Preparation Preview 01:07
Introduction to Preparing for Data Analysis Preview 01:02
Preparing Data for Analysis Preview 07:07
In this lesson you will learn the best practices for preparing data for analysis.
Common Data Problems Preview 08:19
In this lesson you will learn to deal with common data problems that may affect your ability to do data analysis.
Introduction to Key Metrics Preview 01:50
Introduction to Key Metrics Analysis Preview 00:32
Creating Key Metric Calculations - Part 1 Preview 10:05
Creating key metric and key performance indicator calculations.
Creating Key Metric Calculations - Part 2 Preview 08:41
Creating key metric and key performance indicator calculations.
Key Metric Practical Activity Preview 00:19
Key Metrics Practical Activity Preview 07:07
The completed key metric activity
Introduction to Comparison Analysis Preview 01:28
Overview of using comparison analysis to create reports and graphs.
Comparison Analysis - Part 1 Preview 08:41
Using comparison analysis to create reports, graphs and tables of data analysis
Comparison Analysis - Part 2 Preview 08:24
Using comparison analysis to create reports, graphs and tables of data analysis
Practical Activity Comparison Analysis Preview 00:25
Comparison Analysis Practical Activity Preview 10:21
The completed comparison analysis practical activity
Introduction to Trend Analysis Preview 01:09
In this lesson we provide an overview of the different trend analysis techniques and methods
Trend Analysis - Part 1 Preview 09:02
Learn to create trend graphs and tables. Learn to apply different trend lines.
Trend Analysis - Part 2 Preview 07:03
Learn to create trend graphs and tables. Learn to apply different trend lines.
Practical Activity Trend Analysis Preview 00:16
Trend Analysis Practical Activity Preview 05:18
In this lesson we show how to complete the trend analysis practical activity
Introduction to Ranking Analysis Preview 02:03
Overview of ranking analysis and discussion about how to use the techniques
Ranking Analysis - Part 1 Preview 09:06
Ranking analysis including Top 10 analysis techniques
Ranking Analysis - Part 2 Preview 05:37
Ranking analysis including Top 10 analysis techniques
Practical Activity Ranking Analysis Preview 00:17
Practical Activity Ranking Analysis Preview 04:35
Completion of the ranking analysis activity
Introduction to Interactive Dashboards Preview 01:06
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
Interactive Dashboards - Part 1 Preview 07:56
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
Interactive Dashboards - Part 2 Preview 05:48
How to create interactive dashboards using key metrics, comparison analysis, trend analysis and rankings
Introduction to Variance Analysis Preview 01:36
Introduction and overview of variance analysis concepts
Download the Sales Budget Data file Preview 00:06
Variance Analysis - Part 1 Preview 10:54
How to use and create variance analysis calculations and analysis
Variance Analysis - Part 2 Preview 07:55
How to use and create variance analysis calculations and analysis
Practical Activity Variance Analysis Preview 00:15
Variance Analysis Practical Activity Preview 07:15
How to complete the variance analysis practical analysis activity
Introduction to Contribution Analysis Preview 01:48
Introduction and explanation of contribution analysis
Contribution Analysis - Part 1 Preview 05:30
How to create different contribution analysis calculations and techniques
Contribution Analysis - Part 2 Preview 09:38
How to create different contribution analysis calculations and techniques
Contribution Analysis Practical Activity Preview 00:15
Contribution Analysis Practical Activity Preview 05:27
How to complete the contribution analysis practical activity
Introduction to Frequency Analysis Preview 01:28
Introduction and overview of frequency analysis. Learn to easily create frequency histograms and groupings
Frequency Analysis - Part 1 Preview 05:35
Learn to create and analyze age groupings and histograms
Frequency Analysis - Part 2 Preview 02:51
Learn to create and analyze age groupings and histograms
Frequency Analysis Practical Activity Preview 00:13
Frequency Analysis Practical Activity Preview 03:31
How to complete the frequency practical activity
Introduction to Correlation Analysis Preview 01:09
Introduction and overview of correlation analysis. Explains the principles and concepts of correlation analysis
Correlation Analysis Preview 07:42
Introduction to Pareto Analysis Preview 01:48
How to perform pareto analysis
Pareto Analysis Preview 05:08
Example of pareto analysis
Conclusion Preview 01:06
This course includes:
- 3.5 hours on-demand video
- Access on mobile and TV
- Certificate of completion
Related Courses
![Flutter & Dart - The Complete Guide [2022 Edition]](https://img-c.udemycdn.com/course/100x100/1708340_7108_5.jpg)
Recent Posts
A step-by-step guide to post a job on Facebook
Millions of people use Facebook every day. At first, it was just a social media application, but now it has transformed into a completely different ...Read more
Capture Your Career w/ 5 Free Online Photography Courses
Nowadays, learning photography has become easier. Aspiring photographers can now learn the profession thanks to unlimited access to online education. Here are some of the ...Read more
What Job Opportunities Will You Have After Getting a Psychology Degree?
These days, every third person is in need of a psychologist. Anxiety, panic attacks, insomnia and depression have become quite common among children, adults, and ...Read more
Why Is Taking Management Courses Beneficial To Your Career?
It’s critical to keep learning and developing new talents, regardless of your level of expertise. As your career progresses, you’ll need to collaborate effectively with ...Read more
Amazing Advantages Of Online Music Courses
You may now simply and efficiently take online music lessons from the comfort of your own sofa using some very common equipment, free software, and ...Read more
