Pharmaceutical Sales Analysis: Transforming Wholesale-Retail Data into Actionable Insights via Power BI Dashboards.
– Conducted exploratory data analysis on a sourced wholesale-retail dataset, employing Pandas to ensure data quality before transforming it in Power BI’s Query Editor, developed a robust data model using a star schema, enabling efficient data retrieval and analysis.
– Designed two interactive Power BI dashboards, one offering a quick snapshot of overarching sales figures and another providing in-depth analytics from both distributor and customer viewpoints.