Udemy

Data Analysis Course for Beginners SQL ,R, Excel [2025]

Enroll Now
  • 633 Students
  • Updated 1/2025
4.1
(57 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
12 Hour(s) 43 Minute(s)
Language
English
Taught by
Piyush S | insightEdge100.com
Rating
4.1
(57 Ratings)

Course Overview

Data Analysis Course for Beginners SQL ,R, Excel [2025]

Data Analysis Course for Beginners SQL ,R, Excel. Learn the art of Data Analysis & Visualizations for Data Science.

*Lifetime access to course materials . Udemy offers a 30-day refund guarantee for all courses*

*Taught by instructor with 15+ years of Data Science and Big Data Experience*

The course is packed with real life projects examples and has all the contents to make you Data Literate.


  1. Get Transformed from Beginner to Expert .

  2. Become expert in SQL, Excel and R programming.

  3. Start using SQL queries in Oracle , MySQL and apply learning in any kind of database

  4. Start doing the extrapolatory data analysis ( EDA) on any kind of data and start making the meaningful business decisions.

  5. Start writing simple to the most advanced SQL queries.

  6. Integrate R and Python with Database and execute SQL command on them for data analysis and Visualizations.

  7. Start making visualizations charts - bar chart , box plots which will give the meaningful insights

  8. Learn the art of Data Analysis , Visualizations for Data Science Projects

  9. Learn to play with SQL on R and Python Console.

  10. Integrate RDBMS database with R and Python

  11. Create own database in your laptop/Desktop - Oracle and MySQL

    Import and export data from and to external files.

Real world Case Studies Include the analysis from the following datasets

1. Bank Marketing datasets ( R )

2. Identify which customers are eligible for credit card issuance ( R)

3. Root Cause Analysis of Uber Demand Supply Gap ( R)

4. Investment Case Studies: To identify the top 3 countries and investment type to help the Asset Management Company to understand the global trends ( EXCEL)

5.  Acquisition Analytics on the Telemarketing datasets : Find out which customers are most likely to buy future bank    products using tele-channel. ( EXCEL) )

6. Market fact data.( SQL)

Course Content

  • 10 section(s)
  • 154 lecture(s)
  • Section 1 Introduction
  • Section 2 Dataframes in R
  • Section 3 Constructs in R programming
  • Section 4 Visualizations in R
  • Section 5 Case Study- Uber Demand Supply Gap
  • Section 6 Introduction to the World of SQL and Databases
  • Section 7 Database Installation - Oracle and MySQL
  • Section 8 Oracle vs MySQL Resources
  • Section 9 Basics of SQL - Write your 1st SQL
  • Section 10 Advance SQL

What You’ll Learn

  • R programming from Beginning to Advance
  • Data Visualizations using ggplots and Base plots
  • Learn to plot scatter , bar chart , histograms, time-series and bring up the actionable insights
  • Upload real world data like bank marketing data with 45,000 records
  • Start writing simple to the most advanced SQL queries in Oracle and MySQL
  • Start using SQL queries on powerful R and Python console and plots graph for visualizations and data analysis
  • Create your own database in your laptop - Oracle and MySQL
  • Import & export files from and to databases
  • Case Study for Acquisition Analytics to find out which customer segment is the most profitable using EXCEL
  • Investment Case Study to identify the top3 countries and investment type to help the Asset Management Company to understand the global trends using EXCEL


Reviews

  • O
    Oloka Octavia Japians
    4.0

    alot was clear but some videos didn`t have clear communication. I didn`t like how afte saying we don`t need to get Oracle and he won`t use it, he went on to use oracle but its fine. otherwise LOVED it. very grateful

  • A
    Alabi Damilola David
    3.0

    yes. but at some point i got confused cos all notes were appearing on screen making it too much for me to capture at a time

  • M
    Michael Leonor
    5.0

    The class is beneficial for beginners with some practice questions and real-life projects. Highly recommend

  • R
    Rafiq Naufal Shidiq
    5.0

    I enjoy taking this course. This course give both theory and practice using real-life case study projects. So, I can learn all of them in one course.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed