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.
Category: Reference
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...
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...
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.
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
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.
Tableau rounding mechanism – Bankers rounding
Drawing with numbers site also as a good article on this http://drawingwithnumbers.artisart.org/unexpected-results-rounding/
Dynamic sorting with Tableau
A good article with step by step procedure to create dynamic sorting with Tableau
