We will design the database with repeating data. Note: In real time projects there will be more number of tables involved while joining and every table contains many records. CityIdĪt the end of the day Normalized database leads to multiple join conditions in select query and thus affects the performance.įor above example query will be “Select CustomerId, CustomerName, CityName from TblCustomer inner join TblCity on TblCustomer.CityId=tblCity.CityId” Exiting data will be referred wherever required)įollowing tables are the part of normalized database.
Normalization is a database designing technique which makes sure that there will not be any redundant data. It normally stores months or years of data to support historical analysis What is Denormalization? The records from multiple data sources (may be some other databases)are collected and stored in Denormalized manner.
Usually data warehouse is also a database. In a very simple word it means, “It's a place where we store all of our data”.
We will start with very basic stuffs like understanding what is mean by Data warehouse and business intelligence and end with creating some complex SSRS Reports. Learn it and develop your more in-depth knowledge with complete step by step MSBI tutorials on What all we will do here?
#Sql server business intelligence development studio 2013 series
This Learn MSBI article is now outdated we would request to see our latest article using SQL Server 2014 IntroductionĪfter a huge success of our first step by step series article on MVC we are back again with our new initiative “Learn MSBI Step by Step”.