2-data-analyst

Data Analyst Resources

The gate keeper of the business data. They answer situational awareness type questions; what is happening? What are our KPIs? What is the historical trend for sales in region x?

Library Recommendations

• MS Excel Bible 365
• Learning SQL
• Learning Tableau 2022

Cheatsheets

• SQL Tutorial

Spreadsheets

• Beginning Excel 2019
• NYT - spreadsheets for reporters
• Microsoft Excel VBA and Macros

SQL

• Start Here - SQL Tutorial
• Select Star SQL
• SQL Murder Mystery
• SQL Police Department
• SQL Zoo
• SQL Interview Questions
• SQL for Data Science
• SQL for Excel Users
• SQL vs NoSQL
• ERD/RDBMS Diagram Cheatsheet
• SQLite ODBC Driver

Business Intelligence

• VizQL Original Research Paper
• Tableau Official Website
• WHO OData API

Other

• Example Docker Container DB
• Story Telling With Data