Pizza Sales Analysis - Data Extraction, Transformation and Loading
Вставка
- Опубліковано 3 жов 2024
- This video walks through the extraction of the Pizza Sales dataset from source (CSV), transformation in Power Query Editor and loading into Power Bi.
Data Link: www.mavenanaly...
Challenge Description: www.mavenanaly...
#MavenPizzaChallange
Enjoyed the technical content, but your sound quality was quite poor. For me it distracted from your really informative narrative. Thank you for taking the time to share your expertise.
Hi @cazvon, apologies about the sound. Sure to improve in subsequent uploads
Thank you again for the wonderful and throughput explanation.
Under the setting, leaving the "Import relationships from data sources on first load" checked doesn't have any negative effect right?
Look forward to other videos
Hi @Abiodun,
This setting doesn't have effect with our current workflow as we are working with flatfiles. However, its effective when you import data from the database with an existing relationship.
I noticed you had PM/AM in your data, please how did you get the timestamp on the time column.
The column was detected as a "Time" column in Power Query. If yours didn't detect it, you could manually change the data type using the icon at the top left of each column. Hopefully, this helps
@@IdrisAlugo thank U for ur response, I actually tried it but it’ didn’t work
It’s actually worked when I changed it to text format
Hi, I downloaded the dataset from Maven but I don't know why the Date column in Orders has errors. Can you please help me with this?
I already changed the settings as you did
Good you changed the settings. After that, do you still get this error? If yes, can you describe the error a little more?
@@drizzle1866 Hi drizzle1866, thank you so much for your reply, I did everything once again from changing the setting and it's working perfectly now! Once again, thank you so much
thank u so much for ur effort i own u my new career which is realy change my life , thank u again idris