Data Analytics and Data Management Live Bootcamp

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

Live Session

Join Data Analytics Live Classes

Section 2

Excel Recordings

25 Nov 2024 Boot Camp Day 1

26 Nov 2024 Bootcamp Day 2

27 Nov 2024 Bootcamp Day 3

01. 02 Dec 2024 Introduction & Understanding Excel Environment

02. 03 Dec 2024 Data Manipulation & Cleansing [XLookUp, Index & Match]

03. 04 Dec 2024 Dashboarding, Editing Interface [VBA}

04. 05 Dec 2024 Dashboarding, Editing Interface [VBA} Data Visualisation

05. 09 Dec 2024 AVI Sales Dashboard

Section 3

Power BI Recordings

How to Download PowerBI for Mac Users

01. 10 Dec 2024 Understanding Power BI Workflow

02. 19 Dec 2024 Process Flow of Power BI, Database Fundamentals Primary & Foreign Keys

03. 14 Jan 2025 Introduction to PowerBI Continued

04. 16 Jan 2025 Fact & Dimension table (Characteristics), Star Schema

05. 17 Jan 2025 Data Manipulation & Modelling I

06. 20 Jan 2025 Data Manipulation Modelling I [Contd]

07. 21 Jan 2025 AVI Sales Dashboard

08. 23 Jan 2025 AVI Plato Pizza Case Study

09. 24 Jan 2025 AVI Plato Pizza Case Study (Cntd)[Modelling & Dashboard]

10. 27 Jan 2025 AVI Travel Survey Case Study & Dashboard

11. 28 Jan 2025 AVI Travel Survey Dashboard [Cntd]

12. 31 Jan 2025 NHS PowerBI Exercise

13. 03 Feb 2025 Exercise on Excel, Table and PowerBI

14. 04 Feb 2025 Real Estate Case Study

15. 06 Feb 2025 Real Estate Case Study [Contd]

16. 07 Feb 2025 Real Estate Case Study Dashboard

Section 4

Postgre SQL Recordings

01. 10 Feb 2025 Postgre SQL Download, Meaning of Data, Database, Data Warehouse

02. 11 Feb 2025 Entity Relationship Diagram (ERD)

03. 12 Feb 2025 Database Creation on Postgre SQL

04. 13 Feb 2025 Select, Distinct, Where, Count, Limit, Order By [Asc & Desc] Statements

05. 14 Feb 2025 Top 10, Between, IN, Like & iLike, Aggregate Functions, Group By

06. 17 Feb 2025 Having Clause Statement

07. 18 Feb 2025 Logical Operation, Concat, (Split, Date_Part, Extract), Case Statement

08. 20 Feb 2025 JOINS [Inner, Left, Right, Full]

09. 21 Feb 2025 Sub Query

10. 28 Feb 2025 Scalar, Multiple Row, Correlated, Exists Sub Query's, Datatypes

11. 01 Mar 2025 Fraudulent Transaction Case Study [Tailored Analysis]

13. 03 Mar 2025 Fraudulent Transaction Case Study (Cntd), Tableau Download

Section 5

Tableau Recordings

01. 04 Mar 2025 How To Download Tableau, Introduction To Tableau

02. 06 Mar 2025 Building Blocks of Tableau [The WHAT], Dimensions and Measures

03. 07 Mar 2025 Using Marks Card to Build Chart, Filters

04. 10 March 2025 - Data Modelling and Data Preparation, Tableau Function 1

05. 11 Mar 2025 Tableau Functions [Contd]

06. 13 Mar 2025 Calculated Field & Tableau Function [Cntd], Formatting

07. 14 March 2023 Creating Dashboard in Tableau

Section 6

Python Recordings

01. 17 Mar 2025 Download Python, Jupyter Note

02. 18 Mar 2025 Data Type and Basic Arithmetic in Python

03. 20 Mar 2025 Indexing & Slicing

04. 21 Mar 2025 List, Tuples and Dictionary

05. 24 Mar 2025 Boolean Operator, If, Elif, Else, AND & OR Statements

06. 25 Mar 2025 For & While Loop

07. 27 Mar 2025 Break, Continue & Pass

08. 28 Mar 2025 Snowflakes

09. 31 Mar 2025 Introduction to Data Governance

10. 01 Apr 2025 Team Collaboration

11. 03 Apr 2025 Team Collaboration 1 [Education for All (Case Study)]

Section 7

Data Analytics Documents

Datasets Documents

Datasets Documents

Power BI Recordings

13. 03 Feb 2025 Exercise on Excel, Table and PowerBI

Lesson is locked. Please Buy course to proceed.

Power BI Recordings 12. 31 Jan 2025 NHS PowerBI Exercise

Power BI Recordings 14. 04 Feb 2025 Real Estate Case Study

error: Alert: Content selection is disabled!!