Skip to content Skip to footer
Search

Loading Results

Data and analytics

Data analytics can help you navigate through the growing uncertainty

The pandemic has exposed the unpreparedness of many businesses to deal with crisis. While it may be counterintuitive, it is now more important than ever for you to invest in business intelligence. With uncertainty growing and growth slowing, now is the time to assess what data you have, your current operating processes and adjust accordingly to limit any adverse impact that the crisis may have on your business. In times of economic turmoil, you will need data analytics to help you act with urgency through data-driven measures.

Data is no longer simply a repository of information

The effective use of data can guide your company through the fog of instability by helping you assess your current capabilities and predict the situations to come. 

Organisations should automate where they can, upskill employees, and build on their data capabilities. By investing in data analytics and preparing your workforce now, you can help your business accelerate and come out stronger on the other side.

 

Signs to look for:

  • Are you experiencing liquidity issues?
  • Do you have trouble assessing which debtors have the highest likelihood of default?
  • Have you experienced delays in the supply chain due to lockdowns?
  • Do you have difficulty moving inventory and tracking demand during this crisis period?
  • Are you struggling to make urgent/real-time decisions during this crisis?
  • Are you overwhelmed by the volume of disorganized data?
  • Do you want to prepare for multiple scenarios and be ready to respond expediently?

How can PwC help?

At PwC, we can help you transform your data into a valuable tool for business recovery through our data analytics solutions:

Interactive dashboards

Providing cash flow insights, working capital analytics and inventory tracking for cash forecasting and working capital management

Cash flow insights and working capital dashboard

Preserving liquidity levels through cash flow management

In any situation, but more so during a crisis, it is important to have enough cash available to cover immediate needs. We can help you gain better visibility on your cash flows through an interactive dashboard wherein you can easily track your current and expected net working capital, cash inflows and outflows, and cash conversion cycle.

With the cash flow insights and working capital dashboard, we can help you:

  • Identify the largest source of cash inflows and focus your business operations in maintaining that source

  • Uncover and cut down on non-value adding cash expenditures

  • Identify and resolve unusual or excessive amounts of current liabilities and non-cash current assets

  • Explore the optimal maintaining cash balance

  • Plan for different best-case and worst-case scenarios by performing cash flow sensitivity analyses

 

View more

Inventory tracking dashboard

Optimize inventory level to increase cash available for use

Inventories should be monitored so that excess build-ups are minimized or avoided and that cash tie-ups are reduced. We can help you manage your inventory levels through an interactive dashboard that will indicate your stock levels per product type, demand per distributor or sales outlet, optimal stock levels, and other inventory statistics.

With the inventory tracking dashboard, we can help you:

  • Prevent the accumulation of excess stocks

  • Forecast demand or sales to determine optimal inventory levels and warehousing

  • Reorder inventory from your suppliers at the right time

  • Determine the right amount of goods to purchase based on logistical costs and other constraints

View more

Credit risk profiling

Credit risk profiling model to aid in creditor reviews

Sustaining your collections

Adjusting credit terms that are beneficial for you and your customers will lead to accounts still being collected even during a crisis. We can help you streamline the process of reassessing your customers’ financial situations so that we can convert these receivables to cash.

With credit risk profiling, we can help you:

  • Adjust your assessment of your customers’ credit profile, especially those whose expected or current credit risks have significantly increased
  • Renegotiate better credit terms
  • Minimize costs of collection efforts by knowing how aggressive these efforts should be based on account collectibility/

Customer profiling and product bundling analysis

Using machine learning models that aid in better managing inventory levels

Customer profiling analytics

Create sales opportunities amidst declining demand

Customer preferences change overtime. During a crisis, they may choose to limit their spending only for essential goods or services. With data analytics, we can help you classify your customers based on their demographic information and spending behavior to determine which of them are the most beneficial to invest in or which products are mostly preferred by specific groups.

With customer profiling, we can help you:

  • Redesign products or services based on features that are most preferred by customers
  • Modify your marketing efforts and customer service initiatives to match the behavior or characteristics of specific groups

View more

Product bundling analytics

Redesign product mixes to induce demand

Not all products will have the same demand as the others. We can identify combinations of products that are most frequently purchased together by establishing patterns across purchases through data analytics. This will help create opportunities to increase product demand, reduce slow-moving inventory, and improve overall sales.

With product bundling analysis, we can help you:

  • Improve product adoption in new and existing markets by optimizing marketing promotion strategies
  • Increase upselling opportunities by identifying substitute and complementary goods
  • Cross-sell different products by identifying combinations of products frequently purchased

View more

Data analytics workshops

Harness the power of data by upskilling your people in data analytics

One of the key assets of the company is its people. During a crisis, your people should not only be able to quickly understand the data presented before them, but should also be able to generate and communicate key insights to the right people. By upskilling your workforce in data analytics, we can help your company be more adept in integrating data into your decision-making processes, especially during and in preparation for a crisis.

Our modular data analytics workshops can either be conducted through classroom trainings or online/webinar sessions. You can opt to sign up for all or just one of the following modules, depending on your needs:

Module 1: Fundamentals of data analytics

This module will teach you the basic concepts of data analytics and the overall process necessary to transform data into insights that you can use in your decision-making process.

View more

Module 2: Data storytelling

This module will help you build a compelling, persuasive, and logical story out of various data insights that others can easily follow and understand. By doing so, your reports or presentations can become more impactful but not necessarily complex or confusing. A short assessment will be given to the attendees at the end of the session.

View more

Module 3: Data visualization

This module will show you what charts, graphs, or other visualizations are the most appropriate to use to summarize and effectively present the data and insights you have acquired.These data include comparative data, time-series data, proportion data, and even unstructured data like texts and articles.  A short assessment will be given to the attendees at the end of the session.

View more

Module 4: Dashboard creation

This module will introduce you to the basic functions and visualizations of Microsoft Power BI. At the end of the session, attendees will be creating their own capstone projects to have a firsthand experience in designing an interactive dashboard while applying the general concepts and best practices that they have learned.

View more


Contact us

Mary Jade T.  Roxas-Divinagracia, CFA®,CVA

Mary Jade T. Roxas-Divinagracia, CFA®,CVA

Deals and Corporate Finance Managing Partner, PwC Philippines

Tel: +63 (2) 8845 2728

Leilani C. Ramirez-Layug

Leilani C. Ramirez-Layug

Deals and Corporate Finance Director, PwC Philippines

Tel: +63 (2) 8459 3142

Follow PwC Philippines