PowerBI
PowerBI I have been working with Power BI implementation for the last couple of months. It's been a great experience and great tool to create different kind of datasets and dashboards. There are two important areas which we need to cover in this post. 1) ETL using Power Query M formula language 2) Aggregation/calculations for reports using DAX Formula 1) ETL: After loading the initial data into powerbi, we can manipulate the datasets as per our present requirement. This is equivalent into our traditional ETL process. Example : let Source = Sql.Database("example.database.windows.net", "EXAMPLE"), dbo_ISSUES = Source{[Schema="dbo",Item="ISSUES"]}[Data], #"Renamed Columns" = Table.RenameColumns(dbo_ISSUES,{{"PRODUCT", "Product"}}}), #"Filtered Rows11" = Table.SelectRows(#"Renamed Columns", each true), in <#"Filtered Rows...