Follow Us: facebook twitter linkedin

Veeram Raja's Articles

Are you taking advantage of multi-dimensional analytics with OLAP cubes?

Cube Image 2Many companies spend a lot of money, time and effort to build a data warehouse and OLAP cubes, however they start using them to build the same old 2D reports that they were used to from the past. The standard 2D canned reports (Rows and Columns) can be built from any conventional relational database by writing some standard SQL queries. So why use an OLAP (On Line Analytic Processing) cube for such reports?

Time Dimension for Business Intelligence

dim_timeBusiness Intelligence reporting includes the usage of "dimensions." To put it simply, a dimension is a way that you want to "slice" your metrics. For example, you may have a metric of revenue that you want to track. You may want to track this for dimensions such as product (i.e. provide a report of revenue by product), by territory, or by time. The time dimension is one of the most often requested dimensions for business intelligence reporting - but it can also be one of the most complex to implement. This post takes a look at how to create an effective time dimension for your BI project.

 

 

Blog Topics

1
Image

CPR for CRM Study

The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.

2
Image

SharePoint Readiness Assessment

This 60-second assessment is designed to evaluate your organization's collaboration readiness.

3
Image

CRM Self Assessment

Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.

4
Image

SharePoint Feedback Solution

This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.

9
Image

SharePoint Upgrade Checklist

Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.