WELCOME TO 'MPARANZA
'Mparanza helps you analyze a sales dataset to identify the factors that explain the change in revenues, costs and margins. It is very secure: the data you upload is never saved on disk, and is discarded from RAM memory after you close your session.
You can play with one of our test datasets or upload a file. Your an Excel (xlsx) or csv file needs to be in a long, "tidy", format ("tidy" means that you should not have one column for each date, the dates should be "on top" of each other).
Your file should have a few dimension columns (customer, product, market,...), a period (call it 'Period') or a date column (call it 'Date') and one or more metric columns: Revenues (call it 'Amount', required), Units (called 'Quantity'), COGS and Indirect Costs.
Once you have uploaded your file, hit the 🚀Submit button. You will get a price-volume variance analysis plot, along with other charts. Choose among different variance calculation methods using the 🎦 Show variance as menu.
Select Variable dimension bridge in the 🏃🏻♀️ Run widget to map variance across different dimensions for each row result.
Use the 📊 Plot type widget to change plot type.
Under each command you will find a ➕. Click on it to find a short explanation and more options.
The documentation is broken into three sections that will help you get the most out of the app:
Quick start: to get quickly started with the app
Use cases: provides insights and examples that answer the "why use 'Mparanza?" question
Docs: gives you a detailed explanation of the different functions of the tool