Raja

Project Name: Creation of Scalable Pipeline for Power BI visualizations using Azure Data Factory and Snowflake

 Designed and built a scalable pipeline utilizing Azure Data Factory and Snowflake.

 Identified and integrated multiple data sources, including CSV files from disparate sources.

 Uploaded the required files to an Azure storage account and created an Azure Data Factory pipeline to retrieve the data and load it into Snowflake.

 Set up connections to both the storage account and Snowflake, and defined transformation logic to format the data correctly using Data Flow.

 Established a connection between Snowflake and Power BI and created several reports and dashboards based on the data.

 Used various Power BI features to create interactive visualizations that could be used for business insights and decision-making.

 Faced challenges related to data quality, transformation logic, and pipeline performance and leveraged various Azure Data Factory and Snowflake features to optimize the pipeline's performance and ensure data accuracy.

 Developed skills in data pipeline creation using Azure Data Factory and Snowflake, as well as data visualization using Power BI. Project Name: Sales Product Analysis Dashboard

 Gathered and integrated sales data from various sources, including transactional databases and CSV files, ensuring data quality and consistency.

 Designed a robust data model in Power BI, establishing meaningful relationships between different tables to facilitate comprehensive analysis.

 Created visually appealing dashboards and reports to present key performance indicators (KPIs) and sales insights.

 Utilized DAX calculations to analyze total sales, revenue, and profit trends over time, providing valuable insights for sales strategies.

 Conducted product-level analysis to evaluate the performance of individual products, identifying top-selling and underperforming items. Developed customer segmentation based on purchase behavior and demographics, leading to targeted marketing efforts.

 Implemented interactive features such as slicers, filters, and drill-through functionality to enhance dashboard interactivity.

 Optimized dashboard performance to ensure fast load times and responsiveness.

 Configured automatic data refresh schedules to keep the dashboard up-to-date with the latest sales data.

 Collaborated with cross-functional teams, including business analysts and stakeholders, to understand requirements and deliver effective solutions