info@basetsana.co.za    + 27 (0) 63 186 9288    +266 62 620 023

Courses offered

Introduction to R for Business Intelligence

This course is designed with R-Programming beginner in mind for business intelligence. Get up to speed in the use of R-programming and learn business intelligence and presentation and reporting of results.

Course Content

  • Extract, Transform, and Load
  • Data Cleaning
  • Exploratory Data Analysis
  • Regression analysis for Business
  • Data Mining with Cluster Analysis
  • Time Series Analysis.
  • Visualizing Data
  • Web Dashboards with Shinny
Data management using R

This course is designed for data managers. This course is on the use of wide range of transformations, merging several datasets from different data sources such SPSS, STATA, Excel, SAS etc to automate work, manipulates data files and results; send output toother applications like, Latex, MS word, Acrobat reader etc. You will gain various options for operating R/Rstudio and how to use different available syntax (R Bash, 3D, Python, Rcpp, SQL and Stan) for performing data transformations and data analysis efficiently.

Course Content

  • Data Input and Output
  • Data Management
  • Statistical and Mathematical Functions
  • Programming and Operating System
  • Common Statistical Procedures
  • Linear Regression and ANOVA
  • Regression Generalization and Modelling
  • A Graphical Compendium
  • Graphical Options and Configuration
  • Simulation
  • Special Topics
Big Data Science and Analytics

This is an application oriented course to big data analytics using R. You will be looking at several big data applications or methods using R programming.

Course Content

  • Big Data Concepts (This includes setting up big data stack, big data patterns and No-SQL)
  • Big Data Analytics Implementation (This includes (1) Data acquisition. (2) Publish-Subscribe Messaging frameworks. (3) Big data collection systems (4) Messaging Queues.(5) Custom Connectors.)
  • Big Data Storage
  • Batch Analysis
  • Real Time Analysis
  • Interactive querying( This includes (1) Spark SQL (2) Hive (3) Amazon Redshift (4) Google Big Query)
  • Serving Database and Web Frameworks (This includes (1)Relational (SQL) Databases. (2) Non-Relational(SQL) databases)
  • Advanced Topics
  • Data Visualization