Blog - Projects Based Learning

The roadmap for becoming a Data Engineer

Bigdata HadoopApache Cassandra, Apache Druid, Apache Flume, Apache Hadoop, Apache Hive, Apache Kafka, Apache Spark, Apache Spark Machine Learning, Bigdata, Hadoop

The roadmap for becoming a Data Engineer typically involves mastering various skills and technologies. Here's a step-by-step guide:Step 1: Learn the FundamentalsProgramming Languages: Start with proficiency in languages like Python, SQL, and possibly Scala or Java.Database Knowledge: Understand different database systems (SQL and NoSQL) and their use cases.Data Structures and Algorithms: Gain a solid understanding of fundamental data structures and algorithms.Mathematics and Statistics: Familiarize yourself with concepts like probability, statistics, and linear algebra.Step 2: Acquire Big Data TechnologiesApache Hadoop: Learn the Hadoop ecosystem tools like HDFS, MapReduce, Hive, and Pig for distributed data processing.Apache Spark: Master Spark for data processing,…

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…

Installing Apache Druid on the Local Machine

Bigdata HadoopApache Druid, Apache Hadoop, Apache Hive, Apache Kafka, Bigdata, Hadoop

Apache Druid is a real-time analytics database designed for fast slice-and-dice analytics ("OLAP" queries) on large data sets. Most often, Druid powers use cases where real-time ingestion, fast query performance, and high uptime are important.Druid is commonly used as the database backend for GUIs of analytical applications, or for highly-concurrent APIs that need fast aggregations. Druid works best with event-oriented data.Common application areas for Druid include:Clickstream analytics including web and mobile analyticsNetwork telemetry analytics including network performance monitoringServer metrics storageSupply chain analytics including manufacturing metricsApplication performance metricsDigital marketing/advertising analyticsBusiness intelligence/OLAP Prerequisites You can follow these steps on a relatively modest…

Installing Single Node Kafka Cluster

Bigdata HadoopApache Hadoop, Apache Kafka, Bigdata, Hadoop, Kafka

In this tutorial, we will set up a single-node Kafka Cluster and run it using the command line.Step 1) Let’s start getting the Kafka binary, you can download the Kafka binary from the below linkhttps://kafka.apache.org/Step 2) Click on Download button Click on the binary download to get the download started Kafka is download in the Downloaded folder Moving the Kafka download to the Kafka Directory (ie /home/dataengineer/kafka) Step 3) Unzip Kafkatar -xvzf kafka_2.12-3.6.0.tgz Step 4) START THE KAFKA ENVIRONMENTNOTE: Your local environment must have Java 8+ installed.Apache Kafka can be started using ZooKeeperKafka with ZooKeeperRun the following commands in order…

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…

Installing Apache Flume on Ubuntu

Bigdata HadoopApache Flume, Bigdata, Flume, Hadoop, Linux

System Requirements:Java Runtime Environment - Java 1.8 or laterMemory - Sufficient memory for configurations used by sources, channels or sinksDisk Space - Sufficient disk space for configurations used by channels or sinksDirectory Permissions - Read/Write permissions for directories used by agentThe first step is to create a folder Flume:Make flume directory in /home/dataengineer/mkdir flumecd flume We need to go to the website https://flume.apache.org/ and click on download. A new webpage will get open click on apache-flume-1.11.0-bin.tar.gz A new webpage will get open https://www.apache.org/dyn/closer.lua/flume/1.11.0/apache-flume-1.11.0-bin.tar.gz and copy the link shown to you. Type the below commandwget https://dlcdn.apache.org/flume/1.11.0/apache-flume-1.11.0-bin.tar.gz You will be able to…

MySQL client and Server Installation

Bigdata HadoopLinux, MySQL

Step 1: Update/Upgrade Package Repositorysudo apt updatesudo apt upgradeStep 2: Install MySQLsudo apt install mysql-serverWhen asked if you want to continue with the installation, answer Y and hit ENTER.Note: If you only want to connect to a remote MySQL server instead of hosting a database on your machine, install only the MySQL Client by running:sudo apt install mysql-client Step 3: Check if MySQL Service Is Runningsudo systemctl status mysql Step 4: Log in to MySQL Serversudo mysql -u root

Installing Apache Sqoop on Ubuntu

Bigdata HadoopApache Hadoop, Apache Sqoop, Bigdata, Hadoop

Step 1) Create a Sqoop directory by using the command mkdir sqoop so that we can download Apache Sqoop.Step 2) Download the stable version of Apache Sqoop (ie Apache Sqoop 1.4.7 in the year 2022) Website URL https://archive.apache.org/dist/sqoop/1.4.7/wget https://archive.apache.org/dist/sqoop/1.4.7/sqoop-1.4.7.bin__hadoop-2.6.0.tar.gzStep 3) Unzip the downloaded file using the tar commandtar -xvzf sqoop-1.4.7.bin__hadoop-2.6.0.tar.gzStep 4) Edit the .bashrc file by using the commandnano .bashrcStep 5) Enter the following commands below in bashrc file and save itexport SQOOP_HOME="/home/dataengineer/sqoop/sqoop-1.4.7.bin__hadoop-2.6.0"export PATH=$PATH:$SQOOP_HOME/bin Step 6) Execute the below command on the command prompt so bashrc gets activated.source ~/.bashrcStep 7) Check the installed sqoop version using the below commandsqoop version…

Vehicle Sales Report – Data Analysis

Apache Spark AnalyticsApache Spark, Apache Spark Analytics, Data Visualization, Databricks, Scala, Spark SQL

Project idea – The idea behind this project is to analysis and generate Vehicle Sales Report generation and Dive into data on popular vehicles using the following dimensions such as Total Revenue, Total Products Sold, Quarterly Revenue, Total Items Sold (By Product Line), Quarterly Revenue (By Product Line), and Overall Sales (By Product Line) Problem Statement or Business Problem Visualizes Vehicle sales data and generate a report out of it, Dive into data on the vehicle using the following dimensions:Total RevenueTotal Products SoldQuarterly RevenueTotal Items Sold (By Product Line)Quarterly Revenue (By Product Line)Overall Sales (By Product Line)Proportion of Monthly Revenue…

Video Game Sales Data Analysis

Apache Spark AnalyticsApache Spark, Apache Spark Analytics, Data Visualization, Databricks, Scala, Spark SQL

Project idea – The idea behind this project is to analysis Video Game Sales and Dive into data on popular video games using the following dimensions such as Year, Platform, Publisher and Genre Problem Statement or Business Problem Visualizes sales & platform data on video games that sold more than 100k copies.Dive into data on popular video games using the following dimensions:YearPlatformPublisherGenre Attribute Information or Dataset Details: rank: integer (nullable = true)name: string (nullable = true)platform: string (nullable = true)year: string (nullable = true)genre: string (nullable = true)publisher: string (nullable = true)na_sales: double (nullable = true)eu_sales: double (nullable = true)jp_sales:…

Tags