DEV Community

Cover image for My Journey As A Data Analyst
Oluwole Akinyele
Oluwole Akinyele

Posted on

My Journey As A Data Analyst

Hey everyone ๐Ÿ‘‹

This week in my data analyst journey was all about Excel โ€” my first real data best friend ๐Ÿ˜„. I decided to go back to the basics and explore just how powerful this tool really is when you know what youโ€™re doing.

I worked with some raw datasets and used functions like VLOOKUP, INDEX-MATCH, and IF statements to clean and organize data. Honestly, watching messy data transform into neat tables feels like magic every single time.

I also spent some time learning Pivot Tables โ€” easily one of the coolest features in Excel. Being able to summarize large chunks of data in seconds made me realize how much time Iโ€™ve wasted in the past doing things manually ๐Ÿ˜….

On top of that, I played around with some data visualization tools in Excel โ€” adding charts, slicers, and conditional formatting to make my reports look more professional (and fun to read).

Itโ€™s crazy how a tool I once saw as โ€œjust for spreadsheetsโ€ has turned into a full-blown data storytelling platform. Each formula feels like a new superpower unlocked.

Top comments (0)