Case Study

Data analytics to support Sales and HR Departments

ABSTRACT
We implemented Power BI and Microsoft Analytics tools to assist with the consolidation of the client's data.

Where: italy
Challenge
The company we worked with is an Italian firm based in Bolzano, specializing in collectibles, ceramic and porcelain figures, interior decorations, and home accessories.
Approach
Together with the client, we developed a solution to analyze the sell-out data to support the business. In addition, we implemented a second project stream to provide the HR department with analysis and insights on the current workforce.
Solution

We created a data warehouse that consolidates data from various sources, including CRM. This project had two main streams:

  • For the Marketing department, an analysis of the most important KPIs was conducted, such as loyalty cards, frequency of purchase, age of customers, and turnover incidence on registered and non-registered sellouts.
  • For the HR department, an analysis was carried out using Power BI to assess the hours of absence, turnover rate, and staff size in terms of entries and exits during the reference periods.
Results

 

 

 

 

Centralized Analytics Management

 

 

Creation of an effective integrated platform with the CRM and other systems

Technologies

To know more
Research Project

TEMA – Accurate Mapping and Forecasting for Emergency Management

Advanced Technologies and Tools for Natural Disaster Management (NDM)

Case Study

Brescia: Sustainable Mobility Becomes a Game

An app to encourage sustainable behaviors by promoting the use of public and private transport, as well as private and shared bicycles for commuting.

ARIEN: an AI platform to support the fight against illegal drug trafficking

A holistic approach based on artificial intelligence tools for monitoring the production and illegal trafficking of drugs.