Learning a new technology, like any other skill, requires practice. Murat Akkas, a Senior Business Solution Consultant here at Voiant, shares his Anaplan practice project using extracted SQL data from a pizza restaurant.
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.
For this practice project, Murat copied a project that he had already done using other tools. He had completed this project previously withExcel, Python, Power BI, and Tableau. The aim was not to compare all of these tools but to practice Anaplan.
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:
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.
There are hundreds of menu items, so I created a hierarchical list for menu categories and items.
Some menu items, such as pizza, have different size options including small, medium, larger, and giant. Also, some beverages are offered in different volumes. Thus, I needed a size list. Some menu items have a single size, like soup, fries; therefore “one size only” refers only to those that have a single size on the menu.
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.
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.
About the Author: Murat Akkas
Murat is a versatile professional with strong business acumen with over ten years of data analytics experience in Financial Modeling & Analysis, Data Modeling, Data Visualization & Analytics, Time Series Forecasting, and Hypothesis Testing. Murat loves data and thrives on driving arguments with data to help businesses gain insights, make decisions, and solve complex business problems in a fast-paced environment. Prior to Voiant, Murat worked for Deloitte and the Ministry of Finance of Turkey and also worked as an independent consultant for international companies including one of the top five dairy companies in the world.
As a part-time lecturer, Murat taught data analytics at an online data science Bootcamp. Murat was inducted into Beta Gamma Sigma while completing his master’s degree in finance at George Washington University. As a lifelong learner, he also holds a Ph.D. degree in business from Ankara University. He also volunteers with the Anaplan Talent Builder Guided (Elevate) program as a mentor.