Leveraging Power BI to create insightful reports and improve decision-making while enhancing the customer journey.

Canusa Wood is a Vancouver-based company that has grown into one of North America’s leading importers of hardwood plywood, and panel products. Its extensive supply chain encompasses dozens of suppliers from around the world, enabling Canusa Wood to offer a vast array of top-quality materials suitable for various applications such as interior, exterior, marine, and industrial applications.

Despite operating with a small team of 25+ staff, Canusa Wood generates an impressive annual revenue of several million per employee.

DÉFIS

One of the most significant challenges faced by Canusa Wood is effective inventory management. As a company that buys material from multiple mills across the world and distributes its inventory across Canada and the United States, they encounter a considerable lead time for fulfilling their orders.

To improve its inventory and sales management processes, Canusa Wood adopted a new, specialized ERP software called Agility four years ago. This system is designed for building supply distributors to effectively manage inventory, facilitate purchasing and sales order management.

Over the years, Canusa Wood accumulated vast amounts of valuable data through its ERP system. To leverage this data and gain relevant insights, they wanted to explore the use of business intelligence tools. Their goal was to create sophisticated reports that will allow their sales and buying teams to make informed decisions and enhance the customer journey.

6N6A5167 Edit e1591660929886

SOLUTION

Due to the limitations of the Agility ERP software, Canusa Wood required more advanced reporting capabilities. To address this need, they invested in PRO2SQL, a tool that facilitates the data transfer from Agility to an Azure-hosted SQL database. In addition, their adoption of Microsoft 365 made Power BI a perfect choice as their Business Intelligence tool.

As a small company with no IT staff, Canusa Wood turned to Softlanding to help them set up their SQL database and convert their raw data into digestible information via Power BI.

The Softlanding team built the SQL queries for Power BI and helped Canusa decipher and interpret the data they wanted to see in their Power BI reports.

Moreover, Softlanding provided training to the key project stakeholders but also to a co-op student that Canusa hired to accelerate their data utilization.

iStock 1143344407 mis à l'échelle e1591649542149

RÉSULTATS

  • People Empowerment

To avoid the cost and time associated with hiring consultants for report creation, Canusa Wood wanted to empower its teams to build reports independently. With the implementation of Power BI, every team member can now create custom reports, granting salespeople the ability to access real-time information and make more informed decisions to optimize the customer journey.

  • New Business Opportunities

By implementing a SQL database and Power BI, Canusa Wood has unlocked new potential, including the ability to introduce automated pricing into their system. Salespeople can now easily access pricing information for any product, empowering them to conduct real-time price analysis and import pricing data for thousands of SKUs and branches into their ERP.

  • Productivité accrue

By centralizing data in their system, the sales team can now collaborate more effectively with sales support. With Power BI, every team member has access to the information they need to make quick and informed decisions. Moreover, as they learn more and market conditions change, they can modify their reporting to suit their evolving needs.

obturateur 444919042 mis à l'échelle e1591660987280