In my previous blog, I shared my journey through Week 1 and Week 2, where I worked on Excel-based data cleaning, sales analysis, Pivot Tables and Power BI dashboards.
As the internship progressed, the learning curve became much steeper. The focus shifted from spreadsheet analytics to programming, databases and solving real-world business problems using professional data analysis tools.
Weeks 3 and 4 introduced completely new technologies, larger datasets, and more technical challenges that pushed me far beyond my comfort zone.
These two weeks transformed my internship from learning business reporting into building complete end-to-end data analytics solutions.
Week 3: Supply Chain Analytics using Python & Power BI
Week 3 marked my first serious experience with Python for Data Analytics.
Unlike previous weeks, this project required setting up a complete Python development environment before writing a single line of analysis. I worked extensively with Pandas, NumPy, Matplotlib and Jupyter Notebook to clean, analyse and visualize a real-world supply chain dataset containing thousands of records.
After completing the Exploratory Ddata Analysis (EDA), I integrated the insights into Power BI, creating an interactive dashboard that highlighted sales performance, shipment modes, product groups, vendors and country-wise business metrics.
This project taught me that successful data analysis begins with clean, reliable data—and that Python is one of the most powerful tools for transforming raw datasets into meaningful business insights.
GitHub Repository: https://github.com/YasirAwan4831/week-3-python-powerbi-supply-chain-analytics
YouTube Video: https://youtu.be/SQk41XxxpsY?si=ElhxePDt916bh_VJ
LinkedIn Post: https://www.linkedin.com/posts/yasirawan4831_eda-dataabranalyst-
Week 4: Funnel & Revenue Analysis using SQL & Power BI
The final week introduced one of the most important skills in modern data analytics: SQL.
For this project, I worked with SQLite to analyse customer funnel performance, revenue generation and conversion metrics directly from a relational database. Instead of relying on spreadsheets, I learned how businesses retrieve insights using SQL queries, aggregate functions, filtering, grouping and KPI calculations.
The extracted data was then connected to Power BI, where I built an interactive business dashboard presenting conversion rates, revenue trends and overall funnel performance.
This project completed my internship journey by combining database querying, business intelligence and visualization into one complete analytics workflow.
GitHub Repository: https://github.com/YasirAwan4831/week-4-sql-powerbi-funnel-analysis
YouTube Video: https://youtu.be/sdBYOKqT6YM?si=HfNw1CrgG71dHIzi
LinkedIn Post: https://www.linkedin.com/posts/yasirawan4831_sqlite-sqlabrbased
From Learning Tools to Solving Problems
By the end of Week 4, I had worked with:
Microsoft Excel
Power BI
Python
SQL
Business Analytics
Data Cleaning
Exploratory Data Analysis (EDA)
KPI Dashboard Development
Funnel Analysis
GitHub Documentation
However, learning these tools was only part of the journey.
The real growth came from overcoming technical challenges, debugging errors, researching solutions and continuously improving every project.
10 Real Challenges I Faced During My Data Analyst Internship (And How I Solved Them)
Every Internship Teaches Skills — But Real Growth Comes From Solving Problems
When people look at a completed project, they usually see the dashboard, the charts, the SQL queries, or the final GitHub repository.
What they don't see are the countless hours spent fixing errors, learning unfamiliar tools, debugging environments, researching documentation and solving problems that never appeared in any tutorial.
During my one-month Data Analyst Internship at Logic Stack, I completed four industry-based projects covering Excel, Power BI, Python, SQL and Business Analytics.
However, the most valuable outcome wasn't just the projects themselves.
It was learning how to solve problems independently.
This blog shares the biggest technical and practical challenges I faced during my internship—and how each one made me a better Data Analyst.
Week 3 Project
Supply Chain Analytics using Python & Power BI
By Week 3, the internship shifted from Excel into Python-based analytics.
This project focused on cleaning, analysing and visualizing a real-world Supply Chain dataset using Python (Pandas, NumPy, Matplotlib) alongside Power BI.
Unlike previous weeks, this project introduced a completely new development environment, making it both exciting and challenging.
Week 4 Project
Funnel & Revenue Analysis using SQL & Power BI
The final week introduced SQL for business analytics.
The objective was to analyze conversion funnels, revenue performance and customer behavior using SQL queries before presenting business insights inside Power BI dashboards.
This project simulated real-world reporting workflows where raw database queries become executive dashboards.
Challenge 1
Starting With Zero Practical Experience
Challenge
Although I had experience in web development, I had almost no practical exposure to professional Data Analytics workflows.
Everything—from Excel reporting to SQL analytics—was new.
Solution
Instead of trying to learn everything at once, I followed a structured approach:
Learning one technology at a time helped me build confidence while creating portfolio-ready projects every week.
Challenge 2
Building a Professional Excel Workflow
Challenge
Creating clean spreadsheets is easy.
Creating professional business reports is not.
I had to learn:
- Structured Tables
- Pivot Tables
- Professional Formatting
- Multiple Worksheets
- Formula Organization
Solution
I researched Excel best practices and redesigned my workbook several times until it followed professional reporting standards.
The result was an organized multi-sheet Excel project that later became the foundation for my Power BI dashboard.
Challenge 3
Learning Power BI Dashboard Design
Challenge
Power BI wasn't difficult because of the software.
It was difficult because dashboards must answer business questions—not simply display charts.
Solution
I learned:
- KPI Cards
- DAX Basics
- Dashboard Layout Principles
- Visual Hierarchy
- Business Storytelling
Rather than creating colourful visuals, I focused on dashboards that communicate insights clearly.
Challenge 4
Configuring the Python Development Environment
Challenge
This was one of the toughest technical challenges.
Issues included:
- VS Code Python interpreter problems
- Jupyter Kernel connection failures
- Package installation errors
- Environment configuration
- Version conflicts
These problems had nothing to do with analytics—but they completely blocked development.
Solution
Instead of giving up, I researched official documentation, debugging guides and community discussions.
Eventually I:
- Fixed interpreter paths
- Installed required libraries
- Connected Jupyter successfully
- Stabilized the development environment
This experience taught me that environment setup is a real engineering skill.
Challenge 5
Cleaning a Real-World Dataset
Challenge
The Supply Chain dataset contained:
- Missing values
- Mixed data types
- Invalid numeric values
- Text inside number columns
Real business datasets are rarely clean.
Solution
Using Pandas, I:
- Converted invalid values safely
- Filled missing values
- Removed inconsistencies
- Validated cleaned data
Only after proper cleaning did visualization become meaningful.
Challenge 6
Installing SQLite & Building SQL Workflows
Challenge
Week 4 introduced SQL.
Before writing queries, I first had to configure SQLite and import datasets correctly.
Solution
I installed DB Browser for SQLite, verified database structure, imported CSV datasets correctly and prepared the environment before beginning SQL analysis.
This preparation prevented many future errors.
Challenge 7
Writing Complex SQL Queries
Challenge
Simple SELECT statements were easy.
Business reporting required:
- GROUP BY
- Aggregate Functions
- Filtering
- Revenue Calculations
- Conversion Metrics
Solution
Instead of memorizing syntax, I practiced writing increasingly complex queries while documenting each command inside my repository.
This improved both my SQL knowledge and documentation skills.
Challenge 8
Turning Data Into Business Insights
Challenge
Anyone can generate numbers.
A Data Analyst must explain what those numbers actually mean.
Solution
For every project I focused on answering business questions:
- Which products perform best?
- Where is revenue growing?
- Which funnel stage loses customers?
- What actions should businesses take?
This mindset transformed technical work into business analysis.
Challenge 9
Professional GitHub Documentation
Challenge
Writing code is only half the job.
Presenting projects professionally is equally important.
Solution
I created consistent repositories with:
- Detailed README files
- Professional documentation
- SVG animations
- Shields.io badges
- Folder organization
- Screenshots
- Business explanations
These repositories became portfolio-quality projects rather than simple assignments.
Challenge 10
Building My Own Data Analyst Portfolio Website
Challenge
Instead of simply uploading four GitHub repositories, I wanted to create something unique.
Solution
I designed and developed a complete interactive portfolio website using Next.js and TypeScript.
The website includes:
- Internship Overview
- Four Complete Projects
- GitHub Repositories
- LinkedIn Posts
- YouTube Project Videos
- Skills Learned
- Challenges Solved
- Password-Protected Certificate Section
- Resume Download
- Modern Responsive UI
- SEO Optimization
This project combined my web development background with my newly acquired Data Analytics skills, creating a portfolio that reflects both technical implementation and professional presentation.
What This Internship Really Taught Me
This internship wasn't just about learning Excel, Python, SQL or Power BI.
It taught me:
- How to research independently.
- How to debug unfamiliar problems.
- How to organize professional projects.
- How to document technical work.
- How to communicate business insights.
- How to keep learning when solutions aren't immediately obvious.
These lessons will remain valuable long after the internship ends.
Final Thoughts
Looking back, the dashboards and repositories represent only the visible outcome.
The real achievement was overcoming every obstacle that appeared along the way.
Every error message, every failed installation, every debugging session, and every rewritten query contributed to my growth as a Data Analyst.
The internship has ended—but the learning journey continues.
Thank you, LogicStack, for providing a practical environment where I could build real projects, solve real problems and gain valuable industry experience.
Connect With Me
🌐 Portfolio
https://yasirawaninfo-data.vercel.app/
💻 GitHub
https://github.com/YasirAwan4831
💼 LinkedIn
https://linkedin.com/in/yasirawan4831
Thank you for reading. If this journey inspires someone starting their own Data Analytics path, then sharing these experiences has been worthwhile.
_#DataAnalytics #SQL #SQLite #PowerBI #BusinessIntelligence #DataVisualization #Dashboard #GitHub #Internship #LogicStack #DataAnalyst #LearningJourney #OpenToWork #Portfolio #YasirAwan4831 _
Top comments (0)