Best Data Analysis Courses

Find the best online Data Analysis Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Data Analysis Courses.

Microsoft Excel – Learn MS EXCEL For DATA Analysis

Excel: learn how Excel can be used for data analysis by creating excel project-excel app-other excel tools

Created by Yassin Marco - Helped over 895 000+ students in 198 countries

"]

Students: 189203, Price: $59.99

Students: 189203, Price:  Paid

Whether you are interested in learning

- Different ways of how to properly use Microsoft Excel

- Learn the basics of Data Analysis

- Learn how to create different Excel Apps

- Just grow your Knowledge about this amazing Microsoft App

Or any other reason, this course is definitely for you. The way this class have been designed was to offer to the student an easy way to learn Microsoft Excel and the basics of Data analysis at the same time. Indeed, not only this course is teaching you all the basic concepts and functions of Microsoft Excel but at the same time you will have all the required knowledge to create basic Apps that can be used to analyze Data.

The structure of the course

​The way the course is structured is help you learn by practice. In other words, there is way more practice than theory. The main reason of why I structure my courses this way is that for me the best way to learn something is by practicing it enough. This means that if you want to learn how to properly use Microsoft Excel for Data analysis it will be through practice and not simply by learning the theory.

The course is divided in big projects. This way, each time that you learn a new concept you will create a project around it. This will help you not only have a better understanding of the concept but also be able to see in what real life situation a certain concept can be useful.

For who is this course designed

​My goal when I was creating this course was to help the maximum of people not only learn Data analysis but also Microsoft Excel. This means that if you wanted to learn how data is analyzed and at the same time learn the basics of Microsoft Excel then you will enjoy this course. It has been created for everyone who has interest in learning more about Excel, different ways to analyze Data or simply learn a new skill that can be very useful not only in the business world but also in your everyday life.

Why should I take this course

​There is a lot of Microsoft Excel courses that exist, but this course is very unique. Not only it offers you the possibility to learn how to properly use this App, but you will also learn the basics of Data analysis. Also, all the concepts are presented with clear examples and you will be able to learn them by creating your own projects around those concepts. This means that you will have a strong knowledge of Microsoft Excel but also will know and understand how to properly use this app to perform different simple but also more complicated tasks. The best part, is that the APPS that you will create in this course can be used in your business or in your every day life.

There is no risk involved in taking this course

​This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days ​to get a complete refund with no questions asked. Also, if there is any concept that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.

This means that you can either learn amazing skills that can be very useful in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

This is why more than 75 000 students have already took the course !! Don't wait anymore

ENROL NOW and start learning today :)

Learning Python for Data Analysis and Visualization

Learn python and how to use it to analyze,visualize and present data. Includes tons of sample code and hours of video!

Created by Jose Portilla - Head of Data Science, Pierian Data Inc.

"]

Students: 173566, Price: $129.99

Students: 173566, Price:  Paid

PLEASE READ BEFORE ENROLLING: 

1.) THERE IS AN UPDATED VERSION OF THIS COURSE: 

"PYTHON FOR DATA SCIENCE AND MACHINE LEARNING BOOTCAMP" 

2.) IF YOU ARE A COMPLETE BEGINNER IN PYTHON-CHECK OUT MY OTHER COURSE "COMPLETE PYTHON MASTERCLASS JOURNEY"!

CLICK ON MY PROFILE TO FIND IT. (PLEASE WATCH THE FIRST PROMO VIDEO ON THIS PAGE FOR MORE INFO)

**********************************************************************************************************

This course will give you the resources to learn python and effectively use it analyze and visualize data! Start your career in Data Science!

    You'll get a full understanding of how to program with Python and how to use it in conjunction with scientific computing modules and libraries to analyze data. 

  You will also get lifetime access to over 100 example python code notebooks, new and updated videos, as well as future additions of various data analysis projects that you can use for a portfolio to show future employers! 

    By the end of this course you will: 

  - Have an understanding of how to program in Python. 

  - Know how to create and manipulate arrays using numpy and Python. 

  - Know how to use pandas to create and analyze data sets. 

  - Know how to use matplotlib and seaborn libraries to create beautiful data visualization. 

  - Have an amazing portfolio of example python data analysis projects! 

- Have an understanding of Machine Learning and SciKit Learn!

  With 100+ lectures and over 20 hours of information and more than 100 example python code notebooks, you will be excellently prepared for a future in data science! 

Microsoft Excel Pivot Tables – The Beginner Course

Start analyzing data with Excel's most powerful data analysis tool, Pivot Tables. They're easier than you think!

Created by Matt Jackman - Digital Analytics and SEO Professional

"]

Students: 151181, Price: Free

Students: 151181, Price:  Free

What's this course about

Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they'll change the way you use Excel.

If you're not familiar with Pivot Tables, they're a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.

This is an introductory Pivot Table course and gives the information you'll need to start using Pivot Tables.

Who will benefit from this course

If you're somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.

You don't have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.

This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.

What you'll learn in this course

  • How to create a Pivot Table
  • How to summarize information in different ways using Pivot Tables

By the end of this course, you'll be able to take your own information and leverage Pivot Tables to answer questions with ease!

Data Analysis with Pandas and Python

Analyze data quickly and easily with Python's powerful pandas library! All datasets included --- beginners welcome!

Created by Boris Paskhaver - Software Engineer | Consultant | Author

"]

Students: 149474, Price: $19.99

Students: 149474, Price:  Paid

Student Testimonials:

  • The instructor knows the material, and has detailed explanation on every topic he discusses. Has clarity too, and warns students of potential pitfalls. He has a very logical explanation, and it is easy to follow him. I highly recommend this class, and would look into taking a new class from him. - Diana

  • This is excellent, and I cannot complement the instructor enough. Extremely clear, relevant, and high quality - with helpful practical tips and advice. Would recommend this to anyone wanting to learn pandas. Lessons are well constructed. I'm actually surprised at how well done this is. I don't give many 5 stars, but this has earned it so far. - Michael

  • This course is very thorough, clear, and well thought out. This is the best Udemy course I have taken thus far. (This is my third course.) The instruction is excellent! - James

Welcome to the most comprehensive Pandas course available on Udemy! An excellent choice for both beginners and experts looking to expand their knowledge on one of the most popular Python libraries in the world!

Data Analysis with Pandas and Python offers 19+ hours of in-depth video tutorials on the most powerful data analysis toolkit available today. Lessons include:

  • installing

  • sorting

  • filtering

  • grouping

  • aggregating

  • de-duplicating

  • pivoting

  • munging

  • deleting

  • merging

  • visualizing

and more!

Why learn pandas?

If you've spent time in a spreadsheet software like Microsoft Excel, Apple Numbers, or Google Sheets and are eager to take your data analysis skills to the next level, this course is for you! 

Data Analysis with Pandas and Python introduces you to the popular Pandas library built on top of the Python programming language. 

Pandas is a powerhouse tool that allows you to do anything and everything with colossal data sets -- analyzing, organizing, sorting, filtering, pivoting, aggregating, munging, cleaning, calculating, and more! 

I call it "Excel on steroids"!

Over the course of more than 19 hours, I'll take you step-by-step through Pandas, from installation to visualization! We'll cover hundreds of different methods, attributes, features, and functionalities packed away inside this awesome library. We'll dive into tons of different datasets, short and long, broken and pristine, to demonstrate the incredible versatility and efficiency of this package.

Data Analysis with Pandas and Python is bundled with dozens of datasets for you to use. Dive right in and follow along with my lessons to see how easy it is to get started with pandas!

Whether you're a new data analyst or have spent years (*cough* too long *cough*) in Excel, Data Analysis with pandas and Python offers you an incredible introduction to one of the most powerful data toolkits available today!

Microsoft Excel – Data Analysis with Excel Pivot Tables

Master Excel pivots & learn data analysis w/ advanced Excel cases from a top Excel & business intelligence instructor

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 138976, Price: $174.99

Students: 138976, Price:  Paid

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Pivot Table course:

"This is a great Excel course. You can feel confident putting these skills on your resume, and the lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just LEARN Excel Pivot Tables, but become a true Pivot Table EXPERT"

-Monique C.

"Chris provides clear, detailed explanations and shows how to use Excel Pivot Tables to extract hidden details and facts using raw, real-life data sets in Excel. The quizzes and homework reinforce the lessons and the course layout makes it easy to go back to sections that need revision. This course is exactly what I was looking for to master Excel Pivot Tables. Thanks, Chris!"

-Paul M.

"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel and Pivot Table courses from Chris & Maven Analytics and look forward to viewing them as well."

-Ernie A.

__________

FULL COURSE DESCRIPTION:

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how condo prices have trended over the past 10 years, Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:

  • Raw data structure in Excel

  • Pivot Table layouts & styles

  • Design & formatting options

  • Sorting, filtering, & grouping tools

  • Calculated fields, items & values

  • Pivot Charts, slicers & timelines

  • Interactive Excel dashboards

__________

We'll then explore and analyze Excel datasets from a number of real-world case studies, including:

  • San Diego burrito ratings

  • Shark attack records from 1900-2016

  • Facebook Post data from Spartan Race

  • Major League Baseball team statistics

  • San Francisco employee salaries

  • Daily stock market data

  • IMDb movie ratings

  • Apple Store mobile app ratings

  • Wine ratings and descriptions

__________

Whether you're looking for a quick Excel Pivot Table primer, trying to diversify your Excel skill set, or hoping to step up your analytics game in a major way, you've come to the right place. In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge. Enroll today and start your journey to becoming an Excel analytics pro!

See you there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.

Microsoft Excel Zero to Advanced: Data Analysis & Dashboards

Microsoft Excel Beginner to Advanced w/ Data Analysis, & Dashboards. Learn Pro Tips, Shortcuts, Formulas and Functions.

Created by Irfan Sharif - Bestselling Trainer | Chartered Accountant | PwC Alumni

"]

Students: 132534, Price: $99.99

Students: 132534, Price:  Paid

If your work requires working with numbers or large amounts of data, Microsoft Excel is your software.

Microsoft Excel is one of the most powerful data management, data analysis and dashboarding tool.

This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features.

About this course:

Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data.

Prerequisites:

There is absolutely no prerequisite to start this course. Even 8 years old can take this course to learn Excel.

Who should take this course:

First-time learners, who have no idea about Excel and want to start the right way. This includes:

  1. Students

  2. Professionals, especially those who have to work with numbers.

  3. Daydreamers who wish to bring financial sense to their dreams.

  4. Anyone who wants to learn a better way to manage the numbers and calculations.

Software Requirement:

You should have Microsoft Excel installed on your computer. Any version above Excel 2010 will be okay. I will be using Excel 2016 in this course. If you do not have Excel currently, please download Office 365 free trial from the Microsoft website. Just google Office 365 free trial and it will take you to the page.

Money-Back Guarantee: 

Nothing to lose! If you won't be satisfied with the course, Udemy offers 30 days money-back guarantee!

Introduction to the teacher:

Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty | 4000+ in-class students | 100,000+ Udemy students | In love with Excel for 15 years

Python A-Z™: Python For Data Science With Real Exercises!

Programming In Python For Data Analytics And Data Science. Learn Statistical Analysis, Data Mining And Visualization

Created by Kirill Eremenko - Data Scientist

"]

Students: 130580, Price: $99.99

Students: 130580, Price:  Paid

Learn Python Programming by doing!

There are lots of Python courses and lectures out there. However, Python has a very steep learning curve and students often get overwhelmed. This course is different!

This course is truly step-by-step. In every new tutorial we build on what had already learned and move one extra step forward.

After every video you learn a new valuable concept that you can apply right away. And the best part is that you learn through live examples.

This training is packed with real-life analytical challenges which you will learn to solve. Some of these we will solve together, some you will have as homework exercises.

In summary, this course has been designed for all skill levels and even if you have no programming or statistical background you will be successful in this course!

I can't wait to see you in class,

Sincerely,

Kirill Eremenko

Statistics for Data Science and Business Analysis

Statistics you need in the office: Descriptive & Inferential statistics, Hypothesis testing, Regression analysis

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 108459, Price: $94.99

Students: 108459, Price:  Paid

Is statistics a driving force in the industry you want to enter? Do you want to work as a Marketing Analyst, a Business Intelligence Analyst, a Data Analyst, or a Data Scientist?

Well then, you’ve come to the right place!

 

Statistics for Data Science and Business Analysis is here for you with TEMPLATES in Excel included!

 

This is where you start. And it is the perfect beginning!

 

In no time, you will acquire the fundamental skills that will enable you to understand complicated statistical analysis directly applicable to real-life situations. We have created a course that is:   

  • Easy to understand

     

  • Comprehensive

     

  • Practical

     

  • To the point

     

  • Packed with plenty of exercises and resources   

  • Data-driven

     

  • Introduces you to the statistical scientific lingo

     

  • Teaches you about data visualization

     

  • Shows you the main pillars of quant research

     

It is no secret that a lot of these topics have been explained online. Thousands of times. However, it is next to impossible to find a structured program that gives you an understanding of why certain statistical tests are being used so often. Modern software packages and programming languages are automating most of these activities, but this course gives you something more valuable – critical thinking abilities. Computers and programming languages are like ships at sea. They are fine vessels that will carry you to the desired destination, but it is up to you, the aspiring data scientist or BI analyst, to navigate and point them in the right direction.   

Teaching is our passion

 

We worked hard for over four months to create the best possible Statistics course which would deliver the most value to you. We want you to succeed, which is why the course aims to be as engaging as possible. High-quality animations, superb course materials, quiz questions, handouts and course notes, as well as a glossary with all new terms you will learn, are just some of the perks you will get by subscribing.   

What makes this course different from the rest of the Statistics courses out there?

 

  • High-quality production – HD video and animations (This isn’t a collection of boring lectures!)

     

  • Knowledgeable instructor (An adept mathematician and statistician who has competed at an international level)   

  • Complete training – we will cover all major statistical topics and skills you need to become a marketing analyst, a business intelligence analyst, a data analyst, or a data scientist

     

  • Extensive Case Studies that will help you reinforce everything you’ve learned

     

  • Excellent support - if you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 1 business day

     

  • Dynamic - we don’t want to waste your time! The instructor sets a very good pace throughout the whole course

Why do you need these skills?

 

  1. Salary/Income – careers in the field of data science are some of the most popular in the corporate world today. And, given that most businesses are starting to realize the advantages of working with the data at their disposal, this trend will only continue to grow

     

  2. Promotions – If you understand Statistics well, you will be able to back up your business ideas with quantitative evidence, which is an easy path to career growth

     

  3. Secure Future – as we said, the demand for people who understand numbers and data, and can interpret it, is growing exponentially; you’ve probably heard of the number of jobs that will be automated soon, right? Well, data science careers are the ones doing the automating, not getting automated

  4. Growth - this isn’t a boring job. Every day, you will face different challenges that will test your existing skills and require you to learn something new   

Please bear in mind that the course comes with Udemy’s 30-day unconditional money-back guarantee. And why not give such a guarantee? We are certain this course will provide a ton of value for you.

 

Let's start learning together now!

 

Data Science, Machine Learning, Data Analysis, Python & R

FREE Course on Data Science, Machine Learning, Data Analysis, Data Visualization using Python and R Programming

Created by DATAhill Solutions Srinivas Reddy - Data Scientist

"]

Students: 65970, Price: Free

Students: 65970, Price:  Free

Interested in the field of Data Science, Machine Learning, Data Analytics, Data Visualization? Then this course is for you!

This course has been designed by two professional Data Scientists so that we can share our knowledge and help you learn complex theory, algorithms and coding libraries in a simple way.

We will walk you step-by-step into the World of Data Science. With every tutorial you will develop new skills and improve your understanding of this challenging yet lucrative sub-field of Data Science.

Moreover, the course is packed with practical exercises which are based on real-life examples. So not only will you learn the theory, but you will also get some hands-on practice building your own models.

And as a bonus, this course includes both Python and R code templates which you can download and use on your own projects.

SQL for Data Analysis: Weekender Crash Course for Beginners

Using MySQL but applicable to Oracle SQL, Microsoft SQL Server, and PostgreSQL. Taught by a Data Scientist and PM.

Created by A Course You'll Actually Finish - A Course Series

"]

Students: 65932, Price: $124.99

Students: 65932, Price:  Paid

Buff up your resume/CV and become interview-ready by learning real-world SQL in this course.

This SQL course has been taken by fine marketing folks at Google, Facebook, Amazon, Lyft, and Udemy.

Your Story:

Bill was looking to move into a more analytical role and saw SQL as a requirement in the job listings he saw.  He wanted to add "SQL" as a skill to his resume/CV with a clean conscience and back it up if any questions arose in the interview.  But getting there would take forever. Better to just "fake it til' you make it"... right?

Joe was working in a marketing position at a small company. He had a bunch of creative ideas but sometimes felt like he was shooting in the dark and guessing at what customers were doing. If only he had some insights about user behavior so he could be a more data-driven marketer. But data analysis is only for technical folks… right?

Our Story:

David and Pete joined Udemy with little to no technical experience. But after a lot of trial and error, headaches, and help from their friends, they got good enough to uncover unique insights for themselves, their team, and their company using SQL. They were able to discover interesting things about user behavior, create dashboards to track and measure progress on team goals, pull data for the exec team to use in investor pitch decks, and get data driven about decisions they made. They've since helped many team members buff up their data analysis skills and helped students land jobs!

What You'll Learn:

If you have no technical background, don't be afraid! We've distilled our knowledge and experience using SQL into a short course so that by the end, you'll have the raw skills to do some real data analysis for your company using SQL - a language virtually EVERY company uses. Note: this courses teaches you real-world SQL - not just the theory in abstract, but real skills you can use to get more data-driven in your current job. 

How This Course is Structured:

  • In this course we'll be pretending we're a real business (i.e. Blockbuster) so the stuff you learn will be easy to apply to your own situation/company. No abstract/theoretical mumbo jumbo.
  • We'll go through queries a real business would run while also teaching you the raw skills undergirding those queries so you can adapt those skills to create custom queries for your own specific purposes
  • To reinforce learning, we have exercises and quizzes scattered throughout the course so you can learn by doing
  • We'll have a bonus section where new lectures will be added occasionally (including student-requested lectures, more advanced topics, strategies for getting unstuck, etc.)
  • We'll be actively involved in the discussion board answering any questions you might have! Don't be afraid to ask!

A Note About Pedagogy:

We know what it's like to buy a book, feel good about yourself, never finish it and have nothing to show for it. We don't want that to happen with this course. We want this to be a course you'll actually finish. We believe half of learning is motivation and engagement, so we've tried extra hard to make this course fun, relevant, entertaining, and punchy - no frills, no dragging things out, just the good stuff. Heck, you might even find yourself skipping a party to spend time with your new best friends (i.e. us)!

FAQs:

  1. Do I need to purchase any software to take this course? Nope! Everything we use to do data analysis with MySQL is completely free. We'll walk you through the installation and set-up of any software we'll be using.
  2. Can I take this course with Linux? The set-up and installation lectures we've created are for Windows and Mac, and we don't currently have specific installation lectures for Linux.

Data Analysis Essentials Using Excel

Learn to apply the important concepts and techniques of data analysis using Excel.

Created by Symon He - Author | Investor | MBA

"]

Students: 48011, Price: $109.99

Students: 48011, Price:  Paid

Ibadullah Khalil - 5 Stars

“A great instructor and guide for the course. All topics were well driven and to the point with no gibberish language used to make it difficult for the learners just like other instructors. A highly recommended course for every beginner who aims to become a data analyst”

 

Jianyong Chen - 5 Stars

“This is one of the best course I took on Udemy so far. The instructors explained everything in detail and there are practices after each section. Make sure you download all the files, practice on your own, and you will learn a lot. Highly recommend!”

 

 

Every business generates data.  But whether you're able to turn that into useful insights depends on your ability to process, manipulate, and ultimately translate that data.

Whether you're working for a company or running your own, being able to make better decisions requires you to be able to analyze and interpret data.  

What data do you need? How do you prep that data? How do you analyze it to answer specific questions?

In this course, we're going to show you step-by-step, exactly how to do that, by starting with the very basics.  

 

Why Microsoft Excel?

 

This course is as much about Excel, if not more, than data analysis concepts and techniques. Why?

 

Excel is still the most popular tool used by analysts in all industries, across all roles.  It's used by financial analysts, marketing analysts, sales analysts, and of course, data analysts.  

Yes, there are many tools out there but if you learn and master the core concepts and techniques of data analysis in Excel, you'll be able to apply your knowledge to a broad range of applications.

 

Don’t underestimate Excel--a single worksheet can technically hold more than 17 BILLION data points (granted, it will make your computer REALLY slow). Fortunately, most of us running analysis will need to process far fewer data points than that. Still, it speaks to the power of the program.

 

Maurizio Zippo - 5 Stars

“This is one of the best course I have ever taken and thoroughly enjoyed. Highly recommended if you want to brush up your existing Excel Skills and to learn how to build some complicated formulae. The Pivot Table and Charts were something I always struggled with but thanks to Symon and Travis' explanations they are now so easy to use every day at work, saving me tonnes of time! Many Thanks Symon and Travis for putting together this great course you are my Excel heroes! The case studies on Cryptocurrency and The Start Up Market are absolute gems! I can't wait to get started with your next course.”

 

Why learn from us?

 

By signing up with us, you will be learning from two instructors with a combined 35 years of relevant experience across a wide range of analyst roles.  

 

Travis has been a digital marketer, investor, and entrepreneur for 20 years. He’s led growth in Asia for Groupon and even helped build Excel when he was as an engineer at Microsoft.  He is a data analysis and data visualization expert who pulls from his industry experience to teach some of the advanced data analysis topics you’ll find in this course. 

 

Symon has been interpreting and analyzing data for 15 years.  He has served as a financial analyst, marketing analyst, and even head of marketing analytics across half a dozen industries.  If you look at his other courses on Udemy, you'll see that he is an Excel and analysis ninja, having taught nearly 180,000 students with over 18,000 reviews.  

 

Together, we’ve pulled directly from our personal experience and put everything we could into this course. In fact, all of the case studies you’ll find inside are inspired by real-world projects we’ve worked on.

 

What if I don't have any data analysis or Excel background?

 

No worries! This is why we start with the very basics in our foundational sections, which is designed to get you familiar with Excel before we move on to more advanced topics.  You can be a complete beginner and take this course.  It might sometimes feel like you're drinking out of a fire hose, but if you put in the time and effort we promise you’ll see results by following our course and doing the exercises. 

 

We then progressively increase the difficulty as you move along in the course, culminating in advanced techniques taught through our case studies.  

If you do have an Excel background, you can skip or skim through the foundational sections and move directly into the more advanced topics.  

 

Stephen Dias - 5 Stars

“If you're trying to learn the foundations of excel this course is all you need.”

 

Brandon Parker - 5 Stars

“I have a lot of experience building excel models and purchased the course for the case studies. I didn't expect to learn much from the introductory parts but was surprised to find additional keyboard shortcuts I had never learned as well as powerful new functions that will make my life a lot easier. This course helped me brush up on functionality that I often neglected while using excel and was super comprehensive. I look forward to continuing using this course as additional case studies are added and highly recommend it for even excel experts.”

 

Learn through practice.

Like most things in life, becoming proficient at data analysis in Excel takes practice.  A lot of practice.

 

Sure, you'll pick up plenty just from watching, but you'll be doing yourself a disservice if you don't download our more than 100 custom-built Excel practice files specifically designed to help you master the program.

 

We're not done adding all our content yet, either.  This class was initially created an "intro" course, but it will soon become a complete coverage of all things data analysis in Excel.  

 

In conclusion, does any of the following apply to you?

 

    1.     Do you want to really know your way around Excel?

    2.     You have data for your work or business but you're not sure what to make of it?

    3.     You might know your way around Excel but you're not confident about turning data into business insights

    4.     You frequently receive Excel spreadsheets from others but want to better understand how they arrived at their conclusions?

    5.     You want to learn the best practices when it comes to using Excel for data analysis.

    6.     You are intimidated by spreadsheets and terms like Pivot Tables and VLookups

    7.     You want to learn a skill set that is useful for any role in any industry you get into later.

 


If so, then take charge and take our course.

You have absolutely ZERO risk. Udemy gives you a solid-as-an-oak-tree 30-day money back guarantee.  You have nothing to lose and everything to gain.

So if you're ready to go from data deficient to data proficient, enroll now!

 

 

The Intensive 2021 Python & Data Analysis Libraries Diploma

Build your Practical Python Programming Skills for Data Handling, Analysis and Visualization with Real Examples

Created by Ahmed Ibrahim - Software Development Engineer | Software Engineering Coach

"]

Students: 46456, Price: $94.99

Students: 46456, Price:  Paid

Hello and welcome to "The Intensive 2021 Python & Data Analysis Libraries Diploma".

Data science is a huge field, and one of the promising fields that is spreading in a fast way, also, it is one of the very rewarding, and it is increasing in expansion day by day, due to its great importance and benefits, as it is the future.

Data science enables companies to measure, track, and record performance metrics for facilitating and enhancing decision making. Companies can analyze trends to make critical decisions to engage customers better, enhance company performance, and increase profitability.

And the employment of data science and its tools depends on the purpose you want from them.

For example, using data science in health care is very different from using data science in finance and accounting, and so on. And I’ll show you the core libraries for data handling, analysis and visualization which you can use in different areas.

One of the most powerful programming languages ​​that are used for Data science is Python, which is an easy, simple and very powerful language with many libraries and packages that facilitate working on complex and different types of data.

This course you will cover:

  • Python tools for Data Analysis

  • Python Basics

  • Python Fundamentals

  • Python Object-Oriented

  • Advanced Python Foundations

  • Data Handling with Python

  • Numerical Python(NumPy)

  • Data Analysis with Pandas

  • Data Visualization with Matplotlib

  • Advanced Graphs with Seaborn

  • Instructor QA Support and Help

HD Video Training + Working Files + Resources + QA Support.

In this course, you will learn how to code in Python from the beginning and then you will master how to deal with the most famous libraries and tools of the Python language related to data science, starting from data collection, acquiring and analysis to visualize data with advanced techniques, and based on that, the necessary decisions are taken by companies.

I am Ahmed Ibrahim, a software engineer and Instructor and I have taught more than 200,000 engineers and developers around the world in topics related to programming languages ​​and their applications, and in this course, we will dive deeply into the core Python fundamentals, Advanced Foundations, Data handling libraries, Numerical Python, Pandas, Matplotlib and finally Seaborn.

I hope that you will join us in this course to master the Python language for data analysis and Visualization like professionals in this field.

We have a lot to cover in this course.

Let’s get started!

Microsoft Excel Data Analysis and Dashboard Reporting

Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel Instructor

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 36764, Price: $99.99

Students: 36764, Price:  Paid

Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.

The Excel Analysis and Dashboard Reporting course covers some of the most popular data analysis Excel functions and Dashboard tools, including;

  • VLOOKUP() Function for Looking up Information
  • INDEX()/MATCH() Functions a Powerful Alternative to VLOOKUP
  • TEXT() Function for Formatting
  • CHOOSE() for Ultimate Flexibility in Presenting Data
  • Advanced Filtering
  • Summarizing Data with PivotTables and Pivot Charts
  • Interactive Features to Create User Friendly Reports
  • VBA Magic to Create Dynamic Content
  • and more...


What's Included in the Course:

  • 30+ Video Lectures to Follow Along and Practice the Concepts of Excel Data Analysis and Dashboard Reporting
  • Downloadable Exercise Files
  • Instructor Support through the QA Section Found within the Course - Ask Your Questions!
  • Build a Real World Excel Dashboard
  • 30 Day Money Back Guarantee

Join me in this course and take your Microsoft Excel skills to new heights. The skills you learn will help streamline your efforts in managing and presenting Microsoft Excel data.

See you in the course!

Master Data Analysis with Python – Intro to Pandas

Begin your data analysis journey with Python by mastering the fundamentals of the pandas library

Created by Ted Petrou - Author of Pandas Cookbook, Founder of Dunder Data

"]

Students: 34773, Price: Free

Students: 34773, Price:  Free

Master Data Analysis with Python - Intro to Pandas targets those who want to completely master doing data analysis with pandas. This course provides an introduction to the components of the two primary pandas objects, the DataFrame and Series, and how to select subsets of data from them.

This course is taught by expert instructor Ted Petrou, author of the highly-rated book Pandas Cookbook. Ted has taught over 1,000 hours of live in-person data science courses that use the pandas library. Pandas is a difficult library to use effectively and is often taught incorrectly with poor practices. Ted is extremely adept at using pandas and is known for developing best practices on how to use the library.

There are nearly 50 exercises available to help practice the material taught from the lectures. Detailed video and text solutions for each of the exercises are available so that you can see exactly how Ted thinks through the exercises to arrive at a solution.

All of the material and exercises are written in Jupyter Notebooks, which you will be able to download. This allows you to read the notes, run the code, and write solutions to the exercises all in a single place. Additionally, the full contents of the course are available as a 120-page document giving you access to the material from anywhere.

This course targets those who have an interest in becoming experts and completely mastering the pandas library for data analysis in a professional environment. This course does not cover all of the pandas library, just a small and fundamental portion of it. If you are looking for a brief introduction of the entire pandas library, this course is not it. It takes many dozens of hours, lots of practice, and rigorous understanding to be successful using pandas for data analysis.

This course assumes no previous pandas experience. The only prerequisite knowledge is to understand the fundamentals of Python.

This course is the first from the 10-part series Master Data Analysis with Python. The second part is titled Master Data Analysis with Python - Essential Pandas Commands.

Learn Data Analysis using Pandas and Python (Module 2/3)

Analyze and Manipulate data using using Python and powerful Pandas.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 33276, Price: Free

Students: 33276, Price:  Free

Are you completely new to Data science?

Have you been hearing these buzz words like Machine learning, Data Science, Data Scientist, Text analytics, Statistics and don't know what this is?

Do you want to start or switch career to Data Science and analytics?

If yes, then I have a new course for you. This is module # 2 of the Data Science series. In this course, I cover the absolute basics data analysis and manipulation techniques using Pandas. This course will not cover every syntax available in Pandas, but will take you a level where you can do basic to intermediate data analysis, before proceeding towards feeding it to a data science algorithm.

If are you new to data science, I would recommend you to please take Module # 1(Introduction to Data Science using Python) before starting with this course. We will go through commonly used terms and write plenty of code in Python. I spend some time walking you through different career areas in the Business Intelligence Stack, where does Data Science fit in, What is Data Science and what are the tools you will need to get started.

I will be using Python and Pandas in a series of such courses. I am not assuming any prior knowledge in this area. I have given some reading materials, which will help you solidify the concepts that are discussed in this lectures.

This course will the second data science course in a series of courses. Consider this course as a 101 level data manipulation course, where I cover enough to raise your curiosity in the field of Data Science and Analytics.

The other modules will cover more complex concepts. 

Data Analysis & Visualization: Python | Excel | BI | Tableau

Connect to data, clean & transform data, analyse and visualize data.

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 30366, Price: $49.99

Students: 30366, Price:  Paid

As a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database, telemetry data from services that you use, to signals that you get from different areas like social media.

For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site, the aisles you purchase products from, your spending habits, and much more.

With data and information as the most strategic asset of a business, the underlying challenge that organizations have today is understanding and using their data to positively effect change within the business. Businesses continue to struggle to use their data in a meaningful and productive way, which impacts their ability to act.

The key to unlocking this data is being able to tell a story with it. In today's highly competitive and fast-paced business world, crafting reports that tell that story is what helps business leaders take action on the data. Business decision makers depend on an accurate story to drive better business decisions. The faster a business can make precise decisions, the more competitive they will be and the better advantage they will have. Without the story, it is difficult to understand what the data is trying to tell you.

However, having data alone is not enough. You need to be able to act on the data to effect change within the business. That action could involve reallocating resources within the business to accommodate a need, or it could be identifying a failing campaign and knowing when to change course. These situations are where telling a story with your data is important.

Python is a popular programming language.

It is used for:

  • web development (server-side),

  • software development,

  • mathematics,

  • Data Analysis

  • Data Visualization

  • System scripting.

  • Python can be used for data analysis and visualization.

Data analysis is the process of  analysing, interpreting, data to discover valuable insights that drive smarter and more effective business decisions.

Data analysis tools are used to extract useful information from business and other types of  data, and help make the data analysis process easier.

Data visualisation is the graphical representation of information and data.

By using visual elements like charts, graphs and maps, data visualisation tools

provide an accessible way to see and understand trends, outliers and patterns in data.

The Jupyter Notebook is an open-source web application that allows you to create and share documents that contain live code, equations, visualizations and narrative text. Uses include: data cleaning and transformation, numerical simulation, statistical modelling, data visualization, machine learning, and much more.

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.

Power BI consists of several elements that all work together, starting with these three basics:

  • A Windows desktop application called Power BI Desktop.

  • An online SaaS (Software as a Service) service called the Power BI service.

  • Power BI mobile apps for Windows, iOS, and Android devices.

These three elements—Power BI Desktop, the service, and the mobile apps—are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively.

Beyond those three, Power BI also features two other elements:

  • Power BI Report Builder, for creating paginated reports to share in the Power BI service. Read more about paginated reports later in this article.

  • Power BI Report Server, an on-premises report server where you can publish your Power BI reports, after creating them in Power BI Desktop.

Tableau is a widely used business intelligence (BI) and analytics software trusted by companies like Amazon, Experian, and Unilever to explore, visualize, and securely share data in the form of Workbooks and Dashboards. With its user-friendly drag-and-drop functionality it can be used by everyone to quickly clean, analyze, and visualize your team’s data. You’ll learn how to navigate Tableau’s interface and connect and present data using easy-to-understand visualizations. By the end of this training, you’ll have the skills you need to confidently explore Tableau and build impactful data dashboards.

Python for Time Series Data Analysis

Learn how to use Python , Pandas, Numpy , and Statsmodels for Time Series Forecasting and Analysis!

Created by Jose Portilla - Head of Data Science, Pierian Data Inc.

"]

Students: 28428, Price: $109.99

Students: 28428, Price:  Paid

Welcome to the best online resource for learning how to use the Python programming Language for Time Series Analysis!

This course will teach you everything you need to know to use Python for forecasting time series data to predict new future data points.

We'll start off with the basics by teaching you how to work with and manipulate data using the NumPy and Pandas libraries with Python. Then we'll dive deeper into working with Pandas by learning about visualizations with the Pandas library and how to work with time stamped data with Pandas and Python.

Then we'll begin to learn about the statsmodels library and its powerful built in Time Series Analysis Tools. Including learning about Error-Trend-Seasonality decomposition and basic Holt-Winters methods.

Afterwards we'll get to the heart of the course, covering general forecasting models. We'll talk about creating AutoCorrelation and Partial AutoCorrelation charts and using them in conjunction with powerful ARIMA based models, including Seasonal ARIMA models and SARIMAX to include Exogenous data points.

Afterwards we'll learn about state of the art Deep Learning techniques with Recurrent Neural Networks that use deep learning to forecast future data points.

This course even covers Facebook's Prophet library, a simple to use, yet powerful Python library developed to forecast into the future with time series data.

So what are you waiting for! Learn how to work with your time series data and forecast the future!

We'll see you inside the course!

SQL for Data Analysis: Beginner MySQL Business Intelligence

Learn SQL database querying w/ MySQL Workbench. Perfect for SQL beginners and first-time coders.

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 27830, Price: $139.99

Students: 27830, Price:  Paid

See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:

"Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!"

- Maggi M.

"I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"John's deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!"

- Steven M.

______________________________

SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal.

In this course, you’ll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.

But don't worry, you're not alone! We'll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL and database analysis skills along the way.

______________________________

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    We’ll start with a quick intro to the SQL landscape and it's common "flavors" (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we'll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)

  • SQL Database Fundamentals (Part 1)

    Once we have our tools installed, we'll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions.

  • Analyzing Data from Single Tables with MySQL

    In this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data.

    [MID-COURSE MYSQL PROJECT]

  • SQL Database Fundamentals (Part 2)

    The second half of the course is all about anayzing data from multiple tables in MySQL, so we'll begin with a quick review of relational databases and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc.

  • Analyzing Multiple Tables via MySQL JOINS

    In this section, we'll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.

    [FINAL MYSQL PROJECT]

IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course).

______________________________

Enroll today and get LIFETIME access to:

  • 5+ hours of high-quality video

  • Downloadable MySQL ebook

  • Quizzes and homework assignments

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

If you’re looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you!

Happy analyzing!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Fundamentals Data Analysis & Decision Making Models – Theory

Master handling Big Data, Analysis and presenting interactive DashBoards. Forecasting and

Created by Manish Gupta - Hospitality Finance Expert and Business Strategist

"]

Students: 25482, Price: Free

Students: 25482, Price:  Free

 Do you want to understand how big data is analysed and how decisions are made based on big data.

In this course we will be covering the various steps involved in data analysis in brief, Objective of this course to make you familiar with these steps and collect your feedbacks and questions.

I will then use those feedback and questions to make the detailed course better and relevant for you.

SQL Data Analysis – Learn SQL by Doing!

Skyrocket your SQL skills by working on 12 real-world projects, and solving over 150 analysis tasks

Created by Ram Kedem - Owner and Lead Consultant at RamKedem.com

"]

Students: 23555, Price: $29.99

Students: 23555, Price:  Paid

  • Learn SQL data analysis by actually analyzing data :)  This course is by-far the most intensive course available, if your aim is to gain a real hands-on experience. We believe that there’s a HUGE gap between understanding something, and actually knowing how to use it. And this is what this course is all about - helping you master SQL by getting your hands dirty.

  • Build Strong Analytical Skills - During this course you'll be performing more than 150 analysis tasks over 12 different case studies, designed to help you build powerful, job-ready analytics skills.

  • Develop your own "Data Intuition" - By being exposed to so many data-sets, not only you'll build firm SQL skills, but also develop your own “data intuition”, something that has to be earned by hard work.

  • Earn a certificate that really tells how well you know SQL - By finishing up this course, you're entitled to a Certificate of Completion. Now, this course is far from being a one you complete as passive listener :), our Certificate of Completion shows the dedication, willingness to take the extra mile, and experience a student gained in order to learn SQL.

  • Learn how to think like a data analyst - This course is also teaching you how to think like a data analyst! We've included video solutions to many of our exercises, so you'll understand how an experienced data analyst would approach a problem and solve it!

  • Learn from expert data professionals - We're working in the field of data for more than 15 years. What you're about to learn in this course is real SQL applications based on real experience, in addition to the "formal syllabus", this course covers subject such as:

    • How to write a "clean" and understandable queries

    • How to think and approach a problem like a data analyst

    • How to use each SQL clause effectively

    • Practical implementations 

  • We really love teaching - Teaching is also something we do for more than a decade, with thousands of satisfied students from all around the globe we can guarantee a fun, easy-to-understand, well designed course.

  • Cross platform environment - This course is a cross-platform, meaning it is suitable for MySQL, SQL Server and PostgreSQL. Even if today your main focus is MySQL for instance, this course will serve you well in the future should you start working with different database environment

You bring the discipline and commitment, we'll take care of everything else :)

Check out the free preview videos for more information!

Advanced SQL: MySQL Data Analysis & Business Intelligence

Master advanced SQL database coding w/ MySQL Workbench. My SQL course takes your SQL analysis skills to new heights!

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 23339, Price: $129.99

Students: 23339, Price:  Paid

IMPORTANT NOTE: This is an advanced SQL course, which builds on the skills covered in our introductory MySQL courses. Please review the prerequisite skills or complete the beginner SQL course before taking this one!

______________________________

See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:

"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"This is an excellent advanced course! I've taken both SQL courses from Maven Analytics and highly recommend both. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!"

- Dan S.

"John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"

- Steven M.

______________________________

COURSE DESCRIPTION:

If you want to develop practical, real-world analytics & BI skills using advanced SQL, you're in the right place.

This course is unlike anything you’ve seen before, guaranteed. Instead of using random sample data and obscure demos, we’ll be working with a rich, custom-built eCommerce database that we’ve designed from scratch to help you apply your SQL skills to real projects and learn how to truly THINK like an analyst.

You’ll be playing the role of a newly hired Database Analyst for Maven Fuzzy Factory, an eCommerce start-up, and will be working directly with the CEO, Marketing Director and Website Manager to help grow the business and analyze performance along the way. You'll use a range of advanced SQL tools and techniques, and work through actual projects that data analysts and business intelligence professionals work on every day.

______________________________

COURSE OUTLINE:

  • Prerequisite SQL Skills Assessment

    In this section we'll address the core SQL/MySQL skills that you should be comfortable with before starting the course, including SELECT statements, aggregate functions, and table joins. If you aren't sure how your skills stack up, we've included a quiz to assess your baseline SQL knowledge.

  • MySQL Setup & Install

    For students who haven't completed our intro course, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course.

  • Traffic Analysis & Optimization

    In this section we’ll use MySQL to analyze where our website traffic is coming from, how different sources perform in terms of traffic volume and conversion rates, and how we can adjust bids to optimize our budgets.

  • Website Measurement & Testing

    In this section we'll dive into page-level website data to compare traffic and conversion rates, and use MySQL to build and analyze conversion funnels to help optimize the customer purchase experience.

    ***MID-COURSE PROJECT: Preparing data for the executive board meeting

  • Channel Analysis & Optimization

    In this section we’ll dig deeper into our traffic channel mix, explore paid vs. free traffic, break down performance by device type, and write advanced SQL queries to conduct some time-series analyses to understand trending and seasonality.

  • Product-Level Analysis

    In this section we’ll use MySQL to break down product-level sales and conversion rates, analyze cross-selling patterns, and use refund rates to keep a pulse on quality.

  • User-Level Analysis

    In this section we’ll take a closer look at user behavior and repeat sessions, and use MySQL techniques to identify our most valuable customers and explore which channels they are coming from.

    ***FINAL PROJECT: Building a data-driven growth story for potential investors

______________________________

Unlike other SQL courses, this one is uniquely designed to sharpen your business intelligence and analytical thinking skills; as you complete course projects and exercises, you’ll actually see patterns and trends emerging in the data based on your findings. For those looking to pursue a career in analytics, this course is a must.

Enroll today and get LIFETIME access to:

  • 8+ hours of high-quality video

  • Downloadable MySQL ebook

  • Quizzes and hands-on projects

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course).

Happy analyzing!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Complete Introduction to Business Data Analysis

Move beyond BASIC reports and learn data ANALYSIS. Learn to easily turn data into information, insight and intelligence

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 22795, Price: $99.99

Students: 22795, Price:  Paid

If you want to learn simple, effective techniques to create impactful Excel Dashboards and Data Analysis, this course is ideal. Updated in 2021 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!

"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"

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 125 000 enrollments & 100 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.  ****

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.

Business Data Analysis with Microsoft Excel and Power BI

An in-depth training on Excel and Power BI for busy professionals who use Excel a lot at work.

Created by Michael Olafusi - 6x Microsoft MVP, Financial Modeler & BI Professional

"]

Students: 20076, Price: $59.99

Students: 20076, Price:  Paid

**** Important Notice *********************************

We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!

*************************************************************

Microsoft Excel is the world's most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent and indispensable partner in the organization's progress. And, hopefully, it will lead to a much greater career role and opportunity for you.

Power BI is Microsoft's business intelligence and dashboarding tool that enables organizations to have a wholesome understanding of what is happening at all operational levels of the company. With it you can create reports with drill down features, access-level restrictions, auto-refresh, alerts/triggers and interactivity.

This training is going to focus on making you highly proficient in the use of Excel and Power BI for business data analysis, dashboard creation and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you'll need at work.

Excel Data Analysis Masterclass with Excel Dashboards

Master Advanced MS Excel topics - Excel Formulas, Excel Formatting, Excel Pivot Tables, Excel Dashboards & Analytics

Created by Data Is Good Academy - An Google, Facebook, Kaggle Grandmasters team

"]

Students: 19838, Price: $19.99

Students: 19838, Price:  Paid

Welcome to the best online course on Excel.

Microsoft Excel is one of the most used software applications of all time.

Hundreds of millions of people around the world use Excel.

It is a very handy software that can be used to store and organize many datasets.

Using its features and formulas, one can use the tool to make send of the data.

This course provides you functionalities of excel used by data scientists and data analysts along with its basics.

You will learn to create interactive dashboards using excel.

In this course, you will cover:-

  • Basic formatting in excel

  • Datatypes of excel

  • Insertion and deletion of new rows and columns in excel.

  • Sorting and filtering data in excel

  • Learn about the different text functions- UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, TRIM, CONCATENATE, LEN

  • Learn about the different statistical functions- MIN, MAX, AVERAGE.

  • Finding different percentiles.

  • Finding missing values in data

  • Finding outliers in data

  • Learn about the different logical functions- IF, IFERROR, COUNTIF, SUMIF, AVERAGEIF.

  • Learn about conditional formatting.

  • Learn about lookup functions- VLOOKUP, HLOOKUP.

  • Learn about index and match

  • Learn to create pivot tables and pivot charts.

  • Learn to create interactive dashboards.

  • Learn about What-if Analysis:- Goal Seek analysis, Data Tables, Scenario Management.

  • Learn about performing linear regression in excel.

  • Advanced Filtering

Not only this, you will get to practice a lot of exercises on these topics.

We are also providing quizzes.

You will also have access to all the resources used in this course.

Instructor Support - Quick Instructor Support for any queries.

I'm looking forward to see you in the course!

Enroll now and make the best use of this course.

The Ultimate Pandas Bootcamp: Advanced Python Data Analysis

Master the powerful pandas library to analyze, manipulate and visualize data. More than 10 datasets & bonuses included!

Created by Andy Bek - Software Consultant

"]

Students: 19513, Price: $99.99

Students: 19513, Price:  Paid

Welcome to the best resource online for learning and mastering data analysis with pandas and python.

Over 32 hours, 10+ datasets, and 50+ skill challenges, you will gain hands-on mastery of, not only pandas 1.x, but also tens of computer science, statistics, and programming concepts.

We will break down, understand, and practice hundreds of methods, attributes, and techniques in pandas and python that will fundamentally change the way you work with data.

In The Ultimate Pandas Bootcamp (2021) you won’t be working with outdated versions of pandas, writing repetitive commands on the same boring dataset. Instead, you’ll learn pandorable and pythonic solutions to interesting, real-world data problems, while working with many diverse datasets that range from wine servings, video game sales, and SAT scores to stock prices, college salaries and more!

Data analysis is an applied science, which is why in each section, you’ll stop and practice what you learn in dedicated skill challenges, followed by detailed solutions where we often consider and compare alternative solutions.

Data analysis is one of the most in-demand skill across all industries and an increasing number of roles. And python is increasingly the language of choice.

Pandas is the wonderful open-source library that is the embodiment of those trends: based on the python programming language, pandas is the de facto data analysis library in the python data science community.

––––– Structure & Curriculum –––––

Over more than 31 hours, we'll cover everything that pandas has to offer, from manipulating series and dataframes, to merging datasets, handling time series, aggregations, filtering, sorting and much more!

The first four sections of the bootcamp constitute the core curriculum. You'll get acquainted with series and dataframes and develop an in-depth understanding of pandas data structures.

· Series at a Glance

· Series Methods and Handling

· Introducing DataFrames

· DataFrames More In Depth

In the next eight sections, you will dive into more advanced topics and take your pandas skills to another level, learning how to work with multiple datasets, manipulate time series, visualize data, write custom functions to transform data and much more.

· Working With Multiple DataFrames

· Going MultiDimensional

· GroupBy And Aggregates

· Reshaping With Pivots

· Working With Dates And Time

· Regular Expressions And Text Manipulation

· Visualizing Data

· Data Formats And I/O

Pandas and python go hand-in-hand which is why this bootcamp also includes a full-length introduction to the python programming language, to get you up and running writing pythonic code in no time.

This is the ultimate course on one of the most-valuable skills today. I hope you commit to mastering data analysis with pandas.

See you inside!

Introduction to Data Analysis for Government

Get started on your journey to become a government data analysis rockstar.

Created by Socrata Data Academy - Teaching program leaders and government information workers how to analyze data and proficiently use modern data analysis technologies

"]

Students: 16860, Price: Free

Students: 16860, Price:  Free

Data has exploded in the last few years, but educational resources for government information workers to take advantage of that data to improve program outcomes haven't kept up. This first course in the series Fundamentals of Data Analysis for Government focuses on the key components of setting up and executing a data analysis project.

What You'll Learn in this Course

  • How to frame a data analysis project
  • The power of simple descriptive statistics to guide decision making
  • Examples of data being effectively used in the public sector
  • Methods to download, evaluate, clean, and analyze data using Excel
  • How you can be influenced by biases, and can unintentionally introduce them into your analysis
  • The difference between structured, machine-readable data and unstructured, human-readable data

Contents and Overview

This course is ideal for government employees who have a strong qualitative understanding of their work but have yet to master the quantitative skills needed to leverage data in their day-to-day responsibilities. Through ~25 lectures and ~2 hours worth of content, you'll learn all of the fundamentals of government data analysis and establish a strong understanding of the concepts behind using data. Each chapter contains proficiency quizzes and hands-on exercises to practice while you're learning.

Starting with a high-level overview of a data analysis project framework, this course will take you through identifying the actual problem to solve, exploring and defining a conceptual model around the problem, analyzing data to support or reject that model, then communicating insights found from the data analysis to address the problem at hand. Students will see all steps of the framework completed through the lens of a real-world data project done in the City of New Orleans.

Students completing the course will have the knowledge to analyze data and utilize it to improve government program delivery.

With these basics mastered, students are able to continue their learning through the Socrata Data Academy courses online.

SQL for Data Analysis: Solving real-world problems with data

A simple & concise mySQL course (applicable to any SQL), perfect for data analysis, data science, business intelligence.

Created by Max SQL - Data and Insights Manager

"]

Students: 16662, Price: Free

Students: 16662, Price:  Free

Note on the Short Version of the Course

I have launched the course as a free, shortened version. It is an excellent introduction to the basics of handling data. Two points I want you to know:

1. The course so far is an in-depth view on a small & important part of SQL, rather than a light-touch overview of everything.

2. Technically, the full paid version is on the way. But I am finding it very difficult to find the time to complete the lessons (between other projects and work).

Therefore for those who need a comprehensive course now, I'd suggest signing up to a couple of courses now including this one while it's free. That way you can learn now but also enjoy all the additional lessons for free when they arrive.

Note on the Communicating

Udemy prevents instructors of Free courses from answering any questions from students. Therefore for now I cannot provide any feedback or respond to comments.

Summary

Forget the dry, old, textbook approach to learning code. Forget endlessly drilling syntax.

This course puts SQL in context and gets you solving real-world business problems from Day 1.

You'll play the role of a data analyst at Australia's largest fictional consumer bank, with a uniquely rich relational database at your fingertips. This context brings SQL to life and makes it easier for you to understand deeply and quickly.

With this new approach, you'll be surprised to see that SQL is fun and simple to learn. My course guarantee is that you'll go from zero to functional SQL coder within the weekend.

Best features in a nutshell

  • In plain English, with business context and fun analogies to explain the otherwise dry syntax.

  • Unique database, using a fictional bank relational database with incredibly rich transaction data to keep the course interesting and relevant.

  • Focuses deep on the absolute basics, to get you the strong foundations required for a data career.

  • Doesn’t cost money! If you sign up now while it’s free, you have lifetime free access, even as the course grows and becomes paid.

Read on for more detail

My story and building the course

My SQL learning experience was not ideal. When I started work I hadn’t the slightest idea what data was, let alone the power it brings to those who wield it skillfully. I took probably a year longer than necessary to master the SQL for data analytics. Even though I was practicing everyday on the job, I was slow to understand new concepts and struggled to remember new syntax.

Now as a full-time data analytics and insights manager, I have the hindsight to know it should have been much easier.

The main ingredients missing for me were:

  1. Structure

    1. What is important, what isn't, and why.

  2. Context

    1. Analogies, interesting examples, and plain English explanations. Bringing it to life!

So I’ve taken what was lacking in my learning experience and build a course around it. Specifically, here’s why my course stands out:

  • Structured

    • We learn what you need for on the job data analysis using SQL, no more less.

    • The topics are covered in an order that makes sense and helps you build on past learning.

    • You understand why each lesson is important, where it sits in the grand scheme of SQL.

  • In context

    • SQL shouldn’t have to be dry or boring, so I have used realistic business problems and analogies.

    • You’ll be playing the role of a data analyst at the largest fictional company in Australia, the Royal Bank of Australia, solving problems to drive sales, improve marketing reach, and manage customers.

    • Knowing why you’re learning the syntax, you’ll learn faster.

  • Hands on/practical

    • You’ll practice writing SQL in every single lesson.

We are going to have fun too, investigating cryptocurrency trading among customers, and even learning about Australian animals!

Why learn SQL?

Most successful companies today are data-driven.

  • They record every bit of information about their business (e.g. customers, sales).

  • They store that information (called data) in complex databases.

  • And they draw insights from the data to improve their business.

That’s where SQL comes in.

The only way to gather data and transform it into valuable business insights is to combine SQL and a smart analyst like you.

It's with SQL that companies know answers all sorts of where do my customers prefer to shop? Who was incorrectly charged fees? Why are sales going down?)

And as you may have noticed in the Promo, SQL is a great skill to build your career

Data careers, in data analysis (business analysis), data science, & data visualisation (business intelligence).

  1. SQL is needed to actually find and handle data in most organisations.

  2. The data handling and management skills learned via SQL are fundamental to understanding data in general, and are useful even if you don't use the SQL language (rare).

  3. Access to data can make you powerful in organisations. It's hard to argue with an analyst armed with well-prepped data and a solid numbers-based argument.

Marketing, product management, and tech sales:

  1. SQL (and the accompanying data skills) are a great way to stand out in marketing and product.

  2. Marketers and product managers propose changes to improve the business.

  3. Nowadays, any proposed change needs a strong case to support it.

  4. Data is the foundation of any strong business case.

  5. Therefore marketers and product managers with data skills can put together stronger cases, get more initiatives approved, and grow their career faster.

Why start with mySQL? mySQL is:

  • Very common, used by major companies and organisations across the world, such as Uber, Netflix, Spotify, and JPMorgan.

  • Free and easy to set up.

  • Similar to other forms of SQL like Microsoft SQL Server, PostGre SQL, Oracle SQL, Teradata SQL.

Microsoft Excel Data Analysis – Learn How The Experts Use It

Learn the analytics capabilities of Excel and its add-ins, like PowerPivot & How it is used by business data analysts.

Created by New Horizon - An industry leading training provider for 2 decades!

"]

Students: 15847, Price: $99.99

Students: 15847, Price:  Paid

Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. Having a deep practical knowledge of Excel will greatly increase your productivity. You will be seen as a very skilled business data analyst in the organization. And will lead to a much greater opportunities for you.

Excel is the number-one spreadsheet application, with a plethora of capabilities. If you're only using the basic features, you're missing out on a host of features that can benefit your business by uncovering important information hidden within raw data. This Excel Data Analysis course allows you to harness the full power of Excel to do all the heavy lifting for you.

The course, comprised of 3+ hours of video training, guides you through the basic and advanced features of Excel to help you discover the gems hidden inside. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst.

Statistics for Data Analysis Using Excel 2016

Plain & Simple Lessons on Descriptive & Inferential Statistics Theory With Excel Examples for Business & Six Sigma

Created by Sandeep Kumar ­ - Experienced Quality Manager • Six Sigma Coach • Consultant

"]

Students: 13142, Price: $19.99

Students: 13142, Price:  Paid

Start loving data and making sense of it. Leverage the power of MS Excel to make it easy!

Learn statistics, and apply these concepts in your work place using Microsoft Excel.

This course is about Statistics and Data Analysis. The course will teach you the basic concepts related to Statistics and Data Analysis, and help you in applying these concept. Various examples and data-sets are used to explain the application.

I will explain the basic theory first, and then I will show you how to use Microsoft Excel to perform these calculations.

Following areas of statistics are covered:

Descriptive Statistics - Mean, Mode, Median, Quartile, Range, Inter Quartile Range, Standard Deviation

Data Visualization - 3 commonly used charts: Histogram, Box and Whisker Plot and Scatter Plot

Probability - Basic Concepts, Permutations, Combinations

Population and Sampling

Probability Distributions - Normal, Binomial and Poisson Distributions

Hypothesis Testing - One Sample and Two Samples - z Test, t Test, p Test, F Test, Chi Square Test

ANOVA - Perform Analysis of Variance (ANOVA) step by step doing manual calculation and by MS Excel.

Data Visualization in Python Masterclass™ for Data Scientist

Matplotlib for Data Visualization and analysis with Python 2021 Edition

Created by Abbosjon Madiev - Computer Scientist

"]

Students: 12318, Price: Free

Students: 12318, Price:  Free

The only way to truly learn how to use Matplotlib for Data Visualization with Python is by actually getting your hands dirty and trying out the features yourself. That’s where this course comes in!

The hour-long course starts off with an introduction to Matplotlib, including how to install and import it in Python. We will then move on to learn how you can create and customize basic 2D charts in order to best tell your story. Furthermore, you will also learn what subplots are and how you can create as well as customize them with the help of the Matplotlib library.

We will explore the full spectrum of interactive and explorable graphic representations including various plots such as Scatter, Line, Bar, Stacked Bar, Histogram, Pie, and much more. The course also walks you through the basics of creating a 3D plot in Matplotlib and how you can start plotting images using the Python visualization library.

And, once you are done with this course, you will be able to create almost any kind of plot that you need with Matplotlib and Python.

Why you should take this course?

  • Updated 2021 course content: All our course content is updated as per the latest version of the Matplotlib library.

  • Practical hands-on knowledge: This course is oriented to providing a step-by-step implementation guide for making amazing data visualization plots rather than just sticking to the theory.

  • Guided support: We are always there to guide you through the Q/As so feel free to ask us your queries