Data Analytics
Created by Aptech Computer Training

Course Overview

Tools to Master: Excel, Python, SQL, NoSQL, Power BI, Presto, Knime Skills to Master: SQL, Data Wrangling, Prediction Algorithms, Data Visualization Using Power BI, Time Series, Machine Learning, Power BI, Advanced Statistics, Data Minin

Lesson 1: Data Analysis Fundamentals

  • Introduction to Data Science
  • Create and Modify Tables
  • Sort and Filter Data

Lesson 2: Visualizing Data With Excel

  • Visualize Data with Charts
  • Modify and Format Charts
  • Apply Best Practices in Chart Design

Lesson 3: Analyzing Data With Formulas And Functions

  • Analyze Data with Formulas and Named Ranges
  • Analyze Data with Functions
  • Implement Data Validation, Forms, and Controls
  • Create Conditional Visualizations with Lookup Functions

Lesson 4: Analyzing Data With Pivottables

  • Create a PivotTable
  • Analyze PivotTable Data

Lesson 5: Presenting Visual Insights With Dashboards In Excel

  • Visualize Data with PivotCharts
  • Filter Data Using Slicers and Timelines
  • Create a Dashboard in Excel

Lesson 6: Creating Geospatial Visualizations With Excel

  • Create Map Charts in Excel
  • Customize Map Charts in Excel

Lesson 7: Getting And Transforming Data

  • Anaconda Jupyter Environment Setup.
  • Python language Overview.
  • Data types of Python, numbers, string.
  • If, el-if, Loops in python.
  • Functions and modules in python
  • Lambda function.
  • Strings methods.
  • List and its methods.
  • Tuple, set, dictionary and their methods

Lesson 9: Analysis Using Python

  • Understanding the uses of various open source libraries.
  • Importing various modules with different methods.
  • Working with Numpy.
  • Numerical operations on Numpy array.
  • Exploring various use cases of Numpy.
  • Financial Analysis using scikit-learn, QuantLib, SciPy

Lesson 10: Data Visualization Using Python

  • Matplotlib, Seaborne, Plotly and Cufflinks.
  • Draw different types of graphs using above modules.
  • Pie chart, histogram, bar chart, boxplot, count plot etc.

Lesson 11: Data Analytics Using Power BI

  • Dash Board Preparation with BI.
  • Connect to Kaggle Datasets.
  • Explore Pandas Data Frame.
  • Analyze and manipulate Pandas Data Frame.
  • Data cleaning with Python & Export to BI.
  • Data Visualization with Python.
  • Connect to web data with Power BI.
  • Clean and transform web data with Power BI.
  • Create data visualization with Power BI.
  • Publish reports to Power BI Service.
  • Transform less structured data with Power BI.
  • Connect to data source with excel.
  • Prep query with excel Power query.
  • Data cleaning with excel.
  • Create data model and build relationships.
  • Analyze data with Pivot Tables
  • Analyze data with Pivot Charts
  • Connect to data sources with Power BI
  • Join related data and create relationships with PowerBI

Lesson 12: Presto

  • Introduction to Presto
  • Writing Queries in Presto on large data sets.
  • Data Transformation using Presto

Lesson 13: Data Wrangling With Sql/No Sql

  • Introduction to SQL
  • SQL operators
  • Join, tables, and variables
  • SQL functions
  • Subqueries
  • SQL functions, views, and stored procedures
  • User-defined functions
  • SQL performance and optimization
  • Advanced concepts
  • Cloud Operation Using Fire Base
  • No SQL Schema Using Fire Base
  • Fire Base Migration With Python

Lesson 14: Knime

  • Introduction to KNIME
  • Working with data in KNIME
  • Loops in KNiME
  • Webscraping in KNIME
  • Hyperparameter optimization in KNIME
  • Hyperparameter optimization for Machine Learning Models using loops in KNIME
  • Feature Selection in KNIME 

Lesson 15: Predictive Modeling

  • Multiple linear regression
  • Logistic regression
  • Linear discriminant analysis

Lesson 16: Time-Series Forecasting

  • Introduction to time-series
  • Correlation
  • Forecasting
  • Autoregressive models

Lesson 17: Statistics & Machine Learning Using Python

  • Programming with Python
  • Advance Statistics
  • ANOVA
  • Regression analysis
  • Data Mining
  • Supervised and unsupervised learning
  • Clustering
  • Decision trees
  • Neural networks

This course offers:

Category: IT & Software

Subcategory: Other IT & Software

Topic: -

Languages: -

Training Format: Individuals

Training Level: Advanced

Course Duration: 50 hours / course

Course Duration Total: 16 weeks

Course for Offline Classes

1 Limited Seat Offer
Individual Activity

Book Nearby Accommodations

Accomodations
Restaurants
Parks

Aptech Computer Training

USD 1,600
For course
  • Processing...
    30-Day Money-Back Guarantee
    This course includes:
    Levels
    Advanced
    Duration
    50 hours / course
    Subject
    IT & Software
    Update
    17 Feb, 2025 Last Update

    More Courses by Aptech Computer Training

    View All Course
    $799.00

    For course

     
    IT & Software
    Python Programming

    CHAPTER 1: AN INTRODUCTION TO PYTHON CHAPTER 2: BASIC PYTHON SYNTAX CHAPTER 3: LANGUAGE COMPONENTS CHAPTER 4: COLLECTIONS CHAPTER 5: FUNCTIONS CHAPTER 6: MODULES CHAPTER 7: EXCEPTIONS CHAPTER 8:...

    Aptech Computer Training
    26 hours / course (8 Weeks Total)
    Offline-Dubai/Sharjah
    Limited Seat - 1
    Individuals
    $799.00

    For course

     
    IT & Software
    Digital Marketing & SEO

    What you'll learn Find your target audience, easily convince them to become your customer and buy your products. Build a effective website for marketing and sale from scratch (no...

    Aptech Computer Training
    20 hours / course (4 Weeks Total)
    Offline-Dubai/Sharjah
    Limited Seat - 1
    Individuals
    $699.00

    For course

     
    IT & Software
    Analyzing Data with Power BI

    Course Contents Module 1:  Get Started with Microsoft Data Analytics Module 2:  Prepare Data in Power BI Module 3: Clean, Transform, and Load Data in Power BI Module 4:  Designing a Data Model in...

    Aptech Computer Training
    24 hours / course (8 Weeks Total)
    Offline-Dubai/Sharjah
    Limited Seat - 1
    Individuals
    icon More Similar Courses

    Related Courses

    $0.00

    For lesson

    FREE COURSE
    Uploader

    Accommodation options are available for this course.

     
    IT & Software
    Game Developer

    This course started as a runaway success on Kickstarter and has gone on to become the most popular and most watched Unity game development course on Udemy. The course has full English closed-captions...

    David Blow
    1 hour / lesson (3 Weeks Total)
    Live Stream
    Limited Seat - 3
    Groups
    $2.00

    $5.00

    For lesson

    limited offer
    Uploader

    Accommodation options are available for this course.

     
    IT & Software
    Management Skills Training for New & Experienced Managers

    What you'll learn Motivate your employees and create high engagement and empowerment. Provide specific job training for your team members.. Lead teams to become high performing teams engaged in...

    David Blow
    1 hour / lesson (2 Weeks Total)
    Live Stream
    Russian
    Limited Seat - 1
    Individuals
    $5.00

    $5.00

    For week

    Limited offer
    Uploader

    Accommodation options are available for this course.

     
    IT & Software
    Microsoft Excel - Excel from Beginner to Advanced 2024

    What you'll learn Go from complete beginner to proficient Excel user within 8 hours of content. Learn to create workbooks and spreadsheets everyone will be jealous of. Enhance Your Excel...

    David Blow
    10 hours / week (10 Weeks Total)
    Offline-Dubai
    Russian
    Limited Seat - 5
    Groups
    $799.00

    For course

     
    IT & Software
    Python Programming

    CHAPTER 1: AN INTRODUCTION TO PYTHON CHAPTER 2: BASIC PYTHON SYNTAX CHAPTER 3: LANGUAGE COMPONENTS CHAPTER 4: COLLECTIONS CHAPTER 5: FUNCTIONS CHAPTER 6: MODULES CHAPTER 7: EXCEPTIONS CHAPTER 8:...

    Aptech Computer Training
    26 hours / course (8 Weeks Total)
    Offline-Dubai/Sharjah
    Limited Seat - 1
    Individuals
    $799.00

    For course

     
    IT & Software
    Digital Marketing & SEO

    What you'll learn Find your target audience, easily convince them to become your customer and buy your products. Build a effective website for marketing and sale from scratch (no...

    Aptech Computer Training
    20 hours / course (4 Weeks Total)
    Offline-Dubai/Sharjah
    Limited Seat - 1
    Individuals
    $699.00

    For course

     
    IT & Software
    Analyzing Data with Power BI

    Course Contents Module 1:  Get Started with Microsoft Data Analytics Module 2:  Prepare Data in Power BI Module 3: Clean, Transform, and Load Data in Power BI Module 4:  Designing a Data Model in...

    Aptech Computer Training
    24 hours / course (8 Weeks Total)
    Offline-Dubai/Sharjah
    Limited Seat - 1
    Individuals
    My Cart