Portfolio Project - Data Analysis SQL Power BI | Pizza Sales | End to End | Power BI Dashboard

[@SatyamGahlout]

Thank you so much for this video lecture. I have been all concept cleared in this video.

[@randomshite998]

Excellent, please try to do a video with complete scratch (webscraping) because Recruiters have seen too many kaggle datasets. Thank you

[@HisDataProject]

We have one from scratch at kzbin.info/www/bejne/n4bdgJaAecScaqMsi=GXnOYuwbV3V_91d6

[@chirchirkipkiruipharaoh5482]

This is really very insightful. can follow step by step.

[@HisDataProject]

Thank you!

[@brownsugr111]

Tysm

[@LS8636]

Thank you for this 👍

[@HisDataProject]

No problem 👍

[@aishwaryapattnaik3082]

Can you make a video on Advanced Level Financial Domain Dashboards in Power BI and Excel for portfolios please

[@HisDataProject]

I’ll do this soon!

[@libanabdirahman2113]

hello i am following up the tutorial but i am using sql big query when i tried to use the pizza type table its not given the column names but its assigning to random column names names instead of pizza_type_id its calling string_field_0 and instead of name its calling string_field_0 its counting column names as rows anyone who can help i will appreciate

[@tradelover7078]

Im new to powebi, i have a question, In real time project we can directly use CARDs and we can get the reuslts like SUM, avg by changing options right? Why you use sql query to retrive the same?

[@HisDataProject]

Are you referring to doing these calculations in Power BI instead of SQL?

[@Maxim_Vu]

Great video, I appreciate it. in my Power BI in question 3 the percentage was not displaying the amount. They just count. How can I fix this?

[@rokeyize]

check datatype

[@ambikamishra2349]

Can i use this in sequel server 2019??

[@HisDataProject]

Yes you can. There could be minor differences but you’ll only know once you do it

[@ralleypriest-ndubi4951]

Umeiva sana. Kazi muzuri sans Naweza nikuulize swali?

[@HisDataProject]

Uliza

[@mukul29099]

In avg. order value, why using distinct if we need order count

[@HisDataProject]

You need to calculate the number of unique orders. This simply makes sure you don’t count the same order twice

[@zaidqureshi5668]

because distinct is use for unique

[@ShivaKumar-oc8uq]

time column is not inserting in flat file how

[@HisDataProject]

Your question is not clear...

[@kailastupe7039]

are they interactive?

[@HisDataProject]

@kailastupe7039 no, there are no slicers in this dashboard, which would make it interactive