After you register your custom applications with Azure Active Directory, it’s straightforward to build a completely remote application for working with Office 365 SharePoint data which depends only on the SharePoint REST web services. Angular SharePoint App Demo Below is… Read More ›
Office 365 and O365
Microsoft Excel – Data Validation Functions and Conditional Formatting
Microsoft Excel has numerous functions and features that are used to validate data and apply conditional formatting to cells. Below we’ll see how to combine these features along with the CODE, ISNUMBER, and LEN functions to make quick work of… Read More ›
SDL – Security Development Lifecycle – Threat Modeling – DREAD
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
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 ›
Office 365 SharePoint Usage Report and Excel Weekday Function
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 Excel and Microsoft Azure SQL – Power Pivot Demonstration using AdventureWorks
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 ›
Microsoft Excel – Sales Order Invoice Totals by Month – SUMIFS and EOMONTH
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 ›
Power BI – Merge Queries – Client Invoices and Related Tables through SharePoint Lookup Columns in Office 365
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 ›
Power BI Reports for SharePoint CLM Tasks – The Colorblind Theme and Using a Visual Level Filter
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 ›
Power BI – Power Query Editor – Converting Dates From Another Locale – Expense Report Example
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 ›