Balam Singh Bisht

BCA Student 🎓 | Aspiring Data Analyst 📊 | Learning Excel, SQL & Power BI | Documenting my journey from Zero to Job 🚀

[Balam Singh Bisht @DataWithBalam]

@FatimaAbdu2n Ohh well, what is your profession?

[Balam Singh Bisht @DataWithBalam]

🚀 Day 108 of my #ZeroToDataAnalyst journey

Today: Find and Replace in Excel

Manual edits slow you down.
Find and Replace makes data cleaning faster and more consistent.

Small tools create big efficiency.

#Excel #DataAnalytics #LearningInPublic #ZeroToDataAnalyst

[Balam Singh Bisht @DataWithBalam]

🚀 Day 109 of my #ZeroToDataAnalyst journey

Today: Advanced Sorting in Excel

Better organization leads to better insights.
Advanced sorting helps structure data for clearer analysis.

Clarity starts with structure.

#Excel #DataAnalytics #ZeroToDataAnalyst

[Balam Singh Bisht @DataWithBalam]

🚀 Day 107 of my #ZeroToDataAnalyst journey

Today: Freezing Panes in Excel

Small features can improve big workflows.
Freezing panes made navigating large datasets easier and clearer.

Better visibility leads to better analysis.

#Excel #DataAnalytics #LearningInPublic

[Balam Singh Bisht @DataWithBalam]

🚀 Day 106 of my #ZeroToDataAnalyst journey

Today: Notes and Comments in Excel

Data needs context to be understood.
Notes and comments make analysis clearer and more collaborative.

Clarity drives better decisions.

#Excel #DataAnalytics #LearningInPublic

[Balam Singh Bisht @DataWithBalam]

🚀 Day 105 of my #ZeroToDataAnalyst journey

Today: Removing Duplicates in Excel

Duplicate data can break analysis.
Cleaning it ensures accuracy and reliability.

Clean data = correct insights.

#Excel #DataAnalytics #LearningInPublic #ZeroToDataAnalyst

[Balam Singh Bisht @DataWithBalam]

🚀 Day 104 of my #ZeroToDataAnalyst journey

Today: Text to Columns in Excel

Raw data is often messy.
Text to Columns helps turn unstructured data into usable format.

Clean data is the real starting point.

#Excel #DataAnalytics #LearningInPublic #ZeroToDataAnalyst

[Balam Singh Bisht @DataWithBalam]

🚀 Day 103 of my #ZeroToDataAnalyst journey

Today: XLOOKUP in Excel

Better tools simplify complex tasks.
XLOOKUP replaces multiple functions with one flexible solution.

Simple solutions scale better.

#Excel #DataAnalytics #ZeroToDataAnalyst

[Balam Singh Bisht @DataWithBalam]

🚀 Day 102 of my #ZeroToDataAnalyst journey

Today: HLOOKUP in Excel

Data structure changes the solution.
HLOOKUP showed how horizontal lookups require a different approach.

Adaptability matters.

#Excel #DataAnalytics #LearningInPublic #ZeroToDataAnalyst

[Balam Singh Bisht @DataWithBalam]

🚀 Day 101 of my #ZeroToDataAnalyst journey

Today: VLOOKUP in Excel

Data is useful only when it connects.
VLOOKUP helped me link datasets and automate data retrieval.

Connection creates value.

#Excel #DataAnalytics #LearningInPublic #ZeroToDataAnalyst

[Balam Singh Bisht @DataWithBalam]

🚀 Day 100 of my #ZeroToDataAnalyst journey

Today: Advanced Excel for Data Analytics

Excel is not just basic — it’s foundational.
Advanced functions and pivot tables make data analysis faster and more practical.

Strong basics create strong professionals.

#Excel

[Balam Singh Bisht @DataWithBalam]

🚀 Day 99 of my #ZeroToDataAnalyst journey

Today: Ollama (Run LLMs Locally)

AI is powerful, but control matters.
Running models locally improves privacy, flexibility, and independence.

Ownership changes everything.

#AI #Ollama #DataAnalytics #LearningInPublic

[Balam Singh Bisht @DataWithBalam]

🚀 Day 98 of my #ZeroToDataAnalyst journey

Today: Manus AI

AI is shifting product building from execution to direction.
From idea to deployment, workflows are becoming faster and more accessible.

Clarity of thinking is the new skill.

#AI #BuildInPublic #DataAnalytics

[Balam Singh Bisht @DataWithBalam]

🚀 Day 97 of my #ZeroToDataAnalyst journey

Today: Quadratic AI

Data work is shifting from manual effort to intelligent interaction.
AI-powered spreadsheets are making analysis faster and more intuitive.

Tools are evolving. So should workflows.

#AI #DataAnalytics

[Balam Singh Bisht @DataWithBalam]

🚀 Day 96 of my #ZeroToDataAnalyst journey

Today: Claude Code and Warp

Better tools don’t replace skills — they amplify them.
AI-assisted coding and modern terminals are changing how we work.

Efficiency is the new advantage.

#AI #DeveloperTools #DataAnalytics

[Balam Singh Bisht @DataWithBalam]

🚀 Day 95 of my #ZeroToDataAnalyst journey

Today: VS Code Agent Mode Deep Dive

AI can speed up coding, but understanding still matters.
Agent Mode showed how smart workflows improve productivity without replacing thinking.

Use tools wisely.

#AI #VSCode #DataAnalytics

[Balam Singh Bisht @DataWithBalam]

🚀 Day 94 of my #ZeroToDataAnalyst journey

Today: What AI can and cannot do

AI is fast, but not always right.
Understanding its limits is what makes it useful.

Use AI to assist, not replace thinking.

#AI #DataAnalytics #LearningInPublic #ZeroToDataAnalyst

[Balam Singh Bisht @DataWithBalam]

Just wrapped up Advanced Python! 🐍✅

Now diving into "AI Tools for Data Analysts." The goal? Combine Python logic with AI speed to automate the boring stuff (and maybe make manual coders a little jealous 😉).

As I wrap up my BCA, efficiency is everything. What is your go-to AI

[Balam Singh Bisht @DataWithBalam]

🚀 Day 93 of my #ZeroToDataAnalyst journey

Today: Gurgaon Real Estate Market Analysis

Real data is messy, but that’s where real insights come from.
Applied EDA, cleaning, and visualization to analyze property trends.

Projects build real skills.

#Python #DataAnalytics

[Balam Singh Bisht @DataWithBalam]

🚀 Day 92 of my #ZeroToDataAnalyst journey

Today: Data Visualization with Seaborn

Better visuals reveal deeper insights.
Seaborn made it easier to understand patterns and relationships in data.

Clarity creates impact.

#Python #DataAnalytics #Seaborn #LearningInPublic