One of the common source data files that every ETL Developer/Architect will have to grapple with every now and then is XML source files. This is even truer given how common distributed systems have become and the need for applications from different sources and protocols to share data and communicate. Read more
Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings to the BI table. The Microsoft Power Query for Excel, previously the Data Explorer, provides a useful tool for gaining insights into data, data transformation and analysis.
The MS PQ… Read more
I have discovered from working on projects that sometimes you may have to make use of temporary or staging tables for things like loading, parsing and data cleansing. Let’s assume that as per your project or company’s database naming convention, these tables are all prefix with the name/value; “temp_”… Read more
Sometimes in life things happen when you least expect them. This was my experience some few weeks ago when I had to install SharePoint 2010 on a new server. I installed all the pre-requisites needed for this application and going forward I was faced with a very strange error –… Read more
In this blog post, I will be sharing a new date feature in SQL Server 2012 called the EOMONTH (End of Month) which is used to find or get the last day of a month in a specified date.
In prior versions of SQL Server 2012, date functions like “dateadd”… Read more
I am sure you have heard of the term; garbage in garbage out. This maxim is even more true when it comes to preparing, processing and analysing data for reporting purposes. In this blog post, I will focus on some of processes of data quality and then share some… Read more
These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around when to use any of these, I feel oblige to share and infact to also learn more from anyone out there.
This data is used for storing a… Read more
I am wrapping up this series by finally considering the rarely used type 3 SCD.
( i.e. in most business scenarios)
Unlike the Type 2 SCD, the type 3 SCD tracks only the current value and the original value of a dimension member.
Two attributes are normally used in designing… Read more
In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type II. Let’s assume the table below holds historical info of call plans of a customer in the Telecom industry.
Historical information storage (As a row)
From the table above it… Read more
SCD is a basically a concept that explains how historical data/values are stored within a data in a database.
There are three main scenarios namely Type I, Type II and Type III.
In this post, I will be discussing the Type I scenario and I promise to do the part… Read more