SQL Basics: Filtering Data with WHERE Clause

🚀 Day 19 of My 45-Day Data Analytics Challenge Today I learned about SQL COUNT and why it is useful in Data Analytics. The COUNT function is used to find the total number of rows or records in a dataset. It helps analysts understand the size of the data and measure activity. 📊 Example: SELECT COUNT(*) FROM sales_data; This query shows the total number of records in the sales_data table. 🛠️ Common uses of COUNT: • Count total customers • Find number of orders • Measure employees in each department • Count products in each category • Track website visits or app users 💡 Key Insight: COUNT is one of the simplest SQL functions, but it is very useful for measuring business activity and understanding datasets. As I continue learning SQL, I am realizing that even basic functions can provide valuable insights. 📌 What would you count first in a sales dataset: customers, orders, or products? #DataAnalytics #SQL #CountFunction #LearningJourney #DataAnalysis

🚀 Day 16 of My 45-Day Data Analytics Challenge Today I learned about the SQL WHERE clause and why it is important in Data Analytics. The WHERE clause helps filter data based on specific conditions. Instead of viewing the entire table, analysts can focus only on the information they need. 📊 Example: SELECT customer_name, sales_amount FROM sales_data WHERE sales_amount > 5000; This query shows only customers whose sales amount is greater than 5000. 🛠️ Common uses of WHERE: • Find customers from a specific city • Filter sales above a certain value • View records from a particular date • Identify inactive users • Analyze only relevant data 💡 Key Insight: The WHERE clause makes analysis more focused and helps analysts answer specific business questions quickly. As I continue learning SQL, I am realizing that filtering the right data is just as important as retrieving it. 📌 Which condition do you think analysts use the most: greater than, less than, or equal to? #DataAnalytics #SQL #WHEREClause #LearningJourney #DataAnalysis

I recently built a couple of SQL projects and ran into something interesting during a funnel analysis. Event-level data showed conversion rates over 100%, which clearly didn’t make sense. Switching to a session-level funnel improved the modelling, but the inconsistency remained, purchases still exceeded add-to-cart events on mobile. This suggests the issue isn’t just event duplication, but likely related to how the funnel is defined or tracked (e.g., missing events or alternative purchase flows). It reinforced how easy it is to misinterpret metrics if you don’t fully understand how the data is structured. For those working in data/product analytics: What would you suggest adding to personal projects to better reflect real-world scenarios? Currently focusing on SQL + analysis, and thinking about which tools to prioritize next. #DataAnalytics #SQL #ProductAnalytics

Data is only useful when it answers a business question. Writing SQL queries is not just about extracting data... It’s about understanding what decision needs to be made. Instead of: Get all customer data A better approach: Identify customers likely to churn based on usage patterns That changes everything: What data is needed How it is filtered How it is analyzed This is where Data Analysis connects with business impact. Query → Insight → Decision #SQL #DataAnalysis #Analytics #DataDriven #BusinessIntelligence

🚀 Day 3 of My Data Analyst Journey – SQL Practice 💡 How do businesses identify their top-selling products based on revenue? Today, I worked on a real-world SQL problem to analyze product performance using sales data. 🧠 Problem: Find the top 5 best-selling products based on total revenue. 💻 SQL Query: SELECT p.product_name, SUM(oi.price * oi.quantity) AS total_sales FROM order_items oi INNER JOIN products p ON oi.product_id = p.product_id GROUP BY p.product_id, p.product_name ORDER BY total_sales DESC LIMIT 5; 📊 Output: (See attached screenshot showing top-performing products based on revenue) 📊 Key Insight: Bluetooth Headphones generated the highest revenue, followed by Laptop and Office Chair. This analysis helps businesses: ✔️ Identify high-performing products ✔️ Focus on revenue-driving items ✔️ Improve inventory and sales strategy 📌 What I Learned: Using INNER JOIN to combine tables Calculating revenue using price and quantity Aggregating data with SUM() Sorting results to find top performers 💬 Feedback and suggestions are always welcome! #SQL #DataAnalytics #LearningJourney #AspiringDataAnalyst #SQLPractice #DataAnalysis #CareerGrowth

I made Excel project in which I made a simple Excel dashboard after ETL process. This project focuses on analyzing a dataset with over 30,000 records to uncover meaningful insights and trends. It includes data cleaning, exploratory data analysis, and visualization using Excel. Key insights include sales trends, top-performing products, and regional performance. The project demonstrates strong skills in data analysis, data cleaning, and dashboard creation. Link to the Project: https://lnkd.in/g4dR56DS #data_analysis #data #data_visualisation #dashboard #excel

🚀 Day X: SQL JOINs – Where Data Becomes Insight In data analysis, data is rarely in one place. The real value comes from connecting datasets—and that’s exactly what SQL JOINs do. 🔗 JOINs = Relationships + Context Without JOINs → Just tables With JOINs → Meaningful insights 💡 Quick Insight: The type of JOIN you choose directly affects your analysis: INNER JOIN → What exists in both tables LEFT JOIN → What’s missing (powerful for identifying gaps) 📊 As a Data Analyst, JOINs help you: ✔️ Understand customer behavior ✔️ Detect missing or incomplete data ✔️ Build accurate reports & dashboards 🧠 Real takeaway: JOINs are not just queries—they reflect how you think about relationships in data. #SQL #DataAnalytics #DataAnalyst #LearningInPublic #BusinessAnalytics #SQLJoins #WomenInTech

📊 Using SQL to Analyze Sales Data I’ve been working with a sample sales dataset to strengthen my SQL skills and explore how data can support business decision-making. 🔍 Key tasks performed: ✔️ Filtered customer orders based on location and transaction value ✔️ Analyzed product-level sales performance ✔️ Calculated overall revenue using SQL aggregations 📈 Key Insight: Identified high-performing products and cities contributing the most to total revenue, highlighting areas with strong business potential. This hands-on practice is helping me connect SQL concepts with real-world business scenarios and data-driven decision-making. Looking forward to exploring more advanced analytical techniques. #SQL #DataAnalytics #BusinessAnalysis #DataDriven #AnalyticsJourney

🔍 Real Problem I Solved Using Data In one of my reports, I noticed a drop in agent performance. Instead of just reporting numbers, I: ✔️ Analyzed team-wise performance ✔️ Compared SLA and productivity metrics ✔️ Identified specific low-performing segments 💡 Result: Helped highlight key problem areas for better decision-making. This experience taught me: 👉 A Data Analyst should not just report — but provide insights. That’s what I aim to improve every day 🚀 #DataAnalytics #ProblemSolving #PowerBI #SQL #Insights

Day 4/30 – SQL Basics: Using LIMIT to Focus on What Matters So far, I’ve learned how to retrieve, filter, and sort data. Today I explored how to limit the number of results using the LIMIT clause. Example: SELECT * FROM sales ORDER BY amount DESC LIMIT 5; 🔍 What does this do? It returns the top 5 highest-value orders from the dataset. 📌 Why this matters: In real-world analysis, we often don’t need all data — we need the most important data. LIMIT helps answer questions like: • What are the top-selling products? • Who are the highest-paying customers? • Which transactions contribute the most revenue? ⚡ Important concept: ORDER BY + LIMIT = Powerful combination Without sorting, LIMIT just gives random rows. With sorting, it gives meaningful top insights. 🧠 Analyst mindset: Focus > volume. Good analysts don’t look at everything — they quickly identify the top drivers of impact. ✅ Key takeaway: Finding the top N records is often the fastest way to uncover insights. #SQL #DataAnalytics #DataAnalyst #SQLBasics #LearningInPublic