Complete Introduction to Business Data Analysis

Complete Introduction to Business Data Analysis, available at $99.99, has an average rating of 4.57, with 53 lectures, based on 19196 reviews, and has 54592 subscribers.

You will learn about 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 This course is ideal for individuals who are All Business people who want to turn data into information or Excel users who want to take their reporting and analysis to the next level or Students who want to learn powerful methods of data analysis It is particularly useful for All Business people who want to turn data into information or Excel users who want to take their reporting and analysis to the next level or Students who want to learn powerful methods of data analysis.

Enroll now: Complete Introduction to Business Data Analysis

Summary

Title: Complete Introduction to Business Data Analysis

Price: $99.99

Average Rating: 4.57

Number of Lectures: 53

Number of Published Lectures: 53

Number of Curriculum Items: 53

Number of Published Curriculum Objects: 53

Original Price: $89.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

If you want to learn simple, effective techniques to create impactful Excel Dashboards and Data Analysis, this course is the one you’re looking for. 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!

COURSE CONTENT AND OUTCOMES

This course 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

This course 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.

ABOUT THE TRAINER

I am a Udemy Instructor Partner with more than 20 years’ experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.

WHAT STUDENTS ARE SAYING:

Informative lesson and there are activites that I can follow along to practice what I have learned. Amazing course for beginners regarding Business Data Analysis
It was easy to understand. This will help me greatly with my data analysis. Following through on the course hands-on was also helpful
This course was great as an overview of the powers of Excel, i’ve gained some great insight and pointers to use in the future. The practical tasks after each learning part where helpful to solidify my skills.

DATA ANALYSIS COURSES ROADMAP

The tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights. I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.

Microsoft Excel

Introduction to Analyzing Data with Excel Pivot Tables
Complete Introduction to Excel Power Pivot
Complete Introduction to Excel Power Query
Excel Interactive Dashboards and Data Analysis
Complete Introduction to Business Data Analysis
Tables and Formulas with Excel

Microsoft Power BI

Complete Introduction to Microsoft Power BI
Complete Introduction to Power BI Query Editor
Power BI Master Class-Data Models and DAX Formulas
Power BI Master Class – Dashboards and Power BI Service

Google

Complete Introduction to Google Sheets Pivot Tables
Complete Introduction to Looker Studio (formerly Google Data Studio)

Amazon QuickSight

Complete Introduction to Amazon QuickSight

ChatGPT

Introduction to Analyzing Data with ChatGPT

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to Business Data Analysis

Lecture 2: Introduction to Data Analysis

Lecture 3: About the Course

Lecture 4: Download the Training Data Files

Chapter 2: Preparing Data for Analysis

Lecture 1: Introduction to Data Preparation

Lecture 2: Introduction to Preparing for Data Analysis

Lecture 3: Preparing Data for Analysis

Lecture 4: Common Data Problems

Chapter 3: Data Analysis – Key Metrics

Lecture 1: Introduction to Key Metrics

Lecture 2: Introduction to Key Metrics Analysis

Lecture 3: Creating Key Metric Calculations – Part 1

Lecture 4: Creating Key Metric Calculations – Part 2

Lecture 5: Key Metric Practical Activity

Lecture 6: Key Metrics Practical Activity

Chapter 4: Comparison Analysis

Lecture 1: Introduction to Comparison Analysis

Lecture 2: Comparison Analysis – Part 1

Lecture 3: Comparison Analysis – Part 2

Lecture 4: Practical Activity Comparison Analysis

Lecture 5: Comparison Analysis Practical Activity

Chapter 5: Trend Analysis

Lecture 1: Introduction to Trend Analysis

Lecture 2: Trend Analysis – Part 1

Lecture 3: Trend Analysis – Part 2

Lecture 4: Practical Activity Trend Analysis

Lecture 5: Trend Analysis Practical Activity

Chapter 6: Ranking Analysis

Lecture 1: Introduction to Ranking Analysis

Lecture 2: Ranking Analysis – Part 1

Lecture 3: Ranking Analysis – Part 2

Lecture 4: Practical Activity Ranking Analysis

Lecture 5: Practical Activity Ranking Analysis

Chapter 7: Interactive Dashboard Creation

Lecture 1: Introduction to Interactive Dashboards

Lecture 2: Interactive Dashboards – Part 1

Lecture 3: Interactive Dashboards – Part 2

Chapter 8: Variance Analysis

Lecture 1: Introduction to Variance Analysis

Lecture 2: Download the Sales Budget Data file

Lecture 3: Variance Analysis – Part 1

Lecture 4: Variance Analysis – Part 2

Lecture 5: Practical Activity Variance Analysis

Lecture 6: Variance Analysis Practical Activity

Chapter 9: Contribution Analysis

Lecture 1: Introduction to Contribution Analysis

Lecture 2: Contribution Analysis – Part 1

Lecture 3: Contribution Analysis – Part 2

Lecture 4: Contribution Analysis Practical Activity

Lecture 5: Contribution Analysis Practical Activity

Chapter 10: Frequency Analysis

Lecture 1: Introduction to Frequency Analysis

Lecture 2: Frequency Analysis – Part 1

Lecture 3: Frequency Analysis – Part 2

Lecture 4: Frequency Analysis Practical Activity

Lecture 5: Frequency Analysis Practical Activity

Chapter 11: Correlation Analysis

Lecture 1: Introduction to Correlation Analysis

Lecture 2: Correlation Analysis

Chapter 12: Pareto Analysis

Lecture 1: Introduction to Pareto Analysis

Lecture 2: Pareto Analysis

Chapter 13: Conclusion

Lecture 1: Conclusion

Instructors

Ian Littlejohn
Microsoft Power BI and Business Intelligence Specialist

Rating Distribution

1 stars: 75 votes
2 stars: 175 votes
3 stars: 1594 votes
4 stars: 7009 votes
5 stars: 10343 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu