Saturday, October 04, 2025
Analytics Education STEM

Organizing raw dataset to creating impactful, interactive visualizations (Excel, PowerBI)

In this post, I’ll walk through the steps starting with a raw dataset that’s organized differently from what I need, to reshaping the data using Excel formulas, and creating an interactive visualization using PowerBI, to publishing it online using PowerBI. Excel and PowerBI work hand-in-hand to solve such problems effectively, and efficiently. First, I’ll start […]

Read More
Analytics Coding STEM

Data extraction with multiple criteria with interactive UI

Imagine we are business owners who provide a range of services. We have a large set of customer data but we  really want to target those customers who might be interested in your services. We want to extract only that subset of data based on our services. And since we provide multiple, diverse services the […]

Read More
Analytics Education STEM

Analyzing 10 Years of Patriots Performance: NFL

Love em or hate em, New England Patriots is a team to reckon with. They’ve implemented numerous creative and suspicious internal strategies that most  other teams would love to copy or at least understand. Well, I cannot expose those details as they’re not available anywhere. What is available however is their scores and stats. So, […]

Read More
Analytics Coding Education STEM

Tracking Actual vs. My Predictions 4/29/20

Back in March 2020, I did some predictive modeling using simple math and Excel where I presented 3 scenarios: Likely, Best-case, Worst-case. You can read the original blog here: What-If Models (COVID-19): Results Let’s take a look at today’s latest data from WHO and compare my Model 1: Likely Scenario numbers. We’ll compare the USA […]

Read More
Back To Top