Power BI

From Insight to Action Inside Microsoft 365

Posted by Jens Vestergaard on in Community 0 Comment

Turning Data into Everyday Decisions with Microsoft 365

In today’s business landscape, the true value of data lies not just in its collection, but in its ability to drive timely, informed action. Yet, for many organizations, the journey from analytical insight to real-world impact is often slowed by disconnected tools and siloed workflows. What if your teams could access the latest business intelligence right where they work without ever leaving their core productivity apps?

With Microsoft Fabric and Microsoft 365, this vision becomes reality. By embedding data insights directly into familiar tools like Excel, Teams, and Outlook, organizations empower employees at every level to make smarter decisions, collaborate seamlessly, and respond proactively to changing conditions. No more toggling between dashboards and emails; actionable intelligence is now woven into the very fabric (see what I did there? 😏) of daily operations.

This blog post explores how integrating analytics into everyday workflows transforms not only how decisions are made, but also how organizations build a resilient, data-driven culture. Through real-world examples and practical strategies, discover how you can bridge the gap between insight and action; fueling agility, innovation, and sustained business growth.

Embedding Data Insights Directly into Daily Workflows

As organizations look to bridge the gap between analytical insights and daily decision-making, Microsoft Fabric empowers teams by seamlessly integrating data flows from OneLake through Power BI and directly into familiar Microsoft 365 applications such as Excel, Teams, and Outlook. This connected experience ensures that actionable intelligence is available at every touchpoint where work happens, streamlining collaboration and enabling users to embed dashboards, visualizations, and data-driven recommendations into their everyday workflows. To maximize adoption, leaders and managers should prioritize hands-on training, showcase quick wins within business units, and encourage a culture where employees regularly consult and share insights surfaced in their core productivity tools. By embedding analytics within the fabric (oops, not…) of daily operations, companies accelerate the translation of insights into strategic action fueling a more agile, informed, and data-driven organization.

Check out some of the public case studies that displays this approach:

Heathrow Airport Data-Driven Operations with Microsoft 365 and Power BI

Heathrow Airport leverages Power BI, embedded within Microsoft 365 tools, to provide real-time operational dashboards accessible to staff across departments. This integration enables instant access to current metrics and supports agile decision-making in fast-paced airport environments.

Heathrow prepares rather than reacts: uses data to deliver airport calm | Microsoft Customer Stories

Marks & Spencer: Empowering Employees with Embedded Analytics

Retail giant Marks & Spencer uses Microsoft Fabric’s data pipelines and Power BI to embed relevant business insights directly into Teams and Outlook. This approach helps store managers and staff receive timely updates and analytics, improving customer service and operational efficiency.

UK retailer, Marks and Spencer, uses Azure Synapse Analytics and Power BI to drive powerful insights | Microsoft Customer Stories

Telstra: Streamlining Field Operations with Automated Insights

Australian telecom leader Telstra connects data sources using Microsoft Fabric and OneLake, delivering up-to-date analytics via Power BI dashboards within Microsoft 365 applications. Automated refreshes and workflow triggers ensure that field teams always have the latest insights for customer service and maintenance tasks.

City of London: Predictive Analytics for Public Services

The City of London Corporation integrates predictive analytics into routine communications with Microsoft 365 apps. By enabling feedback loops and tailored dashboards, different departments improve service delivery and strategic planning based on actionable, up-to-date data.

Using predictive analytics in local public services | Local Government Association

Driving Proactive Insights and Continuous Business Impact

Building on this momentum, organizations should also leverage Microsoft Fabric’s robust automation features, such as scheduled data refreshes and workflow triggers, to ensure insights remain current and relevant as business conditions evolve. By connecting data sources in OneLake with Power BI, teams can automatically surface the latest operational metrics, customer feedback, and performance trends directly inside their Microsoft 365 environment. This proactive approach empowers employees to make informed decisions faster, supports cross-functional alignment, and fosters continuous improvement. Ultimately, the integration of Fabric with Microsoft 365 not only democratizes access to data but also drives sustained business impact by turning everyday interactions into opportunities for insight-driven action.

Looking ahead, organizations can further amplify these benefits by fostering close collaboration between IT and business stakeholders to identify high-impact scenarios where embedded analytics can streamline processes and drive measurable improvements. Encouraging feedback loops and iterative enhancements within Microsoft 365 such as customizing dashboards for different roles or integrating predictive analytics into routine communications. As adoption matures, businesses not only gain from faster, more accurate decision-making but also build a culture of continuous learning, where actionable data is woven into the very fabric (oops, I did it again) of their daily operations and strategic planning.

Cleveland Clinic adopted Microsoft Power BI and Teams

Monitoring operational performance and patient outcomes, resulting in faster response times and improved care coordination.

Microsoft PowerPoint – BIAS-2022 Presentation – Mark Ruffing.pptx

Sustaining Momentum: Building a Resilient Data Culture for Long-Term Success

To sustain and scale these gains, organizations should invest in ongoing education, governance frameworks, and robust support structures that empower users at all levels to harness the full potential of integrated analytics within Microsoft 365. By cultivating data champions across departments and encouraging best-practice sharing, companies can drive widespread engagement and innovation. This continuous reinforcement ensures that as new features and use cases emerge within Microsoft Fabric and the broader Microsoft 365 suite, teams remain agile and equipped to extract maximum value from their data assets, transforming every interaction into an opportunity for business growth and competitive differentiation.

As Microsoft Fabric’s capabilities continue to evolve, organizations poised for long-term success will embrace a proactive mindset experimenting with advanced AI integrations, tailoring analytics for emerging business needs, and regularly revisiting their data strategies to ensure alignment with broader digital transformation goals. By facilitating ongoing dialogue between business leaders, IT professionals, and end users, companies can adapt swiftly to new opportunities and challenges, embedding a resilient data culture that not only supports current operations but also lays the groundwork for future innovation. This commitment to continuous improvement and cross-functional engagement transforms Microsoft 365 from a suite of productivity tools into a dynamic engine for insight-driven growth, ensuring that every strategic initiative is grounded in timely, actionable intelligence.

Siemens: Accelerating Digital Transformation Together

Optimize supply chain processes, driving efficiency and innovation across their global operations.

Microsoft and Siemens: Accelerating Digital Transformation Together | Microsoft Community Hub

Key Points:

  • Embedded Analytics: Microsoft Fabric enables organizations to deliver dashboards, visualizations, and recommendations directly into Microsoft 365 apps, making insights accessible and actionable for all users.
  • Adoption Strategies: Success depends on hands-on training, showcasing quick wins, and encouraging a culture of regular data consultation and sharing.
  • Automation & Proactivity: Features like scheduled data refreshes and workflow triggers ensure that insights remain current, supporting agile and informed decision-making

Resources:

2.000 members milestone

Posted by Jens Vestergaard on in Community 0 Comment

It’s only been a couple of months since I took over the reins from co-partner Erik Svensen (t|l) for the Danish Power BI User Group. But even just a few months in, I see and appreciate all the hard work and effort Erik has put into this user group. It’s because of Erik’s relentless efforts over the past four-five years that I can now announce that the user group has 2.000 members!

Bravo Erik – Well done!

Power BI Community Tour

Posted by Jens Vestergaard on in Programming 0 Comment

Blog post in Danish 🙂

Om lidt under en måned (25/4-27/4) ruller Power BI bussen afsted og gør sit første stop på Power BI Community Touren 2022. Mere præcist, så begynder vi i Lyngby, kører videre dagen efter til Odense og runder Touren af i Aarhus. Så alt efter hvor du er i landet, vil der være god mulighed for at deltage.

På hvert stop vil der blive disket op med introdultion og best practices indefor de forskellige elementer af Power BI. Med oplæg om Introduktion til Power BI, Data Loading & Mashup, Data Modellering & DAX, Data Visualisering og Distribution og deling vil alle hjørner være dækket.

Der er tale om oplæg der retter sig mod begyndere eller meget let øvede brugere af Power BI, og du kan her få en tryggere start på din rejse med Power BI.

  • Har du brugt Power BI, men mangler at vide hvordan det hele hænger sammen?
  • Har du importeret noget data i Power BI, men mangler at vide hvordan man organiserer sine tabeller?
  • Har du lavet en Power BI rapport, men mangler at vide hvordan man bedst visualiserer dataene?
  • Har du udviklet nogle rapporter, men mangler at vide hvordan du deler dem med dine kollegaer?
  • Har du aldrig brugt Power BI, men vil gerne vide mere om hvorfor det er et af de mest populære rapporterings- og self-service BI værktøjer?

Hvis du svarer ja til ét eller flere af disse spørgsmål, så er Power BI Community Tour for dig. Hvis ikke – så send meget gerne denne information videre til relevante kollegaer!

Sign up her: https://lnkd.in/eVzcBMvp

En stor tak til JDM, Kapacity, Microsoft og Seges for at stille lokaler og forplejning til rådighed.

[Issue] – The Mystery of the Hidden Column

Posted by Jens Vestergaard on in Programming 0 Comment

Yesterday I was trying to setup a new Power BI dashboard for our SQL Server Analysis Services logging data.
We are running traces on most of our servers, in order to keep up with what is going on – this mainly because all other access to the boxes is restricted.

Now, having the data in a SQL Server database, the connection to Power BI Desktop is of course supported out of the box, no issues here what-so-ever, one should think. I however, came across creating a particular view on top of a table, the just didn’t compute in the Power BI Desktop Designer. As depicted below, the view in question would just not be possible to load/edit. Microsoft is looking into this.

View Error

I managed to get around the view issue by persiting the data in another table, consolidating and filtering to only have relevant data there.

Loading the data, from the table into Power BI Desktop Designer is easy, you just point to the server, pick the table and you are presented with two options, either to load or to edit. In this case I opted to load the data. I started playing around with the data and quickly discovered that I was missing out on some attributes in the data. For one thing I needed to convert my date to day, month and year (would have loved some basic week functionality as well, but maybe later eh?).
This functionality is actually build into the tool (Power BI Desktop Designer), so you can generate those extra columns by selecting “Add column” in the ribbon, select the desired date (if you have more) and choose from one of the many options in the “date convert picker”

Month Date Selector

– apologies for the screenshot in Danish.

The above selection will yield the Column you see in same screenshot, named [Month No], and as you can see, it returns a number. This is not very end user friendly, so a little convertion is in order.
The normal Excel IF(test, success, fail) does not work in the Power BI desktop Designer, we need to write it a little bit differently – this is how I convert month number into text:

if Text.Range([Month No],0,1) = "1" then "Jan" else 
if Text.Range([Month No],0,1) = "2" then "Feb" else 
if Text.Range([Month No],0,1) = "3" then "Mar" else 
if Text.Range([Month No],0,1) = "4" then "Apr" else 
if Text.Range([Month No],0,1) = "5" then "May" else 
if Text.Range([Month No],0,1) = "6" then "Jun" else 
if Text.Range([Month No],0,1) = "7" then "Jul" else 
if Text.Range([Month No],0,1) = "8" then "Aug" else 
if Text.Range([Month No],0,1) = "9" then "Sep" else 
if Text.Range([Month No],0,2) = "10" then "Oct" else 
if Text.Range([Month No],0,2) = "11" then "Nov" else 
if Text.Range([Month No],0,2) = "12" then "Dec" else 
"Unkn"

as a custom column:

User Defined Column MonthPlease note the little green check mark indicating everything’s Dandy (b|l|t)… No not that Dandy….

But to my great surprise, the column does not show up in the data source view (or whatever they call it in Power BI Desktop Designer) – Look for [Month Name] as I renamed the column from [Month] in a later step.

Data Source View
WTH is my column?