Excel Analytics Platform

A comprehensive finance management platform with AR, AI, and blockchain features. This platform allows users to analyze Excel data with advanced visualization, AI-powered insights, and blockchain integration.

Features

• Excel file upload and parsing
• Advanced data visualization with 3D charts
• AI-powered data analysis
• Blockchain integration for data verification
• Social login integration (Google, Facebook)
• PDF report generation
• Responsive web interface

Project Structure

├── Frontend/           # React TypeScript frontend
├── server/            # Express.js backend server
├── src/               # Core application logic
└── app.py            # Python utilities

Prerequisites

• Node.js >= 14.0.0
• Python >= 3.8
• MongoDB (for database)

Installation

1. Clone the repository

git clone <repository-url>
cd excel-analytics-platform

2. Install Frontend dependencies

cd Frontend
npm install

3. Install Server dependencies

cd ../server
npm install

4. Install Python dependencies

pip install -r requirements.txt

5. Set up environment variables

• Create .env files in both Frontend and server directories
• Add necessary environment variables (see Environment Variables section)

Environment Variables

Frontend (.env)

REACT_APP_API_URL=http://localhost:5000
REACT_APP_GOOGLE_CLIENT_ID=your_google_client_id
REACT_APP_FACEBOOK_APP_ID=your_facebook_app_id

Server (.env)

PORT=5000
MONGODB_URI=your_mongodb_connection_string
JWT_SECRET=your_jwt_secret

Running the Application

1. Start the frontend development server

cd Frontend
npm start

2. Start the backend server

cd server
npm run dev

Contributing

1. Fork the repository
2. Create your feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

License

This project is licensed under the MIT License - see the LICENSE file for details.