You can book One to one consultancy session with me on Mentoga: https://mentoga.com/muhammadaammartufail


#######################################################################
GitHub Repo for DSAAMP codes: https://github.com/AammarTufail/DSAAMP_2025
#######################################################################
Data analyst ki real job kaisi hoti hai? Is video mein aap dekhenge day-to-day problems aur portfolio ke liye practical project ideas jo recruitment ATS keywords se match karte hain. Perfect for fresh grads, career switchers, aur working professionals.

What you’ll learn
Core problems at work: messy data, SQL joins & window functions, KPIs define karna, stakeholder alignment, version control, reproducible analysis.

Tool stack: Excel/Google Sheets, SQL, Python (Pandas), Power BI/Tableau, GitHub.

How to turn problems into projects: clear business question → data source → method → metric → dashboard/story.

Hiring signals: clean notebooks, README, data dictionary, and a one-page executive summary.

25+ Project Ideas (pick 3–5 for your portfolio)
Marketing & Growth: campaign ROI dashboard, A/B test analyzer, customer segmentation, churn prediction (EDA).
Finance & Sales: monthly revenue KPIs, cohort LTV, sales forecasting (time series), discount effectiveness.
Operations: inventory optimization, order-to-delivery SLA, anomaly detection for returns.
Product & Web/App: funnel analysis, retention heatmap, feature adoption KPIs.
Public/Research: climate time-series trends, education outcomes dashboard, city-level health stats.

Datasets: Kaggle, Google Analytics sample store, World Bank, open city portals, Yahoo Finance API.
Deliverables: SQL scripts, cleaned CSV, Jupyter notebook, BI dashboard link/screenshot, and a short Loom/YouTube walkthrough.

Tip: Har project ko case-study format mein document karein: Problem, Data, Method, Results, Next Steps.
Bonus: Playlist & resources for Excel, SQL, Python, Power BI on Codanics.

Hashtags (with #, space-separated)
#DataAnalytics #DataAnalyst #PortfolioProjects #SQL #Excel #Python #PowerBI #Tableau #BusinessIntelligence #KPIs #TimeSeries #ABTesting #EDA #Dashboards #AnalyticsJobs #CareerSwitch #codanics #urdu #hindi #pakistan #india #science #recent #2025 #babaaammar #aammartufail

Tags (comma-separated, no #)
DataAnalytics, DataAnalyst, PortfolioProjects, SQL, Excel, Python, PowerBI, Tableau, BusinessIntelligence, KPIs, TimeSeries, ABTesting, EDA, Dashboards, AnalyticsJobs, CareerSwitch, codanics, urdu, hindi, pakistan, india, science, recent, 2025, babaaammar, aammartufail

#codanics #dataanalytics #pythonkachilla #pkc24 #dsaamp

4-Months of Data Science to AI Agents Mentorship Program (DSAAMP)
Hurry up!
Register now, only few seats available.
More information about the course and the registration link to google form: https://forms.gle/8dHbiu2TGmHTzgYY8



---------------------------------------------------------------------------------------------------------------------------------------

Here is the playlist with all free crash courses:
https://www.youtube.com/playlist?list=PL9XvIvvVL50EKXNwINseqf8pCPnPrg5qh

Please share and like this video, also write your comment here and subscribe our channel.
---------------------------------------------------------------------------------------------------------------------------------------
Our Free Books: https://codanics.com/books/abc-of-statistics-for-data-science/
Our website: https://www.codanics.com
Our Courses: https://www.codanics.com/courses
Our YouTube Channel: www.youtube.com/@Codanics
Our whatsapp channel: https://whatsapp.com/channel/0029Va7nRDq3QxRzGqaQvS3r
Our Facebook Group: https://www.facebook.com/groups/codanics
Our Discord group for community Discussion: https://discord.gg/QpvUKEtUJD
For more Details contact us at [email protected]