I’m Interested in This Program

  • I authorize the representatives of Acadgild to contact me. This overrides registry on DND/ NDNC.
  • This course includes
  • - 72 hours of live classroom
  • - 200 Hours of Industry Cases & Projects
  • - 24 X 7 Coding Support
  • - Gamified Learning
  • - Lifelong Access to Course Material
  • - International Certification
  • - Job Assistance

ONLINE COURSE FEES
999

Data Analytics with R, Excel, Tableau Course

Course Overview

4.3(50)

  • Intensive 4-month Program
  • Collaborative Assignments with Mentors
  • Master Statistics, Machine Learning and Data Visualization
  • Learn Tools like R, Excel and Tableau
  • DURATION 12 Weeks
    EFFORT 10-15 Hrs/Week
    CAREERS Business Analyst, Data Analyst, Data Visualization Analyst, Business Analyst, Data Manager, Statistician.

    Enroll

    View Details

    Enroll

    Try for Free!
    Valid for 10 days

    Why You Should Take This Course

    Demand for R

    36% of analytics job postings have R as a skill requisite.

    Growing Field:

    Data analytics services are expected to generate a revenue of $187 billion by 2019.

    Well-Paying Jobs:

    Data Analysts earn around Rs 349,284 per year on average.

    How this course can transform your Career

    Acadgild Career Assistance

    Orientation

    Getting you up to speed

    Intial Phase


    Live Mentor
    Sessions

    Career Preperation

    • Interview Questions
    • Mock Interview
    • Online Reputation Building
    • Networking

    Second Phase


    Live Mentor
    Sessions

    Career Preperation

    • Interview Questions
    • Mock Interview
    • Online Reputation Building
    • Networking

    Final Phase


    Live Mentor
    Sessions

    Career Preperation

    • Interview Questions
    • Mock Interview
    • Online Reputation Building
    • Networking

    Corporate Partners

    What will you learn in this course

    • Basics of R
    • Conditional and loops
    • R packages/libraries
    • Data mining GUI in R
    • Data structures in R
    • Exceptions/ debugging in R

    • Reading CSV, JSON, XML, .XLSX and HTML files using R
    • ETL operations in R
    • Sorting/ merging data in R
    • Cleaning data
    • Data management using dplyr in R

    • Descriptive statistics, random variables, and probability distribution functions
    • Data distributions like uniform, binomial, exponential, poisson, etc
    • Probability concepts, set theory and hypothesis testing
    • Central limit theorem, t-test, chi-square, z-test
    • Central limit theorem
    • ANOVA

    • Linear regression model in R
    • Multiple linear regressions model
    • Representation of regression results
    • Non-linear regression models
    • Tree-based regression models
    • Decision tree-based models
    • Rule-based systems

    • Association analysis
    • Market-based analysis/ rules
    • Apriori algorithm
    • Ensemble models - random forest model, boosting model
    • Segmentation analysis- types of segmentation, k-means clustering, Bayesian clustering.
    • Feature selection/ dimension reduction- multidimensional scaling, dimension reduction, factor or
    • component analysis.
    • Axes
    • Covariance

    • Basics of time series
    • Components of time series
    • Time series forecasting
    • Deploying predictive models
    • Using SQL server
    • Using external tools
    • Using big data tools
    • Integrating R with Hadoop/Spark

    • SQL queries
    • Integrating with R
    • Deployment and execution
    • Data modeling and formatting using Excel
    • Excel formulas to perform analytics
    • Macros for job automation

    • Introduction to Tableau and its layout
    • Connecting tableau to files and databases
    • Data filters in Tableau
    • Calculation and parameters
    • Tableau graphs and maps
    • Creating Tableau dashboard
    • Data blending
    • Creating superimposed graphs
    • Integrating Tableau with R

    Compare our courses with others

    FEATURES acadgild logo OTHER VIRTUAL
    LIVE CLASSES
    SELF PACED
    COURSES
    DURATION 12 10-12 Weeks 4-6 Weeks
    LIVE TRAINING HOURS 72 40 -
    TOTAL CODING HOURS 200 100-120 40-50
    PROJECTS acadgild logo acadgild logo acadgild logo
    Gamified Dashboard acadgild logo Rarely provided acadgild logo
    Lifetime Access to Dashboard acadgild logo acadgild logo acadgild logo
    24x7 Coding Support acadgild logo Rarely provided acadgild logo
    Job Assistance Program acadgild logo Rarely provided acadgild logo
    Portfolio Development acadgild logo acadgild logo acadgild logo
    PRICING 999 2000 - 5000 25 - 50

    FAQs

    This course teaches techniques of data analysis and communication using technologies like R, Tableau, and Excel. It covers key concepts, and provides practical experience via real-time projects to help develop skills that are relevant and useful for careers in data analytics.


    The course is suited for anyone with a zeal to learn about data analytics. It is ideal for aspiring data analysts from different backgrounds. Our students are generally analysts, developers, managers, information architects, researchers, and other working professionals looking to advance in the field of data analytics.


    You need knowledge of math and statistics. Knowledge of R programming language would be a plus. Having said that, the course covers the basics of R.


    You will learn Data Analytics and Data Visualization tools. You will learn R, Tableau and Excel primarily, and bits of Hadoop, Spark, SQL and other big data technologies additionally.


    Acadgild provides quality training to anyone with the zeal to learn. We offer a great platform for you to master Data Analytics. Our courses have world class content, offer a gamified learning experience, and include real-time projects to help you gain practical exposure. Additionally, you will be mentored by leading experts in the industry, and will have support around-the-clock from SMEs (Subject Matter Experts) to help you resolve your queries.


    The course will make you proficient in:

    • Data Manipulation
    • Exploratory Data Analysis
    • Data Visualization
    • Linear Models
    • Data Analytics with Visualization using Tableau
    You don’t need to follow this course with another. This course covers most of the skills required to help you land a lucrative job as a data professional.


    Yes, you may. Our curriculum is comprehensive and will make you capable to create your own project. Our support staff is also committed to help you along the way. Alternately, you can work on one of the projects in our repertoire to implement what you learn.


    All sessions are recorded and uploaded to the course dashboard for you to access at your convenience.


    Our mentors are top-notch industry professionals with at least 5 years of experience. You will be taught by the best in all batches.


    You can view a recorded demo session in the Course Overview section. Alternately, you can sign up for a live demo there.


    Yes, we offer free resources like e-books, and blog articles on generic and technical topics by SMEs. You may view these in the free resources section - https://acadgild.com/blog/.


    Our job placement program offers students one-on-one career counselling, and the chance to work with our corporate partners.
    Candidates who fulfill the following criteria will be eligible for the program:
    • Scored 75% marks or above (resulting in a Platinum certificate) in the course.
    • Successfully completed at least 2 quality projects.
    • Scored 80% in all the mock technical interviews.
    • Was never found plagiarizing code.


    You can pay after registering for the course. We accept most credit and debit cards. You can also pay via net banking. Our payment portal has an EMI option if you wish to pay in installments.


    Our ‘Refer and Earn’ program gives you a discount on the course fees when your references join us. You may refer students by writing to us at [email protected]
    The details of the Refer and Earn policy can be found at https://acadgild.com/refer-and-earn.


    To request a refund, write to us at [email protected] You may apply for a refund in the first three days after paying the fees. No requests will be entertained after this initial period. The terms and conditions of AcadGild’s refund policy may be revised without prior notice. Please check websites for updates on this policy.


    You can write to us at [email protected] with your contact details. Our representatives generally respond to requests within 24 hours.


    The Acadgild Gazette

    BIG DATA

    How Hadoop is Used in Organizations

    Some of the biggest organizations worldwide are using Hadoop, but do you know the History behind the creation of Hadoop framework? Did you know Hadoop came into being, inspired by Google’s GFS and MapReduce architecture? Want to know more? Our blog will tell you.

    BIG DATA

    Take Your Career Ahead with Big Data

    It is no secret that the big data jobs are one of the most lucrative jobs of the century. But how does the future look like for big data professionals? How much are big data professionals pad? Find out the answers in our blog.

    BIG DATA

    Importance of Big Data in the Banking Segment

    As Big Data is gradually spreading in wings in different domains, it has emerged as an integral contributor in the field of banking and finance. Find out more about this interesting development from our blog.

    • (+91) 888 002 5025
    • (+1) 888 884 8355