Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation
  • Excel Tutorials

Case Series 2 : Analyzing Sales data with Pivot Table

Saurabh Jain


In this case, we will analyze sales data from two stores and answer the following questions

  • What percentage of sales occur at each store ?
  • What percentage of sales occur at each month ?
  • How much revenue does each product generated?
  • Which products generate 80 % of revenue?

We will also learn the Use of Report Filters & Slicers



Download data set



Recommended Comments

Dear Saurabh,

I have gone through most of your tutorials along with the cases and i liked the way of teaching. It's a great learning and useful for all users (beginners to advance). Thanks.   

Link to comment

I just started learning from your tutorial and you really explain it very patiently. Learning a lot. 

Since I am not familiar with pivot table, I found this turotial little difficult to understand. I had to see it 2 to 3 times to understand it. 

  • Thanks 1
Link to comment
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Login to participate

    • Sign up / Login
    • Join the club
    • and then you are on the board
  • Create New...