Anaplan Practice Project: Restaurant Sales
Anaplan Practice Project
You can view his video that showcases the full project and then take a look through his step-by-step process to better understand how Anaplan can work.
![Screenshot1-1200x535](https://blog.voiantgroup.com/hs-fs/hubfs/Screenshot1-1200x535.jpg?width=677&height=302&name=Screenshot1-1200x535.jpg)
Go Through the Project Steps with Murat
First, I extracted the restaurant sales data of an authentic pizza company branch from an SQL database. Second, I have transformed the transactional data into aggregated daily data grouped by menu category, item, size, and order type. I then exported this data to a csv file. The data covers the beginning of 2017 to the end of June 2021. The transactional data has 248,365 rows, and the daily aggregated data has 137,520 rows. I created a new model in Anaplan and set the model calendar as shown in the image below:
![screenshot2-1-1200x501](https://blog.voiantgroup.com/hs-fs/hubfs/screenshot2-1-1200x501.jpg?width=780&height=326&name=screenshot2-1-1200x501.jpg)
This particular restaurant offers three types of services: dine-in, take-out, and delivery. I have added an order type list and load the types of services as list items.
![Screenshot3-1200x501](https://blog.voiantgroup.com/hs-fs/hubfs/Screenshot3-1200x501.jpg?width=780&height=325&name=Screenshot3-1200x501.jpg)
There are hundreds of menu items, so I created a hierarchical list for menu categories and items.
![Screen Shot 2022-11-07 at 1.25.19 PM](https://blog.voiantgroup.com/hs-fs/hubfs/Screen%20Shot%202022-11-07%20at%201.25.19%20PM.png?width=780&height=321&name=Screen%20Shot%202022-11-07%20at%201.25.19%20PM.png)
![Screen Shot 2022-11-07 at 1.25.52 PM](https://blog.voiantgroup.com/hs-fs/hubfs/Screen%20Shot%202022-11-07%20at%201.25.52%20PM.png?width=780&height=320&name=Screen%20Shot%202022-11-07%20at%201.25.52%20PM.png)
![Screenshot6-1200x493](https://blog.voiantgroup.com/hs-fs/hubfs/Screenshot6-1200x493.jpg?width=783&height=321&name=Screenshot6-1200x493.jpg)
I created a data module to import the csv data file. Order type, menu item, size, and time are the dimensions of this module. On the other hand, this module has two-line items: one for quantity of sales and one for amount of sales.
![Screenshot7-1200x489](https://blog.voiantgroup.com/hs-fs/hubfs/Screenshot7-1200x489.jpg?width=780&height=317&name=Screenshot7-1200x489.jpg)
After having loaded the csv file into data module, I created another module to calculate the rank and percentage as line items for both quantity and amount.
![Screenshot8-1200x485](https://blog.voiantgroup.com/hs-fs/hubfs/Screenshot8-1200x485.jpg?width=780&height=316&name=Screenshot8-1200x485.jpg)