Centricity, a leading provider of new home warranties and extended service contracts, wanted to replace its legacy reporting solution with Power BI—Microsoft’s leading solution for self-service reports and interactive data visualizations. To achieve this, Centricity sought AgileThought’s help to implement a Power BI solution, train users on how to properly leverage Power BI’s features, and empower clients with access to real-time, valuable insights on warranty contracts.
AgileThought built a Power BI solution on top of Centricity’s legacy AS/400 system to create on-demand reporting without the hassle of a full system migration. AgileThought led the company through the entire data warehousing lifecycle, which included:
Thanks to Power BI’s real-time insights and advanced data manipulation capabilities, Centricity has reduced turnaround time on complex custom reports by over 50%. Previously, reporting was a spreadsheet-heavy, time-consuming process; now, data is refreshed daily and the company’s clients can apply filters, change parameters and drill into details to provide curated reports and personalized dashboards for each warranty.
By providing greater transparency into warranty service statistics, loss ratios for specific appliances, and appliance failure rates, Power BI has helped the company improve forecasting and pricing strategies. Additionally, Power BI’s easy yet powerful reporting capabilities has given Centricity a significant competitive advantage—even helping the company win new client deals that nearly doubled their annual revenue.
Implementing Power BI required little additional cost except for the purchase of a few Power BI Pro subscriptions, unlike other data analytics solutions that require expensive infrastructure, software licensing and other standup costs. Power BI has not only given Centricity access to deeper insights, but has also paved a path for future innovation: since Power BI is cloud-based, Centricity can quickly scale and adapt to growing reporting demands as needed. And, if the team decides to migrate their entire system to the cloud in the future, they will be able to continue reporting during the migration without disrupting the business.
Using Power BI’s inherent security features, like role-level security, Centricity ensures that each client only sees the warranty data that pertains to their specific accounts. With this personalized view, clients can easily see how many warranties they’ve sold, monitor the status of warranties, and gain new insights into their business.
To accelerate Power BI adoption, AgileThought provided coaching and mentorship through Power BI Ignite—an offering designed to help clients overcome the challenges and pitfalls associated with deploying Power BI in a secure, reliable manner. From data modeling and Data Analysis Expressions (DAX) development to creating security roles, AgileThought taught the Centricity team how to fully leverage Power BI’s robust reporting features. During the handover at the end of the engagement, AgileThought also reviewed other Microsoft technologies with Centricity—like Azure DevOps, Master Data Services (MDS) models and more—to expand the company’s Microsoft expertise and help spread this knowledge to other departments.
Contact us to share the challenges you’re facing and learn more about the solutions we offer to help you achieve your goals. Our job is to solve your problems with expertly crafted software solutions and real world training.
For a better experience on the web, please upgrade to a modern browser.