Power BI
Getting Started with Power BI
We'll begin with the basics and then build up from there!
Loading Source Data
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.
Importing Power Query Objects
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
Transforming Data
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.
Merging Data (many to 1)
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.
Merging Data (1 to many)
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..
Last updated
Was this helpful?