Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
- Introduction
-
Understanding Data Analytics
• Examples of Data Analytics
• Beginning to interpret data
• Using basic statistics to interpret data
• Using charts to interpret data -
R and Python
• Comparing the use of R vs. Python for Data Analysis -
Setting Up the Working Environment
• Getting Ready to Code
• Writing Data from R to a File
• Preparing the Working Environment
• Downloading and setting up R and RStudio to ensure the environment is functional -
Generating Data Summaries and Observations
• Data Observations
• Data Observations - Filtering the Data
• Modifying the provided R scripts, executing them to obtain results, and verifying the output -
RMarkdown
• Introduction to RMarkdown
• Updating the RMD file for your specific environment and executing it to validate results. -
Statistical Measures
• Statistical Measurements -
Plots and Charts
• Charting and Plotting Techniques
• Box Plots - Five Key Metrics
• Updating R scripts for your environment, executing them, and verifying the output. -
Correlation
• Calculating the Correlation Coefficient -
Mosaic Plots
• Constructing Mosaic Plots
• Troubleshooting code to ensure chart labels are legible within the designated area -
Pie Charts
• Creating Pie Charts
• Updating code to generate a Sales Pie Chart for segments within the same dataset -
Scatter Plots
• Creating Scatter Plots
• Using the provided R script to update and generate scatter plots for all variables. -
Line Graphs
• Creating Line Graphs
• Taking the first 20 rows of the dataset, updating the R script, and executing it -
Q-Q Plots
• Q-Q Plots - Quantile-Quantile plots
• Updating the R script to generate a Q-Q plot for Discounts -
Python Environment
• Setting up the Python Environment
• Adding comments to the Python code (Data_Sumamry.py)
• Running the script using the VS Code IDE
• Getting Started with Python
• Running the script in your RStudio environment; updating the script as needed -
Python and Plotting
• Converting working R code to Python
• Handling Python Nulls and NAs
• Plotting in Python
• Writing Python code for bar charts and histograms based on R scripts from previous sections -
Capstone Project
• Analyzing data for the provided dataset - Financial Sample.xlsx
• Executing Project Work -
Databases and SQL
• Databases and Structured Query Language
• Installing MySQL database and verifying your environment
• Getting started with Python and SQL integration
• Installing MySQL libraries
• Using GUI tools for MySQL databases
• Installing DB Visualizer
• Using Python with SQL
• Running queries using Python with MySQL databases
Requirements
Practical experience with computers and software, along with fundamental knowledge of mathematics and statistics. Prior programming experience is beneficial. This course is appropriate for both technical and business professionals who are eager to learn.
Testimonials (3)
Learning that the QGIS and a tool that can used by other different professionals such land survey
Bame Duncan Koko - Bentel Technologies (Pty) Ltd
Course - QGIS for Geographic Information System
How to use open satellites data for real applications
Tshering Dorji - Druk Holding and Investments
Course - Advanced Geographic Information Systems (GIS)
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.