Lift Table -or- Gains Table

Discussion in 'microsoft.public.sqlserver.datamining' started by Dave Smith, Apr 18, 2007.

  1. Dave Smith

    Dave Smith Guest

    Does anyone know a way to get a table that shows the "Lift" chart results in a table format split by segments of the chart? For example,
    Seg 1 - 10% of file - 15% of responders
    Seg 2 - 10% of file - 13% of responders
    Seg 3 - 10% of file - 7% of responders
    ...etc...
    Thanks for any help.
     
    Dave Smith, Apr 18, 2007
    #1
    1. Advertisements

  2. Dave Smith

    Dejan Sarka Guest

    Dave,
    Check this tip at Sql Server Data Mining site:
    http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3066.aspx.
     
    Dejan Sarka, Apr 19, 2007
    #2
    1. Advertisements

  3. Dave Smith

    Dejan Sarka Guest

    Check this tip at Sql Server Data Mining site: BTW, maybe all you need is a simple prediction query that joins the actual
    and the predicted values like this example:

    SELECT
    FLATTENED t.[BikeBuyer] AS _Actual, (SELECT $PROBABILITY AS _Prob FROM
    PredictHistogram([Lab03DT].[Bike Buyer]) WHERE [Bike Buyer] = 1),
    [Lab03DT].[Bike Buyer] AS _Predicted
    FROM
    [Lab03DT]
    PREDICTION JOIN
    OPENQUERY([Adventure Works DW],
    'SELECT
    [HouseOwnerFlag],
    [CommuteDistance],
    [YearlyIncome],
    [NumberCarsOwned],
    [Region],
    [MaritalStatus],
    [EnglishEducation],
    [Age],
    [CustomerKey],
    [EnglishOccupation],
    [Gender],
    [NumberChildrenAtHome],
    [BikeBuyer],
    [TotalChildren]
    FROM
    [dbo].[Lab02_TestSet]
    ') AS t
    ON
    [Lab03DT].[Customer Key] = t.[CustomerKey] AND
    [Lab03DT].[Marital Status] = t.[MaritalStatus] AND
    [Lab03DT].[Gender] = t.[Gender] AND
    [Lab03DT].[Yearly Income] = t.[YearlyIncome] AND
    [Lab03DT].[Total Children] = t.[TotalChildren] AND
    [Lab03DT].[Number Children At Home] = t.[NumberChildrenAtHome] AND
    [Lab03DT].[English Education] = t.[EnglishEducation] AND
    [Lab03DT].[English Occupation] = t.[EnglishOccupation] AND
    [Lab03DT].[House Owner Flag] = t.[HouseOwnerFlag] AND
    [Lab03DT].[Number Cars Owned] = t.[NumberCarsOwned] AND
    [Lab03DT].[Commute Distance] = t.[CommuteDistance] AND
    [Lab03DT].[Region] = t.[Region] AND
    [Lab03DT].[Age] = t.[Age] AND
    [Lab03DT].[Bike Buyer] = t.[BikeBuyer]
     
    Dejan Sarka, Apr 19, 2007
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.