Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)

Hi Guys, I have been waiting for an official certification from Microsoft on Power BI. And finally I saw the exam opened up. 🙂 Even though it is still marked in Beta but you can go-ahead and schedule if you want. Or you can start gearing up with necessary technical knowledge to complete the certification. …

Continue reading ‘Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)’ »

MERGE your knowledge from EXPERTS – “Project BOTTICELLI”

Hi guys, I am just about to write an introduction of “Project Botticelli” for you; but they gave their introduction in very nice and precise manner so I decided to extract that and put it here for your quick reference. (Excerpt from https://projectbotticelli.com/about-project-botticelli-ltd) “Project Botticelli Ltd is a small company offering online training by business …

Continue reading ‘MERGE your knowledge from EXPERTS – “Project BOTTICELLI”’ »

What is OLAP Database ? What is FASMI?

Hi guys, i was reading an article and came across this term “FASMI“. i have done a little bit of RnD to find out its head & tail. This is what it means: FASMI is an acronym of “Fast Analysis of Shared Multidimensional Information“. A database when called “OLAP Database” if it satisfies following FASMI …

Continue reading ‘What is OLAP Database ? What is FASMI?’ »

Behavior Changes to Analysis Services Features in SQL Server 2012

Hi all, I would like to draw your attention to the few modifications in SSAS behaviors in SQL 2012. The most important difference you will find is the “Cube Browser”. Yes, it’s totally changed. According to Microsoft “The cube browser control that let you drag and drop fields onto a PivotTable structure in Management Studio …

Continue reading ‘Behavior Changes to Analysis Services Features in SQL Server 2012’ »

Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)

Hi all, How are you doing? Today I would show you; how you can highlight minimum and maximum values in an each row of matrix report in SSRS. Again, “there are lots of ways“, but that depends on what is your solution framework. If you are using standard T-SQL queries for reporting, then it’s easier …

Continue reading ‘Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)’ »

MDX Query Parameterization for displaying Last 12 month’s SSRS Report

Hi All, While working with SSRS reports for displaying some financial data; many a times we have to display data for particular time-frame. Or most commonly – last 12 month’s data. I am talking about the case where you are pulling data from SSAS Cube using MDX queries. In this particular example, I need to …

Continue reading ‘MDX Query Parameterization for displaying Last 12 month’s SSRS Report’ »