SQL

Installing Metabase on Windows using Docker

UncategorizedData Analysis, Data Visualization, Docker, Metabase, SQL, Windows

In this tutorial, we will set up a Metabase and run it using Docker.Install Docker Desktop: If you haven't already, download and install Docker Desktop for Windows from the Docker website (https://www.docker.com/products/docker-desktop). Enable Docker: Ensure that Docker Desktop is running and properly configured on your Windows system. (Docker Desktop is an .exe file similar to other windows installs) 3. Pull the Metabase Docker Image: Pull the Metabase Docker image from Docker Hub https://youtu.be/sBYEa_6_lbA4. Create a Docker Container: Once the image is downloaded, create a Docker container5. Access Metabase: Once the container is running, you can access Metabase by opening a web browser and…

Data Analysis using SQL

UncategorizedData Analysis, SQL, SQLite

Agenda This script will serve as an introduction to advanced data analysis utilizing the SQL language, which should be a necessary tool for every data scientist, data engineer, and machine learning engineer to gain access to data. The idea underlying SQL is fairly similar to that of any other language or tool used for data analysis (excel, Pandas), thus it should be very intuitive for individuals who have experience working with data. Loading Data into https://sqliteonline.com/ Open Website in Browser Click on File and select on Open DB Select the file database.sqlite which is downloaded from the download section and…