Loan ChargeOff Prediction

Set up Connection between SQL Server and PowerBI

Follow the instructions below to set up a connection between your SQL Server database and PowerBI. Perform these steps after you have created the LoanChargeOff database.
Follow the instructions below to set up a connection between your Hive table and PowerBI. Perform these steps after you have created the loanchargeoff_predictions table by executiong the LoanChargeOff_main.R and LoanChargeOff_scoring scripts.
  1. Download and install the Spark ODBC driver. If you already have this driver, make sure it version 1.2.4.1005 or greater.
  2. Push the Windows key on your keyboard
  3. Type ODBC
  4. Open the correct app depending on what type of computer you are using (64 bit or 32 bit). To find out if your computer is running 32-bit or 64-bit Windows, do the following:
    • Open System by clicking the Start button, clicking Control Panel, clicking System and Maintenance, and then clicking System.
    • . Under System, you can view the system type
  5. Click on Add
  6. Select Server Native Client 11.0 and click Finish.
  7. Select Microsoft Spark ODBC Driver and click Finish
  8. Under Name, Enter LoanChargeOff. Under Server enter the MachineName from the SQL Server logins set up section. Press Next.
  9. Under Name, Enter LoanChargeOff. Add the Host name (of the form myclustername.azurehdinsight.net). For username and password enter the values you chose when you created the cluster.
  10. Select SQL Server authentication and enter the credentials you created in the SQL Server set up section. Press Next
  11. Check the box for Change the default database to and enter LoanChargeOff. Press Next.
  12. Press Finish
  13. Press Test Data Source
  14. Press Test.
  15. Press OK in the new popover. This will close the popover and return to the previous popovers.

  16. Now that the Data Source is tested. Press OK
  17. Finally, click OK and close the window

    18. You are now ready to use this connection in PowerBI

    Download the LoanChargeOffPredictionDashboardHDI.pbix and open it on your desktop

    Click on Get Data and choose ODBC connection and use the above connection.