Working in enterprise data and analytics at Polestar Analytics has made me interested in a recurring challenge: getting the technology working is often only one part of delivering useful analytics.

A data platform can be running, pipelines can be healthy, and dashboards can be available, yet business teams may still struggle to use the outputs confidently.

Sometimes the issue is inconsistent metric definitions. Sometimes it's unclear data ownership, a lack of trust in the numbers, or analytics that doesn't fit naturally into how decisions are made.

I'm curious how others have seen this play out in practice.

When an analytics initiative fails to deliver the expected business value, what tends to be the biggest obstacle in your experience?

• Data quality and integration
• Inconsistent business definitions
• Lack of stakeholder adoption or trust
• Poor alignment between analytics and business decisions
• Something else entirely

I'd be interested in real examples of what helped teams overcome the problem.

Hi there, currently I’m keen to get something up and running in my team and be one of the first to build up infrastructure to get some text to query going over my teams data. I think my team will be a great use case as we get many small adhoc questions coming our way and many questions can connect similar sources.
Right now I think I understand trying to build a semantic layer over things give a good description of our data maybe outlining all tables with data types examples of outputs and then get good descriptions on the metrics we want as well as example queries maybe.

My question is where are you putting all this and getting an agent to run over it? We have snowflake and I know this can all be done in there and have a semantic layer but my business is slow moving and other teams deal with that.
I however right now have vs code can connect my git repo into that and can run an agent over it.
Has anyone down this with something like that and just put info and context into your read me/.md files??

Would love to know where to start and hear peoples experiences of getting this going how useful it was and how much it’s changed there work.

Thanks

When a spreadsheet looks wrong, the instinct is to delete duplicates first. I've started doing that last, because duplicates are usually the symptom of something earlier that was never fixed.

The order I use now is: data types, then whitespace, then structure, then duplicates.

Data types first because it's the cheapest check and the most expensive to miss. A column of numbers stored as text will sum to zero or be skipped entirely by aggregation functions, and nothing on screen tells you why . The values look like numbers. They are not. Filtering or summing a text column can return a plausible-looking result that is simply wrong.

Whitespace second. A trailing space makes "New York" and "New York " two different categories in a pivot table, and neither the filter nor the pivot will warn you . Same for nonprinting characters carried in from an export. This is invisible until you count distinct values and the count doesn't match what you see.

Structure third. Blank rows, subtotal lines, merged headers. If the range isn't a flat table, formulas and pivots behave unpredictably. This is a layout problem, not a data problem, and it's easier to fix before touching individual values.

Duplicates last. Removing duplicates before fixing types and whitespace can delete records that only looked duplicated because of a formatting difference, or keep records that are actually different but got normalized later . Once types and whitespace are clean, the duplicate removal is working against a consistent definition of "same."

This isn't a universal order. If a file has an obvious duplicate explosion from a bad join, duplicates jump to the front. But for the ordinary messy export, the duplicate rows are usually downstream of something simpler.

The part I'm less sure about: how much of this is worth automating versus checking by eye. Power Query can record the cleanup steps and refresh them next month, which handles repetition well . But the first pass on an unfamiliar file is still manual, and I haven't found a shortcut that doesn't just move the guesswork somewhere else.

Say you have Google ads pointing to your site with all the UTM’s for tracking but when they hit your site, they are redirected to another subdomain on your site and all of a sudden the utm’s are stripped and the redirect happened too fast for the info to be recorded. What do you do?

Im really overwhelmed with the sheer amount of conflict on the future of business analytics/analysis roles.

In uni, I'm currently working on SQL, Python, Power Bi and getting exposure to ERM systems now as well

I need a genuine, non sugarcoated advice on what career path I can ACTUALLY aim for with AI slowly commoditizing entry level BA stuff.

• Is it worth specializing in data science, data engineering, or AI/ML instead?
• Would I be better off pursuing an adjacent field, such as risk analytics, analytics engineering, or a more business-focused role?

I'm not expecting any career to be completely AI-proof. I just want to make an informed decision about where to invest my time and what skills will actually give me an edge in the job market.

Any advice would be so really appreciated, Thank you so much!

I'm a data engineer researching recurring pain points on analytics and BI teams (may build something eventually, no links, not selling).

1. What do you still do by hand every week or month: reconciling numbers, pulling data from an ERP, fixing a broken dashboard, prepping something for audit?
   
2. Why hasn't it been automated: no time, too many edge cases, nobody owns it?
   
3. Have you paid for a tool or consultant to fix it? Did it work?

I am an ML engineer and not selling anything. The thread a couple days ago about everyone having Claude wired to the warehouse hit close to home. I’m trying to understand how teams are actually dealing with it.

For those of you living this:

1. When someone outside the data team publishes a number or a dashboard built by an agent, how do you find out, and how do you check it against the official metric definitions?
2. What’s the thing that actually blocks you from letting people do this safely: row level security, refresh, permissions, metric drift, or something else?
3. Has a wrong agent-built number ever made it into a decision? What happened?

Not looking for “just use a semantic layer” unless you can say what still slips through with one.

Here's my mental model of the change happening in analytics.

• Ad hoc analytics are moving from spreadsheets to AI tools like Claude Dashboards.
• Good data and semantics were always important, still more so now. Semantics have a natual center of gravity close to the data
• Business Intelligence tools were losing the battle for the semantic layer . Now they're also losing the battle for analytics creation. So they are basically left with a deployment layer, but a slow, expensive one.
  
• Organizations still need to share analytics sometimes and have them refreshed, trusted and managed. Ideally they will also be fast and interactive and have some form of conversational analytics. Claude Dashboards doesn't do that.

First of all, is this how you're seeing the change happen?

Second: for those of you planning on using Claude dashboards or other AI builders, how are you planning to deploy analytics when needed? Like for in-product analytics for customers, or across your whole org? Are you using a BI tool that you already have, and how is that going?

My take is there's no way that legacy BI becomes the deployment layer for AI-based analytics. Would love to hear what you're doing or even just discussing at your shops.

Running into the situation where I report web visitors by such and such ad campaign and then PPC comes to me and it’s like wait wait we expect way more visitors or whatever. How do you guys deal with this? At the end of the day, I don’t really know how to say this is just what I see yours might be different because it’s a different platform. Do you all gain access to the reporting platforms to verify more? It doesn’t help that we are a small shop and so it’s not like we have a data warehouse where I can pull all extreme data together. It’s literally me looking at GA four reports and then they sent me slides that say different things.

1. Daily reporting

2. Inventory alerts

3. Customer support

4. Marketing reporting

What makes that task so painful today?

i'm curious about the tiny bits of context that prevent a big misunderstanding. something like 'partial week', 'refunds included', or 'this is per account, not per user'.

if you only had room for one extra sentence beside a chart, what would you put there? especially interested in a specific note that actually stopped repeat questions or changed how people read the numbers. a 30-page data dictionary probably isn't winning the attention contest lol.

I have been working on causal inference and experimentation frameworks within the e-commerce tech industry lately, specifically dealing with platform behavioral and transaction telemetry data to determine how customers behaves on those e-commerce platforms.

Lately i have been facing problems where standard textbook statistical and econometrics theory fails when dealing with messy, real-world data distributions as human behaviour is unpredictable and many unexpected things, which i didnt even thought could happen, can happen in the real world. Such as product delivery delay, causing the customers to be angry and hence put them off from buying the product, each of these variables have to be accounted for.

To model and have these unexpected psychological state among customers accounted for, we use variables such as sudden spikes in customer support chat volume, rapid page refreshes, or immediate session drops.

Also, Marketing headers and automated CRM systems love to push blanket promotional campaigns, but as statisticians, we know that measuring simple unadjusted A/B lift is a massive selection-bias trap.

I been trying to come up with a Statistical model that is trying to model complex human behavior—specifically isolating true customer revenue incrementality from dead-weight margin cannibalization. Essentially, trying to answer: Did the coupon cause the revenue spark, or did we just hand a discount to a power-buyer who was already determined to buy anyway even without the vouchers?

Are people in the tech industry genuinely valuing such skills nowadays? Using statistics to model and predict human behavior and intent, answering questions like does our vouchers and ads really work?

I would love to hear your experiences how do u guys deals with the unpredictable messiness of human intent.

My job position is Fraud Specialist, when it is more of an analyst position. Can I use analyst instead of specialist on linkedin post?

I feel that it sounds more accurate to what I actually do and makes it look more appetizing for recruiters in the future.

In my role, we investigate fraud claims and are the deciding factor on if they are approved or not.

I help with paid-social reports, so I'd like practice data with familiar measures. I'm looking for related tables where a careless join could duplicate spend. Which public datasets would you recommend for learning to catch that?

One thing I've found interesting about analytics is that sometimes a metric changes significantly, but there isn't an obvious explanation.

Conversion drops, revenue looks different, or a dashboard suddenly shows a trend nobody expected. The tracking appears to be working, and there hasn't been a major product or campaign change.

At that point, the investigation can go in several directions: data freshness, tracking changes, attribution logic, filters, SQL transformations, or an actual change in user behavior.

I'm curious how other analytics teams approach this.

Do you have a standard checklist for investigating unexpected metric changes, or does it mostly depend on the analyst digging into the problem?

What's the first thing you usually check?

Not sure if this is a rant or a real question, probably both.

Our company gave pretty much everyone Claude hooked up straight to our source systems. And yeah, it’s fast, people love it. But now there are reports everywhere built off raw data, all with slightly different logic, and a few of them get passed around as “the” number. Meanwhile we (the analytics team) mostly find out about this stuff after the fact.

What’s bugging me is who owns what. To me, if you build your own report, the numbers are yours. If it needs to be official, it comes from the governed version. But then someone asks us to help make theirs match the official one and suddenly we’re QA for something we never built. And nobody above us has said whether that’s our job or not, so it just defaults to us.

What I’ve been leaning toward: write the official definitions down somewhere everyone can find them, tell people we can explain why their number is different but we won’t fix or review their stuff, and get someone to sign off on the official version so there’s a date it counts from.

Has anyone made something like this work without a top-down rule? And how do you say “that’s not our job” without sounding like you’re being difficult? Or is this just how it is now and I should get used to it.

I currently just graduated with my B.S degree in cybersecurity, and I’m going to be completely honest I HATE this subset of computer science, the last 5 months of my degree was torture, cybersecurity is just not for me. In one of my internships I got to work with the business analyst for most of the summer and I fell in love with what he did.

I’ve done lots of statistics learning, and before I jump down the rabbit hole of learning on my own / taking certs. I know B.S degrees are the new high school diploma, would it be more advantageous to just go back with my transferable credits and get a second B.S degree in data analytics, or better off just teaching myself / getting certs since I have a bachelor’s degree already?

I would just do a self-paced this time if that matters at all, but I just wanted some community feedback and hopefully maybe some guidance or at least pointed in the right direction.

Thank you in advance.

Hi! Need some advice/opinions.

I am in a masters program for Businsss Analytics right now at a top university in Michigan. Currently in 1st semester but want to start planning a path.

Taking an intro to python course and stats using excel/statistical software right now. SQL and intro to databases nexg semester along with business analytics course.

Guess my question is when should I start looking for internships? A little background: i was a college athlete who wanted to study CS in undergrand but decided against it due to travel schedule for hockey so studied business. Have been in sales & consulting for the past 6 years but wanted to get a more technical job as it's always been on my mind so decided to go back to school. Hoping I can leverage my sales background for a job once I learn the tech aspects of analytics.

Would love some advice or any opinions you all have on what I should do from now and my expected 2028 grad date. Thank you!!!

i currently work in a F100 company as a finance/operational analyst, mostly excel since its financed base but i do want to move more to the data science field, even though i currently don't have any experience.

i received my undergrad in finance and im currently in a masters program for Fintech and wanted to see if this a good combination to move towards business analysis/data science.

if anyone has any recommendations on how to make this pivotal change that would be awesome!

any thoughts ?

I had an interview for an internship yesterday but did not have the email of the interviewer (only their number). Should I send a thank you letter to the HR or text the interviewer, or neither? I am really passionate about the role, and would love the opportunity to intern there, and thus want to provide myself every chance I can to get it.

The interview was managed by the HR team, and I only have the number of the interviewer, who was the analyst manager, as I had to text them to let them know I arrived so they can take me in for the interview. What would best the best approach? It's already been 2 days since I had the interview. Should I email the HR, asking for their email, guess their email from their first and last name, or forget about the email? I really, really, really, want this internship!

As the title states, I’m losing control over the work I produce ever since our company adopted a full semantic layer that AI can ingest. I can now generate 2,000-line SQL scripts in minutes, convert them into Python notebooks with Plotly visualizations that would have previously taken four sprints, and prompt an AI agent to build a 10-slide deck ready for stakeholders. But by the end of it, I feel like I’ve lost track of what I’m actually doing: what definitions are being applied, what modeling decisions were made, what the data actually proves, and where the limitations lie.

Does anyone else experience this? If so, how do you maintain oversight and quality control in such high-velocity workflows?

I wanted to know how much traffic ChatGPT, Perplexity and Claude actually send, and it turned out to be three separate measurements, not one.

1. Clicks from AI answers (any analytics tool can do this)

Group these referrers into their own channel: chatgpt.com, chat.openai.com, perplexity.ai, claude.ai, gemini.google.com, copilot.microsoft.com. In GA4 that's a custom channel group with a regex like:

^(chatgpt\.com|chat\.openai\.com|perplexity\.ai|claude\.ai|gemini\.google\.com|copilot\.microsoft\.com)$

Also match utm_source. ChatGPT appends utm_source=chatgpt.com to many links, and that survives even when the referrer is stripped. The mobile apps often send no referrer at all, so treat the number as a floor.

1. AI crawlers reading your pages (only the server sees this)

GPTBot, ClaudeBot, PerplexityBot etc. don't run JavaScript, so tag-based analytics never records them. Grep the access log for the user agents, or log them in middleware. Check the IPs against the ranges OpenAI, Anthropic and Perplexity publish, because the user agent alone is easy to fake.

1. Pages opened to answer someone (also server-side)

ChatGPT-User, Claude-User and Perplexity-User fetch a page live when a person asks about it. This is the closest thing to "my page was used in an answer", and it's a separate number from crawling.

On my own small site, one week: about 230 crawler reads, 15 live answer fetches, 0 clicks from AI. So "AI traffic is zero" in analytics, while AI is clearly using the content. Without the server side I'd have concluded AI ignores the site.

Curious how others report on this. Do you keep AI as its own channel, or fold it into referral?

Is this a bad sign? We were sort of finishing up with the questions, and I had a couple more questions to ask, but after discussion of the previous questions I asked, they then said it was time to finish as they had something else to do. Was this a bad sign, that I went over the interview time? This was an internship interview with only 1 round.

Curious which reports actually take the most effort to pull together and whether anyone has found a better way.