Capstone course in Business Insights and Analytics
Timeline
-
October 17, 2021Experience start
-
November 2, 2021Project Scope Meeting
-
January 29, 2022Stage 1
-
March 12, 2022Stage 2
-
April 2, 2022Stage 3
-
April 23, 2022Stage 4
-
April 24, 2022Experience end
Timeline
-
October 17, 2021Experience start
-
November 2, 2021Project Scope Meeting
Meeting between students and company to confirm: project scope, communication styles, and important dates. NDAs are signed. November/December: Students do preliminary
research on the industry/company and get familiar with the tools needed for the project, if required. Company ensures access to data -
January 29, 2022Stage 1
The business problem and project scope are validated. Data is prepared for analysis.
-
March 12, 2022Stage 2
Solution design is developed and discussed with the sponsor company.
-
April 2, 2022Stage 3
Solution development is outlined and discussed with the sponsor company.
-
April 23, 2022Stage 4
Final solution is presented to the sponsor company.
-
April 24, 2022Experience end
Categories
Information technology Data analysis Market researchSkills
business analytics data analysis researchAre you looking for ways to monetize your data more effectively? Does your business have lots of historical data requiring cleaning and profiling? Are you interested in merging your internal data to various external data to derive new business insights? Do you face a specific business problem that can be tackled by using advanced statistical analysis, databases, big data, and machine learning tools? Business Insights and Analytics Post-Graduate Certificate Program at Humber College can help you find solutions to these problems. How? Partner with us in a Capstone project and benefit from getting a team of 5-6 students supervised by an experienced professional who will help you come up with a data-driven solution. The team will help you define the scope of the problem and the data for further analysis. They will apply a broad range of data analytics skills to build a solution and present business insights for your consideration.
Our students are:
- Well-versed in application of legislative requirements related to data protection
- Able to ask analytical questions, formulate a problem and define required data entities
- Able to profile data & conduct statistical analysis to assess data quality
- Able to use UML diagram to represent a business problem solution
- Able to uncover unidentified relationships between data
- Able to organize multiple data sources into an enterprise-wide database using SQL
- Able to develop descriptive/diagnostic/predictive/prescriptive models (i.e., Java, SPSS, SPSS Modeler, SAS, Python) to help managers derive business insights
- Able to manipulate & merge any type of data (structured, semi structured, unstructured) & use R for Big Data manipulation
- Skilled at working with the Hadoop architecture & querying large amounts of data using Map Reduce
- Able to define what dashboards are needed in a specific situation & identify the ideal visual to present data (i.e., Excel, Tableau, Power BI)
- Able to simulate/test the solution to a problem, conduct UAT, & integrate feedback.
Expected deliverables by the end of the project:
- Data analytics-base solutions (i.e., statistical analysis, dashboards, predictive model, machine learning implementation, etc.)
- The results will be communicated in a final presentation and final report.
Project timeline
-
October 17, 2021Experience start
-
November 2, 2021Project Scope Meeting
-
January 29, 2022Stage 1
-
March 12, 2022Stage 2
-
April 2, 2022Stage 3
-
April 23, 2022Stage 4
-
April 24, 2022Experience end
Timeline
-
October 17, 2021Experience start
-
November 2, 2021Project Scope Meeting
Meeting between students and company to confirm: project scope, communication styles, and important dates. NDAs are signed. November/December: Students do preliminary
research on the industry/company and get familiar with the tools needed for the project, if required. Company ensures access to data -
January 29, 2022Stage 1
The business problem and project scope are validated. Data is prepared for analysis.
-
March 12, 2022Stage 2
Solution design is developed and discussed with the sponsor company.
-
April 2, 2022Stage 3
Solution development is outlined and discussed with the sponsor company.
-
April 23, 2022Stage 4
Final solution is presented to the sponsor company.
-
April 24, 2022Experience end
Project Examples
Examples of the problems that we will help you solve in different functions/areas are:
In sales
· Identify cross-selling opportunities based on customer purchase history to enhance sales and improve customer experience
· Increase sales by identifying seasonal trends
· Identify profitable vs. unprofitable customers
· Predict the likelihood of customer attrition
· Determine which items should be on sale and avoid having an item and its complimentary (example: pasta and sauce) on sale at the same time
In supply chain
· Determine how much inventory to have at a given time to manage costs and space effectively
· Evaluate the efficiency of current suppliers and predict that of potential suppliers
In marketing
· Identify customer segments and select the best product/service to bring to the market
· Improve marketing campaigns based on the sentiment analysis
In finance
· Identify which bank client has a higher probability to apply for a mortgage
· Identify which clients will most likely not pay their mortgage/loan/debt
· Determine the credit limit a bank/financial institution can offer to a clientExamp
In HR:
· Determine which employee is more likely to leave the company and why
· Determine whether a potential applicant fit the company
Companies must answer the following questions to submit a match request to this experience:
Be available for initial meetings with the Capstone faculty/mentors to initiate your relationship and confirm your scope is an appropriate fit for the course. Provide project scope, a mix of internal data and tips for external data sources.
If your project requires specific software, you will need to provide access to it. (Our students will be equipped with access to a broad range of the software used in the program (i.e., SSMS and SQL Server, IBM SPSS Statistics, Python with numpy and matplotlib libraries, SAS Studio, SAS Enterprise Miner, IBM Cognos Analytics, IBM Watson Studio, IBM Cloud Services, Tableau, R Studio, Neo4j database system, Power BI, etc.)).
Provide feedback on the project progress and final solution - estimated 15-20 hours’ time commitment.
Provide a dedicated contact who is available to answer periodic emails or phone calls over the duration of the project to address students' questions. Checking in with students as the project progresses with regular meetings, reviews, and updates.
Timeline
-
October 17, 2021Experience start
-
November 2, 2021Project Scope Meeting
-
January 29, 2022Stage 1
-
March 12, 2022Stage 2
-
April 2, 2022Stage 3
-
April 23, 2022Stage 4
-
April 24, 2022Experience end
Timeline
-
October 17, 2021Experience start
-
November 2, 2021Project Scope Meeting
Meeting between students and company to confirm: project scope, communication styles, and important dates. NDAs are signed. November/December: Students do preliminary
research on the industry/company and get familiar with the tools needed for the project, if required. Company ensures access to data -
January 29, 2022Stage 1
The business problem and project scope are validated. Data is prepared for analysis.
-
March 12, 2022Stage 2
Solution design is developed and discussed with the sponsor company.
-
April 2, 2022Stage 3
Solution development is outlined and discussed with the sponsor company.
-
April 23, 2022Stage 4
Final solution is presented to the sponsor company.
-
April 24, 2022Experience end