Digital Transformation With DWH And BI

Company size:

Presence:

Technologies:

300+ Employees

CEE Region

Sharepoint, Power Apps, Power BI, Azure SQL DB, Azure EventHub

01:

CHALLENGE

The ultimate objective was to deploy a central Data Warehouse (DWH) and Business Intelligence (BI) reporting system to combine data from various sources. With this combination, both the modeled data and the end-user information was supposed to be available in one place as well as accessible and usable for all the internal and external stakeholders, becoming a single source of truth and delivering:

  • Asset Foundations – establishing KPIs and deploying reporting based on footfall (number of people entering a property or property’s area), tenant sales (turnover of a point of sales located in the property), and occupancy costs (charges and fees related to the lease contract) as well as their benchmarks for the entire portfolio, replacing and/or supplementing the current reporting.
  • Shopper Analytics – extending the above analytics by establishing and deploying a proof of concept for KPIs and reporting based on end-consumer-oriented data originated from other sources (i.e., in-property systems), contextualizing the above metrics (related to footfall and tenant sales) as well as their derivatives, on the example of a few properties having the systems in place, supplementing the above reporting.

02:

SOLUTION

After study of the detailed documentation and close cooperation with the customer’s team, delivery of the following high-level scope was raised:

  • review of Client’s current Azure environment to ensure it follows Microsoft Cloud Adoption Framework
  • design and Architecture of DWH and Reporting solution with the usage of Microsoft Azure
  • ingestion of data from source systems data (initial data load + pipeline setup)
  • design and implementation of the ETL/ELT processes to load data into serving layer data structures
  • design and implementation of PowerBI reports
  • creation of SharePoint/PowerApp that can serve as data input

03:

RESULTS

  • improved business monitoring & decision-making process
  • segmentation of shoppers giving the ability to prepare more accurate personalized offers
  • increased sales and revenue by 5-10%
  • negotiation with customers based on accurate data

YOU MAY ALSO LIKE:

Manufacturing

Legacy System Migration To Azure

contact

Let's talk

Katarzyna Strzelecka

Sales Operations Manager

+48 722 233 444


Warning: Undefined array key "events_tracker_for_elementor_gtag_label" in /home/cloudsonmars/ftp/new-wp/wp-content/plugins/events-tracker-for-elementor/includes/class-main.php on line 719
Clouds On Mars needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy policy.

contact

Let's talk


Warning: Undefined array key "events_tracker_for_elementor_gtag_label" in /home/cloudsonmars/ftp/new-wp/wp-content/plugins/events-tracker-for-elementor/includes/class-main.php on line 719
Clouds On Mars needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy policy.

This website uses cookies.