01
SQL Business Reporting
Wrote PostgreSQL queries on a retail database to compute sales KPIs for a business report.
2 of 7 skills
Wrote PostgreSQL queries on a retail database to compute sales KPIs for a business report.
Cleaned raw data with Power Query and built a pivot-driven dashboard in Excel.
Built a star schema and DAX measures, then designed a KPI scorecard with drillthrough.
Compared investment options with ROI, NPV and sensitivity analysis, and wrote the business case.
Building production business analyst work on real-world data.