Tools for data science and analytics installation process.

Introduction.

Before we begin with the tools we need to ask the bigger question who is a data analyst and a data scientist. First, Data analyst; they beg to answer the question WHAT HAPPENED. Second, Data Scientist; they beg to answer the question PREDICTION AND PRESCRIPTION. In the current world data is flowing all over us day by day hence.

How to install MYSQL and PostgreSQL.

Introduction.

MYSQL is just but an open-source database. It is a relational database system where one can manage, store and extract data that is structured. PostgreSQL is an advanced database system that is used for large and high performance applications which stores data.

Steps for Installation.

Step 1: Downloading MYSQL.

1. Go to your web browser and search https://www.mysql.com/downloads/
2. Click on download now and download according to your laptop operating system.

Step 2: Installation of MYSQL.

1. Open the downloaded file.
2. Once opened choose "my server only".
3. Set the port number to default.
4. Create a root password then finish the configuration.

Postgre.

Step 1: Download PostgreSql.

1. Go to your browser https://www.postgresql.org/download/
2. Choose your Operating system.
3. After downloading open it then choose components for installation then click on next to continue.

Step 2: Configuration of PostgreSQL.

1. One will be asked to configure some essential settings which are:
2. You will be required to set a password.
3. You will be asked to input aport number leave it at default which is '5432'.
4. Leave the installation at locale default settings then finish installation.

Installation of Excel and PowerBi.

Excel.

Step 1: Installation.

1. Go to Microsoft store on windows and look for excel then download it.
2. After finishing the download open it and ensure it is working properly.

PowerBi.

Step 1: Installation.

1. Go to Microsoft store on windows and look for PowerBi then download it.
2. After the download is over open it and ensure it is working properly.

What about for other users that is MacBook and Linux.

One can use a Virtual machine to access this tools.

### Step 1: VirtualBox.

1. Install VirtualBox and select for MacBook or Linux.
2. Follow the installation instructions and the VirtualBox will be fully installed into your machine.
3. Download windows ISO file and save in you laptop.

Step 2: Create a virtual machine.

1. Open the virtualbox and then click on new.
2. You will be required to fill;
3. Name of the virtual machine.
4. The Type.
5. Version of the windows.

Step 3: Allocate virtual machine some memory.

1. Choose how much RAM to give the virtual machine.

Step 4: Create the hard disk of the VM.

1. Click on create a virtual hard disk now then click next.
2. Choose Virtualbox Disk image.
3. Choose the dynamically allocated then set size to 50GB.

Step 5: Install windows.

1. Select the virtualmachine you created then click on start.
2. You shall be prompted then select the windows ISO file that we downloaded and folow the normal windows installation steps. 3.The windows will open inside the virtual machine.

Step 6: Installation Excell and PowerBI.

1. Inside the windowss viryual machine go to Microssoft Store and download both PowerBI and excel.

Step 7:Launch the application.

1. Inside the Windows virtual machine you can now open;
2. PoweBI.
3. Excel.