Learning Path: Data Analyst
By Geoffrey Grosenbach on October 20, 2014
Learning path objective:
You'll learn to use the basic tools needed to go from raw data logs to full featured dashboards. This learning path covers SQL, Excel, Tableau and D3.js, along with the concepts behind data warehousing and business intelligence.
A bit of prior experience with programming and mathematics will help you successfully complete this learning path.
Learning path description:
This learning path starts with the fundamentals, covers the big picture, goes straight into practical visualization tools and ends with a powerful framework for creating custom dashboards. Before you can visualize and present data, you'll need to get it into your database and know how to query it. Introduction to SQL is the starting point for the language, which is used to interact with most business databases.
Next, you'll learn about Relational Database Design as a way to store intermediate data. After that, you'll move directly to a big picture course on storing that data and understanding what business intelligence is all about.
Now comes the fun part! Business Dashboard Fundamentals covers both the aesthetic issues around visual communication and the practical application of these concepts in Microsoft Excel and Tableau. You will then move on to a more in-depth course on one of the most powerful visualization tools available today: Tableau. With all of this under your belt, you'll be ready to tackle Microsoft Excel, the standard for desktop spreadsheets for almost 30 years.
Finally, you'll finish with a lower-level graphics package: D3.js. As one of the most popular projects on GitHub, D3 is used by the The New York Times, Facebook, and many other companies to create custom visualizations and dashboards.
Learning path course sequence:
|Introduction to SQL||3h 22m|
|Relational Database Design||7h 33m|
|Introduction to Data Warehousing and Business Intelligence||1h 13m|
|Business Dashboard Fundamentals||3h 36m|
|Data Analysis Fundamentals with Tableau||4h 47m|
|Excel: An Analytics Superhub||3h 02m|
|D3.js Data Visualization Fundamentals||4h 35m|