January 18, 2010 at 8:17 am
Hi everybody,
I am trying to implement BI, but I would like to get a checklist of the things I need to do, because probably I am leaving something left.
Currently I have done the dimensional model, also I have the ETL ready and, using analysis services I created the cubes, then I moved to SSRS to create my reports, but i can't do drill downs, neither dashboards.
So, what i would like to know is the steps I need to go through in order to implement a completely functional Data Warehouse.
Thanks.
Frank.
January 20, 2010 at 7:12 pm
The typical basic steps would be:
1) Gather Requirements
2) Dimensional Modeling
3) ETL
4) OLAP Design
5) Front-end BI Delivery
With SSRS you are going to have to build your own drilldown functionality unless you hide certain levels of hierarchies to give a drilldown look-and-feel. Chris Webb has a report that you can check out on ReportSurfer.com - http://reportsurfer.com/_webapp_170467/Real_Analysis_Services_Drilldown.
Other tools that you might want to look at that are in the Microsoft stack would be Excel 2007, ProClarity, and PerformancePoint.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
January 22, 2010 at 6:35 am
Thank You very much Dan!
Frank.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply