Intro to Data Analytics using Excel
Intro to Data Analytics using Excel, available at $69.99, has an average rating of 4.79, with 45 lectures, 6 quizzes, based on 124 reviews, and has 446 subscribers.
You will learn about Understand what "big data" and "data analytics" actually mean and why they are so important Learn different data analysis tools, how they work together, and how to use them with your data Know how to ask deeper and more meaningful questions of your data Apply various analysis techniques to datasets in Excel including a regression analysis Build a fully dynamic dashboard to present your findings This course is ideal for individuals who are Anyone who wants to learn more about their data, but don't know where to start or Beginners in analytics looking to start gaining value from their data It is particularly useful for Anyone who wants to learn more about their data, but don't know where to start or Beginners in analytics looking to start gaining value from their data.
Enroll now: Intro to Data Analytics using Excel
Summary
Title: Intro to Data Analytics using Excel
Price: $69.99
Average Rating: 4.79
Number of Lectures: 45
Number of Quizzes: 6
Number of Published Lectures: 45
Number of Published Quizzes: 6
Number of Curriculum Items: 51
Number of Published Curriculum Objects: 51
Original Price: $34.99
Quality Status: approved
Status: Live
What You Will Learn
- Understand what "big data" and "data analytics" actually mean and why they are so important
- Learn different data analysis tools, how they work together, and how to use them with your data
- Know how to ask deeper and more meaningful questions of your data
- Apply various analysis techniques to datasets in Excel including a regression analysis
- Build a fully dynamic dashboard to present your findings
Who Should Attend
- Anyone who wants to learn more about their data, but don't know where to start
- Beginners in analytics looking to start gaining value from their data
Target Audiences
- Anyone who wants to learn more about their data, but don't know where to start
- Beginners in analytics looking to start gaining value from their data
Our world, your company, and your life are filled with endless amounts of data just begging you to do something with it! If you work with data in any capacity and want to learn how to start analyzing it in an easy-to-understand manner, this course is for you.
In this course, you’ll learn the basics of data analysis, some fundamental tools and how to apply them, how to ask questions of your data, and how to present your findings in a slick dashboard. The entire course is done in Excel, no need to have some fancy-shmancy statistical software.
*We do highly recommend taking our “Beginner Statistics for Data Analytics” course before taking this course. The stats course gives you a great background on many of the tools we’ll be using.*
We start by demystifying the terms big data and data analytics before jumping into our statistics bootcamp (don’t worry, it’s not as scary as it sounds) to learn the key analytics tools. Armed with these tools, we’ll dive into a case study where we’ll use various analytical tools to analyze our data, come up with hypotheses, and test our assumptions. We top everything off by learning how to present data using a dynamic dashboard.
At completion, you’ll know how to use analytical techniques to analyze data sets.
Our courses are always:
-
Very easy to understand– There is not memorizing complex formulas (we have Excel to do that for us) or learning abstract theories. Just real, applicable knowledge.
-
Fun– We keep the course light-hearted with fun examples
-
To the point– We removed all the fluff so you’re just left with the most essential knowledge
Let’s start learning!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Welcome to the course!
Lecture 2: Download the course materials
Chapter 2: Introduction to Data Analytics & Big Data
Lecture 1: Introduction to Big Data
Lecture 2: Introduction to Data Analytics
Lecture 3: Types of Analytics
Chapter 3: Understanding the Data
Lecture 1: Introducing the Data and Problem
Lecture 2: Basic Analytics pt. I
Lecture 3: Basic Analytics pt. II
Lecture 4: Basic Analytics pt. III
Lecture 5: Descriptive Analytics pt. I
Lecture 6: Descriptive Analytics pt. II
Lecture 7: Creating a Histogram
Chapter 4: Pareto Analysis
Lecture 1: Pareto Analysis pt. I
Lecture 2: Pareto Analysis pt. II
Lecture 3: Pareto Analysis pt. III
Lecture 4: Pareto Analysis pt. IV
Chapter 5: Correlation & Regression Analysis
Lecture 1: Preparing our Data
Lecture 2: Calculating and Interpreting Correlation
Lecture 3: Asking more Questions
Lecture 4: Scatter Plots
Lecture 5: Analysis Tool Pack, Correlation, and R-square
Lecture 6: P-Value
Lecture 7: Creating a Model
Lecture 8: Confidence Interval
Chapter 6: Relationships
Lecture 1: Looking at Data in a Different Light
Lecture 2: PivotTables and Calculated Fields
Lecture 3: Looking at Data through a Different Lens (03:58)
Lecture 4: Drilling into Turnover pt. I
Lecture 5: Drilling into Turnover pt. II
Lecture 6: Calculating Tenure at the Firm pt. I
Lecture 7: Calculating Tenure at the Firm pt. II
Lecture 8: Calculating Tenure at the Firm pt. III
Lecture 9: Discovering our Answer
Chapter 7: Modeling & Dashboards
Lecture 1: Quantifying our Recommendation
Lecture 2: Calculating Overall Turnover Cost
Lecture 3: Calculating Maternity Turnover Cost
Lecture 4: Calculating Maternity Leave Cost
Lecture 5: Calculating the Final Benefit
Lecture 6: Creating a Data Table pt. I
Lecture 7: Creating a Data Table pt. II
Lecture 8: Creating a Dashboard pt. I
Lecture 9: Creating a Dashboard pt. II
Lecture 10: Creating a Dashboard pt. III
Lecture 11: Creating a Dashboard pt. IV
Chapter 8: Conclusion
Lecture 1: Conclusion
Instructors
-
Joseph @ Wisdify
CFO, Corporate Finance expert, Instructor, Mentor
Rating Distribution
- 1 stars: 1 votes
- 2 stars: 2 votes
- 3 stars: 10 votes
- 4 stars: 47 votes
- 5 stars: 64 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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024