Hitesh Ranga Data Analyst | Business Analyst
No reviews yet

►

Experienced Data Analytics Professional | 8 Years Industry Expertise | Python, SQL, Power BI, Excel

Hello! I’m Hitesh Ranga, a seasoned Data Analyst with over 8 years of real-world experience in data analytics, business intelligence, and automation. I spent 7+ years working with Maruti Suzuki, where I applied data-driven solutions to optimize business operations. Now, as the founder of Synthanalytix, I’m leading a successful Data Analytics with AI/Power BI Developer Training Program, already empowering 25+ students with hands-on, practical skills.

What I Offer:

1) Python for Data Analysis: Learn how to leverage Python for data manipulation, analysis, and visualization. I teach with real-world datasets to ensure you gain practical skills.

2) SQL Mastery: SQL is the backbone of data analysis, and I will guide you through every aspect, from basic queries to complex data transformations and optimizations, all while using industry-relevant tools like MySQL Workbench and SSMS.

3) Power BI for Business Intelligence: I’ll help you master Power BI, enabling you to create insightful, interactive dashboards that make data-driven decision-making easy for any business.

4) Excel for Advanced Analytics: Learn how to use Excel beyond basic spreadsheet tasks—pivot tables, data modeling, and advanced formulas to analyze large datasets efficiently.

5) Professional Resume Building, LinkedIn Profile Optimization, Data Analytics Interview Preparation.

6) ChatGPT and other generative AI tools use case to improve productivity.

Why Learn with Me?

Hands-On Learning: All my lessons are focused on practical skills, using real-world projects and examples that you can apply in any industry.

Industry Insight: With my deep understanding of data analytics in both manufacturing and business environments, I provide industry-focused knowledge that prepares you for real-world challenges.

Personalized Guidance: I ensure each student gets the individual attention they need, with custom learning paths tailored to your pace and skill level.

Whether you're just starting your journey in data analytics or looking to enhance your skills, I’m here to guide you every step of the way.

Let’s turn data into opportunities!

Subjects

Data analysis Beginner-Expert
Microsoft Power BI Beginner-Expert
Data analysis and visualization Beginner-Expert
SQL and Data warehousing Beginner-Expert
Resume Building Beginner-Expert

Experience

Founder (Jan, 2024–Present) at Synthanalytix

In January 2024, I embarked on a new venture as the Founder of Synthanalytix, a platform dedicated to providing freelance data solutions. My goal is to leverage my expertise in SQL, Python, and data visualization tools such as Power BI to help businesses harness the power of data for strategic decision-making.
Senior Engineer (Sep, 2016–Oct, 2023) at Maruti Suzuki India Limited ( India )

• Conduct thorough data analysis and generate insightful Power BI reports and dashboards on a daily basis.
• Collaborate with other departments to understand data needs and translate complex datasets into visually
appealing and user-friendly data visualizations.
• Design intuitive dashboards consisting of charts, graphs, maps, and KPIs using DAX scripts.
• Ensure data accuracy and consistency by collecting, cleaning, and transforming data from multiple sources.
• Optimize Power BI reports and dashboards for performance and responsiveness through aggregation,
indexing, and other techniques.
• Provide technical guidance and training to the users on how to effectively leverage the reports.

Education

PwC Switzerland - Power BI Job Simulation (Oct, 2023–Nov, 2023) from Forage
Microsoft Power BI Certification (Sep, 2023–Oct, 2023) from Udemy
SQL for Data Analysis (Aug, 2023–Sep, 2023) from LinkedIn Learning
Lean Six Sigma: Green Belt (Aug, 2023–Sep, 2023) from LinkedIn Learning
Data analyst Certification (Jun, 2023–Sep, 2023) from GROW DATA SKILLS
IBM Certification in Python for Data Science and AI (Jan, 2023–May, 2023) from Coursera
Bachelor's degree (Dec, 2017–Dec, 2020) from The Institution of Engineers (India), India

Fee details

₹600–2,000/hour (US$7.14–23.78/hour)

Courses offered

Power BI Developer
- US$7700
- Duration: 3 Months
- Delivery mode: Online
- Group size: 21 - 40
- Instruction language: Hindi
- Certificate provided: Yes
Live Classes 🗓️ starting from 1st September.

Course Language: Hindi

Groups for Students:
Group [B]: For Working Professionals: Live classes on Saturday and Sunday from 11:00 AM - 1:00 PM. Course Duration: 12 weeks approx.

Every enrolled student needs to join our student community on Discord.
Recordings of lectures will be provided on the Discord server.

Course Curriculum includes:
Database management
SQL (MSSQL/T-SQL & MySQL)
Power BI Data Connectivity & Transformation
Data Modeling, DAX & DAX Studio
Power BI Report Creation & Visualization
Power BI Dashboard Creation & Security
Power BI Services & Power BI Administration
Power Apps & Power BI Report Builder
Power BI Mobile
Azure SQL Database

Virtual Internships provided by Top MNCs:
Accenture: Data Analytics and Visualization
PwC Switzerland: Power BI
TATA Group: Data Visualization: Empowering Business with Effective Insights

Job Assistance:
Resume Building
Naukri.com profile creation and Optimization
LinkedIn profile creation and Optimization
Job portal access to apply for jobs
Professional tips related to connecting with Hiring Managers on LinkedIn

Certificates:
You will receive 5 certificates: a) Accenture: Data Analytics and Visualization b) TATA Group: Data Visualization: Empowering Business with Effective Insights c) PwC Switzerland: Power BI d) Synthanalytix: Power BI Developer e) Synthanalytix: Hackathon Participation
After completing this course, you can directly apply for: Microsoft Certified: Power BI Data Analyst Associate (PL-300) Exam (the most recognized Power BI certification globally)

Career Opportunities:
After this course, you can apply for jobs like Power BI Developer, Power BI Consultant, Data Analyst, Business Analyst, BI Analyst, Data Visualization Engineer.
You can also work as a freelancer.

We will conduct a hackathon competition at the end of the course, and the top 3 students will receive up to 80% cashback on the course price they paid! 🏆
We will also invite real industry Power BI experts for more guidance.

Who Can Apply:
Anyone can apply; you don't need a Computer Science educational background.
Even if you want to switch your career to the IT industry.
Even if you are currently a student.
Even if you want to upskill for promotions.
This course is for everyone.

A laptop and good internet connection are essential for this course.

Salary Expectations:
In this field, you can expect a salary between 9 LPA to 22 LPA or even more, depending on your experience.