Data Analytics Capstone Project

PROJ 006
Closed
EDGE UP
Calgary, Alberta, Canada
Instructor
(5)
3
Timeline
  • November 1, 2021
    Experience start
  • October 19, 2021
    Data Understanding/Data Preparation
  • November 10, 2021
    Project Scope Meeting
  • November 24, 2021
    Check-in
  • December 11, 2021
    Managing Data in the Cloud
  • December 11, 2021
    Check-in
  • December 25, 2021
    Experience end
Experience
10/10 project matches
Dates set by experience
Preferred companies
Canada
Any
Any industries
Categories
Information technology Data analysis
Skills
business analytics business consulting data analytics storytelling and data visualization data analysis
Learner goals and capabilities

Are you a firm looking to explore the value of data analytics? Students in the SAIT Data Analytics certificate are trained in data extraction and transformation as well as data preparation, data modeling and reporting on pre-existing data gathered by the organization. These students will work with your organization to analyze your data sets and provide any recommendations they may have as a result of the analysis.

EDGE UP (Energy to Digital Growth Education and Upskilling Project) is a multi-stakeholder program launched in Calgary in 2019 to test new approaches to skills development for workers to re-engage with technology jobs being created in all sectors of Calgary’s economy. The program targets professionals displaced from the structural change in the oil and gas sector.

This program is funded by the Level UP program (powered by Riipen). Students are paid a $1400 CAD stipend on completion of the project by Riipen. Employers are not responsible for payment. You can learn more here.

Learners
Certificate
Any level
46 learners
Project
30 hours per learner
Learners self-assign
Teams of 6
Expected outcomes and deliverables

The final project deliverable will include:

  1. A report outlining the work they performed, analysis they conducted including visualizations and recommendations they may have as a result of the analysis. The students will provide a proof of concept of the solution.
  2. A 20-minute presentation of the project and results to the industry partner and classmates.

If you're interested in working with students beyond their capstone projects, we invite you to look into the work-integrated learning placement opportunity:

ICTC’s WIL Digital is an innovative Work Integrated Learning program that helps small and medium-sized employers grow their businesses by providing the wage subsidy for hiring EDGE UP 2.0 participants. The wage subsidy is at 75% of salary up to a maximum of $7500. The employer must provide a meaningful work integrated learning opportunity for EDGE UP 2.0 participants. The placement takes place between Jan- Mar 2022.

Employers, please indicate your interest in WIL Digital by writing to ICTC: edgeup@ictc-ctic.ca

Project timeline
  • November 1, 2021
    Experience start
  • October 19, 2021
    Data Understanding/Data Preparation
  • November 10, 2021
    Project Scope Meeting
  • November 24, 2021
    Check-in
  • December 11, 2021
    Managing Data in the Cloud
  • December 11, 2021
    Check-in
  • December 25, 2021
    Experience end
Project Examples

Beginning in October, students in groups of 4-5 will spend around 100 hours assisting your company by providing analytical research and recommendations tailored to one of your company’s data opportunities or challenges.

Students will develop the following skills and competencies and will develop the knowledge, skills, and aptitude to apply fundamental principles of data analytics to support business decision-making processes, creating accurate and meaningful storytelling with actionable insights. They will accomplish this using a foundation of data management and ethics. The students are developing skills in the Microsoft stack and IBM SPSS, and will be expected to use these technologies for the project.

Program Outcomes

  • Understand database concepts and how to design and implement databases to maintain data integrity.
  • Develop skills to query data using SQL scripting.
  • Manipulate data using ETL principles (extract, transform, load) to develop a data repository that can then be analyzed in a business context that is relevant to decision-making.
  • Apply fundamental data analytics principles, aligning data and business processes to create accurate, actionable insights.
  • Use industry-recognized programs and tools to extract meaning from data (SPSS, Power BI).
  • Present data that communicate data analysis effectively and accurately for a business audience using visualizations (dashboards) and reports.
  • Develop skills in Python programming, specific to data analysis functions.
  • Introduce cloud principles for managing data in the cloud, using Microsoft Azure as the platform.

Students may work with the company in one of three ways

  1. Assist organizations in data gathering research and/or prepare data for future use by the organization. Students can help design and model databases to gather and store data for future analysis.
  2. Assist organizations in preparing existing data for analysis. Students may perform data quality checks, data cleaning, and data transformation exercises on existing data to ready data for analysis by the organization.
  3. Assist organizations in data analysis. Using organizational data, students may conduct data analysis and design data analytics reports to be delivered to the firm.

Project examples include but are not limited to:

  • Analysis of customer segmentation relative to different products and services, to enhance marketing campaigns and refocus your products/services.
  • Investigate predictive models to understand trends in sales, attrition rates, and profits that impact your business.
  • Propose new ways to visualize data through tables and plots that can provide new insights for managers.

Participating industry partners provide data sets.


Companies must answer the following questions to submit a match request to this experience:

Be available for a quick phone call with the instructor/project manager to initiate your relationship and confirm your scope is an appropriate fit for the course.

Provide a dedicated contact who is available to answer periodic emails or phone calls over the duration of the project to address students' questions.

Provide data sets for students to analyze