Today, I went back to Jobberman.
I had previously analyzed the data using Pandas and NumPy, cleaning it and uncovering insights about job roles, salary trends, and top-paying positions.
But there’s just something about analyzing data with a visualization tool... It's better 😎
Continuing my MySQL journey
Today I focused on database keys. Built an order system using primary & foreign keys to connect customers, orders, and products, ensuring data integrity.
Still learning, one query at a time.
Did a little something today with MySQL 👀
This time, I analyzed a dataset across multiple tables using SQL joins.
Worked with customers, orders, products, and order_items tables to understand how data connects and extract insights.
Getting more comfortable with SQL 😊
I have tasted Python
I have tasted SQL
I have tasted Power BI and Tableau
I have tasted Excel
I highly recommend using what gets the job done more efficiently for you🙃🤭
Lately, I’ve been honing my SQL skills with MySQL, creating databases and tables, inserting and updating data, and writing queries to filter, calculate, and manage table relationships.
Still learning and improving.
I wasn’t excited about NYSC.
Honestly saw it as one year I could easily lose if I wasn’t intentional.
So I made a decision: if I was ever going to serve, it had to be rewarding, not just something I endured.
Before I registered, I sat down and made a list of companies hiring entry-level and graduate trainee roles with salary ranges between 150k – 300k
I didn’t apply randomly. I applied only to roles that aligned with my skill set and long-term direction, didn’t limit myself to just data analysis, stretched to business analysis, research & policy, business development, etc..
After applying, I didn’t stop there.
I reached out directly to decision-makers, whether it’s CTOs, COOs, and CEOs, honestly I no send HR like that, oops 😅
I sent messages on LinkedIn. Sometimes, I even reached out via Instagram. (Yes, I had to stalk a little 😅)
Slowly, the responses started coming in.
Then a request letter.
Did this for like 3 months o, got an offer in October, registered for November batch.
That’s how!
Finally carried out an analysis on the Jobberman Dataset.
I first cleaned the salary column, then analyzed the dataset to identify the highest-paying roles, the companies hiring the most, and other key trends.
So I tried it again.
This time, I scraped multiple pages of job listings from Jobberman and turned the results into a clean, structured dataset.
It includes job titles, company names, work arrangements, employment types, salaries, and job descriptions... all ready for analysis.
So I tried data mining for the first time… yay! 🤗🤭
I scraped data from a website and transformed that raw information into a structured database.
There’s still a lot to learn, but I’m really enjoying every step of the process!