Nilhan Perera

Hi, today I an informative blog on what a Schema is and the difference between a Star Schema and a Fact Constellation. Once again I was attending a training session on Business Intelligence and Analytics and this session happened to be on Dimensional Modelling.  The following are a few interesting topics that were covered Data Warehouse A relational database structure is one that supports Online Analytical Processing. It acts as a Central Repository for all data from various sources. Here the data is de-normalized and because of this it speeds up the retrieval process of read-oriented data. Data Mart Data Marts on the other hand mainly focus on storing data related to a single business unit, vertical or process. Schema A logical description of an entire database that includes the name and description of records of all record-types including all associated data items and aggregates. The question then arises Star Schema Vs Fact Constellation Fir...

Love Your Data…… Breathe it, Dream of it, think of it as you would think of that special someone. Hi, I am Nilhan. A Student, a Foodie and now a major enthusiast in the field of Business Intelligence. I am currently a Software Engineering Student and an Intern at One of Sri Lanka’s Premium Technology Solutions partner’s that cater to Industry Leaders around the World. The term Business Intelligence was first introduced to me by Google :p.  I was doing some research one afternoon about Big Data and the role of a Data Scientist and this term Business Intelligence was quite frequently mentioned in most of the articles I read, so out of curiosity, I looked it up and well there was quite a lot on it, but I could not clearly understand what it was at that time. Fast Forward One year and I am attending a training program conducted by this cool person who also happens to be one of the very few people here in Sri Lanka to hold a Microsoft MVP status in the SQL and Data Plat...