session13 - FINANCIALDATAMINING FINANCEWEB2.0...

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

View Full Document Right Arrow Icon
FINANCIAL DATA MINING &  FINANCE WEB 2.0 INSY 430: Class # 13 Feb. 16th, 2010
Image of page 1

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

View Full Document Right Arrow Icon
CLUSTERING: RESULTS Source: Pan and Baskar
Image of page 2
FOLLOWING THE GROUP  LEADER?
Image of page 3

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

View Full Document Right 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?
Image of page 4
PERFORMANCE Cluster 1: Investment: $8051 Returns: $14044 Market: $6477 Cluster 2: Investment: $10518 Returns: $12883 Market: $8878 Source: Dartmouth study
Image of page 5

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

View Full Document Right Arrow Icon
GENERAL OVERVIEW – BI  PLATFORM Analysis Services Analysis Services OLAP & Data Mining OLAP & Data Mining Data Transformation Data Transformation Services Services ETL ETL SQL Server SQL Server Relational Engine Relational Engine Reporting Services Reporting Services Management Tools Management Tools Development Tools Development Tools
Image of page 6
DATA WAREHOUSE FRAMEWORK
Image of page 7

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

View Full Document Right 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
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
Image of page 9

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

View Full Document Right 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
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  a Relational Database (RDBMS) like Oracle.  Special schema design: 
Image of page 11

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern