Yinka

Virtual Assistant • Data Analytics 📊
Interested in Healthcare Analytics & AI Automation
Sharing insights, projects & continuous learning.

[Yinka @3rdTeey]

Day 51/180 📊

Today I worked on a full healthcare data-cleaning project in Power Query.

Cleaning, transforming, grouping and combining data made one thing clear:

Good analysis starts with good data.

Still building. 📊

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 50/180 📊

Today I went behind the buttons in Power Query.

I explored Advanced Editor, M language, parameters, refresh and troubleshooting.

The goal isn’t just knowing what to click. It’s understanding what’s happening behind the clicks.

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 49/180 📊

Today’s Power Query lesson:

Merge = join related data
Append = stack similar data

A simple distinction, but getting it wrong can completely change your dataset.

#DataAnalytics #PowerQuery #HealthcareAnalytics

[Yinka @3rdTeey]

Day 48/180 📊

Today I worked with Group By in Power Query.

I used healthcare data to summarize patient counts, total bills and average bills by ward.

From individual records → meaningful insights.

#DataAnalytics #PowerQuery #HealthcareAnalytics

[Yinka @3rdTeey]

Day 47/180 📊

Today I worked with Custom, Conditional & Index Columns in Power Query.

Raw data doesn’t always give you the fields you need.

Sometimes, you have to create them from what you already have.

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 46/180 📊

Today I worked with Date & Date/Time transformations in Power Query.

Dates can look correct but still be stored incorrectly.

Getting them right matters when analysing admissions, length of stay and monthly trends.

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 46/180 📊

Today I practiced Date & Date/Time transformations in Power Query.

Extracting year, month, quarter, day, time and calculating date differences.

Small transformations can reveal a lot of useful information in a dataset.

#DataAnalytics #PowerQuery

[Yinka @3rdTeey]

Day 45/180 📊

Today I worked with Split Columns & Merge Columns in Power Query.

Simple tools, but real data isn’t always consistent.

The lesson: inspect the pattern before deciding how to transform it.

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 44/180 📊

Messy text can affect your analysis more than you think.

Today I used Power Query to clean spaces, text cases, unwanted characters and extract text.

Less manual editing. More consistent data.

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 43/180 📊

Today’s lesson: cleaning data isn’t just deleting what looks wrong.

I worked on replacing inconsistent values, missing data, Fill Down/Up and errors in Power Query.

The key? Understand the problem before fixing it.

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 42/180 📊

A simple lesson from today:

Before analyzing data, make sure the data is structured correctly.

Today I worked with data types, columns and rows in Power Query.

Garbage in, garbage out. 📊

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 41 📊

Diving deeper into Excel today with Power Query.

Covered the interface, importing data, and Applied Steps.

The goal isn’t just to know the tools, but to get better at using them to solve real data-cleaning problems.

#DataAnalytics #PowerQuery #Excel

[Yinka @3rdTeey]

Day 40/180 📊

Today I learned about Advanced Data Cleaning and why a systematic approach matters when working with messy datasets.

Clean data, better analysis. ✅

#Excel #DataAnalytics #Day40

[Yinka @3rdTeey]

Day 39/180 📊

Today I learned about error checking and data quality checks in Excel.

Before analyzing data, I need to make sure it is complete, valid, consistent, and logical. ✅

#Excel #DataAnalytics #Day39

[Yinka @3rdTeey]

Day 38/180 📊

Today I learned about Data Validation in Excel.

It helps prevent incorrect or inconsistent entries and keeps data cleaner from the start. ✅

#Excel #DataAnalytics #Day38

[Yinka @3rdTeey]

Day 37/180 📊

Today I learned Text to Columns & Flash Fill in Excel.

Two simple tools that can make data preparation much faster. ✅

#Excel #DataAnalytics #Day37

[Yinka @3rdTeey]

Day 36/180 📊

Today I learned about cleaning dates in Excel and how to tell whether Excel recognizes a date as an actual date or just text.

One more step toward cleaner, more reliable data. ✅

#Excel #DataAnalytics #Day36

[Yinka @3rdTeey]

Day 35/180 📊

Today I learned how to clean numbers and currency values in Excel.

Messy data can affect calculations, so proper cleaning matters. ✅

#Excel #DataAnalytics #Day35

[Yinka @3rdTeey]

Day 34/180 📊

Today I learned about standardizing inconsistent categories in Excel.

Different spellings or formats can represent the same thing, so cleaning them is important for accurate analysis. ✅

#Excel #DataAnalytics #Day34

[Yinka @3rdTeey]

Day 33/180 📊

Today I learned about missing values in Excel and why they need to be handled carefully.

A blank doesn’t always mean zero. Understanding the data comes first. ✅

#Excel #DataAnalytics #Day33