JDS Academy - Setting up the environment

JDS Academy - Installing environment and required softwares

Intro

1 Why Python, R, SQL and bash?

2. Create a Data Server!

2.1 What is a data server?

2.2 Get the Data Server!
2.3 Log in to your data server (for Mac / Windows / Linux users)

3. Install Python, R, SQL and bash!

3.1 Install bash - and create a new user!
3.2 Install Python 3 and Jupyter Notebook!
3.3 Install postgreSQL!
3.4 Install pgadmin4!
3.5 Install R and RStudio!

Troubleshoot - SQL
Troubleshoot - Python & Jupyter

4. Extra functionalities

4.1 Installing Python libraries: Pandas, NumPy, MatPlotLib and Scikit-Learn
4.2 Installing csvkit for bash
4.3 Installing SQL Workbench for Postgresql

5. Wrap up!

Tools - eszközök

Szoftverek, eszközök, amiket használni szoktam Data Science / Data Analysis hobbi projektjeimhez.

Softwares, tools which I use during my hobby projects.

Alap, azaz megkerülhetetlen / basic, thus inevitable

• ETL: bash (on Ubuntu Linux), Python 3.x, Microsoft (MS) Excel, NotePad++
• Data storage and queries: SQL  -> PostgreSQL (+ Workbench), MySQL (server) + bash + Python
• presentation: Google Sheets, Google Data Studio and Google Analytics, MS Office (O365/desktop; Excel, PowerPoint), Libre Office  

Magasabb színvonalhoz / for higher quality

• data analysis and visualisation: Google Data Studio, Tableau, PowerBI
• Python -> Matplotlib, Keras, Pandas,
  Jupyter notebook
• Machine/Deep Learning: Python (Pandas, Keras, SKLearn)

Más / Others

• web: HTML 5, CSS, PHP
• scientific analysis: Microcal Origin
• image editors: Paint.Net, GIMP, basic Photoshop
• image analysis: Matlab
• data acquisition / hardware control: National Instruments Labview, Matlab, Python