Skip to content

niloycste/Crypto-Currency-Analysis-Dashboard

Repository files navigation

Crypto-Currency-Analysis-Dashboard

Problem Statement: Cryptocurrency Market Analysis

The objective of this Crypto analysis is to gain valuable insights into the cryptocurrency market from this website.
I collected the data using selenium library.Anyone interested can find the code here or can also find the dataset in Kaggle from this link.

Later I utilized the scraped data to understand the following Trends and relations using Tableau Dashboard:

  1. Performance Trends: Visualize and compare the performance trends (1h, 24h, 7d, 30d) of different cryptocurrencies based on their respective Coin Names.
  2. Market Metrics Overview: Create comprehensive visualizations comparing Top Coin Names against essential metrics, including Price, 24-hour Volume, Circulating Supply, and Market Cap.
  3. Aggregate Metrics: Calculate and visualize aggregate metrics such as Total Market Cap, Total 24-hour Volume, and Total Circulating Supply across all cryptocurrencies.

You can visit the public dashboard from here.

Columns Name & Description

This crypto dataset has a total of 12 columns.

  1. Rank: The ranking of the cryptocurrency based on certain criteria (e.g., market capitalization).
  2. Coin Name: The name of the cryptocurrency.
  3. Symbol: The symbol or ticker used to represent the cryptocurrency in exchanges.
  4. Price: The current price of one unit of the cryptocurrency.
  5. 1h: The percentage change in price over the last 1 hour.
  6. 24h: The percentage change in price over the last 24 hours.
  7. 7d: The percentage change in price over the last 7 days.
  8. 30d: The percentage change in price over the last 30 days.
  9. 24h Volume: The trading volume of the cryptocurrency over the last 24 hours.
  10. Circulating Supply: The amount of the cryptocurrency that is currently in circulation.
  11. Total Supply: The total amount of the cryptocurrency that can ever exist.
  12. Market Cap: The market capitalization of the cryptocurrency, calculated by multiplying the current price by the circulating supply.

Expected Insights from the Dashboard.

  1. Identification of top-performing cryptocurrencies based on various metrics like Top 10 crypto base don price, highest trading over last 24 hours, top crypto based on circulating supply, and total market cap.
Top 10 Crypto by Price 24-Hour Volume
Supply Market Cap
  1. Exploration of trends and patterns in the cryptocurrency market over different time intervals.

1 Hour 24 Hours

7 Days 30 Days

  1. Understanding the aggregated market metrics to assess the overall health of the cryptocurrency market like total current price, total 24-hour volume, total circulating supply, and total market cap.


There are two dashboards so click the button to go to the next dashboard and vice versa.


Build From Sources & Selenium Scraper

  1. Clone the repo
git clone https://github.com/niloycste/Crypto-Currency-Analysis-Dashboard.git
  1. Initialize and Activate Virtual Environment
virtualenv env
source env/Scripts/activate
  1. Install Dependencies
pip install -r requirements.txt
  1. Download the Firefox web driver
https://github.com/mozilla/geckodriver/releases
  1. Run the Scrapper
python coingeckoupdated.py
  1. anyone can get a file name "CryptocurrencyData.csv" containing all the desired columns

Analytics

Tableau Public View: https://public.tableau.com/app/profile/niloy/viz/Crypto-CurrencyAnalysisDashboard/OverallAnalysisOfCrypto