pharma-analytics

Ranks the opportunity spaces in the India Cardiac market where Cipla has a sustainable right to win. A deterministic engine computes every figure; the model only narrates what the tools return.

SQL-based pharmaceutical data analysis project using MySQL to analyze drug sales, revenue, inventory, expiry, and supply-chain insights.

Power BI case study on NovaMed’s 2023 sales, customer segments, and product performance across global markets.

Pharma commercial performance and sales force effectiveness analysis using Excel, SQL Server and Power BI visibility.

Pharma commercial analytics on CMS Open Payments + Medicare Part D. dbt + Postgres + Streamlit + Groq LLM. Live demo linked.

Pharma commercial analytics project — SQL Server star schema + Power BI dashboard covering product, geography, channel, concentration, sales-force, and time-trend analysis.

Every row accounted for: a PySpark medallion lakehouse where bronze_in = silver_kept + quarantined + deduped is asserted per batch and re-runs are checksum-verified no-ops. YAML contracts gate each layer, violations quarantined with reasons. 1.22M rows through bronze/silver/gold in 236.6s on 2 cores. Fabric/Databricks pattern, runs on a laptop.

Interactive Streamlit web app for 365 Emirates Pharma monitoring sales performance, SLA compliance, discount capping, and cold chain storage thresholds.