Thursday April 27th 2017

Categories

Insider

Archives

‘Analysis Services’ Archives

A Better Way to Model Data

A Better Way to Model Data

Over the last three decades ERP, CRM, and Analytical systems have evolved. However the way in which those systems store that data has not. In fact in those 3 decades there has been no change in the way that ERP, CRM, and Analytical systems store data. Generally speaking, modern day ERP and CRM systems are based upon data that has been modeled [...]

Open data, SSIS and Excel

Open data, SSIS and Excel

Recently Downloaded the Large dataset from UK Government Open Data Website i.e. Land Registry Price Paid Data from 1995 to 2015 about 24 million definitive records dating back to January 1995. Used the SSIS to get the data into SQL Server from CSV. Initially aggregate the data using the following query, select YEAR(), [...]

Marketing analytics solution has to treat simplicity as a “must-have” rather than a “nice-to-have” feature.

Marketing analytics solution has to treat simplicity as a “must-have” rather than a “nice-to-have” feature.

Data analytics can be a game changer for marketing organizations. McKinsey’s DataMatics study showed that firms in the top quartile of analytics performance were 20 times better at attracting new customers and more than five times better at retaining existing ones than firms in the bottom quartile. But many companies struggle to realize the [...]

Analysis Services tutorial, Key Performance Indicators (KPI)

Analysis Services tutorial, Key Performance Indicators (KPI)

Analysis Services tutorial, Key Performance Indicators (KPI) A Key Performance Indicators (KPI) help a business organizations define and measure progress toward meeting its goals.

Analysis Services Tutorial – Creating OLAP cube. Introduction to data warehouse

Analysis Services Tutorial – Creating OLAP cube. Introduction to data warehouse

I found this tutorial to be very helpful it explains very - how to create, manage and share OLAP cube, dimensions, measures and how to integrate relational and online analytical processing (OLAP) data for business intelligence (BI).