Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Apr 30th @8:00AM

Faculty: Mr. Venkat (8+ Yrs Of Exp,..)

Duration: 2 Months

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91- 9246212143, 80 96 96 96 96

Syllabus:

DATA ANALYST

Excel and SQL for Data Analytics

Excel for Data Analytics

Excel - Introduction

• Excel Window Navigation
• Primary Operations
• Cells and Columns Management
• Copy, Paste, and Paste Special Operations

Excel - Logical Functions

• IF, AND, OR, NESTED IFs, IFERROR, etc.

Excel - Arithmetic Functions

• AVERAGE, SUBTRACTION, DIVISION, MULTIPLICATION, etc.

Excel - Combination of Arithmetic and Logical Operations

• Combining both types of operations to create complex formulas

Excel - Lookup and Reference Functions

• VLOOKUP, HLOOKUP, INDEX, MATCH, etc.

Excel - Date and Text Functions

• DATE, DAY, MONTH, YEAR, TEXT, CONCATENATE, etc.

Data Summarization and Visualization

• Pivot Tables
• Charts (Bar, Line, Pie, etc.)
• Conditional Formatting for highlighting trends

Exploratory Data Analysis (EDA)

• Performing basic data analysis using built-in Excel tools

Excel - Project on Creating Real World Dashboard Using Excel

• Creating interactive dashboards with Excel for business insights

Excel – Project on Creating Real World Business Report Using Excel

• Developing professional business reports integrating data from multiple excel Sources
  

SQL for Data Analytics

SQL - Introduction

• Basics of SQL and its importance in data analytics

SQL - Understanding Databases and Table Structures

• Database schemas, tables, columns, and relationships

Querying Data

• SELECT, WHERE, and basic querying techniques

Sorting Data

• Sorting results using ORDER BY clause

Filtering Data

• Filtering with WHERE, BETWEEN, IN, LIKE, and pattern matching

SQL - Joining Data

• INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and understanding relationships

SQL - Grouping Data

• Using GROUP BY, HAVING, COUNT, SUM, AVG, etc.

SQL - Subqueries

• Writing nested queries for more advanced data analysis

SQL - Set Operators

• Using UNION, INTERSECT, and EXCEPT to combine result sets

SQL - Advanced SQL Functions

• Window functions, aggregate functions, and other advanced SQL techniques

Python and R Programming for Data Analytics

Python for Data Analytics

Python - Data Types

• Strings
• Numbers (Integer, Float)
• Booleans (True/False)
• Operators (Arithmetic, Comparison, Logical)

Python - Data Structures

• Lists, Tuples, Dictionaries, Sets

Python - Programming Constructs

• If, Else, and Elif Statements
• Loops (for, while)
• Exception Handling (try-except)
• File I/O Operations (read, write files)

Python - Data Manipulation with Libraries

• Using Pandas, Numpy for data cleaning and transformation

Python - Project on Exploratory Data Analysis and Visualization Using Python

• Data analysis and visualization with Pandas, Numpy, Matplotlib, Seaborn

Python - Project on Automating Excel Business Report Using Python

• Automating report generation from multiple Excel files using Pandas and OpenPyXL

R Programming for Data Analysts

R - Data Types

• Numeric
• Integer
• Complex
• Character
• Logical

R - Data Structures

• Vectors
• Matrices
• Lists
• Data Frames
• Factors

R - Programming Constructs

• If, Else, and Elif Statements
• Loops (for, while)
• Exception Handling
• File I/O Operations (read/write)

R - Data Manipulation

• Data transformation using dplyr, tidyr, and other R packages

R - Project on Exploratory Data Analysis and Visualization Using R

• Real-world data analysis using R libraries such as ggplot2, dplyr, and tidyr

R - Project on Automating Excel Business Report Using R

• Automating report generation and manipulation of Excel data using R (readxl, openxlsx)

Looker (Google Data Studio)

Introduction to Looker

• Understanding Looker and its role in modern data analytics
• Navigating the Looker interface
• Looker terminology

Data Modeling in Looker

• Defining dimensions and measures
• Creating relationships between data sources

Building Dashboards in Looker

• Creating interactive dashboards
• Visualizations in Looker (Bar, Line, Pie charts, etc.)
• Adding filters, drilldowns, and interactive elements

Looker Advanced Features

• Custom visualizations and embedding Looker reports
• Data Alerts and Notifications
• Sharing and scheduling reports in Looker

Looker Project: Building Real-World Business Dashboards

• Developing dashboards for real-world business cases, integrating data from various sources