DATA ANALYTICS THROUGH DCA

Data Analytics

Course description

  • Computer Fundamentals - Introduction
  • Functional Organization of Computer
  • Hardware & Software
  • Network & Data Communication
  • Number Systems
  • Hardware & software requirement for internet
  • Internet services
  • Types of personal computers
  • Algorithm and Flow chart
  • IF AND OR and SUM if , COUNT IF
  • Pivot and Vlookup
  • Sort and Formatting
  • Powerful Data Analysis
  • Charts
  • Introduction to DBMS
  • Entity and relational Data models
  • Relational Data Models
  • Database Normalization
  • Relational Algebra and Relational Calculus
  • Backup and Recovery
  • Database Security and Integrity
  • Design and Development of Database Applications on CRDBMS
  • A brief Introduction to Mongo DB (NOSQL DB)
  • Introduction to System Engineering
  • Systems documentation consideration
  • System Planning
  • Input/output
  • System Implementation and Maintenance
  • Introduction to Management Information System (MIS)
  • Introduction to Python
  • Python Data Types and Data structures
  • Flow Control, Functions and Modules
  • File Handling and Regular Expressions
  • Object Oriented programming and Exception handling
  • Towards Data Science
  • Introduction to SQL
  • SQL Commands
  • Views and Indexes
  • Sub queries
  • Joins, Unions, Intersection, Minus
  • Unions
  • Cursors in SQL
  • Embedded SQL
  • Stored procedures
  • Functions in SQL
  • Practical Exercises for SQL
  • Introduction to Data Analysis and Data Visualization
  • Familiarity with RDBMS & SQL
  • Introduction to Business Intelligence Tools like Tableau
  • Visual Analytics-In detail
  • Introduction to Mappings
  • Sorting,Filtering and Grouping in Tableau
  • Forcasting and Clustering
  • Dashboard and stories
  • Introduction
  • Text functions
  • Mathematical functions
  • Logical functions
  • what is the table and features
  • Logical function problems
  • chart
  • Goal seek and Pivot Table
  • V Lookup
  • INTRODUCTIONS TO MS WORD
  • INSERT TABLE
  • INSERT SHAPES
  • PICTURES AND LINK
  • Header and Footer, Smart Art, Drop Cap, Book Mark
  • Page design
  • Layout and View
  • Mail merge
  • Introduction Table and Data type
  • Lookup Wizard and Filter
  • Query
  • Form and Report
  • Introduction to Powerpoint
  • Shapes, Image and 3D
  • Table, Chart and Link
  • Create a Presentation
  • How to use 3D model and Shapes
Matthew taylor/Accounting teacher

Lorem ipsum is simply dummy text of the printing typesetting industry. Lorem ipsum has been the industry's standard.

4.9

2,488 Reviews
Average customer ratings
80%
10%
05%
03%
02%
Herman miller
06 April 2023
08

Lorem ipsum dolor sit sed do eiusmod tempor incididunt labore enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate.

Wilbur haddock
26 April 2023
06

Lorem ipsum dolor sit sed do eiusmod tempor incididunt labore enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate.

Colene landin
28 April 2023
00

Lorem ipsum dolor sit sed do eiusmod tempor incididunt labore enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate.

Add a review

Scroll