Hello, I'm Syed Arshad Hussain, a passionate Data Analyst. Below you'll find links to some of my projects, along with my professional profile details. Feel free to explore my repositories and connect with me if you have any questions or collaboration ideas!
- Name: Syed Arshad Hussain
- Role: Data Analyst
- Email: [email protected]
- LinkedIn: (https://www.linkedin.com/in/arshadhussain-analyst/)
- PORTFOLIO: (https://www.datascienceportfol.io/hussainsyedarshad)
Here are some of the repositories I've been working on:
PROJECT - 1 -OTT MERGE ANALYSIS**: ๐ฅ๐ Strategic Merger Insights in the OTT Domain This project was part of the Codebasics Resume Project Challenge #14 and focused on uncovering actionable insights to support a strategic merger between LioCinema and Jotstar, two leading Indian OTT platforms.
๐ Project Objective Evaluate platform performance, user behavior, and content consumption patterns to help establish Lio-Jotstar as India's #1 OTT platform.
๐ Scope of Analysis
Subscriber Trends: Growth patterns, inactivity rates, upgrades, and downgrades
Content Insights: Language diversity, content type preferences
Engagement Analysis: Watch time by device and city tier
๐ Tools & Technologies Used
Power Query: For data cleaning & transformation
Excel: For early-stage data preparation
MySQL: For deep-dive data analysis using SQL
Power BI: For building interactive dashboards & visualizations
๐ก Key Insights
Subscriber Growth:
LioCinema grew 5x in 2024, but 45% of its users are inactive
Jotstar has 85% active paid users, despite a smaller base
๐ Content Diversity:
Jotstar dominates with English/Hindi content for urban users
LioCinema leads in regional content (Tamil, Telugu)
๐ฐ Revenue Trends:
Jotstar earns 2x more revenue than LioCinema, but lacks growth momentum
๐ Strategic Takeaways
Boost Engagement: Reactivate LioCinema's dormant users
Monetization Strategy: Adapt Jotstar's success formula for paid plans
Content Optimization: Align content offerings to serve a broader audience post-merger.
PROJECT -2 - FESTIVAL SALES ANALYSIS**: Atliq Mart, a retail giant with over 50 supermarkets, recently ran massive promotions during Diwali 2023 and Sankranti 2024 on their Atiq branded products. As the sales director wanted immediate insights into the success of these promotions, I took charge of analyzing the data and presenting key findings.
๐ Leveraging SQL and PowerBI, I dove into the data provided by our stakeholders to uncover which promotions performed well and which ones didn't. To streamline the analysis process and avoid repeating code, I created a view in SQL called "sales summary," which provided a consolidated overview of sales data.
๐ Through my video presentation and PowerBI dashboard, I walked through the tasks undertaken and the compelling findings discovered.
๐ ๐๐ฒ๐ ๐ง๐ฎ๐๐ธ๐ ๐ฎ๐ป๐ฑ ๐๐ถ๐ป๐ฑ๐ถ๐ป๐ด๐:
๐๐ฎ๐๐ฎ ๐๐ ๐ฝ๐น๐ผ๐ฟ๐ฎ๐๐ถ๐ผ๐ป: I meticulously explored sales data, examining trends, customer behavior, and product performance during the festive period. ๐ฃ๐ฟ๐ผ๐บ๐ผ๐๐ถ๐ผ๐ป ๐๐ณ๐ณ๐ฒ๐ฐ๐๐ถ๐๐ฒ๐ป๐ฒ๐๐: Using SQL queries, I assessed the impact of various promotions on sales volume, revenue, and customer engagement. ๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ ๐๐ฎ๐๐ต๐ฏ๐ผ๐ฎ๐ฟ๐ฑ: To visualize the results, I created an interactive Power BI dashboard. It revealed which promotions resonated with customers and which fell short. ๐ฏ ๐๐บ๐ฝ๐ฎ๐ฐ๐:
โช Increased sales by 107.64% during Diwali and 113.58% during Sankranti. โช Identified top-performing products and category. โช Uncovered hidden patterns that will inform marketing decisions.
PROJECT - 3- EXCEL-FINACIAL-ANALYSIS**:Created a report for AtliQ Hardwares
AtliQ Business Model ๐ป
๐น Hardware company that sell peripherals like PC, Mouse, Keyboard , Printers to Clients across the world.
Problem Statement ๐
๐น To create a Finance and Sales report to improve the Gross Margin and overall Net Sales.
Finance Analytics
๐น Analyzed financial metrics such as Net Sales, COGS (Cost of Goods Sold), Gross Margin, and GM% (Gross Margin Percentage) on a monthly, quarterly, and annual basis for the fiscal year
Sales Analytics
๐นAnalyzed sales data to assess Customer performance, Market performance against targets, Top 10 products, Division-level reports, Top and Bottom 5 products by Quantity, as well as New products and the Top 5 Markets.
Technical & Soft Skills:
Proficiency in ETL methodology (Extract, Transform, Load). Skills to generate a date table using Power Query. Ability to derive fiscal months and quarters. Establishing data model relationships with Power Pivot. Proficiency in incorporating supplementary data into an existing data model. Utilizing DAX to create calculated columns. Soft Skills:
Refined understanding of Finance & Sales Reports Designing user-centric reports with empathy in mind. Optimization of report generation through meticulous fine-tuning. Developing a systematic approach to devising a report building plan.
About No description, website, or topics provided. Resources Readme Activity Stars 0 stars Watchers 0 watching Forks 0 forks Releases No releases published Create a new release Packages No packages published Publish your first package Footer ยฉ 20
Feel free to explore and give feedback!
- Data Analysis
- Python (Pandas, NumPy, Matplotlib, Seaborn)
- SQL
- Machine Learning
- Data Visualization
You can reach me via email or connect with me on LinkedIn.