• Home
  • Courses
    • Courses for Children
      • FV Jr. App Development
      • Kids Course
      • FV Jr. Robotics
    • Literacy Courses
      • School Level Courses
      • College Level Courses
      • Advance Excel
      • Computer Basics
      • Computer Accounting
      • WordPress for Beginners
    • Designing Courses
      • Web Designing
      • HTML5 AND CSS3
      • Bootstrap
      • Graphic Design Courses
      • Photoshop
      • CorelDraw Classes
      • Social Media Banner
      • Video Editing
      • Whiteboard Animation
      • Adobe After Effects
      • Lightroom
      • Adobe Illustrator
    • Programming Courses
      • Python Programming
        • Python Programming
      • PHP Programming
        • Php Course
      • Java Programming
        • Java Programming
      • C Programming
      • C++ Programming
      • MySQL Programming
      • ANGULAR 5 Programming
      • JSON Programming
      • Jquery Programming
      • JSP Programming
      • Servlets
    • Professional Courses
      • Data Analysis with Python
      • Financial Modelling
      • Diploma in Data Analysis
      • Diploma in Digital Marketing
      • SEO Training
      • WordPress Course For Programmers
      • IoT with Raspberry Pi & Arduino
      • Mobile Application Development
    • Diploma Courses
      • Diploma in Graphic Design Courses
      • Diploma in Financial Accounting & Data Analysis
      • Diploma in Programming
      • Diploma in Web Designing
      • Diploma in Web Designing, Development & Digital Marketing
    • Special Combo Courses
  • Our Blogs
  • Our Events
  • Portfolio
    • Our Portfolio
    • Student’s Portfolio
  • Contact
  • About Us
    Have any question?
    +91-9825771678
    admin@futurevisioncomputers.com
    Future Vision Computers
    • Home
    • Courses
      • Courses for Children
        • FV Jr. App Development
        • Kids Course
        • FV Jr. Robotics
      • Literacy Courses
        • School Level Courses
        • College Level Courses
        • Advance Excel
        • Computer Basics
        • Computer Accounting
        • WordPress for Beginners
      • Designing Courses
        • Web Designing
        • HTML5 AND CSS3
        • Bootstrap
        • Graphic Design Courses
        • Photoshop
        • CorelDraw Classes
        • Social Media Banner
        • Video Editing
        • Whiteboard Animation
        • Adobe After Effects
        • Lightroom
        • Adobe Illustrator
      • Programming Courses
        • Python Programming
          • Python Programming
        • PHP Programming
          • Php Course
        • Java Programming
          • Java Programming
        • C Programming
        • C++ Programming
        • MySQL Programming
        • ANGULAR 5 Programming
        • JSON Programming
        • Jquery Programming
        • JSP Programming
        • Servlets
      • Professional Courses
        • Data Analysis with Python
        • Financial Modelling
        • Diploma in Data Analysis
        • Diploma in Digital Marketing
        • SEO Training
        • WordPress Course For Programmers
        • IoT with Raspberry Pi & Arduino
        • Mobile Application Development
      • Diploma Courses
        • Diploma in Graphic Design Courses
        • Diploma in Financial Accounting & Data Analysis
        • Diploma in Programming
        • Diploma in Web Designing
        • Diploma in Web Designing, Development & Digital Marketing
      • Special Combo Courses
    • Our Blogs
    • Our Events
    • Portfolio
      • Our Portfolio
      • Student’s Portfolio
    • Contact
    • About Us

      Diploma Courses

      Classes Home » Courses » Diploma in Data Analysis
      CoursesProfessional CoursesDiploma in Data Analysis
      • Module 1
        38
        • Lecture1.1
          Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets
        • Lecture1.2
          Difference between Excel 2003, 2007, 2010 and 2013
        • Lecture1.3
          Saving Excel File as PDF, CSV and Older versions
        • Lecture1.4
          Using Excel Shortcuts with Full List of Shortcuts
        • Lecture1.5
          Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
        • Lecture1.6
          Using Paste Special Options
        • Lecture1.7
          Formatting Cells, Rows, Columns and Sheets
        • Lecture1.8
          Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
        • Lecture1.9
          Page Layout and Printer Properties
        • Lecture1.10
          Inserting Pictures and other objects in Worksheets
        • Lecture1.11
          Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etc
        • Lecture1.12
          Database Functions
        • Lecture1.13
          Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc
        • Lecture1.14
          Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc
        • Lecture1.15
          Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc And More
        • Lecture1.16
          Using Conditional Formatting
        • Lecture1.17
          Using Conditional Formatting with Multiple Cell Rules
        • Lecture1.18
          Using Color Scales and Icon Sets in Conditional Formatting
        • Lecture1.19
          Creating New Rules and Managing Existing Rules
        • Lecture1.20
          Sorting Data A-Z and Z-A
        • Lecture1.21
          Using Filters to Sort Data
        • Lecture1.22
          Advance Filtering Options
        • Lecture1.23
          Creating Pivot Tables
        • Lecture1.24
          Using Pivot Table Options
        • Lecture1.25
          Changing and Updating Data Range
        • Lecture1.26
          Formatting Pivot Table and Making Dynamic Pivot Tables
        • Lecture1.27
          Creating Pivot Charts
        • Lecture1.28
          Types of Pivot Charts and Their Usage
        • Lecture1.29
          Formatting Pivot Charts and Making Dynamic Pivot Charts
        • Lecture1.30
          Advanced Filtering
        • Lecture1.31
          Data validation
        • Lecture1.32
          Consolidation
        • Lecture1.33
          Groups
        • Lecture1.34
          Subtotal
        • Lecture1.35
          How to Record / Run Excel Macro ?
        • Lecture1.36
          What is Excel Macro ?
        • Lecture1.37
          How Add Developer’s Tab in Excel 2007 / 2010
        • Lecture1.38
          How to add different types of controls like Text Box, Radio button, button etc. in Excel
      • Module 2
        17
        • Lecture2.1
          Mathematical Function (Using Case Studies)
        • Lecture2.2
          Logical Function (Using Case Studies)
        • Lecture2.3
          Text Function (Using Case Studies)
        • Lecture2.4
          Flash Fill (Using Case Studies)
        • Lecture2.5
          Area Charts
        • Lecture2.6
          Surface Charts
        • Lecture2.7
          Trend line Charts
        • Lecture2.8
          Candle Stick Charts
        • Lecture2.9
          Pie Charts
        • Lecture2.10
          XY (Scatter Charts)
        • Lecture2.11
          Time Series Charts
        • Lecture2.12
          Bubble Charts
        • Lecture2.13
          Radar Charts
        • Lecture2.14
          Doughnut Charts
        • Lecture2.15
          Rotating 3D Excel Charts
        • Lecture2.16
          More Case Studies
        • Lecture2.17
          Add-On Tools (Analytical Tools)
      • Basic Python
        26
        • Lecture3.1
          Introduction to Python
        • Lecture3.2
          Python – The Universal Language
        • Lecture3.3
          Installing Python
        • Lecture3.4
          iPython – a better Python interpreter
        • Lecture3.5
          Types – Dynamic v/s Static Typing – tstrong v/s Weak Typing
        • Lecture3.6
          Numbers
        • Lecture3.7
          Strings
        • Lecture3.8
          Unicode
        • Lecture3.9
          Complex Types
        • Lecture3.10
          Operators – Operator Overloading
        • Lecture3.11
          Variables
        • Lecture3.12
          Scopping And Expressions
        • Lecture3.13
          Use of tabs and whitespaces as indent
        • Lecture3.14
          Conditionals – for…else
        • Lecture3.15
          The general syntax
        • Lecture3.16
          Default values for arguments
        • Lecture3.17
          Returning and receiving multiple values
        • Lecture3.18
          Variable number of arguments – args, kwargs
        • Lecture3.19
          Scope revisited
        • Lecture3.20
          Primitive v/s Composite Types
        • Lecture3.21
          Lists
        • Lecture3.22
          Tuples
        • Lecture3.23
          Maps (or Dictionaries)
        • Lecture3.24
          Sets
        • Lecture3.25
          Enums
        • Lecture3.26
          Looping Techniques
      • Data Analysis with Python
        27
        • Lecture4.1
          Installing Anaconda and Jupyter Notebook
        • Lecture4.2
          Jupyter Notebook overview
        • Lecture4.3
          Importing data from a csv, text file or another database
        • Lecture4.4
          Overview of various methods and attributes of Numpy
        • Lecture4.5
          Array
        • Lecture4.6
          Creating 1 dimensional arrays
        • Lecture4.7
          Creating 2 dimensional arrays
        • Lecture4.8
          Array indexing
        • Lecture4.9
          Accessing array elements
        • Lecture4.10
          Concatenating Numpy arrays
        • Lecture4.11
          Arithmetic operations with arrays
        • Lecture4.12
          Covariance
        • Lecture4.13
          Correlation
        • Lecture4.14
          Linear Regression
        • Lecture4.15
          Overview of various methods and attributes of Pandas
        • Lecture4.16
          Introduction
        • Lecture4.17
          Working with various Series attributes
        • Lecture4.18
          Introduction
        • Lecture4.19
          Pivoting
        • Lecture4.20
          Sorting
        • Lecture4.21
          Aggregation
        • Lecture4.22
          Descriptive statistical analysis with Pandas
        • Lecture4.23
          Introduction to Matplotlib
        • Lecture4.24
          Various Matplotlib methods
        • Lecture4.25
          Creating Line, Scatter, Bar, etc. charts
        • Lecture4.26
          Customising charts using: X and Y labels, Limits, Ticks, Legends
        • Lecture4.27
          Introduction to Pyplot
      • R Programming
        43
        • Lecture5.1
          R–OVERVIEW
        • Lecture5.2
          R – ENVIRONMENT SETUP
        • Lecture5.3
          R – BASIC SYNTAX
        • Lecture5.4
          R – DATA TYPES
        • Lecture5.5
          R – VARIABLES
        • Lecture5.6
          R – OPERATORS
        • Lecture5.7
          R – DECISION MAKING
        • Lecture5.8
          R – LOOPS
        • Lecture5.9
          R – FUNCTION
        • Lecture5.10
          R – STRINGS
        • Lecture5.11
          R – LISTS
        • Lecture5.12
          13.R – MATRICES
        • Lecture5.13
          R – ARRAYS
        • Lecture5.14
          R – FACTORS
        • Lecture5.15
          R – DATA FRAMES
        • Lecture5.16
          R – PACKAGES
        • Lecture5.17
          R – DATA RESHAPING Melt
        • Lecture5.18
          The Data
        • Lecture5.19
          R – CSV FILES
        • Lecture5.20
          R – EXCEL FILE Input as xlsx
        • Lecture5.21
          File
        • Lecture5.22
          R – BINARY FILES
        • Lecture5.23
          R – XML FILES
        • Lecture5.24
          R – JSON FILE
        • Lecture5.25
          R – WEB DATA
        • Lecture5.26
          R – DATABASES
        • Lecture5.27
          R – PIE CHARTS
        • Lecture5.28
          R – BOXPLOTS
        • Lecture5.29
          R – HISTOGRAMS
        • Lecture5.30
          R – LINE GRAPHS
        • Lecture5.31
          R – SCATTERPLOTS
        • Lecture5.32
          R – LINEAR REGRESSION
        • Lecture5.33
          R – MULTIPLE REGRESSION
        • Lecture5.34
          R – LOGISTIC REGRESSION
        • Lecture5.35
          R – NORMAL DISTRIBUTION
        • Lecture5.36
          R – BINOMIAL DISTRIBUTION
        • Lecture5.37
          R – POISSON REGRESSION
        • Lecture5.38
          R – ANALYSIS OF COVARIANCE
        • Lecture5.39
          R – TIME SERIES ANALYSIS
        • Lecture5.40
          R – NONLINEAR LEAST SQUARE
        • Lecture5.41
          R – DECISION TREE
        • Lecture5.42
          R – SURVIVAL ANALYSIS
        • Lecture5.43
          R – CHI SQUARE TEST
      • SQL
        16
        • Lecture6.1
          Introduction
        • Lecture6.2
          Creating New Tables
        • Lecture6.3
          SQL SELECT Statements
        • Lecture6.4
          Manipulating Data(Insert, Delete, Update)
        • Lecture6.5
          Distinct, Order By, Join clauses and Aggregate Functions
        • Lecture6.6
          Using Primary keys, Foreign keys
        • Lecture6.7
          Get Data from Multiple Tables
        • Lecture6.8
          Using DDL Statements
        • Lecture6.9
          Restricting and Sorting Data
        • Lecture6.10
          Using Single-row Functions
        • Lecture6.11
          Conversion Functions
        • Lecture6.12
          Conditional Expressions
        • Lecture6.13
          Using the Group Functions
        • Lecture6.14
          Subqueries to solve queries
        • Lecture6.15
          Linking SQL file with Python
        • Lecture6.16
          Accessing database
        This content is protected, please login and enroll course to view this content!
        Prev How to add different types of controls like Text Box, Radio button, button etc. in Excel
        Next Logical Function (Using Case Studies)

        Leave A Reply Cancel reply

        Your email address will not be published.

        Citylight Branch

        G-40, Navmangalam Complex, Citylight, Surat

        +91-9825771678

        admin@futurevisioncomputers.com

         

        Vesu Branch

        G-48, J-9 High Street, Canal Road, Vesu, Surat

        +91-9825771678

        admin@futurevisioncomputers.com

        Our courses

        • Professional Courses
        • Diploma Courses
        • Programming Courses
        • Designing Courses
        • Special Combo Courses
        • Courses for Children
        • Literacy Courses

        Useful Links

        • About Us
        • Contact Us
        • Our Blogs
        • Events
        • Refund Policy
        • Terms of Services
        • Privacy Policy

        Diploma Courses

        • Diploma in Digital Marketing
        • Diploma in Data Analysis
        • Diploma in Web Development
        • Diploma in Financial Accounting
        • Diploma in Programming
        • Diploma in Web Designing
        • Diploma in Graphic Design Courses

        Connect with us

        Copyright © 2021 Developed by Future Vision Computers.

        Modal title

        Message modal