Work with retail sales and inventory data for US client, using Excel and SQL Server to build Power BI reports and dashboards for business stakeholders. ​ data extract, join and validate data, then clean and transform it in Power Query (missing values, business rule mapping, data types) before loading into Power BI models. ​ ​ Design star‑schema data models, define relationships, and develop 30+ DAX measures for KPIs like total sales, YoY/MoM growth, running totals, average basket size and store performance. ​ ​ Implement Row‑Level Security and manage scheduled data refreshes in Power BI Service, including gateway checks and basic refresh issue troubleshooting. ​ Build and maintain 6–7 interactive dashboards (sales performance, store comparison, product mix, inventory status, customer trends) and handle enhancement requests via Jira tickets from requirement to tested, published reports.