Complete Introduction to Business Data Analysis

Move beyond BASIC reports and learn DATA ANALYSIS. Easily turn data into INSIGHT and INTELLIGENCE with Microsoft Excel

4.60 (17332 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
Complete Introduction to Business Data Analysis
49,511
students
3.5 hours
content
Sep 2023
last update
$94.99
regular price

What you will learn

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

Why take this course?

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.

Content

Introduction

Introduction to Business Data Analysis
Introduction to Data Analysis
Download the Training Data Files

Preparing Data for Analysis

Introduction to Data Preparation
Introduction to Preparing for Data Analysis
Preparing Data for Analysis
Common Data Problems
The Completed Common Data Problems Data File

Data Analysis - Key Metrics

Introduction to Key Metrics
Introduction to Key Metrics Analysis
Creating Key Metric Calculations - Part 1
Creating Key Metric Calculations - Part 2
Key Metric Practical Activity
Key Metrics Practical Activity

Comparison Analysis

Introduction to Comparison Analysis
Comparison Analysis - Part 1
Comparison Analysis - Part 2
Practical Activity Comparison Analysis
Comparison Analysis Practical Activity

Trend Analysis

Introduction to Trend Analysis
Trend Analysis - Part 1
Trend Analysis - Part 2
Practical Activity Trend Analysis
Trend Analysis Practical Activity

Ranking Analysis

Introduction to Ranking Analysis
Ranking Analysis - Part 1
Ranking Analysis - Part 2
Practical Activity Ranking Analysis
Practical Activity Ranking Analysis

Interactive Dashboard Creation

Introduction to Interactive Dashboards
Interactive Dashboards - Part 1
Interactive Dashboards - Part 2

Variance Analysis

Introduction to Variance Analysis
Download the Sales Budget Data file
Variance Analysis - Part 1
Variance Analysis - Part 2
Practical Activity Variance Analysis
Variance Analysis Practical Activity

Contribution Analysis

Introduction to Contribution Analysis
Contribution Analysis - Part 1
Contribution Analysis - Part 2
Contribution Analysis Practical Activity
Contribution Analysis Practical Activity

Frequency Analysis

Introduction to Frequency Analysis
Frequency Analysis - Part 1
Frequency Analysis - Part 2
Frequency Analysis Practical Activity
Frequency Analysis Practical Activity

Correlation Analysis

Introduction to Correlation Analysis
Correlation Analysis

Pareto Analysis

Introduction to Pareto Analysis
Pareto Analysis

Conclusion

Conclusion

Screenshots

Complete Introduction to Business Data Analysis - Screenshot_01Complete Introduction to Business Data Analysis - Screenshot_02Complete Introduction to Business Data Analysis - Screenshot_03Complete Introduction to Business Data Analysis - Screenshot_04

Our review

--- **Overview of the Course:** The course has garnered a high level of satisfaction from its participants, with a global rating of 4.60. The recent reviews consistently praise the course for its wealth of information, clarity, and practical applicability in enhancing data analysis skills, particularly within Microsoft Excel. The majority of reviewers found the course to be informative and beneficial for both beginners and more advanced learners. **Pros:** - **Comprehensive Content:** Reviewers have reported learning new things even if they had prior knowledge or had taken other advanced courses. - **Clear Explanations:** The instructor is commended for being clear, concise, and easy to follow, making complex analytical techniques understandable. - **Practical Application:** Many learners appreciated the practical exercises that allowed them to apply concepts in real-time, enhancing their ability to analyze data effectively. - **Interactive Dashboard Lessons:** Several reviewers highlighted the dashboard lessons as particularly useful and practical for their work. - **Value for Career Advancement:** A number of learners expressed that the course was perfectly matched for their career needs and would enable them to apply new skills to improve report analysis. - **Enjoyable Learning Experience:** The course content was described as engaging, with some learners expressing enthusiasm for applying what they learned immediately after the course. - **Variety of Learning Styles:** Some reviewers pointed out that the course's approach to teaching through examples and exercises catered to different learning styles, making it more effective. **Cons:** - **Pace of Instruction:** A few reviewers felt the course moved too quickly, which made it difficult to keep up or understand the instructions without prior knowledge. - **Exercise Quality:** There were mentions that some exercises were not particularly helpful and did not add much value. Additionally, the dashboard section was criticized for being too basic and not aesthetically pleasing. - **Speed of Delivery:** Some learners indicated that the instructor zipped through content at a pace that assumed prior knowledge, making it challenging for beginners to follow along. - **Lack of Summaries or Reference Material:** A learner suggested that having a brief outline or summary as text or reference material would aid in focusing on the presentation without needing to refer to additional notes. - **Need for Slower Pacing and Supporting Resources:** To accommodate learners with varying levels of expertise, it was recommended that the course be delivered at a slower pace and include more supporting resources. **Additional Notes:** - The instructor's explanatory capacity was generally average, but their approach to teaching was appreciated by most learners. - Some reviewers pointed out that the course opened up new horizons for them within Excel's capabilities. - The interactive dashboard lesson was particularly beneficial for those who seldom use slicers in their reports and presentations. - The course was deemed both a refresher and an overview of analytical functions within Microsoft Excel, proving to be ideal for data analysts starting out on their journey. In summary, the course is highly recommended for its informative content and practical approach to teaching data analysis with Excel. However, it would benefit from a more measured pace, improved exercise quality, and additional learning materials to better accommodate learners of varying skill levels.

Coupons

DateDiscountStatus
5/6/202189% OFF
expired

Charts

Price

Complete Introduction to Business Data Analysis - Price chart

Rating

Complete Introduction to Business Data Analysis - Ratings chart

Enrollment distribution

Complete Introduction to Business Data Analysis - Distribution chart
540450
udemy ID
6/29/2015
course created date
7/17/2019
course indexed date
Bot
course submited by