Project Details

I delved deep into Excel's powerful features, learning how to:

🎯𝑫𝒆𝒔𝒊𝒈𝒏 𝒅𝒚𝒏𝒂𝒎𝒊𝒄 𝒄𝒉𝒂𝒓𝒕𝒔 𝒂𝒏𝒅 𝒈𝒓𝒂𝒑𝒉𝒔.
🎯𝑼𝒕𝒊𝒍𝒊𝒛𝒆 𝒑𝒊𝒗𝒐𝒕 𝒕𝒂𝒃𝒍𝒆𝒔 𝒂𝒏𝒅 𝒔𝒍𝒊𝒄𝒆𝒓𝒔
🎯𝑰𝒏𝒄𝒐𝒓𝒑𝒐𝒓𝒂𝒕𝒆 𝒂𝒅𝒗𝒂𝒏𝒄𝒆𝒅 𝒇𝒐𝒓𝒎𝒖𝒍𝒂𝒔 𝒂𝒏𝒅 𝒇𝒖𝒏𝒄𝒕𝒊𝒐𝒏𝒔

===========================================
𝐆𝐨𝐧𝐞 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐬𝐨𝐦𝐞 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐬:

✅Filter
✅Sort
✅Sort By
✅Spill ranges

===========================================
𝐌𝐢𝐬𝐭𝐚𝐤𝐞𝐬 𝐈'𝐯𝐞 𝐦𝐚𝐝𝐞 𝐰𝐡𝐢𝐥𝐞 𝐜𝐫𝐞𝐚𝐭𝐢𝐧𝐠 𝐝𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝:

🎭 Incorrect chart selection
🎭 Inconsistent data formatting

===========================================
𝐍𝐞𝐰 𝐥𝐞𝐚𝐫𝐧𝐢𝐧𝐠𝐬:

🤔 CHOOSE
🔄 SORTA
✅ Data Validation List

Project video

Project Details

Explored AtliQ Hardware Project:

Designed interactive dashboard
Integrated sales, marketing, financial data
Empowered data-driven decisions

✨ Power BI learning journey enriched my data-driven decision-making experience.

🎯 Tools Used:

Excel, Power Query
Power BI, DAX
DAX Studio optimization

🎯 Business Metrics:

Gross Sales, Net Invoice Sales
Net Sales, Gross Margin
Net Profit, Deductions
COGS, YTD, YTG, Market Share

🎯 Essentials:

KPI Indicators, Calculated Columns
Advanced Data Modeling
DAX Measures, Bookmarks
Navigational Precision

Project video

Project Details

☑️𝐌𝐢𝐬𝐬𝐢𝐨𝐧:

We wanted to Analyse Telangana’s growth among different sectors quantitatively and provide useful Insights to the Telangana government that would help them to make data-informed decisions that would further support the growth of the state.

☑️𝐓𝐨𝐩 𝐅𝐢𝐧𝐝𝐢𝐧𝐠:

⭐E-stamp sales in Telangana rural areas (2019-2022): 437K(21 districts), while urban areas recorded 818K.(12 districts)

⭐Electric vehicle sales demonstrate consistent annual growth in Telangana districts.

⭐Rangareddy, Sangareddy, Medchal Malkajgiri, Yadadri Bhuvanagiri, and Mahabubnagar are the districts exhibiting substantial employment rates.

Project video

Project Details

🌟𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞 𝐌𝐢𝐬𝐬𝐢𝐨𝐧

Atliq Hardware is a computer hardware company that manufactures and distributes hardware across four main regions. The management at Atliq Hardware realized the need for more insightful and data-informed decisions but lacked adequate resources. Tony Sharma, the Data Analytics Director, aimed to find candidates proficient in both technical and soft skills. As a part of the hiring process, he organized an SQL challenge to assess candidates in both domains.

🌟𝐓𝐨𝐨𝐥𝐬 𝐈 𝐋𝐞𝐯𝐞𝐫𝐚𝐠𝐞𝐝

-MySQL for analyzing dataset
-PowerBI for visualization
-Canva for crafting presentations.
-OBS Studio for recording and sharing insights.

🌟𝐖𝐡𝐚𝐭 𝐈 𝐆𝐚𝐢𝐧𝐞𝐝
- Deepened my understanding of SQL.
- Explored complex data scenarios.
- Mastered the art of extracting insights from real-world datasets.
- Honed my problem-solving abilities.
- Joined a vibrant community of data enthusiasts.

Project video