Category: Office 365

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 […]

Learn how to add needed context to your business intelligence content easily using Microsoft Power BI and Microsoft Sway. The results will amaze you.

Business Intelligence enables you to engage in richer conversations with your leadership about your business’ performance. Facilitating these conversations is key to your success.

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 […]

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 […]

When companies begin making their data more accessible via Self-Serve Power BI, they soon reach a critical break point in those efforts. The Project dashboards tell them something that isn’t pleasant or doesn’t match the narrative been publicized. The Reality in Your Project Dashboards Performance indicators go red. The data shows the stellar progress that […]

Are you having tired of waiting for long refresh times with Power BI? Perhaps, you are getting timeouts because you are retrieving too much data. There’s three easy ways to avoid these issues. WHY IS MY POWER BI DATA REFRESH SO SLOW? Many Power BI models refresh slowly as the models are not structured to […]

Visualizing Project Time Project Online supports collaborative work management across your organization. It provides the ability to manage multiple project schedules and allows project team members to enter the time spent on assigned tasks via their timesheet. The timesheet information can then be used for many purposes. Many Project Management Offices (PMOs) have dynamic information […]