Certificate on Completion
Course Curriculum
Term 1: Foundation
Office Productive Tools
Microsoft Word , Microsoft Excel, Microsoft PowerPoint
Analyzing Data using Microsoft Advanced Excel
- Calculating Data with Advanced Formulas
- Financial, Logical, Text, Lookup & References, and Statistical Functions.
- Presenting and Forecasting Data Using Charts.
- Analyzing Data using Pivot Tables and Pivot Charts.
- Analyzing Data using What-if Analysis and Power Pivot.
- Automating Business Operations using VBA.
Data Exploration with Microsoft Power BI
- Understanding Power BI Interface and Power BI Variants
- Using Excel Data in power BI for visualization
- Reporting/Dash boarding using power
- Publishing Power BI Dashboards
- Data relationships and queries in Power BI
- Data Transformations in power BI
Database Management with SQL
- Retrieve, summarize, and group data
- Use functions to customize the result set
- Query data by using joins and subqueries
- Manage databases, tables, and result sets
- Manipulate data by using DML statements
- Create and manage indexes and views
Project - In this section, you will be working on projects.
Term 2: Professional
Programming Basics and Data Analytics with Python
- Type Variables and Operators
- Strings, Lists, Dictionary
- Control Statements and Loops
- Functions and Scope of Variable
- Module and Package
- Collections
- Class and Objects
- Preparing the data
- Exploring the Data
- Classification Techniques
- Regular Dimensions
- Visualization in Python
Data Visualization using Tableau
- Introduction
- Basic Chart Developments
- Advanced Charts
- Working with its Dashboards
- Data Visualization and Real-Time Analytics
Data Analytics using R Programming
- Understanding of R System and installation and configuration of R-Studio
- Environment and R-Studio
- Understanding R Packages, their installation, and management
- Understanding of nuts and bolts of R
- R program Structure
- R Data Type, Command Syntax and Control Structures
- File Operations in R
- Preparing Data in R
- Data Cleaning, imputation, and conversion
- Visualizing data using R with different types of graphs and charts
- Applying R Advance features to solve complex problems
Project - In this section, you will be working on projects.