Hi Folks, 
I am a Data Analyst & an educator by heart. I have expertise in Excel, Python, MySQL, Tableau and Power BI.

Data Source:<a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.kaggle.com/datasets/mysarahmadbhat/pizza-place-sales">https://www.kaggle.com/datasets/mysarahmadbhat/pizza-place-sales</a>BACKGROUND:The pizza place aims to leverage its business strategy by understanding more about its customers' preferences, peak hours, busiest days, best-selling pizzas, the seasonality in the sales, least selling pizza, improving staff management and building strategies to increase their revenue.METHODOLOGY:<ul><li>Data Collection</li><li>Data Cleaning &amp; organisation</li><li>Data Analysis</li><li>Conclusion</li></ul>GOALS:<ul><li>Identify Customers' preferences</li><li>Optimize menu &amp; pricing startegy</li><li>Identify Peak sales periods</li><li>Forecasting &amp; Planning</li></ul>PROJECT SCOPE:1. How many customers do they have each day? Are there any peak hours?2. How many pizzas are typically in an order? Do they have any bestsellers?3. How much money did they make this year? Can we identify any seasonality in the sales?4. Are there any pizzas they should take off the menu, or any promotions they could leverage?KPIs:•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Number of customers each day•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Number of orders in the queue at a given time•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Peak hours•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Top bestselling pizza•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Revenue generated in a year•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Seasonality in sale•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Least selling pizzaCONCEPTS USED:• SUM, AVERAGE, MULTIPLICATION, ROUNDUP, COUNTIF, Month, Hour formulas• VLOOKUP, removing delimiter, Conditional formatting, Sorting.• Pivot Tables &amp; ChartsCONCLUSION:In conclusion, the analysis of pizza sales data has shed light on several important aspects of customer behaviour, market trends, and business performance within the pizza industry. We have identified key findings by examining the data and draw insights that can guide decision-making and drive business growth.

Pizza Place Sales

Data Analytics professional at Schenider Electric having 2+ years of experience with Excel,SQL, Python,Tableau

Pharmacy Graduate | Aspiring Data Analyst

The comprehensive database contains ratings and reviews for over 15,000 movies curated by Rotten Tomatoes. Each meticulously crafted record encompasses vital film details such as title, synopsis, genre, directors, cast ensemble, release date, studio affiliation, and runtime, providing users with a holistic understanding of the cinematic work. Alongside these foundational elements, the database incorporates featured reviews from esteemed critics, offering diverse perspectives on the film's merits. The inclusion of the "Tomatometer" status further aids in gauging critical consensus, indicating whether a movie has received predominantly positive or negative reviews. Additionally, audience ratings furnish insight into public reception, enriching the viewer's decision-making process. With an expansive range of films spanning various genres and eras, this repository serves as a valuable resource for cinephiles, critics, and industry professionals alike, facilitating informed discussions and explorations within the realm of cinema. Whether seeking to discover new favorites, analyze cinematic trends, or simply indulge in the art of storytelling, this vast collection promises to captivate and enrich the cinematic journey of enthusiasts worldwide.

ROTTEN TOMATOES

UI/UX Designer × No-Code Dev 🧑🏻‍💻 | Mobile App, Web App & Websites | 🟢 Available for Work | ✉️ DM for Collab.

This case study outlines my process for designing an app that helps designers to browse &amp; read product reviews from other designers &amp; be part of the design community in the same platform.Problem StatementDesigners often have a problem in finding, reading as well as writing Product Reviews especially since there are no dedicated product review apps. Reviews from the general users are available in plenty but the need to have specific Designer reviews to make sound decisions on the product’s UI/UX updates has been missing so far.SolutionA product review app designed specifically for designers would provide a valuable resource for finding &amp; reading product reviews. The app would be easy to use &amp; would include features that are meant for product designers, such as the ability to write reviews, read reviews from others fellow designers &amp; be part of the community of Designers as a whole.This is where DesignersBox comes in. It enables the designers to write reviews for products, provide ratings based on their experiences with the UI &amp; UX of the App as well as checkout reviews from other designers all while being part of a large community of designers helping each other learn, Collab &amp; grow in their careers.Goals• Increased Productivity — Designers would be able to find the information they need more quickly &amp; easily, which would save them time.• Understand Designer’s Mindset — Product Designers will be able to understand the mindset of the designer’s reviewing the products, it’ll help the up &amp; coming designers as well as the experienced ones to make sound decisions while designing or updating their own products.• Community of Designers — Being part of a community of designers from across the globe will be able to help them to learn, grow &amp; collaborate to excel in their respective careers as Designers.

UI/UX Case Study: DesignersBox

Mobile Architect • Co-Founder & Chief Business Technology Officer at LeadIT

Hey Guys! My name is Dmitry, and this is my first experience like this, so don't insult me 😆I've done a lot of products before that failed and also made a lot of mistakes over the past 10 years. The idea for this product came to us when we had an agency where we had big ambitions and a good start, but after 6 years, we were stuck and needed help understanding why we couldn't grow more. You may assume that starting a business is more complex than many guys said, and every new day is a new challenge, so sometimes you may want help to resolve hard challenges and grow faster than your competitors. That's why having such a platform would be nice, where you can ask people who already did this how to do better.So Shortly, the Product Should Help Businesses (Entrepreneurs) and Individuals Find Experts to Grow Their Professional Skills.&nbsp;In our fantasies, we would like to grow to the top, where people from different places around the world could find Tier specialists and entrepreneurs. Like, we want to give any person a chance to talk to anybody from Google or Nvidia, etc., and ask them questions. We understand that if you want to talk with guys from Top Tier companies, this would not be free, so their time would cost some money.&nbsp;Initially, we started with small pieces to build this platform but shortly realized that to build such, there should be a lot of things communicating between each other to give users a great experience. I've brought the most challenging to build in the list:🚦 Flexible search to find and filter experts(category, sub-category, skills, language, rating, verification, and more)🗓️ The planner page is where you can see all the events that come to you or you made. This is one of the hardest features here; we did a lot of complex communications to build this page where, as a consultant, you want to see all your meetings with a calendar or list.📼 Video calls and their recording. After all the time you and the expert spend together, you may want to have a video recording to show it to your growing team department.⏱️ Book a call. Oh, this was interesting; you may think about it this way..when you are going on a call with an expert, you may want to ask him straightforward questions so both of you will understand the context and will not talk about "weather" all the time. Also, if you are an expert, you may want to have only some specific time to have a book, like every Friday from 5pm. Yeah, so we build our own internal framework to handle such complex cases, see for yourself!🚚 System where experts can flexibly create their own custom services to provide. Including but not forcing them to select for whom they want to provide a service for individuals or for businesses only. When creating a service, they can select what questions the requester needs to answer, when the expert wants to have consultations, etc. If I create a successful business owner in my career, and I may want to mentor someone, I don't have all day to do this, and definitely, I want to understand before even a call if I can help this person with his questions. &nbsp;📢 Notifications, Profile, Book Detail, etc.&nbsp;Best Regards, Dmytro.

Porada App

Data engineer @Srijan Technologies
Data engineering|Cloud computing|trekking|Video games

Data modelling is a crucial aspect of database design and development. It involves structuring and organizing data in a way that is efficient, scalable, and easy to manage. By studying different data models, you can gain insights into best practices, common patterns, and industry standards.This repository contains various data models for different industries. You can use this repository for learning purposes and to understand how to create data models.

Data Modelling template

Front-end Developer at Unios

Thu Nhap Online aims to curate all successful online products made by indie makers, bootstrappers, and solopreneurs. This is where you will find:<ul><li>The validated product ideas raking in cash for surprising niche markets</li><li>The diverse revenue model of these products</li><li>The different marketing strategies that bring them success</li></ul>All manually and carefully vetted, presented to you in a clean and minimalist interface for a clutter-free experienceP.S. Thu nhap is Vietnamese for income, so Thu Nhap Online = Online Income 😉

Thu Nhap Online

Hello there, I am a passionate User experience designer who is willing to solve interesting user's problems.

I worked on the Career Khoj app, which is transforming career exploration by guiding individuals toward the ideal career path that matches their abilities and interests. This innovative app goes beyond traditional job search platforms by providing personalized course recommendations, valuable mentorship from industry professionals, and a host of other features. Its purpose is to empower users in making informed career decisions and discovering fulfilling opportunities.

Career - Khoj

Google Meta IBM Certified UX Designer | Product Design | Branding Expert

Embark on a journey through the development of ChopLife, a groundbreaking project aimed at revolutionizing community engagement through food. From the initial stages of in-depth research and meticulous branding to the intricacies of UX research and UI design, every step of ChopLife's creation has been carefully crafted to enhance the user experience. Dive into the case study to explore how ChopLife seamlessly integrates user-friendly features and visually stunning design elements to simplify the discovery of dining experiences and promotions while celebrating local culture. Join us in celebrating the culmination of our efforts—a project that not only connects communities but also celebrates the rich tapestry of culinary experiences.

ChopLife Case study

Product Design, Psychology & Philosophy.

Heritalk : Crafting a ancient language learning app that avoids misleading progress from game playing.History fans, language lovers, and those into cultural heritage struggle to find good stuff to learn ancient languages. There’s not enough real texts, native speakers’ help, or cultural stuff for a proper deep dive.

Heritalk

Full Stack Developer | PHP + Angular + Python + AWS | Speaker | Blogger | Leadership | AWS Community Builder

This list provides a springboard for your AWS journey. As you gain confidence, you can explore more complex projects involving databases, serverless architectures, and machine learning.This is a collaborative effort, and I welcome contributions! If you have any newbie-friendly projects in mind, feel free to add them to the repository. Your contribution will empower fellow learners!

Curated AWS Project Ideas for Beginners

※ Building @framernewslettr🚀 ※ I Craft High-Converting Landing Pages ✨ ※ Official Verified @Framer Partner ※ @Framer No

Co-Learn: Find Your Perfect Study PartnerCo-Learn is a mobile application that helps users find compatible study partners. Unlike traditional methods of finding study buddies, Co-Learn goes beyond simply connecting classmates. Through its matching algorithm, Co-Learn considers factors like learning styles, academic goals, and scheduling availability to create optimal partnerships. This focus on compatibility fosters a more effective and synergistic study experience for users.

Co-Learn App UX Case-Study

Hi! I'm a product designer & former frontend dev. Into F1, chill chess and good food.
Learn 🧐 | Create 🏗 | Evolve 🌱

This project is a part of the <a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.10kdesigners.com/">10kdesigners</a> capstone project assigned by <a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="http://peerlist.io/">Peerlist</a>, with the aim of building a referral reward feature for Peerlist members who can refer a friend for a job post on the platform.In this case study, I have explained in detail my process and implementation of designing the "Hire my Peer" feature for Peerlist under the guidance of Akash Bhadange (CEO and Founder of Peerlist).The case study is divided into four sections:<ol><li>Setting up the context.</li><li>Defining the problem, persona categorization, and research.</li><li>Strategizing, finding solutions, and implementation.</li><li>Short tl;dr videos sprinkled throughout.</li></ol>This case study received more than 7k impressions across platforms and is also published in Bootcamp on Medium.

Hire my Peer

Discover detailed case studies that can provide valuable insights and inspiration for your projects.

The Best Case Study Side Projects of 2024