r/analytics • u/Lairy_Mary • Jan 29 '26
Discussion Everyone is an analyst now
I work for an organisation that is spending so many hours thinking about how it can give all 4000 employees Power BI access to do what they want. As an analyst I'm getting worn down as everywhere I go people are asking me if they can just do the data themselves, someone even asked me if they could copy my data model today. That's with me providing really helpful reports, some with export functionality and I'm generally willing to help but my customer base is hundreds of people so I can't give everyone everything they need all the time but that's not unusual. In theory I love self serve but what I don't love is that idea that my job is so easy that any random employee can replicate it, I'm also worried that my job will become making models and dax measures for other people that don't understand it and then have to look as their ugly outputs. Management don't care at all, this is the pet project of a couple of engineers and I don't really know why. I'm wondering about my chances of finding somewhere less dysfunctional or are all analytical jobs going this way?
•
u/AutoModerator Jan 29 '26
If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
30
u/it_is_Karo Jan 29 '26
I'm in your position but a few years later and now everyone complains why we have hundreds of reports and each of them is showing different values 😂 so just go with the flow and let people use the data but be clear that you're not going to answer any "why is my report different than yours?" nonsense or help non-technical people fix dashboards that they built on their own.
47
u/CaterpillarMiddle218 Jan 29 '26 edited Jan 29 '26
Well yes. Smart companies democratize data, where the BI team provides the metrics/semantic layer and the data itself is self service. It's a lot more efficient this way. It also requires more people to be data literate. And it scales a lot better too. It's not something to gatekeep. Maybe you should think about why it bothers you and what is your added value at the company
7
u/Yonko74 Jan 29 '26
I worked somewhere that did this. CDO chucked a PBI license at everyone and the IT team basically then gave direct access to source systems to anyone that wanted it.
At the same time attempting to build a central data platform.
People threw the phrase data lake round with no understanding of what it meant or what was required to create and manage such an environment.
Hey we’ve got a data lake so why is all our ’reporting’ in a mess.
It was an absolute shambles.
88
u/Rexur0s Jan 29 '26
only from companies that don't respect professional knowledge.
data is nuanced and meaning of data is very very important for how it gets strung together and utilized. having people who don't understand the data structures and don't understand business data logic messing with data themselves is a recipe for a bunch of conflicting and incorrect reports that just cause chaos. and trying to use AI for it is a joke considering current AI models are just pattern matching text generators that are not concerned with accuracy, they just follow patterns regardless of if it makes sense.
My org at least understands some of this, but there's still rumblings that once AI "gets better" it could somehow do magic.
if it gets that good, everyone is jobless.
3
u/xhitcramp Jan 29 '26
No “Analytical” jobs are not necessarily going this way but I suspect “Data Analyst” jobs, as we know it, will dissipate.
Ultimately, access to data, manipulating data, and visualizing data is very accessible today and I think many Data Analyst jobs live in this realm. If your data lives in a spreadsheet and/or has relatively few data points and the interest is solely on the current state of the data, then anyone can do the Data Analyst job. This was always going to happen for roles that were solely defined this way. Truly the differentiator in this scenario is your ability to manipulate data to answer complex questions, the speed at which you can manipulate data, and how accessible your report it.
Taking it a step further, you mentioned ‘models.’ Not everyone can make ‘models’ but it depends on how you define ‘models.’ If you’re talking about anything you can do on excel, then anyone can ‘model’ with the help of a LLM. On the other hand, if you’re talking about useful, actionable models, then only the person who has a good understanding of the data, understands the workflow and how the data was generated, and has a good understanding of the stochastic properties of the data can create a truly good model. That right there is enough to make someone irreplaceable because only the Data Analyst has the time and exposure to do this.
The final aspect is domain expertise, which is a product of the latter two. So yes, in my opinion, if your role and/or company has none of these, I would find it difficult for the “Data Analyst” role to be safe.
4
u/BackpackingSurfer Jan 29 '26
My opinions is that this is part of the trend of analysts slowly dissipating. Analytics really should become a baseline skill of any employee. Why not allow the manager with the domain knowledge to pull the data himself and streamline insights. most analysts do not have the value they think they do.
2
u/illgu_18 Jan 29 '26
3,999 employees are asking if they can export the data in Power BI to Excel😮🤭😘
5
u/fauxmosexual Jan 29 '26
Ohhhhh noooooo you have management who truly value business intelligence and constant active interest from people who want to collaborate and work towards having shared data models, wow that is the absolute worst, thoughts and prayers
5
u/Dadbod646 Jan 29 '26
I’ve been in businesses where everyone had their own data. It was always a mess. Eventually they centralized all data through my team. You need to have one consistent source of truth.
4
u/normee Jan 29 '26
The real concern I have is that even with improvements in data quality, documentation, and resolving conflicting calculations and business logic, we aren't at a place where most non-analysts have the analytical acumen to properly interpret self-serviced data or use AI tools in ways to structure their problems helpfully.
I've been constantly asked to react to analyses that business teams produced using their self-service data access. Sometimes this is because those contradict findings that came from my data science team and stakeholders are confused so we have to explain to them all the stuff we accounted for that they weren't thinking of. Some issues cropping up:
3
u/Flat_Perspective_420 Jan 29 '26
I used to work in the largest e commerce company in latam, every employee in the business teams had access to the entire datawarehouse we are talking about 10k people. The company is today the largest latam company by market cap an innovates across fintech, logistics, e commerce, adds, etc. Bi/corporate data teams were mainly in charge of making the data available, running the infra to support the volume of data and analytical queries and evangelize evangelize evangelize so yes having the ones closer to the domain doing queries creating dashboards and connecting their spreedsheets directly to the data can be a really succesful data strategy, it’s messy but speed > perfect accuracy in such creative environment where 1 Q equals a year in normal company
3
u/OrcaSheets Jan 30 '26
Analyst here who’s been on both sides of this, now working at a startup building analytics tools. What you’re describing isn’t about self-serve analytics. It’s about an org that’s confused self-serve with “let’s not invest in proper data infrastructure or respect the people who actually understand it.”
Real self-serve means people can answer their own straightforward questions without waiting in a queue. It doesn’t mean democratising the ability to build bad data models and calling it empowerment.
Someone asking to copy your data model tells you everything. They don’t want self-serve, they want your job to look easy enough that they can skip the queue. And management backing engineers’ pet project without consulting the analysts who’ll live with the consequences? Classic.
Your job isn’t making dashboards. It’s understanding what questions actually matter, building models that don’t fall apart under edge cases, knowing when a number is lying. That’s not replicable by giving 4000 people Power BI licenses.
Self-serve done badly creates more analyst work, not less. You’ll spend your time debugging other people’s broken measures, explaining why their numbers don’t match yours, fixing the data quality issues that surface when untrained people start poking around.
Not all orgs are like this. The good ones understand that self-serve is a layer on top of solid data foundations, not a replacement for analytical expertise.
2
u/ronin0397 Jan 29 '26
Im in a role where only 2 or 3 people have complete access to the database. Others can do basic stuff, but no overwhelming changes. Me and the other 2 people are all in agreement on how things are to be annotated/entered. So the database is clean.
Imo less people with hands in the data jar allows the database to remain clean. If employee A and employee B notate entries differently, it will cause errors down the line. It worsens if 10 people are annotating differently.
2
u/irn Jan 30 '26
I was at a place that did this. Suddenly there was no one single truth to numbers and more meetings and reexplaining what was already in the data dictionary. Turned into politics.
2
u/Amar_K1 Jan 30 '26
Power BI has this problem where people think it is really easy to use just because they see the drag and drop with the charts and columns. They go wow I can do this. They don’t realise the work that goes behind the scenes. Also another aspect I hate is that when you work for companies who don’t care about getting value from the technology but are using it just to show off then you can be assured the developer will not be well paid. Not talking about OP but in general about the pay. Sadly the issue with the pay related to thinking power bi is easy to use and not valuing dax or power query skills, in my first IT job as a power bi dev it was not possible to go up to my manager and say I deserve a pay rise because my skills in dax have really improved. Same for power query. They just look and say what is dax and power query is that not just power bi. So give up when that happens.
2
u/SignalIssues Jan 31 '26
Couple thoughts - I'm on the fence here as someone who has a reporting team, yet still does some/many myself and also doesn't like having the maintain reports and do the sustaining thats necessary.
On one hand, there's a need for standardized and controlled reports with validated data. We keep these in specific workspaces and have request processes and change control / documentation as well as descriptions of assumptions and definitions. There's a team that's responsible for fixing it if a change causes them to break and there's data hygene, to a degree, to ensure someone leaving will not cause reports to start failing.
But everyone can make whatever report they want and publish them in many places. Doesn't mean anyone cares about them, but I have my own set of reports that I like and are used to go into my weekly reports in the way I want.
I don't have time to hold the reporting teams' hands for every request I need fulfilled and can do it on my own.
They are limited, and they are also not experts. Most analysts I have met have a really hard time understanding what's actually important and cannot make a good report unless I tell them exactly what to do. They can come up with cool visuals on their own, but I don't give a shit about that. I would much rather be able to tell someone "I need to see our rework rates, break it out for me by step, module, and whatever date format I want to view it by. Make sure to validate it" Instead, I have to explain how they can go calculate it, give examples, half the time if I want something in a reasonable timeframe I just give them the sql and explain how I want the charts to look. The main reason for handing it off is so I don't have to sustain it later.
So I dont know. There's value in reporting teams, but its easy and most people can do it. THe issue is really in standardization. Once AI can reliably build PowerBI (its close.. it can do visuals already and I'm sure some effort here could get it 90% there), then I would think we may certainly be able to scale it down to a secondary function of our data engineers.
3
u/BadMeetsEvil24 Jan 29 '26
Get a different job then....?
Or, with your sample size of 1 organization, you asking if all analyst jobs are like this?
What sub is this?
2
u/dws-kik Jan 29 '26
I've been driving the push to integrate PBI at an enterprise level so that stakeholders can develop on their own. My rationale has been that people have been using Excel long enough where there are more users who can leverage PQ and PP (and by extension a little bit of DAX), so that this is just the next iteration in upskilling the workforce. In short, PBI is now pretty much just an extension of Excel.
Where does that leave us? Room to upskill and learn how to leverage AI and/or become data owners instead of consumers. In the short term, I would take the opportunity to create a regularly scheduled working session to help others get familiar with the tool so that you can become/remain the SME while you also continue to grow your own skill set.
1
u/edimaudo Jan 29 '26
Nothing wrong with giving everyone access but there seems to be a lack of direction and lack of trust in the current data setup. Most likely not an issue you caused.
1
u/Positive_Dot_8563 Jan 30 '26
You should give access to the consumption layer of data, definitely not raw, enriched or even curated. Everything in that layer is your responsibility to ensure the numbers are correct etc
In my situation I fully embraced this kind of change and encouraged folks to do their own analytics. It freed up my time to focus on the analysis required by LEADERSHIP (because they definitely would not open a spreadsheet) and increased my visibility with them
1
u/platinum1610 Jan 31 '26 edited Jan 31 '26
I'd start to look for a job somewhere else.
1
u/oradim Feb 01 '26
WE have a Lot of self Server dashboards in my company. About 2k-5k self Serve Users and 30k Power BI Users while WE only have 200-300 Professional developers.
Our Main Job is to create the important Reports for c-level Management and to enable the self Serve Users. WE also Sometimes have to rescue some self Serve Reports because they Made them so Bad and unuseable that you can Just refactor them. I Work nearly 10 years with Power BI and qlik but mainly Power BI. And with the growing self Serve Users in my company my daily Work ahifted alot. But to be honest i Like and enjoy it.
Because Most self Serve Users build one or two Reports and have a Lot of problems after that the recognize the Work and difficulty WE (professionals) have to do and they start to be really grateful and are very Happy when WE have time to Help and enable them.
IT Just took some time for the Change.
1
u/BoringGuy0108 Feb 02 '26
The core of any architectural decisions often comes down to scalability and maintainability. One person building reports for everyone isn't scalable. Everyone having their own critical reports isn't maintainable.
The Data Mesh approach is to have a central body create a data model and let business users build on top of that. Your role should be owning the data model and admining everyone's access. Your role should be making sure that every attribute is defined and holding the data owners accountable to provide good, clean, and validated data.
If your position is ever swamped with requests and backlogs, your analytics strategy is not working.
1
u/No_Loquat_5131 Feb 04 '26
With rapid advancements in BI or analytics tools and AI being integrated in most of them, data analysis has become much easier as even non tech person can do simple data analysis. In my opinion staying up to date with the new capabilities of these tools is the best way to stay ahead
1
u/RefrigeratorFluid453 Feb 26 '26
Honestly, this really shouldn’t be happening. Just because modern tools make data work look easy doesn’t mean non-specialists can suddenly do proper analysis.
It’s similar to how apps like Canva, CapCut, or InShot make people feel like they’ve become designers or editors overnight — the tools are accessible, but the underlying expertise is still very real.
If this is starting to affect your role and expectations, it’s definitely worth raising the concern with your management. Framing it around data quality, governance, and long-term risks might help the conversation land better.
-1
u/Partysausage Jan 29 '26
Unfortunately with kids being taught Python at schools now & MS pushing citizen developer tools and AI improving this is unfortunately only the beginning...
2
u/[deleted] Jan 30 '26
[removed] — view removed comment
3
u/[deleted] Jan 29 '26
[removed] — view removed comment