Power BI
Last updated
Was this helpful?
Last updated
Was this helpful?
We'll begin with the basics and then build up from there!
Power BI has numerous data sources ranging from flat files to databases. Outlined below are 3 different types of data sources; flat files, SQL Server and SSAS Cube.
Before Power BI there was Power Pivot in Excel for creating sophisticated data models. Power BI augments this capability. Thus, we can transpose any efforts made using Power Pivot easily in to Power BI
Shaping your data as part of your data modelling can be performed either before you’ve loaded your data or after. Some of the transformations you can perform have been outlined below.
You can merge two tables/queries into a single table given there is at least 1 field that enables the tables to match (key). Doing this allows you to add columns from a reference table into your table. It is assumed that your current table/query has many records that map to a single record in the lookup table.
You can merge two tables/queries into a single table where your current table has a single record that maps to many records in the lookup table. To achieve this, the data in the lookup table needs to be rolled up (aggregated) in order for it to be brought in..
