How is power BI different from excel

+1 vote
How is power BI different from Excel.
Sep 26, 2018 in Power BI by lina
• 8,220 points
514 views

1 answer to this question.

0 votes
Power series plug-ins you can do certain similar things in Excel as with Power BI and in Power BI you can do certain types of calculations like what you can do in Excel, I would say that the intended purpose of the tools are vastly different. Excel is your traditional spreadsheet program with a very long history which leads to a vast array of features. Traditional spreadsheets allow you to reference individual cells and do all kinds of calculations. Without the power series of plug-ins though there really is no capacity to easily build complex data models, really you are just dealing with essentially unrelated tables of information.

By contrast, Power BI is really focused on data ingest and building potentially complex data models easily. In Power BI, you can easily relate separate tables to one another. You can then create a wide array of visualizations for that data and this is focused toward visualizing aggregations of that data in your data model.
answered Sep 26, 2018 by Hannah
• 18,570 points

Related Questions In Power BI

0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
1,253 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,360 points
1,727 views
0 votes
1 answer

Switch Power BI data sources from Excel to Azure analysis services

One option that you should consider would ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 52,360 points
477 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,167 views
+4 votes
3 answers

Will Power BI take over MS Excel

Well, if your taking about just data ...READ MORE

answered Sep 26, 2018 in Power BI by Vardhan
• 13,190 points
850 views
0 votes
1 answer

Why should I shift from MS Excel to Power BI

There are a lot of advantages from ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 52,360 points
469 views
0 votes
1 answer

Advance excel, Power bi and sql

Hi, @There, What type of analyst would you ...READ MORE

answered Oct 5, 2020 in Career Counselling by Gitika
• 65,910 points
617 views
0 votes
1 answer
0 votes
1 answer

How many reports can be created in one Power BI reports

You have a limit of 1000 datasets ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,570 points
1,295 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP