BHARGAV CHOUDHURY
Guwahati
Summary
Dynamic Senior Data Analyst with a proven track record at Appstix Technologies, adept at leveraging Power BI for impactful data visualization and trend analysis. Enhanced sales by 10% through actionable insights while mentoring over 500 students in data techniques. Skilled in DAX and effective communication, driving data-driven decision-making.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Appstix Technologies Pvt Ltd
03.2021 - 12.2024
- Company Overview: Appstix Technologies Pvt Ltd is a leading technology solutions provider specializing in innovative software development, data analytics, and business intelligence services to help businesses drive growth and efficiency.
- Streamlined monthly reporting by automating data extraction and visualization processes using Power BI, leveraging advanced features such as DAX, Power Query, and data modeling for efficient and dynamic reporting
- Designed dynamic Power BI dashboards with interactive filters, enabling senior management to monitor real-time business KPIs and make data-driven decisions
- Performed trend analysis on customer and sales data using Power BI, identifying patterns that contributed to a 10% increase in sales through interactive visualizations and insights
- Conducted complex data analysis, including forecasting and trend analysis, using Power BI's advanced analytics tools – DAX, forecasting models, and regression analysis
Data Analyst and Instructor
JTPC
Guwahati
05.2017 - 01.2021
- Company Overview: An organization offering training in data analysis and programming
- Developed monthly reports and dashboards using Excel that provided actionable insights into business performance
- Instructed and mentored 500+ students in data analysis and Excel techniques, guiding them through the use of data tools, statistical methods, and automation for real-world applications
- Conducted workshops and training sessions, equipping learners with the skills to analyze and visualize data effectively using Excel
- Provided hands-on support to students, helping them build practical skills in Excel-based data manipulation, automation, and analysis
- An organization offering training in data analysis and programming
Education
Bachelor of Engineering - Computer Science
VTU
KarnatakaSkills
- Data Analysis & Statistical Techniques: Exploratory Data Analysis, Statistical Analysis, Hypothesis Testing, Regression Analysis, Trend Analysis, Forecasting Techniques, Data Quality
- Programming Languages & Libraries: Python, R, Pandas, Numpy, Matplotlib, Seaborn, Anaconda
- Business Intelligence & Visualization Tools: Power BI, Tableau, Data Visualization, Dashboard Design, DAX Functions
- Database Management & SQL: MySQL, SQL, Database Management, Data Extraction, Data Manipulation, Data Structures
- Advanced Excel: Advanced Excel, Pivot Tables, Power Query, VLOOKUP
- Machine Learning & Data Modeling: Machine Learning, Data Modeling
- Soft Skills: Effective Communication, Team Collaboration, Customer Insights
Websites
Accomplishments
- Automated reporting process, reducing time by 40% using Excel and SQL.
- Enhanced sales by 10% through trend analysis and customer data insights.
- Mentored 500 students, fostering skills in practical data analysis and Excel.
Projects
Inbound Interaction Analytics,
10/01/24, 11/01/24,
Inbound Call Analytics project aimed at improving customer satisfaction through data analysis.,
Analyzed inbound call data for the CX team using Power BI, covering 23 days and key metrics such as agent names, queue times, call durations, and call statuses (abandoned, answered, transferred) to assess team performance.,
Leveraged Power BI dashboards to identify trends and provide data-driven insights, helping the CX team improve customer interactions and enhance overall customer satisfaction using AI tools like IVR, RPA, and predictive analytics.
Recruitment Optimization Analysis,
08/01/24, 10/01/24,
Project focusing on analyzing hiring process metrics to uncover hiring patterns., Analyzed the company's hiring process focusing on gender distribution, salary analysis, departmental composition, and position tiers., Uncovered key insights regarding hiring patterns and organizational dynamics.
Languages
- English
- Hindi
- Assamese
Certification
Microsoft Excel Certification.
Languages
English
First Language
Hindi
Proficient (C2)
C2
References
References available upon request.
Timeline
Senior Data Analyst
Appstix Technologies Pvt Ltd
03.2021 - 12.2024
Data Analyst and Instructor
JTPC
05.2017 - 01.2021
Bachelor of Engineering - Computer Science
VTU
Similar Profiles
Chaithra Chaithra null
Software Test Engineer at appstix solution pvt ltdSoftware Test Engineer at appstix solution pvt ltd
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)
S ChetanS Chetan
Assistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt LtdAssistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt Ltd