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 and Microsoft Azure SQL – Power Pivot Demonstration using AdventureWorks

  By Christopher Brotsos on October 6, 2018 • ( 0 )

  

  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

  By Christopher Brotsos on October 3, 2018 • ( 0 )

  

  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?

  By Christopher Brotsos on October 2, 2018 • ( 0 )

  

  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 ›

• Microsoft Excel – Sales Order Invoice Totals by Month – SUMIFS and EOMONTH

  By Christopher Brotsos on September 28, 2018 • ( 0 )

  

  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

  By Christopher Brotsos on September 26, 2018 • ( 0 )

  

  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

  By Christopher Brotsos on September 24, 2018 • ( 1 )

  

  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

  By Christopher Brotsos on September 21, 2018 • ( 0 )

  

  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 ›