power BI

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

Data Transformation: (by Power Query)

- Append Queries (Two CSV Files 2016,2018)

- Troubleshooting the errors

- Remove Duplicates and keep most recent

- Filter Data

- Change Measure or Column Format to Currency

- Create Hierarchy

- Detect and Remove Outliers

Visuals: (Use Measures)

- Number of Projects (# Projects)

- Number of Backers (#Backers)

- Total Pledged

- Total Goal

less