University Canada West
Log in Sign up

Data Analysis and Dashboard in Excel

EXL1002
Closed
Cambrian College
Cambrian College
Sudbury, Ontario, Canada
Sidney Shapiro
Sidney Shapiro He / Him
Assistant Professor, Business Analytics
2
Timeline
  • November 2, 2020
    Experience start
  • November 12, 2020
    Project Scope Meeting
  • November 17, 2020
    Experience end
Experience
1/2 project matches
Dates set by experience
Preferred companies
Anywhere
Any
Any industries
Categories
Information technology Data analysis
Skills
business consulting communication data analysis research dashboard development
Learner goals and capabilities

Using a data set provided by your organization, student-consultants will use data analysis methods to help you and your organization derive insights and make more informed decisions. Based on the information you provide and the goals that you've shared with the students, they will provide you with an analysis and recommendations on issues of your choice.

Learners
Graduate
Any level
30 learners
Project
15 hours per learner
Learners self-assign
Teams of 3
Expected outcomes and deliverables

Students will submit a 5-page report and dashboard in Excel or PowerB with data analysis and recommendations. There is also an additional option to have the teams make a presentation.

Project timeline
  • November 2, 2020
    Experience start
  • November 12, 2020
    Project Scope Meeting
  • November 17, 2020
    Experience end
Project Examples

Working in small groups, Cambrian College students will tackle a question designed by you to guide their exploration of the data provided. Among other things, the students will organize and consolidate the data in multiple worksheets, perform visual analysis, apply logical operators and formulas, create dashboards and data summaries.

As a partnering organization, you will provide the students with a central question that you face, and the students will create meaningful spreadsheets to analyze, manage and communicate data, as well as provide recommendations.

Project objectives include, but are not limited to: analyzing data, constructing dashboards in PowerBI or Excel, and providing an analysis of data based on provided criteria.

Possible project examples include, but are not limited to:

  • Analyzing historical buyer data to identify key target markets or new business development opportunities.
  • Analyzing available industry data to identify market trends
  • Identifying trends and patterns in your sales cycle
  • Identifying trends in demand to help with forecasting
  • Analyzing data on customer satisfaction to highlight key areas for improvement
Linked templates
Analyzing Industry Data View all
Companies must answer the following questions to submit a match request to this experience:

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

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