Data Analytics Courses: A Curated List

Link to original article where the list is updated periodically.

We’ve curated a list of online, self-paced courses from the Udemy learning platform that are dedicated to teaching in-demand skills for analytics professionals. We’ve listed courses that adhere to the following criteria (including one course from yours truly on business analytics at the bottom of the list):

• Have high review scores and many reviews. This ensures that the overall review score is a reliable value.
• Have an instructor whose voice is easily understood.
• Teaches a skill that is highly relevant in today’s job market.

I’ve included the rating score by current students for each course. Ratings are on a 5-point scale.

Udemy frequently discounts courses, so feel free to bookmark the location of my LIVE list and check occasionally for a sale price. I will update the list periodically to add new resources at this web page location.

Now, on to the list…

Power BI

Power BI Complete Introduction

Public Rating 4.5

What you'll learn

• At the end of this course students will be able to analyse data from different data sources and create their own datasets
• Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
• Students will have the required knowledge to dive deeper into Power BI and find out more about its advanced features

Up and Running with Power BI Desktop

Public Rating 4.6

What you'll learn

• Build professional-quality business intelligence reports from the ground up
• Blend and transform raw data into beautiful interactive dashboards
• Design and implement the same B.I. tools used by professional analysts and data scientists
• Showcase your skills with two full-scale course projects (with step-by-step solutions)
• Understand the business intelligence workflow from end-to-end
• Learn from a best-selling instructor and professional BI developer

Powerful Reports and Dashboards with Microsoft Power BI

Public Rating 4.5

What you'll learn

• lessons from a best selling Udemy instructor
• Learn to create POWERFUL reports and dashboards with Microsoft PowerBI with a few clicks of the mouse
• Gain valuable INSIGHT and INTELLIGENCE from your business and marketing data in a FRACTION of the time of traditional spreadsheets
• PUBLISH reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes
• Learn to create Data Models and use the DAX Formula language to develop POWERFUL calculations
• Easily create a wide range of GRAPHS and VISUALISATIONS using drag and drop technologies
• Use the Power BI Q & A feature to easily ask QUESTIONS of your data and provide new insight

Publishing to Power BI Service

Public Rating 4.6

What you'll learn

• Publish professional-quality business intelligence reports to the cloud
• Automate reports and dashboards with gateways, dataflows, and scheduled refresh
• Explore and analyze data with natural language Q&A, quick insights, bookmarks and data-driven alerts
• Collaborate and share with other users and teams online and in real time
• Configure user roles and row-level security to maintain data quality and control
• Master the same tools and techniques used by top BI professionals

Tableau

Tableau 10: Hands on Tableau Training (Note: Tableau 10 is a few versions ago but the majority of the content applies to the most recent version as well.)

Public Rating 4.6

• Install Tableau Desktop 10
• Connect Tableau to various Datasets: Excel and CSV files
• Create Barcharts
• Create Area Charts
• Create Maps
• Create Scatterplots
• Create Piecharts
• Create Treemaps
• Create Interactive Dashboards
• Create Storylines
• Understand Types of Joins and how they work
• Work with Data Blending in Tableau
• Create Table Calculations
• Work with Parameters
• Create Dual Axis Charts
• Create Calculated Fields
• Create Calculated Fields in a Blend
• Export Results from Tableau into Powerpoint, Word, and other software
• Work with Time Series Data (two methods)
• Creating Data Extracts in Tableau
• Understand Aggregation, Granularity, and Level of Detail
• Adding Filters and Quick Filters
• Create Data Hierarchies
• Adding Actions to Dashboards (filters & highlighting)

Tableau 10 Advanced

Public Rating 4.7

What you'll learn

• Create and use Groups
• Understand the difference between Groups and Sets
• Create and use Static Sets
• Create and use Dynamic Sets
• Combine Sets into more Sets
• Use Sets as filters
• Create Sets via Formulas
• Control Sets with Parameters
• Control Reference Lines with Parameters
• Use multiple fields in the colour property
• Create highly interactive Dashboards
• Develop an intrinsic understanding of how table calculations work
• Use Quick Table calculations
• Write your own Table calculations
• Combine multiple layers of Table Calculations
• Use Table Calculations as filters
• Use trendlines to interrogate data
• Perform Data Mining in Tableau
• Create powerful storylines for presentation to Executives
• Create powerful storylines for presentation to Executives
• Understand Level Of Details
• Implement Advanced Mapping Techniques

Tableau - Accelerate Your Career and Get Certified

Public Rating 4.5

What you'll learn

• Sort, filter, slice, pivot, and graph using a Tableau Public, a free version of the market leading visualization tool.
• Combine multiple data sources using joins, blends, and unions.
• Create bar charts, pie charts, and line graphs.
• Create calculated fields with conditional logic.
• Map your data to quickly detect geographic variation.
• Create a dynamic dashboards combining multiple worksheets.
• Create trendlines and understand the relevant statistical metrics such as p-value and R-squared.
• Create forecasts with prediction intervals, accounting for seasonal variability.
• Take two full-length practice exams for the Tableau Desktop Certified Associate Exam.
• Use publicly available data to create visualizations on topics that interest you - anything from the economy to the Olympics.

The Complete Tableau Bootcamp for Data Visualization

Public Rating 4.6

What you'll learn

• Learn the Foundational Elements of Data Visualization, and Apply Them Using Tableau
• Build Professional Business Dashboards to Effectively Convey Patterns and Trends in Your Data
• Learn and Master Level of Detail (LOD) Expressions to Solve Complex Tasks in Data Visualization
• Learn and Master the Usage of Basic Calculations to Solve Common Tasks in Data Visualization
• Learn and Master Table Calculations to Apply Further Transformations to Your Visualization
• Learn to Navigate the Dashboard Workspace, and Customize Your Dashboards to Different Devices
• Learn and Master Tableau’s Mapping Functionality to Answer Spatial Questions
• Learn to Style and Format Maps with Mapbox, WMS, and Dual Axis capabilities
• Learn to Find, and Make of Use of Various Spatial Files in Tableau
• Learn and Master the Usage of Context Filters, Dimension Filters, Top N Filters, and Measure Filters.
• Use Heat Maps to Find Hot Spots in Overlapping Data
• Learn to Add Interactivity to your Plots using Set actions and Parameter Control
• Learn about Different Join types to Combine your Data into a Single Rich Data Source
• Learn to Use Story Points to Tell Stories With Your Data
• Apply Pivots to your Data for Effective Data Processing
• Implement Unions to Combine Multiple Data Sources into One
• Learn About Theoretical Concepts Such as Data Types and Pre-attentive Processing

SQL

mySQL for Data Analytics and Business Intelligence

Public Rating 4.6

What you'll learn

• Become an expert in SQL
• Learn how to code in SQL
• Boost your resume by learning an in-demand skill
• Create, design, and operate with SQL databases
• Start using MySQL – the #1 Database Management System
• Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
• Adopt professionally tested SQL best practices
• Gain theoretical insights about relational databases
• Work with a sophisticated real-life database throughout the course
• Get maximum preparation for real-life database management
• Add data analytical tools to your skillset
• Develop business intuition while solving tasks with big data
• Study relational database management theory that you will need in your workplace every day
• Learn how to create a database from scratch
• The ability to take control of your dataset – insert, update, and delete records from your database
• Be confident while working with constraints and relating data tables
• Become a proficient MySQL Workbench user
• Acquire top-notch coding techniques and best practices

Master SQL for Data Science

Public Rating 4.6

What you'll learn

• Write complex SQL statements to query the database and gain critical insight on data
• Practice Every Step of the Way by Working Through 100+ Puzzles (with solutions)
• Transition from the Very Basics to a Point Where You can Effortlessly Work with Large SQL Queries
• Learn Advanced Querying Techniques
• Become a Master SQL Developer

Advanced SQL - mySQL for Analytics and Business Intelligence

Public Rating 4.6

What you'll learn

• Write advanced SQL queries to explore and analyze databases with MySQL Workbench
• Learn how to use subqueries and temporary tables to handle complex multi-step data problems
• Solve practical hands-on assignments and real-world eCommerce use cases
• Analyze data across multiple tables with powerful MySQL JOIN statements
• Master unique tips and tools that you won't find anywhere else

Forecasting and Integrating Tools

Integrating Python - sql - Tableau

Public Rating 4.4

What you'll learn

• How to use Python, SQL, and Tableau together
• Software integration
• Data preprocessing techniques
• Apply machine learning
• Create a module for later use of the ML model
• Connect Python and SQL to transfer data from Jupyter to Workbench
• Visualize data in Tableau
• Analysis and interpretation of the exercise outputs in Jupyter and Tableau

Time Series Analysis in Python

Public Rating 4.4

• Differentiate between time series data and cross-sectional data.
• Understand the fundamental assumptions of time series data and how to take advantage of them.
• Transforming a data set into a time-series.
• Start coding in Python and learn how to use it for statistical analysis.
• Carry out time-series analysis in Python and interpreting the results, based on the data in question.
• Examine the crucial differences between related series like prices and returns.
• Comprehend the need to normalize data when comparing different time series.
• Encounter special types of time series like White Noise and Random Walks.
• Learn about "autocorrelation" and how to account for it.
• Learn about accounting for "unexpected shocks" via moving averages.
• Discuss model selection in time series and the role residuals play in it.
• Comprehend stationarity and how to test for its existence.
• Acknowledge the notion of integration and understand when, why and how to properly use it.
• Realize the importance of volatility and how we can measure it.
• Forecast the future based on patterns observed in the past.

What you'll learn

The Business Intelligence Analyst Course 2020

Public Rating 4.5

What you'll learn

• Become an expert in Statistics, SQL, Tableau, and problem solving
• Boost your resume with in-demand skills
• Gather, organize, analyze and visualize data
• Use data for improved business decision-making
• Present information in the form of metrics, KPIs, reports, and dashboards
• Perform quantitative and qualitative business analysis
• Analyze current and historical data
• Discover how to find trends, market conditions, and research competitor positioning
• Understand the fundamentals of database theory
• Use SQL to create, design, and manipulate SQL databases
• Extract data from a database writing your own queries
• Create powerful professional visualizations in Tableau
• Combine SQL and Tableau to visualize data from the source
• Solve real-world business analysis tasks in SQL and Tableau

Business Analytics

Business Analytics 101 (A quick, 30-minute course by yours truly)

Pubic Rating 4.4

• How to use data analytics to identify the challenges impacting business performance
• How to read business data and use it for business improvement (profit, supplier delivery, customer service)
• How to select metrics and KPIs to measure what matters to your business
• How to apply data analysis to a variety of business problems and use the results to identify actions/decisions