- Home
- All Courses
- Courses
- Mastering Business and Data Analytics
Curriculum
- 4 Sections
- 25 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Module 1:Excel (4 Class)4
- Module 2: PowerBi (11 Class)11
- 2.1Class 01: Power BI Basics
- 2.2Class 02: Data Loading & Transformation
- 2.3Class 03: Data Modeling, Basic DAX and Starting Portfolio Project 01
- 2.4Class 04: DAX Functions & Visualization Essentials
- 2.5Class 05: Advanced DAX & Project Visualization
- 2.6Class 06: Interactive & Map Visualizations
- 2.7Class 07: Advanced Report Customization
- 2.8Class 08: Finalizing & Deploying Project 01
- 2.9Class 09: Starting Portfolio Project 02 – Cohort & RFM Analysis
- 2.10Class 10: Advanced DAX for Cohort & RFM Analysis
- 2.11Class 11: Course Completion & Final Projects
- Module 3: Final Discussion and Career Path (1 Class)1
- Additional Module (Free Recorded SQL Videos) : SQL (9 Class)9
- 4.1Class 1: Environment Setup and Support
- 4.2Class 2: Introduction to SQL, Databases, Data Types, Primary & Foreign Keys, and Constraints
- 4.3Class 3: Creating Tables and Databases in SQL
- 4.4Class 4: Data Manipulation: INSERT, UPDATE, DELETE & ALTER Table
- 4.5Class 5: SELECT Statement, WHERE Clause, Importing Excel (CSV) Files & Aggregate Functions
- 4.6Class 6: Functions in SQL, GROUP BY, HAVING, Time Functions & Subqueries
- 4.7Class 7: SQL JOINS – Types & Syntax
- 4.8Class 8: SELF JOIN, UNION & UNION ALL
- 4.9Class 9: Window Functions, CASE Statements & CTEs
Class 02: VLOOKUP & Financial Charts
Next