Vera Kinya’s Post

Monday Data Thought: One thing I’m learning as I continue growing in data analytics: Consistency beats intensity. It’s easy to feel like you need to learn everything at once, new tools, new techniques, new concepts. But real progress comes from: • practicing regularly • building small projects • improving one skill at a time Over time, those small efforts compound into real confidence and capability. Data analytics is not about quick wins, it’s about steady growth. Still learning. Still building. #DataAnalytics #SQL #Python #BusinessIntelligence #LearningInPublic

Friday Data Reflection: One thing I’m learning as I continue building data projects: Good analysis is about trade-offs. Sometimes you have to balance: • speed vs accuracy • simplicity vs detail • technical depth vs business clarity It’s not always about doing the most complex analysis, but choosing what best fits the problem and the audience. The goal is not just to analyze data, but to deliver insights that are timely, clear, and useful. Still learning. Still building. #DataAnalytics #SQL #Python #BusinessIntelligence #LearningInPublic

Many people jump directly into tools when learning Data Analytics. SQL. Python. Power BI. But one thing changed my mindset completely: 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐢𝐬 𝐧𝐨𝐭 𝐚𝐛𝐨𝐮𝐭 𝐭𝐨𝐨𝐥𝐬. 𝐈𝐭’𝐬 𝐚𝐛𝐨𝐮𝐭 𝐬𝐨𝐥𝐯𝐢𝐧𝐠 𝐛𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐩𝐫𝐨𝐛𝐥𝐞𝐦𝐬. Tools are just the medium. The real value comes from:- • Understanding the problem • Asking the right questions • Finding patterns in data • Turning insights into decisions Tools can be learned in months. Thinking like an analyst takes practice. #dataanalytics #careergrowth #analytics #learningjourney

Earlier, I used to think data analysis was all about dashboards, visualizations, and complex models. But while working with real datasets, I’ve realized something important — data preprocessing is where the real work happens. Most data is messy. It comes with missing values, inconsistent formats, duplicates, and sometimes even wrong entries. If we skip cleaning and preparing it properly, the final analysis can be completely misleading. Preprocessing may not look exciting, but it builds the foundation for everything that comes after — whether it’s analysis, visualization, or machine learning. I’m learning that even small steps like cleaning columns, handling missing data, or structuring information correctly can make a huge difference. In the end, it’s simple: Better data leads to better insights. #DataAnalytics #DataScience #LearningJourney #Python

📊 Day 2 of #100DaysOfBusinessAnalytics One of the most important steps in data analysis is Exploratory Data Analysis (EDA). EDA helps analysts understand the dataset before building models or drawing conclusions. Some key things I usually explore during EDA: • Understanding the dataset structure • Checking for missing values • Identifying patterns and trends • Detecting outliers in the data • Using visualizations to understand distributions EDA helps transform raw data into meaningful insights, which supports better business decision-making. Tools I often use for this process include Python (Pandas, Matplotlib) along with Excel and Power BI for visualization. Learning how to explore data effectively is a key step in becoming a better analyst. #100DaysOfBusinessAnalytics #BusinessAnalytics #DataAnalytics #Python #Excel #PowerBI

Friday Data Reflection: One thing I’m learning as I continue building data projects: Good analysis is iterative. It’s rarely perfect the first time. Sometimes you: • revisit your queries • adjust your assumptions • refine your visuals • or even rethink the problem And that’s okay. Each iteration improves: • accuracy • clarity • and the overall quality of insights Data analysis is not a one-step process, it’s a cycle of learning, testing, and improving. The goal is not just to get results, but to get better results over time. Still learning. Still building. #DataAnalytics #SQL #Python #BusinessIntelligence #LearningInPublic

Most people approach data analytics as a checklist of tools. That’s the wrong approach. High-quality work comes from understanding structure, not just execution. At the core sits business understanding. Everything else supports it. Data comes in. It gets cleaned. Then explored using SQL or Python. Findings are shaped into visuals. Finally, those visuals are turned into decisions. Add AI on top, and the speed increases. But clarity still depends on how well the foundation is built. Here’s where most go wrong: They jump straight to dashboards. They skip context. They ignore data quality. The result looks good, but fails in real decisions. Strong analysts don’t work in steps. They think in systems. Every part connects. Every layer affects the outcome. If one piece is weak, everything built on top of it becomes unreliable. That’s the difference between reporting numbers and driving decisions. Your weakest link? #dataanalytics #businessanalytics #datascience #datavisualization #powerbi #sql #python #aiforbusiness #datastorytelling

If you're learning data analytics, This one concept will change everything: Filtering Data. Most beginners write code. But analysts ask questions like: “Show me only the important data.” Here’s a simple example in Python: df[df["Salary"] > 30000] That one line does something powerful: • Checks each value • Creates a True/False condition • Filters only relevant rows And suddenly… You go from: raw data → useful insight This is how you answer real questions like: ➡ Who are the high earners? ➡ Which sales are above average? ➡ Which customers matter most? You don’t need complex models to start. You need clarity in thinking. Learn how to filter data properly and you’re already thinking like an analyst. What’s one Pandas function you recently learned?

🔶drop_duplicates() catches exact copies. But real data has a sneakier problem that it completely misses. Same person. Slightly different entry. Same Employee ID. Employee_ID: 10234 | Name: John Kamau | Dept: Sales Employee_ID: 10234 | Name: J. Kamau | Dept: sales Those look different enough that drop_duplicates() won’t touch them. But they’re the same person entered twice. Here’s how to catch it: # Find IDs appearing more than once duplicate_ids = df[ df.duplicated(subset=[“Employee_ID”], keep=False) ] print(f“Records with duplicate IDs: {len(duplicate_ids)}”) print(duplicate_ids.sort_values(“Employee_ID”).head(20)) 🔷This shows every row that shares an ID with another row. Now you can actually investigate instead of guessing. The fix depends on what you find: # Keep only the most recent entry per employee df = df.sort_values(“date_added”, ascending=False) df = df.drop_duplicates(subset=[“Employee_ID”], keep=“first”) Soft duplicates are dangerous for one reason: your analysis treats one person as two data points. Your model learns from the same person twice. Your headcount reports are wrong from the start. And none of it raises an error. Everything looks fine. 📍Check for duplicates by key columns, not just identical rows. That extra step catches what the default function misses. ❓Have you ever found soft duplicates in a dataset? What gave it away? #DataCleaning #Python #DataScience

Understanding Mean, Median & Mode Made Simple 💡 One concept that really helped me understand data better: 👉 The relationship between Mean, Median, and Mode It’s not just theory… It actually tells you the shape of your data 👇 📊 Normal Distribution (Symmetrical) Mean = Median = Mode ➡️ Everything is balanced 📊 Positively Skewed (Right Skewed) Mean > Median > Mode ➡️ Few large values pull the mean to the right 📊 Negatively Skewed (Left Skewed) Mean < Median < Mode ➡️ Few small values pull the mean to the left 🎯 Simple way to remember: Right skew → Mean is highest Left skew → Mean is lowest I’m still learning, but concepts like these make statistics much more intuitive 📈 #datascience #dataanalytics #statistics #python #sql #machinelearning #learning #students #analytics #beginner #selflearning #dataskills #careergrowth