Kickstarter dashboard

This project focuses on building an end-to-end analytical dashboard in Power BI to explore Kickstarter crowdfunding data and extract meaningful insights.

? Data Preparation & Modeling

• Cleaned and transformed raw data using Power Query

• Handled missing values and standardized categorical fields (state, category, country)

• Created a structured data model optimized for analysis and performance

? DAX Measures & KPIs

• Built custom DAX measures to calculate:

• Total Projects

• Total Backers

• Total Goal Amount

• Total Pledged Amount

• Applied aggregation logic and formatting for large-scale numeric values (K, M, B)

? Analytical Insights

• Time-series analysis to track project volume by year and identify growth and decline phases

• Categorical analysis to compare performance across main project categories

• State-based analysis to evaluate success vs failure distribution

• Geographical analysis to identify country-level concentration of projects

? Dashboard Design

• Used cards, line charts, donut charts, treemaps, and bar charts for clear insight delivery

• Focused on readability, hierarchy, and storytelling

• Applied a consistent layout and theme to enhance user experience

? This project highlights my skills in:

• Data cleaning & transformation

• Data modeling

• DAX calculations

• Business-oriented data storytelling