What’s New in MDS of SQL Server 2016

Posted by on May 28, 2015 in MDS, SQL Server 2016 | 6 Comments

SQL Server 2016 CTP 2 released almost a day ago, and I’ve had a chance to install it and play with Master Data Services to see what changes has been made in this product. Master Data Services is a service of SQL Server first released in SQL Server 2008R2, and enhanced in SQL Server 2012. ...

Read More

DMX with .Net-Part 1

Posted by on May 26, 2015 in Data Mining | No Comments

Predictions always matter; it is always nice to find a pattern in existing data. It will help to have a more accurate decision-making. These days, I am busy with designing and implementing a prototype for tourist recommendation system. I need to use variety of data mining algorithm such as “clustering” “Decision Tree”, “Regression”, “Neural Network”. ...

Read More

Incremental Load: Change Data Capture in SSIS

Posted by on May 26, 2015 in SSIS | 8 Comments

Incremental Load is always a big challenge in Data Warehouse and ETL implementation. In enterprise world you face millions, billions and even more of records in fact tables. It won’t be a practical practice to load those records every night, as it would have many downsides such as; ETL process will slow down significantly, and ...

Read More

DMX practice for Tourist Recommendation System

Posted by on May 18, 2015 in Business Intelligence | No Comments

  there is a first experience with DMX I employed  DMX in my .NET code last year to create a travel mining model for predictions travel budget, length of travel, destination. I need to predict via different algorithms. so I have  added a reference to Microsoft.AnalysisServices.AdomdClient to my C# project using Microsoft.AnalysisServices.AdomdClient; public AdomdConnection connection = ...

Read More

Codecamp Christchurch 2015 SQL and BI Stream Highlights

Posted by on May 16, 2015 in Events | No Comments

Codecamp Christchurch 2015 ran today on Christchurch Poly-technique of Technology. I’ve joined the even in last minutes when the agenda was full set, so I only joined as audience. There was a really good turnout for the codecamp about 200 registered. Three streams ran on Software Development, SQL/BI, and SharePoint. 5 sessions in each stream. ...

Read More

Introduction to Power BI Designer

Posted by on May 15, 2015 in Power BI | No Comments

Power BI Designer is the new Editor for Power BI main components which are: Power Query, Power Pivot, and Power View. Power BI Designer made building Power BI solutions easier with an integrated solution. Power BI Designer’s files can be easily uploaded into Power BI site. In this tutorial video you will learn basics of ...

Read More