Big Data!!! Are you demotivated when your peers are discussing about data scienceand recent advances in Big Data? Did you ever think how Flipkart and Amazon are suggesting products for their customers? Do you know how financial institutions/retailers are using Big Data to transform themselves into next-generation enterprises? Do you want to be part of the world class next generation organizations to change the game rules of the strategy making and to zoom your career to newer heights?
Here is the power of Data Science in the form of Data Mining concepts which are considered most powerful techniques in Big Data Analytics.
Data Mining with R unveils underlying amazing patterns, wonderful insights which go unnoticed otherwise, from the large amounts of data. Data mining tools predict behaviours and future trends, allowing businesses to make proactive, unbiased and scientific-driven decisions. Data mining has powerful tools and techniques that answer business questions in a scientific manner, which traditional methods cannot answer. Adoption of data mining concepts in decision making changed the companies, the way they operate the business and improved revenues significantly.
Companies in a wide range of industries such as Information Technology, Retail, Telecommunication, Oil and Gas, Finance, Healthcare are already using data mining tools and techniques to take advantage of historical data and to create their future business strategies.
Data mining can be broadly categorized into two branches i.e. supervised learning and unsupervised learning. Unsupervised learning deals with identifying significant facts, relationships, hidden patterns, trends and anomalies. Clustering, Principle Component Analysis, Association Rules, etc., are considered unsupervised learning. Supervised learning deals with prediction and classification of the data with machine learning algorithms. Weka is the most popular tool for supervised learning.
Description: Learn about High-level overview of Data Science project management methodology, Statistical Analysis using examples, understand Statistics and Statistics 101. Also, learn about exploratory data analysis, data cleansing, data preparation, feature engineering.
Topics
Description: Continue with the discussion on understanding Statistics, the various Moments of business decision and other Basic Statistics Concepts. Also, learn about some graphical techniques in Analytics.
Topics
Description: Learn about the other moments of business decision as part of Statistical Analysis. Learn more about Visual data representation and graphical techniques. Learn about Python, R programming with respect to Data Science and Machine Learning. Understand how to work with different Python IDE and Python programming examples.
Topics
Description: Learn about Normal Distribution and Standard Normal Distribution. Rules and Principles of Normal distribution. And how to check for normality by QQ normal distribution Plot.
Topics
Description: Under this last topic on Basics of statistics, learn some higher statistical concepts and gain understanding on interval estimates.
Topics
Introduction to R and Python basic stats
Description: Get introduced to Hypothesis testing, various Hypothesis testing Statistics, understand what is Null Hypothesis, Alternative hypothesis and types of hypothesis testing.
Topics
Description: Learn about the various types of tests in Hypothesis testing. Get introduced to the prerequisites and conditions needed to proceed with a Hypothesis test. Understand the interpretation of the results of a Hypothesis testing and probabilities of Alpha error.
Topics
Description: Continuing the discussion on Hypothesis testing, learn more about non-parametric tests. Perform different tests and interpret the results.
Topics
Description: Learn about Linear Regression, components of Linear Regression viz regression line, Linear Regression calculator, Linear Regression equation. Get introduced to Linear Regression analysis, Multiple Linear Regression and Linear Regression examples.
Topics
Description: In the second part of the tutorial, you will learn about the Models and Assumptions for building Linear Regression Models, build Multiple Linear Regression Models and evaluate the results of the Linear Regression Analysis.
Topics
Description: Learn to analyse Attribute Data, understand the principles of Logistic Regression, Logit Model. Learn about Regression Statistics and Logistic Regression Analysis.
Topics
Description: Learn about the Multiple Logistic Regression and understand the Regression Analysis, Probability measures and its interpretation. Know what is a confusion matrix and its elements. Get introduced to “Cut off value” estimation using ROC curve. Work with gain chart and lift chart.
Topics
Description: Get introduced to Multinomial regression, or otherwise known as multinomial logistic regression, learn about multinomial logit models and multinomial logistic regression examples.
Topics
Data Mining Unsupervised
Description: As part of Data Mining Unsupervised get introduced to various clustering algorithms, learn about Hierarchial clustering, K means clustering using clustering examples and know what clustering machine learning is all about.
Topics
Hierarchial
Description: In this continuation lecture learn about K means Clustering, Clustering ratio and various clustering metrics. Get introduced to methods of making optimum clusters.
Topics
Description: Learn to apply data reduction in data mining using dimensionality reduction techniques. Gain knowledge about the advantages of dimensionality reduction using PCA and SVD.
Topics
Description: Under data mining unsupervised techniques, learn about Network Analytics and the measures used. Get introduced to Network Analysis tools like NodeXL.
Topics
Description: Learn one of the most important topic Association rules in data mining. Understand how the Apriori algorithm works, and the association rule mining algorithm.
Topics
Description: Learn how online recommendations are made. Get insights about online Recommender System, Content-Based Recommender Systems, Content-Based Filtering and various recommendation engine algorithms. Get to know about people to people collaborative filtering and Item to item collaborative filtering.
Topics
Description: Text mining or Text data mining is one of the wide spectrum of tools for analyzing unstructured data. As a part of this course, learn about Text analytics, the various text mining techniques, its application, text mining algorithms and sentiment analysis.
Topics
Description: Learn how to extract data from Social Media, download user reviews from E-commerce and Travel websites. Generate various visualizations using the downloaded data.
Topics
Description: Learn how to perform text analytics using Python and work with various libraries that aid in data extraction, text mining, sentiment analysis and
Topics
Description: Natural language processing applications are in great demand now and various natural language processing projects are being taken up. As part of this tutorial, learn about Natural language and ‘Natural language understanding’.
Topics
Classifiers
Description: Learn about Machine Learning modeling using KNN, the K nearest neighbour algorithm using KNN algorithm examples. The KNN classifier is one of the most popular classifier algorithms.
Topics
Description: Under the Naive Bayes classifier tutorial, learn how the classification modeling is done using Bayesian classification, understand the same using Naive Bayes example. Learn about Naive Bayes through the example of text mining.
Topics
Description: Decision Tree and Random Forest are one of the most powerful classifier algorithms today. Under this tutorial, learn about Decision Tree Analysis, Decision Tree examples and Random Forest algorithms.
Topics
Description: Bagging and Boosting is an ensemble technique which is a part of the random forest algorithm. Learn about Bagging and Boosting examples under this tutorial.
Topics
Description: Artificial Neural Network and Support Vector Machines are the two powerful Deep learning algorithms. Get introduced to Neural Net, Convolutional Neural Network, Recurrent Neural Network. Learn how to work with Support Vector Machine, SVM classifiers and SVM regression.
Topics
Description: Forecasting or Time Series Analysis is an important component in analytics. Here, get to know the various forecasting methods, forecasting techniques and business forecasting techniques. Get introduced to the time series components and the various time series analysis using time series examples.
Topics
Assignments/Projects/Placement Support
Predicting the flight delays
Predict impurity in ore
Predicting the oil price
Electric Motor Temperature
"Daily" Twitter Data Analysis for a Product
Natural Language Processing
Value added courses
Introduction to R Programming
How To Install R & R Studio
Data Structures in R
Programming Statistical
How to Import Dataset in R
R-Packages
How to Integrate R and SQL
How to Get Data From SQL to R
Introduction to python
Description: You will get an introduction to the Python programming language and understand the importance of it. How to download and work with Python along with all the basics of Anaconda will be taught. You will also get a clear idea of downloading the various Python libraries and how to use them.
Topics
Basic Python
Description: In this module, you will learn the basics such as assigning a variable, differences between dictionary, sets, tuple, and some decision making statements. Also, you will learn about working with different loops, data types and its usage.
Topics
Working with libraries like NumPy, Pandas, Matplotlib, Seaborn, SciPy, Sklearn In Python
Description: This module helps you to learn and understand the different libraries used in Python. You will also get a clear idea about the NumPy library and how you can use it. NumPy is a Numeric Python library which helps in dealing with the numeric calculations with data frames.
Topics
Working experience with Pandas In Python
Description: In this module, you will learn how to download the Pandas package and syntax for the same. Pandas is also a library similar to Numpy which predominantly helps in working with series data and data frames. You will learn how to impute the data in the place of missing values called the missing value treatment done in the Pandas package itself.
Topics
Working experience with Matplotlib library In Python
Description: In this module, you will learn where, how and when to use the Matplotlib library. This library is used to visualize the data. You will get an in-depth understanding of the importance of this library.
Topics
Description: This module will help you to understand the importance of Seaborn package and downloading the library Just like the Matplotlib library, the Seaborn library is also used in visualizing the data allowing high-level visualizations with categorical data.
Topics
To work with Seaborn Library (High-level interface for drawing attractive and informative statistical graphics) In Python
Description: This module will help you to understand the importance of Seaborn package and downloading the library Just like the Matplotlib library, the Seaborn library is also used in visualizing the data allowing high-level visualizations with categorical data.
Topics
Introduction to SciPy and Sklearn Libraries In Python
Description: In this module, you will understand the importance of both Scipy and Sklearn libraries which are predominantly used in building Machine Learning Algorithms working with Linear Equations. Sklearn also known as Scikit-learn, is a machine learning library for the Python programming language. You will get a clear idea of where you can use these libraries along with some examples.
Topics
What is Data Visualization?
Tableau – Data Visualization Tool
Tableau User Interface
Basic Chart types
Intermediate Chart
Advanced Charts
Maps in Tableau
Adding Background Image
Data Connectivity in-depth understanding
Creating Calculated Fields
Responsive Tool Tips
Connecting Tableau with Tableau Server
Connecting Tableau with R
Contact Our Team of Experts
Why ExcelR?
Global Presence
ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.
