Data Analytics Capstone Project
General
- Certificate
- 23 learners; teams of 5
- 80 hours per learner
- Dates set by experience
- Learners self-assign
Preferred companies
- 6/7 project matches
- Canada
- Academic experience
- Startup, Any, Small to medium enterprise
- Any
Categories
Skills
Project timeline
-
August 15, 2022Experience start
-
August 16, 2022Project Scope Meeting
-
August 25, 2022Check-in
-
September 3, 2022Final Report/Presentation
-
September 3, 2022Experience end
Timeline
-
August 15, 2022Experience start
-
August 16, 2022Project Scope Meeting
Meeting between project teams and company to confirm: project scope, communication styles, and important dates.
-
August 25, 2022Check-in
Present the preliminary work completed thus far, which may include research, findings and recommendations.
-
September 3, 2022Final Report/Presentation
Final deliverables, materials, and generated reports should be ready for presentation and submission.
-
September 3, 2022Experience end
Overview
- Details
-
Is your organization looking to explore the value of data analytics? Students will work in teams applying critical thinking, skills and knowledge learned in their 12-week Data Analytics program to solve a problem or opportunity in your organization related to data.
Using a data set provided by your organization, students will use data analysis methods to help you and your organization derive insights and make more informed decisions.
Training Components:
- Querying data using SQL scripting.
- Data Visualization - present data to communicate data analysis effectively and accurately.
- Python Programming Language - basic data science techniques using Python
- MS Excel - using Power Pivot and Power Query
- Database concepts - how to design and implement databases to maintain data integrity.
- Cloud principles - managing data in the cloud through Microsoft Azure.
- Learner skills
- Business analytics, Business consulting, Data analytics, Storytelling and data visualization, Data analysis
- Deliverables
-
Deliverables may vary depending on the scope of the project. It will be important to stick to the scope due to time limits and student abilities. The final project deliverable may include:
- A report outlining the work they performed, and 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.
- A 20-minute presentation of the project and results to the industry partner and classmates.
Project Examples
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.
Students may work with the company in the following ways:
- Assist organizations in preparing existing data for analysis. Students may perform data quality checks, data cleaning, and data transformation exercises on existing data to make the data ready for analysis by the organization.
- Assist organizations in data analysis. Using organizational data, students may conduct data analysis and design data analytics reports to be delivered to the firm.
- Create dashboards and reports to visualize the data and easy decision-making and insights.
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.
Project Timeline:
The project is expected to go into two phases as follows:
- Phase 1 (August 5 - 14): Students are focused on completing coursework in their full-time training program. Once a project is matched with a student project team, we expect that during this phase the initial project communications and sharing of project materials/resources can begin to ensure project objectives are agreed upon before starting Phase 2.
- Phase 2 (August 15 - September 2): Students have completed their coursework and will now be focused and working full time on your project.
Important notes:
- Please set clear project objectives with your student project team. Given the short timeframes, the goal/objective of the proposed project should be relatively simple.
- Your organization must offer a Non-disclosure agreement (NDA). The agreement should allow the students to show what they have done in the project and demonstrate samples of the work done. Confidential information can be removed.
- An IP agreement should be provided by your organization and signed by the students and a representative from your organization.
- If no IP or NDA is required for the project, please offer this in writing to the students to avoid future conflicts.
Additional company criteria
Companies must answer the following questions to submit a match request to this experience:
Provide data sets for students to analyze and all necessary resources/access for the project.
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.