Internship (Business Analytics & Reporting)
Intas Pharmaceuticals
Ahmedabad, Gujarat, IndiaFresher1h agovia LinkedIn
Posted 20 Nov 2026, 10:12 IST
This job at a glance
- Who can apply
- Freshers and up to 1 year · BCA or MCA
- Must know
- Data analysisBusiness analysisOperationsExcelStakeholder managementStatistics
- Nice to have
- Data visualizationPower BISQL
- Work
- On-site in Ahmedabad · internship
- Pay
- Not stated by the employer.
- Skill demand
- Excel20%Operations15%Data analysis3%Business analysis3%of 150 similar fresher jobs posted in India this week
- Listed
- 20 Nov 2026 · still open
Sign in free to see which of these skills your resume already shows.
About the Role
We are looking for enthusiastic and analytical BCA/MCA freshers who are passionate about data analysis, business reporting, and transforming data into meaningful insights. The selected candidates will work closely with business teams to create reports, dashboards, and data-driven solutions that support decision-making across various functions.
- Position: Business Analytics Intern (6 Months Paid Internship) / Business Analytics Apprentice (11 Months Apprenticeship)
- Location: Ahmedabad
- Department: Business Analytics / HR Analytics / Commercial Excellence / Operations Analytics
- Stipend: As per company norms
Key Responsibilities
- Analyze business data and generate actionable insights.
- Develop and maintain MIS reports using Advanced Microsoft Excel.
- Create interactive dashboards and reports using Power BI.
- Collect, clean, validate, and organize large datasets from multiple sources.
- Prepare weekly, monthly, and ad-hoc business reports.
- Monitor key performance indicators (KPIs) and performance metrics.
- Support automation initiatives through Excel formulas, Power Query, and reporting tools.
- Identify trends, patterns, and business opportunities through data analysis.
- Collaborate with stakeholders to understand reporting requirements.
- Present data findings through charts, graphs, and dashboards.
Requirements & Tech Stack
- Strong knowledge of Advanced Microsoft Excel, including:
- VLOOKUP/XLOOKUP
- Pivot Tables & Pivot Charts
- Conditional Formatting
- Data Validation
- Advanced Formulas and Functions
- Power Query (Preferred)
- Dashboard Creation
- Basic to Intermediate knowledge of Power BI:
- Data Modeling
- DAX Fundamentals
- Power Query
- Dashboard Development
- Report Publishing
- Basic understanding of:
- Data Analysis Techniques
- Business Intelligence Concepts
- Statistics and Data Interpretation
- SQL (Preferred)
- Data Visualization Best Practices
Qualifications
- BCA or MCA from a recognized university.
- Freshers or candidates with up to 1 year of experience can apply.
- Strong analytical and problem-solving abilities.
- Attention to detail and accuracy.
- Good communication and presentation skills.
- Ability to work with large datasets.
- Quick learner with a proactive attitude.
- Team player with strong organizational skills.