Data integration & Power BI Reporting support saves hundreds of man-days per year for Philip Morris CZ&SK

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.

Results

• Excessive jobs are eliminated.
• Data are unified and transfers are automated.
• This process is still running and helps the company.

Challenge

• Reports with a modern look.
• Functional and customized.
• For provided spending, partners, employees, and customers.

Results

• 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.

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.

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.

Results

• 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.