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)

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

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

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

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

  • First Peoples Fund Investing in the Indigenous Arts Ecology Report (2017)
  • First Nations Oweesta Corporation Building Native Communities Course Evaluation (2016)

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

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

  • 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)

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

  • The Learning Journey II Final Report (2015)

  • Lower Sioux Intergenerational Cultural Incubator Feasibility Study (2017– 2018)
  • The McKnight Foundation State of the Regional Arts Councils (2017– 2019)

  • 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)

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

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

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

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

  • 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)

ORGANIZATIONAL

IMPACT TRACKING

CLIENTS AND PROJECTS INCLUDE:

 

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

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

  • Chehalis Tribal Loan Fund (2015 - current)

  • Cheyenne River Youth Project  (2017 - current)

  • Citizen Potawatomi Community Development Corporation (2015 - 2016)

  • Council for Native Hawaiian Advancement  (2016 - current)

  • First American Capital Corporation (2015 - current)

  • First Nations Community Financial  (2016 - current)

  • First Nations Oweesta Corporation (2015 - 2017)

  • First Peoples Fund (2013 - 2017)

  • Great Eagle Financial Services (2019)

  • Hawaiian Community Assets (2019 - current)

  • Hmong Wisconsin Chamber of Commerce (2019 - current)

  • Homestead Community Development Corporation (2019 - current)

  • Indian Agricultural Council (2019 - current)

  • The Lakota Funds (2015 - 2018)

  • Leech Lake Financial Services (2016 - 2018)

  • Lummi Community Development Financial Institution (2015 - 2016)

  • Mvskoke Loan Fund (2016 - 2018) 

  • 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)

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)  

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

  • Wix Facebook page
  • Google Classic