The-Data-Analyst-Toolbox

Tools that data analysts and business analysts work with

SQL

• Window Functions
• View
• CTE
• Checklist for SQL Query Optimization

Excel

• Excel Formulas & Functions
• Pivot Tables
• Dashboards

Google Analytics

• Google Analytics Glossary Top 50 Terms

Econometrics

• Econometric Theory and Methods (ETM), by R. Davidson and J. G.Mackinnon, Oxford University Press.
• Econometric Analysis (EA), by W.H. Greene, New York, Macmillan

Statistics

• UW Course Notes

Python