Hi, I'm David ๐
I'm transitioning into Data Analytics.
Skills I'm learning: โ Excel โ SQL โ Power BI โ Data Visualization
I'll be sharing dashboards, projects, and insights as I grow.
Follow my journey! ๐ #DataAnalytics#PowerBI#SQL
Hey algorithm, connect me with people who love:
๐ Data Analysisโจ๐ Data Scienceโจ๐ป Excel, SQL, Power BI & Pythonโจ๐ Problem-solvingโจ๐ง Critical thinkingโจ๐ Continuous learningโจ๐ Data booksโจ๐ Analytics projectsโจ๐ฌ Research & insightsโจ๐ Data storytellingโจ๐ข Sharing knowledgeโจ๐ Learning and growing
If thatโs you, welcome home.
AGGREGATION FUNCTIONS in Excel:
SUM โ Add numbers
SUMIF โ Add with one condition
SUMIFS โ Add with many conditions
AVERAGE โ Mean of values
AVERAGEIF โ Average with one condition
AVERAGEIFS โ Average with many conditions
COUNTA โ Count non-empty cells
COUNTIF โ Count with one condition
COUNTIFS โ Count with multiple conditions
MAX โ Largest value MIN โ Smallest value
MAXIFS โ Largest value with criteria
MINIFS โ Smallest value with criteria
SUBTOTAL โ Filter-aware calculation
Turning raw data into actionable insights ๐
Built this interactive dashboard to analyze key business metrics, identify trends, and support better decision-making. Data storytelling is where numbers meet strategy. #DataAnalytics#DashboardDesign#ExcelDashboard#DataVisualization
๐ Customer Analysis Dashboard Completed!
Key findings:
โข 3,900 customers generated ยฃ5.18M in revenue
โข Adults are the most valuable customer segment
โข Revenue peaked in 2013 before declining in 2014
Turning data into actionable business insights. ๐
#DataAnalytics#Excel
Hi, I'm David ๐
I'm transitioning into Data Analytics.
Skills I'm learning: โ Excel โ SQL โ Power BI โ Data Visualization
I'll be sharing dashboards, projects, and insights as I grow.
Follow my journey! ๐ #DataAnalytics#PowerBI#SQL
Just completed an HR Analytics Dashboard in Excel.
Key insight: Employees with higher appraisal scores tended to have better retention rates.
What would you add to this dashboard? ๐
#Excel#DataAnalytics