Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

MSAS – Building a Relational Decision Tree Model

By Exforsys | on May 6, 2005 |
MSAS
Let us assume FoodMart wants the members with Golden Membership to be studied. It wants to focus on broadening the membership of the Gold Card. This can be done now using the Decision Tree Model.

The Decision Tree model can be created from the relational data contained in the FoodMart 2000 Access database.

1. In the Analysis Manager tree pane right click the Mining model folder and select New mining model…

2. In the Wizard Welcome screen click Next to proceed.

3. In the Select the source type screen select ROLAP model.

4. Next select the source table for defining our database. The window displays the available data sources. New data sources can be added by clicking on the New data source button. We will build our decision tree by using two tables:–Customers and Sales_fact_1998. Select the radio button for Multiple tables. Now add the selected tables from the list of those available by double clicking on it or selecting it and clicking the arrows to move the tables.

5. In the next screen we have to choose the Algorithm for the mining model. Select Microsoft Decision Tree and click Next.

6. In the next screen we are prompted to define how the tables are related. We can edit and create joins on this screen. A default join is displayed and this can be changed if we are not satisfied.

7. In the next screen we will proceed to define the Key column that will uniquely identify our case. Since our focus is on customer we will select the customer ID as the column key for analysis.

8. Next we will proceed to identify input and prediction columns. Input columns are considered during the partitioning process and give the user the best split. The aim is to identify the demographic factors that determine Golden card holder’s behavior. Let us add member_card from customer table and unit_sales from the Sales fact 1998 table to the predictable columns and all the columns from the customer table to the Input Columns pane.

9. Now click Next to save the model and process it. Let us name our decision tree mining model as Customer sales tree. We will save the model but not process it. Select the Radio button and click Finish.

10. Now let us edit the model in the Relational Mining Model Editor. This editor has only the parameter pane on the left and the tables are displayed on the right pane with the join in place. There are two tabs in the right pane one for Schema and the other for content. Click the content tab to view the content. A message is displayed asking the user to process the mining model.

11. Right click on the mining model in the left pane and click process.

12. The following message is displayed

13. Save the cube and process it. Click Yes to save and process. The user is now asked to select the processing method. Full Process is selected by default. Click OK.

14. The process log window opens and the model is processed.

15. Now view the data in the content tab.

16. Note that some nodes have higher concentration of cases than the others. Selecting one node and double clicking it we get a larger view of the data.

17. We can navigate the nodes and see the various attributes of the nodes until we have a pattern. Let us say we want to see if golden cards are held by persons who are in the higher income bracket. Let us focus on persons with $150K + salaries per annum. Double click on the node.

18. The node has two sub nodes: Persons who are married and persons who are not married.

19. There are further levels to the decision tree as indicated by the forked lines. Let us double click on persons who are married.

20. Under the married persons, persons not in USA node has further levels. Let us double click on that and examine the nodes.

21. Now we know that the number of persons having account numbers greater than a particular number or less than a particular number have golden membership but the percentage of such members is only 32.26%, Whereas the members who have an Account number greater than 42343243776 or >86 have 88.89% golden membership.







 

22. A pattern emerges. Persons having high income levels, who are married and not in USA and having an account number over a particular range have golden cards. Now we can examine the attributes of such persons-whether they are educated or reside in a particular geographical area or shop at a particular store etc. The final pattern that emerges can be used to make marketing decisions.

« « MSAS – Introduction to Data Mining
MSAS – Browsing the Dependency Network » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 401 Followers
  • Popular
  • Recent
  • MSAS : Office 2000 OLAP Components

    March 25, 2005 - 0 Comment
  • MSAS – Building a Virtual Cube

    April 24, 2005 - 0 Comment
  • Designing the Dimensional Model and Preparing the data for OLAP

    March 1, 2005 - 0 Comment
  • MSAS: Introducing Member Properties

    April 7, 2005 - 0 Comment
  • MSAS – Browsing the Dependency Network

    May 6, 2005 - 0 Comment
  • MSAS : Browsing the Cube

    March 10, 2005 - 0 Comment
  • MSAS – Introducing Dimension and Cube Processing

    April 17, 2005 - 0 Comment
  • Understanding Dimension Basics

    March 29, 2005 - 0 Comment
  • MSAS – Creating and Maintaining Calculated Members in Virtual Cubes

    April 24, 2005 - 0 Comment
  • Understanding OLAP Models

    March 2, 2005 - 0 Comment
  • MSAS – Browsing the Dependency Network

    May 6, 2005 - 0 Comment
  • MSAS – Introduction to Data Mining

    May 6, 2005 - 0 Comment
  • MSAS – Applying security to a Dimension

    May 5, 2005 - 0 Comment
  • Tutorial 65: MSAS – Managing Cube Roles

    May 5, 2005 - 0 Comment
  • MSAS – Understanding Database Roles

    May 5, 2005 - 0 Comment
  • MSAS – Securing User Authentication

    May 2, 2005 - 0 Comment
  • MSAS – Introducing Analysis Services Security

    May 2, 2005 - 0 Comment
  • MSAS – Writebacks

    April 28, 2005 - 0 Comment
  • MSAS – Defining and Creating Drillthrough

    April 26, 2005 - 0 Comment
  • MSAS – Defining and Creating Auctions

    April 26, 2005 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • MSAS – Browsing the Dependency Network
  • MSAS – Introduction to Data Mining
  • MSAS – Applying security to a Dimension
  • Tutorial 65: MSAS – Managing Cube Roles
  • MSAS – Understanding Database Roles

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2022. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy
Necessary Always Enabled