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
    Thanks for any help.
    Dave Smith, Apr 18, 2007
    1. Advertisements

  2. Dave Smith

    Dejan Sarka Guest

    Check this tip at Sql Server Data Mining site:
    Dejan Sarka, Apr 19, 2007
    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:

    PredictHistogram([Lab03DT].[Bike Buyer]) WHERE [Bike Buyer] = 1),
    [Lab03DT].[Bike Buyer] AS _Predicted
    OPENQUERY([Adventure Works DW],
    ') AS t
    [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
    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.