SSAS: Build a Cube and access data in Excel

This video demonstrates how to build a cube in Microsoft SSAS and later on access the cube data from Excel.


Please leave feedback if this was helpful. Thanks!

T-SQL: CURSORS

Cursors in T-SQL are usually not very performant. Depending on the data quantity and what you're trying to achieve, they may be very useful. Please check the video below, where I demonstrate a sample, when Cursor does the job!



Please leave feedback if this was helpful. Thanks!

SSRS: Using .NET custom code for formatting

In this video I will write a funciton in VB.NET to later use for formatting purposes (changing font color).

Please leave feedback if this was helpful. Thanks!

T-SQL: PIVOT vs. UNPIVOT

Today I'm presenting the very helpful aggregation function PIVOT and later a reverse function of this called UNPIVOT. This function helps you present your data in a maxtrix form!


Please leave feedback if this was helpful. Thanks!