Data Analytics: Insights from Tomorrow's Experts

DATA-3215
Closed
Holland College
Charlottetown, Prince Edward Island, Canada
Chris Stewart
Learning Manager
(2)
2
Timeline
  • December 16, 2023
    Experience start
  • December 16, 2023
    Identify a Client
  • January 29, 2024
    Mission Statement & Stakeholder Analysis
  • February 8, 2024
    Project Scope Statement
  • February 14, 2024
    Written Proposal
  • February 16, 2024
    Approval to Proceed
  • April 26, 2024
    Experience end
Experience
12/11 project matches
Dates set by experience
Preferred companies
Canada
Any company type
Any industries
Categories
Artificial intelligence Databases Data visualization Data analysis Data modelling
Skills
sql python data prep stats ml coding ethics prediction etl
Learner goals and capabilities

Our data analytics students harness advanced tools and methodologies to dissect complex datasets, offering actionable insights tailored to your business needs. By collaborating with these future experts, companies gain a fresh perspective, innovative solutions, and a detailed analytical roadmap to drive strategic decision-making.

Learners
Graduate
Any level
25 learners
Project
90 hours per learner
Learners apply to projects
Teams of 2
Expected outcomes and deliverables

Format of Deliverables:

Deliverables may include, but are not limited to, some or all of the following:

  1. Written Proposal: Before embarking on the analysis, employers receive a detailed written proposal. This document outlines the scope, intended benefits, critical processes affected, resources to be used, and a comprehensive data overview. It sets the stage and expectations for the project.
  2. Interactive Dashboards: Students utilize tools like Power BI, Office, or Python to develop dynamic and intuitive dashboards. These offer an at-a-glance view of the key metrics, historical trends, and insights, tailored to the specific needs and objectives of the project.
  3. Detailed Reports: Alongside dashboards, students prepare comprehensive written reports. These delve deep into the analysis, providing context, interpretation, and actionable recommendations. Each report is structured to begin with an executive summary, followed by a detailed analysis, and concluding with proposed next steps.
  4. Data Models & Pipelines: For projects involving data infrastructure setup, students provide structured data models with documentation and a schematic view of proposed data pipelines. These elements ensure seamless data flow and advanced analysis.
  5. Presentation Slides: At the end of the project, employers receive a slide deck summarizing the project's objectives, methodologies used, key findings, and recommendations. This format is ideal for sharing insights with broader teams or stakeholders.


Expected Outcomes:

  1. Clear Understanding: Employers will gain a deeper understanding of their data, the insights it hides, and the opportunities it presents. This knowledge will enable more informed decision-making.
  2. Actionable Recommendations: Each project culminates with actionable steps that businesses can undertake, based on the insights derived from the data. These recommendations can range from operational changes to strategic shifts.
  3. Enhanced Decision-making: With the combination of interactive dashboards and detailed reports, businesses will be equipped to make data-driven decisions swiftly and with greater confidence.
  4. Skill Transfer: Employers will benefit from the latest methodologies and tools used in the realm of data analytics. Interactions with students can lead to skill transfer, enhancing the internal capabilities of the company.
  5. Future Roadmap: Beyond immediate insights and actions, employers will also receive suggestions for future data projects or areas worth exploring, providing a roadmap for continuous data-driven improvement.


Project timeline
  • December 16, 2023
    Experience start
  • December 16, 2023
    Identify a Client
  • January 29, 2024
    Mission Statement & Stakeholder Analysis
  • February 8, 2024
    Project Scope Statement
  • February 14, 2024
    Written Proposal
  • February 16, 2024
    Approval to Proceed
  • April 26, 2024
    Experience end
Project Examples

Projects from prior years:


  • End to end reporting of sales data for a client in a regulated industry, including automation of sales metrics reporting dashboards in PowerBI.
  • Modelling of lab testing procedures for a pharmaceutical CDMO leading to pipeline developments, scheduling process improvements and predictive modelling using AI of sample testing times.
  • Metric development, KPI reporting and automation of quality operations reporting for a pharmaceutical CDMO.
  • Reporting & Data Maturity Model research , selection, and recommendations for a national not for profit.
  • Labour market data modelling and analysis, design recommendations for a Data-warehouse to support online applications.
  • Analyzing student retention data for a provincial community college
  • Written report analyzing national demographic trends with projections over 25- and 50-year periods.
  • Designing and building a data collection pipeline for Academic Alerts at a provincial community college


Projects Ideas:


  • Historical Data Dashboarding and Metric Development: Students can visualize historical trends and data points using interactive dashboards, making complex datasets more digestible. Alongside this, they're skilled in metric development, ensuring that businesses measure what truly matters to them. Together, these tools enable businesses to track their performance effectively over time and make data-informed decisions.
  • Customer Segmentation and Sales Forecasting: Leveraging data, students categorize customers into distinct segments and predict future sales trends, aiding targeted marketing and strategic planning.
  • Churn Analysis and Customer Sentiment: Analyzing customer behaviours helps in predicting potential churn while gauging sentiment from platforms can determine perceptions towards a brand, aiding retention and reputation management.
  • Supply Chain Optimization and Operational Efficiency Analysis: Through data, students pinpoint and rectify inefficiencies in the supply chain and broader business operations, leading to cost savings and streamlined processes.
  • Maturity Model Application: Students apply tailored maturity models, like BI maturity or Data Fluency Inventory, helping businesses chart their growth and sophistication journey.
  • Website Traffic Analysis and Product Recommendation Systems: Evaluating web traffic and user behaviours, students can suggest enhancements for website design and develop algorithms for tailored product recommendations.
  • Fraud Detection and Business Security: Identifying unusual transaction patterns, students can propose models to detect potential fraudulent activities, strengthening business security.
  • Data Modelling and Pipeline Design: Skilled in building data models for complex scenarios, students can also set up efficient data pipelines, ensuring seamless data flow and advanced analysis.
  • Market Basket Analysis and Cross-Selling Strategies: Recognizing products often purchased together, businesses can be advised on promotions or placements to boost sales through effective cross-selling.