In 2021, Living Water was evaluating its current financial system reporting and business intelligence strategy. During this time, the organization considered exploring the value of additional modules such as the Vena Power BI Connector to their Vena Solution financial planning system. The overall goal was to position the organization to become more agile with the addition of Power BI to make more real-time decisions.
“This time last year, I met with William and several other vendors. We were looking for a vendor that had the expertise to utilize Power BI with best business practices and experience with Vena Solutions and Salesforce. [ProLytics] met those needs and they were a top contender in the Power BI experience and was unsurpassed, and made it a clear choice for us,” says Kevin.
Before the implementation, Living Water was already building its financial reports through the Vena platform. The Living Water FP&A team had limited experience with Power BI as the organization had yet to fully utilize and integrate the BI platform into their Financial Reporting process. The Living Water team was exploring new ways to take their reporting process to the next level with Power BI to build the necessary reports and get the views required on time.
The most significant priority was creating dimensionality between Living Water’s global operations along with role-level security to allow its business users to filter reports by department and country. In addition, the user permission had to be set in a certain way in which each country manager only has exclusive access to their location’s data. From monthly data refreshes, the second requirement was the ability to regular data refreshes to ensure the accuracy of business data to be as close to real-time as possible.
In reflection, Kevin notes: “This is Power BI 1.0 for our organization. One of the main reasons we had a team like ProLytics come in was to lay the foundation and to help us get started on a solid foundation. There is a bit of a learning curve with DAX, but same as Excel formulas once you start using them, you start learning more new and complex formulas from there.”
In the future, Living Water wants the ability to disclose and embed specific reports onto the website for the appropriate level of users. This way any stakeholders and executives who have questions are able to drill down and search for the necessary financial information they need.
Our team of experts is committed to working closely with each customer to achieve their goals, deliver value-added technology solutions, and aid informed business decision-making.
Date: Tuesday, April 4th, 2023
Time: 12:00 PM – 1:00 PM EDT
Are you running a professional services organization? Interested in a low-effort modern planning tool to create more accurate budgets, identify potential cost savings, and optimize your resources? Join us for a short discussion where we explore the advantages of how utilizing modern planning and data analysis can enhance your reporting on timekeeper costs and profitability.
Discover the valuable organizational insights that can be gained from reporting dashboards, leading to improved profitability analysis and forecasting accuracy.
It’s our pleasure to announce that we have the honor of having, Pat Carrano, CFO at Loopstra Nixon LLP, a Toronto-based Law Firm, as our guest speaker.
This webinar is perfect for legal professionals who want to improve their law firm’s profitability, streamline their financial processes, and gain a competitive advantage in the marketplace. Whether you’re a managing partner, financial controller, or billing manager, this session will provide you with valuable insights and strategies to improve your firm’s financial performance.
We will be in touch shortly! By subscribing to ProLytics Consulting Group, you will receive the newest updates from us regarding our services, any changes, events, news and more.