WELCOME TO 'MPARANZA

'Mparanza is a one-click, no-code, business intelligence tool focused on sales and margins analysis.

At its core, four ideas:

  • Sales and margins analysis is a relevant enough subset of data analytics to merit a dedicated tool.
  • Sales and margins analysis is generally performed on datasets with a similar "tidy" structure.
  • Sales and margins analysis is not a form of art. It is possible to define a finite set of best practice analytical approaches (which charts to use, which kind analysis to run,...)
  • Charting is not a form of art. It is possible to identify best practices for how charts are supposed to look. Those best practices are defined in the IBCS standard.

When you put these four ideas together, you end up with a one-click, no-code sales and margin analysis tool that generates plots at the speed of thought, eliminates the need to use Excel, and delivers broader insights compared to PowerBi or Tableau, since it is not constrained by the specific set of visuals baked into your dashboard.

It is also very secure: uploaded data is never saved on disk, and is completely discarded from RAM memory once you close your session.

Interested? Play with one of our test datasets or upload a file.

Your an Excel (xlsx) or csv file needs to be in a "tidy" format ("tidy" means that 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: Sales (required, call it 'Amount'), Units, Discounts, COGS, Indirect Costs,...

Once you have uploaded your file, hit the 🚀Submit button. You will get a 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 for 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