Khadijat sadiq 📊

Data Storytelling | SQL • Excel • Power BI • Tableau | Python | From Data to Decisions

[Khadijat sadiq 📊 @Data_girrl]

YouTube channels to learn and masters data analytics

[Khadijat sadiq 📊 @Data_girrl]

Data Analysis Roadmap that will guide your data journey.

[Khadijat sadiq 📊 @Data_girrl]

@real_confide Glad it will help

[Khadijat sadiq 📊 @Data_girrl]

PowerBi

[Khadijat sadiq 📊 @Data_girrl]

Power bi interface

[Khadijat sadiq 📊 @Data_girrl]

@Ms_Wiiny Permit granted dear

[Khadijat sadiq 📊 @Data_girrl]

@dicta_andy @UOkarevu64498 Congratulations did you pay for the certificate?

[Khadijat sadiq 📊 @Data_girrl]

@ObohX I learnt wireframes from your wall

[Khadijat sadiq 📊 @Data_girrl]

Brilliant insight

[Freedom | Excel Boss @ObohX]

At the end of every quarter, Sandra has the same challenge.

As the Commercial Analytics Lead at Nestlé Nigeria, she's responsible for preparing performance reports for management.

The problem isn't the reporting itself.
The problem is that the data comes from different regions.

For Q1, sales reports arrived from the North, South-West, and South-East regions as separate CSV files. Each region maintained its own report, which meant slight differences in formatting, naming conventions, and data quality.

Before management could answer questions like:
• Which region generated the most revenue?
• Which products performed best?
• Who were the top-performing sales representatives?
• How did revenue trend throughout the quarter?
The data first had to be prepared.

This project started with three regional sales datasets.

Using Power Query, I imported the files, standardized the structure, corrected data types, cleaned inconsistencies, and appended all three datasets into a single master table.
Once the foundation was in place, I created additional fields to support analysis, including:
• Revenue
• Profit
• Profit Margin
• Week Number
• Month Name
• Performance Indicators

With the transformed dataset ready, the next step was analysis.
Before building any visuals, I summarized the data using PivotTables to identify the key insights and answer the business questions that mattered most.
Only after the analysis phase did I move into dashboard design.

I wireframed the layout, defined the KPI structure, selected the appropriate visualizations, and built an interactive dashboard featuring:

• Revenue, Profit, Quantity, and Transaction KPIs
• Revenue by Channel and Category
• Top Performing Sales Representatives
• Best Selling Products
• Weekly Revenue Trends
�� Interactive filters for Region, Month, and Sales Representative

What began as three separate CSV files became a centralized reporting solution capable of delivering insights in seconds.
One lesson I keep reinforcing in my classes:
Most people think dashboards start with charts.
They don't.
Dashboards start with clean data, a structured process, and the right business questions.

Tools Used: Excel, Power Query, PivotTables, PivotCharts, Slicers, Dashboard Design

#DataAnalytics #Excel #PowerQuery #BusinessIntelligence

[Khadijat sadiq 📊 @Data_girrl]

@benefit2cryp Thank you

[Khadijat sadiq 📊 @Data_girrl]

Dashboards wireframe on PowerPoint

[Khadijat sadiq 📊 @Data_girrl]

As part of my project with DecodeLab, I applied SQL to extract and analyze targeted data from our database. By leveraging SELECT, GROUP BY, ORDER BY, and HAVING, I focused on pulling only the metrics essential for analysis –revenue, order volume, and product performance.

[Khadijat sadiq 📊 @Data_girrl]

@ladycarpenter01 I love it

[Ojo David🙂‍↔️ @officialdave001]

🚚 Just completed my Capstone Project at @TechSphereAcad given by @ezekiel_aleke in the recently concluded Data Analytics cohort

Using Excel, SQL, and Power BI, I analyzed 14 logistics datasets and built 5 interactive dashboards covering:

[Khadijat sadiq 📊 @Data_girrl]

@Raji_Mariam01 @cheftee_lead Congratulations Mariam you did it

[Khadijat sadiq 📊 @Data_girrl]

Congratulations Mariam you did it celebrate 🎉

[Raji Mariam @Raji_Mariam01]

Just wrapped up my final project as a Data Analytics Intern at DecodeLabs,a fully interactive Power BI dashboard for Nova Mart e-comm sales.

From cleaning raw data, writing SQL queries, to building something dynamic and useful. Here’s what the numbers revealed:

[Khadijat sadiq 📊 @Data_girrl]

@top_processEngr Thank you

[Khadijat sadiq 📊 @Data_girrl]

Internship task completed for week 2 at @decodelabtech

[Temi ✨ @cheftee_lead]

It’s my birthday today.

Happy birthday to me 🎂🥰❤️