Cryptocurrency Analysis

Project Report: Cryptocurrency Analysis Using Power BI

Company Theme: Yellow and Black

Overview

This project report details the design and implementation of a cryptocurrency analysis dashboard using Power BI. The dashboard is themed with the company colors, yellow and black, and consists of two pages providing a comprehensive analysis of cryptocurrency market metrics.

Page 1: Market Overview

Components:

• Market Cap by Date Line Chart
• KPI Cards:
  • High
  • Low
  • Market Cap
  • Volume
• Slicers:
  • Date Range
  • Currency
  • Analysis Granularity (Year, Month, Quarterly, Weekly, Daily)

Design Details:

• Market Cap by Date Line Chart: A line chart plotting the market capitalization of selected cryptocurrencies over time. The X-axis represents the date, and the Y-axis represents the market cap.
• KPI Cards:
  • High: Displays the highest price recorded for the selected date range and currency.
  • Low: Displays the lowest price recorded for the selected date range and currency.
  • Market Cap: Shows the total market capitalization for the selected date range and currency.
  • Volume: Shows the trading volume for the selected date range and currency.
• Slicers:
  • Date Range: Allows users to filter the data by a specific date range.
  • Currency: Enables selection of one or more cryptocurrencies.
  • Analysis Granularity: Provides options to view data by year, month, quarter, week, or day for more detailed analysis.

Page 2: Detailed Metrics

Components:

• High, Low & Average by Date Line Chart
• Open & Close by Date Line Chart
• Slicers (Inherited from Page 1):
  • Currency
  • Date Range
• Total Market Cap Bar Chart for Top 5 Currencies
• All-Time High and Low Cards

Conclusion

This Power BI dashboard provides a comprehensive and interactive way to analyze cryptocurrency market data. By utilizing various visualizations and slicers, users can gain insights into market trends, price movements, and overall market performance across different time frames. The use of company colors ensures that the dashboard aligns with the corporate branding, providing a professional and cohesive look.

Screenshots (Placeholder)

📫 Connect

• Email: lutfulkabir1757@gmail.com
• LinkedIn: Md. Lutful Kabir
• Portfolio: Md. Lutful Kabir