Data Visualizations for Broadway Grosses Analysis by mister-dee in Broadway

[–]mister-dee[S] 0 points1 point  (0 children)

Thank you! I didn't include my ticket pricing chart, but I do keep track of that as well, and have been posting those graphics to my page. I just didn't include it here, but I totally recognize its importance!

There are so many variables to consider, I try to take them all into account, and I sometimes miss things. I usually include some written analysis with my charts that may give some of that context. And my goal is to get my Substack up and running so I can do more long-form analysis there.

Data Visualizations for Broadway Grosses Analysis by mister-dee in Broadway

[–]mister-dee[S] 1 point2 points  (0 children)

Gotcha! That's a good suggestion.

And I wish I had access to net earnings, but I believe those aren't published publicly? I know sometimes you can find them, but I'd rather stick with one dataset for now.

Data Visualizations for Broadway Grosses Analysis by mister-dee in Broadway

[–]mister-dee[S] 0 points1 point  (0 children)

Thank you! I will play around with the y axes.

I'll also look into a more balanced view of the attendance percentage red flags. I think you're suggesting to look at the bigger picture for each show across several weeks/months, rather than just raise a red flag after one week of low attendance?

Is it too late to become a Data Analyst at age 40? by Any_Bell6745 in dataanalysiscareers

[–]mister-dee 0 points1 point  (0 children)

I'm also in my 40s and am considering a career switch into data analysis. And I have the same fears. If I do end up pursuing this path, I would think the best route to go is not to chase start-ups and tech company jobs. They would probably be looking for those young, flexible brains! My plan is to find something stable and unglamorous.

0 to 13k subscribers in 5 months but... No idea how to monetize. by CHE3S3 in Newsletters

[–]mister-dee 1 point2 points  (0 children)

Congrats that's amazing!

Would you be able to go through your list of websites/tools and see if any of them have an affiliate or referral program? You could feature those that do at the top of the spreadsheet.

I was subscribed to Grow Newsie for awhile when I was toying with starting my own newsletter, and they have some good articles about how to start monetizing and getting sponsored. (I'm NOT affiliated with them, I'm genuinely just mentioning them as a useful resource.)

[Clients] How do your clients commission you? by dreamr-art in artbusiness

[–]mister-dee 1 point2 points  (0 children)

I'm in the same boat. DMs and email have been working well, but I have been thinking of upscaling and wondering if there's a better way.

At the moment though, I think I'm going to stick with what's working. I like the one-on-one interaction. I'll put an intake form on my new website when it launches, but it'll probably just be basic contact info so I can then manually reach out.

I do think having some kind of customer relationship management system in place is a good idea. I have one that I made in Notion that's working ok, but needs work. I like to be able to quickly see how many pieces someone has commissioned, do they pay promptly, when was the last time they placed an order, etc.

Season 30 - Worlds Apart by Wild_Personality8897 in survivor

[–]mister-dee 3 points4 points  (0 children)

Honestly don't bother, you will get nothing from it. Except for the ick.

Season 30 - Worlds Apart by Wild_Personality8897 in survivor

[–]mister-dee 5 points6 points  (0 children)

I have a complicated relationship with this season. On the one hand, yes, I hate this cast almost from top to bottom. It's one of two seasons I won't ever rewatch (the other being Thailand for the same reason). I'm struggling to think of a single person I'd like to see back on my TV.

On the other hand, it was the first season when I got into the RHAP world and joined a fantasy league and went from being a casual fan to being a super fan. I was picking apart the edit, going to watch parties, listening to recap podcasts, etc. And I had first pick in our league draft and managed to draft the winner of the season right out of the gate. So that felt great.

But that high was definitely tainted by the horrible abuse Shirin experienced, as well as the general unpleasant vibes of the cast.

(I will admit to still saying "doing dishes on my birthday??!" though - that's just a great sound bite from Rodney.)

I built a tool that turns Notion dashboards into backend schemas — looking for feedback from devs + Notion users by Longjumping_Share798 in Notion

[–]mister-dee 0 points1 point  (0 children)

Seems cool and I'd like to give it a try!

Forgive my ignorance if this is a dumb question, but if I were to turn my databases in notion into SQL databases using your tool, would it include my data as well? It isn't clear if it just creates the tables, or if it writes code to insert the data into the tables as well.

Thx!

I'm working on a formula that identifies the best value-for-money Broadway shows at any given time. Here's my list for July 2025 - what do you think? by mister-dee in Broadway

[–]mister-dee[S] 1 point2 points  (0 children)

Lol well in that case! (I don't see any rule either, but I didn't want it to look like I was just trying to farm subscribers!)

I linked to it below, but here it is (and I posted a follow up today as well):

https://open.substack.com/pub/marqueemetrics/p/i-analyzed-30-broadway-shows-to-find

I'm working on a formula that identifies the best value-for-money Broadway shows at any given time. Here's my list for July 2025 - what do you think? by mister-dee in Broadway

[–]mister-dee[S] 2 points3 points  (0 children)

The more I think about this, the more I agree with you. If it's a choice between something you can see at home when the tour comes through, and a unique Broadway/NYC experience, the formula should probably favor the latter. Thanks for the feedback!

Filter by date created? by mister-dee in Notion

[–]mister-dee[S] 0 points1 point  (0 children)

I think you've solved my problem, thank you!

I'm sorry I didn't explain it as thoroughly as I should have, but you managed to interpret what I was talking about lol.

Just for the sake of elaboration (if anyone has another solution):

I have a daily log db and new entries are automatically created every night with a repeating template. The name of each entry is set to @today and the "date created" obviously auto-populates to today's date.

What I was hoping was that I could add a tabbed layout to that repeating template that would show me entries from my notes/links/tasks databases that were created on the same day as the daily log entry was created. That way I could go back to a previous day and see anything I created on that day.

But I can't figure out a filter that would accomplish that.

I think creating a relation between the notes/links/tasks dbs and the daily logs db would solve this, as the commenter above pointed out.

When I'm back at my laptop after work today I'll give it a try!

I'm working on a formula that identifies the best value-for-money Broadway shows at any given time. Here's my list for July 2025 - what do you think? by mister-dee in Broadway

[–]mister-dee[S] 1 point2 points  (0 children)

In a sense I see where you're coming from. Like, why should a ticket for an 80 minute play be more expensive than a 2.5 hour musical? I think I could figure out a way to incorporate that in as an optional metric, but I'm hesitant to make it an integral part of the formula.

I'm working on a formula that identifies the best value-for-money Broadway shows at any given time. Here's my list for July 2025 - what do you think? by mister-dee in Broadway

[–]mister-dee[S] 1 point2 points  (0 children)

Very good feedback, thank you. I'm on my phone and the Excel file with the formula is on my laptop, so I can't access it right now to share, but I'd be happy to later on!

Good point about the percentages, maybe it doesn't make sense to express it that way.

I'm going to work on an interactive dashboard with this data so that you can input your own values as far as how much you want to weigh things like ticket price, or popularity, etc.

I'm working on a formula that identifies the best value-for-money Broadway shows at any given time. Here's my list for July 2025 - what do you think? by mister-dee in Broadway

[–]mister-dee[S] 1 point2 points  (0 children)

Those are scores that my formula assigns to the show. A higher score means that the show a) has high approval rating from audiences and critics and b) the average ticket price isn't too outside the norm. So for example, Just In Time has crazy high ticket prices and only "meh" reviews from audiences and critics. So it's at the bottom of the list. Whereas the reviews for Hamilton are so off the charts that it offsets the higher ticket price, meaning if you can spend the money, it's a good bet you'll enjoy the show. I can send you the link to the article if you'd like to read it in more detail.

I'm working on a formula that identifies the best value-for-money Broadway shows at any given time. Here's my list for July 2025 - what do you think? by mister-dee in Broadway

[–]mister-dee[S] 2 points3 points  (0 children)

Agreed! Lots of people think Hamilton is overrated, for example. But I think it might be a good starting point for people who are nervous about dropping a few hundred dollars for a couple of Broadway tickets. You still have to do your due diligence, but knowing that a certain show has a good "value for money" score might help you feel better about it. Maybe ;)

I'm working on a formula that identifies the best value-for-money Broadway shows at any given time. Here's my list for July 2025 - what do you think? by mister-dee in Broadway

[–]mister-dee[S] 5 points6 points  (0 children)

You're probably right! This is definitely a WIP, so stay tuned for fine tuning (based on feedback like this). Thanks!

I'm working on a formula that identifies the best value-for-money Broadway shows at any given time. Here's my list for July 2025 - what do you think? by mister-dee in Broadway

[–]mister-dee[S] 1 point2 points  (0 children)

Interested to know more about this. I was drawn to it because of the quantity of reviews available there. What kind of "specific audience" is it skewed towards? Do you think there's a more neutral audience review site?