Diploma in Data Analytics and Visualization

Choose the type of account

You can sign up as an individual instructor or an academy owner. See the difference below.

Academy Owners

done
Can create & share study material and practice tests
done
Can publish courses and batches
done
Can invite a team of instructors to teach
done
Can collect reviews and ratings on their academy profile
done
Can promote courses, enroll learners & collect payments

Learn More

Independent Instructors

done
Can create & share study material and practice tests
close
Cannot publish courses or create batches
done
Can schedule classes and teach online, but as an instructor of an academy
done
Can collect reviews and ratings on their instructor profile
close
Since they cannot publish courses, they can't enroll learners & collect payments

Learn More

Starts at

₹47,200 Inclusive of GST

What you'll be able to do after completing these classes

done Develop skills in Excel, VBA, SQL, Power BI; capable of handling roles like MIS Executive, Data Analyst, Business Analyst, and Reporting Analyst.
done Acquire real-life experience through training based on actual corporate projects and challenges.
done Learn efficient use of AI tools, accelerate data-driven decision making, and be at par with modern organization standards.

person_outline Week 1: Excel interface, professional data handling, and preparation/cleaning techniques.

expand_more

person_outline Week 2: Advanced formulas: VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, and COUNTIFS.

expand_more

person_outline Week 3: Logic, text, and date functions; conditional formatting; data validation.

expand_more

person_outline Week 4: Pivot Tables/Charts; building MIS reports and interactive dashboards.

expand_more

person_outline Week 5: Introduction to Macros; recording/editing; basics of VBA environment.

expand_more

person_outline Week 6: VBA programming: Variables, loops, conditional logic (If/Then), and automating repetitive tasks.

expand_more

person_outline Week 7: Advanced automation: Event-based triggers, User Forms, and custom function creation.

expand_more

person_outline Week 8: Database concepts, DDL/DML, and core SQL queries (SELECT, WHERE, ORDER BY).

expand_more

person_outline Week 9: Data filtering, sorting, aggregation (GROUP BY, SUM, AVG), and HAVING clause.

expand_more

person_outline Week 10: Relational database design: JOIN operations (Inner, Left, Right), subqueries, and table relationships.

expand_more

About the course

This comprehensive 16-week course, delivered by leading corporate training organization Webs Jyoti, is designed to help learners master Excel, VBA, SQL, and Power BI—tools integral to roles such as MIS Executive, Data Analyst, and Business Analyst. Drawing on a decade-long legacy of 160 corporate trainings and 75,000 learners, the curriculum is rooted in real-world workplace challenges, utilizing practical datasets and case studies from companies like Nestle and MakeMyTrip. The training spans from foundational Excel to advanced functions like XLOOKUP, INDEX-MATCH, and dynamic arrays, empowering participants to manage extensive datasets and create professional dashboards for business decision-making. Beyond spreadsheet management, learners will master automation through VBA Macros, data extraction and analysis via SQL, and interactive visualization using Power BI and Power Query. A modern highlight of the course is the introduction to AI-assisted analysis with Microsoft Copilot, enhancing productivity through AI-driven insights. Under the guidance of Hirdesh Bhardwaj, a corporate trainer with over 17 years of experience, participants receive personalized attention to ensure they are fully equipped to excel in the global corporate landscape.

2 enrollment options available

Mar 1 (Sun)

3:00 PM

location_on

Mon Tue Wed Thu Fri Sat Sun

Yuno Learning

Mar 1 (Sun)

10:00 AM

location_on

Mon Tue Wed Thu Fri Sat Sun

Yuno Learning