Congratulations for sharing the workbook. I have watched many videos and nobody is smart enough to share the workbook. Many thanks! Excellent analytical skills.
How do you drive Values/ Analysis? Such as Revenue from new categories or Growth in Revenue against two months back figure? Since source data has no such fields?
@@excelenthusiasts Lets refer to the City Drill Down Sheet of the Workbook whereas within the Pivot Table Value Fields we are able to see dimensions such as"Growth in revenue over the previous month " & "Growth in revenue over the selected month - 2 " However, In the source data, the only value fields you have are Discounts & Total Price. Similarly in the New Categories Sheet, Pivot Table Report under Value Field has "Number of New Categories Sold" whereas there are is no separate value field for New Categories within the Source Data. How do you drive these Analyses (The Raw Data Input that's being used essentially)?
Congratulations for sharing the workbook. I have watched many videos and nobody is smart enough to share the workbook. Many thanks! Excellent analytical skills.
Thank you.
Thank you for sharing this 💌
You are welcome.
Hello Ashish
I went through your video
Can u plz suggest from where can I get the data sheet to practice
Hi. Check out this link - www.ashishmathur.com/sales-data-modelling-and-interactive-visualisations-of-an-e-commerce-company/
Do you have a video where you've taught how to create all these tables and graphs??
No. Creating the graphs is very simple. The hard work is in writing the DAX formulas in the PowerPivot.
waow mate thanks for this. you sir are a genious
You are welcome. Thank you for your kind words.
Hi sir, can you please tell how to account for cancelled sales in revenue for orders placed in previous accounting period?
Hi. Share some data in an MS Excel file, explain the question and show the expected result.
wtf was that scream at 7:58 ?!!!!!!!!!!!
Mind your language.
Hi Ashish, please share excel file, in the download link file is not available
Thank you
Hi. That data is confidential and therefore i cannot share the download link. Sorry.
How do you drive Values/ Analysis?
Such as Revenue from new categories or Growth in Revenue against two months back figure? Since source data has no such fields?
If you can share some data and show the expected result, then i can help.
@@excelenthusiasts Lets refer to the City Drill Down Sheet of the Workbook whereas within the Pivot Table Value Fields we are able to see dimensions such as"Growth in revenue over the previous month
" & "Growth in revenue over the selected month - 2
"
However, In the source data, the only value fields you have are Discounts & Total Price.
Similarly in the New Categories Sheet, Pivot Table Report under Value Field has "Number of New Categories Sold" whereas there are is no separate value field for New Categories within the Source Data.
How do you drive these Analyses (The Raw Data Input that's being used essentially)?
@@MrRoughking Hi. I have written DAX formulas in the PowerPivot to compute those KPIs
Hi Ashish, you did an amazing analysis, where I can download the worksheet?
Thank you. Form here - www.ashishmathur.com/sales-data-modelling-and-interactive-visualisations-of-an-e-commerce-company/
Hi Ashish, do you have a tutorial to perform the task you did in worksheet?
M Sidd No, I don't.
You can hear it coming at 7:53 haha