MPP & Distribution in Azure SQL Data Warehouse

I was fortunate to attend a training about Cortana Intelligence Suite and SQL Data warehouse at Microsoft Paris. The training covered a series of modules on the field of Data Science + Azure SQL Data Warehousing.

As a BI specialist, I got interested in the SQL Data Warehousing part and I plunged into the fantastic world ofAzure Data Warehouse (ADW) in the last days.

In this article, I would like to talk about two concepts in Azure SQL Data warehouse : MPP & distribution. These concepts define how your data is distributed and processed in parallel:

Read More MPP & Distribution in Azure SQL Data Warehouse

 

Parent / Child Dimension Properties - Part 2

After creating our Parent-Child dimension (Part 1), we will see in this second part, the different properties of this dimension.

For this, we keep the same example as before : the dimension of the families (Categories) of a product organized according to a descending hierarchy.

Let's go !!!

Read More Parent / Child Dimension Properties - Part 2

 

The Parent / Child dimension - part 1

Parent-Child dimension is a type of dimension that I did not know before (yes we can not know everything ☻), but I had the opportunity to use it within the framework of a project on which I worked; suddenly, I said to myself that it will be a good idea to share with you what I learned about this dimension.

In order to better explain how to create this type of dimension and the options, you need to understand the context of the example which is part of this article.

Read More The Parent / Child dimension - part 1

 

Create an HDInsight cluster using PowerShell

This article provides a mechanism for creating an HDInsight cluster using Windows PowerShell.

The objective is to define a PowerShell script to create and configure your HDInsight cluster and of course delete it afterwards because one of the features that is not yet managed in Azure for the moment and we want it to be added soon , is the shutdown of your cluster when it is not in use, because leaving it running costs money.

Read More Create an HDInsight cluster using PowerShell

 

Dynamic management of SSAS partitions - part 2

Here we are in the 2th part of this article where there is less blah blah but more practice (putting our hands in the leg !!)

In this part, I will explain the step by step operations to create the cube partitions in a dynamic way.

  • Step 1 :

First, prepare the test data, for that, we will work with the database and the cube AdventureWorksDW, you can download the sources as well as the deployment scripts from the links below:

Read More Dynamic management of SSAS partitions - part 2