search

aliahmad-1987 / DataAnalystProjectFromScratch_PBI_SQL_SalesAnalysis

Repository for files related to YouTube series on creating a Data Analyst Portoflio from scratch with SQL & Power BI.
88 stars 77 forks source link

Sean - Data Analytics Project - Part #4 issue #1

Open Sbgv677 opened 3 years ago

Sbgv677 commented 3 years ago

Hi Ali, Hope you had a good day. As requested these are the screenshots for the issue I came across, including a brief description of my experience with the issue.

First, the following is what the uploaded csv file for Fact_InternetSales looks like in the transform data/query editor feature in Power BI:

Screenshot 2021-04-12 162400

After apply&close, the actual table shows the following output which I can only describe as the system altering the data:

Screenshot 2021-04-12 162805

aliahmad-1987 commented 3 years ago

Hi @Sbgv677,

So what you are wondering if the data has been altered? Notice that there is the same product key, so I believe that would have the same price. It seems like it has been sorted though by product key in the last screen, also the row amount looks correct.

can you show a picture of the data model?

Sbgv677 commented 3 years ago

Hi @AnalyzeWithAli,

I was wondering if the data was altered because values in ProductKey are dropped automatically, leaving a couple of repeating values to fill-in for the missing values. When I use line charts with the ProductKey/SalesAmount columns as inputs, I normally get a horizontal line with little to no rise, or a single dot. The following is the data model you requested:

image

aliahmad-1987 commented 3 years ago

Hi @Sbgv677,

It's a bit hard to know exactly what is going on without seeing the order and what is being done. Everything looks good initially though!

An alternative could be that you download the finished .pbix from this GitHub place, remove the visuals etc. and just start with the model connected? At least then you get through the steps and to create something yourself for the experience etc.