Become a Data Analyst – July 2024 Cohort

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 Session

Join Data Analytics Live Classes

Section 2

Excel Recordings

01. 15 July 2024 Introduction & Understanding Excel Environment

02. 16 July 2024 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking

03. 17 July 2024 Data Manipulation & Cleansing [Sum, Name Ranges, Structure Referencing, IF, Clean, Trim, Text to Column, Left & Right, Conditional Formatting]

04. 18 July 2024 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IF, Sum IF, IF + AND, IF + OR]

05. 19 July 2024 Data Manipulation & Cleansing [VLookUp, XLookUp, Index & Match]

06. 22 July 2024 Assignment Correction

07. 23 July 2024 Data Manipulation & Cleansing [Index & Match (Contd), Pivot Table with Trends (KPIs & Sales)]

08. 24 July 2024 Dashboarding, Editing Interface [VBA]

Section 3

PowerBI Recordings

How to Download PowerBI for Mac Users

01. 25 July 2024 Understanding PowerBI Workflow, Power Query Environment, Data Model in Power BI

02. 26 July 2024 Database Fundamentals Primary & Foreign Keys, Facts & Dimension Tables

03. 29 July 2024 Fact & Dimension table (Contd), Star & Snowflakes Schema

04. 30 July 2024 How to Download PowerBI, Data Manipulation & Modelling I

05. 31 July 2024 Data Manipulation & Modelling II [Contd]

06. 01 Aug 2024 Data Manipulation & Modelling III

07. 02 Aug 2024 DAX & Data Visualization

08. 05 Aug 2024 Data Visualization [Dashboarding] (Contd)

09. 06 Aug 2024 Sales Modelling & Dashboarding

10. 12 Aug 2024 AVI Travel Survey Case Study

11. 13 Aug 2024 AVI Travel Survey Case Study [Contd] with Dashboard

12. 19 Aug 2024 IBM HR Case Study with Dashboard

13. 20 Aug 2024 IBM HR Case Study [contd] with Dashboard

14. 21 Aug 2024 Plato Pizza Case Study

15. 22 Aug 2024 Plato Pizza with Dashboard [Contd] Pt1

16. 23 Aug 2024 Plato Pizza with Dashboard [Contd] Pt2

17. 27 Aug 2024 Collaboration

18. 28 Aug 2024 Connecting PowerBi with Yahoo Finance to Build Dashboard

19. 02 Sept 2024 How to Bookmark using BITCOIN Dashboard, AVI Property Case Study

20. 03 Sept 2024 AVI Property Case Study [Contd]

21. 04 Sept 2024 AVI Property Case Study with Dashboard [Contd]

22. 05 Sept 2024 Designing & Visualising using AVI Property Case Study Dashboard

23. 06 Sept 2024 Understanding UX Unicorn, Postgre Installation

Section 4

SQL Recordings

01. 10 Sept 2024 Meaning of Data, Database, Data Warehouse

02. 11 Sept 2024 Entity Relationship Diagram (ERD)

03. 12 Sept 2024 Creating a Database and Testimonials (Success Story)

04. 13 Sept 2024 Select, Distinct and Where Statement

05. 16 Sept 2024 Where [Comparison operators], AND, OR, NOT, Statement

06. 17 Sept 2024 Count, Limit, Order By [Asc & Desc], Top 10, Between, Like & iLike, IN Aggregate Functions

Section 5

Data Analytics Documents

Datasets Documents

Datasets Documents

PowerBI Recordings

10. 12 Aug 2024 AVI Travel Survey Case Study

Lesson is locked. Please Buy course to proceed.

PowerBI Recordings 09. 06 Aug 2024 Sales Modelling & Dashboarding

PowerBI Recordings 11. 13 Aug 2024 AVI Travel Survey Case Study [Contd] with Dashboard

error: Alert: Content selection is disabled!!