Dimensional Modeling for AHS

Jul 30, 2015Download as PPTX, PDF0 likes377 views

The document proposes a data warehouse model to help the Alaska Humane Society Cat Shelter better organize and analyze data related to its operations. It identifies key business objectives like increasing adoptions and donations. Current record keeping is paper-based with some Excel files. Recommendations include creating an integrated database system, assigning a volunteer IT manager, and using the data online and in signage to help adoptions and funding. Dimensions include cats, adoptions, volunteers and donations. Data quality will require roles like a data steward to ensure accuracy and completeness. The conclusion emphasizes that meeting goals depends on properly maintaining and using the collected data.

AHS CAT SHELTER
DATA MODEL
DEVELOPMENT AND
IMPLEMANTATION OF
A DATA WAREHOUSE
MODEL, WHICH WILL
HELP THE ALASKA
HUMANE SOCIETY CAT
SHELTER TO BETTER
STORE AND
ANALYZE ALL THE
DATA RELATED TO ITS
ACTIVITY.
LAUREN
RILEY
PATRICK
McCORMACK
MARIO
RONCADOR
CIS A670
APRIL 23, 2015

AHS CAT SHELTER DATA MODEL
INTRODUCTION
 Alaska Humane Society
 Houses 150 cats
 Run solely on volunteerism and donations
 Filing system is still largely paper with some records kept in Excel
 Outdated usage of sites such as Petfinder.com and Facebook to
showcase adoptable cats

AHS CAT SHELTER DATA MODEL
1. PROJECT PLANNING
 Business Objectives:
 Integrated & organized record keeping system
 Increase Adoption Rate
 Grow Monetary Donation
 Organizational Obstacles:
 Lack of organization
 Ex. volunteer and adoption records
 Financial instability
 Enterprise Business Requirements
 Low cost (one-time versus subscription)
 Data easily exported to Excel for use with sites such as
Petfinder.com
 IT Support
 Cloud Based (optimally)

AHS CAT SHELTER DATA MODEL
 Finding #1: AHS does not have a working data management
system in place.
 Recommendation: Create an integrated, organized record
keeping system and assign one long-term IT savvy volunteer to
maintain the database. Utilize 501(C)3 status to find an
affordable database solution.
2. CONSOLIDATED FINDINGS

AHS CAT SHELTER DATA MODEL
 Finding #2: AHS current adoption rate is substandard.
 Recommendation:
 Raise overall awareness of individual cats available for adoption by
leveraging the database for online sites such as Petfinder.com, where
the majority of people looking to adopt a pet start their search.
 Make the physical location easier to find by increasing roadside
signage. The shelter does not have extensive phone or email
communications so it is imperative that potential customers can find
the shelter during office hours.
2. CONSOLIDATED FINDINGS

AHS CAT SHELTER DATA MODEL
 Finding #3: AHS funding is not stable from year to year.
 Recommendation:
 Instead of relying on one-time donations (the bulk of which come
form Pick.Click.Give), utilize current volunteer experience in grant
writing and search for renewable grants that provide a more
sustainable funding method for non-profit entities.
 Increased funding may allow for a full time paid employee who could
maintain the database. This will be imperative to assist in tracking
grant management and making sure the shelter is fulfilling the grant
requirements.
2. CONSOLIDATED FINDINGS

AHS CAT SHELTER DATA MODEL
3. DIMENSIONAL MODELING
Measures
of
Interest
Measures related to the “Cat care
and Adoption”:
1. Cats
2. Adoption
3. Health History
4. Vaccination
Measures related to “Facility and
Volunteers”:
1. Volunteers
2. Donations
3. Maintenance

AHS CAT SHELTER DATA MODEL
3. DIMENSIONAL MODELING

AHS CAT SHELTER DATA MODEL
Data quality ensuring measures
3. DIMENSIONAL MODELING
RELEVANT ATTRIBUTES
DATA STEWARTSHIP ROLES
Completeness
Reliability
Accuracy
Conciseness
Usefulness
Anita Shell
Lauren Riley technical issues
database population

AHS CAT SHELTER DATA MODEL
 Data management has been identified as a key area of
importance for AHS
 Once the information has been catalogued, volunteers will
need to be assigned the task of maintaining the updated
database
 Overall business objectives such as increased adoptions and
donations will be effected by their ability to properly maintain
and leverage their data
CONCLUSION

AHS CAT SHELTER DATA MODEL
THANK YOU!
Lauren
Patrick
Mario

The document outlines a student's daily routine, which includes waking up at 7:15am, having breakfast at 7:30am, getting dressed and leaving for school by 8:10am, having a playground break at 11:45am, finishing school at 3pm, arriving home by 3:15pm, having lunch at 3:30pm, doing homework at 4pm, having a snack at 6:30pm, watching TV at 7:30pm, taking a shower at 9pm, eating dinner at 9:30pm, and going to bed at 10:30pm.

La comunicación on lineSol taramon

��

La comunicación on-line utiliza Internet como canal de comunicación multimedia e interactivo para formar conexiones y comunidades, permitiendo la interacción entre estudiantes y profesores a través de correo electrónico, salas de discusión, foros y videoconferencia de manera sincrónica o asincrónica. La comunicación on-line ofrece ventajas como la expresión fácil entre personas que de otra forma no podrían comunicarse y la interacción directa con compañeros y profesores de otras universidades.

Java ring-110920020424-phpapp02Jana Vontari

��

The document discusses Java Ring, which is a finger ring containing a microprocessor and capabilities for the user. It has a JVM, RAM, ROM, and connects to other devices using a blue dot receptor. Information is stored securely on the ring and the user can access accounts or unlock doors simply by touching the ring to the receptor. While convenient, Java Rings have limitations around cost, storage space, and potential for theft.

Flow meter yekavalangiehsan yekavalangi

��

.The business of ITLauren Riley

��

This document discusses several key topics related to IT organizations and management including their core activities, roles and responsibilities, business cases, investment portfolios, balanced scorecards, cost recovery methods, and total cost of ownership. It provides an overview of 14 core activities that IT organizations engage in, defines the CIO role, and explains how business cases are used to evaluate new investments in terms of objectives and benefits.

.Organizational Strategy and Information SystemsLauren Riley

��

Organizational strategy involves defining tasks, structure, people, and information/control processes. Information strategy must align with organizational strategy. Information systems can influence organizational design by determining decision rights and structure. They also impact management control through data collection, evaluation, communication, planning, and performance measurement. Finally, information systems interact with organizational culture at different levels and cultures vary in their adoption of new technologies.

Robotics janardhanJana Vontari

��

This document discusses robots and robotics. It defines a robot as a re-programmable machine that can replace humans in hazardous work. The main components of industrial robots are sensors to detect the environment, effectors to interact with it, actuators to move parts of the robot, and controllers to direct the robot's movements. There are different types of robots including mobile robots that can roll or walk, stationary industrial robots, and virtual robots that exist as computer programs. Robots have many applications but also have limitations like needing power and maintenance.

How to Use Your Database to Power Your Fundraising - FINZ 2014 PresentationBlackbaud Pacific

��

This document provides tips on how nonprofit organizations can use their fundraising databases more effectively. It discusses the importance of clean, well-maintained data and designating a database manager. Current fundraising trends like donor retention, source diversification, and new channels are also covered. The document encourages organizations to monitor key metrics in their database like donor acquisition and retention rates to inform strategy. Automating processes and focusing on high-value donors are presented as ways to maximize database potential.

Petstore Supply Chain Management Report STUDENT N.docxssuser562afc1

��

Petstore Supply Chain Management Report STUDENT NAME California State University San Bernardino SCM 607 XXXXX 2018 PETSTORE COMPANY Supply Chain Management Report Table of Contents Company History ................................................................................................................ 1 Evaluation of the Supply Chain Processes.......................................................................... 3 Supply Chain Performance Drivers .................................................................................... 4 Network Design .................................................................................................................. 6 Supply Chain Risk Mitigation ............................................................................................ 7 Forecasting Practices .......................................................................................................... 8 Sales & Operations Planning .............................................................................................. 9 Inventory Management Practices ...................................................................................... 10 Use of Transportation ....................................................................................................... 11 Sourcing Decisions ........................................................................................................... 12 Information Technology for Supply Chain Optimization ................................................. 13 Supply Chain Sustainability with Learning Outcomes & Recommendations .................. 14 References ......................................................................................................................... 17 PETSTORE COMPANY Supply Chain Management Report 1 Company History Founded in 1965, the mail-order veterinary supply business, UPCO, changed its name to Petstore in 1979. The business started in San Diego, California and expanded all the way to Oregon by 1980, creating 40 retail store locations. By 1988, Petstore had acquired two smaller pet supply chains and more than tripled its number of store locations, entering the Washington and Texas markets. Live animals were introduced in the late 80s as well. By 1992, Petstore had opened its first East Coast stores in New Jersey and coined their signature phrase, “Where the Pets Go.” By 1994, Petstore was the largest pet specialty retailer, operating in 13 states with 218 stores. They went public under the ticker symbol PETC. The company has gone back and forth from being publicly traded to privately held. It was bought out by Leonard Green Partners and Texas Pacific Group in 2000, but again went public in 2002. The company became privately held again in 2006 by investment groups led by TPG. Ten years later, the company was acquired by CVC Capital Partners and Can.

Tech lab.presentation.kachingle.typaldos.final.4.28.10.03.amAdoptMeApp

��

Kachingle has developed two apps, AdoptMeApp and SponsorMeApp, powered by their micropayment subscription engine, to help animal shelters and rescue organizations. AdoptMeApp allows volunteers to easily share stories and updates about adoptable pets on social media to promote adoptions. SponsorMeApp allows organizations to attract ongoing monthly subscriptions from sponsors to support specific pets and generates a new revenue stream for the organizations. Kachingle takes a cut of the subscription transactions.

Social media making it work for your organization oct 2011Community Legal Education Ontario (CLEO)

��

The Data Informed Nonprofit: SalesForce Foundation WebinarBeth Kanter

��

The document discusses how nonprofits can become more data-informed organizations by following a "crawl-walk-run-fly" model of increasing their use and maturity of data practices over time. It provides examples of practices at each level from basic, inconsistent data collection to advanced use of data visualization and real-time reporting. Key recommendations include starting with small pilots to build measurement habits, identifying the right metrics and tools for goals, and ensuring data is used for decision-making and continuous improvement. The overall message is that nonprofits can strengthen their impact by gradually increasing their ability to collect, analyze, and apply insights from data.

Making Data Actionable; PDFRich Jones

��

1. The document outlines strategies for making data actionable, including developing a big data strategy, setting milestones, identifying relevant data sources, and using data to create organizational efficiencies. 2. It emphasizes focusing marketing and data use on engagement, lead generation, and utilization metrics. Data should be used to move from broad approaches like blast marketing to more targeted segmented marketing. 3. Key steps include gathering, organizing, and identifying relevant data, then using data to track activities and outcomes, store results for future use, and continuously tweak marketing based on lessons learned.

Making the Most of Your eTapestry Database - Customer Sessionkrucker

��

This document summarizes a seminar about maximizing the use of an eTapestry donor database. It discusses how the current economy is affecting donations and recommends strategies like website optimization, recurring gifts, e-commerce, effective communication, and data management. Relationship management tools can help track interactions and cultivate donors. eTapestry provides training and support to help non-profits succeed. New features like mobile access allow users to access the donor database anywhere.

CALPACT Webinar: Using Infographics and Data VisualizationCenter for Public Health Practice & Leadership at UC Berkeley

��

Interested in learning how to transform data or complex, hard to understand information into something more visually appealing and meaningful? Or how to use tools and techniques to more successfully communicate critical information? In this webinar, the fourth session in the latest 21st Century New Media Series from CALPACT and CHL at UC Berkeley's School of Public Health, join Sheila Baxter and Leslie Safier from Healthy Communities Institute and Leslie Yang, from Awasu Design, as they share how they're using data visualization tools and infographics to innovatively communicate data that matters in a clear and creative way. Enjoy these slides from the training! Listen to the webinar here: http://cc.readytalk.com/play?id=5pq7nu View the webinar resources here: http://www.slideshare.net/SPHCalpact/calpact-webinar-using-infographics-and-data-visualization-resources To learn more about this series, please visit: http://chl.berkeley.edu/events/newmedia/2014-new-media-trainings/sessions.html Follow Us on Twitter: @CALPACT Facebook: http://www.facebook.com/CALPACTUCB Website: www.calpact.org

Finding Meaning in the NumbersTechSoup Canada

��

Essential Digital Tools for Farm and Food Ventures - 25th Annual Southern SAW...Robert Fish

��

Connecting Up KeynoteBeth Kanter

��

Beth Kanter discusses how nonprofits can become more networked, use measurement, and make sense of their data. She outlines a maturity model from "crawl-walk-run-fly" and provides examples of practices at each stage. These include developing a networked culture, staffing for social media, collecting and analyzing data, and learning from failures. Kanter emphasizes starting small with measurement, defining the right metrics, and using data to continuously improve programs and communications. The talk provides actionable advice on how nonprofits can incorporate social media and data practices into their work.

Paying Essay Markets For Freelance Writers All Freelance WritingLiz Brown

��

This document discusses the process for requesting essay writing help from the website HelpWriting.net. It outlines the 5 main steps: 1. Create an account with an email and password. 2. Complete a 10-minute order form providing instructions, sources, and deadline. 3. Review bids from writers and choose one based on qualifications. Place a deposit to start the assignment. 4. Review the completed paper and authorize final payment if pleased. Free revisions are allowed. 5. Multiple revisions can be requested to ensure satisfaction. Plagiarized work results in a full refund.

Comparative Study of Improved Association Rules Mining Based On Shopping SystemEswar Publications

��

Data mining is a process of discovering fascinating designs, new instructions and information from large amount of sales facts in transactional and interpersonal catalogs. The main purpose of this function is to find frequent patterns, associations and relationship between various database using different Algorithms. Association rule mining (ARM) is used to improve decisions making in the applications. ARM became essential in an information and decision-overloaded world. They changed the way users make decisions, and helped their creators to increase revenue at the same time. Bringing ARM to a broader audience is essential in order to popularize them beyond the limits of scientific research and high technology entrepreneurship. It will be able to expand and apply effective marketing strategies and in disease identification frequent patterns are generated to discover the frequently occur diseases in a definite area. The conclusion in all applications is some kind of association rules (AR) that are useful for efficient decision making.

Time is Magic: Modern Messaging for Non-ProfitsHighRoad Solution

��

Association and non-profit marketing & communication professionals are finally making the case for updating, integrating and automating their email, social and content marketing processes so that they have more time to focus on understanding their users. Now that we fully exist in a multi-channel, multi-touchpoint and user-centric world, it's critical that associations and non-profits update their mindsets and methodologies to match. This presentation was first presented on July 21, 2014 at the American Marketing Association's Non-Profit Conference along with Nathan Sprenger of National Council of Behavioral Health.

Improving Customer Service with Communities And Gaining Social Media ROIDr. Natalie Petouhoff

��

Syfab is it for me? social media may 2018Lou Mycroft

��

This document provides guidance on using social media for fundraising. It discusses how social media can help at all stages of fundraising by building networks and promoting an organization. While social media may not directly raise much money initially, it is important for building digital communities over time. The document provides tips on using platforms like Facebook and Twitter effectively for fundraising and engagement. It also discusses online giving options, the use of videos, and crowdfunding strategies to support fundraising through social media.

AdoptMeApp presentation for Maddie's FundPalo Alto Homeless Dogs

��

"Every Shelter Pet Now Has a New Happy Story" AdoptMeApp enables staff, volunteers, and fosterers in animal shelters and rescue groups to easily post and share linked stories, photos, and videos about adoptable pets Taps into volunteer creativity and social networks Gives dynamic, rather than static, view of pet Lets adopter see how the pet interacts in many situations, with different people Especially great for fostered pets - shows how the pet fits into someone’s home and life. Takes advantage of foster situation!

Meaningful Metrics for StartupsGoSquared

��

Effective Use of Technology in Fundraising w/ Jay LoveBloomerang

��

This document summarizes a presentation on effectively using technology in fundraising. The key purposes of technology in fundraising are to properly fund an organization's mission with the least cost possible and to enable donor retention and maximize lifetime donor value. Proper use of a donor database for record keeping, outbound communications, and tracking interactions is essential for donor retention. Data should be segmented to focus efforts on high-value donors who contribute 90% of funding, while removing those who do not contribute after 24 months. Appeals, acknowledgements, and social media use should be personalized and segmented to best engage each donor group.

Creating a Successful Giving Day StrategySocial Media for Nonprofits

��

This document provides guidance on creating a successful giving day strategy. It recommends starting planning early and setting a fundraising goal of $50,000 by attracting 255 new donors at a 3% participation rate from a donor file of 8,500. Key elements for success include appointing a passionate leader and team, branding the campaign, engaging the community through shareable content on social media, making it fun through challenges and games, and celebrating and thanking donors. Planning tools, matching funds, and reporting capabilities can help maximize results. An example timeline is also included.

Dimensional Modeling for AHS

1. AHS CAT SHELTER DATA MODEL DEVELOPMENT AND IMPLEMANTATION OF A DATA WAREHOUSE MODEL, WHICH WILL HELP THE ALASKA HUMANE SOCIETY CAT SHELTER TO BETTER STORE AND ANALYZE ALL THE DATA RELATED TO ITS ACTIVITY. LAUREN RILEY PATRICK McCORMACK MARIO RONCADOR CIS A670 APRIL 23, 2015

2. AHS CAT SHELTER DATA MODEL INTRODUCTION  Alaska Humane Society  Houses 150 cats  Run solely on volunteerism and donations  Filing system is still largely paper with some records kept in Excel  Outdated usage of sites such as Petfinder.com and Facebook to showcase adoptable cats

3. AHS CAT SHELTER DATA MODEL 1. PROJECT PLANNING  Business Objectives:  Integrated & organized record keeping system  Increase Adoption Rate  Grow Monetary Donation  Organizational Obstacles:  Lack of organization  Ex. volunteer and adoption records  Financial instability  Enterprise Business Requirements  Low cost (one-time versus subscription)  Data easily exported to Excel for use with sites such as Petfinder.com  IT Support  Cloud Based (optimally)

4. AHS CAT SHELTER DATA MODEL  Finding #1: AHS does not have a working data management system in place.  Recommendation: Create an integrated, organized record keeping system and assign one long-term IT savvy volunteer to maintain the database. Utilize 501(C)3 status to find an affordable database solution. 2. CONSOLIDATED FINDINGS

5. AHS CAT SHELTER DATA MODEL  Finding #2: AHS current adoption rate is substandard.  Recommendation:  Raise overall awareness of individual cats available for adoption by leveraging the database for online sites such as Petfinder.com, where the majority of people looking to adopt a pet start their search.  Make the physical location easier to find by increasing roadside signage. The shelter does not have extensive phone or email communications so it is imperative that potential customers can find the shelter during office hours. 2. CONSOLIDATED FINDINGS

6. AHS CAT SHELTER DATA MODEL  Finding #3: AHS funding is not stable from year to year.  Recommendation:  Instead of relying on one-time donations (the bulk of which come form Pick.Click.Give), utilize current volunteer experience in grant writing and search for renewable grants that provide a more sustainable funding method for non-profit entities.  Increased funding may allow for a full time paid employee who could maintain the database. This will be imperative to assist in tracking grant management and making sure the shelter is fulfilling the grant requirements. 2. CONSOLIDATED FINDINGS

7. AHS CAT SHELTER DATA MODEL 3. DIMENSIONAL MODELING Measures of Interest Measures related to the “Cat care and Adoption”: 1. Cats 2. Adoption 3. Health History 4. Vaccination Measures related to “Facility and Volunteers”: 1. Volunteers 2. Donations 3. Maintenance

8. AHS CAT SHELTER DATA MODEL 3. DIMENSIONAL MODELING

9. AHS CAT SHELTER DATA MODEL 3. DIMENSIONAL MODELING

10. AHS CAT SHELTER DATA MODEL Data quality ensuring measures 3. DIMENSIONAL MODELING RELEVANT ATTRIBUTES DATA STEWARTSHIP ROLES Completeness Reliability Accuracy Conciseness Usefulness Anita Shell Lauren Riley technical issues database population

11. AHS CAT SHELTER DATA MODEL  Data management has been identified as a key area of importance for AHS  Once the information has been catalogued, volunteers will need to be assigned the task of maintaining the updated database  Overall business objectives such as increased adoptions and donations will be effected by their ability to properly maintain and leverage their data CONCLUSION

12. AHS CAT SHELTER DATA MODEL THANK YOU! Lauren Patrick Mario

�ݺ�ߣ

Dimensional Modeling for AHS

Recommended

More Related Content

Similar to Dimensional Modeling for AHS (20)

Dimensional Modeling for AHS