Here I touch on a quick but effective way to do forecasting based on historical data…this without the help of any chart. Scenario You have data on your customers’ spends at your shopping mall based on how many miles they drive to get there. The dataset is below. Your objective is to find out how […]
Tag: STEM
Creating a GEO learning app in Excel and PowerBI (part2/2)
This is a two-part blog series. To follow along, see part 1 followed by part 2 (this). If you haven’t see a quick animation of the interface, it’s available in part 1. Previously, I demonstrated how to get the dataset ready and create some basic charts in Excel about the states of USA. Now, we […]
Creating a GEO learning app in Excel and PowerBI (part1/2)
In this blog, I’ll show you some very effective and efficient ways to get vital information about all states of the USA, and eventually create visuals, then interactive visuals, then an interactive application online. All from starting with the basic names of states. I wish every kid and adults would have this type of application […]
Automatically Creating Datasets (Excel)
Often we have to start with a sample dataset for experimentation or verification even if the dataset isn’t based on real-life data. In many cases, people start manually typing their own data to create the sample, or search online for some sample datasets. There’s a better way! All data can be automatically generated within Excel […]
Working with Fiscal Quarters (Excel)
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 […]
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 […]
GOTO conference in Amsterdam: Agile
Although the message was delivered about the misinterpretations of Agile back in 2015, few heeded. Or perhaps few could hold back the ocean of this profitable industry with a broom while the proponents pushed a new framework as a methodology to the panicky companies entering the hashtag#programmanagement hashtag#agile 21st century. This clip is of Pragmatic […]
A Christmas Tree in Excel (Happy Holidays!)
Merry Christmas and Happy Holidays, everyone! Here’s a quick and dirty animated tree decorated by me for Christmas in Excel (yes, I have a real one at home but not as wonky). It uses Excel’s basic conditional formatting and number generator functions to create this cute, blinking tree. With a little VBA code, you can […]