Power BI

What is Power BI

Power BI is Microsoft's business analytics platform that connects to various data sources, transforms raw numbers, and turns them into interactive visual dashboards for better decision-making.

Power BI desktop vs service

Use desktop to build reports and publish them to power BI service, where users access and interact with reports.

Front end vs Back end

Front end: what end users see, tables inside our power BI data models.

Back end: query editor, where our raw data is extracted, transformed and loaded to front end (ETL)

Data connector

A software bridge, built into Microsoft Power BI, that lets you link to external files, databases, and online apps. It handles sign-in security and pulls your info into your reports.

Power Query Editor

Power Query Editor in Power BI is a tool used to connect to data sources, clean raw data, and shape tables before loading them into your report. It acts as an ETL (Extract, Transform, Load) workspace.

Power BI transformations

Power BI transformations refer to the process of cleaning, shaping, and restructuring raw data into a usable format before loading it into your report model, primarily handled using Power Query.