This project visualizes pharmaceutical spending data across different countries using Power BI. The interactive dashboard provides insights into total spending, per capita spending, and the percentage of health expenditure allocated to pharmaceuticals.
The dataset used for this project is sourced from DataHub and includes the following indicators:
- PC_HEALTHXP: Percentage of health spending.
- PC_GDP: Percentage of GDP.
- USD_CAP: Spending in USD per capita.
- TOTAL_SPEND: Total spending in millions.
- Interactive Visualizations: Includes bar charts, line charts, pie charts, and a Sankey diagram to visualize spending flows.
- Dynamic Filtering: Users can filter data by year, country, and spending category to explore specific insights.
- Custom Formatting: Enhanced visuals with custom colors, labels, and titles for a comprehensive view.
- Bar Chart: Compare pharmaceutical spending across different countries.
- Line Chart: Show trends in spending over time.
- Pie Chart: Display the share of total health spending by country.
- Sankey Diagram: Visualize the flow of spending from countries to different categories.
- Heat Map: Highlight high and low spending areas.
- Radar Chart: Compare multiple variables for different locations.
- Download the Dataset: Get the CSV file from DataHub.
- Open Power BI Desktop and import the dataset.
- Follow the visualizations setup in the project file to recreate the dashboard.
This Power BI dashboard provides a comprehensive view of global pharmaceutical spending, helping stakeholders understand spending patterns and make informed decisions. Feel free to explore the project, and contributions are welcome!