Activity
Mon
Wed
Fri
Sun
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
What is this?
Less
More

Memberships

The SKOOL Directory

531 members • Free

Data Innovators Exchange

681 members • Free

Business Analysis Institute

1k members • Free

Excel Analytica

243 members • Free

Everyday Analysts Hub

137 members • Free

2 contributions to Excel Analytica
What Excel Creation from 2025 are you Proud of?
I know some of us do most things at work and may not be able to share a screenshot (myself included) but let's hear what are the amazing things you've created / done in Excel this year! I'll Start us off. ⬇️ _______________________________________________ I do a lot of work in forecasting and analysis and showing how a metric trends over time (like a product's price) is pretty standard. Line charts work, dot plots work also. But I also needed to show how many units were getting sold each of these days. You can overlay a bar chart, and that works, but visually communicating volume works great if each dot gets lighter with less volume. And that's what this chart does. Solid Dots have high volume. Very light dots have very little volume. Your eye immediately sees where volume is greatest, and has the biggest effect on results. I used this visual to help explain a hot-button issue and it immediately got shared with executives in multiple departments — big credibility booster. What's something you're proud of? — New Function You Learned — Process you improved — Challenge you Overcame
What Excel Creation from 2025 are you Proud of?
1 like • 19d
Dot plots are my favorite—especially when there are two independent variables! The only thing to remember is that correlation ≠ causation, but we can still demonstrate correlation strength when recommending a strategy. I’ve used this in the past to prove how a data automation project reduced scrap by providing operational visibility into interchangeable materials. Has anyone else used this type of chart for a specific analysis? I’d love to hear what other use cases you've found for it.
Hey everyone! Joining after 5 years of Data, PM, and "organized chaos."
I’ve realized that even the cleanest query fails to address the issue if it doesn't solve a stakeholder’s actual 2 AM headache, so I'm here to bridge that gap with a more consultative mindset. I’m excited to share some of my automation frameworks, but I'm also here to pick your brains on the new tools and workflows you're using to stay ahead! Is there an Excel/data feature that saved your day/night? Or one that you just can't wrap your head around? (I still use V/HLOOKUP over XLOOKUP 😅)
1
0
1-2 of 2
Kenny Lam
1
3points to level up
@kenny-lam-1878
Business Intelligence Consultant

Active 8d ago
Joined Feb 23, 2026
Powered by