Data Analytics

Analytics is the path from raw tables to questions a team can answer without a model yet. This page is that path as a free data analytics course, walked in videos from spreadsheets and dashboards through SQL to Python and Pandas.

Course

The course starts with what the job is before any tool. CareerFoundry's What Is Data Analytics? - An Introduction (Full Guide) is that framing. The spine of the path is Alex The Analyst's playlist: the Intro is FREE Data Analyst Bootcamp!!, and How to plan it is How to Become a Data Analyst in 2023 (Completely FREE!).

The first tools are spreadsheets and dashboards. Excel 21-27 in the playlist starts at Pivot Tables in Excel | Excel Tutorials for Beginners. PowerBI 33-41 starts at How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners. Tableau 23-31 comes from a Simplilearn playlist instead: Tableau Training For Beginners | Tableau Tutorial | Tableau Tutorial For Beginners | Simplilearn.

Dashboards sit on data that lives in a database, so SQL comes next. SQL 3-20 starts at Installing MySQL and Creating Databases | MySQL for Beginners.

The same notes are in SQL.

For SQL questions, the practice video is Solving Easy SQL Interview Questions on Analyst Builder.

The path ends in code. Python 42-56 starts at Installing Jupyter Notebooks/Anaconda | Python for Beginners, and Pandas 57-64 starts at Reading in Files in Pandas | Python Pandas Tutorials. As a single Course that covers the Python side in one sitting, freeCodeCamp.org has Data Analysis with Python Course - Numpy, Pandas, Data Visualization. Simplilearn's Data Analytics Full Course In 5 Hours | Data Analytics For Beginners | Data Analytics | Simplilearn is the long-form alternative, with the author's own verdict: Not sure if needed.