Data Analytics Provisioning, Importing, Extracting and Manipulation
Code: BIDA405
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 SQL, 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
- Construct complex scripts in R, Python and SQL to solve problems
- Apply appropriate safeguards for data privacy and security
Perform the following basic tasks in R, Python and SQL as appropriate:
- Import and export data
- Clean data
- Compile data
- Extract data
- Manipulate data
- Prepare data for visualization and reporting
Prerequisites
It is recommended that students have completed the following courses:
- BIDA301 Business Intelligence and Data Analytics Fundamentals
- BIDA302 Data Analytics Coding Fundamentals
or
- Have basic experience coding in R or Python as well as experience using formulas in Excel.
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 internet connection
Funding
This course is eligible for the StrongerBC future skills grant. To register using this grant please first review your eligibility and then select the StrongerBC future skills grant fee type below.