DATA ANALYTICS:
Data analytics is the procedure of looking at data sets to identify trends and create inferences about the knowledge they contain. Data analytics is increasingly carried out with the use of specialist hardware and software. In order to support businesses make better business decisions, data analytics technologies and methodologies are extensively used in commercial sectors. Analytics tools are also used by scientists and researchers to support or refute scientific models, hypotheses and theories.
Topics:
- Python
- SQL
- Tableau
- Power Bi
- Advanced Excel
- AWS
PYTHON
SQL
Tableau
Introduction to
Python
Python Interpreter
Basics of Python
Control Flow
Functions
Modules
Package
Numeric Types
String
List
Tuple
Dictionary
Set
Files
And Many More…
Introduction to Oracle Database
Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Invoke Conversion Functions and Conditional Expressions
And Many More…
Tableau And Data Visualization
Tableau And Data Connections
Data Organization
Advanced DataPreparation And Analytics In Tableau
Dashboards And Work Sharing
And Many More…
Power Bi
Advanced Excel
AWS
Power BI Complete Introduction
PBI Desktop Installation, PBI Desktop & Service Overview
Module 1: Power Query
Introduction to Power Query – Extract, Transform & Load
Module 2: Power Pivot
Power BI Data Modeling – Relationship View
Module 3: Power View
Report View / Power View
Module 4: Power BI Service
Power BI Service Introduction
And Many More…
Multiple Level Subtotal Reports
Filtering Database & Sorting Data
Securing & Protecting Worksheet
Linking Multiple Sheets
3D Reference in Excel
Sheet Referencing
Dynamic Linking Word/Excel/Power point
Function H lookup V lookup Lookup
X Lookup Dynamic H lookup V lookup
COUNTIF, SUMIF, SUMIFS
And Many More…
Introduction to AWS
Amazon Simple Storage Service (Amazon S3) and Amazon Glacier Storage
AWS Identity and Access Management (IAM)
Amazon Elastic Compute Cloud (Amazon EC2) and Amazon Elastic Block
Amazon Virtual Private Cloud (Amazon VPC)
Network Address Translation (NAT) Instances and NAT Gateways
And Many More…