You can build an Excel profit and loss spreadsheet using the INDIRECT and VLOOKUP functions. Together, these functions enable you to analyze profit and expense data for your projects. I’ll demonstrate how these functions can be combined to help you… Read More ›
Microsoft makes it simple to deploy Azure SQL Databases. Once deployed, Microsoft Excel and Power Pivot make reporting against those databases a pretty much perfect experience. In this post, I’ll demonstrate how you can connect these technologies and produce meaningful… Read More ›
Power BI has a very useful feature in the Power Query Editor named Unpivot Columns. In this blog entry, we’ll look at an interesting problem with analyzing Human Resources (HR) peer Performance Review survey results, and how to solve that… Read More ›
The data we import in Power BI would always be formatted consistently-and-predictably in an ideal situation, but the likelihood of inconsistencies and changes in delivered reports bring up a critical question you should ask yourself when setting up your edit… Read More ›
We have a common scenario as the basis of this blog post: use Microsoft Excel to calculate sales order and invoice totals for a specific month. Though, for a recent requirement, I had a data set and a few requirements… Read More ›
In this post we’ll look at how to sum-up and report on unpaid Invoice amounts with a currency data type in Power BI using the Merge Queries feature. We’ll see how to manage related tables that have their relationship defined… Read More ›
In this post I’ll demonstrate how to use Power BI for Reports against CLM Tasks (Contract Lifecycle Management) stored in SharePoint. You’ll also see an important use of Visual Level Filters as well as a demonstration of the Colorblind theme…. Read More ›
Many of us work with data in Power BI that includes date and time information mined from sources in different locales or regions of the world than our own. In this post, I’m using a simple CSV of expenses that… Read More ›
In the previous post, we saw Human Resources (HR) import SharePoint list data into Power BI Desktop, and now that groundwork will be used to publish employee lifecycle Power BI Reports and Dashboards to Office 365. The report will consist… Read More ›
Human Resources (HR) can garner meaningful insights using Office 365, the basic Microsoft Power BI functions, and with straightforward SharePoint lists to hold employee lifecycle data. Over the next 2-3 posts, we’ll watch the HR team build Microsoft Power BI… Read More ›