Skip to content

python for business intelligence.md

Latest commit

 

History

History
51 lines (36 loc) · 2.97 KB

python for business intelligence.md

File metadata and controls

51 lines (36 loc) · 2.97 KB

Starter Kit and Resources for Python and VS Code

Python

Download and install the latest Python vesrion.

Important

During installation, add python to your environmental variables. That means that you have to check the box saying ADD TO PATH on the first screen during the installation

Note

If prompted select to additionally install pip.

Caution

We do not recommend using other python distributions (e.g. anaconda).

Next

  1. Verify that python is installed.
    • Open a command prompt and type the command for launching a python interpreter. Depending on the OS and python's version this can either be python, python3, py or py3.
    • If none work, you need to add python to your environmental variables manually. To do this, find the interpreter in the installation directory and add it as an environmental variable.
    • From now on we'll consider that python is installed and works with the command python. If this differs in your PC, use your own instead of python from now on.
  2. Verify that pip is installed.
    • Pip is a package manager for Python.
    • Open a command prompt and type the command pip.
    • If it doesn't exist type python -m pip. If this works, you can add pip to your environmental variables (look above on how to do this). `
    • If pip isn't installed, download the installer from here and run it as a python scripy: python get-pip.py.
  3. Packages required during this course can be installed using the pip package manager. Either pip install package-name or python -m pip install package-name. Any package that is required will be pointed out and installed in class.

Code editor

Feel free to use any IDE you like. However, VS Code is the recommended IDE since it is light-weight, has a ton of extensions/plugins, and it is an industry standard.

Other tools

  1. Git, download and install Git Version Control

Accounts

Create a Github account

Optional software

You will optionally need the MS-SQL Server database (RDBMS), the MS-SQL Server management interface and the Power BI desktop application. In detail you have to download:

  1. Latest Version of SQL Server Developer

    • Download the Developer edition (SQL20XX-SSEI-Dev.exe)
    • Execute the SQL20XX-SSEI-Dev.exe and perform a default installation.

  2. Latest version of SQL Server Management Studio

    • Download and install the SSMS-Setup-ENU.exe file.

  3. Latest version of Power BI