Are you interested in applying the power of business intelligence or a data warehouse to your project?
I can work with you to put together an initial design, or to refine a design that may already be in-progress:
- Justifying the move to a purpose-built OLAP system, including clarifying the capabilities of Analysis Services (SSAS) and the power and flexibility of OLAP vs. OLTP in certain scenarios
- Initial cube structure (mapping OLTP tables to facts and dimensions)
- Data import and update strategies (Integration Services, proactive caching, etc)
- How and when to use Data Mining
- Tools recommendations (for example: Reporting Services, ADOMD.NET, Excel, Visio or commercial tools)
- How data warehousing (staging databases) should fit in to an overall OLAP strategy
- Using Analysis Services to help offload your OLTP databases
- Infrastructure recommendations
I can deliver my design recommendations either in written form or as an interactive presentation, or both.
If this interests you, please send the following information, so that I can provide a quote:
- A brief description of your project
- Details about your database architecture and the approximate amount of data involved
- Your goals for the engagement
- Your schedule requirements