Success Story

Saving Hundreds of Man-Days Per Year for Philip Morris CZ&SK with Data Integration and Power BI Reporting

Adastra assisted Philip Morris to automate their data consolidation process, previously managed through manual Excel files, and to enhance their business intelligence capabilities by redesigning and developing new Power BI reports. This strategic move significantly reduced manual labor and improved operational efficiency, enabling a stronger focus on business development.

40

excel files were sorted over manually each month

12+

Power BI reports were redesigned

10

reports were newly developed

About the Client

Philip Morris CZ&SK is a branch of the global tobacco company Philip Morris International, operating in the Czech Republic and Slovakia, known for its prominent presence in the tobacco industry and its focus on developing smoke-free alternatives.

Solution

Adastra implemented a comprehensive data integration and Power BI reporting solution for Philip Morris CZ&SK, focusing on automating manual data processes and enhancing analytical capabilities. This solution not only minimized the need for manual data handling but also provided advanced reporting tools, significantly improving operational efficiency and supporting strategic business insights.

Success Story

Industry:

Retail and CPG

Technology:

Power Apps | Power BI | Power Platform

Expertise:

BI and Analytics | DWH Modernization

Date:

November 7, 2023

Empowering Philip Morris with Advanced Data Insights: A Partnership in Data Analysis, Engineering, and Power BI Reporting

Data analysis, data engineering, and Power BI reporting. Areas in which Philip Morris CZ&SK asked Adastra for support in 2019. The goal was to provide fast and powerful data insights, so they can focus more on business development and less on data/reporting implementation tasks.

We built a professional team of Data Analysts, Data Engineers & Power BI Developers, who were constantly working on data integration & reporting tasks. And continue to do so. They support clients’ BI team to dedicate more people to the customer journey, systems process mapping, to control data quality.

In the last year, more than 12 Power BI Reports were redesigned for better reading, performance & functionality. And 10 reports were newly developed; from 1-page dashboards to many-paged complex reporting solutions.

“I really appreciate the support we are getting from Adastra, their expertise helped us to deliver many new reports and insights to our business stakeholders in very fast and efficient way.”

Marek Hallér
Manager of Consumer Journey, Business and Consumer Intelligence at Philip Morris International

Need a similar solution?

Contact Form (Sidebar)

Time to Handle Company Growth

Effective man-days

Employees have the time to devote to more demanding, higher value-added tasks.

Pro-client approach

Increased motivation to buy, anticipating system errors on the part of users. With that, improvement in customer experience and, therefore, satisfaction.

Power BI reporting

It serves all levels of staff (from salesmen in the field to senior management).

One source of truth for all data

For all employees across the company.

What Do We Do for Philip Morris CZ&SK

  • Data analysis of consumables and devices, focusing on customer segmentation.

  • DWH data modeling (Power Designer based on SQL Server data).

  • Reports development in Power BI with ongoing support and maintenance.

  • Omnichannel process optimization, customer registration, first purchase in the channel etc.

  • Optimization of existing Power BI solutions. Visual, technical and functional. Aiming to give the reports a modern look and feel, enhancing user interaction and improving functionality, thus speeding up the processing of business decisions. All that while optimizing data load and reducing servers’ sources consumption.

  • Support CZ & SK BI and business departments with data-related tasks.

  • Sharing with BI team reporting best practices, so all Power BI report creation would be based on them.

Employees Were Sorting Over 40 Excel Files Each Month

Then

All consolidation of these files had to be done manually.

Now

Excessive jobs are eliminated, data is unified, transfers are automated.

In One Year

More than 12 Power BI reports were redesigned

  • Better Reading

  • Performance

  • Functionality

10 reports were newly redeveloped

  • From 1-page dashboards to complex reports with multiple pages

Philip Morris Dashboard Example

Our PMI BI Support in Detail: Data Migration (Philip Morris CZ)

Employees were sorting over 40 Excel files by hand. Each month. Thanks to our wide experience with BI we were ready to sort out this problem and eliminate the excessive job.

Challenge

Over 40 resellers every month send their own Excel file with information about their sales.

All consolidation of files had to be done manually; some employees had to manage only that data consolidation.

Solution

Adastra provided a solution using the Web Upload application, which was installed for resellers.

It validates data inputs and then sends all data from resellers in the same format to the data warehouse, which is then available to be used for Power BI Reports.

Result

Excessive jobs are eliminated.

Data are unified and transfers are automated.

This process is still running and helps the company.

Power BI Migration, Reporting & Redesign (Philip Morris CZ)

Dozens of reports to create or redesign for user interaction empowering and speeding up the business decision process. With constant support and maintenance.

Challenge

Reports with a modern look.

Functional and customized.

For provided spending, partners, employees, and customers.

Result

We migrated a set of reports from Tableau and Excel to Power BI.

We identified some critical points in the process, raising a ticket to the global team.

We investigate how processes like the registration of customers and purchase work after the launch of a new CRM platform, which is a completely new architecture of systems, and the interaction between them.

We helped the Czech team to understand how some of the processes work and how often the data are transferred between the systems in the process.

Employees have more time to spend on high-value-added tasks.

Reports were developed (or helped BI team to develop) to cover many important business tasks, for example:

  • Help to identify groups of customers that may indicate some system problem
    For instance, when you buy a device online, it should always be linked to your profile. However, the report might indicate that it’s not always like this.
    The system can analyze how big the groups of users with similar problems are if data correction is needed, whether the call center should be involved, etc.
  • Help to identify how much money has to be placed aside to cover future spending from the client’s benefits
    This was required as a part of the appearance of a loyalty program, which gives Philip Morris (PM) customers certain rewards and therefore boosts spending.
  • Report for partners to help them easily track their performance
    It identifies how many orders of Philip Morris products were made through partners, when, in which product categories, in which cases, and whether it is the first or following purchase.
  • Report for referral tracking
    Helps to understand how consumers use the referral code, whether they invite new members or not, and at what time it happens.

Power BI Migration, Reporting & Redesign (Philip Morris CZ)

Dozens of reports to create or redesign for user interaction empowering and speeding up the business decision process. With constant support and maintenance.

Challenge

Providing out-of-the-box reporting solutions, focusing on business needs.

A complex solution had to provide multiple views, uncovering business insights regarding promotion effectiveness.

Result

Data transformation of information about Sales, Customer Segments, Promotions, Vouchers, Loyalty Club Membership, etc., into meaningful business insights.

Creation of custom charts according to business requirements.

Implementation of complex programming solutions in Power BI.

Share this story

Read More Success Stories

Need a similar solution? Get in touch with us, we can help.