Predicting Hospital Length of Stay

Implemented with Microsoft Machine Learning Services

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

You are now ready to use this connection in PowerBI by following the instructions here.