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,110 points
36 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
• 14,070 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 in Power BI by Phalguni
• 1,010 points
85 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
• 40,480 points
226 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
• 40,480 points
53 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,530 points
256 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
• 12,530 points
120 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
• 40,480 points
56 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
79 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
• 14,070 points
45 views