Many of us today are developing solutions using Microsoft 365, AWS, and other cloud ecosystems as our core platform and computing environment. We also often tie in Azure services, and reach out across the globe to wire-in free (or subscription… Read More ›
Power BI Fitness and Meal Planning with Excel This post demonstrates a Power BI Fitness and Meal planning solution based on Excel data. Power BI is an excellent tool for visualizing important data about the food we consume and provides… Read More ›
At the end of every quarter, I deliver a usage report which summarizes the historical number of users who visited a page in the Office 365 SharePoint Intranet. The metrics data and graphics are created by exporting the Office 365… 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 ›
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 ›
Both professionals and hobbyists depend on Microsoft Excel for scheduling and resource planning, and if that’s the case for you too, then the WORKDAY and WORKDAY.INTL formulas are two essential tools to have in your belt of Excel tools. Both… 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 ›