Blog Objective

This is a blog that attempts to make life easier by noting down the author's accrued knowledge and experiences.
The author has dealt with several IT projects (in Java EE and .NET) and is a specialist in system development.

05 November 2010

Take-Home Notes from Seminars

Emerging Technologies

  • Cloud – for starters, for for non-business critical functions like CRM, email, collaboration
  • Collaboration
  • User experience
  • Data deluge – what to do with so much data?

Top Business Prioritises

  1. Business process improvement
  2. Reduce enterprise costs
  3. Increase use of information & analytics
  4. Improve workforce effectiveness
  5. Attract & retain new customers

Business Intelligence

State of Business Intelligence today – 20% of users in an organisation have BI in place; 80% of users do not.
BI Solution Architecture
  1. Source system
  2. ETL processes
  3. Data Warehouse solution (ODS, Staging, Analysis cubes)
  4. Report presentation

Microsoft Business Intelligence Strategy

  1. Familiarity – Office integration
  2. Collaborative – SharePoint integration
  3. Manageability – MS SQL

Data Warehouse

Trends in Data-Warehouse

  1. Increase in volume
  2. Reduce cost
  3. Adoption of appliances
  4. Move into MPP
  5. Desire for real-time analytics
  6. Realisation of the importance of data quality

Microsoft DWH Strategy

  1. Low TCO for massive scalability – SQL 2008 R2
  2. Hardware flexibility – Fast track data warehouse
  3. Improved business agility & alignment – Parallel data warehouse (need to consider when data reaches 50TB)
Source system –> Data Warehouse –> SharePoint (report dissemination)


Information Workers spend 48% of time searching & analysing information.
Customer centricity
CapabilitiesReportingScore-cardingData-miningClosed-looped analytics

No comments: