Mohammed Gouse | Data Analytics

Transitioning into Data Analytics • Learning in public • Python • SQL • Excel • Power BI • Sharing projects and lessons along the way

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 17

📊 Excel: Power Query Editor for cleaning, transforming data & creating new columns

🗄️ SQL: Learned Window Functions and Cohort Analysis

🧠 Feature Engineering: Label Encoding & Ordinal Encoding.

#DataAnalytics #SQL #Excel #MachineLearning

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 16

📊 Excel: Power Query basics & importing data from different sources

🗄️ SQL: Dynamic Date Filtering

🧠 Feature Engineering: One-Hot Encoding for converting categorical data into numerical values.

#DataAnalytics #Excel #SQL #MachineLearning

[Mohammed Gouse | Data Analytics @ymdgouse]

Built My Career in Data | Day 15

📊 Excel: Analysis ToolPak & Data Tables

🗄️ SQL: TO_CHAR() & DATETRUNC() for working with dates

🧠 Feature Engineering: Detecting and handling outliers using box plots and the five-number summary.

#DataAnalytics #SQL #Excel #MachineLearning

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 14

Today's focus was one of Excel's most powerful features.

📊EXCEL :-
- Learned Pivot Tables,
- Pivot Charts
- Advanced Pivot Table techniques like grouping and hierarchies.

#Excel #DataAnalytics

[Mohammed Gouse | Data Analytics @ymdgouse]

𝗘𝘅𝗰𝗲𝗹 𝘀𝗸𝗶𝗹𝗹𝘀 𝘂𝘀𝗲𝗱
The following Excel skills were utilized for analysis:

- 📉 𝗖𝗵𝗮𝗿𝘁𝘀
- 🧮 𝗙𝗼𝗿𝗺𝘂𝗹𝗮𝘀 𝗮𝗻𝗱 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀
- ❎ 𝗗𝗮𝘁𝗮 𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗶𝗼𝗻

🔗 𝗚𝗶𝘁𝗛𝘂𝗯 𝗥𝗲𝗽𝗼𝘀𝗶𝘁𝗼𝗿𝘆:
https://t.co/4w0LbmOnSX

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 13

This data jobs salary dashboard was created to help job seekers investigate salaries for their desired jobs and ensure they are being adequately compensated.

#Excel #DataAnalytics #BuildInPublic

𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 12

📊 Excel: Tables, conditional formatting & collaboration

📈 Power BI: Charts, custom visuals & tooltips

🗄️ SQL: Continued solving SQL problems to strengthen query skills.

#DataAnalytics #PowerBI #SQL #Excel

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 11

📊 Excel: Histogram, Box Plot & Sparklines

📈 Power BI: Basic visualizations & custom themes

🗄️ SQL: Practiced queries on SQL Practice & HackerRank

🧠 FE: Learned SMOTE for handling imbalanced datasets.
#DataAnalytics #PowerBI #SQL #Excel

[Mohammed Gouse | Data Analytics @ymdgouse]

Also learned how to handle imbalanced data using Upsampling & Downsampling

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 10

📊 Excel: Charts & visualizations

🗄️ SQL: Pivoting with statistical aggregations, segmentation & local Contoso setup

📈 Power BI: Calendar tables and why they matter in time-based analysis.

#DataAnalytics #PowerBI #SQL #Excel

[Mohammed Gouse | Data Analytics @ymdgouse]

Today's focus was preparing data for analysis.

Learning that good analysis starts with clean, well-structured data.

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 9

📊 Excel: Text & Date-Time functions

🗄️ SQL: Pivoting data using CASE with aggregations

🧠 Feature Engineering: Handling missing values using mean, median, mode & random sampling.

#DataAnalytics #SQL #Excel #MachineLearning

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 8

📈 Power BI: DAX basics (Measures, Calculated Columns, SUM, COUNT, IF & Quick Measures)

📊 Excel: Lookup functions

🗄️ SQL: Set up Google Colab, explored Jupyter Notebooks & the Contoso database.

#DataAnalytics #PowerBI #SQL #Excel

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 6 & 7

Built and published my first SQL data analytics project!

Analyzed a data science job postings dataset, documented the project with a README, and uploaded it to GitHub.

https://t.co/BAlGoxEHjG

#SQL #DataAnalytics #BuildInPublic

[Mohammed Gouse | Data Analytics @ymdgouse]

It was a guided eCommerce sales dashboard, but it helped me understand how data, visuals and interactivity come together.

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 5
Built my first Power BI dashboard today!

Also learned SQL (CTEs, Subqueries & UNION) and Excel arrays & SUMPRODUCT.

One dashboard down. Many more to build.

#PowerBI #DataAnalytics #SQL #Excel

[Mohammed Gouse | Data Analytics @ymdgouse]

Today's focus was building a strong data model.

Learning that good analysis starts with a solid data model.

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 4

📊 Excel: Math & statistical functions

🗄️ SQL: Date functions, CASE expressions & database loading

📈 Power BI: Star schema, fact vs dimension tables, relationships & basic DAX.

#PowerBI #DataAnalytics #SQL #Excel

[Mohammed Gouse | Data Analytics @ymdgouse]

Today's focus was turning raw data into usable data.

Excel: IF, IFS, AND, OR, COUNT, AVERAGE

SQL & Power BI - Learning how clean data leads to better decisions.

[Mohammed Gouse | Data Analytics @ymdgouse]

Building My Career in Data | Day 3

📊 Excel: Formulas, functions & logical functions

🗄️ SQL: data types & table creation.

📈 Power BI: Data import, cleaning, transformations, Pivot/Unpivot, custom & conditional columns.

#DataAnalytics #PowerBI #SQL #Excel