• 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 Numbers
        Next Unicode

        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