This post addresses a common scenario where a business unit may have multiple copies of the same Excel file that they need to aggregate into a consolidated data set for reporting.
Learn how to work with SharePoint Multi-value columns in Power BI!
Many organizations who use Office 365 use SharePoint lists to keep track of data. It can be any number of items. We’ve seen process information, project tasks, inventory, and more being managed in Power BI. Power BI provides a SharePoint list connector that connects to the SharePoint OData connector. Theoretically, it should make the connection […]
Many Power BI reports and dashboards have simple, color-based indicators, commonly referred to as Key Performance Indicators or KPIs. These indicators provide a way to communicate the current condition of a monitored metric. These KPIs require the data consumer to: Trust the data used to calculate it Understand the rule used to derive the indicator […]
Learn how to add needed context to your business intelligence content easily using Microsoft Power BI and Microsoft Sway. The results will amaze you.
Learn how to engage executives with metrics that matter in our new #PowerBI Book, “What Does Your Data Say?: With Conversation-Centric Design.”
Business Intelligence enables you to engage in richer conversations with your leadership about your business’ performance. Facilitating these conversations is key to your success.
Are you accidentally exposing confidential data with Microsoft Power BI? You may if you are misusing the Publish to Web functionality. What is Publish to Web? Publish to Web is a function that enables you to share your Microsoft Power BI content with the world. For example, if you are a government agency and you […]
Prevent data source changes from breaking your Power BI model! This technique allows your data models to refresh while giving you time to address the change
Whenever I start a conference presentation, I lead with “Business Intelligence is not just reporting!” This comes about as a call to get new Power BI users to look more broadly. If all you are doing with Power BI is replicating the Excel spreadsheets you already have, you are missing out on significant value. If […]