PREVIOUS AND CURRENT

DATABASE DEVELOPMENT

Sweet Grass develops databases for our clients regularly in many different systems ranging from basic excel tables to relational customer relationship management (CRM) systems. Sweet Grass prioritizes a custom solution for each client we work with on database builds so that systems fit within a client’s process and supports their work, rather than adding to it. 

 

As part of our process we first identify what data is being collected, what tools are being utilized, and what the reporting needs are, and then aligning a tool and system to best meet the needs of the organization, as well as offering the ability to grow and change with the organization.

 

There are many solutions available and thus we work to identify the best tools and system while staying in budget and working within our client’s’ perspective(s) and overall vision. As part of this approach we try to identify one solution to fit an organization’s needs, especially in utilizing integrations between software.

 

We have built and serviced databases for the following organizations which provide different purposes for those organizations.

RESEARCH PROJECT DATABASES FOR

STORAGE AND ANALYSIS

CLIENTS AND PROJECTS INCLUDE:

 

  • Black Hills Community Loan Fund Market Study (2017 – 2019)

  • Cheyenne River Youth Projec REDCAN Graffiti Jam Event Evaluation (2017 and 2019)

  • The McKnight Foundation State of the Regional Arts Councils (2017– 2019)

  • Four Bands Community Fund

    • Youth Survey Comparison Report (2018)

    • Business Assessment (2015, 2016, and 2018)

    • Workforce Training Evaluation (2016)

    • Cheyenne River’s Workforce Development Survey and Report (2014 – 2015)

    • C.R.E.A.T.E. Evaluation Report (2015)

    • Fishing Derby Event Evaluation (2015)

    • VITA Program Evaluation (2015)

  • Lower Sioux Intergenerational Cultural Incubator Feasibility Study (2017– 2018)
  • Thunder Valley Community Development Corporation

    • Wakígnakapi: Developing a Food Hub and Grocery Store for the Oglala Lakota Oyáte Feasibility Study (2018)

    • Thunder Valley’s HOME Market Study (2017)

    • Oglala Oyate Survey and Report (2016)

  • First Nations Oweesta Corporation and Ihanktonwan Development Fund Market Analysis: A Community Snapshot (2018)

  • First Peoples Fund Investing in the Indigenous Arts Ecology Report (2017)

  • South Dakota Native Homeownership Coalition A Brief Look at Emerging Markets and Expanding Opportunities of Native Homeownership (2016 ‒ 2017)

  • Coeur d’Alene Financial Services Market Study (2017)

  • NACDC - Financial Services Piikani Money Awareness Campaign Evaluation and Reporting (2017)

  • ​​Native CDFI Network Revisiting Native American Entrepreneurship in South Dakota’s Nine Reservations Research Report (2017)

  • Cheyenne River Voices: Our Survey, Our Voice, Our Way Research and Report (2013 – 2016)

  • Building Native CDFI Sustainability and Impact Final Report (2016)

  • The Learning Journey II Final Report (2015)

  • ​​​First Nations Development Institute For Profit Opportunities in Native Communities: Entrepreneurship and Innovation Research and Report (2016)

  • First Nations Oweesta Corporation Building Native Communities Course Evaluation (2016)

  • The Lakota Fund Individual Development Account Impact Report (2016) 

  • Táala Fund/Bar K Market Study and Analysis Market Study and Analysis (2016)

  • Rosebud Economic Development Corporation Sicangu Strengths, Economic Needs, and Business Development Assessment Market Study (2014 – 2015

  • ​​Northern Shores Community Development Market Study Report (2015) 

ORGANIZATIONAL

IMPACT TRACKING

CLIENTS AND PROJECTS INCLUDE:

 

  • Bii Gii Wiin Community Development Fund  (2016 - current)

  • Chehalis Tribal Loan Fund (2015 - current)

  • Cheyenne River Youth Project  (2017 - current)

  • Council for Native Hawaiian Advancement  (2016 - current)

  • First American Capital Corporation (2015 - current)

  • First Nations Community Financial  (2016 - current)

  • Hmong Wisconsin Chamber of Commerce (2019 - current)

  • Indian Agricultural Council (2019 - current)

  • NACDC - Financial Services (2015 - current)

  • Native Partnership for Housing (2016 - current)

  • NiiJii Capital Partners Inc.  (2016 - current)

  • Nimiipuu Community Development Fund (2016 - current)

  • Northwest Native Development Fund  (2015 - current)

  • South Dakota Native Homeownership Coalition (2015 - current)

  • Táala Fund (2019 - current)

  • Tatanka Funds  (2016 - current)

  • Wisconsin Native Loan Fund  (2016 - current)

  • Great Eagle Financial Services (2019)

  • The Lakota Funds (2015 - 2018)

  • First Nations Oweesta Corporation (2015 - 2017)

  • First Peoples Fund (2013 - 2017)

  • Citizen Potawatomi Community Development Corporation (2015 - 2016)

  • Lummi Community Development Financial Institution (2015 - 2016)

  • Cha Piyeh Inc. (now Native Community Finance) (2016 - 2018)

  • Leech Lake Financial Services (2016 - 2018)

  • Mvskoke Loan Fund (2016 - 2018) 

CUSTOMER RELATIONSHIP MANAGEMENT SYSTEMS

CLIENTS AND PROJECTS INCLUDE:

 

  • Native CDFI Network Membership Database (2016)

PROJECT ACTIVITY AND IMPACT TRACKING

CLIENTS AND PROJECTS INCLUDE:

 

  • Pine Ridge Area Chamber of Commerce

    • Oglala Lakota Love of Learning Program Development and Evaluation (2017 – current)

    • Workforce and Business Development Longitudinal Research Project (2014 – 2018)

  • Rural Community Assistance Corporation’s Impact Measurement Program (2018 – current)

  • The Colorado Trust’s Yuma Resident Team Community Action Planning (2018) 

  • Cheyenne River Tribal Ventures’s Organization and Program Evaluation (2011 ‒ 2016)  

© 2019 by Sweet Grass Consulting, LLC. Proudly created with Wix.com

  • Wix Facebook page
  • Google Classic