Full Stack Data Analytics 2.0 

MySQL

SQL

SQL Query

SQL Queries Part 2

SQL Queries

SQL function and procedure

SQL primary and foreign key

Window Function

Partition

Joins ,Union , Indexing , CTE

Triggers & Case

NF & Pivote

Snowflake

Snowflake Fundamentals

SQL Project

Sql Date Functions

Staging in SNOWFLAKE ( loading data from AWS to snowflake )

CIA_Factbook_Population_Datasets

SNOWFALKE CONTINUOS DATA LOAD USING SNOWPIPE

Snowflake continuous data loading

What is Cloud Computing

The Different Types of cloud computing

What is PasS?

Power Center on premise vs Informatica cloud

Power Center on cloud vs Informatica cloud

Advantages of using Informatica cloud

Informatica Cloud Architecture

Informatica Cloud Connectivity and Secure Agent

Informatica Documentation

How to Create a informatica cloud account

What are the different services available in informatica cloud

Quick Overview of Data Integration Service

Quick Overview of Administration Service

Quick Overview of Monitor Service

Steps to download and install secure agent

How to Create a informatica cloud account

What are the different services available in informatica cloud

Quick Overview of Data Integration Service

Quick Overview of Administration Service

Quick Overview of Monitor Service

Steps to download and install secure agent

Setup salesforce connection

Setup big query connection

Setup snowflake connection

Setup Amazon S3 connection

Creating Customer Table in Oracle Database

Set up Oracle connection

Create Mapping

Connect with Target Table

Expression Transformation

Overview in Expression Transformation

Router Transformation

Filter Transformation

Aggregator Transformation

Mapping Task Properties in IICS

Mapping Task Demo

Synchronization Task in IICS

Replication Task in IICS

Data Transfer Task in IICS

Create a Taskflow in IICS

Tasks inside a Taskflow in IICS

Schedule a Taskflow in IICS

Unschedule a Taskflow in IICS

File Listener in IICS

Start Taskflow from File Listener in IICS

Start Taskflow from Faulted step in IICS

Blackout Period in IICS

Copy,Rename,move,Delete Assets in IICS

Deploy the assets from one environment to another environment

Build an ETL Pipeline for Bank Transactions

Develop Informatica Mappings, Sessions, Worklets, Workflows for Sales Dataset

Create data warehouse for multiple subject

Power Bi

Snowflake Integration with Power Bi + Donut Charts

Line Chart (All types) + Slicers + Managing Relationship

Basic Charts in Power BI Desktop

Column Chart in Power BI

Stacked Column Chart in Power BI

Pie Chart in Power BI

Donut Chart in Power BI

Funnel Chart in Power BI

Ribbon Chart

Include and Exclude

Export data from Visual

Creating a Map in Power BI

Filled Map

Map with Pie Chart

Formatting in Map

Change Background in Map

Map of India in Power BI

Map of Australia in Power BI

Table and Matrix in Power BI

Creating a Table in Power BI

Formatting a Table

Conditional Formatting in Table

Aggregation in Table

Matrix in Power BI

Conditional Formatting in Matrix

Hirearchies in Matrix

Sub-Total and Total in Matrix

Number Formatting in Table

Other Charts in Power BI

Line Chart in Power BI

Drill Down in Line Chart

Area Chart in Power BI

Line vs Column Chart in Power BI

Scatter Plot in Power BI

Waterfall Chart in Power BI

TreeMap in Power BI

Guage Chart in Power BI

Cards and Filters in Power BI

Number Card

Text Card

Formatting of Text Card

Date Card

Date Card (Relative Filtering)

Multi-Row Card

Filter on Visual

Filter on This PAge

Filter on All Pages

Drillthrough in Power BI

Slicers in Power BI

Text Slicers in Power BI

Formatting a Text Slicer

Date Slicers in Power BI

Formatting a Date Slicer

Number Slicers in Power BI

Advanced Charts in Power BI

Animated Bar Chart Race

Drill down donut Chart

Drill down Column chart

Word Cloud in Power BI

Sankey Chart in Power BI

Infographic in Power BI

Play Axis in Power BI

Scroller in Power BI

Sunburst Chart in Power BI

Histogram in Power BI

Insert Image in Power BI

Insert Text in Power BI

Insert Shapes in Power BI

Insert Buttons in Power BI

Web URL Action in Power BI

Page Navigation Action in Power BI

Bookmark Action in Power BI

Drillthrough Action in Power BI

Create a Superstore Report in Power BI

Create an Account on Power BI Service

Publish Report to Power BI Service Account

Export Power BI Report to PPT, PDF or PBIX

Comment, Share and Subscribe to Power BI Report

Create a Dashboard in Power BI Service

Problem in Power BI Dashboard and its solution

Automatic Refresh in Power BI using Gateway

Text Functions in Power Query (Power BI)

Merge Columns in Power Query (Power BI)

Split and Trim in Power Query (Power BI)

Upper,Lower and ProperCase in Power Query (Power BI)

Prefix and Suffix in Power Query (Power BI)

Left,Right and Mid Functions in Power Query (Power BI)

Extract Text with Delimiters

Date Functions in Power Query(Power BI)

Year,Quarter,Month and Day Functions in Power Query (Power BI)

Find Difference between Dates in Power Query(Power BI)

Month and Day Name in Power Query (Power BI)

Day,Week of Month,Year in Power Query (Power BI)

Extract Date, Time in Power Query (Power BI)

Calculate Age in Power Query (Power BI)

Day of Year,Quarter,Month in Power Query (Power BI)

Number Functions in Power Query (Power BI)

Basic Number Functions in Power Query (Power BI)

Percentage,Percent Of, Module in Power Query (Power BI)

Round Functions in Power Query (Power BI)

IsEven,IsODD, Sign in Power Query (Power BI)

Append multiple CSV files in a folder in Power Query (Power BI)

Append multiple excel sheets,Tables in Power Query (Power BI)

Append Excel sheets or Tables with different columns in Power BI

Append multiple Excel files from a folder in Power BI

Append different data sources in Power BI

Merge Files and Tables in Power BI

Merge Sheets or Tables in Power Query (Power BI)

Merge Data from multiple Excel files or Workbooks in Power BI

Merge data from different data sources in Power Query (Power BI)

Merge data having multiple criteria in Power BI

Conditional Column and Column from example in Power BI

Column from examples in Power BI - Split Text

Column from examples in Power BI - Merge Columns

Column from Examples in Power BI - Date

Column from Examples in Power BI - Alphanumeric

Conditional Column in Power BI - One Column

Conditional Column in Power BI - two columns

Conditional Column in Power BI - Compare two columns

Conditional Column in Power BI - on Dates

Very Important Topics in Power Query (Power BI)

Fill Down in Power BI

Grouping in Power Query (Power BI)

Transpose in Power Query (Power BI)

Unpivot In Power Query (Power BI)

Data Types in Power Query (Power BI)

Replace Errors and Values in Power Query (Power BI)

Keep and Remove Rows in Power Query (Power BI)

Add,Remove and Goto Columns in Power Query (Power BI)

M Language in Power Query

Introduction to M Language

IsIn Date Functions in M Language - Power BI

Add and Subtract Date M Functions in Power BI

Basic Date M Functions in Power BI

Basic Text M Functions in Power BI

Simple M Code in Power BI

Trick to get all 900+ M Functions in Power BI

Tableau Introduction

Download and Install Tableau

Tableau Vs Excel

Introduction to section 1

MySQL introduction - 5 points to know

MYsql Installation MAC

Introduction to section 2

Creating and dropping database - Startup

Resolving the issue for future

Creating your first table

Adding values to canon table

Answering customer question

Introduction to section 3

Primary key, default and NULL

Table with primary key and default values

Testing the new table

Adding new values and answering questions

Update in customers table

Delete from the customers table

Introduction to section 4

Understand the new lco user DB

Task for CONCAT

Task for REPLACE

task for SUBSTRING

Task for reverse and CHAR_LENGTH

Task for case conversion and DOCS

Introduction to section 5

A task on DISTINCT

A task for ORDER BY

A task on LIMIT

Match the pattern

A task on COUNT

SQL MODES and GROUP BY

MIN MAX and SUBQUERIES

GROUP BY with MAX and MIN

SUM and AVERAGE with GROUP BY

A task on AND OR

A task in RANGE based selection

CASE THEN - multiple range selection

Introduction to section 6

Data type for INTEGER and STRING

Data type for DATE, DATETIME and JSON

DATE TIME code Example

Get the date and time

Lets join tom and jerry tables

Types of JOIN

Introduction to section 7

Code talk over FOREIGN keys

Understand a new database

A task on INNER join

ONE to MANY and MANY TO MANY

Join more 3 or more tables

A task on LEFT JOIN

A task on RIGHT JOIN

FULL OUTER join and UNION tasks

Introduction to section 8

Database engines - INNODB and more

ACID in database

Introduction to section 9

How practice database works - FILM

MYSQL Outro and some free resources

Python Introduction, Installation and Setup

Python Basics & Conditionals

Conditionals & Loops

Working with Loops

Working with Strings & Lists

List manipulation

Tuple, Set & Dictionary

Working with Functions

Introduction

Different types of Statistics

Population vs Sample

Mean, Median and Mode

Variance, Standard Deviation

Sample Variance why n-1

Standard Deviation

Variables

Random Variables

Percentiles & quartiles

5 number summary

Histograms

Gaussian - Normal distribution

Standard Normal distribution

Application Of Zscore

Basics Of Probability

Addition Rule In Probability

Multiplication rule in probability

Permutation

Combination

Log Normal Distribution

Central Limit theorem

Statistics - Left Skewed And Right Skewed Distribution And Relation With Mean, Median And Mode

Covariance

Pearson And Spearman Rank Correlation

What is P Value

What is Confidence Intervals

How To Perform Hypothesis Testing - Confidence IntervalZ Test Statistics Derive Conclusion

Hypothesis testing part 2

Hypothesis testing part 3

Finalizing statistics

Launching Excel

Microsoft Excel Startup Screen

Introduction to the Excel Interface

Customizing the Excel Quick Access Toolbar

More on the Excel Interface

Understanding the Structure of an Excel Workbook

Saving an Excel Document

Opening an Existing Excel Document

Common Excel Shortcut Keys

Entering Text to Create Spreadsheet Titles

Working with Numeric Data in Excel

Entering Date Values in Excel

Working with Cell References

Creating Basic Formulas in Excel

Relative Versus Absolute Cell References in Formulas

Understanding the Order of Operation

The structure of an Excel Function

Working with the SUM() Function

Working with the MIN() and MAX() Functions

Working with the AVERAGE() Function

Working with the COUNT() Function

Adjacent Cells Error in Excel Calculations

Using the AutoSum Command

Excel's AutoSum Shortcut Key

Using the AutoFill Command to Copy Formulas

Moving and Copying Data in an Excel Worksheet

Inserting and Deleting Rows and Columns

Changing the Width and Height of Cells

Hiding and Unhiding Excel Rows and Columns

Renaming an Excel Worksheet

Deleting an Excel Worksheet

Moving and Copying an Excel Worksheet

Working with Font Formatting Commands

Changing the Background Color of a Cell

Adding Borders to Cells

Excel Cell Borders Continued

Formatting Data as Currency Values

Formatting Percentages

Using Excel's Format Painter

Creating Styles to Format Data

Merging and Centering Cells

Using Conditional Formatting

Editing Excel Conditional Formatting

Introduction to Alteryx

Download and Install Alteryx

User Interface of Alteryx

Get Data from Excel

Get Data from CSV

Append All CSV files

Browse Tool

Output Tool - Update Existing Data

Directory Tool

Directory Tool - Specific Files

Text Input Tool

Date and Time Tool

Auto Field Tool

Data Cleansing Tool

Filter Tool (Text Example)

Filter Tool (Number Example)

Filter Tool ( Date Example)

FORMULA TOOL ( Basic Example )

FORMULA TOOL - (Multiple Examples)

GENERATE ROWS TOOL

IMPUTATION TOOL

MULTI-FIELD BINNING TOOL

MULTI-FIELD FORMULA

MULTI ROW FORMULA

RANDOM % SAMPLE TOOL

SAMPLE TOOL

RECORD ID TOOL

SELECT TOOL

SORT

CREATE SAMPLE TOOL

TILE TOOL

UNIQUE TOOL

APPEND FIELDS TOOL

FIND AND REPLACE TOOL

FUZZY MATCH TOOL

JOIN TOOL

JOIN MULTIPLE TOOL

UNION TOOL

REGEX TOOL

Text To Columns

CROSS TAB Tool

TRANSPOSE Tool

RUNNING TOTAL Tool

SUMMARIZE TOOL

TABLE TOOL

INTERACTIVE CHART Tool

JOIN TABLE AND CHART

ADD ANNOTATION

REPORT TEXT TOOL

REPORT HEADER TOOL

REPORT FOOTER TOOL

REPORT LAYOUT TOOL

COMMENT TOOL

EXPLORER TOOL

CONTAINER TOOL

Case Study 1

Case Study 2

Case Study 3

Case Study 4

Case Study 5