Practicum in Data Analytics (DA 301)

DA301
Closed
Denison University
Granville, Ohio, United States
ML
Assistant Professor
1
Timeline
  • January 17, 2022
    Experience start
  • August 31, 2021
    Start of Semester
  • September 4, 2021
    Initial meetings
  • October 1, 2021
    Bid proposals
  • October 16, 2021
    Progress Reports
  • November 16, 2021
    Progress Report 2
  • April 1, 2022
    Experience end
General
  • Undergraduate; 3rd year, 4th year
  • 4 learners; teams of 4
  • 60 hours per learner
  • Dates set by experience
  • Learners self-assign
Preferred companies
  • 1 projects wanted
  • Anywhere
  • Academic experience
  • Any
  • Any industries
Categories
Data analysis Operations Project management Product or service launch
Skills
business analytics storytelling and data visualization data analysis, data science concepts, text analytics business and analytical problem framing model development deployment and documentation
Project timeline
  • January 17, 2022
    Experience start
  • August 31, 2021
    Start of Semester
  • September 4, 2021
    Initial meetings
  • October 1, 2021
    Bid proposals
  • October 16, 2021
    Progress Reports
  • November 16, 2021
    Progress Report 2
  • April 1, 2022
    Experience end
Overview
Learner goals and capabilities

Students in this 15-week practicum course apply their emerging analytics toolkit (statistics, data collection & wrangling, visualization, modeling) to provide data-driven deliverables and a formal report on a data-driven problem for your organization. Taken after students complete their foundational skill courses, this course affords students a real-world, client-based opportunity experience to develop and hone the skills critical to making DA useful to various audiences. A significant component of the course is working with professional clients and in-class instruction to develop program management, ethical, creative problem solving, collaborative, and communication skills (written, oral, and visual) appropriate for professional and/or public audiences. Students will synthesize, hone, adapt, and translate their data analytics skills through your puzzle while gaining experience with DA in a realistic context (for-profit, non-profit, government, academic research, etc...).

Expected outcomes and deliverables

Every team in the practicum is required to provide the following to the clients and instructors:

  1. A 2-page executive summary targeted to key stakeholders with key insights, suggestions, conclusions for the project at hand.
  2. A complete technical report (roughly 15-20 pages) detailing the project, subject matter research, methodologies, data collection/sourcing, analysis and models, and conclusions/suggestions
  3. All data relating to the project in appropriate, clean, and documented formats
  4. Any code and files necessary to reproduce the project
  5. A live final presentation

Teams often aim to provide additional deliverables uniquely suited to the client/project that may include, but are not limited to:

  1. Functional or prototype dashboards/visuals for the data and future work
  2. Interactive tools for future predictive modeling
  3. Reproducible code for future analysis and/or data collection
  4. Suggestions for future work, additional data sources, new methodologies, and ongoing collaboration
  5. Create and implement a plan for taking raw data and extracting useful information from data
  6. Evaluate results of data science analysis on a real-world dataset
  7. Synthesize results of a large data science project into a short video and website presentation
Project Examples

This practicum provides an opportunity for businesses, organizations, instructors, and undergraduate learners to collaborate to identify and translate a real problem into a data analytics problem. Starting with a mission-relevant puzzle or problem from a client, student teams undertake a semester-long project with the client that begins with necessary background domain research, project scope refinement, and a mock bid proposal. Project work typically includes moderate data collection, significant data preparation, descriptive analysis, and statistical modeling/testing - with the potential to include predictive modeling, machine learning implementation, and other more advanced techniques as appropriate to the project and conditional on the prior coursework of students assigned to your project. Practicum project results and recommendations (with other deliverables as agreed to by the client, instructors, and student teams) will be communicated through an executive summary, a formal technical report document, and a live final presentation.

A practicum client will be assigned two student teams of 3-4 undergraduate DA majors in their Junior or Senior year. Each team will come from a different section of the course led by separate instructors. The teams largely work independently in parallel, as a quasi-competition, under the expectation that the client will comparatively identify the strengths and weaknesses of each team's final deliverables and answer some version and/or combination of the following: "Which team would you hire?", "What deliverables hold the most value?", "Which team's suggestions are most like to be implemented?"

Ideal clients are first and foremost interested in partnering with course instructors in the education and preparation of the next generation of well-rounded undergraduate data analytics majors through work on a project of relevance to your organization and/or mission. We like to label an ideal project as "mission curious" rather than "critical" since the course environment is focused on providing an opportunity to undergraduates that are still developing a DA skillset. To ensure course and student learning objectives are achieved, we recommend that the expected database for a project be of sufficient size for some statistical modeling (e.g., at least 5,000+ observations/rows and 20+ variables/columns) in size. Of course, these are just guidelines, and course instructors would be happy to discuss the viability of other data for a successful practicum project. Also, data need not be ‘clean’ in one data file nor entirely collected at the start of the project -- it is advantageous to the students’ learning experience to engage in moderate data collection, preparation, and wrangling before analysis. Ideally, we want to strike a balance so that data prep does not consume student work for the entire project nor present a burden to the client or project viability.

Client projects should keep in mind that most students will have completed course work on introductory data analytics, introductory computer science, applied statistics, and data systems at this stage in their undergraduate DA major. These classes expose students to skills including data cleaning, some SQL, linear and logistic modeling, descriptive statistics, hypothesis testing, reproducibility practices, many data visualization methods. A typical student in the practicum will have experience with Python, R/Rstudio, many typical libraries, GitHub, and Tableau. Some students may have exposure to more diverse software platforms and/or advanced supervised and unsupervised classification and machine learning methods, but this cannot be guaranteed. Thus, successful projects are encouraged, but not limited to, to mesh with these techniques and platforms.

The client-student relationship is at the core of a positive practicum experience. Consequently, clients should be willing and prepared to meet with assigned teams multiple times over the semester, maintain avenues for appropriate communication outside of meetings, offer constructive (and even critical) formative feedback on milestones and performance throughout the semester, and commit to a live (likely virtual) final presentation session at the end of the semester. Some past clients have met weekly with teams, while others relied more heavily upon as-needed electronic communication with 3-5 scheduled meetings spaced across the semester. Instructors generally leave these details up to the client and student teams' needs and comfort.

Potential clients can submit a high-level proposal or problem statement of the project question, scope, and expected deliverables. Information on relevant data sets and their content, units of analysis, and especially availability/readiness is helpful. Any preferences for acceptable tools/formats for the project work ideal deliverables are also valuable at this stage. It is typical for this class to have a project evolve and narrow as clients interact with instructors and especially the students so that the project scope can be organic and multifaceted. We value and recognize the importance of data security and protecting intellectual property. Thus, as needed, datasets could be provided based on a non-disclosure agreement, and/or we can work with you to come up with other secure data sharing solutions. The practicum course instructors will review the documents to confirm the scope and timing of the proposed problem and its alignment with the practicum course requirements.

Some (non-limiting) examples of previous and desirable practicum project topics:

  1. Assessment of organization/policy efficacy (e.g., social services, sustainability, food service)
  2. Market analysis and viability for new products
  3. Consumer trends, personification, and strategy for retail
  4. Email campaign strategy
  5. Website usage, patterns, efficacy
  6. Client/Donor/Consumer engagement and participation
  7. Demand for social services (healthcare, emergency services, infrastructure, etc.)
  8. Customer acquisition and retention
  9. Healthcare and public health models (prior project on medication delivery efficiency w/in a hospital network)
  10. Dashboarding and modeling hunger for major regional foodbank
  11. Determining media consumption (mass vs. digital)
  12. Reduction of client churn (lower abandonment)
  13. Cross-sell and upsell opportunities
  14. Develop high propensity target markets
  15. Customer segmentation (behavioral or transactional)
  16. Market Basket Analysis to understand which items are often purchased together

Additional company criteria

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

2 - 3 web conferences may be scheduled in advance with the lead of the participating organization. The Instructor may ask that you participate in an Instructor-led webinar session for students at the beginning of the project by providing an overview of your organization, project, and desired/expected outcomes.

Be available for a quick phone call with the organizer to initiate your relationship and confirm your scope is an appropriate fit for the experience. Advise the instructor if students will be required to sign an NDA before beginning the project.

Provide a dedicated contact who will be available to answer periodic emails or phone calls over the duration of the project to address student’s questions or provide additional information. Minimum of 2-4 interactions with the student group leader (approximately 4-6 hours over the duration of the project). Let the students/instructor know if you will be away for an extended time (e.g., vacation).

Provide an online video or link to your website to introduce the students to your organization before starting the project.

Share feedback and recommendations about the project deliverables with the students and instructor.