session13 - FINANCIALDATAMINING& FINANCEWEB2.0...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
FINANCE WEB 2.0 INSY 430: Class # 13 Feb. 16th, 2010
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CLUSTERING: RESULTS Source: Pan and Baskar
Background image of page 2
FOLLOWING THE GROUP  LEADER?
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
HOW GOOD IS THIS  PREDICTION? Question: how much money can we make? Algorithm: Start with 100 stocks on day 1 If leading stock goes up by 10%, buy if you can If leading stock goes down by 10%, sell if you can How much is return?
Background image of page 4
PERFORMANCE Cluster 1: Investment: $8051 Returns: $14044 Market: $6477 Cluster 2: Investment: $10518 Returns: $12883 Market: $8878 Source: Dartmouth study
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
GENERAL OVERVIEW – BI  PLATFORM Analysis Services Analysis Services Data Transformation Data Transformation Services Services ETL ETL SQL Server SQL Server Relational Engine Relational Engine Reporting Services Reporting Services Management Tools Development Tools
Background image of page 6
DATA WAREHOUSE FRAMEWORK
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
A Three-Tier Warehousing Architecture A Three-Tier Warehousing Architecture Data Warehouse Extract Transform Load Refresh OLAP Engine Analysis Query Reports Data mining Monitor Integrator Metadata Data Sources Front-End Tools Serve Data Marts Operational DBs other source s Data Storage OLAP Server ROLAP MOLAP
Background image of page 8
ON-LINE ANALYTICAL  PROCESSING (OLAP)  A category of software tools that provides analysis  of data stored in a database OLAP tools enable users to analyze different  dimensions of multidimensional data (multi- dimensional database) Analyze tactical information that answers “who?”,  “what?”, “What if?” What would be the effects on soft drink costs to  distributors if syrup prices went up by $.10/gallon and  transportation costs went down by $0.5/mile? Components: the OLAP server, which sits between a client and a  database management systems (DBMS) The OLAP server understands how data is organized in  the database and has special functions for analyzing the  data
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
MOLAP MOLAP = Multidimensional OLAP Store data cube as multidimensional  array (aggregates are stored in data cube  instead of relational database) (Usually) pre-compute all aggregates Sample products: Pilot, Essbase, Gentia Advantages: Very efficient data access   fast answers Disadvantages: Doesn’t scale to large numbers of dimensions Requires special-purpose data store
Background image of page 10
ROLAP: DIMENSIONAL MODELING  USING RELATIONAL DBMS Users see their data organized in cubes with  dimensions, but the data is really stored in 
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/23/2010 for the course INSY INSY434 taught by Professor Oh during the Winter '10 term at McGill.

Page1 / 37

session13 - FINANCIALDATAMINING& FINANCEWEB2.0...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online