FinancialNews_Project

Financial News ETL & AI Dashboard Project

Overview

This project is an end-to-end Financial News Data Engineering and Analytics solution built using:

• SSIS (SQL Server Integration Services)
• Medallion Architecture (Bronze, Silver, Gold)
• Power BI
• AI-powered Dashboard Generation
• Git & GitHub

The project collects, processes, transforms, and structures financial news data into multiple refined layers for analytics and AI-driven dashboard creation.

---

Project Architecture

Raw Data
   ↓
Bronze Layer
   ↓
Silver Layer
   ↓
Gold Layer
   ↓
AI Dashboard Generator
   ↓
Power BI Dashboard

---

Repository Structure

FinancialNews_Project/
│
├── ETL/
│   └── FinancialNews_ETL/
│       ├── FinancialNews_ETL.sln
│       ├── SSIS Packages
│       └── ETL Components
│
├── Reporting/
│   ├── Financial_news_dashboard.pbix
│   ├── financial_news_events.csv
│   ├── financial_news_events.json
│   ├── financial_news_events.xlsx
│   ├── news data.csv
│   └── news data.xlsx
│
├── Data/
│   ├── Bronze/
│   ├── Silver/
│   └── Gold/
│
├── Screenshots/
│
├── README.md
└── .gitignore

---

Medallion Architecture

Bronze Layer

Stores raw ingested financial news data directly from source systems.

Silver Layer

Performs:

• Data cleaning
• Transformation
• Standardization
• Validation

Gold Layer

Contains:

• Aggregated datasets
• Business-ready analytics data
• Dashboard-ready datasets

---

Technologies Used

Technology	Purpose
SSIS	ETL Pipeline Development
SQL Server	Data Storage
Power BI	Dashboard & Reporting
GitHub	Version Control
Python / AI	Dashboard Automation
CSV / JSON / Excel	Source Data Formats

---

AI Dashboard Generator

This project also integrates with an AI-powered dashboard generation system.

Related AI Project

Paste your AI project link below:

AI Dashboard Generator

Example:

[AI Dashboard Generator](https://github.com/hellypatell/AI-Financial-Data-Engineer-Chat)

The AI system automatically:

• Analyzes processed financial news data
• Generates dashboards
• Creates visual insights
• Automates analytics workflows

---

Power BI Dashboard

The repository includes a Power BI dashboard:

Reporting/Financial_news_dashboard.pbix

The dashboard provides:

• Financial trend analysis
• Event-based insights
• News analytics
• KPI monitoring

---

Features

• End-to-end ETL pipeline
• Medallion architecture implementation
• AI-based dashboard generation
• Power BI analytics dashboard
• Multi-format data ingestion
• GitHub version control
• Scalable project structure

---

Future Improvements

• Real-time data ingestion
• Azure Data Factory integration
• Snowflake/Data Warehouse support
• ML-based sentiment analysis
• Automated deployment pipelines
• Live streaming dashboards

---

Screenshots

Add dashboard screenshots inside:

Screenshots/

Example:

![Dashboard](Screenshots/dashboard.png)

---

How to Run

Clone Repository

git clone https://github.com/hellypatell/FinancialNews_Project.git

Open SSIS Solution

Open:

ETL/FinancialNews_ETL.sln

using Visual Studio with SSIS extension installed.

Open Power BI Dashboard

Open:

Reporting/Financial_news_dashboard.pbix

using Power BI Desktop.

---

Author

Helly Patel

GitHub: https://github.com/hellypatell

---

License

This project is for educational and portfolio purposes.