Tag: business intelligence

Business Analytics and Data Science – launch and decide career in data platform

TweetThe multitude of Business Intelligence and Data Warehousing is mature enough with necessary tools & technologies, based on this business users are well versed with requirements. However, the new age of data analysis turned into expansion of Analytics which has…

Different Types of Facts and Fact Tables in Data warehouse Design

TweetIn the previous post Different Types of Dimensions used in Data warehouse Design. we have discussed most commonly used types of Dimensions in Data warehouse Design. And as promised in this post I will be discussing most commonly used types of…

Different Types of Dimensions used in Data warehouse

TweetAbout me: Kaushal Shah I am a Microsoft® Certified Solutions Associate (MCSA) for SQL Server 2012,Currently working in Microsoft BI space.I always keen to learn new technology and new skills.I have worked within different sectors of business.I have worked in…

How to Add Precedence Constraints in SSIS using BIML

TweetIn SSIS, tasks are linked by precedence constraints. If there are two tasks and you want them to execute in a certain order,  this is where precedence constraints are used to define the order in which they get executed in the…

June 13th – An important day in SQL Server community @sqlsat

TweetThis Saturday is going to be a busiest day in SQL Server community and learning arena. SQLSaturday – a popular day conference with local speakers (and MVPs) sharing their knowledge in SQL Server world. If you happen to be any of the…

SSIS Logging Template using BIML

TweetPurpose : As a BI developer you write lot of repetitive code if there are products in your company which are using same dataset but presented in different way by applying some different transformations to data or some front end changes.…

How to generate Multiple SSIS Packages using BIML

TweetAbout BIDS Helper: A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI). The Biml Package Generator provides the ability to create packages from Business Intelligence Markup Language (Biml). Biml…

BIML Introduction

TweetAbout me: Aashish Patel. I am an enthusiastic BI Developer who is always eager to learn new technology. My skill set is within Data Warehousing using Microsoft BI Stack. I have worked in various industries (Airline , Marketing Database, Document Management…

SQL Server 2014 – Accelerate Your Insights – live from San Francisco

TweetHere is the announcement (Data Platform insider blog) of live event happening on 15th April 2014 live from San Francisco Save the date to watch the keynotes streamed live on 4/15: –        Mark your calendar –        RSVP on Facebook Join us as…