Question 1

What is Power BI?

Accepted Answer

Power BI is a cloud based analytics platform offering a suite of self-service business intelligence tools.

It enables you to:

1. Connect to a wide range of applications and data sources to import data into the service
2. Powerful data transformation tools to clean, shape, and enrich your data ready for analysis
3. A high performance in-memory modelling engine that facilitates high speed interactive analysis
4. The DAX formula language for defining context rich calculations, metrics, and KPIs
5. An open source visualisation layer with a comprehensive range of built in rich visualisations along with a marketplace of extended visualisations and infographics

Question 2

What is a Data Warehouse?

Accepted Answer

A data warehouse is simply a relational database designed specifically for serving reporting functions.

It will typically store data collected from other databases or data-oriented applications, and may also change the shape and format of that data to better suite analysis as opposed to the more granular structure that may suit data entry and maintenance.

Frequently Asked Questions

Expert Guidance for Every IT Question You Have

Frequently Asked Questions