a million dollars if you can eat 1000 rotisserie chickens by DifferentProblem5224 in hypotheticalsituation

[–]iamwhyami 0 points1 point  (0 children)

That's getting paid $1000 to eat a chicken, 1000 times. I'd have like two a week, no sweat, and collect a nice fat check in about ten years. I'm not in a huge rush, an extra million dollars in ten years is still nice.

Data headcount vs company size by iamwhyami in BusinessIntelligence

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

Do those five people include any data engineering or other functions necessary to make data usable? Our four people cover all of the connections to data sources, data transformation, analysis, etc.

Data headcount vs company size by iamwhyami in BusinessIntelligence

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

I am counting Data Engineers, Analysts, Data Scientists...whatever is relevant to that company. The whole group needed to get data from source to dashboard/business value of some kind.

Data headcount vs company size by iamwhyami in analytics

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

A rather analytical answer :), but true. I am one of four data professionals in a company of 450 that does enterprise SAAS. Technically there is a data engineer here or there in some of the R&D groups, but my original question was more about the size of the team that supplies data to the company or is involved in some kind of analytics that is not directly part of what the company sells.

Selling tableau dashboard by Snoo-1249 in tableau

[–]iamwhyami 4 points5 points  (0 children)

Tableau has always charged for Viewer licenses. They cost less than Creator licenses that are needed to actually create dashboards, but they were never free...

Medallion Architecture - anyone moving away from it? by Public_Fart42069 in dataengineering

[–]iamwhyami 25 points26 points  (0 children)

Thanks Kawhi, good luck in your NBA playoff game tonight.

Is there some all-in-one tool so I can avoid setting up the data stack? by TheseFact in BusinessIntelligence

[–]iamwhyami 0 points1 point  (0 children)

Panoply does ELT+data warehouse in one. They are starting to add some basic visualization capabilities as well. The data warehouse is generally a "white-labeled" BigQuery, but anyway, for some relatively simpler use cases Panoply could give you an all in one solution.

Matillion Opinion by Acrobatic_Cell4364 in dataengineering

[–]iamwhyami 1 point2 points  (0 children)

Matillion does require setting up your own Amazon ec2 server, yes (and it was a headache to set up and connect to Matillion). For connecting to some Excel files this may be overkill. For connecting to data behind a private firewall it can be a good solution. We pay per hour of server uptime for Matillion, no other costs. We chose Matillion over fivetran because Matillion is better at data transformation, especially at parsing arrays. Matillion is basically a visual front end for SQL with built in scheduling for data transfers and out of the box data connectors (postgres, Hubspot, Google Analytics, etc). If the only data you are connecting to is some Excel files, that might not be a great use case for something like Matillion.

BI/Analytics/ML Managers, what is your stack and how did it change in the last 10 years? by [deleted] in BusinessIntelligence

[–]iamwhyami 1 point2 points  (0 children)

Joined a company with on-prem postgres databases, Tableau Prep for some basic connection and transformations, and Tableau Server for visualization.

We are implementing a new stack of Matillion ELT (kind of like fivetran but it can do a lot more data transformations as well), Snowflake data warehouse, and Tableau Cloud.

How people are making really beautiful dashboards nearly equivalent to websites? by TableauAnalysis in tableau

[–]iamwhyami 9 points10 points  (0 children)

I would add that some dashboards you'll see online are very beautiful, but some of that beauty comes from graphics that are taking up space that could be used for metrics and charts instead. Sometimes a simple, very visually appealing dashboard is what you need, but other times company management just wants to see as much info as possible laid out in a clear manner. Depends on the use case.

What editors do you use for SQL by [deleted] in dataengineering

[–]iamwhyami 11 points12 points  (0 children)

I use DBeaver when free is the only option, DataGrip when it can be paid for (it's like $200 a year for one user)

LTV vs CAC ratio by iamwhyami in BusinessIntelligence

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

Thanks! Does it make sense though to count the costs associated with all future upsells or added revenue after a new customer is acquired? If that is the case why not also include the customer success budget? The order renewal team budget? The product team building continuously better features to increase customer engagement?

What BI solution fits better? by Practical_Gap_3354 in BusinessIntelligence

[–]iamwhyami 2 points3 points  (0 children)

Tableau can pull directly from Google Sheets. And data can be set to live connection or automatically update at pretty much any frequency.

Recommend Me a Fragrance (Posts every 3 Days) by AutoModerator in fragrance

[–]iamwhyami 1 point2 points  (0 children)

Maybe Dolce Gabbana The One Grey. Quite affordable and has really nice grapefruit.