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)

Miscellaneous

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

No comments: