Category: Business Intelligence
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 […]
I was working with some bookmarks in a Power BI model earlier when I noticed that in some cases the Filter pane was expanded and in other cases, it was collapsed. I was intrigued so I started investigating. It seems when you save the bookmark, it now retains the open/close state of the Filter pane. […]
In an earlier post, I wrote about how to mine the OCR data from Office 365 document folders using Power BI. During the research for that post I discovered that the photo EXIF data is also available for analysis from Office 365. I’ll show you how to get to it in this post. What is […]
On occasion, useless solutions like this will be posted as they may not be directly useful in production, but they are educational in value and can lead to useful work. Oh goodness, what have you done? This post originally started as a joke at dinner with Adam Saxton of Guy in a Cube and Jason […]
If you need to do use small-multiple visualization in Power BI, see the easiest way to do it, using the Infographics Designer custom visual!
I’m so excited to see Optical Character Recognition (OCR) working natively now in Office 365! I got my start in government where we scanned a lot of documents. There was a lot of data locked away in those images but no easy way to mine it. OCR was explored as a possible solution, but it […]
Part 2 of this series explores the difficulty in determining whether your business intelligence content is using authentic data. To illustrate the point, let’s examine a recent Seattle Times article about the Measles outbreak happening in Washington. An Example The article in question, “Are measles a risk at your kid’s school? Explore vaccination-exemption data with […]