🚀 Main Project: Social Media Analytics Platform
System Overview
This is a complete data pipeline simulating a real social media platform. The JavaScript web application serves as the core interface, providing access to both the Oracle APEX post creation system and the Power BI analytics dashboard. Data is stored and managed via REST APIs and analyzed using Power BI.
Architecture
- Frontend: JavaScript web app
- Backend: Oracle APEX + REST API
- Database: Oracle SQL
- Analytics: Power BI
Core Features
- User posts, likes, comments, followers
- Real-time-style data integration
- Engagement tracking
- Trend analysis
- KPI dashboards
- Behavioral insights
Power BI Dashboard
GitHub Repositories
🧠 Subsystems
Backend: Oracle APEX + REST API
Built a relational schema for a social media platform including users, posts, interactions, and messaging. Oracle APEX is used for administration and REST services expose the data.
- Normalized schema
- CRUD operations
- Session handling
- REST endpoints
- Data validation
Frontend: JavaScript Web App
A custom interface that allows users to create posts dynamically. This simulates real-world activity and feeds the analytics system.
- Post creation
- API integration
- Live data testing
- Form handling
Analytics: Power BI
Interactive dashboards designed to explore engagement, growth, and content performance.
- User growth
- Engagement KPIs
- Post performance
- Time-series analysis
- Dynamic filtering
📬 Contact
Email: flavius.andrei205@gmail.com
LinkedIn: View Profile