KickStarters Dataset Dashboard

️Data was split across two Excel files—one for 2016 projects and another for 2018 projects. It required handling as 1️⃣one table had more columns than the other, and 2️⃣to make matters interesting, the column names were different between the two sets. This discrepancy was causing null values when appending tables, as they must share identical column names.

The Solution:

️Enter Power Query! I used its magic to seamlessly append both tables into a cohesive, comprehensive dataset. With a mix of data profiling, careful alignment of column names, and some M language wizardry, I conquered the challenges head-on.