SSAS Partition wise Disk Usage Report
Objective The objective of this report is show size of the partitions available in the cube and which storage mode…
SSAS Dimension Performance Report
Objective The objective of this report is monitor progressing time of all the dimensions as well as data retrieval time duration…
SSAS Partition wise Processing Report
SSAS Cube gets data and do pre aggregation from OLTP systems when we process the cube. We can divide the…
SSAS Measure Group wise Query performance Report
While monitoring the performance of SSAS Cube, we can drill down the performance monitoring at Measure group levels. Cube contains…
SSAS Query Performance Detail Report
The objective of this article is provide information on how to monitor Cube performance by logging their query logs and…
Features of Modern days Performance Monitoring Tool
1. This tool can be a web based tool so that it is easy to access the tool. 2. It…
Onboarding Process Document for Software / IT Projects
1. Background The objective of this document to provide a detailed information about Onboarding process for an IT/Software project. It…
Recommendation for SQL Query if date column data type is NVARCHAR (String)
Problem: If date column in SQL Server table is of NVARCHAR (String) type. 1) Because of nvarchar datatype, date in the…
Power BI: How to create Age slicer if date of birth is the only field available in the data model
If there is a requirement of creating an Age slicer which is numeric slicer and only date of birth is…
Power BI – How to create 5 STAR Rating in Power BI
1) What is 5 STAR Rating Customer review(s) help us in building our brand and also helps customer to…
Power BI – How to refresh single table from data model
Issue: When we click on Refresh button to refresh the table(s) in Power BI Designer, by default, it will start…