MSIS Capstone
2. Capstone Planning
3. Capstone Execution
Project Options
Sponsored Project
Sample Project: Automating Data Analytics
Project Summary: The objective was to automate a monthly Excel scorecard used by staff and executives at Ace Intermountain Recycling. The project team delivered a scorecard that was easily accessible via a web browser displaying the information and metrics that were originally calculated manually. The new scorecard can be accessed at any time, is continuously updated, and easy for management to maintain.
Sponsoring Company Background: Ace Intermountain Recycling Center (AIRC) operates transfer stations for recycled materials, green waste, and other garbage in the Salt Lake Valley and surrounding areas. The AIRC scorecard built by this project accumulates different metrics, allowing management to easily view revenue, costs, and other productivity trends.
Project Timeline: Sponsored capstone projects span two semesters. The first semester is used for project selection and planning. The project is executed in the next semester (about 30 weeks total).
Project Planning and Execution: The main technologies used were SQL, Microsoft Power BI, Python, and REST APIs. The first phase of the project execution was dedicated to creating data connections between the server and each data source; the next phase was cleaning and transforming the raw data into usable datasets with Power BI. SharePoint was utilized to present the dashboard with all its metrics in one central location.
“I would strongly recommend the project. It offers so much experience, which is primarily what employers are looking for. I have certifications for other things, but I always get asked in interviews about the experience. Many times, I’m in an interview and they say, ‘Tell us about a challenge you experienced’ and this capstone project is always an option for one. There are so many times when, in answer to an interview question, I can think back to my capstone project.”
– Andy Adamson, project manager
“[The sponsored capstone project] benefitted my technical skills a lot. We never really worked with APIs throughout my other classes, and in this project we did work with a couple of APIs directly. We utilized Python in a real-world situation, and then we also utilized Microsoft’s Power BI platform quite extensively. I’ve been utilizing all three of those technologies in my current project at work. I gained real-world technical skills with real-world situations and it’s been benefitting my work projects.”
– Connor Bryner, team member
“You always learn new things and get put in environments that you are completely unfamiliar with. There’s just a lot of learning to be done in that kind of space and it looks good on the resume to have a real project you worked on and completed. … [I chose this project because] it seemed like a small company that I could really do a lot for, which I think also makes it fun. I felt like I could make a big difference; they would actually use what I did if I did it well.”
– Jared Kujawa, team member
Certification
There are three primary levels of certification:
- Entry Level – Great options for people new to IT and related fields or who are learning a specific technology. Examples include A+, Security+, ScrumMaster, Tableau, etc.
- Associate Level – Designed for more specialized areas in IT, some level of experience and previous certification may be required. These comprise (ISC)2 SSCP, CAPM, and various AWS Associate Certifications as well as specialty certifications such as AWS Security, and certifications from IAPP.
- Professional Level – These are certifications that require significant experience, as well as training and often someone to sponsor or certify your experience. These include the CISSP, CISM, CISA, CRISC, PMP, and any SANS/GIAC certification based on a 400-level course (or higher) such as GSEC, GCED, etc.
Sponsored Project
Ace Intermountain Recycling Sample Project
Project Summary: The objective was to automate a monthly Excel scorecard used by staff and executives at Ace Intermountain Recycling. The project team delivered a scorecard that was easily accessible via a web browser displaying the information and metrics that were originally calculated manually. The new scorecard can be accessed at any time, is continuously updated, and easy for management to maintain.
Sponsoring Company Background: Ace Intermountain Recycling Center (AIRC) operates transfer stations for recycled materials, green waste, and other garbage in the Salt Lake Valley and surrounding areas. The AIRC scorecard built by this project accumulates different metrics, allowing management to easily view revenue, costs, and other productivity trends.
Project Timeline: Sponsored capstone projects span two semesters. The first semester is used for project selection and planning. The project is executed in the next semester (about 30 weeks total).
Project Planning and Execution: The main technologies used were SQL, Microsoft Power BI, Python, and REST APIs. The first phase of the project execution was dedicated to creating data connections between the server and each data source; the next phase was cleaning and transforming the raw data into usable datasets with Power BI. SharePoint was utilized to present the dashboard with all its metrics in one central location.
“For anyone who’s skeptical about doing a project over a certification, I would strongly recommend the project. It offers so much experience, which is primarily what employers are looking for. I have certifications for other things, but I always get asked in interviews about the experience. Many times, I’m in an interview and they say, ‘Tell us about a challenge you experienced’ and this capstone project is always an option for one. There are so many times when, in answer to an interview question, I can think back to my capstone project.”
– Andy Adamson, project manager
“[The sponsored capstone project] benefitted my technical skills a lot. We never really worked with APIs throughout my other classes, and in this project we did work with a couple of APIs directly. We utilized Python in a real-world situation, and then we also utilized Microsoft’s Power BI platform quite extensively. I’ve been utilizing all three of those technologies in my current project at work. I gained real-world technical skills with real-world situations and it’s been benefitting my work projects.”
– Connor Bryner, team member
“You always learn new things and get put in environments that you are completely unfamiliar with. There’s just a lot of learning to be done in that kind of space and it looks good on the resume to have a real project you worked on and completed. … [I chose this project because] it seemed like a small company that I could really do a lot for, which I think also makes it fun. I felt like I could make a big difference; they would actually use what I did if I did it well.”
– Jared Kujawa, team member
Certification
There are three primary levels of certification:
- Entry Level – Great options for people new to IT and related fields or who are learning a specific technology. Examples include A+, Security+, ScrumMaster, Tableau, etc.
- Associate Level – Designed for more specialized areas in IT, some level of experience and previous certification may be required. These comprise (ISC)2 SSCP, CAPM, and various AWS Associate Certifications as well as specialty certifications such as AWS Security, and certifications from IAPP.
- Professional Level – These are certifications that require significant experience, as well as training and often someone to sponsor or certify your experience. These include the CISSP, CISM, CISA, CRISC, PMP, and any SANS/GIAC certification based on a 400-level course (or higher) such as GSEC, GCED, etc.
