kickstarter project

kickstarter projects

- An institution or company that connects project owners and investors.

tools : Power BI Desktop.

- Data Source: Two CSV Files (2016,2018)

https://www.kaggle.com/ke...

Data Transformation:

- Create Custom Column has the file name (ex: 2016 , 2018 ) (M Language)

- Append (Union) two files using M Language (Power Query)

- Remove Duplicates

Modeling:

- Create Hierarchy (Main Category, Category and Project Name) Called it "Project Hierarchy"

- We can hide the unneeded tables or rename tables.

- Number of Projects Measure

- Number of Backers Measure

- Total Pledged Measure

- Total Goal Measure

Visuals: (Use Measures)

- Number of Projects (# Projects) Card

- Number of Backers Card

- Total Pledged Card

- Total Goal Card

- # Projects by State

- # Projects by Project Hierarchy (Drill Down)

- # Projects by Launched

- Total Pledged by Currency or Country