Dawood Khan
POS Data Analyst | Power Query, Power BI, Excel Dashboards
New to Contra
Dawood is ready for their next project!
The Consumer Complaints Dashboard: Insights & Actions provides an interactive view of consumer complaints for a financial institution from 2019 to 2023. It categorizes data by state, product, issue, and includes slicers for each category plus a timeline filter. A key feature...
This project demonstrates how I used Excel Power Query to clean, transform, and automate multiple CSV files stored in a folder. The goal was to extract only the required rows, reshape the data, and build an automated solution that updates with a single click whenever new data is...
Slime Kitchen ran 14 stores across franchise and corporate ownership using two POS systems — Square and GoParrot.
I extracted, merged, and cleaned both exports using Power Query, added custom time columns, and built a fully interactive Looker studio dashboard.
The owner could —...
Cleaned and automated 30,000+ rows of POS data using Power Query, reducing manual reporting time by 80%. Built an interactive Power BI dashboard tracking $6.29M in sales and 255K units sold across multiple locations. Delivered KPIs (YoY, MoM, WoW) and insights into top products...
