Portfolio - Nikita Agrawal

About Me

Hello! 👋 I'm Nikita Agarwal, a Business Analyst transitioning into data analytics. With a strong engineering background, I offer a unique blend of technical expertise and analytical precision. My passion lies in using data to drive impactful decisions and optimize processes.

Why Choose Me?

📊 Analytical Mindset: My working experience enables me to tackle complex problems with clarity and precision.

🛠️ Data Tools Enthusiast: I am mastering tools like Excel, PowerBI, MySQL, and Python to stay ahead in data analytics.

🧮 Problem-Solver: I leverage data-driven insights to address real-world challenges and seek innovative solutions.

🔍 Detail-Oriented: My keen attention to detail ensures accurate data interpretation and reporting for confident decision-making.

🌟 Passion for Growth: I am committed to continuous learning, always seeking to expand my knowledge and skills in data analytics. I'm excited to apply my unique background and skills to the world of data analysis.

Key Skills

Power BI

SQL

Excel

Effective Communication

Problem solving

My Projects

Business Insights 360 Dashboard: Finance, Sales, Marketing and Supply Chain

Domain/Function: 360 Business Analytics

Atliq Hardware Analytics

Domain/Function: Sales & Finance Performance Analytics

Analysis and Insights on Consumer Goods data

Domain/Function: Consumer Goods

Swiggy-Delivery-Insights-Project

Domain/Function: Consumer Goods

IPL Auction 2024 – Data Analytics Dashboard

Domain/Function: Sports Analytics / Cricket Data Visualization

My Experience

TraceNcode, Indore– Data Analyst
May 2024 - Present

Wrote SQL queries to extract customer and transaction data from relational databases for weekly/monthly reporting.

Performed monthly revenue forecasting and trend analysis using SQL + Excel; supported capacity planning.

Built and managed Power BI dashboards to visualize KPIs like revenue, user growth, daily sales, and retention trends.

Cleaned and prepped large datasets using Excel (VLOOKUP, PivotTables, Power Query) and basic Python (Pandas).

Collaborated with marketing and sales teams to deliver data-driven insights and automated reporting processes.

Technovate Solution, Ahmedabad– Business Analyst
Aug 2023 - April 2024

Gathered requirements and supported ERPNext implementation for 12+ clients, improving delivery timelines by 20%.
Built internal dashboards using Power BI to track lead conversions, onboarding status, and support ticket metrics.
Analyzed Gitex 2023 lead data (100+ contacts) using SQL and visualized insights in Power BI by region, industry, and lead status.
Extracted and validated ERPNext data via SQL queries, supporting reporting accuracy and performance tracking.
Represented the company at Gitex Global 2023, delivering 30+ demos and generating 15+ qualified leads

=========================

Prometteur Solutions, Pune – Sr. Business Development Executive

Jun 2021 – Aug 2023

Prospected and analyzed 500+ leads via Upwork, LinkedIn, and website, increasing lead quality by 20%.
Prepared BRDs, proposals, and wireframes that helped close $200K+ in deals.
Collaborated with the dev team to scope 30+ projects, improve pricing accuracy, and define payment milestones.
Designed and presented Power BI sales dashboards during internal reviews meetings to highlight deal status, pipeline stages, and lead sources.
Pulled data from Zoho CRM and Upwork exports, cleaned it using Excel, and built interactive dashboards with key KPIs like total leads, win ratio, average deal value, and source-based conversion

=========================

Qualwebs Software Services, Indore – Business Development Executive
Jan 2019 – Jun 2021

Managed 100+ bids monthly across Upwork, Freelancer, and Guru, maintaining a 12% win rate.
Helped define project estimates and pricing strategies, resulting in 15% increase in project acceptance.

Awards & Certificate