MySQL-Tableau-for-Data-Analytics-and-Business-Intelligence
collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence
- 140
- TSQL
- 2 y ago
collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence
SQL data analysis & visualization projects using MySQL, PostgreSQL, SQLite, Tableau, Apache Spark and pySpark.
AirBNB is a rental and hospitality website that is used all over the world in more than 191 countries for short-term lodging such as vacations. The company that was founded in 2008 has a lot of customers who rent the houses of the hosts who put up their houses on rent. The purpose of this project is to design and develop the database of AirBNB to dig deeper into learning how complex a hospitality
SLIIT 2nd year first semester university project using Java, servlets for an online food ordering system
Logging (reporting)humidity and temperature information in database with DHT11 sensor, visualize with web interface
A very Interactive UI for users to log onto their dashboards and sign Up if they don't have an account. Designed with the help of PyQt-5 and Qt-Designer
An API to alter the data in MySQL, Cassandra, and MongoDB databases
Database workshop in order to design and practice sql requests. Enjoy :-)
Developed CRUD functionality for User, Post, Category, and Comment APIs, ensuring data consistency. Implemented Mapping, JPA Finder Method, JPQL, Native Query, Criteria Query, Pagination and Sorting, Searching, User Input Validation, and Exception Handling for robust API responses.
This project is a real-time attendance system using facial recognition. Developed in Python, it includes a Tkinter GUI, OpenCV for face detection, and MySQL for managing employee records. It supports user registration, dataset-based training, automates manual signing, logs attendance in CSV files, and generates detailed attendance reports.