Portland Pedal Power (PPP), is a delivery and catering delivery service, based out of Portland that differentiates itself from the competition with the usage of bicycles. Business Intelligence is the process of equipping organizations to make better decisions with the usage of data. A data warehouse architecture coupled with reporting capabilities will allow the leadership of PPP to better understand their customers. This project warranted the capstone team to upgrade the existing data infrastructure, define and automate ETL (Extract Transform, Load) processes to combine disparate sources of data and build interactive data visualizations and report to make everyday decisions easier.

Many organizations utilize Excel to track valuable data. Often times, these spreadsheets grow out of hand with information stored inconsistently and in random areas. This results in a loss of data integrity and the inability to extract information holistically. We teamed up with SightLife, a global health organization to build a dynamic database with powerful data analytics by incorporating existing Microsoft technologies. With a standardized and streamlined data management process, Sightlife now has the ability to ask their data questions and discover the answers. Utilizing their information’s full potential brings them one step closer to eliminating corneal blindness

MISO (Musical Instruments of the Seattle Opera) is a Microsoft Access database designed to track the Seattle Opera’s instrument collection. Before MISO, instruments were tracked using several spreadsheets that were inconsistent and difficult to update. The Seattle Opera realized it needed a better system when a cimbasso went missing. After a frantic search, it was discovered that the cimbasso was never missing - it had been in the Seattle Opera’s library all along. With MISO, all relevant instrument information, including location, current user and technical specifications are all combined into one location, ensuring that no instrument is lost.

PATH and MSR® Global Health developed the SafiStation™, an innovative and easy-to-use device that generates chlorine for infection prevention and water treatment in low-resource health care facilities. PATH is preparing to conduct a field test of up to 50 SafiStation devices across three countries to evaluate device performance, impact, and usability. We created an integrated web-based data dashboard to automatically collect and visualize technical performance data collected directly from the device using cellular networks. The dashboard will give PATH and MSR access to real-time performance and functionality data to monitor device usage and identify challenges with the technical performance.

Amazon's Strategic Recruitment Team (SRT) handles their Executive level hiring for Machine learning (ML) experts. The current challenge with their hiring procedure is that it needs a lot of manual effort to browse through Google Scholar/other academic websites to know about a ML expert’s research. We proposed an academic perspective solution which provides Amazon’s SRT with a portal displaying their well sought ML expert's collaboration network, conference research trends and his affiliations. Our solution makes it easier for recruiters to initiate networking with ML experts at Top conferences as it provides vital information about the candidate.

Gay City's LGBT Library provides LGBT materials to Seattle's queer communities. However, with an outdated database and no Reader's Advisory in place, volunteers often had a difficult time finding what patrons needed. Liz and Rachel helped update the browsing process by transferring Gay City to a new database, taking inventory of the entire library, and creating Reader's Advisory lists on a variety of topics based on patron feedback. Available both online and in print, the lists include Gay Fiction, Lesbian Fiction, Transgender & Genderqueer Fiction, Transgender & Genderqueer Nonfiction, Young Adult Fiction, and Science Fiction.

The Costume Shop at Millikin University holds thousands of costuming items. Unfortunately, there is no inventory, no organizational system, nor a database of the items in the collection. This is a major problem for everyone in the shop, which includes students, staff, and any guest designers they may have for a show. I built a database for them in FileMaker Pro, which could be used by both experienced designers and less experienced student workers. Over the next two years, they will continue to add items to the database to make the transition to their new building a smooth one.

As a bridging tool, this Access undergraduate award database is designed to compile academic raw data retrieved from central student information system to be in align with current university standards on student awards/scholarships, to effectively sort, filter, and select potential candidates for 25 pre-academic session awards provided by the Department of Chemical & Biological Engineering and APSC. With only a few clicks, the access interface would enable users to shortlist students in orders based on various award criteria. Also, this database is linked with a departmental SharePoint site to get all the data synced and communicated among the award committee.

The UW Night Market mobile application alleviates long wait line issues that plague popular food festivals. Leveraging a mobile ordering system to facilitate the ordering process between attendees and vendors, the application increases attendee satisfaction and vendor sales. During this year’s UW Night Market event on May 12th, the application completed 483 orders and generated $4,553 in revenue for ten vendors in four hours.