u/datawazo

I blame AI and not Summer but we've been on a real nice dry spell for a few months. Luckily existing work is strong and we're not in any kind of crisis but I had a road map for a new hire in Sept and we're well short of that happening.

But rain -> pours. Four random lead opportunities this week. Two via linkedin, 1 via white label partnership, 1 via network.

Nothing closed, still nothing ok the books but the meetings went well and its nice to be looking at new opportunities again for the first time in a good while.

Opened a report today and basically measure now has .00 after it. It wasn't like this a week ago or whatever. What's the gambit Microsoft. I didn't really want the blessing of setting everything from auto to 0 on this fine friday

I'm a PBI and Tableau guy through and through, but not infrequently someone rings me up and wants a tool for like 3,000 named users and doesn't have the budget for either of the big tools' per person licensing or embedded/core models.

Example from today is a saas company supportig1,200 users (as a start) viewing reports between 3 to 18 times/user/month currently charging their clients $3/per user! Obviously they can't up that to cover the cost of reporting with Tableau and PBI or even Looker's pricing models.

So back to do my own research on the side but wondering if anyone has experience with tools that might have fewer features but that can support this type of model?

And I'd prefer if you don't see this as an opportunity to dump your own product into the comments please and ty

So I have a sql view with the field Store Name in it. Its in a published datasource on server.

For some reason at one point some idiot (it me) edited the published datasource and added a relationship to the dim store table. So if you use the published datasource you have Store Name twice.

I want to rectify this, but every report built is using the store name field from the relationship, which is the one I want to kill.

I've gone ahead and removed the relationship and renamed the remaining store name field to match what the previous one was. But all reports are broken with the cant find referenced field error. Is there something im missing? Any way to do this without widespread impact?

https://preview.redd.it/pda4fxoqw0ch1.png?width=1700&format=png&auto=webp&s=4debd133b48e6768813a2a319e13ad1ad11a7d21

linkedIn reminded me yesterday that it's been 9 years since I added owner of an analytics company as a job.

I know a lot of people here are interested in this path, so every so often I try to open myself up to an AMA if anyone wants to know what it's like, how I started, how it's going.

FAQ:

How did you get first client - First client was from Reddit, second from Freelancer, third - ~12th were from Upwork. I was moonlighting early and didn't want to advertise myself too much locally and get in trouble with my FTJ, so relied on online options. Upwork 9 years ago was tough, but way more forgiving than it is now.

How do you get clients now - Prior to this year, leant a lot on content. Building public use dashboards and posting them to LinkedIn, twitter when it didn't suck and relevant subreddits. I also do a lot of open enrollment (paid) training that leads to clients. Referrals and a few in person events rounded out the rest. Online content I find has tanked with the rise of AI, so trying to figure out what my next steps are.

Tips for starting - Have a public portfolio. A good one. One that showcases first your understanding of how to use Tableau and 2 your ability to understand data and data storytelling. Try to make it practical, using open data if possible. My 2nd client onboarded with me because they were a sports facility management company and I had done a viz with my city's facility usage open data. Perfect happenstance, but that will go further than another netflix viz.

Know Tableau but also know SQL to efficiently bring data into Tableau, that's what I wish I knew more of when I started and had to quickly get good at.

What does a day look like - Most of my work these days is backend, facilitating tableau dev for other people (clients or my team). So I spend a lot of time in databases. I spend a lot of time in meetings. I love live building on a call, it's so powerful and useful. I do still work in Tableau but it's a lot less than 3-4 years ago. Also PowerBI has probably surpassed Tableau in terms of client work for me (partly because one of my team members has our 2 - 3 main Tableau contracts).

How do you charge - I charge purely hourly. A lot of "gurus" recommend fixed rate because there is more margin and that's true, but I hate scope management so much that I just do hourly bill. It's seldom been an issue with any clients. I started charging $75/hour which is what my first client recommended, and have just gradually increased it from there.

Best project - One of my favorite projects was a non client project tracking flight delays across Canada that got me onto National news. I had been on local news a few times but this was the highest my content has soared, and it was really cool. Also did a random radio interview for a province 3,000 KM away.

Worst Project - My least favorite projects always comes down to the people. It's can be so hard to balance self respect with needing money - easier as time has gone on. Had a guy that would email his requirements, I'd build them out and publish, he'd not check for 10 days and then get back to me with URGENT. He actually emailed me for a project update Christmas Morning (he was American, yes he knew it was Christmas. Schedule send that shit if you have to) and that was the final straw.

Lucky to be in a role where I get to try different things against different sectors. We've been trying to find more opportunities for AI - and obviously learning like everyone else along the way.

Here are three projects from ~the last week, how they went, what I would have changed.

1 - the great

We got a PDF from a client that had a bunch of data in it as a table. They tried a PDF to excel tool. But the merged cells were a nightmare. It was structured as "Finished Product" "Ingredient" but the FG was only in the first row and not tied to any ingredients. Worse was that the first Ingredient was also in the same row, alongside the FG.

I tried Excel and PowerQuery to get a split working but nothing was consistently working.

Loaded it into Claude and it used a Python PDF parsing framework to extract it all perfectly. Subsequently, we had other PDFs containing images of text with info about these finished goods (think menus) that Claude was also able to easily parse through and extract.

This was a huge win, highly recommend. With the caveat - I made sure nothing we loaded in was proprietary. Even though we're on "Pro"

2 - the good

Separate project for a retailer that, somehow, has no product categorization. We've been with them for two years and it's been a consistent sore spot. No one has had the appetite to sit through their 100K skus | sku descriptions and categorize them. We tried this with Chatgpt last summer and it was underwhelming. Tried in in Claude last week. It was WAY better, but with familiar caveats.

We loaded the descriptions and asked it to categorize across 6 categories, 19 sub categories. I also asked it to provide a confidence score for each. It nailed about 95%. Massive win. But the confidence score was useless. So chasing down the extra 5% is still messy. The errors ARE more consistent than when we did Chat though. More localized. Like a frozen good manufacturer it is >30% wrong on - categorizing "Frozen Cheese Bites" as Dairy, for example. The problem is someone still has to find and hand code those last 5%. So how much time are we really saving? Hopefully enough, now that the errors are more grouped.

Full disclosure - this was a 2000 sku pilot, I'm running the full thing this week.

3 - The Ugly.

Looking at ROI of a customer re-engagement campaign. If someone doesn't buy for 2 years they fall into "un engaged" and go to the re-engagement funnel. Client wanted to know the what the optimal amount of time in re-engagement was before just giving up on someone.

So they had purchases in file A, re-engagement touchpoints in file B. In my head I knew how I would solve this in SQL | Tableau. Not really that easy but you find their disengagement date, count the # of mailings until they rebuy ... doable. Needs some work but doable.

Again I stripped both files down to remove any posssible noise. It was just Cust ID, Buy Date, Buy Amount and in the other Cust ID, Campaign Date.

Loaded them into Claude, gave it the details and it create a dashboard. Bing bang bomb. Copied the text and screenshot and sent to client they LOVED it.

But wanted more. They wanted break even point, so they gave me avg $ value per touchpoint. I gave it to Claude.

He came back with a dollar value of re-engagement purchases that was 60% of the whole file. Insanely not likely. Passed it my concerns, it agreed with me, gave me a new number. I gave that to client they said still seems way too high. Validated it against a subset of the data and it was close to two x.

This is, IMO, where these things fall apart quickest. Once things go south, you're almost better offer completely pulling the plug and either restarting or not. I find there's no ability to right the ship. The logic its running is opaque, it's got no backbone to push back on anything I say. We're just in this spiral now where it gives me numbers and all I can do is hope they are correct.

I'm going to go back to my SQL + Tableau solution. At least that way I know the rough guardrails it should be operating in.

Anyway. Those are my three forays into the "new world" this week. Happy to discuss anything on this.

I ran 15KM yesterday, 10KM hard Wednesday, 12 on Monday. I'm sore. My body hurts. It's my rest day. I'm getting some work done at a coffee shop.

Just saw a guy with a good pace going, top off, and now I'm like - do I need a rest day? Do I need to work? I could do a riverside run.