Microsoft Fabric for finance professionals: What you should know

Table of Contents
Table of Contents
Recently, Microsoft announced the launch of Fabric. Maybe you met Fabric for the first time when you logged into PowerBI and found new branding, options, and features! So, what is in Microsoft Fabric for finance professionals?
Microsoft Fabric is marketed as a โunified data analytics platform.โ The goal is to bring together datasets across your organization with clear control and permissions. But what will this mean for how we -corporate finance professionals- use and interact with datasets, dashboards, and more?
As Microsoft Fabric is rolled out in numerous companies, this quick guide can act as a compass to help you navigate through the changes this new tool presents. Letโs dive into learning what it means for our day-to-day life in corporate finance.
In recent years, Microsoft has rolled out a series of products and features that have fundamentally altered the landscape of data and analytics. The latest iteration in this series is Microsoft Fabric. Microsoft describes Fabric as a โunified analytics platform.โ But, what does that really mean?
In many ways, Microsoft Fabric can be viewed as a new branding and positioning of its existing services, but with added features and functionality. This is a new and unified approach to how we handle our data. To get a better grasp of Fabricโs role within the ecosystem, the diagram below from Microsoft paints Fabric as a new and refreshed umbrella, covering many tools that you may already be leveraging.
Many of these tools and sources may appear familiar. In fact, the purpose of Fabric is to unite data and the services that live on top of it into a common brand.
So, what does all of this mean for us, professionals working in corporate finance and accounting?
Letโs be clear: Microsoft Fabric is not a finance-specific product. Instead, it is a platform that enables individuals across various departments, including finance and accounting, to leverage its robust data and analytics features. For those of us in finance and accounting, weโll mainly benefit from Fabricโs capabilities in data unification, enhanced data governance, and more.
Most corporate finance teams struggle with segmented, siloed data. Your marketing team might lean on an analytics dataset for calculating optimal channels. Your accounting data may include spend information that doesnโt tie and match this information. This creates a back-and-forth that requires constant reconciliation and disagreement.
Hereโs the thing: when every stakeholder has to set up their own datasets, youโre sure to end up with disparate data. Without a unified data platform, itโs not unlikely for teams to choose separate, disconnected data tools.
In nowadays corporate finance, every function is data driven. The problem begins when the functions canโt agree on the data that they act upon. With each team working in its own silo, itโs impossible for the team to harmonize its goals and efforts. This is the promise of a unified data platform like Microsoft Fabric.
One key feature that Microsoft is implementing alongside Fabric is Microsoft Copilot for data insights. This AI-powered companion can answer questions about data. And since itโs plugged into the broader Fabric ecosystem, you could apply this to data across your organization.
Here are a few features Microsoft has confirmed as additions for Power BI environments by way of Copilot:
The good news is that if youโre already comfortable in tools like Power BI, you wonโt have to adapt many of your approaches to use Microsoft Fabric. I think of Fabricโs advantages as occurring somewhat โupstreamโ of the end user. Rememberโitโs a unified platform that intends to tear down the walls between business users.
Most FP&A teams wonโt directly set up Microsoft Fabric. Typically, turning on Fabric is administered by IT teams that already own the existing Microsoft setup.
Here are some good conversation starters that can help us bridge the gap to our IT and infrastructure teams:
Each of these can serve as a compelling โwhyโ for adopting Microsoft Fabric in your company. If youโre feeling that data is disjointed, siloed, and confusingly secured, adopting Fabric might make sense.
Another powerful feature within Microsoft Fabric is Data Activator. This tool flags and highlights changes and actions within data. Activator is also a no-code tool. This tool is built with analysts in mind. This type of feature enables you to set rules based alerts for data changes.
Here are examples provided by Microsoft as part of the release related to Data Activator:
This feature could help drive more conversations with your business partners. If you can โpushโ data out to users when action is needed, youโre more likely to drive the needed action.
Above all, Microsoft Fabric seems focused on reducing silos in datasets. Iโve seen Power BI roll out in many organizations, and too often, it becomes a โkingdomโ approach. Each team launches their own datasets in separate workspaces. Teams spend time trying to explain correlations and differences between sets.
I expect that many organizations will use Microsoft Fabric to bring more business partners into the fold on exploring and analyzing data. After all, good FP&A begins when you connect everyone in an organization together. When itโs simpler to aggregate and share data across your teams, youโre more likely to engage your business partners.
Microsoft continues to make it clear: the landscape of data and how we interact with it will continue to evolve over time. And as the needs and uses expand, so too will the product offerings. The latest chapter โ Microsoft Fabric โ feels like an opportunity to unify many services and platforms and make them better.
If you work in a company that is already using Microsoft products for much of its tech stack, itโs worth a conversation with your IT partners about enabling Fabric within the organization. Youโll continue to take advantage of data availability through tools like Power BI, now with more features to action and manage that data.
How do you keep employees motivated and engaged in the workplace? There are several strategies, one of which is talent mobility. Generally speaking, talent mobility is the practice of using internal talent to fill positions within your company. However, talent mobility goes far beyond that. โUnlike succession, which is typically a top-down approach, talent mobility [โฆ]
What does good leadership mean in the era of hybrid and remote work? What kind of leadership style is best to keep productivity high and promote an ethical workforce? As the title of this article suggests, we may have a straightforward answer for you. However, it might not be so simpleโstay tuned for the twist [โฆ]
There are three words that have transformed business intelligence (BI) into one of todayโs most popular topics: data, data and data! Thatโs right. Not too long ago, the most important decisions of a company were defined by accumulated experiences and intuition. Today, however, effective management is defined by actionable, data-driven information. Gone are the days [โฆ]