(Information is Beautiful)

Posts tagged “Data Warehousing

Big Bang Data

A brief detour through art

http://bigbangdata.cccb.org/en/

“A NEW ERA OF KNOWLEDGE
The revolution of disciplines after Big Data
From professional football and literary studies to crime prevention, today the fields of knowledge that have been profoundly changed by access to big data sets are countless. Data science methodologies are opening up new paths in numerous disciplines creating specialised fields that are associated with new professional profiles.
Thus, today, in urban planning, we talk of smart city technologies; in the press, of data journalism, and in departments of history, of digital humanities.
The first wave of data-driven products is also generating tensions and rifts in the respective industries, as is happening with the highly controversial personalised genome analysis services.”


rownum in SQL Server

Oracle has a handy little automatic column called rownum, especially nice when auto-generating IDs (but be careful!!)

In SQL Server you do this:

SELECT rownum = ROW_NUMBER() OVER (ORDER BY t.[ID] ASC)
 ,t.*
 FROM [Table] t

Finding Duplicates in a table

Incredibly useful snippit for data profiling..

SELECT [ID],count([ID]) FROM [Some DB].[dbo].[Some DIM]
 GROUP BY [ID] HAVING count([ID]) > 1