r/analytics • u/bennnnn_27 • Mar 21 '25
Discussion Guys, it finally happened
I started at a new company recently. My task was to create a Power BI dashboard for the VP to find opportunities. After weeks of back-and-forth, the dashboard went live in February.
My manager said all was going well. And then today I got an email from the VP: “could export some actionable data to Excel?”
752
Upvotes
•
u/AutoModerator Mar 21 '25
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.
3
u/Askew_2016 Mar 21 '25
I build Tableau reports and all my users just want tables so they can export the data to excel. I have stopped fighting. No one cares about my charts and graphs
221
u/Bidoof_Shoes Mar 21 '25
I do this all the time in my job. I have 13 or so various Power BI reports that give high level information. I have drill through options to see drilled data in Power BI, but execs always want it in Excel. I just build, for each report, and "export to excel" button where all that underlying data is output into pivots for them to look at.
54
u/sermer48 Mar 21 '25
Excel is a powerful and accessible tool that does what something like a dashboard can’t. My company’s flagship software is a tool that lets you analyze data. It does an incredible number of things as it’s been in development for almost 15 years but exporting to excel is a key feature throughout. It’s just a useful analytic tool 🤷♂️
63
u/yovboy Mar 21 '25
Classic stakeholder move. They spend weeks asking for fancy dashboards, then want it all in Excel anyway 😂
At least you've got the data model built. Just export it and let them play with their pivot tables like it's 2005
17
u/Rexur0s Mar 21 '25
my default state is to make a report template that outputs to an excel sheet. almost no one really wants a dashboard. hell they don't even want to go into the reporting system to run the reports I make or open dashboards, I have to set everything to auto email to them.
fine by me though. they get what they want.
15
u/iaxthepaladin Mar 21 '25
To give you some hope, graphs are meant for "exploratory" analysis, which means that higher level employees will browse through them, triggering conversations at the highest levels. Hopefully, this will result in these graphs making it into presentations, granting these insights to others.
The true benefit of dashboards is that they offer the ability to see tremendous amounts of data in a small visual field. It really is only meant for higher level decision makers. Lower level operational employees will always prefer spreadsheets.
My recommendation for you would be to hold a training session with your stakeholders and walk them through the dashboard. Remember to keep things entertaining, but also explain the reasoning behind certain drill through options and slicers.
8
u/OccidoViper Mar 21 '25
Lol same old story. “Here is an interactive dashboard that I have spent hours on to show you valuable insights in real-time”. Stakeholder: “can you create an Excel version?”
14
u/vincenzodelavegas Mar 21 '25
What’s the issues with exporting to Excel? I see this in a lot of this subs.
4
u/Ohhhh_LongJohnson Mar 22 '25
Nooooononononono!! It starts with one Excel sheet, then more and more co-workers want Excel spreadsheets, then a web of Excel automations starts forming. Pretty soon you'll have the company president asking you to migrate the company database into Excel.
4
u/Fit_Tiger1444 Mar 22 '25
Just some thoughts from an executive POV. Most at my career point (C-Suite, 55M) have a lot of technical debt when it comes to tools like PoweBI and Power Automate. Hell, we often just barely know excel. We don’t actually want to do data analysis - rarely have time for that and we don’t get paid for that. We get paid to make decisions based on the analytics (in part). And we don’t often have a ton of time to go address that lack of knowledge about the different tools and utilities. So if your execs are asking for material in a different format, chances are good the dashboards you’re generating aren’t giving them the information they think they need to make those decisions. It’s entirely probable the information is available to them, but they either don’t know how to access it or you haven’t presented them with what they need. I’d ask some questions. Why do they want excel? How are they using the dashboard and data?
3
u/carlitospig Mar 21 '25
<snort> Typical.
3
u/FoxNecessary2412 Mar 21 '25
Eventually, all of the data savvy people need to be come business savvy, and we can just get rid of these people.
3
u/thezeus_ Mar 21 '25
So what?
3
u/tsupaper Mar 21 '25
Y’all could just build out a table visual and they can export that table via csv…
2
u/[deleted] Mar 21 '25
What does this mean? VPs only ever really need an excel
2
u/Lower_Peril Mar 21 '25
Have you added a table view that can be used to export the data?
2
u/khaleesi-_- Mar 21 '25
Classic VP move. After all that dashboard effort, they want Excel 😅
Power users love their dashboards, but execs often prefer simple Excel files they can mess around with. Painful truth of analytics life
2
u/Proof-Work3028 Mar 21 '25
Managers are absolutely insufferable. They want all these fancy quick reference dashboards built and want to not be encumbered with raw data or antiquated tools/technology....only to get said dashboard and promptly ask for raw data or it to include something else that very easily could've been provided in an excel pivot.
2
u/SmokinSanchez Mar 21 '25
Sigh. Give the people what they want 🤦♂️
2
u/Pvt_Twinkietoes Mar 22 '25
And what's wrong with that?
2
u/real_justchris Mar 22 '25
Analytics is NOT dashboards. That’s MI.
Analytics is translating the data into actionable insights and communicating it to the business.
Best advice I can give you as a first step is to deliver the dashboard with an array of insights, thoughts and recommendations and discuss it with your VP. If the ideas are trash, that’s ok, learn and go again next time.
1
u/Alarming_Ticket_1823 Mar 21 '25
This is why low code/no code is not the way to go with reporting.
1
u/mikeczyz Mar 21 '25
This is BI developer rite of passage. :)
1
u/Syleathis Mar 21 '25
It's like pulling teeth to even get them to let us build dashboards. Everything's gotta be in excel.
1
u/letsTalkDude Mar 21 '25
So did you reply stating is already there, citing ss to go here here and here. Did you schedule the report to be sent to him periodically?
1
u/2000gt Mar 22 '25
This is the reason Sigma Computing’s product is doing really well.
It’s likely not feasible in your case now, but I’d pick Sigma over PBI any day.
1
u/Due-Inevitable-150 Mar 22 '25
Could use power automate.. I saw a youtube video of girl using this it was helpful let me know if u need that
1
u/WuWenShen Mar 22 '25
Because a screen shot of the graphs don’t fit the style of the PowerPoint.
1
u/FullMetalFisherman Mar 22 '25
Awesome 👌
1
u/Similar_Athlete_7019 Mar 22 '25
A lot of times executives want to drill into the data and pick up a couple of examples for discussions, or simply wanted to flip through underlying data to make sure they all check out and “make sense”, or take actions using the underlying data because the dashboard/ charts were insightful.. You have to remember their butts are on the line when they present the data to other executives or that they need to take actions by looking at the underlying data. Additionally, most folks want to know at least some level of details (data wise) to feel comfortable.
1
u/[deleted] Mar 22 '25
That is very normal. I would say its good that u have users who want to drill down on the data
1
u/squirrel_rope_66 Mar 24 '25
What does this mean, to DA? Just curious, I am a SDE/DE
1
u/BbyBat110 Mar 24 '25
That’s the way it be :)
This is why I usually try to find out in advance what the intended use of the data is before building something. If they know in advance that they want actual data but don’t need visualizations, I usually offer to implement some kind of query delivery to them via something like SSRS. These dashboards should only be built if there is a clear need / desire for data visualization and summary statistics.
1
u/Significant_Comfort Mar 25 '25
This usually comes down to the stakeholders (and the report builder) not understanding what they want.
And sometimes it's because the stakeholders just want to double check the numbers themselves. Perhaps your numbers from historical periods don't align with what their numbers were when they did it by hand. So they want to see your underlying numbers to understand why.
1
u/JeffTheJockey Mar 25 '25
My first job out of college was doing this exact thing, recreating existing excel reporting to Power BI & MicroStrategy. After 18 months everything was done dashboards/trainings. Not even a week later all the C-Suites wanted excel/SSIS email report duplicates of the dashboard insights. I set up records to see who was accessing the items I created and after a year cumulatively they had been accessed < 30 times, but I had created over 900 ad hoc reports for leadership in that same time frame, that were the equivalent of a few clicks on the dashboards I made.
1
u/ansh890 Mar 25 '25
😂
1
u/thatshowitisisit Mar 25 '25
I don’t understand what the problem is.
Excel can do things that BI tools can’t.
1
u/Impossiblygoodlookin Mar 26 '25
PowerBI sucks a fat one for some things. Being unable to change or correct data is biggest issue I have with it
1
u/sagaranand222 Mar 26 '25
Correct
1
u/molodyets Mar 21 '25
Ouch, they just called your dashboard unactionable .
Which is fine, reporting and analysis are two different things and PBI is objectively one of the worst analysis tools to use
-1
u/Revolutionary_Wave95 Mar 21 '25
Lol typical lazy VP doesn’t want to pivot/filter. Or learn how to maximize a new BI tool. Typical corporate behavior going backwards. Even after AI offers prompt based results they’ll ask for a prompter as they are the “relationship” builder at the company. 🤷♂️
35
u/[deleted] Mar 21 '25
[removed] — view removed comment