Jeremiah Jacob | Data Analyst

HR & Compensation Analyst transitioning deeper into Data Analytics | Excel, SQL, Power BI & Python | Sharing my journey, projects & beginner-friendly lessons

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

Hi, I’m Jeremiah 👋 A Statistics grad and HR C&B Analyst building deeper in Data Analytics with Excel, SQL, Power BI & Python.

I’ll be sharing my journey, projects, lessons and practical insights from HR, payroll and business data. Let’s connect 🤝

#DataAnalytics #Excel #SQL

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

PivotTables are becoming one of my favorite Excel features.

Today I turned raw sales data into a summary report by grouping, filtering and comparing product performance-all without writing a formula.

I can see why they're essential for data analysts.

#Excel #PivotTable #Data

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

3 Excel cleaning tricks I practiced today:

TRIM removes extra spaces.
PROPER standardizes names.
Flash Fill (Ctrl+E) speeds up repetitive tasks.

Every clean dataset starts with good data cleaning. Practicing with a messy HR dataset.

#Excel #DataAnalytics #LearningInPublic

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

@SharonAnalytics I get this. Trying to build in data while handling other responsibilities can be exhausting, but documenting the journey and staying consistent will compound over time. Rooting for you 🙌

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

@SharonAnalytics This is a solid first project 👏 building a dashboard from a messy dataset is a great way to learn because it forces you to clean, structure and actually interpret the data. Curious - what was the most challenging part for you, the cleaning, formulas or dashboard design?

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

@Alex_TheAnalyst This really hits home. I’m currently rebuilding my data analytics foundation from an HR/Comp & Benefits background, and posts like this are a good reminder that mastering Excel, SQL, Power BI and core problem-solving still matters even with all the AI buzz around.

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

This week I worked through Power Query, XLOOKUP, and aggregation formulas in Excel.

Small progress, but I’m focused on building strong foundations before moving deeper into SQL, Power BI, and Python.

#DataAnalytics #Excel #LearningInPublic

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

@Microsoft365 Absolutely 🙌 XLOOKUP has made lookups much cleaner for me.

I’m currently documenting my Excel learning journey as I build toward stronger data analytics skills in Excel, SQL, and Power BI.

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

Why I switched to XLOOKUP in Excel:

It’s cleaner, easier to read, and more flexible than VLOOKUP. No more counting column numbers manually, and I can return a custom “Not Found” message directly in the formula. Small change, better workflow.

#Excel #DataAnalytics

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

If you work with targets, commissions, payroll, or KPI summaries, learn SUMIFS, COUNTIFS, and IFS early.

They save time and make reports much easier to build.

I’m currently practicing them through a simple commission calculator. #Excel #DataAnalytics

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

If you clean the same kind of file every week, use Power Query instead of repeating the steps manually. Import once, clean once, then just refresh when new data comes in.

Saves time and reduces errors.

#Excel #DataAnalytics

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

Day 1 of learning in public

Today I’m setting up the foundation for my data analytics journey- cleaning up my profiles, organizing GitHub, and getting ready to build consistently with Excel, SQL, Power BI, and Python. Small steps, but important ones.
#DataAnalytics #Excel #SQL

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

@KhusbooT14835 All

[Khusboo Tayal @KhusbooT14835]

All Paid Courses (Free for First 4500 People)

𝗣𝗮𝗶𝗱 𝗖𝗼𝘂𝗿𝘀𝗲 𝗙𝗥𝗘𝗘 (PART - 3)

1. Artificial Intelligence
2. Machine Learning
3. Cloud Computing
4. Ethical Hacking
5. Data Analytics
6. AWS Certified
7. Data Science
8. BIG DATA
9. Python
10. MBA

(72 Hours only )

To get-
1. Follow me [MUST]
2. Like & Retweet to get DM
3. Reply " All "

[Parul Gautam @Parul_Gautam7]

A-Z 10000+ pages of all programming PDF note books:🔥 just for FREE !!

You will get
🎯 Html
🎯 Css
🎯Jquery
🎯 Node.js
🎯 Algorithm React
🎯 React native
🎯 .Net
🎯 Angular
🎯 Oracle DB
🎯 MongoDB
🎯 Typescript Python
🎯 Powershell
🎯 C++
🎯C#
🎯 Hibernate
🎯Spring
🎯22 more... Simply,

You just have to
✅Follow ( to DM)
✅RT
✅Comment ♥️

[Jeremiah Jacob | Data Analyst @Analyst_Jacob]

@Parul_Gautam7 ❤️

[Obinna Iheanachor @DataSenseiObi]

Do you want to become a world-class data analyst in just 6 months?

I’ve been there, and I know how overwhelming it can be to learn data analysis from scratch.

That’s why I’ve created a 6-month roadmap of free high-quality resources that will teach you everything you need to know, from statistics and Excel to Python and cloud computing.

In this thread, I’ll share with you my ultimate roadmap and how you can download it for free.

Let’s get started! 👇

[L.A.M.Z @OlamideTowobola]

If you’re interested in LEARNING all of these for FREE:

Product management
Project management
Business analytics
Data visualization
Microsoft excel
Data analytics
Big data
Scrum
UI/UX
Agile
SQL

Open, RT this and thank me later:

https://t.co/946zJFiWth

[Pastor William F. Kumuyi @pastorwf_kumuyi]

JESUS only is our MESSAGE!

[Ujjwal Chadha @ujjwalscript]

How to stay consistent with programming until you make it to your dream job 🧵👇

(Inspired by Atomic Habits)