3. BI Analytics Jobs in Abroad (Remote Job)

Business Intelligence Analytics Job Ready Live Bootcamp 3. BI Analytics Jobs in Abroad (Remote Job)

Business Intelligence Analytics Job Ready Live Bootcamp

0% Completed

Module 00: Introduction to BI Analytics Bootcamp

1. What is Business Analytics ?

Video - 00:11:17 mins

2. BI Analytics Jobs in Local Market

Video - 00:8:25 mins

3. BI Analytics Jobs in Abroad (Remote Job)

Video - 00:7:25 mins

4. What to Learn in BI Analytics

Video - 00:11:17 mins

5. What you will Learn in this bootcamp

Video - 00:18:59 mins

Module 0.5: Your Course Conduct Links and groups

Whatsapp Paid Group

Reading

Google Classroom Paid Link

Reading

Module 1.1 – Week 0.5 – Excel Mastery Fundamentals

Class 01 - Excel Interface and Workflow

Video - 00:30:52 mins

Class 02 - Data Entry & Basic Formulas

Video - 00:34:06 mins

Class 03 - Data Cleaning & Preparation

Video - 00:40:25 mins

Class 04 - Data Validation & Logical Functions

Video - 00:43:36 mins

Class 05 - VLOOKUP, INDEX & MATCH

Video - 00:34:35 mins

Class 06 - Statistical Formulas

Video - 00:20:44 mins

Class 07 - Date Formulas & Pivot Tables

Video - 00:31:17 mins

Module 1.2 – Week 01 – Excel Mastery Live

Excel Mastery - Live Class 01

Reading

Excel Mastery - Live Class 02 (Project 01)

Reading

Module 1.3 – Week 02 – Excel Mastery Live

Excel Mastery - Live Class 03

Reading

Excel Mastery - Live Class 04 (Project 02)

Module 2.1 – Week 2.5 – Google Analytics Fundamentals

Class 01 - Google Analytics & Excel Integration

Video - 00:24:43 mins

Class 02 – Excel Advanced Lookup Techniques

Video - 00:20:45 mins

Class 03 – Google Sheets Lookup & Array Functions

Video - 00:18:59 mins

Class 04 – Google Sheets Query, Array, and IF Functions

Video - 00:21:44 mins

Google Analytics Quiz 01

Quiz

Google Analytics Quiz 01

Quiz

Google Analytics Quiz 01

Quiz

Module 2.2 – Week 03 – Google Analytics Live

Google Analytics - Live Class 01

Reading

Google Analytics - Live Class 02 (Project 01)

Reading

Module 2.3 – Week 04 – Google Analytics Live

Google Analytics - Live Class 03

Reading

Google Analytics - Live Class 04 (Project 02)

Reading

Google Analytics Quiz 02

Quiz

Google Analytics Quiz 02

Quiz

Google Analytics Quiz 02

Quiz

Module 3.1 – Week 4.5 – Power BI with DAX Fundamentals

Class 01 - Power BI Foundation: Setup & Initial Workflow

Video - 00:41:35 mins

Class 02 - Data Transformation & Power Query Fundamentals

Video - 00:43:21 mins

Class 03 - Advanced Power Query: Data Enrichment & Optimization

Video - 00:46:42 mins

Class 04 - DAX Fundamentals: Aggregations & Error Handling

Video - 00:41:01 mins

Class 05 - Data Visualization Principles & Basic Charting

Video - 00:44:00 mins

Class 06 - Interactive Dashboard Design & Slicer Logic

Video - 00:40:09 mins

Class 07 - Advanced Visualization & Dashboard Storytelling

Video - 00:43:51 mins

Class 08 - Advanced Geospatial Analysis & ArcGIS Integration

Video - 00:24:55 mins

Class 09 - Data Analytics Project: End-to-End Dashboard Development

Video - 00:31:56 mins

Class 10 - Final Project Recap: Building the Summary Dashboard

Video - 00:29:07 mins

Module 3.2 – Week 05 – Power BI with DAX Live

Power BI - Live Class 01

Reading

Power BI - Live Class 02 (Project 01)

Reading

Module 3.3 – Week 06 – Power BI with DAX Live

Power BI - Live Class 03

Reading

Power BI - Live Class 04 (Project 02)

Module 4.1 – Week 6.5 – SQL Fundamentals

Class 01 - SQL for Big Data: Analysis, Quality, and Window Functions

Video - 00:25:17 mins

Class 02 - SQL Fundamentals: Precise Data Retrieval and Formatting

Video - 00:20:19 mins

Class 03 - SQL Aggregations: Summarizing and Processing Sales Data

Video - 00:19:30 mins

Class 04 - SQL Conditional Logic and Post-Aggregation Filtering

Video - 00:18:20 mins

Class 05 - Temporal Analysis: Date Functions and Time-Series Trends

Video - 00:17:30 mins

Class 06 - Data Quality Assurance and Value Classification

Video - 00:18:02 mins

Class 07 - Advanced SQL Architecture: Subqueries, Nesting, and CTEs

Video - 00:23:27 mins

Class 08 - Window Functions: Advanced Analytics and Data Ranking

Video - 00:17:59 mins

Class 09 - Relational Joins, String Manipulation, and Null Logic

Video - 00:21:45 mins

Module 4.2 – Week 07 – SQL Live

SQL - Live Class 01

Reading

SQL - Live Class 02 (Project 01)

Reading

Module 4.3 – Week 08 – SQL Live

SQL - Live Class 03

Reading

SQL - Live Class 04 (Project 02)

Module 5.1 – Week 09 – Big Data Analytics Live

Big Data - Live Class 01

Reading

Big Data - Live Class 02 (Project 01)

Module 5.2 – Week 10 – Big Data Analytics Live

Big Data - Live Class 03

Reading

Big Data - Live Class 04 (Project 02)

Reading

Module 6.1 – Week 10.5 – Python for Data Analytics Fundamentals

Class 01 – Python Fundamentals for Beginners

Video - 00:45:35 mins

Class 02 - Python Data Structures: Lists & Tuples

Video - 00:44:57 mins

Class 03 - Conditional Logic, List & Dictionaries

Video - 00:42:58 mins

Class 04 - Loops & Functions

Video - 00:38:09 mins

Class 05 - Python Modules, Math, and File Handling

Video - 00:44:23 mins

Class 06 - NumPy Arrays & Matrix Operations

Video - 00:40:29 mins

Class 07 - File Handling & Pandas Basics

Video - 00:45:50 mins

Class 08 - Python Strings, Lists & Dictionaries

Video - 00:46:38 mins

Class 09 - Python Conditional Logic & Loops

Video - 00:40:20 mins

Module 6.2 – Week 11 – Python for Data Analytics Live

Python - Live Class 01

Reading

Python - Live Class 02 (Project 01)

Reading

Module 6.3 – Week 12 – Python for Data Analytics Live

Python - Live Class 03

Reading

Python - Live Class 04 (Project 02)

Module 7.1 – Week 12.5 – Statistical Analytics Fundamentals

Class 01 - Linear Algebra for Data Science: Vectors & Matrices

Video - 00:32:50 mins

Class 02 - Matrix Algebra: Transformations and Structural Operations

Video - 00:31:29 mins

Class 03 - Statistical Foundations: From Description to Inference

Video - 00:30:45 mins

Class 04 - Data Classification and Visual Representation

Video - 00:33:47 mins

Class 05 - Descriptive Statistics: Measures of Central Tendency

Video - 00:43:01 mins

Class 06 - Descriptive Statistics: Measures of Variability and Distribution

Video - 00:35:24 mins

Class 07 - Statistical Shape Analysis and Python Implementation

Video - 00:33:30 mins

Class 08 - Sampling Methodologies: Theory and Python Implementation

Video - 00:40:56 mins

Class 09 - Systematic and Cluster Sampling: Advanced Selection Logic

Video - 00:51:53 mins

Class 10 - Probability Theory: Foundations of Uncertainty

Video - 00:28:23 mins

Class 11 - Random Variables and Probability Distributions in Data Science

Video - 00:30:36 mins

Class 12 - Discrete Probability Distributions

Video - 00:30:56 mins

Class 13 - Continuous Probability Distributions: Modeling Smooth Intervals

Video - 00:37:55 mins

Module 7.2 – Week 13 – Statistical Analytics Fundamentals Live

Statistics - Live Class 01

Reading

Statistics - Live Class 02 (Project 01)

Reading

Module 7.3 – Week 14 – Statistical Analytics Fundamentals Live

Statistics - Live Class 03

Reading

Statistics - Live Class 04 (Project 02)

Module 8.0 – Week 15 – BI Analytics Career Guideline

Class 01 – GitHub, Kaggle & Web-Based Resume Writing

Reading

Class 02 – Local & Remote Job Finding Strategy with Portfolio Building

Reading

Module 9.0 – Week 16 – Tableau (Bonus Module)

Class 01 – Tableau Fundamentals & Basic Charts

Video - 1:01:46 mins

Class 02 – Advanced Visualization in Tableau

Video - 00:59:12 mins

Class 03 – Data Analysis & Visual Exploration in Tableau

Video - 00:59:02 mins

Class 04 – Call Center Data Analysis in Tableau

Video - 00:57:35 mins

Class 05 – Connecting to Data Servers and Analyzing Insights in Tableau

Video - 00:51:40 mins

Class 06 – Sales Analysis & KPI Dashboard in Tableau

Video - 00:55:54 mins

Module 10.0 – Week 17 – Machine Learning (Bonus Module)

Video - 00:43:20 mins

Practice Materials

Reading

Announcements Reviews Course Info

Previous Next

Business Intelligence Analytics Job Ready Live Bootcamp 3. BI Analytics Jobs in Abroad (Remote Job)

Business Intelligence Analytics Job Ready Live Bootcamp

শুরু করুন আপনার ডেটা ক্যারিয়ার

Shortcuts

Important Links