Where is OLAP in Power BI

0 votes
I am new to Business Intelligence and Power BI I understand the need of warehouses and dimension modeling

My question is once the data warehouse is created (in my case using oracle) i can connect it to Power BI and start creating reports with the datasets imported from my warehouse

In this case what is the difference between the data imported in Power BI and the OLAP cubes , is it the same thing ? (does Power BI creates the cubes implicitly before being able to create reports for example)

For instance, I can have my data warehouse created with usual sql and sgbd oracle (no multidimensional database , MDX or any other concept/technology) so I need to understand the utility of OLAP in this case

In case it is useful to use OLAP and or MDX , should we redesign the warehouse from scratch with other technologies or it is just a layer to add on top of oracle database?
Feb 22, 2022 in Power BI by surbhi
• 3,820 points
1,732 views

1 answer to this question.

0 votes

Is there a difference between the data loaded in Power BI and the data in OLAP cubes? NO is the answer.

When we have a data warehouse, why do we need an OLAP cube?

A cube's main purpose is to do precalculations and store the results in an analysis (in general, ssas) database. We generate an OLAP (or SSAS) cube instead of doing the calculations in the rdbms or data warehouse. As a result, the calculated formula's output is saved as a cube. As a result, the cube's core is a fact table, and the cube's dimensions are its faces.

There are various advantages to constructing an OLAP cube, but the most important ones are that we may prevent resource contention when doing analysis with the source system and that we can have data from multiple data sources for analytic processing (OLAP).

What's the use of an OLAP cube when we can import data from a data warehouse directly into PowerBI?

There is little delay because the OLAP cube stores the precalculated data for each query in PowerBI.

As a result, OLAP takes Relationships, Aggregations, Drill Downs, and Business Logic out of PowerBI and performs them at the cube level.

Unlock the Power of Data Visualization with Our Comprehensive Power BI Course!

answered Feb 22, 2022 by surbhi
• 3,820 points

Related Questions In Power BI

+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,540 points
13,898 views
0 votes
1 answer

Where is Power Bi being hosted?

Power BI is currently cloud hosted by ...READ MORE

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

Where is Power BI being used

Power BI is a business analytics service ...READ MORE

answered Oct 8, 2018 in Power BI by Kalgi
• 52,360 points
665 views
0 votes
1 answer

What is query editor in Power BI?

Hi, Power BI Desktop also comes with Power ...READ MORE

answered Feb 4, 2020 in Power BI by Rishikesh
4,957 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,130 points
1,207 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,674 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,540 points
1,419 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

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

Getting MS Power BI error when reading hive table through MapR drill odbc driver

The answer is that Microsoft Power BI ...READ MORE

answered Feb 22, 2022 in Power BI by surbhi
• 3,820 points
717 views
0 votes
1 answer

Hide the Power BI logo during visualization load

First, replace the Power BI logo with ...READ MORE

answered Feb 22, 2022 in Power BI by surbhi
• 3,820 points
2,584 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