Python with Data Analysis

Data Analysis is the key to unlocking insights and making informed decisions in today’s data-driven world. By learning data analysis, you'll gain the skills to collect, clean, and interpret data, turning raw information into actionable insights. It's essential in various fields like business, healthcare, finance, and social sciences. Mastering data analysis tools and techniques, such as Excel, SQL, Python, and visualization tools, will empower you to solve complex problems, improve efficiency, and drive strategic decisions. Dive into data analysis today and transform how you understand and leverage data to create meaningful impact

Course Content

Introduction to Data Analysis

Data Analysiswith real-world Examples

Applications using Data Analysis

Applications using PowerBI

Applications using Tableau

Applications using WebScrapping

SQL and Databases

Data types

varibales

operators

print

precision and fied width

Python Installation and Running

Installation and Running

Jupyter Notebook

.py file from terminal

Google Colab

String

list

tuple

sets

dictionary

Forloops

while loops

if

else

elif

break

continue

functions

lambda function

comprehensions

Error / Exception Handling

File Handling

JSON module

OS Module

Pickle Module

Datetime Module

Copy Module

oops concept

class

object

constructor

inheritance

polymorphisam

abstraction

excapsulation

what is process

what is multiprocessing

what is multithreading

start

join

kill

terminate

Numpy

Pandas

Data Visualization Library: Matplotlib

Seaborn

Descriptive Statistics

Measure of central tendency

Measure of dispersion

outliers

covariance

correlation

testing

hypothesis testing

mean

median

mode

Normal Distribution etc..

SELECT statement

FROM clause

WHERE clause

JOINs INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

GROUP BY clause

HAVING clause

ORDER BY clause

Aggregate functions (SUM AVG COUNT MIN MAX

Transactions BEGIN TRANSACTION

COMMIT

ROLLBACK

Constraints PRIMARY KEY

FOREIGN KEY

UNIQUE

CHECK

Data manipulation INSERT

UPDATE

DELETE

DMl operations

DQL Operations

DDl Operations

Alter

drop

sprename

truncate

Formulas and Functions

math formulas

LOOKUP

INDEX-MATCH

PivotTables (Creating Filtering Grouping)

Charts and Graphs

Column chart

Line chart

Pie chart etc

Conditional Formatting

Data Validation

Named Ranges

Excel Tables

Functions for Text Manipulation

LEFT

RIGHT

CONCATENATE etc

Functions for Date and Time

DATE

TODAY

MONTH etc

Data Import and Export

PowerBI Introduction

PowerBI Installations

Data Explanation

Visualizations

Bar chart

Line chart

Pie chart

Area chart

Scatter plot

Bubble chart

Treemap

Funnel

Card

Geographic map

Filled map

Line chart

Area chart

Histogram

Donut chat

Model View Explanation

DAX Formulas

Power Query

Tableau Introduction

Tableau Installation

What is Data Source

What is sheet

What is DashBoard

What is Story telling

Tableau visualizations

Tableau alignments

Tableau Parameters

Tableau sets

Tableau GroupBy

Include Exclude Bar Chart

Line Chart

Pie Chart

Map

Scatter Plot

Histogram

Gantt Chart

Bubble Chart

Heat Map

Tree Map

Box Plot

Area Chart

Dual-Axis Chart

Waterfall Chart

Highlight Table

Packed Bubbles

Word Cloud

Funnel Chart

Ascending order

Descending order

Transform

Publish Data Reports