Offer: CORE
Our CORE offer helps you set up a complete dashboard of key indicators to ensure a proactive monitoring of your business. It includes data collection and aggregation, KPI calculation, dashboard creation with a standardised visualisation tool.
Details
Data source
Data collection
Data processing
and
storage
Data visualisation
Tools
Description
Number of data sources collected for the project.
Origin of the data sources collected. External data can be collected by export, API, web scraping…
Includes data cleaning, formatting, normalisation, anonymisation, aggregation, checks and controls...
The full process can be manual, semi-automated or fully automated.
Number of dashboards included. One dashboard has several indicators and graphs.
The tools for the different steps of the data collection, processing and visualisation can be market tools (API, Google Data Studio, Power BI, Tableau…) or be specifically developed for the project (Python, Dash Plotly, Django…).
Included
1
First-party data
Manual
or
semi-automated
1 to 3
Market tool
Our projects
Expenses & revenue dashboard for a fine-dining restaurant
Clara Bangkok
Industry: Restaurant
Business needs:
Improve expenses & revenue collection process and implement a daily activity monitoring dashboard.
Deliverable:
Expenses & revenue collection process and activity monitoring dashboard with:
-
Appropriate access rights to internal staff, external accounting team and shareholders,
-
Monthly / yearly aggregation and control tables,
-
Detailed KPIs, tables and graphs monitoring operational Profit & Loss, cash flow, sale and customer revenue per period, table, menu...
-
Expenses per category, type, issuing date, payment date, supplier...
-
Online traffic and booking.
Methodology and tools:
-
Data collection and aggregation: Google Sheets Query
-
Data visualisation: Google Data Studio / Looker
