Misty_πŸ’› (@_Mistyyyy__) header
Misty_πŸ’› (@_Mistyyyy__) profile picture

Documenting my data analysis journey hereπŸ“Š Status:Not a NewbieπŸ™‚β€β†”οΈ

Joined January 2025
Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)Photo by Misty_πŸ’› (@_Mistyyyy__)
Misty_πŸ’› retweeted
I just wrapped up a new project: Retail Sales, Customer Behavior & Promotion Analysis This one dives into how retailers can boost revenue & optimize promotions by understanding customers, stores, and seasonal sales trends.
2
2
2
376
Misty_πŸ’› retweeted
Hiring isn’t just β€œapply β†’ interview β†’ hired.” It’s a pipeline full of bottlenecks, mismatched expectations & hidden patterns. I built a Recruitment Pipeline Dashboard (Excel + Power Query + DAX) to help HR teams see: βœ” Who’s in the talent pool βœ” Where candidates get stuck
8
17
1
138
7,389
Misty_πŸ’› retweeted
How do you handle the data modeling btwn a fact table with two important dates and the date table? That was my challenge for this analysis but I was able to overcome it through the active and inactive relationships and DAX's 'USERRELATIONSHIP()' function to activate the inactive
7
7
89
3,498
Misty_πŸ’› retweeted
Wireframing before visualization has been a game charger, and I don't use a fancy tool for it, just PowerPoint! Planning my layout first makes the process smoother, faster, and less frustrating compared to the struggle with layout and backgrounds when...
10
13
1
121
11,581
Misty_πŸ’› retweeted
I just completed a powerbi fintech dashboard project. I worked with a synthetic dataset from kaggle an I built a 2- pages interactive report analyzing customer behavior, account activity, and loan performance. I handled the data cleaning using powerquery
30
38
1
351
17,485
Recently, I delved into analyzing Covid-19 data using SQL, and it proved to be a rewarding experience. Here's a glimpse of the project: πŸ“Š **General Data Filtering** The project centers on two datasets: CovidDeaths$ and CovidVaccinations$.
6
13
3
54
4,124
I completed this Power BI project using a dataset provided by Alex the Analyst, focused on understanding the landscape of data professionals across the globe. The dataset consisted of responses from 630 survey participants with an average age of 29.87. My process began in
9
17
135
11,281
"Beyond the fancy dashboard" πŸ‘ There's a lot of dirty works in the backend.
Beyond the fancy dashboard is the not so fancy side, data cleaning. Over the weekend, I explored data cleaning using power query in Microsoft Excel with the focus on answering specific business questions. Here are the functions I explored after loading the table into power query
1
2
7
876
Just completed a full London Bike Sharing Data Analysis Used Python for data cleaning, manipulation, i.e mapping season, weather, holidays, weekends cols Built dynamic dashboards in Power BI for deep insights. The full project and Python codes here: medium.com/@oyizaaminat01/lo…
10
19
1
173
22,801
Turned my Youtube watch-history into a full Exploratory Data Analysis project using Python. Check out the full project on Github: github.com/AminaYusuf01/Port… Using the following steps, I discovered some fun and insightful patterns from my Youtube habits:
12
36
3
259
31,205
Replying to @LearnwithWiDa
@LearnwithWiDa products are different!
Over the weekend, I analyzed a hospital emergency room dataset using power BI to visualize and power query for transformation and cleaning. Many DAX later, and this is the visualization πŸ˜€
1
2
9
590
This Power BI reports present a real-life performance analysis of WEAC candidates in Nigeria between 2019 and 2021. With over 4.7 million candidates records, the project explores trends across gender, school type, region, and state
2
16
112
9,836
Misty_πŸ’› retweeted
Just like there's pivot in powequery, there's also pivot in SQL πŸ˜ƒ same concept, different tools! I've used pivot in power query before and here's my first pivot attempt in SQL. Let me break down how I did it πŸ‘‡ FRAME ONE: data cleaning FRAME TWO: The pivot query
7
13
91
5,306
Hey Data Fam! Staying consistent online while learning deeply behind the scenes hasn't been easy so I took time off posting to level up my data analytics skills but I'm back now ready to start sharing more of my journey. This is a Pizza Sales report using SQL & Power Bi
4
11
91
4,361
My First Power BI Dashboard! πŸŒπŸ“Š Steph Curry’s performance over the years, analyzed with Power BI. πŸ“Š A deep dive into the career of the greatest shooter in NBA πŸ€ Total Points: 25,117 πŸ’Ž Assist Numbers: 6481 πŸ€ Games Played: 1016 ⛹️‍♂️ Rebounds:4770
1
10
16
835
Type conversion in Python - str - int - float
1
12
88
5,957
Misty_πŸ’› retweeted
I began learning power BI, a Microsoft business intelligence tool for storytelling. I understood its building blocks. Learnt to differentiate btwn a report, dashboard and tiles. The three powerBI components-service,desktop and mobile.could distinguish btwn views, panes and canvas
20
15
1
173
11,153
Misty_πŸ’› retweeted
Replying to @_Mistyyyy__
You tried
1
1
1
287
Replying to @_Mistyyyy__
Great work! I'm proud of you.
1
1
2
327
Misty_πŸ’› retweeted
Like I said here, up next is practising what I learnt in a real dataset. To explore more options, I used three related tables of a coffee shop. The product table, which contains data about the coffee, the customer table, and the orders table
Replying to @_Mistyyyy__
I can join two or more tables to answer questions. I can update my table, alter it by dropping or adding a column, or changing the column(field) name or datatype. UP NEXT IS PRACTISING ALL I'VE LEARNT IN A REAL DATASET. stay with me. Thank you
1
4
5
365