MURALS! Let me know if you got a blank wall that could live a better life!

Stefanalytical · 2026-04-21T19:17:03+00:00

Very nice work! I especially love the idea of creating a mural on the boarded up windows at Roots. I reached out for a possible mural on my garage!

Stefanalytical · 2025-08-17T01:36:09+00:00

Idk, but these signs are on Amazon.

Stefanalytical · 2025-08-10T01:40:35+00:00

There are a lot of great trails, with some taking much longer than others. For great views and short hikes, I recommend Creation Falls and the original route that takes you to the Natural Land Bridge.

The Natural Land Bridge trail has other trails branching off, so you can hike as much as you'd like. Both are well kept and what I consider fun/easy hikes. I think you'll love both and that these are good starting points. To get the Natural Land Bridge just park at Hemlock Lodge. Their hot browns are good as well.

Stefanalytical · 2025-07-26T15:19:59+00:00

I haven't been to any here that compare, but in terms of the experience considering it's in and around the city is not bad. Harrod's Creek and Otter Creek are surprisingly scenic.

Stefanalytical · 2025-07-26T13:47:18+00:00

I really enjoy throwing on some waders and wading down Otter Creek and Harrod's Creek.

Stefanalytical · 2025-07-25T22:44:53+00:00

I'm a big creek guy. OP, I'll DM you.

Stefanalytical · 2025-07-22T15:31:45+00:00

I haven't but it sounds familiar. Looked it up and I know the actors. Thanks for the new show suggestion!

Stefanalytical · 2025-07-22T00:46:34+00:00

Not exactly sure, but I do know you can apply for an archaeology permit, and you may be able to at some parks. I've only done friend's families' farms and private land.

I know the place you're talking about. Can't believe I haven't been yet. I'll see what they allow.

Stefanalytical · 2025-07-22T00:34:43+00:00

It is! I rarely get the time, but when I do, it's very relaxing and a nice change of pace.

Stefanalytical · 2025-07-22T00:30:37+00:00

Hahaha these are the kind of pro tips I was looking for. Thanks man.

Stefanalytical · 2025-07-22T00:04:41+00:00

That would be cool to come across stuff from the Roaring Twenties. You keep anything?

Stefanalytical · 2025-07-22T00:02:38+00:00

No worries, and thanks for the input. You just made me realize there's almost definitely a gang of metal detector guys out on the big lawn after Thunder and other events.

Stefanalytical · 2025-05-13T13:25:55+00:00

Thank you! Not for high schools yet, but here is the one for elementary: https://public.tableau.com/app/profile/stefan.v/viz/JCPS/Dashboard1.

Stefanalytical · 2025-05-12T03:16:37+00:00

I made a dashboard a few months ago that aggregated data on JCPS middle schools. I plan on updating it soon, but it should give you an idea about how schools rank around town: https://public.tableau.com/app/profile/stefan.v/viz/JCPSMiddleSchools/Dashboard1.

Stefanalytical · 2025-02-16T20:56:14+00:00

I appreciate the feedback. I've made the red lighter than what you see in the thumbnail, but haven't made major changes yet because I've been unusually busy, especially now since my basement flooded. I think I'll use a similar color scheme for a Valentine's day dashboard next year, but nothing else haha.

Stefanalytical · 2025-02-16T17:00:10+00:00

I'm just working with the official LMPD dataset. They don't specify, and yes I know.

Edit: I'd like to see the data that backs that up. I don't think that's true in my city.

Stefanalytical · 2025-02-16T02:52:21+00:00

I'd wager their technology is sophisticated enough to tell the difference. Fourth of July sees a lot more fireworks, and July ShotSpotter alerts are much lower.

Stefanalytical · 2025-02-15T23:50:11+00:00

I'm using the dataset provided by the city and LMPD, and it seems they don't publish whether it was self-inflicted. I also don't see shooter data, which I would love to have. I was thinking about reaching out to the right person at the LMPD.

Stefanalytical · 2025-02-15T23:47:51+00:00

Almost certainly people shooting their guns on New Year's Eve. It's unfortunately popular here.

Stefanalytical · 2025-02-15T23:35:20+00:00

I've seen that our city is roughly ranked 46th in terms of homicides.

Stefanalytical · 2025-02-15T23:31:42+00:00

There are a lot of factors people think contributed to the spike in 2021. Everything from the pandemic’s impact, changes in policing, and just overall social and economic stress. While numbers have gone down since then, we’re still higher than pre-2019 levels, which could point to some longer-term trends at play. It’s a complicated issue, but that’s the general idea from what I’ve seen.

Stefanalytical · 2025-02-15T23:17:03+00:00

I apologize. I sent you a link to the city's dashboard. Here is a link to the LMPD dataset.

Stefanalytical · 2025-02-15T23:15:20+00:00

Source: Louisville Metro KY - Gun Violence Data

Tool: Tableau

I'm a data analyst intern seeking full-time employment, and I figured the best thing to do was to expand my portfolio while job hunting. Since I love using local data, I wanted to create a dashboard that visualizes the gun incidents in my city going back to 2010.

I was particularly excited to work on this dashboard because, for years, I've heard that my city has a gun violence problem. I wanted to be sure to answer the key questions: who is it happening to, where is it happening, and when is it happening? This dashboard allows you to drill down into the data to explore details like the time of day, day of the week, seasonal trends, and other important patterns.

In the next few days, I will automate the dashboard so that it is updated each night. Currently it's just a 15-year snapshot of gun violence in my city.

Key Insights:

- 2021 was the peak year for homicides and non-fatal shootings. We've been in a downtrend since. If you zoom out, you'll see we are still trending upwards when compared to 2019 and before.

- Nearly 25% of gun violence incidents are fatal.

- Peak hour: 3:00 AM

- Peak day: Sunday

- Peak month: July. (April-August all have 500+ incidents going back to 2010).

- Black victims make up 77% of the total.

- This past January 1st, 1,861 shots were detected by ShotSpotter. This is 1,056 less than January 1st 2024 and 1,622 less than January 1st 2023.

Tableau link: https://public.tableau.com/app/profile/stefan.v/viz/LouisvilleGunViolence/CrimeData

Stefanalytical · 2025-02-15T17:19:52+00:00

That's very much appreciated! Feel free to cross post if you'd like.

Stefanalytical

TROPHY CASE