OBJECTIVE :

The objective of the data analyst is to explore, sort and analyze megadata from various sources in order to take advantage of them and reach conclusions to optimize business processes or for decision support.

TARGET AUDIENCE :

students / Graduates / Diploma Students / Engineering Students

PREREQUISITES :

Prior knowledge in Basic Computer/ Science/ Engineering/ Maths/ Statistics is required.

OVERVIEW :

Data Analytic careers are one of the most highly compensated careers worldwide currently. Due to its broad application in every industry, there is a higher demand for data Analyst who can analyze complex data and communicate the results effectively. In this course, we will be covering the basics of data analytics and learning the tools used for data science from scratch. We will start the lessons at the beginner level and move up to the advanced level.

COURSE COVERAGE:

DATA MANAGEMENT

EXCEL Introduction - Formatting Worksheet - Conditional formatting - Pivot tables and charts - Formulas and functions (VLOOKUP, INDEX-MATCH, SUMIF, etc.)- Data cleaning and transformation - Data validation and sorting - Macros - Excel VBA User Forms - Connect with External Data - Creating an Automation Project.

MySQL Creating and modifying tables - Data manipulation (INSERT, UPDATE, DELETE) - Querying databases (SELECT, JOIN, GROUP BY)- Aggregation fuctions (SUM, AVG, COUNT) JOIN AND Subquerie.

MongoDB Introduction to NoSQL databases - CRUD operations - Data Indexing & Aggregation - Working with Unstructured Data

DATA VISUALIZATION

MATPLOTLIB Basic ploting (line plots, bar plots)- Customizing plots (labels, titles, legends) - Multiple subplots - Histograms and box plots - 3D plotting.

Power BI Connecting to data sources - Data transformation and cleaning - Building visualizations charts, tables, maps - Creating dashboards - Applying filters and slicers - Implementing advanced analytics in Power BI.

LANGUAGE SKILLS

PYTHON Basic syntax and data types - Control flow - functions and modules - File handling - Exception handling - List comprehensions and lambda functions - Object-oriented programming(OOP) concept.

DATA WRANGLING

NUMPY Arrays and array operations - Indexing and slicing - Mathematical functions - Linear algebra operations - Random module - Broadcasting.

PANDAS Series and Data Frame - Indexing and selecting data - Data cleaning and manipulation - Merging and joining data - Grouping and aggregation data - Handlinng missing data - Time series data.

CODE MANAGEMENT

GIT Setting up a GIT repository - Version Control - Branching & Merging - Collaboration.

Enroll

Add Student Data

×

First Name

Last Name

Select the Course Full Stack Developer Data Science Data Analyst HDCA-Programming (Honors Diploma in Computer Application) HDCA-Tally (Honors Diploma in Computer Application) DCA-Programming(Diploma in Computer Application) DCA-Tally(Diploma in Computer Application) ADPP (Advanced Diploma in Python Programming) DFPD (Diploma in Full Stack Python Developer) DMO (Diploma in MS Office) CCAE(Certificate Course in Advanced Excel) Diploma in .Net ADJP (Advanced Diploma in Java Programming) DPFD (Diploma in PHP Full Stack Developer HDFD (Honors Diploma in Full Stack Developer) MDSA (Master Diploma in System Administration) Spoken English Women's wear pattern making Fashion for Women's wear Advanced Pattern Making for Women & Kids wear Hand Embroidery Fashion Jewellery Making Softtoys Making Ladies single garment

Phone Number

Close Save Data