Chance Insight – Data Analytics

Tag: data

  • SQL Code for Lifetime Value Model

    SQL Code for Lifetime Value Model

    —

    by

    CB
    in ,

    The first part of building the code to pull the data for the lifetime value model is to create an SQL script that will get the historical data we need to train our model on. The SQL Code select 6 fields from the Contoso Retail Datawarehouse:The full SQL code is at the bottom of the…

  • Building an Survey Results Report with Power BI

    Building an Survey Results Report with Power BI

    —

    by

    CB
    in

    Power BI can be useful for displaying and storing survey results for your organization. In this example we build some data for the results of a fictitious Airline survey, using questions taken from a real online airport survey. The data was built in Excel with a sheet for questions and a sheet for answers. You…