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.
  1. Push the Windows key on your keyboard
  2. Type ODBC
  3. 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
  4. Click on Add
  5. Select Server Native Client 11.0 and click Finish.
  6. Under Name, Enter LoanChargeOff. Under Server enter the MachineName from the SQL Server logins set up section. Press Next.
  7. Select SQL Server authentication and enter the credentials you created in the SQL Server set up section. Press Next
  8. Check the box for Change the default database to and enter LoanChargeOff. Press Next.
  9. Press Finish
  10. Press Test Data Source
  11. Press OK in the new popover. This will close the popover and return to the previous popovers.
  12. Now that the Data Source is tested. Press OK
  13. Finally, click OK and close the window

    14. 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.