DATA SCIENCE Course

DATA SCIENCE Syallbus

  • Installation of R & R Studio
  • Features of R
  • Variables in R
  • Constants in R
  • Operators in R
  • Datatypes and R Objects
  • Accepting Input from keyboard
  • Important Built-in functions
  • Creating Vectors
  • Accessing elements of a Vector
  • Operations on Vectors
  • Vector Arithmetic
  • if statement
  • if…else statement
  • Switch () function
  • repeat loop
  • while loop
  • for loop
  • break statement
  • next statement
  • Formal and Actual arguments
  • Named arguments
  • Global and local variables
  • Argument and lazy evaluation of functions
  • Recursive functions
  • Creating matrices
  • Accessing elements of a Matrix
  • Operations on Matrices
  • Matrix transpose
  • Creating strings
  • paste() and paste0()
  • Formatting numbers and string using format()
  • String manipulation
  • Creating lists
  • Manipulating list elements
  • Merging lists
  • Converting lists to vectors
  • Creating arrays
  • Accessing array elements
  • Calculations across array elements
  • Understanding factors
  • Modifying factors
  • Factors in Data frames
  • 10. DATA FRAMES IN R
  • Creating data frame
  • Operations on data frames
  • Accessing data frames
  • Creating data frames from various sources
  • Need for data visualization
  • Plotting categorical data
  • Stacked bar plot
  • Histogram
  • plot() function and line plot
  • pie chart
  • Scatter plot
  • Box plot
  • Important functions in stringr
  • Load data into dataframe
  • Viewing the data
  • Selecting columns
  • Selecting rows
  • Reordering the rows
  • Pipe operator
  • Group operations
  • What is NumPy array?
  • Array Constructor
  • Introduction to Array
  • Range() function
  • How to create 2-D Arrays
  • Matrix Operation
  • What is Array indexing and Slicing?
  • Indexing in 1-D Arrays
  • Indexing in 2-D Arrays
  • Slicing in 1-D Arrays
  • Slicing in 2-D Arrays
  • Array Comparison
  • Introduction to pandas
  • Pandas and Data Manipulation
  • What is Labeled and structured data?
  • What are Series and DataFrame objects?
  • What is Data Cleansing?
  • What is Data visualization?
  • Deleting and Dropping Columns
  • Series
  • Apply() function
  • Creating Series
  • Data Frame and Basic Functionality
  • Head() function
  • About: Merges and Joins
  • What is Data fill?
  • Mean() function
  • Data Frame Manipulation
  • Indexing and missing Values
  • Grouping and Reshaping
  • From excel
  • From CSV
  • DAX Introduction
  • CALCULATE – SUMIF
  • CALCULATE – SUMIFS
  • LOOKUPVALUE
  • CALENDAR, FORMAT, LEFT, MONTH, YEAR, DAY
  • DATEDIF, EDATE, NOW, QUARTER
  • FILTER, FILTERS, DISTINCT, ALLEXPECT
  • CONTAINS, ISBLANK, ISTEXT, ISNONTEXT, ISNUMBER
  • IF, Nested IF OR, AND
  • SUMX
  • at and iat
  • loc() Function and Iloc() function
  • head() Function and tail() Function
  • About describe() function
  • groupby() function
  • crosstab() function
  • How to combine Data Frames?
  • How to add and remove rows and columns?
  • How to sort data?
  • How to handle missing values?
  • How to handle duplicates?
  • How to handle Date and Time?
  • Processing and Cleaning Data through Pandas methods
  • Dealing with missing values
  • Introduction to Data Visualization
  • Matplotlib package:
  • Introduction to MatPlotlib Library
  • How to use matplotlib.pyplot interface
  • Types of charts
  • How to plot Histogram and pie chart?
  • About: Bar Chart, Stacked Chart, Scatter plot
  • DML (Data Manipulation Language), DDL (Data Definition Language), DQL
  • (Data Query Language)
  • How to create, alter and drop the DDL?
  • How to insert, update, delete and merge the DML?
  • How to select the DQL?
  • Primary and foreign key,unique key
  • How to select distinct?
  • Addition (+)
  • Subtraction (-)
  • Multiplication (*)
  • Division (/)
  • Modulus (%)
  • AND
  • OR
  • BETWEEN
  • SQL like, where
  • order by,
  • view, joins, aliases
  • Inner Join
  • Full (Outer) Join
  • Left (Outer) Join
  • Right (Outer) Join
    1. String Functions:
    • Char_length
    • Lower
    • Reverse
    • Upper
    1. Numeric Functions:
    • Max
    • Min
    • Sum
    • Avg
    • Count
    1. Date Functions:
    • Curdate
    • Curtime
    • Now
    • Month
    • Year
    • Day
    • Extract
    • Hour
    • Minute
    • Second
  • What is Power BI
  • How to get Power BI
  • The Parts of Power BI
  • What will you learn in this course
  • When we should use Power BI
  • Core Blocks of Power BI
  • Power BI Desktop vs Pro Version
  • Power BI Menus and Options
  • Menus and Options
  • Power BI components
  • Types of Data connection
  • How to Connect to Data Sources
  • Change data source
  • How to Import Data (Excel Report)
  • How to Import Data (Excel Table)
  • How to Import Data (Multiple Excel Table)
  • How to Import Data (Multiple Table and Sheets)
  • How to Import Data (Multiple Excel Reports)
  • How to Import Data (Multiple Excel Reports Multiple Sheets)
  • Creating Tables in Power BI Apply () function
  • How to Insert TextBox and Image
  • Data Frame and Basic Functionality
  • Data Cleansing
  • Data Transformation and Cleansing Intro
  • Data Transformation and Cleansing – Home
  • Data Transformation and Cleansing – Transform
  • Data Transformation and Cleansing – Column
  • Data Transformation and Cleansing – View
  • Data Transformation and Append Queries
  • Data Transformation and Merge
  • Relationship Basic
  • How to create Relationship and Why
  • Many to One Relationship
  • One to One Relationship
  • One to Many Relationship
  • Many to Many Relationship
  • Chart and Visualisation Basic
  • Data Import and Basic Check and Card Creation
  • Table and Matrix
  • Line Chart
  • Stacked Column Chart
  • Donut Chart Month
  • 100% Stacked Column and Bar Chart
  • Commentaries Box
  • Slicer
  • Publish Dashboard and how to do Analysis
  • Dashboard 2 – Intro
  • Actual vs Budget Data Load
  • Title and Multi Card
  • Matrix
  • Monthly Trend Actual vs Budget
  • Waterfall Chart
  • Pie Chart
  • Gauge Chart
  •  Map Chart
  • Analysis and Keynote 1
  • Time Slicer
  • Publish Dashboard
  • Create Bookmark and Add Button
  • Visual, Page, all Page Filter
  • Tooltips
  • Drill Through
  • Selection Panel
  • Funnel, Area, Ribbon Chart
  • Dynamic Commentaries
  • Visuals and Others Summary
  • Relationship Model Challenges
  • Quick Measures
  • Publish Report
  • Pinning Visuals
  • Export Data and Visuals – Excel, PPT and PDF Format

In the last 12 hours, 10 learners have onboarded with us

Data Science Course Schedule

Data Science Course Schedule

Month Topic
Month 1
  • FUNDAMENTALS OF R
  • VECTORS
  • CONTROL STATEMENTS
  • FUNCTIONS IN R
Month 2
  • MATRICES
  • STRINGS
  • LISTS
  • ARRAYS IN R
  • R FACTORS
Month 3
  • DATA VISUALIZATION IN R
  • STRINGR PACKAGE
  • DPLYR PACKAGE
Month 4
  • NumPy Package
  • Pandas Package
  • How To Load Datasets
  • DAX
  • Accessing Data From DataFrame
Month 5
  • Exploratory Data Analysis (EDA)
  • Data Cleaning
  • Python For Data Visualization
  • SQL (Structured Query Language) Basics
  • SQL Constraints
  • SQL Operators
Month 6
  • SQL Comparison Operators
  • SQL Logical Operators
  • Joins
  • MySQL Functions
  • Power BI Introduction
  • Data Connection
  • Queries Relationship
  • Dashboard 1 - Sales Summary (Visuals, Slicer And Others)
  • Dashboard 2 - Budget Vs Actual Analysis (Visuals, Slicer Etc.)
  • Publish And Sharing

Data science is an interdisciplinary field that involves extracting insights and knowledge from structured and unstructured data.

Benefits

Class Time:

Course Details:

Course Price:

Rs.75000 Rs.50000

Lesson Duration

6 Months

Course Mode

Online & Offline Class

Places for Students

12

Language:

English, Hindi

Certifications

Digital, Physical

Location

Chembur, Govandi

H
M
S

In the last 12 hours, 10 learners have onboarded with us

FAQ

Our training center is conveniently located in Chembur And Govandi 

You can enroll by visiting our website or contacting our office directly. Also Contact Directly Whatsapp No. +91 91672 43835 Phone No. +91 9167243835

Yes, we offer both online and offline classes to cater to different preferences. You can choose the mode that suits your schedule and learning style.

 

Yes, a certificate is provided upon course completion, and placement assistance is offered to help you secure relevant job opportunities.

 

The course fee is 50,000/- for the entire program.

The course duration is 6 months, providing a condensed and intensive learning experience.

 

In the last 12 hours, 10 learners have onboarded with us

Discover the power of databases with our MySQL course. Dive into essential SQL skills for efficient data management

Level up your Python skills with our course. Enroll now!

Enhance your web development skills with our ASP.NET course. Build dynamic web applications efficiently

Learn Top Trending Course In Programming Industry Basic to Advanced

Start your software development journey today. Enroll now!

Master C++ for efficient coding and development. Enroll now!

Scroll to Top

Start Your Journey with 100% Placement

GET DEMO LECTURE