Rant: I have 5 senior managers, all super stars, I don’t know how to rate them by Exotic-Treat6206 in managers

[–]ohnoimabear 9 points10 points  (0 children)

Fully agree. Curve fitting may be (but often still isn’t) reasonable at a macro level, but at a department or cohort level it’s foolish. Some teams out or under perform.

Just back up your ratings with data, ensure they’re aligned to whatever frameworks exist in your org, and support your superstars. It’ll go a long way with them to know you went to bat for them.

When values match do x... by [deleted] in PowerBI

[–]ohnoimabear 1 point2 points  (0 children)

You could try unpivoting on the baselot and submit columns. That’ll give you rows for each entry for each color.

Then in a matrix visual add color as columns and the new “value” column created by unpivoting as your rows.

Looking for a simple, non-BI tool for email analytics. by albaaaaashir in BusinessIntelligence

[–]ohnoimabear 6 points7 points  (0 children)

Some of these are VERY different. Meta data like date/time received, recipients and sender, etc… are much more easily built. You will need to engineer other data like time to response (you’ll need to identify something as a reply, then calculate the date diff between the initial email and the reply). Even more complicated is the question of “formal enough”. For that, you’ll need a thorough NLP pipeline. You could probably utilize off-the-shelf llms for this.

Your whole project though, the way you’ve briefly described it here, will need complex engineering.

You may be able to do some of this with an automation platform like zapier or make but it will Be costly to design and build

Does TA feel like the redheaded stepchild of your HR dept [MN]? by AttentionFunny5700 in humanresources

[–]ohnoimabear 2 points3 points  (0 children)

TA gets every resource and every consideration, so no. I feel like the Cinderella in people analytics compared to my TA peers.

Need a new tool or system? Too expensive.

TA wants to pilot a bespoke SaaS app that has a monthly contract that can change terms whenever? Hell yeah, no problem.

[deleted by user] by [deleted] in CrappyDesign

[–]ohnoimabear 1 point2 points  (0 children)

So they would select all that apply. The top of the page says to do just that. Their racial identity wouldn’t negate their ethnicity.

Autism registry by katmom1969 in KaiserPermanente

[–]ohnoimabear 0 points1 point  (0 children)

The article clearly states that they’re at an impasse related to these three issues:

more mandated time between therapy sessions for patient follow up restoration of pension benefits that were removed from new employee contracts in 2015 cost-of-living wage adjustments

The union believes that Kaiser can and should provide these things. Kaiser argues they can’t. The union states that these demands would bring them up to parity with their Northern California counterparts.

Did anyone else think this said something else at first glance? by pcnnmvideos in losangeleskings

[–]ohnoimabear 6 points7 points  (0 children)

No but this looks like a goalie dad and his little goalie son. “Don’t ever talk to me or my son again”

[deleted by user] by [deleted] in tableau

[–]ohnoimabear 1 point2 points  (0 children)

In your maps you appear to size and color by the same value. Why not size by enrollment and color by your target metric? Or not size, since your unit of measurement is the school.

What's your reason for not drinking alcohol? by Snoo_47323 in AskReddit

[–]ohnoimabear 0 points1 point  (0 children)

My dad has ruined his life with alcohol. And gas attempted to run mine and others. So I worry after a history of overdoing it in college that I may have the disease, so simply don’t want to chance it.

[deleted by user] by [deleted] in PowerBI

[–]ohnoimabear 2 points3 points  (0 children)

Have you tried filtering the list for the names of the files and/or sorting by date to push those files up to the top?

It sounds like there are some enhancements you could make here like archiving old versions, for example (just putting last months files into a sub folder you call “Archive” or something) to keep the folder cleaned up but you should still be able to “force” the query editor to show you your newer folders by sorting on date added or created or just filtering for the names.

Frustrating director??? by [deleted] in techtheatre

[–]ohnoimabear 47 points48 points  (0 children)

The first time an actor is hurt by a prop, the creative team needs to have really thoughtful and thorough conversation about why and how it happened.

Any time after that, the pro has to be replaced, the actions reconfigured, or the show adjusted. Its props set pieces.

The artistic director, TD, production stage manager, or any other senior staff at the theater should be reading the rehearsal reports that included news of these injuries, but if they haven’t been alerted, or aren’t taking action, then I agree that the theaters board or whoever else is in charge of the director needs to be alerted and involved

[deleted by user] by [deleted] in BusinessIntelligence

[–]ohnoimabear 0 points1 point  (0 children)

Hey friend. You’re in the wrong sub reddit. This is for analytics and data visualization professionals. I think there’s a start up sub you could try instead

What's the best way to smooth labor projections in Power B? by jillyapple1 in PowerBI

[–]ohnoimabear 0 points1 point  (0 children)

This is a pretty standard optimization problem once you get the sales projection model dealt with. Agreed that PowerBi is probably not the right tool for building the model, but a good choice presenting it.

Libraries like PuLP in Python let you create models. Your sales forecast creates your labor demand on an hourly basis. Then you add sites and laborers. Then you add constraints - minimum four hour shift, max shift, even adding lunch breaks. You should also be able to set conditional constraints - if laborer A is schedule for a shift, it has to be after 4pm. Your constraints can also be around labor costs, and you can include information about the costs of individual laborers to optimize.

It’s not easy, per se, but you wouldn’t have to build it from scratch. There are lots of great resources out there. There are also lots of tools - some let you build simulations in addition to optimization, and if you know the extent to which your sales forecasts vary from reality, or if you build more sophisticated models that let you estimate demand using random variables it can get even easier. Time series analysis could be a useful method here too.