CKAN’s Post

🚀 Excited to share my latest project: A comprehensive Library Management System! 📚 I am thrilled to announce the completion of my comprehensive Library Management System, designed to streamline and enhance the efficiency of library operations. This project involved creating a robust database using SQL, covering all essential aspects of library management. Here's an overview of the database structure: 📚 Database Creation: - Database Name: lib_mngmt_system 🔖 Tables Created: 1. tbl_category: Stores book categories. 2. tbl_publisher: Stores publisher details including language and type. 3. tbl_location: Stores the location details within the library. 4. tbl_author: Stores author information. 5. tbl_book: Stores book details, linking to categories, publishers, and locations. 6. tbl_book_author: Stores the relationship between books and authors. 7. tbl_member_status: Tracks member status and membership dates. 8. tbl_member: Stores member information and links to member status. 9. tbl_library_staff: Stores library staff details. 10. tbl_book_issue: Tracks book issuance details. 11. tbl_fine_due: Tracks fines due from members. 12. tbl_fine_payment: Tracks fine payments. 13. tbl_book_request_status: Tracks the availability status of book requests. 14. tbl_book_request: Tracks book requests made by members. 🔍 Key Queries Implemented: - Display member details, filter by inactive status or account type. - Display members with due fines. - Count active and inactive memberships. - Calculate the total number of books and available copies. - Categorize book counts and total engineering & technology books. - Search for specific books and check availability. - Issue and return book functionalities. - Show fine details for specific members. 📊 Sample Data Inserted: - Authors, categories, publishers, locations, books, members, staff, and more to demonstrate the functionality. This system aims to facilitate seamless library management, making it easier to handle book inventories, member accounts, book issues, returns, and fines. Github Link: https://lnkd.in/gFmkmAcq #SQL #LibraryManagementSystem #DatabaseDesign #ProjectShowcase #TechInnovation #SQLQueries #DatabaseDevelopment Day 9/10

I'm excited to share the outcomes of my most recent project, which involved a deep dive into a substantial dataset comprising 54,808 rows and 154 columns. This is the HR datasets around 5% of its employees have promoted in the company. so, we have the check employee is promoted or not? 🌐 Explore the full project and detailed analysis: GitHub Repository: https://lnkd.in/gbNyQpZ9 kaggle link: https://lnkd.in/dFKTgm2p #dataanalysis #dataanalytics #pythonfordatascience #analytics #kaggle #datacleaning #dailycoding #codechallenge #dataanalyticsjourney

🚀 Exciting News: Completed Data Cleaning Project in SQL! 🚀 Hey LinkedIn connections! 👋 I'm thrilled to share that I've successfully wrapped up a comprehensive data cleaning project in the "NashvilleHousing" dataset using SQL. 📊💻 The objective was to refine and enhance the dataset for more robust analysis. 🛠️ I applied various data cleaning techniques to ensure accuracy, consistency, and reliability in the data, making it a solid foundation for any analytical endeavor. 📈 If you're curious about the details or looking to upskill in data cleaning, I encourage you to check out my project. It's a great resource to learn practical applications of SQL in real-world scenarios. 🎓💡 I'm open to questions, discussions, and feedback! Feel free to drop a comment or send me a message. Let's collaborate and learn from each other. 🤝🔍 You can find the dataset and explore the full project here: https://lnkd.in/dk_i7USA #DataCleaning #SQL #DataAnalysis #NashvilleHousing #DataScience

🚀 Excited to Share: Introducing "Talk to Database Advance" 🚀 👋 Hey LinkedIn Fam, I'm thrilled to share my latest project with you all! 🌟 Ever wanted to interact with a database without diving into complex query languages like SQL? Well, now you can, thanks to "Talk to Database Advance"! 🌐 Dive In: Curious to explore? Feel free to check out the live application here: - https://lnkd.in/g97DuPUp 🔗 GitHub Repository: https://lnkd.in/g5Nm9WcR 🎉 What's New? Create Your Own Database: Now, you have the power to craft your own database tailored to your needs. No more limitations, just pure customization! Seamless Communication: Communicate directly with your database hassle-free. No SQL knowledge required. Just interact with the intuitive user interface and let the magic happen. Obtained Answers Display: Easily visualize the responses obtained from your database in a user-friendly interface. It's all about making data interaction effortless and enjoyable. 🚀 Let's Connect: I'm super excited about the potential of "Talk to Database Advance" and would love to hear your thoughts! Connect with me on LinkedIn, and let's geek out over data-driven innovations together. Keep innovating, keep exploring! 💡✨ #TalkToDatabase #NoSQLNoProblem #DataManagement #DatabaseInnovation

🚀 𝐏𝐲𝐒𝐩𝐚𝐫𝐤 𝐀𝐝𝐯𝐞𝐧𝐭𝐮𝐫𝐞𝐬: 8-𝐖𝐞𝐞𝐤 𝐒𝐐𝐋 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞 – 𝐂𝐚𝐬𝐞 𝐒𝐭𝐮𝐝𝐲 #3: 𝐅𝐨𝐨𝐝𝐢𝐞-𝐅𝐢 #𝐖𝐞𝐞𝐤3🍕🍔🍜 🚀 Excited to share my latest #PySpark solution to 𝐃𝐚𝐧𝐧𝐲 𝐌𝐚'𝐬 #8𝐖𝐞𝐞𝐤𝐒𝐐𝐋𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞, diving into the world of 𝐅𝐨𝐨𝐝𝐢𝐞-𝐅𝐢! 🎉 (https://lnkd.in/gw4FnCp5) In this case study, I took my PySpark skills up a notch by incorporating new functions like 𝐥𝐚𝐠() and 𝐥𝐞𝐚𝐝(). These powerful window functions helped me analyze customer subscription changes over time 📈, offering insights into user behavior patterns and churn rates 🔄. Key highlights of this challenge: 🧑💻 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐓𝐢𝐦𝐞-𝐛𝐚𝐬𝐞𝐝 𝐂𝐚𝐥𝐜𝐮𝐥𝐚𝐭𝐢𝐨𝐧𝐬 with PySpark (lag(), lead()) 💡 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐨𝐧 𝐋𝐢𝐟𝐞𝐜𝐲𝐜𝐥𝐞 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 for users (monthly to annual subscriptions) ⚡ 𝐄𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐭 𝐃𝐚𝐭𝐚𝐅𝐫𝐚𝐦𝐞 𝐎𝐩𝐞𝐫𝐚𝐭𝐢𝐨𝐧𝐬 to handle large datasets seamlessly 🛠️ 𝐂𝐡𝐞𝐜𝐤𝐩𝐨𝐢𝐧𝐭𝐢𝐧𝐠 for optimized job performance I'm thrilled with how much I've learned so far, and this case study definitely stretched my skills with data manipulation and handling time-series data ⏳. 📊 You can check out my full solution here: 1. https://lnkd.in/guJ6HzCc 2. https://lnkd.in/gbEqPss3 Let’s connect if you’re also into 𝐏𝐲𝐒𝐩𝐚𝐫𝐤, 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠, or working on real-world data challenges! Always happy to exchange insights! 💬 #PySpark #SQL #DataEngineering #FoodieFi #LearningByDoing #AdvancedSQL #WindowFunctions

The Incubator Hub is doing wonders, i learnt how to build my portfolio today using #Github and it was awesome. i realised there is a lot to know and learn. Temidayo TeeDee AYENI put us through github. i created a #repository and made my #readme file active for editing. so now i can: #create repositories #make headings to level 4 #link up a url on my portfolio #create table using pipelines - that was fascinating when i saw the preview #upload pictures and include it in my portfolio #to design an outline for my headings, so wow use this link to check up my work https://lnkd.in/dZfQriP9. thanks to Femi Ayodele (MCT) Muhsin H. Oketoyan EstherEdward Oketoyan (PMP, R.COREN) #portfolio_building #github #data_analysis #data_analyst #data_engineers #LITA

I did some challenging SQL project here is my experience and what have learnt. Project Experience and Sales Insights Working on this project has been both challenging and enlightening, especially regarding the sales side of things. Here are some key takeaways from my experience Mastering Key SQL Concepts One of the biggest technical achievements was getting comfortable with SQL fundamentals and more complex clauses, like GROUP BY, HAVING, and ORDER BY. I initially found these concepts challenging but soon realized how vital they are for making sense of large datasets. Now, I can use these SQL functions confidently, which opens doors to more efficient and nuanced data analysis. Project Reflection: Working on this project has been an incredible journey of growth, skill development, and collaboration. These projects can be accessed on my Github account through the link below https://lnkd.in/gNHwx2_p.

Excited to share my recent project, "HouseHub" - a comprehensive real estate management platform! 🏠 As part of my Master's program, I developed HouseHub to streamline the home-buying process for customers and agents alike. Here's a snapshot of what this project entails: 📊 Database Design and Implementation: Created a robust database schema using MySQL. Implemented essential tables: Customer, Agent, AgentAvailability, House, 3D-Tour, and CustomerReviews. Populated the database with realistic dummy data for customers, agents, agent availability, houses, tours, and customer reviews.  Key SQL Queries: Extracted valuable insights using various SQL queries, helping in making informed decisions. Tech Stack: MySQL for database management. SQL for data querying and manipulation. This project significantly enhanced my understanding of database management and my ability to create efficient, real-world applications, boosting my confidence with MySQL. Special thanks to Professor Kui Du for their constant support and guidance throughout this journey. Your mentorship has been invaluable! Feel free to check out the project on GitHub: GitHub Link #RealEstate #DatabaseManagement #SQL #MySQL #MastersProject #HouseHub #GitHub

🚀 Thrilled to unveil our latest project: Bash Shell Script DBMS 📊 Adham Ayman and I have worked together to develop a command-line interface (CLI) based app that empowers users to efficiently store and retrieve data from their hard disks. 🖥️ Key Features: 🔍 CLI Menu for user-friendly navigation ✨ Main Menu options: Create, List, Connect, and Drop Databases 💽 Submenu for specific database operations: Create, List, Drop Tables, and more This project not only enhances data management but also provides a seamless user experience. 💡 What it offers: 📂 Create Database: Set up your data repository 📋 List Databases: Easily track your databases 🔗 Connect to Databases: Seamless transition to specific databases ❌ Drop Database: Efficient database removal And, when connected to a specific database: 🗄️ Create/List/Drop Table: Manage your tables effortlessly 📥 Insert/Select/Delete/Update Table: Fine-tune your data operations Big shoutout to @AdhamAyman for the fantastic collaboration! Excited about the potential applications and looking forward to your thoughts! Feel free to reach out for more details or a demo. 👩💻👨💻 #DatabaseManagement #ShellScripting #TechInnovation #CLIApp #DataManagement https://lnkd.in/dwnjuxK2

🚀 Project Completed: Investment Analysis Dashboard! 📊 I'm excited to announce the completion of our investment analysis project at Cognifyz Technologies! We developed an interactive Power BI dashboard to gain insights into investment behaviors and preferences. Highlights: Data Exploration: Key stats like average age and investment percentages. Gender Analysis: Trends in investment choices by gender. Objective Analysis: Correlation between savings goals and investment avenues. Duration & Frequency: Impact of investment durations and monitoring frequencies. Reasons for Investment: Top reasons like better returns and tax benefits. Information Sources: Preferred sources for investment information. Our dashboard provides actionable insights for smarter investment decisions. Huge thanks to the team for their hard work! 🙌 Reach out if you want to know more! Github Link : https://lnkd.in/gkNua5-W #DataScience #InvestmentAnalysis #PowerBI #DataVisualization #Cognifyz #Cognifyztechnologies #ProjectCompletion