MLSA | Data Analyst | Power BI Developer | Youtuber | Lover of music and Art | Passionate about teaching |
2×Datathon Winner
Subscribe tomy YouTube channel 👇
Are you eager to learn how to extract insights from business data through SQL Queries?
Join us on Saturday, September 21st, 2024, for an interactive workshop where we'll build a hands-on SQL project focused on Customer Churn analysis.
I did it! 💃💃
I've officially Graduated from Udacity Data Analyst Nanodegree.
This Progam has made me a better Python Programmer and a better Data Analyst.
Writing Meaningful ReadMe's, Working on Projects all by myself.
When I Started 3 months ago, I could barely code.
A FREE Power BI Beginner Class‼️
I’ve been learning Power BI on the Microsoft Learn Platform and reading a lot of articles; I’ve decided to share my knowledge.
With this, I plan to hold a 10-day FREE Power BI Beginner class. I’ll introduce you as a beginner to Power BI.
A QUICK STORY
When I decided to do the
#30daysofdata
challenge, I decided I was going to end it with a project and what you are seeing is a result of my hardwork.
I analyzed 148k tweets of Beyoncé’s Renaissance Album using Python and built this dashboard using Power BI.
Your girl is a Graduate!
FIRST CLASS HONORS, B. Eng, Civil Engineering 🎓
Thank you Jesus.
Funny how I went into UNN unafraid,
First year felt like a breeze, but oh what a challenge I still had ahead.
Second year started and I was a crazy mess.
Introducing a new series on my YouTube channel "HOW TO: A Power BI series" where I show you how to do more with data in Microsoft Power BI.
The inspiration to do this arose from my numerous searches on the web and YouTube on how to this with Power BI,
Guys please I applied for
@hertechtrail
laptop grant. I really need a laptop. I’ve been sharing with my sister
@Rita_tyna
but she has a full time job and light supply has been really terrible lately. I can barely complete my courses.
HerTechTrail’s laptop support program is back; BIGGER and BETTER 💃💃
This program is to aid black women in Tech with laptops to pursue their passion in tech
Need a laptop for your tech journey?
Apply here Now👇
#HTTLS
#hertechtrail
#womenintech
@AskMichaelTaiwo
Unique ID: 443414
My name is Chinonso Okonkwo, a Graduate of Civil Engineering, UNN (First Class Honors).
I learnt about the importance of GRE in graduate Admissions and Graduate school funding through the EducationUSA bootcamp that I was privileged to be a part of.
(1/5)
The goal was to complete the Data Analyst with Python track and now its been achieved💃
I've been really used to learning on Coursera and Udacity, so it took a while to adapt to learning on Datacamp but I did it
#data
This past couple of weeks have been something I'll tell ya. But guess who just got Microsoft Certified.
Meee 💃💃
Woke up one morning and decided to schedule my exam the next day. Why? I was tired of doubting myself, and constantly worrying if I was ready or not.
Here's a football pitch I created in Power BI with few lines of code written in the Python script editor.
Looking forward to taking this further with analysis.
Here's the viz and the code.
Want to learn how to create this, a detailed tutorial on how to do this drops on
When I started Udacity Data Analyst Program, I bought a book solely for the course. In this book, I wrote down codes as a beginner.
Do people still write codes on paper? Lol
I just received my laptop, I'm so excited 🤗🤗
Looking forward to more productivity with this.
Thanks once again for making this happen
@OoTheNigerian
@hackSultan
@precillieo
I appreciate this 🙏🙏
I'm excited to announce that I've been accepted into the Microsoft Learn Student Ambassadors Program.
Looking forward to helping students in their tech journey or getting them started.
Thank you to
@TheOyinbooke
@DavidAbu_
for sharing this opportunities to the tech community.
Want to learn how to use Microsoft Power BI for Data analytics.
Check out this collection
It also include series of labs, so you get to practice as you learn.
Course 7 Bagged!
This one wasn't easy o, cos I was already learning Python and it was hard for me to accept R, but I could see the similarities in both languages.
Now my Advise: Learn one language at a time if possible.
How to Apply for a Twitter Developer
Account and get your API KEY❗
Here's link to the medium article I wrote to get those keys.
I tried to make it a step by step guideline so anyone can easily understand.
Hope it helps someone in the data community.
Exploratory data analysis. In this course, I practiced importing and cleaning data. Making sure your data is clean, validating your data is quite important. I visualized age distributions with histogram, setting the bin size.
@hackSultan
@OoTheNigerian
1. My name is Chinonso Okonkwo. I am a Data Analyst. I started my tech career last year and I've been consistently learning and building in public. I've also impacted others with the 10 Days of Power BI Free Bootcamp where I organised and taught over 600 people how
Guess who's become an Alpha MLSA😩..Meee💃💃.... Omo I can't wait to share the knowledge in DAX I gained to attain this milestone..make I just see small time and small money for data, I go arrange Power BI class to teach people everything.
2022 was the year for me, the year I started to dream, started my tech journey, slowly started to believe in myself. Met some amazing personalities on twitter. Fell in love with
@MSPowerBI
Started a YouTube channel, became a private tutor.
I'm grateful God for everything.
I Updated my Sales Dashboard taking note of the feedback I got from
@saltypip
and
@jessica_xls
I tried to increase Font size a bit.
Highlighted key recommendation.
Corrected the typographical error.
We worked on the Maven Toys dataset yesterday. Here’s a one page report I created in the
#10DaysofPowerBI
class. I enjoyed writing out DAX functions to calculate the Average Transaction value(ATV), Profit Margin, Average Rev per store amongst others.
It's not been easy learning these days.
If it's not light, it's laptop issues.
It's staying awake all night and feeling like u achieved nothing,cos your goals for the week are staring at u unaccomplished. Yes, I know it should be growth over goals mindset. But it's hard sometimes
Teaching is something I’m quite passionate about. I remember saving up from offering private classes in school to buying my first digital tablet then, but I never really knew how to start, never knew I could JUST START. Today I’m celebrating 500+ freaking subscribers on YouTube.
16k views on YouTube 💃💃. Everyday, I have had at least 2 persons subscribing to my channel and I really appreciate the support. Now, i can call myself a Youtuber, lol. See ehn I'm going to be successful in this life and successful people work hard.
Since the Launch of Microsoft Fabric, I've been exploring it and I want to share a couple of resources that is currently helping me and I think would be helpful to you as well.
Yay! I submitted my Udacity Project 3 and it got APPROVED. I'm Super excited about this one.💃💃💃
Because I started working on it, hit a dead end , Then I started all over.
Someone just supported the program
#10DaysofPowerBI
with 10GB of data. I literally was up thinking about data supply yesterday . Then after watching a video of a girl who trusted God for something. I decided to just place it in God’s hands and God has provided for me.
I analysed the performance of Joro Academy Students in the just concluded examination.
I was focused on identifying variables that helped students perform better or worse.
Recommendations were also given in the Report.
Please check it out and let me know what you think.
Being in class from 8 to 4pm.
Just came online and saw the most wonderful news ever 🤗🤗
Like can my day get any better.
Thank you God🙏
Thank you to everyone,
I'm really really grateful.
Started working on my
@Udacity
Data Analysis with Python project 2
Part one is done.
1. Gathering data ✅
My laptop was low so I had to take a break 💔
Next: Assessing data
#Python
#DataAnalytics
No POWER can QUERY my love for you. In you I find the POWER to BI myself. DAX why I love you.
In the future, I'll tell our kids that you're the perfect MODEL to look up to when creating relationships. Cause you EXCEL in all you do, Let's FUNCTION as one.
@Rita_tyna
Let’s see who’s got the best lines with Love and Data Analytics…😁
We go first: “You SUM up my life. Thinking about you makes me FUNCTION and EXCEL in all I do.”
Now it’s your turn! Drop your lines in the comments. Feel free to tag your val..😉
#ValentinesDay
Back to studying, I completed the course Data Manipulation with Pandas. Personally, pandas is one of the python libraries I love, so I enjoyed this. With pandas you could subset a dataframe, merge two dataframes, extract year from a date column and many more.
Yes!, I'm officially back to learning on the Datacamp platform.
The Goal: Complete the Data Analyst with Python track.
I really enjoyed taking this course, felt a bit easy for me but towards the end e choke.
Glad I completed it tho💃
#DataAnalyst
#data
CREATING A DATA MODEL IN POWER BI
🧵 A thread ❗
When working with data from multiple sources, it's vital that you establish a relationship between the data to create a cohesive report.
Microsoft Labs is providing a hands-on learning experience for SQL. So far I'm loving it 🤗🤗.
Done with tackling this challenges. Made use of some functions like COALESCE (which returns the first non-null entry in a list), CASE expression (which is similar to SWITCH function in
This is an appreciation message to everyone who has shown me their support with this. The likes, the comments, the quotes, The write ups that made me emotional.
I'm very appreciative🙏
I pray that when you need men, God will raise men to fight for you as you've done for me.
@AskMichaelTaiwo
Unique ID: 443414
My name is Chinonso Okonkwo, a Graduate of Civil Engineering, UNN (First Class Honors).
I learnt about the importance of GRE in graduate Admissions and Graduate school funding through the EducationUSA bootcamp that I was privileged to be a part of.
(1/5)
Day 21 of
#30daysofdata
Today I learnt Sentiment analysis and the steps involved.
Step 1: Tokenization (dividing statements into individual words)
Step 2: Cleaning the data to remove special characters
Step 3: Removing stop words and words which do not add value to the analysis.
Deeply honoured and grateful to have been chosen🙏. To be honest, it came at a time when I was struggling with handling responsibilities. Talk about juggling between a research grant, a research paper, my final year project, learning data and ML.
Good morning everyone. I'll be joining
@hertechtrail
Data Community Twitter Space, on the Road Map to becoming a Data Analyst on Wednesday 7pm, the 28th of September 2022. Looking forward to this. You can join the space through this link
I had my phone and laptop stolen this morning. This is really painful because its the first night in weeks I decided not to stay awake all night, cos its messing with my health. I have never felt like cursing someone so bad like I do right now.
It’s day 1 of
#10DaysofPowerBI
We started off with a segment “Power BI conversations” . Discussions about powerbi amidst alternatives like Tableau came up.
This is my submission to Mubby's Data Challenge to show and rank the most influential actors in Nigeria.
@Femi_OfMainland
@Rita_tyna
-----------------------------------------
Let's talk about Iterator functions.
A useful function in Microsoft Power BI is the iterator functions.
Iterator functions are functions in DAX (Data Analysis Expressions) that evaluates a given expression for each row.
🧵 A thread!
Today, I read a chapter of a book, Created a visual in Power BI, Learnt little DAX and applied it.
Wrote down a python code, which refused to run but i persevered and it finally did, then later I got stuck again.
At this point, I took a break. Now, I'm about to continue DAX.
Currently taking the course Introduction to statistics in python and my knowledge of probability from further maths is coming in handy. To think probability showed me shege back then.
Hey twitter fam.
We are building a data community for UNN students.
If you are a student of the University of Nigeria, Nsukka passionate about data and would love to join a community of data enthusiasts.
Please fill this form. Kindly
RT for people on your timeline.
/Optimizing Performance in Power BI/
A Thread!
1/
Have you ever been creating a dashboard and noticed that some or all of your visuals are taking longer to load.
Well, this is why your reports and model should be optimized.
Finally, Project 2 of my
@udacity
Data Analyst done.
This one wasn't easy I'll admit.
I had no interest in a project about Dogs, but I definitely enjoyed the Gathering Stage, which involved me
1. Applying for a twitter developer account.
2. Querying data using an API
#Python
Day 30 of
#30daysofdata
Yay!
I made it.
It's Day 30!
Wrapping up my Project, almost done with the Article.
I Will be sharing this with the tech community soon.
🧵 A Thread❗
With DAX you can create 3 calculations namely;
1. Calculated tables
2. Calculated Columns and
3. Measures.
DAX can also be used in applying Row Level Security. There are over 80 DAX functions. Today I learnt the importance of using the DIVIDE function instead of
#Day1
I continued working on my Google Capstone Project, did cleaning for the 12 months of data using Excel. Added some necessary columns for better analysis. Looking good for now.
Today was a productive day and I feel good
Thank you Jesus.
#30daysofdata
Does anyone know anyone in Total Energies, I'm in need of a Sponsor and the sponsor's IGG for my compulsory 3-6 months internship as an engineering student.
Please retweet, share across 🙏
Thank you.
What I'm working on, webscraping a wikipedia table.Webscraping is simply extracting data from a website using code.
When given a choice,I'll say pick using an API over scraping, why?,scraping is brittle and breaks with web layout redesigns because the underlying html has changed
Today I reinforced my knowledge on why it's best to create a column in Power Query when possible.
By adding custom columns which you do in Power Query, it loads your data to the model in a compact and optimal way.
But why do we need to create calculated columns then?
I wanted to add a functionality in my power bi report where user can choose to view heat maps with/without the data labels. So this led me to discovering bookmarks in power bi. Its an interesting functionality.
Any one with resources to learn more about bookmarks, please share.
I analyzed the Superstore Dataset this weekend and would like to share.
Ps: This is my first time using PowerBI to create a visualization but I know I'll definitely be using this more.
Any Suggestions, feedback or constructive criticism would be appreciated.
@jessica_xls
So I've been off here for a while. Needed time to think and plan, and so much resources dey here, i no wan loose focus.
Also, this is a public announcement, UNN is after my life. Exams in about 2 weeks and omo e choke but we go dey alright laslas.
In this course, I practiced creating plot using seaborn. With seaborn, I created scatter plots, line plots, and many more. Seaborn plots create two different types of object; FacetGrid and Axes subplots. To add titles and labels I need to determine the type of the object first.
Going through submissions of the case study of 10 Days of Power BI and I’m impressed. In just ten days the participants have a project to show for it. There are corrections to be made, but they did a good job unguided.
#10DaysofPowerBI
Microsoft Learn Student Ambassador UNN successfully held the Global Power Platform Bootcamp in University of Nigeria, Nsukka today.
Humbled to have been a speaker 🙏. Thanks to the incredible MLSA UNN team for putting this together.
Special thanks to you
@JohncrossDavid
I just completed a Module on Professional Ethics as part of my ALX Financial Analyst Program, delivered in partnership with Corporate Finance Institute.
I learnt about Ethics and why it matters.
I'll be speaking on "Building Dashboards that tell insightful stories" at the PowerBI master class organised by
@MubarDauda
.
If you registered for the class, make sure you don't miss this one.
#tech
#storytelling
#data
Are you a student looking to start your career in tech, or a profesional who wants to learn new skills and want to know what "a day in the life of" is really like before you dive in.
Then join me and register for Student Summit.
Just finished solving a Linear programming problem we solved in class using simplex method in Excel.
The knowledge of Microsoft Excel is definitely needed by any business professional.
#tech
#data
#Excel
Omo
It's not easy combining school with tech, especially while preparing for exams.
On some days one has to give.
Thank God I was able to spend some time on a course yesterday and run some codes on jupyter notebook.
Little steps.
👩💻▶️ I just uploaded a new video on how to get more visuals in Power BI.
Check it here.
Prerequisite: You need to sign in with a professional email address or have a Microsoft 365 account which will look something like this name
@onmicrosoft
.com
Happy Birthday Sis
@Rita_tyna
🎂🥂
I hope this new year brings you the very best, because you deserve it and more. You put in the best everywhere: family, friends, work, you name it.
I'm so proud of you and your growth.
Grow and Glow in Jesus name.
So the test I took, one of the requirements was to download Microsoft Teams..
As per tech babe na, all my friends came to me for help, and I assisted them with installing the app successfully. This tech thing sweet sha
🤗💃💃💃
This is a very wrong statement to make, as a person to another person. I would even call this decisively mean. I don't share enough here because people are always looking to belittle one's work, time and effort. But this year, that ends.
Learning takes time and practice. You will not always understand everything from the beginning of learning. Therefore, be patient and persevere with theory and activities to reinforce your knowledge.
Day 24 of
#30daysofdata
Watched videos on Excel Interview questions.
Did Some Data gathering using Twitters API.
Added a linked Table of Content to my Jupyter notebook.
Started using Location Geocoding to extract d Longitude and Latitudes of Addresses, Nepa no let me finish am😂
👩💻▶️ Want to learn how to plot football shots in Power BI, check this
Plotting your event data on a football pitch is a way of communicating the data in a visually appealing manner.
In this tutorial, we will be walking through how to plot football
👩💻▶️ I just dropped the tutorial on how I created the football Pitch in Power BI. Check it out here
I'll be exploring this further with analysis in the coming videos, do subscribe to my channel.
#PowerBI
#MsPowerBI
#dataanalytics
#NonsoandPowerBIin2023
Here's a football pitch I created in Power BI with few lines of code written in the Python script editor.
Looking forward to taking this further with analysis.
Here's the viz and the code.
Want to learn how to create this, a detailed tutorial on how to do this drops on
I'm a sucker for Tableau dashboards.
They just give me a Cool vibe.
But I'm also of the School of thought, that it's not the tool, it's the Analyst.
#dataanalyst
#Tableau
#data