Data Analytics Course

BY
IBM via Intellipaat

Mode

Online

Fees

₹ 85044

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 85,044
certificate availability

Yes

certificate providing authority

IBM +1 more

The syllabus

Introduction to Data Analytics

  • Module 01 – Introduction to Data Analytics

SQL for Data Analysis

  • Module 01 – Introduction to SQL
  • Module 02 – Database Normalization and Entity Relationship Model
  • Module 03 – SQL Operators
  • Module 04 – Working with SQL: Join, Tables, and Variables
  • Module 05 – Deep Dive into SQL Functions
  • Module 06 – Working with Subqueries
  • Module 07 – SQL Views, Functions, and Stored Procedures
  • Module 08 – Deep Dive into User-defined Functions
  • Module 09 – SQL Optimization and Performance
  • Module 10 – Advanced Topics
  • Module 11 – Managing Database Concurrency
  • Module 12 – Programming Databases Using Transact-SQL
  • Module 13 – Microsoft Courses: Study Material

Python for Data Science

  • Module 01 – Introduction to Data Science using Python
  • Module 02 – Python basic constructs
  • Module 03 – Maths for DS-Statistics & Probability
  • Module 04 – OOPs in Python (Self paced)
  • Module 05 – NumPy for mathematical computing
  • Module 06 – SciPy for scientific computing (Self-paced)
  • Module 07 – Data manipulation
  • Module 08 – Data visualization with Matplotlib
  • Module 09 – Machine Learning using Python
  • Module 10 – Supervised learning
  • Module 11 – Unsupervised Learning
  • Module 12 – Python integration with Spark (Self paced)
  • Module 13 – Dimensionality Reduction
  • Module 14 – Time Series Forecasting

Tableau Desktop 10

  • Module 01 – Introduction to Data Visualization and The Power of Tableau
  • Module 02 – Architecture of Tableau
  • Module 03 – Charts and Graphs
  • Module 04 – Working with Metadata and Data Blending
  • Module 05 – Advanced Data Manipulations
  • Module 06 – Working with Filters
  • Module 07 – Organizing Data and Visual Analytics
  • Module 08 – Working with Mapping
  • Module 09 – Working with Calculations and Expressions
  • Module 10 – Working with Parameters
  • Module 11 – Dashboards and Stories
  • Module 12 – Tableau Prep
  • Module 13 – Integration of Tableau with R

Business Analyst

  • Module 01 – Introducing business analyst
  • Module 02 – Understanding business needs
  • Module 03 – Project management
  • Module 04 – Techniques used by business analysts
  • Module 05 – Software project methodologies
  • Module 06 – UML with Microsoft Visio

Data Analytics Capstone Project

  • Module 01 – Data Analyst Capstone

Power BI

  • Module 01 – Introduction To Power BI
  • Module 02 – Data Extraction
  • Module 03 – Data Transformation – Shaping & Combining Data
  • Module 04 – Data Modelling & Dax
  • Module 05 – Data Visualization With Analytics
  • Module 06 – Power BI Service (cloud), Q & A And Data Insights
  • Module 07 – Power BI Settings, Administration & Direct Connectivity
  • Module 08 – Embedded Power BI With API & Power BI Mobile
  • Module 09 – Power BI Advance & Power BI Premium

Statistics and Probability

  • Module 01 – Information of Statistics
  • Module 02 – Data Conversion
  • Module 03 – Terms of Statistics
  • Module 04 – Plots
  • Module 05 – Statistics & Probability
  • Module 06 – Distributions
  • Module 07 – Sampling
  • Module 08 – Tables & Analysis

Advanced Excel

  • Module 01 – Entering Data
  • Module 02 – Referencing in Formulas
  • Module 03 – Name Range
  • Module 04 – Understanding Logical Functions
  • Module 05 – Getting started with Conditional Formatting
  • Module 06 – Advanced-level Validation
  • Module 07 – Important Formulas in Excel
  • Module 08 – Working with Dynamic table
  • Module 09 – Data Sorting
  • Module 10 – Data Filtering
  • Module 11 – Chart Creation
  • Module 12 – Various Techniques of Charting
  • Module 13 – Pivot Tables in Excel
  • Module 14 – Ensuring Data and File Security
  • Module 15 – Getting started with VBA Macros
  • Module 16 – Ranges and Worksheet in VBA
  • Module 17 – IF condition
  • Module 18 – Loops in VBA
  • Module 19 – Debugging in VBA
  • Module 20 – Dashboard Visualization
  • Module 21 – Principles of Charting
  • Module 22 – Getting started with Pivot Tables
  • Module 23 – Statistics with Excel

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books