get app

    Data Analytics Course

    BY
    IBM via Intellipaat

    Brochure Enquire
    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

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Cyber Security Courses Programming Courses Digital Marketing Courses Law Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses IIT Madras Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    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