4 Months Business Intelligence (Data Analytics) Excel, PowerBI, SQL, Tableau Training March 2024

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 Daily Data Live Training Session

Join Data Analytics Live Classes

Section 2

Join Weekly Interview Forum (Wednesdays)

Join Interview Forum - Data Analytics/ Business Intelligence

Section 3

Excel for Data Analytics Recordings

01. 18 Mar 2024 Introduction & Understanding Excel Environment

02. 22 Mar 2024 Data Manipulation & Cleansing [Left & Right, Clean, Trim, Sum, Average, Count, CountA, Max, Min, IF]

03. 25 Mar 2024 Cell Referencing [Relative, Absolute, Mixed Referencing, Cell Locking, Name Ranges, Structure Referencing]

04. 28 Mar 2024 Data Manipulation & Cleansing [Conditional Formatting, Sum & Subtotal, Using IF, Count IFS, Sum IF]

05. 04 Apr 2024 Data Manipulation & Cleansing [Substitute, IF + AND, IF + OR]

06. 05 Apr 2024 Data Manipulation & Cleansing [VLookUp, XLookUp, Index & Match (Project)]

07. 08 Apr 2024 Data Manipulation & Cleansing [Pivot Table with Trends(KPIs & Sales)]

08. 11 Apr 2024 Data Manipulation & Cleansing [Sales Trend (Contd), Dashboarding]

09. 12 Apr 2024 Power BI Download, Assignment Solution

Section 4

Power BI Recordings

01. 15 Apr 2024 Understanding Power BI Workflow, Power Query Environment, Data Model in Power BI

02. 16 Apr 2024 Database Fundamentals [Primary & Foreign Keys, [Facts & Dimension Tables]

03. 18 Apr 2024 Fact & Dimension table (Contd) Star & Snowflakes Schema, Data Manipulation & Modelling 1

04. 22 Apr 2024 Data Manipulation & Modelling I

05. 24 Apr 2024 Data Manipulation & Modelling II

06. 25 Apr 2024 DAX & Data Visualization

07. 26 Apr 2024 DAX & Data Visualization (Contd)

08. 29 Apr 2024 Plato Pizza Case Study Solution

09. 30 Apr 2024 Plato Pizza Case Study [contd]

10. 01 May 2024 Domino's Pizza Case Study Solution

11. 02 May 2024 BTC Case Study with Dashboard

12. 03 May 2024 Bitcoin Case Study with Dashboard [Contd]

13. 08 May 2024 Real Estate Case Study

14. 09 May 2024 Real Estate Case Study [Contd] with Dashboard

15. 10 May 2024 Real Estate Case Study Dashboard

Section 5

SQL Recordings

01. 13 May 2024 Meaning of Data, Database, Data Warehouse, Entity Relationship Diagram (ERD), Download Postgre SQL

02. 14 May 2024 Database Creation on Postgre SQL, Select Statement

03. 16 May 2024 Distinct, Where, Count, Limit, Order By [Asc & Desc] Statements

04. 17 May 2024 Top 10, Between, Like & iLike, IN, Aggregate Functions, Group By, Having Statement

05. 21 May 2024 Where, Count, Limit, Order By [Asc & Desc], IN, Like & iLike Statements

06. 22 May 2024 Group By & Having Clause Statement, JOINS

07. 23 May 2024 JOINS [Inner, Left, Right, Full], Create Table [Fraudulent Transaction]

08. 24 May 2024 Fraudulent Case Study [Tailored Analysis]

Section 6

Tableau Recordings

01. 28 May 2024 How To Download Tableau, Introduction To Tableau

02. 29 May 2024 Building Blocks of Tableau [The WHAT & HOW]

03. 31 May 2024 Data Modelling & Preparation (Data Blending, Relationship, Joins)

04. 04 June 2024 Tableau Function & Calculated Field 1

05. 05 June 2024 Tableau Function & Calculated Field 2, Dashboarding

06. 06 June 2024 Tableau Dashboarding [Contd]

Section 7

Python Recordings

01. 11 June 2024 Python Class

02. 12 June 2024 Download Python, Jupyter Notebook, Variables

03. 13 June 2024 Strings, Indexing & Slicing

04. 14 June 2024 Print Formatting, Concatenation, List

05. 17 June 2024 Project Guide

Section 8

Data Analystics Documents

Datasets Documents

Upload CV and Book 1-2-1 Review

Power BI Recordings

05. 24 Apr 2024 Data Manipulation & Modelling II

Lesson is locked. Please Buy course to proceed.

Power BI Recordings 04. 22 Apr 2024 Data Manipulation & Modelling I

Power BI Recordings 06. 25 Apr 2024 DAX & Data Visualization

error: Alert: Content selection is disabled!!