u/datawazo

Hills scare the crap out of me, primarily because they've consistently killed every good run.

I struggle bussed a 15k today because it was moderately hilly, running it much slower than previous flat half marathon goes.

Is that just the way she be? Or can I actively be better.

My client acq is struggling this year and I think it's because the online channels have just gotten so bleak. For context it's​ our 8th year in business.

Heres how I've previously gotten clients:

1. Maintaining a good presence on twitter + posting content. My audience is pretty left leaning though an X has been a wasteland for a few years.

2. Reddit by engaging in a couple relevant tech communities. This was always unpredictable but it did drive some leads. Now it seems like overall engagement on here has cratered. Primarily because of all the Automated posts (imo)

3. Linkedin was a big channel for us posting quality content that includes analysis, how tos and day in the life stuff. Now ... it's more hit and miss. Content posts do really well, arguably better. But most other posts do poorly.

We'd also comment a lot on linkedin to build a presence, but have been finding less and less that's worthwhile to comment on.

We never were successful on Meta.

Imo online has just become a wasteland of shit and a lot of people have disengaged. But maybe I'm too jaded. Maybe it's an us problem.

We've had new clients come in via referral this year but that's literally it. Thinking of trying to do more in person as maybe people have migrated to something more authentic.

What are y'all seeing. Have you changed how you engage online.

Just want to preface with I've done my research, I have my little matrix with pros and cons to present, just want to see if anyone has additional boots on the ground advice.

I have a client implementation on Tableau right now for head office. They like it, we like them.

They're a professional membership org, think like andvocacy/lobby group for family doctors. ~400 active members.

They want a subset of our reports available to all members, knowing that true uptake will be about 10% of users weekly, maybe 60% quarterly.

Standard user based pricing kills this model.

Tableau has consumption based but according to my internet sleuthing we'd be looking at about $28k annually.

PowerBI comes in at about $11k but you need to turn it off over night (?) and manage some type of tokenization which doesn't scare me but sounds complex.

I'd love to go with looker studio but we require login driven security.

So... I have two somewhat less mainstream options on my list that claim to work, with ball park estimates (wont name cause dont want to sound promotional) but wondering if anyone has experience deploying a solve for this within your projects?

No sales plz.

Stupid story but client sent me an excel proving my math was wrong in pbi.

The excel was a straight export of my matrix and highlighted the undeniable fact that my numerator of 1 divided by my denominator of 6 did not equal my percentage score of 7.8%.

Valid.

So I opened er up and double checked the dax for my numerator. Looked fine. Checked the dax for my denominator. Looked fine. Checked the quotient, no problem.

Maybe a relationship?? No. Maybe pulling something accidentally in from the wrong table?

I was going insane. Everything was lining up. Nothing about my math seemed off, but despite how many times I put the numbers in the calculator I just could not get 7.8%. The math didn't change.

I don't know what finally made it click, but I Checked the number format. Added a decimal. 1 was actually 0.5. 6 was 6.4. 0.5/6.4 does, in fact, math out.

Stupid formatting. Stupid morning.