Business Intelligence Data Analysis

Applying VLOOKUP function Preview 03:32

Applying HLOOKUP function Preview 02:03

Quiz on Lookup Functions

Quiz Solution Preview 03:10

Why to use Index and Match? Preview 02:29

Applying Index and Match Preview 02:37

Quiz on Index and Match

Quiz Solution Preview 03:10

Making Pivot Tables Preview 03:40

Making Pivot Charts Preview 01:58

Quiz on Pivot Tables

Quiz Solution Preview 03:02

Basics of Data Visualizations Preview 02:09

Making Charts in Excel Preview 03:44

Making Dashboards Preview 02:31

Adding Slicers in Dashboards Preview 02:33

Formatting dashboards Preview 01:55

Quiz on Dashboards

Quiz Solution Preview 02:51

Goal Seek Analysis Preview 02:54

Data Tables Preview 02:45

Scenario Management Preview 03:17

Quiz on What If Analysis

Quiz Solution Preview 04:00

Understanding Regression Preview 01:58

Performing Linear Regression Preview 02:19

Quiz on Regression

Quiz Solution Preview 04:58

Introduction to SQL Preview 03:49

Build your first SQL query Preview 05:15

Basic SQL queries Part - 1 Preview 07:27

Basic SQL queries Part - 2 Preview 06:36

Brain Buster Exercise Preview 02:29

Brain Buster Solution Preview 04:44

Quiz on Introduction to SQL

Quiz Solution Preview 04:00

Installation Preview 04:27

Interface walkthrough Preview 04:00

Creating Required Databases Preview 02:16

Quiz on Installation and set up

Quiz Solution Preview 02:42

Type of SQL Commands Preview 04:38

The SELECT Command Preview 03:44

Numerical Functions Preview 05:43

String Functions Preview 05:57

Exercises on String Functions Preview 06:52

The Having Clause Preview 04:09

Filtering using the Like Operator Preview 06:48

Quiz on DQL

Quiz Solution Preview 06:07

Numerical Datatypes Preview 08:50

String Datatypes Preview 08:04

Constraints Preview 06:59

Quiz on DDL

Quiz Solution Preview 05:52

Creating Databases and Tables Preview 09:00

Alter, Drop, and Truncate Preview 03:30

Insert, Update, and Delete Preview 04:48

Quiz on DML

Quiz Solution Preview 03:24

Foreign Key Preview 05:58

Joins Preview 06:00

Left, Right, and Outer Join Preview 06:59

Compound Joins, and Multiple Joins Preview 04:14

Star Schema Preview 03:45

Sub Queries Part 1 Preview 05:08

Sub Queries Part 2 Preview 07:02

Quiz on Joins, Sub Queries & Set Operations

Quiz Solution Preview 04:29

Connecting MySQL through Python Preview 06:23

Loading Tables into a Pandas DataFrame Preview 04:12

Quiz on Accessing Databases using Python

Quiz Solution Preview 03:59

What is Big query Preview 03:35

How Big query works Preview 05:07

Getting started with GCP and Big query Preview 05:24

Importing Dataset and Executing your first Big query Preview 05:25

Visualizing using Data Studio Preview 03:42

BI Engine Preview 04:18

SQL exercise on Big query Preview 04:03

Quiz on Introduction to Big Query

Quiz Solution Preview 06:00

Use of Big query in Data Analysis Preview 02:37

Exploring Big query dataset on kaggle kernel Preview 06:09

Connecting Big query to Tableau Desktop for Visualizations Preview 10:31

Data Analysis project - Part 1 (Introduction and Setting up Problem statement) Preview 05:38

Data Analysis project - Part 2 (Exercises and Solutions) Preview 06:14

Quiz on Big Query for Data Analysis

Quiz Solution Preview 04:44

What is Data warehouse Preview 03:05

Properties of modern Data warehouse Preview 03:59

Alternatives to Big query Preview 03:24

Quiz on Data warehouse

Quiz Solution Preview 04:28

Getting Started with Tableau Preview 07:15

Navigating Tableau Preview 08:37

Creating Your First Visualization Preview 09:03

Building Your First Dashboard Preview 05:28

Quiz on Creating your First Tableau Dashboard

Introduction Preview 01:45

Dimensions and Measures Preview 08:25

Green & Blue Pills Preview 07:55

Measures Names & Values Preview 02:27

Working with Time Series Data Preview 09:43

Aggregation and Granularity Preview 08:43

Aggregation Options Preview 03:08

Show Me Toolbar Preview 04:47

Marks cards & Level of Detail Preview 13:08

Custom Shapes Preview 04:19

Filtering Data Preview 10:54

Pages Shelf Preview 04:42

Exercise on Building Blocks of Data Visualization Preview 01:43

Solution on Building Blocks of Data Visualization Preview 14:37

Quiz on Building Blocks of Data Visualization

Exercise Answer Preview 14:37

Highlight Table Preview 08:02

Highlight Table Bar Charts & Sorting Preview 06:14

Bar-in-Bar Preview 04:25

Histogram Preview 07:46

Pie Charts Preview 05:01

Pie Chart Exercise Solution Preview 04:21

Tree Map Preview 04:29

Bubble Chart Preview 04:06

Line Charts Preview 07:36

Area Chart Preview 07:26

Heat Map Preview 05:34

Exercise on Tableau Basic Visualization (Vietnam War Dataset) Preview 10:33

Solution on Tableau Basic Visualization Preview 22:34

Quiz on Tableau Basic Visualization

Exercise Answer Preview 22:34

Overview Preview 03:28

Theme & Workbook Level Formatting Preview 04:41

Axis Lines and Formatting Preview 08:30

Parts of the View Preview 03:41

Formatting Pane - Part 1 Preview 02:57

Formatting Pane - Part 2 (Fonts, Alignment & Shading) Preview 08:58

Formatting Pane - Part 3 (Borders & Lines) Preview 05:41

Number Format Preview 05:22

Titles & Captions Preview 07:35

Mark Labels Preview 05:18

Styling and Customizing a Tooltip Preview 04:48

Visualization in Tooltip Preview 04:03

Editing Axis Preview 10:06

Annotating the Viz Preview 06:34

Section Exercise - Data Ink Ratio Preview 02:16

Section Exercise Solution - Data Ink Ratio Preview 07:38

Quiz on Formatting in Tableau

Why should you learn Python? Preview 06:19

Installing Python and Jupyter Notebook Preview 06:27

Understanding the Interface of Jupyter Notebook Preview 06:41

Naming Convention for variables Preview 07:37

Built in Data Types and Type Casting Preview 07:19

Scope of Variables Preview 05:18

Quiz on Variables and Data Types

Quiz Solution Preview 04:35

Exercise on Variables and Data Types Preview 02:43

Solution on Variables and Data Types Preview 02:37

Exercise on Scope of Variables Preview 03:57

Solution on Scope of Variables Preview 02:39

Arithmetic and Assignment Operators Preview 08:42

Comparison, Logical, and Bitwise Operators Preview 07:49

Identity and Membership Operators Preview 03:17

Quiz on Operators

Quiz Solution Preview 03:36

Exercise on Arithmetic and Assignment Operators Preview 03:50

Solution on Arithmetic and Assignment Operators Preview 03:21

Exercise on Comparison, Logical, and Bitwise Operators Preview 04:06

Solution on Comparison, Logical, and Bitwise Operators Preview 03:33

Exercise on Identity and Membership Operators Preview 03:26

Solution on Identity and Membership Operators Preview 02:36

String Formatting Preview 04:48

String Methods Preview 05:53

User Input Preview 03:07

Quiz on Strings

Quiz Solution Preview 03:42

Exercise on Strings Preview 02:39

Solution on Strings Preview 03:20

If, elif, and else Preview 04:09

For and While Preview 05:41

Break and Continue Preview 03:15

Quiz on Loops and conditionals

Quiz Solution Preview 03:48

Exercise on Loops and Conditionals Preview 03:52

Solution on Loops and Conditionals Preview 04:32

Introduction to datetime Preview 02:17

The date and time class Preview 03:12

The datetime class Preview 01:44

The timedelta class Preview 01:15

Quiz on Dates and Times

Quiz Solution Preview 03:16

Exercise on Date and Time Preview 03:32

Solution on Date and Time Preview 03:37

Meta Characters for Regular Expressions Preview 05:17

Built-in Functions for Regular Expressions Preview 02:28

Special Characters for Regular Expressions Preview 02:50

Sets for Regular Expressions Preview 04:19

Quiz on Regular Expressions

Quiz Solution Preview 02:49

Exercise on Regular Expressions Preview 03:17

Solution on Regular Expressions Preview 03:31

Array Creation using Numpy Preview 03:35

Mathematical Operations using Numpy Preview 02:53

Built-in Functions in Numpy Preview 02:56

Quiz on Introduction to Numpy

Quiz Solution Preview 03:50

Exercise on Built-in Functions in Numpy Preview 03:28

Solution on Built-in Functions in Numpy Preview 03:16

Reading Datasets using Pandas Preview 03:46

Plotting Data in Pandas Preview 02:21

Indexing, Selecting, and Filtering Data using Pandas Preview 04:46

Merging and Concatenating DataFrames Preview 04:59

Lambda, Map, and Apply Functions Preview 02:22

Quiz on Introduction to Pandas

Quiz Solution Preview 04:08

Exercise on Pandas Plotting Preview 02:38

Solution on Pandas Plotting Preview 03:55

Exercise on Indexing and Selecting Preview 02:52

Solution on Indexing and Selecting Preview 03:07

Exercise on Apply Functions Preview 03:29

Solution on Apply Functions Preview 03:25

Why EDA and how it is useful Preview 02:09

Course curriculum walkthrough Preview 02:38

Data Profiling Preview 07:02

Analyzing Target Data Preview 04:02

Summarizing data Preview 02:43

Quiz on Introduction to EDA

Quiz Solution Preview 03:21

Exploring the Dabl Library Preview 06:51

Exploring the Sweetviz Library Preview 05:55

Using Color Gradients for better analysis Preview 03:25

Best Practices for Data Exploration Preview 02:08

Quiz on Examining Data

Quiz Solution Preview 03:42

Univariate Analysis Preview 04:07

Bivariate Analysis Preview 03:15

Multivariate Analysis Preview 04:47

Quiz on Basics of Visualization

Quiz Solution Preview 03:26

Scatter Plots Preview 03:36

Charts with Colorscale Preview 02:04

Bar, Line, and Area Charts Preview 04:21

Facet Grids Preview 02:25

Statistical Charts Preview 04:11

Polar Charts Preview 02:22

Subplots Preview 02:38

3D Charts Preview 01:50

Waffle Charts Preview 01:49

Maps Preview 02:28

Quiz on Advanced Visualizations

Quiz Solution Preview 03:43

Animation with Bubbleplot Preview 02:53

Animation with Facets Preview 01:39

Animation with Scatter Maps Preview 01:30

Animation with Choropleth Maps Preview 01:50

Quiz on Animated Visualizations

Quiz Solution Preview 02:46

Introduction to Ipywidgets Preview 03:12

Interactive Univariate Analysis Preview 02:22

Interactive Bivariate Analysis Preview 03:27

Interactive Multivariate Analysis Preview 02:10

Quiz on Interactive Visualizations

Quiz Solution Preview 03:44

Sunburst Charts Preview 02:18

Parallel Co-ordinate Charts Preview 01:36

Funnel Charts Preview 02:51

Gantt Charts Preview 02:23

Ternary Charts Preview 01:40

Tree Maps Preview 01:40

Network Charts Preview 02:33

Quiz on Miscellaneous Charts

Quiz Solution Preview 03:32

Aggregate functions used for Grouping Preview 03:58

Using Groupby for Grouping Operations Preview 02:23

Groupby with Idxmax and Idxmin functions Preview 01:45

Using Color scales for better visualization Preview 01:49

Visualizing the Groupby Operations Preview 02:18

Using Pivot Tables for Grouping Operations Preview 02:29

Difference between Groupby and Pivot tables Preview 01:51

Performing Cross Tabulation Preview 02:55

Visualizing Cross tabulated Data Preview 01:43

Interactive Grouping Operations Preview 02:40

Quiz on Grouping Operations

Quiz Solution Preview 03:37

When to perform Filtering Operations Preview 02:01

Introduction to Simple Filtering Operations Preview 01:25

Advanced Filtering Operations Preview 02:29

Filtering and Grouping Operations Preview 01:32

Interactive Filtering Operations Preview 01:37

Quiz on Filtering Operations

Quiz Solution Preview 03:34

Introduction to Linear Regression Preview 04:36

Implementing Linear Regression using Sklearn Preview 11:20

Feature Selection using RFECV Preview 06:23

Data Transformation with Linear Regression Preview 06:41

Applying Cross Validation Preview 05:19

Analyzing the performance of Regression models Preview 05:24

R2 score and adjuted R2 score intuition Preview 06:02

MAE, RMSE, R2 and Adjusted R2 in code Preview 05:41

Applying real time prediction on our model Preview 10:05

Industry relevance of linear regression Preview 02:37

Quiz on Modelling with Linear Regression

Quiz Solution Preview 06:19

Understanding a Business Problem Preview 02:54

Important Factors to Consider in a Business Problem Preview 02:32

The Process of Interviewing Preview 03:13

Do's and Dont's of Interviewing Preview 02:59

Introduction to 5W Framework Preview 02:28

Introduction to 5Why Framework Preview 03:11

Case Study on 5W and 5Why Framework Preview 04:08

Introduction to Spin Framework Preview 03:17

Case Study on Spin Framework Preview 02:55

Introduction to Business Model Canvas Preview 05:29

Introduction to Issue Tree Frameworks Preview 03:09

Case Study on Issue Tree Frameworks Preview 03:04

Introduction to 7P Framework Preview 02:52

Introduction to 3P Framework Preview 02:43

Introduction to 5C Framework Preview 03:35

Introduction to Specialized Business Frameworks Preview 03:19

Why is Communication so Important? Preview 03:00

Tips for Better Communication Preview 02:44

Do's and Dont's for Communication Preview 02:56

How to Deal with Large no. of People Preview 02:50

How to Manage Stress and Anxiety Preview 03:37

How to develop Communication Skills Preview 02:07

How to Develop Negotiation Skills Preview 04:56

How to Handle Negative People Preview 02:45

How to say "No" at Workplace Preview 02:45

How to use Empathy in Communication. Preview 01:59

Why Presentation Skills are Important Preview 02:13

How to Use Google Slides Preview 03:21

Tips and Tricks to make an Effective Presentation. Preview 02:20

Adding Graphics to your Presentation Preview 02:04

Adding Animations to your Presentation Preview 02:42

Introduction to Github? Preview 01:51

Introduction to Version Control Preview 02:13

Introduction to Git Preview 05:05

How to Upload Projects using Github. Preview 02:43

Using Github Pages to make your Portfolio Preview 03:23

How to Clone, Fork and Search for Projects in Github Preview 04:15

Maintaining Github Repositories Preview 03:10

Mastering Github Issues Preview 02:21

Getting Insight about Github Repositories Preview 02:21

Benefits of Grooming Preview 01:51

How to Dress for Different Occasions Preview 02:49

Eating and Talking Habits Preview 02:26

How to be More Presentable Preview 02:12

How to Improve Interpersonal Skills Preview 02:26

How to be professional at work place Preview 01:57

Conclusion Preview 02:11

How to Get Your Certificate of Completion Preview 00:16

Bonus Lecture Preview 01:00