Complete Introduction to Business Data Analysis
What you'll 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
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 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
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
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
Instructor
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.
I completed my university degree in economics and emerged keen and eager to change the world. I spent the first half of my career working for multinational companies, on projects of various sizes, in different sectors, all revolving around analysing data of some sort and working with different software products, including Microsoft Excel.
I found that so many Excel users had a very basic understanding of how Excel works, and instead of using Excel to do the work for them, were doing all the work themselves, using old spreadsheet technology like macros instead of embracing technology like Pivot Tables. Pivot Tables were actually introduced into Excel in 1994 but many Excel users have avoided using them because they seem complicated and difficult to use.
In 2008 I decided to start my own training company and this was borne out of the passion I had to teach Excel users how to work smarter, not harder, increasing productivity by up to 80%. As technology evolved, and new systems developed, I continuously expanded my training to include Power BI, Amazon QuickSight, Looker Studio (formerly Google Data Studio), and most recently, Chat GPT. 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 which are guaranteed to make you 80% more productive in 20% of the time.
Initially I carried out all my training in person, in boardrooms and training centres for companies of all sizes, and then in 2013 I recorded my first Udemy course. The demand for in person, classroom training has dropped off significantly, and I now focus my time on Udemy and growing my new YouTube tutorials channel.
What has always made my training unique is that I enable you to move beyond spreadsheets without the need to learn new, technical processes and programming languages like SQL. Instead, I teach you a variety of analysis techniques and show you how to create sophisticated dashboards and reports using simple, yet powerful tools and methods, making data easier to understand and empowering you to make better business decisions in less time, putting you in the top 1% of Excel and Power BI users worldwide.