Wednesday, November 18, 2026
Analytics Coding Education STEM

Complementary post to: Pop Quiz [And Solutions With Low Code!]

This post is a continuation of or complementary post to about using Excel and SQL for pop-quizes. Please read that first to get proper context…otherwise, this wouldn’t make much sense. As discussed in the post linked above, the SQL queries can be saved from Microsoft Query Editor to an external file. It’s really convenient because […]

Read More
STEM

Understanding Trends: Real-world example

Trend analysis is a pivotal part of business analytics, project planning, marketing, and virtually all aspects of strategic planning and understanding of patterns/behavior. In this post, I present a straight-forward but very practical use of some analytics and walk you through: 1) Data collection 2) Data cleanup and shaping 3) Creating trends and understanding the […]

Read More
Analytics Coding Education STEM

Raw Data to Machine Learning to Decision-Tree: Excel

Machine Learning in Excel? Isn’t ML the new thing, new algorithm that’s only done in the Cloud using R and Python? Nope! We’ve been doing in Excel for many years!! It’s only recently getting a lot of attention with Cloud and large datasets and made much, much simpler to use for today’s Data Scientists— but […]

Read More
Analytics STEM

Waffle Charts (3 methods + bonus)

Certainly! Here’s a revised version of your paragraph: Waffle charts might be familiar to you. These charts are characterized by small squares within a grid, providing a straightforward representation of ratios. This concept is akin to that of pie charts, area charts, or treemaps—the choice ultimately hinges on the target audience and personal taste. Waffle […]

Read More
Analytics Education STEM

Putting together our Presidents (Infographic in Excel)

In several of my earlier blogs, I demonstrated working with raw data from multiple sources to generate visual and statistical analysis. You can find them in the following posts: Let’s Play With All The Presidents (Excel)-Part1 Let’s Play With All The Presidents (Excel)-Part2 Getting To Know Our Presidents In this blog, I share the combined […]

Read More
Back To Top