Author: Arunkumar Navaneethan

March 21, 2015

FTP link to US Census data

The FTP link to US census data is available in the following link and you don’t need any access credential to browse or download the files.

Reference

March 20, 2015

SQL Server Integration Services – Introduction

In SQL Server 2008 Business Intelligence Studio is used to create the SSIS packages (Programs). It is the client side application. In SQL Server 2012 SQL Server data tools can be used to create...

Reference

March 18, 2015

Microsoft Business Intelligence Tools – Study plan

PluralSight study plan SQL Server Business Intelligence Overview (4 Hours) SSIS Integration Services Fundamentals (7 hours) Advanced Integration Services (3.5 hours) Advanced Integration Services – Part 2 (4 hours) SSIS Design Patterns for Data Warehousing (3 hours) SSRS...

Reference

February 6, 2015

QlikView vs. Tableau

An interesting article from 2014 comparing Qlikview and Tableau. Working closely with Tableau have seen it fixing user experience issues at a very quick rate.

Reference

January 20, 2015

data validation from table column – Excel

How to use a table name in data validation lists and conditional formatting formulas Link to a useful article on creating a drop-down list from table column

Reference

January 12, 2015

Waterfall chart in Tableau

A typical waterfall chart is used to show how an initial value is increased and decreased by a series of intermediate values, leading to a final value.