Course Information
Course Overview
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.
Get Transformed from Beginner to Expert .
Become expert in SQL, Excel and R programming.
Start using SQL queries in Oracle , MySQL and apply learning in any kind of database
Start doing the extrapolatory data analysis ( EDA) on any kind of data and start making the meaningful business decisions.
Start writing simple to the most advanced SQL queries.
Integrate R and Python with Database and execute SQL command on them for data analysis and Visualizations.
Start making visualizations charts - bar chart , box plots which will give the meaningful insights
Learn the art of Data Analysis , Visualizations for Data Science Projects
Learn to play with SQL on R and Python Console.
Integrate RDBMS database with R and Python
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
Skills covered in this course
Reviews
-
OOloka Octavia Japians
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
-
AAlabi Damilola David
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
-
MMichael Leonor
The class is beneficial for beginners with some practice questions and real-life projects. Highly recommend
-
RRafiq Naufal Shidiq
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.