PowerBI learnings
I. Power Query M code:
- During the practice process, I have applied functions with the reference from Microsoft's Power Query M function. In addition to tools available on function bar, the use of M code allows me to process data more effectively.
- To know what I have practiced with functions, let's check cases here.
=Table.AddColumn(#"Added Custom", "Custom.1", each Table.SelectColumns(#"Renamed Columns",List.RemoveRange([Custom],2,List.Count([Custom])-(2+5))))
II. Data model:
The purpose of PowerBi is to create reports, dashboards used for data analysis, so data should be de-normalized and taken out as fast as possiblle. PowerBi is based on OLAP (Online Analytical Processing) with the use of Star Schema model. The model includes DIM tables providing descriptive information for 4-Ws which are who, what, where and a FACT table used for calculation and measurement. A DIM table that can be used for different FACT tables is called shared DIM.
III. Dax:
- I use Dax.guide to look for the use of new DAX functions. These are DAX learnings I have earned.