𝕃♡𝕣𝕖𝕥𝕥𝕒

CIPM in progress😝😝

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

Started my CIPM classes on the 11th of June…I’m coming back to quote this tweet when I become an Associate member by God’s Grace 🙈🤭

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@Femiforge Amen oo
Happy new month

[PeePee🎀 @peegzy1]

Train yourself to handle life without ever borrowing money.

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@Femiforge Okkay 🙂🙂‍↕️

[Femi The Analyst . @Femiforge]

When you feel like texting your ex, open Excel and start cleaning some data.

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

-I found out that Adults aged 35-49 generated the highest revenue even more than Elderly customers despite having fewer transactions.

#Learninginpublic #LearningExcel

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

Day 13/30 of #LearningDataAnalytics (Excel)

Continued the customer analysis project today🎉:

-I grouped customers by how much they spend, then checked which groups those spending patterns belong to.

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

Day 12/30 of #LearningDataAnalytics (Excel)

Today I worked on a full analysis project 🎉

-Explored a real customer dataset
-Derived new columns: age bands, customer value, order weekday, year-month
-Used SUMIFS to break down revenue by country, gender, and age group.

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@top_processEngr Thanks 😊

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

Day 12/30 of #LearningDataAnalytics (Excel)

Today I worked on a full analysis project 🎉

-Explored a real customer dataset
-Derived new columns: age bands, customer value, order weekday, year-month
-Used SUMIFS to break down revenue by country, gender, and age group.

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

Day 11/30 of #LearningDataAnalytics (Excel)

Today I learnt 🎉:

-Power Query editor Interface
- Use of Power Query
-How power query works

Power query is used for turning messy datasets into clean, structured data that’s ready for analysis.

#LearningInPublic #LearningExcel

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@phillieslite Thank you ☺️

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@viktorscript3 Thank you 😊

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@ReadswithAJ @OSASBAL @_apex_divine @Chrisnny27 Please I need the past questions also🧎🏾

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

This is the first time it felt less like learning Excel and more like actually doing data analysis.
#LearnInPublic #LearningExcel

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@Femiforge @vheeorji22 Lemme bookmark

[Femi The Analyst . @Femiforge]

This one-page guide will instantly improve your data storytelling.

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@classicman70483 Feel free to share

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@BakareJoshua15 Thank you 😊

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

Day 11/30 of #LearningDataAnalytics (Excel)

Today I learnt 🎉:

-Power Query editor Interface
- Use of Power Query
-How power query works

Power query is used for turning messy datasets into clean, structured data that’s ready for analysis.

#LearningInPublic #LearningExcel

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

Day 10/30 of #LearningDataAnalytics (Excel)

Today I practiced 🎉:

-VLOOKUP
-IFERROR
-INDEX/ MATCH

Started learning how to combine functions together. Small shift, but changing the way I think about formulas.

#LearningInPublic #LearningExcel

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@ninafrancez1 @ZoomCharts This is so clean. keep building

[𝕃♡𝕣𝕖𝕥𝕥𝕒 @_dndLoretta]

@vheeorji22 Spreadsheets for now

[Femi The Analyst . @Femiforge]

𝗗𝗔𝗧𝗔 𝗔𝗡𝗔𝗟𝗬𝗦𝗜𝗦 𝗣𝗥𝗢𝗖𝗘𝗦𝗦:

✅️Define the problem

✅️Collect the data

✅️Data Cleaning

✅️Data Analysis & Visualization

✅️Interpret the results

✅️Communicate the results

💥Did I miss any ?