Data Analytics and Data Management Live Bootcamp May 2025

Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Course sections

Section 1

Join Live Sessions

Join Data Analytics Live Classes

Section 2

Excel Recordings

01. 12 May 2025 Introduction & Understanding Excel Environment

02. 13 May 2025 Data Manipulation & Cleansing [Sum, Average, Count, CountA, Max, Min], Relative Referencing

03. 14 May 2025 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Paste Special] IF Statement

04. 15 May 2025 Mixed Referencing, Name Range, Structured Referencing, Sum & Sub total

05. 19 May 2025 Left & Right, Clean, Trim, Conditional Formatting

06. 20 May 2025 Sum & Subtotal, IF statement, CountIF

07. 21 May 2025 CountIF, SumIF, Index & Match, VLookUp, XLookUp

08. 22 May 2025 Index & Match, VLookUp, XLookUp, Dashboarding

09. 27 May 2025 Pivot Chat, Dashboarding

10. 28 May 2025 Dashboarding Cont.

Section 3

Power BI Recordings

11. 29 May 2025 Understanding Power BI Workflow, Power Query Environment, Data Model in Power BI

12. 2 June 2025 Process flow of PowerBI, Interface, Workflow, Power Query Editor

13. 3 June 2025 Fact & Dimension table, Star & Snowflakes Schema

14. 5 June 2025 Concept of Fact Dimension table, How to Download PowerBI, Data Manipulation & Modelling I

15. 09 June 2025 Data Manipulation & Modelling

16. 10 June 2025 Data Manipulation & Modelling II

17. 11 June 2025 Data Visualization, Creating Measures Using DAX

18. 12 June 2025 Group Work for the Excel Assignment

19. 16 June 2025 Plato Pizza Case Study

20. 17 June 2025 Plato Pizza Case Study [contd 1]

20. 17 June 2025 Plato Pizza Case Study [contd 2]

21. 18 June 2025 Plato Pizza Case Study [contd] Dashboard

22. 19 June 2025 Plato Pizza Case Study [contd 2] Dashboard

23. 23 June 2025 AVI Travel Survey Case Study

24. 24 June 2025 AVI Travel Survey Case Study [Contd]

25. 25 June 2025 IBM HR Analytics Employee Attrition & Performance Case Study

26. 26 June 2025 Real Estate Case Study

27. 30 June 2025 Real Estate Case Study [Contd] with Dashbord

28. 01 July 2025 Real Estate Case Study [Contd 2] with Dashbord

29. 02 July 2025 Real Estate Case Study [Contd 3] with Dashbord

30. 03 July 2025 Real Estate Case Study, Book Marking & Page Navigator

31. 07 July 2025 Call Centre Case Study

32. 08 July 2025 Call Centre Case Study [Contd]

33. 09 July 2025 Call Centre Case Study [Contd 2] Dashboard

34. 10 July 2025 Call Centre Case Study [Contd 3] Dashboard

35. 14 July 2025 Call Centre Case Study [Contd 4] Dashboard

36. 15 July 2025 Call Centre Case Study [Contd 5] Dashboard, Download PostgreSQL

Section 4

Postgre SQL

01. 16 July 2025 Meaning of Data, Database

02. 17 July 2025 Entity Relationship Diagram (ERD), DBMS, Database Creation on Postgre SQL, Importing Data into SQL

03. 21 July 2025 Basic SQL Syntax {Select, Distinct, Where, In, Between, And] Statements

04. 22 July 2025 Basic SQL Syntax [Limit, Order By Asc & Desc, Aggregate Functions, AS] Statements

05. 23 July 2025 Basic SQL Syntax [Group By, Having, Joins] Statements

06. 24 July 2025 JOINS [Inner, Left, Right, Full]

07. 28 July 2025 JOINS [Inner, Left, Right, Full] Contd

08. 29 July 2025 JOINS [Inner, Left, Right, Full] Contd 3

09. 30 July 2025 JOINS & CONCAT

10. 31 July 2025 Case Statement & Sub Queries

11. 04 Aug 2025 Fraudulent Transaction Case Study

12. 05 Aug 2025 Fraudulent Transaction Case Study [Contd]

13. 06 Aug 2025 An Order Insight for an E-commerce Retailers Case Study

14. 07 Aug 2025 An Order Insight for an E-commerce Retailers Case Study 2

15. 11 Aug 2025 An Order Insight for an E-commerce Retailers Case Study 3

16. 12 Aug 2025 An Order Insight for an E-commerce Retailers Case Study 4

17. 13 Aug 2025 How to Connect PowerBI to PostgreSQL

18. 14 Aug 2025 Sub Query

Section 5

Data Analytics Documents

Datasets Documents

Datasets Documents

Section 6

Power BI Recordings

18. 12 June 2025 Group Work for the Excel Assignment

Lesson is locked. Please Buy course to proceed.

Power BI Recordings 17. 11 June 2025 Data Visualization, Creating Measures Using DAX

Power BI Recordings 19. 16 June 2025 Plato Pizza Case Study

error: Alert: Content selection is disabled!!