Introduction
Every learning journey begins with a single decision.
For me, that decision was to step into the world of Data Analytics—a field that combines problem-solving, business understanding, and technology to transform raw data into meaningful insights.
When I joined the Logic Stack Data Analyst Internship, I wasn't simply looking to complete another internship. My goal was much bigger: I wanted to build practical skills, work on real-world projects, document every step professionally and create a portfolio that genuinely reflected my growth.
Over the course of one month, I worked on multiple projects involving Excel, Python, SQL, Power BI, GitHub, technical documentation, and portfolio development. Every week introduced new concepts, new challenges and new opportunities to improve.
This blog shares my complete journey—from the first day of the internship to the completion of the final project. Rather than focusing only on the outcomes, I want to share the process, the lessons I learned and how each project helped me grow as an aspiring Data Analyst.
Why I Chose This Internship
The field of Data Analytics has become one of the fastest-growing domains in technology. Organizations across every industry rely on data to make better decisions, optimize operations, and understand customer behaviour.
I wanted hands-on experience with the tools and workflows used by professionals instead of learning only through theory.
This internship provided exactly that opportunity.
It focused on:
- Practical business datasets
- Real analytical workflows
- Professional documentation
- Dashboard development
- Industry-standard tools
- Portfolio building
Instead of completing isolated exercises, every week contributed to a larger learning journey.
About the Logic Stack Internship
The internship was designed as a structured four-week program where every week introduced a new challenge.
Rather than repeating similar exercises, each project focused on solving a different business problem using different analytical techniques.
Throughout the internship I worked with:
- Microsoft Excel
- Python
- Pandas
- NumPy
- SQL (SQLite)
- Power BI
- GitHub
- Technical Documentation
Every project required not only completing the technical work but also presenting it professionally through GitHub repositories, documentation, dashboards, screenshots and project reports.
My Goals Before Starting
Before beginning the internship, I set a few personal goals for myself:
- Learn modern Data Analytics tools through practical work.
- Improve my analytical thinking.
- Build projects suitable for a professional portfolio.
- Learn proper GitHub documentation.
- Create dashboards that communicate business insights effectively.
- Gain confidence working with real datasets.
Looking back now, these goals helped me stay focused throughout the internship.
Week 1 – Learning the Foundations
The first week focused on building a strong analytical foundation.
Instead of jumping directly into advanced visualization, the emphasis was placed on understanding datasets, identifying business questions, cleaning information and extracting useful insights.
This project taught me that successful data analysis begins long before dashboards are created.
Some of the concepts I worked on included:
- Understanding structured datasets
- Data cleaning
- Exploratory analysis
- Identifying patterns
- Basic business insights
- Professional project documentation
More importantly, I learned how to organize a project professionally from the beginning—a habit that became extremely valuable during the following weeks.
GitHub Repository: https://github.com/YasirAwan4831/week-1-retail-sales-excel-analysis
YouTube Video: https://youtube.com/shorts/-vCaOvUj-DA?si=4DzXsE1v3Idt84xs
LinkedIn Post: https://www.linkedin.com/posts/yasirawan4831_excel-logicstack-dataanalyst-activity-
Week 2 – Building Analytical Confidence
The second week pushed my skills further.
The datasets became larger, the questions became more analytical and the expectations shifted from simply calculating values to explaining business performance.
This project strengthened my ability to:
- Interpret business metrics
- Compare trends
- Identify opportunities
- Present findings clearly
- Think from a business perspective instead of only a technical perspective
One important lesson from this week was that data alone has very little value unless it is converted into actionable insights.
That mindset completely changed how I approached the remaining internship projects.
GitHub Repository: https://github.com/YasirAwan4831/week-2-excel-powerbi-sales-dashboard
YouTube Video: https://youtube.com/shorts/JLg-B-rs0gE?si=kCWG7KHxdxw2d-Pa
LinkedIn Post: https://www.linkedin.com/posts/yasirawan4831_weekabr2-excel-powerabrbi-activity-
Continuing the Journey...
By the end of the first two weeks, I had gained confidence working with datasets, understanding business requirements, and documenting projects professionally.
However, the most challenging—and most rewarding—part of the internship was still ahead.
In the next part of this journey, I'll cover:
- Week 3: Supply Chain Analytics with Python & Power BI
- Week 4: SQL + Power BI Funnel Analysis
- Building production-quality GitHub repositories
- Creating a modern Data Analytics Portfolio Website
- Earning my internship completion certificate
- Key lessons and reflections from the entire experience
The second half of this journey represents the point where I transitioned from completing internship tasks to building projects that reflect my professional capabilities as a Data Analyst.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---------------------------------------------------
#DataAnalytics #Portfolio #SQL #PowerBI #Python #Excel #GitHub #WebDevelopment #LearningInPublic #CareerGrowth #OpenToWork Muhammad Yasir #MuhammadYasir #YasirAwan4831
-
