Basically I fix messy spreadsheets and build dashboards out of them. Over a year doing this across multiple business locations, tracking KPIs and performance. Built interactive dashboards with time-based, sales, and funnel analysis, showing where things go wrong, not just totals. Automated a task that used to take 4-5 hrs/week. Also handled SQL on big datasets, 100k+ records a day, without things breaking.
Tools: Power BI, DAX, SQL, Excel (pivot tables, XLOOKUP, macros), Looker Studio, BigQuery
If your numbers are a mess or your dashboard doesn't help you decide anything, that's what I fix... Lee más