Data Analytics Provisioning, Importing, Extracting and Manipulation

Code: BIDA405
Apply this course towards: Business Administration - Certificate, Business Administration - Diploma, Business Intelligence and Data Analytics

Course description

This course will explore the fundamentals of coding and scripting for Data Analytics. You will develop the ability to script and code for basic tasks in Data Analytics in common data analytic tools such as SQL, R, Python, and Excel. This will allow you to import and export data appropriately and perform fundamental data manipulations and to automate basic analysis elements.

Learning objectives

  • Construct complex scripts in R, Python and JavaScript to solve problems
  • Apply appropriate safeguards for data privacy and security

Perform the following basic tasks in R, Python, and JavaScript as appropriate:

  • Import and export data
  • Clean data
  • Compile data
  • Extract data
  • Manipulate data
  • Prepare data for visualization and reporting


​​It is recommended that students have completed BIDA301 Business Intelligence and Data Analytics Fundamentals and BIDA302 Data Analytics Coding Fundamentals, or have basic experience coding in R or Python as well as experience using formulas in Excel.

Required equipment/software:

  • Personal computer with internet connection

English language requirement:

If your first language is not English, you will be asked to provide evidence of fluency through the submission of an IELTS (Academic) score of minimum 6.0 (with no component less than 5.5), TOEFL score of 550 (79 Internet Based TOEFL), completion of the UVic English Language Centre's ELPI 570 level, or equivalent level through one of our English pathway partners.

Registration details

You have already registered for this course.

View My account

This item is already in your shop cart.

View shop cart
Fee Tax Subtotal
{{ ::(fee.price | currency) }} {{ ::( | currency) }} {{ ::( | currency) }}
{{ ::(child.price | currency) }} {{ ::( | currency) }} {{ ::( | currency) }}
    Total {{ fee.totalFees | currency }}

Add to Shop Cart

Note: You will be asked to log in or create an account to register and pay for this course.

Having trouble registering online? Register by phone: 250-472-4747

You're already on the waiting list for this item.

Sorry, this section is full.

Online registration temporarily unavailable

Sorry, this course is not available for registration at this time.

This course is in progress. Please contact us for more details.

Online registration is closed for this course. You may still be able to register by phone. Call 250-472-4747 to find out.

This course is on your wish list. You will be notified when this course becomes available.

Want to receive notification when this course becomes available?

{{ loggedIn ? 'Add to wish list' : 'Login/create a new account to add to wish list' }}

Info you should know: