Job Role

Data Analytics

Migrated course from legacy data

Course Syllabus

1

Module 1: Python

  • Introduction to Python
  • Getting started with Python
  • Hands-on Data Types
  • Operators
  • Flow Control
  • Loops
  • Functions
  • Types of Parameter / Arguments
  • Local Variables and Global Variables
  • Decorator
  • Constructors
  • Oops Concepts
  • Inheritance
  • Polymorphism
  • Encapsulation
  • Abstraction
  • Database Connectivity
  • Exception Handling
  • Python Libraries
  • Numpy
  • Pandas
  • Matplotlib
2

Module 2: SQL Fundamental

  • Introduction to MYSQL
  • Installation of MySQL
  • CRUD operation in MySQL
  • Joins in MySQL
  • Views in MySQL
  • Store Procedure
  • Triggers
  • In-Built functions in MySQL
  • Performance Tuning on SQL Queries
3

Module 3: Advance Excel

  • Introduction to Microsoft Excel
  • How to Add, Subtract, Multiply, Divide in Excel
  • Excel Data Validation, Filters, Grouping
  • Introduction to formulas and functions in Excel
  • Logical functions (operators) and conditions in Excel
  • Visualizing data using charts in Excel
  • How to Import Data into Excel
  • How to Import SQL Database Data into Excel
  • Pivot Tables in Excel: Beginner's Guide
  • Excel VLOOKUP,ISBLANK Function
  • Macros & VBA in Excel
  • Introduction to Macros in Excel
  • Creating your First Visual Basic for Applications (VBA) in Excel
  • VBA Data Types, Variables & Constant
  • VBA Excel Form Control
  • VBA Arithmetic Operators
  • VBA String Operators
  • VBA Comparison Operators
  • VBA Logical Operators
4

Module 4: Power BI

  • INTRODUCTION TO POWER BI
  • Installing Power BI Desktop
  • Exploring The Power BI Workflow
  • Data types and Categories
  • Connecting To Different Data Sources
  • Create Dashboard
  • DAX Functions
  • M Functions
  • Time Intelligence Functions
  • POWER BI KPI
  • Modeling and ER Diagram
5

Module 5: Fundamental of Tableau

  • Introduction to Tableau
  • Overview of Tableau
  • Data visualization and analytic
  • Elements of the Tableau dashboard
  • Understanding the significance of Tableau Desktop and Tableau Server
  • Operations with elements.(Graphs, Table, Map & Charts)
6

Module 6: Fundamentals of data and data warehousing

  • Data Warehousing Basics
  • Database vs Data Warehouse
  • Data Warehouse Concepts, Architecture and Components
  • OLTP vs OLAP
  • Fact Table and Dimension Table
  • SCD Types
  • Star and SnowFlake Schema in Data Warehousing
  • Datawarehousing Technologies prior to Big data evolution (e.g. Teradata)
  • Difference Between Teradata and Relational Database
7

Module 7: Introduction to HADDOP

Ready to Start Learning?

Join thousands of students who have transformed their careers with our expert-led training.