# data[].attributes.headline
Slicing and Dicing Marketing Data with Pivot Table : Case : True Colours Harware 

# data[].attributes.subject
Slicing and Dicing Marketing Data with Pivot Table : Case : True Colours Harware 

# data[].attributes.body
Kindly open the data attachded for two hardware stores : raja store and sethi store .

How to analyze the data using Excel pivot Tables

1. What percentage of sales occures at each store?

2. what percentage of sales occurs during each months?

3. How much revenue does each product gentates ?

4. Which products generates 80 percent of the revenue https://lms.srmup.in/pluginfile.php/597/mod_forum/post/66/Slicing%20and%20Dicing_marketingData.xlsx

# data[].attributes.headline
Slicing and Dicing : case 2 : La Patit Bakery

# data[].attributes.subject
Slicing and Dicing : case 2 : La Patit Bakery

# data[].attributes.body
La Patit bakery  sales cakes , pies, coffee and smoothies. the owner has hored you to analyzie factors affecting sales of these products .with a pivot table and all the analysis skills you now have, you can quickly describe the important factors affecting sales.

Data : https://lms.srmup.in/pluginfile.php/9798/mod_forum/post/68/BakeryData.xlsx

Read the note and work:

note:https://lms.srmup.in/pluginfile.php/9798/mod_forum/post/68/Teaching%20note_%20La%20petit%20bakery.pdf

# data[].attributes.headline
Teaching Notes for Case 2 : Laptit bakery

# data[].attributes.subject
Teaching Notes for Case 2 : Laptit bakery

# data[].attributes.body
Please read the case 2 note and according work