My first project that did without guidance on PowerBI was quite interesting.Jcars dataset. I remember it opening PowerBI and loading the data and started editing the query, I have never seen such a messy dataset in my life lol. So I started the process with data cleaning.
Step 1: Cleaning The Data
I started in Cleaning the dataset in powerquery. I first put on a setting called column quality, which shows me the quality of dataset in each column.It has 3 types, Valid, Error and empty. As cleaning up, I replaced errors with null,and also changed type of the data, transform the data when needed, used setting like TRIM and Proper(capitailizing words).
Afterwards I got the money columns,I saw them and I was about to cry. The money was in different currencies but I managed to change them. after that I was done and moved to the next step.
Step 2: Duplicating the PowerQuery Table
I duplicated the DataSet 6 times. I renamed them; DIM-STORE,DIM-CUSTOMER,DIM-DATE,DIM-SALE,DIM-SALE,DIM-PRODUCT and Fact Table. This tables are essential for modelling which is will coming later.I managed to select appropriate columns for each table and afterwards I proceed to close and save the queries.
Step 3: Managing Relationships
Dimension Tables after being created have relationship with each other based on the items picked. Most Dimensional Tables are most linked to Fact Table since it a representation of quantitative, measurable events. All my tables were linked to Fact table by Keys. It important for you to check if
Step 4 : Dashboarding
After all that it important that start understanding the model and have a dashboard giving an overview of the business events in the company. What I noticed the most was that Government is their biggest buyer and had also most return for cars. Government mostly prefers buying SUV.
Top comments (0)