- Tutorials
- Courses
- Tracks
Complete Data Analytics - Live
Unlock the power of data! Elevate your expertise with our Mastering Data Analytics Course. Gain proficiency in Python, SQL, Excel, and Tableau for data analysis, visualization, and reporting. Explore hands-on, real-world projects and much more.
For further queries, reach us via Call/WhatsApp at: +91- 8130806418
Course Overview
Key Highlights
- 30+ hours of beginner to advanced self-paced content
- Hands-on practice with real-world datasets
- Learn industrial tools: Excel, SQL, Python, Pandas, NumPy, Jupyter, Tableau, Power BI & more
- Work on multiple real-life projects and implementations
What Sets Us Apart
24 X 7 Doubt Support
Recognised Certification
Projects Covered
Complimentary Course Access
AI Chat Support 24/7 – A dedicated service provided with this course for free to help you overcome any doubt, at any time, and anywhere.
Note: If you are not happy with the AI agent, then you will be connected with our course Teaching Assistant.
Teaching Assistant Support – Every class includes a dedicated doubt-clearing session where you can raise queries with the Teaching Assistant assigned to your batch.
Read moreWhat Sets Us Apart
AI Chat Support 24/7 – A dedicated service provided with this course for free to help you overcome any doubt,
Earn an industry-recognised GeeksforGeeks Certificate of Completion by fulfilling the course requirements.
Perks of our certif
- E-Commerce Product Analysis with Excel & Python
- Movie Industry Analysis using SQL
- Food Industry Data Analysis
- 100K Books Dataset Analysis
-
1-year access to the online course materials and recorded videos
-
Read more...
Course Content
Day 1: Introduction to Excel for Data Analysis
- Overview of Excel interface
- Basics of navigating and working with sheets
- Introduction to cells, rows, columns, and ranges
- Understanding basic functions (SUM, AVERAGE, COUNT)
- Working with mathematical and statistical functions
- Introduction to text functions for data manipulation
Day 2: Advanced Formulas and Functions
- Working with logical functions (IF, AND, OR)
- Exploring lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Introduction to array formulas
- Identifying and handling missing data
- Removing duplicates and dealing with errors
- Text-to-columns and data-splitting techniques
- Formatting data for analysis
- Creating basic charts and graphs
- Tips for effective data presentation
- Introduction to PivotTables for dynamic data analysis
- Creating PivotCharts for visual insights
- Customizing and formatting PivotTables and PivotCharts
- Time-saving shortcuts and productivity hacks
- Excel with AI
Day 1: Introduction to SǪL and Database Fundamentals
- Overview of SǪL and its applications
- Introduction to Relational Databases
- Basic SǪL syntax and structure
- Creating and modifying tables with CREATE and ALTER
- Understanding data types and constraints
Day 2: Retrieving Data with SELECT Statements
- Basics of SELECT statements
- Filtering data with WHERE clause
- Sorting results with ORDER BY
Day 1: Aggregation and Grouping
- Understanding aggregate functions (SUM, AVG, COUNT)
- Grouping data with GROUP BY
- Working with complex WHERE conditions
- Using operators (AND, OR, NOT, etc)
Day 2: Window Functions and Analytic Ǫueries
- Introduction to window functions
- Performing analytic queries with OVER clause
Day 1: Joins and Subqueries
- Performing INNER and OUTER joins
- Using subqueries for complex queries
Day 2: Case Statements and CTE Ǫueries
- Understanding and using CASE statements in SǪL
- Applying CASE statements in data analysis scenarios
- Introduction to Common Table Expressions
- Using CTEs for recursive queries and data manipulation
