Data Analytics Coding Fundamentals

Code: BIDA302
Apply this course towards: Business Intelligence and Data Analytics, Business Administration – Certificate, Business Administration – Diploma

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 R, Python and Excel. This will allow you to import and export data appropriately, perform fundamental data manipulations, and automate basic analysis elements.

Learning objectives

  • Perform basic data manipulations
  • Create variables
  • Apply key concepts of variables, constants and functions
  • Calculate descriptive statistics
  • Perform basic logical formula functions
  • Group and ungroup data
  • Data importing
  • Data exporting
  • Extract and combine data
  • Create what-if scenarios

Prerequisites

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.

Required equipment and software

  • Personal computer with reliable internet connection – a machine with administrative privileges is recommended
  • Webcam or HD webcam – built-in, USB plug-in is recommended
  • Speakers and microphone – built-in, USB plug-in, or wireless Bluetooth
  • Operating system:
    • Microsoft Windows 10
    • Microsoft Windows Server 2008 SP2–2016
    • Microsoft Windows 8.0 and 8.1
    • macOS 10.14 Mojave or later
  • Microsoft Office:
    • Recommended: Excel for Microsoft 365 on Windows or macOS; or at least Excel 2019 or Excel 2016
    • Microsoft Office 365 – Students will benefit from Microsoft Office 365 as it is free for the UVic community. Once you have your Netlink ID account, you can sign up for your UVic Microsoft 365 account at onlineservices.uvic.ca and download the software.
  • Hardware (minimum):
    • Processor: 1.4GH (this allows you to use Zoom, Excel and Brightspace at the same time)
    • RAM: 2GB
    • Disk space: 2GB
  • For specific Zoom system recomendations, please visit the Zoom support website

Funding

This course is eligible for the StrongerBC future skills grant. To register using this grant please review the eligibility, registration details and funding dates. 

Registration details

Select your offering:

You have already registered for this course.

View My account

This item is already in your shop cart.

View shop cart
Loading section fee(s)...

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

Sorry, this section is full.

FEES
Fee Tax Subtotal
{{ ::(fee.price | currency) }} {{ ::(fee.tax | currency) }} {{ ::(fee.total | currency) }}
{{ ::(child.price | currency) }} {{ ::(child.tax | currency) }} {{ ::(child.total | currency) }}
    Total {{ fee.totalFees | currency }}

Add to Shop Cart Loading

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

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

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' : 'Sign in/create a new account to add to wish list' }}

Info you should know:

Continuing Studies statement on use of educational technology

This course will require the use of Zoom and may use other education technology such as internet-based applications, cloud services, or social media. In order to complete this course you will be required to either consent to the disclosure of your personal information outside of Canada to enable use of these technologies, or work with the Division of Continuing Studies to explore other privacy protective options (such as using an alias or nickname).