Data Analyst Bootcamp (FREE 35+ Hour Full Course) - SQL, Excel, Power BI, Python, AI & GitHub
Luke Barousse
Luke Barousse’s data analyst bootcamp, put together from four of his courses: SQL with PostgreSQL, Excel, Power BI and Python, plus a short section on using ChatGPT for analysis. Every part works with the same data jobs dataset and has its own projects, from a SQL skills analysis to Excel and Power BI dashboards and a Python study of job and skill demand. The databases and files are free; the practice problems and certificates are a paid extra.
What you'll learn
- Querying PostgreSQL with joins, subqueries and CTEs
- Excel formulas, PivotTables, Power Query and Power Pivot
- Building Power BI dashboards with DAX
- Analyzing data with pandas and plotting it with Matplotlib and Seaborn
- Portfolio projects on a real data jobs dataset