After several sleepless nights, I have completed my First PowerBI Dashboard. This Healthcare dataset has about 55,000 patient admissions across hospitals.
#DataAnalytics
A time of sorrow 🙁 we need to be spiritually awakened by the atrocities governing our nation, children and people are dying like flies and some useless set of people will still choose this current government because of their tribalistic selfless mentality.
Certified Data Analyst! Months of learning, practicing, and diving deep into datasets have officially led to this milestone. I’ve thoroughly enjoyed the challenge of learning how to turn messy numbers into clear, actionable business insights.Thank you God 🤲 #data@E1XAcademy
Data cleaning is where most beginner analysts fail.
Not because it’s hard
but because no one teaches it properly.
I’ve worked with:
→ Survey data (NGO research)
→ Banking system data
Here are 10 data cleaning techniques every beginner must know:
Worked with joins to combine tables and started learning subqueries.
It’s interesting seeing how similar some of these concepts are to Power BI when working with data.
Still getting comfortable with subqueries, but I’ll keep building on it as I progress.
5 Excel skills every Data Analyst must know:
• VLOOKUP → Find data across tables
• SUMIF → Sum based on condition
• COUNTIF → Count based on condition
• INDEX + MATCH → Better than VLOOKUP
• Pivot Table → Summarize thousands of rows fast
Master these before jumping to advanced tools. 🚀
Save this for later. 🔥
What is a KPI card?
A KPI card displays one critical metric clearly.
▫️Highlighting performance
▫️Comparing actual vs target
💡KPI cards highlight the most important metrics for quick evaluation.
#DataDigest#DataAnalytics#Beginners
This week has been one of those “learning is not always smooth” weeks
I started catching up on SQL and learned how to:
• Create databases
• Create tables
• Update records
• Work with structured data
Then I moved to import CSV/text files into SQL Server…
@ezekiel_aleke
@RuthChika12 Hi Ruth
So if a company sells coffee for 4,800 and a doughnut for 2,100, then runs a promo on the two items for 5,500 do you think they’re at loss or making profit?