Creating a list lookup. Many Excel spreadsheets contain data spread across many different worksheets and in collaboratively work environments, worksheets are shared among coworkers. The result of this data separation is that sometimes a scenarios arises when critical data is needed but unavailable by the current spreadsheet. To overcome this limitation, I will use the…

Automate scenario analysis of constraints to achieve goals. Product management leverages numerous factors to achieve optimal success with product outcomes such as constraints (limitations upon resources) and decisions decisions on those constraints. Optimization allows team members to influence certain decisions about constraints, delivering differing results according to the team strategy. In this article, I will…

Implementing Business Rules through Advanced Transformations In this article, I’ll continue from the article [Power Query – Transformations] and illustrate some advanced transformations available in the Query Editor. I’ll begin with the same data from the previous article. Split Column By Delimiter First, I wish to parse “Order ID” values so I end up with…

Automate scenario analysis of constraints to achieve goals. Product management leverages numerous factors to achieve optimal success with product outcomes such as constraints (limitations upon resources) and decisions decisions on those constraints. Optimization allows team members to influence certain decisions about constraints, delivering differing results according to the team strategy. In this article, I will…

Using the Chi-Squared Test to Validate Results When analyzing data it is important to demonstrate confidence the results found using the sample reflects would be found throughout the population, and not random phenomenon. In this article, I will begin with a simple A/B Test determining between two age groups (1-50, 51-100) which constitute the larger…