Portfolio - ANIRUDDHA BISWAS

Hello, I am

ANIRUDDHA BISWAS

Data Analyst

About Me.

I am an aspiring Data Analyst with a background in Business Administration (BBA) and over six years of experience in administrative roles. My expertise in managing records, preparing reports, and ensuring operational efficiency has strengthened my analytical skills.

Proficient in Excel, Power BI, SQL, and Python, I specialize in data visualization, reporting, and trend analysis to drive business insights. While I haven't worked in a formal data analyst role yet, I have completed multiple business projects, applying my skills to solve real-world challenges.

My portfolio showcases my ability to work with complex datasets, identify key trends, and present insights effectively. I am eager to apply my skills in a professional setting and contribute to data-driven decision-making.

Explore my portfolio to see my work in action!

1

Excel Project

1

PowerBI Project

Skills.

Microsoft Excel

MySQL

Power BI

Python

Tableau

Alteryx

SPSS

Projects.

My Experience.

EduBest – Senior Administrative Officer
(Dec 2016 - Present)

Maintained accurate records for 300+ students and optimized facility scheduling, increasing resource efficiency by 20%.
Automated salary disbursement for 100+ employees monthly, reducing processing time by 30%.
Delivered 50+ detailed reports, facilitated 20+ meetings, and organized 10+ events annually to support decision-making.

AtliQ Technologies – Data Analyst Intern
(Nov 2024 - Dec 2024)

Conducted thorough data variance analysis and debugged over 50 complex SQL queries in MySQL Workbench, ensuring precise extraction of critical insights that directly informed reporting for senior management decisions.
Cleaned and normalized 1M+ rows of data, improving retrieval efficiency by 25%.
Created 5 interactive dashboards in Power BI, enhancing decision-making for 10+ stakeholders.

Awards & Certificate.

SQL Beginner to Advanced For Data Professionals

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Scam Awareness Course

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Contact.

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download CV

[email protected]

Call Me

+91 9088081313

https://www.linkedin.com/in/aniruddha-biswas/

GitHub

https://github.com/ANIRUDDHA-BISWAS

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

Domain/Function: Sales & Finance

Designed and optimized Sales Performance & Finance reports to assess sales trends, evaluate market performance against targets, monitor key metrics, and analyze financial outcomes. These insights enhanced decision-making and improved resource allocation.

View Project
Engagement

View Project
on GitHUB

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

It highlights the top 5 and bottom 5 products based on quantity sold. The top products are displayed in green, while low-performing products.

Profit & Loss (P&L) based on the market for AtliQ Hardwares, displaying Net Sales, COGS, Gross Margin, and Gross Margin%.

Project Details

AtliQ Hardwares, a global hardware leader, faced the challenge of optimizing sales and enhancing net gross margins. I analyzed over half a million records of unorganized sales data using extensive ETL techniques to extract strategic insights and improve company performance, focusing on net sales and net gross margin.

Key Operations Performed:
- Conducted extensive ETL (Extract, Transform, Load) processes to organize the sales data.
- Created detailed Profit and Loss (P&L) reports by various categories.
- Developed customer net sales and market vs. target performance reports.
- Established data model relationships and utilized DAX for calculated columns.

Key Learnings :
- The power of data analytics in uncovering hidden business opportunities.
- The importance of data quality and organization for actionable insights.
- The role of ETL processes in preparing data for analysis.

PowerBI Project

Business insights 360, AtliQ Hardware

Domain/Function: Finance, Sales, Marketing and Supply Chain

View Project
Engagement

View Project
on GitHUB

User--Centric Landing Page for a Seamless and Engaging Dashboard Experience.

Comprehensive Executive Insights Page for Strategic Decision-Making and High-Level Analytics.

Project Details

AtliQ Technologies, a fast-growing hardware company specializing in peripherals, faced significant challenges in Latin America. My project, Business Insights 360, was crafted to help them overcome these challenges through data-driven decision-making.

⚡ Project Highlights:
➡ Finance View
➡ Sales View
➡ Marketing View
➡ Supply Chain View
➡ Executive View

🕹 Learning Journey:
▶ Project Planning and Scoping.
▶ SQL Connector to Power BI.
▶ Power BI Tool Introduction.
▶ Power Query & M Language
▶ DAX (Data Analysis Expressions)
▶ Data Modeling
▶ Bookmarks & Page Navigation
▶ Excel Integration

💡 Business Terms Covered:
Gross price | Net sales | Net invoice sales | Pre-invoice deductions | post-invoice deductions | Manufacturing cost | Freight cost | Cost of Goods Sold (COGS) | Gross Margin | Operational Expenses | Net Profit | FY - Financial Year/Fiscal Year | YTD - Year to Date | YTG - Year to Go .