The Merge Join Transformation and a SSIS Sorting Tip

My previous blog post was about the SSIS Lookup task and how it really works. Now that I have shown that the Lookup task shouldn’t be used for one-to-many or many-to-many joins, let’s take a look at the Merge Join transformation task. If you follow along with this blog, you will learn a little tip that will eliminate the requirement for you to add a SORT transformation task within your data flow task.

Continue reading The Merge Join Transformation and a SSIS Sorting Tip

Creating SSAS Hierarchies with Multiple Dimension Tables

Recently, I was tasked with building a hierarchy using multiple dimensions. I was advised to use a named query or materialized view to accomplish this because SSAS doesn’t have the capabilities to read the columns/attributes from multiple dimensions. Since I have done this before, I decided to take the AdventureWorks database and give a step-by-step tutorial of how to accomplish this request. Let’s get started!

Continue reading Creating SSAS Hierarchies with Multiple Dimension Tables

Business intelligence goes mobile with Microsoft

4.24_Blog_Post

 

Welcome to the information age, a time when businesses have access to a wealth of different data, ranging from first-party collected facts to Web analytics metrics. While organizations have always used data in one form or another to drive decision-making processes, companies nowadays are easily gathering information from CRM and ERP systems as well as discovering a variety of different data sources, including social media, cybersecurity reporting tools and industry studies.

Continue reading Business intelligence goes mobile with Microsoft

SQL Server Business Intelligence Environment Planning

One of the most critical initiatives for any organization involves building a business intelligence infrastructure and solution. Before embarking on this endeavor, it is key to put the proper resources in place for a successful business intelligence implementation and evolution.

Continue reading SQL Server Business Intelligence Environment Planning