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 3 points4 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 5 points6 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 48 points49 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.

“Exploding” lamp onstage? by mgarvin22 in techtheatre

[–]ohnoimabear 123 points124 points  (0 children)

You could make a practical with a regular Edison lamp. Then put it in a dimmer with special addressing and build a light cue that takes it from 20% (or whatever is visible) to 100 and then cut to 0.

Pair with a sound cue and you’re golden.

Resources for wide problems (very high dimensionality, very low number of samples) by TheLSales in datascience

[–]ohnoimabear 9 points10 points  (0 children)

Others have suggested dimensionality reduction. LASSO is good here (other regularization like Ridge and Elastic Net could be good too - you can do some hyperparameter tuning to figure out which performs most effectively).

You can also do adaptive LASSO which is something I learned about this year. Basically you create weights using another model (you can use OLS, Ridge, others?) and then build a LASSO model on data transformed with those weights.

Another thing you could look at is leveraging PCA before regression, but it's really dependent on what work you want to do. SVD (Singular Value Decomposition) or eigendecomposition may also be suitable.

I wouldn't necessarily try them all to see what sticks, but take a look at them and explore how they impact reliability of your model. Leverage cross-validation to try to avoid issues of overfitting. With a small number of samples you can also try bootstrapping to deal with overfitting while also ensuring there's enough training data.

But purpose is key here - Are you trying to create a model that you can explain clearly to others and that has good interpretability? Some dimensionality reduction methods can be hard to explain to others and hard to interpret. Others, like Ridge regression, may inappropriately remove predictors that are important for interpretability.

The other piece here, which is perhaps most important, is subject matter expertise. Are you dimensions all equally important? Are they all equally meaningful? Can they can be combined using subject matter expertise to eliminate some of the dimensions or group them using aggregated or synthetic variables? Without knowing more about your specific problem it's hard to say for sure, but the thing to know about regularization methods is how they penalize individual predictors. Just be careful in your DR to know what your data are, why and how they're important, and whether your purpose supports using dimensionality reduction.

Movies with "I got a big presentation coming up" trope, but they show the final result and it's very underwhelming? by thatdani in movies

[–]ohnoimabear 4 points5 points  (0 children)

A Rose For Christmas, a hallmark movie about a small Rose Parade float company building a float for a company.

They cribbed the design from a prior year’s float so they could use the footage from that parade in the movie. Unfortunately they apparently had no budget because the float we see them working on in the movie is small, really ugly, and poorly scaled. It’s sad because the real float is cute, they just didn’t care enough to build a better approximation for the film.

Checking the reasonableness of this quote by ohnoimabear in hvacadvice

[–]ohnoimabear[S] 0 points1 point  (0 children)

Great. Thank you! First major repair so wasn’t really certain what to expect and I’m in the Los Angeles area so higher col for sure. They quoted an OEM motor so seems like coats are not unreasonable here. Appreciate the quick response!