Data line
Data
Turn raw data into decisions: spreadsheets and SQL, statistics, dashboards, machine learning and models in production.
6 courses37 lessons open22 h in total
- Station 1Data Analysis with Excel, Python & AIGo from a vague question to a clear answer: clean and pivot data in a spreadsheet, repeat the analysis in Python with pandas, check an AI assistant's work and write a one-page answer people act on.
- Station 2SQL & Data ModelingDesign PostgreSQL tables that keep every fact in one place, write the SQL behind real reports, make queries fast with the right indexes, and keep data correct under concurrent writes and live schema changes.
- Station 3Statistics for Data WorkThe statistics analysts and data scientists use every week: honest summaries, confidence intervals, hypothesis tests, A/B tests, regression and the traps that fool smart people.
- Station 4Dashboards and Business IntelligenceModel data for reporting, define metrics once, design dashboards around decisions and keep them fresh, tested and trusted.
- Station 5Data Science and Machine LearningFrame business problems as models, build them with Python and scikit-learn, and prove they beat a simple rule.
- Station 6Machine Learning in ProductionTake models from a notebook to a reliable service: pipelines, deployment, monitoring, drift and retraining (MLOps).