Get in Touch
 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.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories