How Microsoft Treasury uses Power BI
The Microsoft Treasury group manages $158 billion in assets, including cash and investments, account receivable, equity, and other investments. They act as an in-house bank for operations in over 190 countries, monitor thousands of bank accounts, and provide just-in-time cash management on a global basis. With a preview this large, Microsoft Treasury relies on vast amount of data in order to make fast, accurate, and actionable decisions to keep their operations running smoothly.
In the past, Treasury used a combination of Excel, PowerPoint, and third-party services to analyze and present their data, but Corporate VP, Treasurer George Zinn saw the future in the integration of a different product: Microsoft Power BI.
Power BI is a cloud-based suite of business analytics tools that make it easy to combine data from multiple sources, analyze and visualize information, and share insights. It features easy drag-and-drop report authoring for advanced insights, and online web dashboards that update automatically and can be shared with an entire team in seconds. Power BI can work together with Excel to provide innovative data cleaning, visualization, and sharing tools for existing workbooks.
For George Zinn, integrating Power BI into Treasury’s existing daily data maintenance would result in improved sharing across teams and faster reporting, automated real-time updates, and access to both new trending information and deep dives into records.
Although the adoption of Power BI started only months ago, its effects can already be felt within Microsoft Treasury. “Power BI has helped transform our team by providing us with a powerful tool for analytics and visualization,” says Zinn.
Let’s take a deeper look at what Power BI brings to the Microsoft Treasury group.
Answer questions faster
Microsoft’s Capital Markets team, including Group Portfolio Manager Alex Blackmur, manages $158 billion dollars in assets. With such a big mandate, there’s a need to have visibility on where every dollar is invested.
Previously, Capital Markets used a daily dashboard to track their assets. Every day someone would have to export data from a third-party portfolio management solution, use Excel’s powerful tools to massage the data, and then save a screenshot of the current report. That report was then either emailed around, or sometimes even printed and handed out to everyone in the trading room.
While this labor-intensive process meant that the Capital Markets team was informed and as up-to-date as possible on positioning and risk, it was extremely difficult to answer any questions outside of the report screenshot.
Nowadays, the team uses a shared Power BI dashboard that mimics much of the old spreadsheet. Even though the main database for Capital Markets has over 28 million rows of data, it’s fast and easy for them to find the specific information they need. Want to know how much a specific manager has invested in a specific country? It’s all right there.
Joseph Vasen, Group Treasury Manager, faced similar challenges on the Bank Infrastructure team. Bank Infrastructure is responsible for opening, closing, and managing upwards of 1400 bank accounts (each time we acquire a medium or large company we inherit hundreds of accounts that usually have to be closed over time) globally, including coordinating the various signatories needed. Before Power BI, the team relied on canned reports that missed important details and provided little help when answering operational questions.
Vasen says that after launching even just the first iteration of a report in Power BI, his team had access to much more rich analysis. They can discover which banks take the longest to establish new accounts, track the average number of bank accounts over time, and in a few clicks anyone in Treasury can locate who the bank account signatories are.
With Power BI, you can answer critical questions faster no matter where you are. “Power BI is much more dynamic and the delivery method is much more streamlined,” says Blackmur. “We can publish [our data] to the web, get it on our phones, and even print it out if we still want to.”
Find the right level of detail for your audience
The Operations team at Microsoft Treasury handles cash operations and investment operations, and combined they oversee 24,000 trades annually and monitor up to 2000 bank statements (incl. custody accounts) each day. Jayna Bundy, Director of Treasury Operations, and Lisa Wagner, Group Treasury Manager, not only have to keep track of trades with counterparties, collateral management, and cash holdings from around the world, but they also give regular status reports to their own team, other teams, and multiple levels of management.
After adopting Power BI, the Operations team was able to create a number of different dashboards that present the same data in different ways for different audiences. Bundy’s team has dashboards for their own drill down purposes, executive briefings for managerial reviews, and dashboards oriented towards external clients and customers. She reports that with the new dashboards, her team has more visibility than ever into the bank balances with its banking partners and helps slice and dice the data in various ways.
Meanwhile, Wagner and colleagues are using KPI cards and slicers to highlight key metrics in the initial view, and providing examination points for more detail. That way if the Treasurer only wants to see, for example, total payment volume or bank diversification, it’s easily accessible, while Wagner can quickly get to the intra-quarter details she needs to do her job.
Stay updated with real time data and auto-refresh
The Structured Finance team, including Senior Treasury Manager Damaris Sardenberg, provides financial solutions to large scale customers who want to purchase products or services from Microsoft. The Cash Planning team, including Group Treasury Manager Jim Scurlock, manages global cash and banking activities, monitoring balances and subsidiary activity. Both teams, as it happens, are excited about Power BI’s real time data and automatic refresh.
In the past, the Structured Finance team pulled data manually to create graphics. For a team that uses trend-spotting as part of their toolkit, it was an inefficient system. The Cash Planning team had a similar process, exporting monthly reports out of SAP, and later using Power Pivot in Excel. With Power BI, it’s easy for both teams to have access to fresh, automatically updated data from most of their sources, including Excel.
For her part, Sardenberg is thrilled that once the initial report and dashboard views are set up, she doesn’t have to waste precious time and resources to manage data. Instead, the exported reports are saved in a SharePoint site, and Power BI automatically updates from the file per the team’s preset schedule.
Scurlock is equally happy with the benefits of switching to Power BI, and how easy it is to update data. “As a middle manager, I have teams that have to quickly report to me about 400 subsidiaries, monitoring cash and volumes in multiple countries. Seeing the data as fast as we can upload it is key way to get the temperature of the landscape so I can be more proactive. Instead of waiting to get numbers, I can see spikes and quickly address them.”
CLICK HERE to read the full article and find out why Microsoft Treasury trusts Power BI to manage over $158 billion in assets!
To learn more on how Tallan and Power BI can transform your data into powerful visualizations to optimize business processes , CLICK HERE.