Power BI Implementation and Tableau Upgrades for a National Tire Distributor

Client

A national tire distributor with over 60 logistics centers provides dealers and retailers across the U.S. with a comprehensive range of passenger and light truck tires.

CLIENT PROFILE
EMPLOYEES: 1,000+
INDUSTRY: Tire Distribution
FOUNDED: 2018
 

The Project Scope

The company was using Tableau and had a plan to move to Power BI because of some desired features. They had a huge backlog of dashboards and reports needed to be built, but with limited Power BI expertise, they were facing throughput challenges. Because of the pandemic, they were also facing cash flow challenges for a period of time. Smartbridge was engaged to bring the necessary resources and expertise to build some Tableau content followed by Power BI content.

Smartbridge has extensive experience in custom application development

Custom Application Development

Key Challenges and Issues

  • They hadn’t used Power BI before so everything was brand new and needed to be implemented.

  • There was initially some resistance to switching to Power BI. Users were accustomed to the self-service capabilities of Tableau and didn’t recognize the value (at first) in switching to Power BI. As part of the development, we also conducted a series of training sessions to make them more comfortable with Power BI.

  • The company was undergoing an overhaul of the EDW and is in the process of refreshing most of the data warehouse schema. This posed a huge challenge since we had to build the front-end on a moving back-end.

Smartbridge Solutions

1. Instead of migrating existing Tableau content to Power BI, with guidance from the sponsor, we started with upgrading some Tableau content followed by creating new content in PowerBI to get buy-in from the business. Smartbridge built a set of Tableau dashboards for primarily 2 groups:

  • Dashboards for Finance

    We built content around daily unit sales focusing on volume.

  • Dashboards for the Car Dealer Team

    These are a set of dashboards addressing various aspects of their car dealer customers, specifically focusing on invoice data, replenishment, and stock status.

2. Smartbridge also created 4 Power BI apps (set of dashboards) for various groups of the business:

  • App for Finance

    Prior to this app, the company was reporting everything according to the volume of tires in Tableau. Now they have reports focused on actual and cost amounts along with volumes.

  • App for Sales

    This app calculates daily incentives for the sales team and also creates reports that are sent to the executive teams on a daily basis. It also includes new customer tracking.

  • App for Operations

    This app is used for stock and inventory analysis. Users can analyze the fill rates for each of the locations and much more.

  • App for Field Sales

    This is used by the executive team to look into the sales team’s performance and comparison.

3. Another small solution we provided the client was automating the email feeds for the organization. Previously when a support email would come in, a support team in India would load the data into a data warehouse. Now the data is loaded into a SharePoint location which is then reported on.

4. Smartbridge also implemented ETL/PowerShell based data refresh triggering to replace the time based scheduling. This removed some of the pain points that the data team was previously facing.

Success Through Customized Tableau and Power BI Solutions

The new Tableau content was very well received by the finance and car dealer teams. Though there was initial resistance to change from the business having to switch from Tableau to Power BI. However, with guided training and education of the features, the end-users are much more excited about this change. Users expressed extreme happiness with the content Smartbridge built with Power BI and are considering an upgrade to the content previously available in Tableau.

There’s more to explore at Smartbridge.com!

Sign up to be notified when we publish articles, news, videos and more!