Author Archives
I am a software engineer, business and systems analyst, program manager, and technical architect with a passion for delivering business strategy and technology. Over the past 15 years I have partnered with dozens of employers and clients to achieve goals across the corporate landscape.
-
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 ›
-
Microsoft Excel – Understanding Template Options
Most users of Microsoft Excel know that the product supports templates. There are the many out-of-the-box templates you are presented with when you first launch Excel, and there is the “Save as Template” XLTX options through which you can save… Read More ›
-
Microsoft Power BI and Excel for Fitness and Nutrition Meal Planning
Power BI is an excellent tool for visualizing important data about the food we consume and provides a method to quickly and easily build an a powerful interface to help with meal planning education and ideas. The purpose here is… Read More ›
-
Microsoft Project – Insert or Unhide Task Name Column
Not too long ago, I accidentally hid the “Task Name” column in a Microsoft Project plan. It wasn’t as obvious as I thought it would be to restore or reinsert that critical column. Here are some options for you if… 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 – Useful Shortcuts
Tables in Microsoft Excel are used frequently. They help with formatting, filtering, sorting, creating ranges, and are even required to light-up or correctly use other features in the application. In this quick post, let me share two shortcuts that I… 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 ›
-
Power BI and Power Query – Human Resources (HR) Performance Review Survey Reports – Unpivot Columns
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 ›
-
Power BI – Remove Rows or use Column Filters?
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 ›
