KanTime Inc.’s Post

👏 Hello everyone,I'm excited to showcase my latest project : 📊 AtliQ Mart Promotion Analysis 📊 given by Codebasics as resume project challenge ! 📍 Domain: FMCG 📍 Function: Sales/ Promotion 📋 Problem Statement : AtliQ Mart, a retail giant in southern India, operates over 50 supermarkets. During Diwali 2024 and Sankaranti 2024, AtliQ Mart ran promotional campaigns for its AtliQ branded products. The purpose of these promotions was to gauge their effectiveness and inform decisions for future promotional periods. Evaluation is needed to determine which promotions performed well and which ones did not meet expectations. Analyzing the outcomes will enable AtliQ Mart to make informed decisions for upcoming promotional activities. 🛠 Tools used : 1) MySQL : for AD-HOC Request 2) Power-BI : for Visualization and dashboard 3) MS PowerPoint : for Presentation 💻 important Link : Github : https://lnkd.in/dUXEFjfq Special thanks 🙏 to Dhaval Patel Sir, Hemanand Vadivel Sir and Codebasics team for providing this amazing opportunity to showcase my data analytic skills. 😀 Please feel free to share your feedback and suggestions in comment which help me to grow and improve my analytics skills throughout the journey. 😀 THANK YOU !! #dataanalysis #dataanalyst #codebasics #resumepro #visualizations #dashboard #ResumeProjectChallenge9 #RPC9

🚀 Excited to share that I've successfully completed Challenge #9 at Codebasics! 🎉 I recently tackled a fascinating project analyzing sales data during two major campaigns, Diwali and Sankranti. The project involved comparing sales before and after promotions to identify key insights into campaign performance and product popularity. Here are some of the highlights from my analysis: 🔍 Campaign Analysis: I delved into the sales data to determine which campaign yielded better results and analyzed the impact of promotions on sales during each campaign. 📦 Top Performing Products: Identified products that experienced significant quantity sales during both campaigns and analyzed their popularity trends. 📈 City-wise Sales Growth: Evaluated sales growth in different cities during the campaigns to understand regional variations in consumer behavior. 💡 Promotions Analysis: Analyzed the effectiveness of various promotions in driving sales during both campaigns and identified the most successful strategies. This project provided valuable insights into sales dynamics and helped me enhance my analytical skills. I'm excited to continue leveraging my expertise in data analysis to drive business success. Big thanks to Codebasics for providing this challenging project opportunity! 💼 #DataAnalysis #SalesAnalytics #CodebasicsChallenge #professionaldevelopment

Hi Connections, One of my colleague from Flipkart is looking to switch her career from Operations to analytics. She has very strong knowledge on SQL, MS Excel and Python. She is very dedicated and hardworking. Any leads or reference would be very helpful in shaping her career. I am attaching her CV here to reaching out to her. Akriti kumari: FYI. #dataanalytics #businessanalytics #analyticsjobs #analytics

Day 10 out of 50 Starting the journey of sharing #interview questions . Company: Meesho Level: Medium Language/Tool: SQL . Problem Statement: You have a table named orders_table with the following structure: c_id: Customer ID order_date: Date of the order (format: YYYY-MM-DD) no_order: Number of orders placed on that date 1. You need to retrieve the top 10 customers who have: 2. Placed at least one order in the past 365 days from the current date. 3. Not placed any orders in the past 60 days from the current date. For each of these customers, you should calculate the total number of orders they placed, considering only those orders which were placed more than 60 days ago. . My Approach: 1. Create a Common Table Expression (CTE) to filter out orders that were placed more than 60 days ago. 2. Create another CTE to identify customers who have placed at least one order in the past 365 days. 3. Join these two CTEs to find the total number of orders for each customer who meets the above criteria. 4. Sort the results by the total number of orders in descending order. 5. Limit the results to the top 10 customers. . Here's my approach, what would be yours? . #python #interview #meta #fang #datascience #sql #easy #dailychallenge #50daysofsolving #facebook #meesho #SQL

Hey everyone! I'm super excited to share what I worked on during my internship at Devtern in the data science world! 🚀🔍 🌟 Thrilled to unveil my latest project journey during my internship at Devtern in the dynamic realm of data science! 🚀 📝 Project Exploration: Crafted a cutting-edge Text Classification model harnessing Python's versatile pandas, numpy, and scikit-learn libraries. The mission? To discern between authentic and counterfeit news articles based on their textual content. 🛠️ Tools & Technologies: Python pandas numpy scikit-learn 🔑 Core Steps: Data Preprocessing: Immersed myself in the dataset using pandas to unravel its intricate structure. Textual Transformation: Harnessed the power of TF-IDF vectorization to seamlessly translate textual data into numerical features. Model Crafting: Implemented a robust Passive Aggressive Classifier to seamlessly train the model with precision. Performance Evaluation: Methodically evaluated model efficacy through meticulous scrutiny using confusion matrices and classification reports. Visualization: Elevated the analysis by visually depicting model performance using captivating heatmap renditions of confusion matrices. ✨ Dive into the realm of data science with me, where innovation meets impact! 📊 Excited to be part of the awesome things happening at Devtern!

Discover how much you know about #MadhyaPradesh by participating in our weekly quiz series about the #HeartofIndia. Put your knowledge to the test and learn fascinating new facts about this amazing state. Stay tuned to jig your brains! #MPTourism #QuizTime #ExploreIndia

#TrehanFloors - Sector 71, #Gurugram Experience A #Life Of Opulence & #Grandeur Call 9718160160 #AssetsGalleria #gurugramdiaries #gurugrammers #gurugramnews #gurugramcity #gurgaon #gurgaontimes #gurgaondiaries #gurgaonlife #gurgaonlifestyle #gurugramproperty #gurgaonproperty #gurgaonproperties #gurgaonrealestate

Hey LinkedIn network! 🌐 I am thrilled to share a project that I had the privilege to work,, thanks to the wonderful team at iNeuron.ai! 🚀 📚 Project Overview: Title: Analyzing Swiggy: Bangalore Delivery Outlet Data Domain: Food Industry Technology: Python (GitHub repo link attached!) 🔍 Problem Statement: We delved into the fascinating world of online food ordering, focusing on the renowned platform Swiggy! Our mission? To extract, transform, and load a massive dataset, uncovering valuable insights and meaningful relationships between attributes. 🍕📈 💡 Key Approaches: We harnessed the power of Python 🐍and data visualization to unravel the secrets hidden within the data. Our toolkit included Python, enabling us to apply a range of techniques and bring our imagination to life. 🔬 What We Discovered: Through meticulous analysis, we identified key metrics, trends, and factors that drive the online food ordering experience. From delivery times to customer preferences, we've uncovered a wealth of knowledge that holds immense value for the food industry. 🕵️♂️📊 📁 Project Showcase: 🔗 GitHub Repository: https://lnkd.in/g3WTh5AA Stay hungry for knowledge and innovation! Let's connect and discuss the fascinating world of data together. 📈🍽️ #DataAnalysis #FoodIndustry #SwiggyAnalysis #PythonMagic #BusinessIntelligence #DataVisualization

It's quiz time! It's a chance to put your general knowledge to the test. Share your answers in the comments! Answer is:- Science, technology, engineering, and mathematics Visit: http://rknec.edu . . #RCOEM #RKNEC #rcoemnagpur #quiz #QuizTime #QuizChallenge #knowledge #answers #TestYourKnowledge #ThinkFast #generalknowledge #generalknowledgequiz #GuessTheAnswer #CommentYourAnswer

🚀 Exciting Project Alert! 🚀 Hey LinkedIn Fam! 🌟 After 4 fantastic years in US IT recruitment, I’m thrilled to announce my latest adventure into the world of Data Analysis! 📊✨ Over the past year, I’ve been diving deep into SQL, Python (and its libraries like Pandas, NumPy, Matplotlib, and Seaborn), and Advanced Excel, working on multiple projects to hone my skills. Today, I’m excited to share my newest project analyzing Diwali sales data using Pandas, NumPy, Matplotlib and Seaborn. Here’s a sneak peek into what I discovered: 🔍 Data Cleaning & Processing: I scrubbed the data cleaner than a Diwali house cleaning spree! 📈 Data Analysis & Visualization: I turned numbers into insights sharper than a festive firecracker! Here are some sparkling insights from my analysis: 🎆 Women Power: Women are leading the charge in both order counts and total sales, outpacing men significantly. You go, ladies! 💪 🏥 Top Buyers: The IT and Healthcare sectors are the frontrunners in purchasing. Techies and docs love a good Diwali deal! 👰 Married Women Rule: Married women are splurging more. Who says married life can’t be fun? 🌍 Regional Insights: Uttar Pradesh is topping the sales charts. UP, you are truly lighting up the festival! Each step of the analysis is meticulously documented with comments, outputs, and even some insightful suggestions. This project is a testament to my skills and dedication to turning raw data into meaningful stories using Python Libraries. A special shoutout to Rishabh Mishra for his incredible guidance and the dataset from his YouTube videos. Your mentorship has been invaluable, Rishabh. Thank you for lighting the path! 🔥🙏 Check out my project to see the fireworks of data insights in action. If you’re looking for a passionate Data/Business Analyst ready to dive into data and illuminate insights, let’s connect! #CareerTransition #DataAnalytics #Python #SQL #Excel #DataVisualization #BusinessAnalysis #JobSeeker #OpenToWork #WomenInData #Tech #Healthcare #DiwaliSales #Insights #LinkedInCommunity #ThankYou #Mentorship