- Module 01 – Introduction to Data Analytics
Online
₹ 60,021
Quick facts
particular | details | ||
---|---|---|---|
Collaborators
IBM,
+1 more
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
The syllabus
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
Articles
Popular Articles
Latest Articles
Trending Courses
Popular Courses
Popular Platforms
Learn more about the Courses
Providers
Providers
- Microsoft Corporation
View all coursesders">
View all courseView all coursess
Providers
Providers
Collaborators
- Microsoft Corporation
Medium of Instructions
Mode of Learning
Mode of Study
Mode of Delivery
Certificate Providing Authority
- Microsoft Corporation
Thank You!
The Brochure has been downloaded and sent to your registered email ID successfully.
Download Brochure
Thank You!
Brochure has been downloaded.
Sign In/Sign Up
We endeavor to keep you informed and help you choose the right Career path. Sign in and access our resources on Exams, Study Material, Counseling, Colleges etc.