"We were encouraged because Softjourn asked the right questions and involved people with the right experience in our conversations."
PEX: Leveraging Power BI to Save Time & Encourage Data-Driven Decision Making
We helped a client deliver a Power BI solution that will help them harness the power of their data.
ABOUT THE CLIENT:
The Challenge
PEX wanted the ability to analyze key data elements, indicators, and visualizations from multiple data sources to better drive their business and future projects. They also wanted to utilize the data to provide more insights for their clients when using PEX's platform.
The Solution
Softjourn team members worked closely with PEX engineers to design and build a data warehouse, which enabled the analysis of a decade's worth of data in seconds. Power BI allowed the PEX team to gain valuable insights from their data.
The Benefits
By leveraging Power BI, PEX experienced the following benefits:
- Immense time savings
- increased information availability
- More actionable information
- Elevated scalability
The Client
PEX, a New York fintech company founded in 2006, is a platform provider of next-generation corporate card and expense management solutions for businesses. The PEX service enables companies to manage employee spending, payments to vendors, and distribute funds to program enrollees.
PEX distinguishes itself due to its platform offering a multitude of sought-after and remarkable automated functionalities, seamless integration with highly desired applications, and the guarantee that its platform can scale alongside its clients' businesses, irrespective of company size.
Our History
We've been working with PEX since 2012 when we first helped them design and develop their mobile application. Over the last decade, we've partnered with PEX on numerous other projects, from their CRM, integrations, design, marketplace, and much more.
This time, we helped deliver this client a solution that would help them harness the power of their data. PEX holds a significant position in the prepaid market, boasting a substantial client base that relies on PEX's card and expense management solutions. As a result, there existed a substantial volume of data that needed to be securely stored and readily accessible to both the PEX team and their clients.
Toffer Grant, Founder & CEO of PEX
The Challenge
PEX wanted the ability to analyze key data elements, indicators, and visualizations from multiple data sources to better drive their business and future projects. They also wanted to utilize the data to provide more insights for their clients when using PEX's platform.
Being in business for over a decade, PEX has a tremendous amount of data. Actionable insights were trapped within the data, and PEX needed a way to enable its business stakeholders to easily gain those insights.
While it was critical that PEX leveraged its data more efficiently, their engineering team needed to continue to build valuable features for their customers, so they turned to Softjourn to help provide experts in database and Power BI development.
Our team has always enjoyed partnering with PEX over the last decade, so we were eager to ensure the accuracy and efficiency of their data collection. Softjourn's overarching goal was to provide actionable and scalable intelligence to our client's various teams and stakeholders.
The Solution
Our client tested several solutions before deciding Power BI suited their needs best. Power BI is a powerful Microsoft business intelligence tool that converts various data into visually coherent, actionable insights.
Although implementation is complex, we encourage our clients to utilize Power BI because it comes packed with exceptional features and functionalities for data analysis.
Softjourn team members worked closely with PEX engineers to design and build a data warehouse that enabled the analysis of a decade's worth of data in seconds. Power BI allowed PEX team members to gain valuable insights into their data.
PEX didn't just want to build a set of reports for one-time use but to create a sustainable architecture that made the overall solution highly maintainable. To help with this, Softjourn team members worked closely with PEX to understand the business meaning of the data and developed comprehensive documentation that enabled continuous improvement of the data warehouse and business intelligence solutions.
By transforming the data into charts, graphs, and other high-quality visualizations, the PEX team can self-service to gain valuable data insights with minimal effort.
To further innovate on the business intelligence architecture, PEX built a customer-facing analytics capability that allows customers to gain insights from their own data. This solution is called PEX Spend Analytics and is available in the PEX marketplace.
The Benefits
Softjourn's experts have deep experience working with Power BI, and we highly recommend it as a phenomenal tool for large companies, like PEX, that work with massive amounts of data.
By leveraging Power BI, PEX will experience the following benefits:
- Immense time savings - Valuable data insights are available to end users who can self-service to build their own reports, freeing up Engineering resources to focus on building more value for PEX customers.
- Increased information availability - Our client's team can quickly and independently look for specific data.
- More actionable information - PEX's team and clients can now use visuals and other Power BI tools to make data-driven decisions.
- Elevated scalability - PEX's capacity to leverage data expands proportionally with the growth of its user base and service offerings. This solution seamlessly adapts to accommodate their expanding data needs.
Conclusion
PEX was delighted with the results of our work together, and recently, they launched a Spend Analytics app powered by Microsoft Power BI Embedded. This powerful app gives small and medium enterprises the same analytics capabilities usually reserved for larger enterprises.
Softjourn is committed to furthering the adoption and accessibility of Power BI, enabling our clients (and their clients!) to harness its tremendous capabilities. Our focus is on enriching our clients' platforms with scalable data solutions that deliver impactful results for their businesses.
If you are seeking to optimize your platform with cutting-edge data tools tailored for business success, do not hesitate to contact one of Softjourn's experts and embark on your Power BI journey!
Partnership & Recognition
