Excel vs Power BI. When does it make sense to use the latter, if ever? I have spent my career using excel, but my some people in my company are starting to talk about PowerBI. Thoughts?

like
Posting as :
works at
You are currently posting as works at

Amount of data and amount of visualizations you need. Power BI more often than not has Excel files as a data input (and power BI is used to present & manipulate the data in an easier way).

like

Pretty much any time you want to share a report for others to see data without the need to input data. Power BI doesn't allow you to input data (at least without jumping into Power Apps) so it's best to display data. That being said it's leaps and bounds ahead of Excel for doing that. The ability for scheduled refreshes of data and the visualizations alone make Power BI the way to go. If you're just doing quick analysis or need others to input data, Excel is fine but you'll be ahead of the curve by being able to model and create reports on Power BI.

like

As others have said, any time you want to share or visualize, use PBI. Excel is great for data storage. PBI is great for visualizing.

Note that you SHOULD get your data moved into an RDBMS. But that’s not always possible. And if you have everything externalized to PBI it also isn’t a decision you have to make right away.

like

And data security. You can set up RLS in power bi

like

I wish my company didn’t get rid of power bi 😂

Related Posts

Are we all small training sets waiting to experience and learn it all and eventually be part of the master AI aka God?

like

Big 4 EAs: How many partners do you support? How many do you think is realistic for the pay and your sanity?

like

After nearly 20 years in the military serving in T&E and HR roles, I’m considering moving on and have been conducting lots of research into consulting. BS, MA, and SPHR cert - no MBA. I’m looking for suggestions or advise about transitioning. DC Metro area is likely landing spot.

like

Hi fishes, How will the below assessment in hexaware
DA_ Selenium_Java_Automation Testing_HTD_2021

It was scheduled for tomorrow.
My experience in 2.11 years in automation testing

like

What sort of equity stakes do management teams at PE-backed companies typically get?

like

All days are work days

Post Photo
likefunny

Hi Guys,
I have multiple offers including offers from TCS.
But the TCS offer is less. So I'm not planning to join. Will the company block me if I do not join.

like

McKinsey & Company I am a senior graduating soon with a technical masters (accelerated program) from an Ivy League. I have an offer for Facebook TPM and McKinsey & Company BA. McK first year TC is 75k less. Will McK increase the offer? If so, how much?

Any thoughts on FB vs McK?

like

For those of you who are SHRM CP certified. Can you please advise if the SHRM learning system is worth it? Are there other effective learning tools that are less expensive ?

like

EY India Hi all
Which is better in terms of wlb?
EY India OR EY gds

like

Is the working hours mentioned in my workspace correct? I have recently been allocated to a project and it shows timings from 11 pm -9 am..

like

Lawyers in Public Accounting, what have your non-public accounting job experiences been like? If you’re currently in public accounting, are you happy where you’re at or do you aspire to do something different? I’m always curious to hear about career paths.

like

If I resign from IBM , within 11months 15days what will happen?

like

No one really talks about what to do once you get Covid-19. Have companies made an effort to proactively educate employees, or create a process to help employees report their illness with next steps?

like

Has anyone successfully managed their ADHD without medication? Looking for homeopathic remedies or tips

like
like

Hi - I have an interview with Johnson & Johnson for a Leader role. There seems to be multiple interviews with multiple people in the organization. Hoping to get some insight on this process from those who have been through it as it sounds like a great opportunity. What do they look for? How can I ace the interview?

like

Planning director vs strategy director. Whats the diff? Is there a diff?

I feel like a planning director wouldnt know how to manage digital strgy while a strgy dir would be much more well rounded

like

Creatives who left for tech. What is it exactly that you do now? Is it still writing or art directing? Or a different creative role? Hearing about people leaving for tech so I want to know what it means exactly aside from the benefits.

like

Accenture 🐟

How difficult is it to get the top of the range listed in the job postings? Also, are what are standard sign on bonuses?

like

Additional Posts in Excel Genius

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Would anyone be willing to teach me vlookup?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Anyone know what these badges are?

Post Photo
likefunny

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal