Links in Power BI

This is just a compilation of different types of linking mechanisms in Power BI. I have explained them from use case point of view. It’s mainly written for newbies like me who are wondering which linking feature is applicable for which use case? 🙂 Tiles: Link between dashboard and reportss This is only available for … More Links in Power BI

Non-additive measures with different granularity in Power BI

I have found many articles on web regarding non-additive measures in power BI. But most of them are about inventory-type measures where normal aggregate functions are not suitable for use. However, in real life we often face situations where data providers deliver pre-calculated measures for different hierarchy levels. Numeric distribution, weighted distribution, market share etc. … More Non-additive measures with different granularity in Power BI

Restore SQL Server database using SAS from Azure Blob Storage

You need to create a SQL Server credential first to restore a database back up from Azure blob storage. A lot of writings can be found around the web on this. Most of them have used Azure Storage Account to create the credential in the first place. In this short post, I will be using … More Restore SQL Server database using SAS from Azure Blob Storage

From SQL to Spark

When I started learning spark, I decided to learn it from the other way round. That means, rather than going through a step by step journey, I decided to learn it from BI reporting perspective. I took a table with some data. Then, I tried to answer some common reporting queries by using python+Spark. It … More From SQL to Spark

Visual Insight charts inside Microstrategy documents

Microstrategy visual insight has lots of exciting beautiful looking charts. But many of them are not available in documents. You can import them into document following the steps described below. But, do not do this unless you really have to do it. Because, those imported charts become difficult to maintain inside document. most of the … More Visual Insight charts inside Microstrategy documents

Metric calculation based on selection in Microstrategy

Hello guys, I am back after a long time. I was learning Microstrategy during last one year. So, here I am, writing something on mstr. Today, I am writing about a problem that almost every mstr developer faces. Let’s say, you have two base metrics: dollars and units. Now, you like to calculate Market Share … More Metric calculation based on selection in Microstrategy

What I have learned in the name of unit testing of ETL, DWH, OLAP Cube and MDX

In one of our projects, we ‘somehow’ decided that every part of the system should be ‘unit test’-ed . It was a classical ETL->DWH->Cube project where web dashboard was built to show BI reports from cube (using MDX as reporting language).  Off course, unit testing was nothing new to our web developers. But, our data warehouse developers … More What I have learned in the name of unit testing of ETL, DWH, OLAP Cube and MDX