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!

T-SQL: Find gap ranges using ROW_NUMBER()

Here I will be demonstrating how you can find gaps with help of the T_SQL function ROW_NUMBER() which I described in the previous video. In the first part I will write a query that shows where each gap begins and ends. In the second query I will show you how you generate a list of missing values.


Please leave feedback if this was helpful. Thanks!

T-SQL: ROW_NUMBER(), RANK(), DENSE_RANK() & NTILE()

In this video I'm demonstrating the following T-SQL functions: Row_Number(), Rank(), Dense_Rank(), Ntile()


Please leave feedback if this was helpful. Thanks!

SSIS: Importing an Excel file using conditional split & exporting results into multiple textfiles

This tutorial will demonstrate how to use SSIS for an Excel file import & then based on several case conditions splitting the results by exporting them to multiple textfiles.


Hope you enjoy it! Please leave feedback if this was helpful. Thanks!