Cloud-Integrated Database and Visualization

Explanation of an ongoing project.

Sales Data Analysis and Visualization Project

Description:
This project demonstrates my ability to work with cloud-based database systems and create actionable insights using modern data visualization tools. The project uses snowflake as the database platform, Power BI for creating interactive dashboards, and is hosted on Microsoft Azure to simulate real-world cloud architecture. (Idea of this project is to learn cloud computing).

  1. Database Integration:

    • Loaded a sample sales dataset into Snowflake for efficient storage and querying.

    • Used SQL to clean, transform, and analyze the data.

  2. Visualization:

    • Created interactive dashboards in Power BI to visualize sales trends, customer segmentation, and product performance.

    • Integrated real-time data refresh for up-to-date analytics.

  3. Cloud Deployment:

    • Deployed the Snowflake database on Microsoft Azure, showcasing familiarity with cloud solutions.

    • Configured Power BI to connect securely to Snowflake through Azure.

Tools & Technologies Used:

  • Snowflake: Cloud database for efficient data storage and querying.

  • Power BI: For creating dynamic and user-friendly dashboards.

  • Microsoft Azure: To simulate real-world cloud deployment scenarios.