Complete Introduction to Business Data Analysis

Brief Summary

This course is all about leveling up your data analysis skills using Excel. You'll learn straightforward techniques to create cool dashboards and understand data better—perfect for anyone looking to make data-driven decisions at work. Plus, it’s super user-friendly with no complicated stuff!

About This Course

Move beyond basic reports and learn data analysis. Easily turn data into insight and intelligence with Microsoft Excel

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

• 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