Pricing And Sales Analysis

Company size:

Presence:

Technologies:

20 000+ Employees

Global

Power BI

01:

CHALLENGE

An American multinational beauty company needed to compare prices from multiple markets of their e-stores. Gaps in pricing between countries and stores affected revenues and profits and the goal was to stabilize prices across markets and different retailers. Additionally, our customer was preparing a huge program to rename, rebrand and integrate a set of e-stores into a single European beauty store. All the above needed precise data and correct trend and results analysis to make the right business decisions on a strategical and operational level.

02:

SOLUTION

  • analysis of source data and source XLSX data structure
  • design and implementation of ETL processes in Power Query
  • creation of Power BI data model and Power BI Service structure
  • creation of Power BI dashboard comparing prices, countries, and different retailers showing trends and gaps

03:

RESULTS

  • process Automation (90% less manual work)
  • pricing Gaps were reduced by 30%
  • ability to monitor prices on a regular basis (due to faster and semi-automated processing)
  • ability to predict the business impact of store integration and prices standardization within the whole EU market

YOU MAY ALSO LIKE:

Construction

Digital Transformation With DWH And BI

FMCG

Discovering Innovation Through Analysis

contact

Let's talk

Katarzyna Strzelecka

Sales Operations Manager

+48 722 233 444

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

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.