Many businesses have their fiscal calendar that’s different from Gregorian calendar and for analysis/reporting purposes we need to easily translate between the two. In this blog, I’ll show how to do just and then do a summary of expenses by fiscal quarters from a dataset of Gregorian calendar dates. Then I’ll also demonstrate turning that […]
Blog
Classifying customers by age (Bin, Bucket, Category)
In this blog, I’ll share a method to map customers, based on their date of birth, to appropriate classification (for analytics), and appropriate price for services as per an established table/scheme. This will be done in Excel. Objective Imagine the business owner has a different pricing scheme based on customer categorization; a common practice. The […]
NFL 2019 regular season is done. What have we learned?
Now that the 2019 NFL regular season is in the books, we have complete data available about the teams’ performances. What can we glean from them? In this blog, I share some findings, answers, and the process of analytics behind discovery of the answers. I will focus on overall team performance data, not individual positions, […]
A Real Data Merge Challenge (Excel)
Instead of demonstrating what each of the thousands of functions does in Excel, it’s most helpful, I think to demonstrate how to solve real-life scenarios and the formulas that come in handy as secondary. Today, I present this. The Challenge: You are given 2 datasets of fruits and their prices. One set includes some items/fruits […]