際際滷

際際滷Share a Scribd company logo
Sarah Duehr
Summer 2015 Information Systems Intern
Supervisor / Mentor: Patrick Harding
1
About Me
Grew up in Bloomington C Normal, IL
Senior at Illinois State University, Normal, IL
Majoring in Computer Science
? with Minor in Mathematics
Student organization leadership:
? Secretary for UNICEF at ISU
? Aug. 2014 C May 2015
? Treasurer for UNICEF at ISU
? May 2015 C Present
? Treasurer for Association of Computing Machinery (ACM)
? May 2015 C Present
2
Project Overview
Diagram all the flowpaths at DPW, with data
Calculate and display: cycle time, takt time, theoretical inventory, and
average estimated recovery weight for each PC and flowpath
Used for Kaizens and plant improvements
3
First steps: research and requirements
Research
? Dynamic Visio diagrams
? Visio C database connection
? Data cubes
Gathering requirements
? What did ABS want on diagrams?
? How would diagrams be used?
Narrowing down requirements
? What can be done in 3 months?
4
First Draft: a dynamic diagram with dummy data
Dynamic Visio diagram
? Redraws based on excel workbook
? Written in Visual Basic for Applications (VBA)
5
Connecting Visio to data: my first big roadblock
6
Visio
Data
Cube
Database
Visio
Data
Cube
DatabaseExcel
Migration to Sharepoint: second big roadblock
Makes diagram accessible
Limitations of Visio in Sharepoint
? Won¨t support VBA code
Redesigned diagram to use hyperlinks
? Same functionality, different implementation
7
Final Product: DPW Plant Flowpath main page
8
Final Product: Plate Heat Treat flowpaths with flowpath level data
9
Final Product: PH2 flowpath with PC level data
10
Final Product: detailed data for single PC
11
What I learned
Technical
? Visual Basic for Applications (VBA)
? SQL Server Analysis Services
? Data cubes
? SharePoint, Visio services, excel services
? Real world examples of SQL
? Version control
Business
? Project timelines
? Working with business partner
? Real world setbacks and workarounds
? Having a supervisor
? Working on my own
? Hard deadlines
12
13

More Related Content

Viewers also liked (7)

Noprojects in Agile
Noprojects in AgileNoprojects in Agile
Noprojects in Agile
Coffee Talk
?
O medio mari?o (Candea 1994)
O medio mari?o (Candea 1994)O medio mari?o (Candea 1994)
O medio mari?o (Candea 1994)
candeadosalnes
?
屈勣殆範^をg屬垢
屈勣殆範^をg屬垢屈勣殆範^をg屬垢
屈勣殆範^をg屬垢
Akihiro HATANAKA
?
Take Agile to Next Level
Take Agile to Next LevelTake Agile to Next Level
Take Agile to Next Level
Coffee Talk
?
Flexidata profile EN software
Flexidata profile EN softwareFlexidata profile EN software
Flexidata profile EN software
Dao Nguyen
?
Principios fundamentales de una apologetica cristianaPrincipios fundamentales de una apologetica cristiana
Principios fundamentales de una apologetica cristiana
Ludwing Sanchez Carranza
?
Art of agile coaching
Art of agile coachingArt of agile coaching
Art of agile coaching
Coffee Talk
?
Noprojects in Agile
Noprojects in AgileNoprojects in Agile
Noprojects in Agile
Coffee Talk
?
O medio mari?o (Candea 1994)
O medio mari?o (Candea 1994)O medio mari?o (Candea 1994)
O medio mari?o (Candea 1994)
candeadosalnes
?
Take Agile to Next Level
Take Agile to Next LevelTake Agile to Next Level
Take Agile to Next Level
Coffee Talk
?
Flexidata profile EN software
Flexidata profile EN softwareFlexidata profile EN software
Flexidata profile EN software
Dao Nguyen
?
Principios fundamentales de una apologetica cristianaPrincipios fundamentales de una apologetica cristiana
Principios fundamentales de una apologetica cristiana
Ludwing Sanchez Carranza
?
Art of agile coaching
Art of agile coachingArt of agile coaching
Art of agile coaching
Coffee Talk
?

Similar to Project Presentation (20)

Eecs6893 big dataanalytics-lecture1
Eecs6893 big dataanalytics-lecture1Eecs6893 big dataanalytics-lecture1
Eecs6893 big dataanalytics-lecture1
Aravindharamanan S
?
Data carpentry ndic-2015-05-05
Data carpentry ndic-2015-05-05Data carpentry ndic-2015-05-05
Data carpentry ndic-2015-05-05
tracykteal
?
EDF Presentation - Final 2
EDF Presentation - Final 2EDF Presentation - Final 2
EDF Presentation - Final 2
Ryan Moya, LEED A.P.
?
Big Data Brown Bag
Big Data Brown BagBig Data Brown Bag
Big Data Brown Bag
usmanqureshi
?
Data Science and Online Education
Data Science and Online EducationData Science and Online Education
Data Science and Online Education
Geoffrey Fox
?
The NIH as a Digital Enterprise: Implications for PAG
The NIH as a Digital Enterprise: Implications for PAGThe NIH as a Digital Enterprise: Implications for PAG
The NIH as a Digital Enterprise: Implications for PAG
Philip Bourne
?
3 dvc nsf-062813
3 dvc nsf-0628133 dvc nsf-062813
3 dvc nsf-062813
Philip Bourne
?
Data Effectiveness: How to build a Data Driven and Reporting infrastructure
Data Effectiveness: How to build a Data Driven and Reporting infrastructureData Effectiveness: How to build a Data Driven and Reporting infrastructure
Data Effectiveness: How to build a Data Driven and Reporting infrastructure
Andrew Patricio
?
PSB2014 A Vision for Biomedical Research
PSB2014 A Vision for Biomedical ResearchPSB2014 A Vision for Biomedical Research
PSB2014 A Vision for Biomedical Research
Philip Bourne
?
DataEd 際際滷s: Data Management Best Practices
DataEd 際際滷s: Data Management Best PracticesDataEd 際際滷s: Data Management Best Practices
DataEd 際際滷s: Data Management Best Practices
DATAVERSITY
?
Luciano uvi hackfest.28.10.2020
Luciano uvi hackfest.28.10.2020Luciano uvi hackfest.28.10.2020
Luciano uvi hackfest.28.10.2020
Joanne Luciano
?
Data-centric design and the knowledge graph
Data-centric design and the knowledge graphData-centric design and the knowledge graph
Data-centric design and the knowledge graph
Alan Morrison
?
Towards Biomedical Research as a Digital Enterprise
Towards Biomedical Research as a Digital EnterpriseTowards Biomedical Research as a Digital Enterprise
Towards Biomedical Research as a Digital Enterprise
Philip Bourne
?
DataEd 際際滷s: Expressing Data Improvements as Business Outcomes
DataEd 際際滷s: Expressing Data Improvements as Business OutcomesDataEd 際際滷s: Expressing Data Improvements as Business Outcomes
DataEd 際際滷s: Expressing Data Improvements as Business Outcomes
DATAVERSITY
?
Advanced Project Data Analytics for Improved Project Delivery
Advanced Project Data Analytics for Improved Project DeliveryAdvanced Project Data Analytics for Improved Project Delivery
Advanced Project Data Analytics for Improved Project Delivery
Mark Constable
?
Adding value through BI: a Jisc perspective
Adding value through BI: a Jisc perspectiveAdding value through BI: a Jisc perspective
Adding value through BI: a Jisc perspective
JISC infoNet
?
How to access the AEDC data collections
How to access the AEDC data collectionsHow to access the AEDC data collections
How to access the AEDC data collections
Sonia Whiteley
?
Data science unit1
Data science unit1Data science unit1
Data science unit1
varshakumar21
?
Department of Commerce App Challenge: Big Data Dashboards
Department of Commerce App Challenge: Big Data DashboardsDepartment of Commerce App Challenge: Big Data Dashboards
Department of Commerce App Challenge: Big Data Dashboards
Brand Niemann
?
Digital apprenticeships community event
Digital apprenticeships community eventDigital apprenticeships community event
Digital apprenticeships community event
James Clay
?
Eecs6893 big dataanalytics-lecture1
Eecs6893 big dataanalytics-lecture1Eecs6893 big dataanalytics-lecture1
Eecs6893 big dataanalytics-lecture1
Aravindharamanan S
?
Data carpentry ndic-2015-05-05
Data carpentry ndic-2015-05-05Data carpentry ndic-2015-05-05
Data carpentry ndic-2015-05-05
tracykteal
?
Data Science and Online Education
Data Science and Online EducationData Science and Online Education
Data Science and Online Education
Geoffrey Fox
?
The NIH as a Digital Enterprise: Implications for PAG
The NIH as a Digital Enterprise: Implications for PAGThe NIH as a Digital Enterprise: Implications for PAG
The NIH as a Digital Enterprise: Implications for PAG
Philip Bourne
?
Data Effectiveness: How to build a Data Driven and Reporting infrastructure
Data Effectiveness: How to build a Data Driven and Reporting infrastructureData Effectiveness: How to build a Data Driven and Reporting infrastructure
Data Effectiveness: How to build a Data Driven and Reporting infrastructure
Andrew Patricio
?
PSB2014 A Vision for Biomedical Research
PSB2014 A Vision for Biomedical ResearchPSB2014 A Vision for Biomedical Research
PSB2014 A Vision for Biomedical Research
Philip Bourne
?
DataEd 際際滷s: Data Management Best Practices
DataEd 際際滷s: Data Management Best PracticesDataEd 際際滷s: Data Management Best Practices
DataEd 際際滷s: Data Management Best Practices
DATAVERSITY
?
Luciano uvi hackfest.28.10.2020
Luciano uvi hackfest.28.10.2020Luciano uvi hackfest.28.10.2020
Luciano uvi hackfest.28.10.2020
Joanne Luciano
?
Data-centric design and the knowledge graph
Data-centric design and the knowledge graphData-centric design and the knowledge graph
Data-centric design and the knowledge graph
Alan Morrison
?
Towards Biomedical Research as a Digital Enterprise
Towards Biomedical Research as a Digital EnterpriseTowards Biomedical Research as a Digital Enterprise
Towards Biomedical Research as a Digital Enterprise
Philip Bourne
?
DataEd 際際滷s: Expressing Data Improvements as Business Outcomes
DataEd 際際滷s: Expressing Data Improvements as Business OutcomesDataEd 際際滷s: Expressing Data Improvements as Business Outcomes
DataEd 際際滷s: Expressing Data Improvements as Business Outcomes
DATAVERSITY
?
Advanced Project Data Analytics for Improved Project Delivery
Advanced Project Data Analytics for Improved Project DeliveryAdvanced Project Data Analytics for Improved Project Delivery
Advanced Project Data Analytics for Improved Project Delivery
Mark Constable
?
Adding value through BI: a Jisc perspective
Adding value through BI: a Jisc perspectiveAdding value through BI: a Jisc perspective
Adding value through BI: a Jisc perspective
JISC infoNet
?
How to access the AEDC data collections
How to access the AEDC data collectionsHow to access the AEDC data collections
How to access the AEDC data collections
Sonia Whiteley
?
Department of Commerce App Challenge: Big Data Dashboards
Department of Commerce App Challenge: Big Data DashboardsDepartment of Commerce App Challenge: Big Data Dashboards
Department of Commerce App Challenge: Big Data Dashboards
Brand Niemann
?
Digital apprenticeships community event
Digital apprenticeships community eventDigital apprenticeships community event
Digital apprenticeships community event
James Clay
?

Project Presentation

  • 1. Sarah Duehr Summer 2015 Information Systems Intern Supervisor / Mentor: Patrick Harding 1
  • 2. About Me Grew up in Bloomington C Normal, IL Senior at Illinois State University, Normal, IL Majoring in Computer Science ? with Minor in Mathematics Student organization leadership: ? Secretary for UNICEF at ISU ? Aug. 2014 C May 2015 ? Treasurer for UNICEF at ISU ? May 2015 C Present ? Treasurer for Association of Computing Machinery (ACM) ? May 2015 C Present 2
  • 3. Project Overview Diagram all the flowpaths at DPW, with data Calculate and display: cycle time, takt time, theoretical inventory, and average estimated recovery weight for each PC and flowpath Used for Kaizens and plant improvements 3
  • 4. First steps: research and requirements Research ? Dynamic Visio diagrams ? Visio C database connection ? Data cubes Gathering requirements ? What did ABS want on diagrams? ? How would diagrams be used? Narrowing down requirements ? What can be done in 3 months? 4
  • 5. First Draft: a dynamic diagram with dummy data Dynamic Visio diagram ? Redraws based on excel workbook ? Written in Visual Basic for Applications (VBA) 5
  • 6. Connecting Visio to data: my first big roadblock 6 Visio Data Cube Database Visio Data Cube DatabaseExcel
  • 7. Migration to Sharepoint: second big roadblock Makes diagram accessible Limitations of Visio in Sharepoint ? Won¨t support VBA code Redesigned diagram to use hyperlinks ? Same functionality, different implementation 7
  • 8. Final Product: DPW Plant Flowpath main page 8
  • 9. Final Product: Plate Heat Treat flowpaths with flowpath level data 9
  • 10. Final Product: PH2 flowpath with PC level data 10
  • 11. Final Product: detailed data for single PC 11
  • 12. What I learned Technical ? Visual Basic for Applications (VBA) ? SQL Server Analysis Services ? Data cubes ? SharePoint, Visio services, excel services ? Real world examples of SQL ? Version control Business ? Project timelines ? Working with business partner ? Real world setbacks and workarounds ? Having a supervisor ? Working on my own ? Hard deadlines 12
  • 13. 13