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