{"id":1842,"date":"2014-10-28T12:29:51","date_gmt":"2014-10-28T12:29:51","guid":{"rendered":"https:\/\/techcafeteria.com\/new\/?p=1842"},"modified":"2014-10-28T12:29:51","modified_gmt":"2014-10-28T12:29:51","slug":"how-easy-is-it-for-you-to-manage-analyze-and-present-data","status":"publish","type":"post","link":"https:\/\/techcafeteria.com\/?p=1842","title":{"rendered":"How Easy Is It For You To Manage, Analyze And Present Data?"},"content":{"rendered":"<p><a href=\"http:\/\/techcafeteria.com\/new\/wp-content\/uploads\/2014\/10\/apple-256262_640.jpg\"><img decoding=\"async\" class=\"alignright  wp-image-1844\" style=\"padding-left: 10px;\" src=\"http:\/\/techcafeteria.com\/new\/wp-content\/uploads\/2014\/10\/apple-256262_640.jpg\" alt=\"apple-256262_640\" width=\"225\" height=\"149\" srcset=\"https:\/\/techcafeteria.com\/wp-content\/uploads\/2014\/10\/apple-256262_640.jpg 640w, https:\/\/techcafeteria.com\/wp-content\/uploads\/2014\/10\/apple-256262_640-300x198.jpg 300w, https:\/\/techcafeteria.com\/wp-content\/uploads\/2014\/10\/apple-256262_640-347x230.jpg 347w\" sizes=\"(max-width: 225px) 100vw, 225px\" \/><\/a>I ask because my <a href=\"https:\/\/techcafeteria.com\/category\/articles\/\">articles are up<\/a>, including my big piece from <a href=\"http:\/\/www.nten.org\/research\/collected-voices-data-informed-nonprofits\">NTEN&#8217;s Collected Voices: Data-Informed Nonprofits <\/a>on <a href=\"https:\/\/techcafeteria.com\/2014\/10\/27\/architecting-healthy-data-management-systems\/\">Architecting Healthy Data Management Systems<\/a>. I&#8217;m happy to have this one available in a standalone, web-searchable format, because I think it&#8217;s a bit of a \u00a0signature work. \u00a0I consider data systems architecture to be my main talent; the most significant work that I&#8217;ve done in my career.<\/p>\n<ul>\n<li>I integrated eleven databases at the law firm of <a href=\"http:\/\/investing.businessweek.com\/research\/stocks\/private\/snapshot.asp?privcapId=1080972\">Lillick &amp; Charles<\/a> in the late 90&#8217;s, using Outlook as a portal to Intranet, CRM, documents and voicemail. We had\u00a0single-entry of all client and matter data that then, through SQL Server triggers, was pushed to the other databases that shared the data. \u00a0This is what I call the &#8220;holy grail&#8221; of data ,entered once by the person who cares most about it, distributed to the systems that use it, and then easily accessible by staff. No misspelled names or redundant data entry chores.<\/li>\n<\/ul>\n<ul>\n<li>In the early 2000&#8217;s, at <a href=\"http:\/\/www.sfgoodwill.org\">Goodwill<\/a>, I developed a <a href=\"http:\/\/www.slideshare.net\/peterscampbell\/retail-data-warehouse\">retail data management system<\/a> on open source (MySQL and PHP, primarily) that put drill-down reporting in a web browser, updated by 6:00 am every morning with the latest sales and production data. \u00a0We were able to use this data in ways that were revolutionary for a budget-challenged Goodwill, and we saw impressive financial results.<\/li>\n<\/ul>\n<p>The article lays out the approach I&#8217;m taking at <a href=\"http:\/\/www.lsc.gov\">Legal Services Corporation<\/a> to integrate all of our grantee data into a &#8220;data portal&#8221;, built on Salesforce and Box. It&#8217;s written with the challenges that nonprofits face front and center: how to do this on a budget, and how to do it without a team of developers on staff.<\/p>\n<p>At a time when, more and more, our funding depends on our ability to demonstrate our effectiveness, we need the data to be reliable, available and presentable. \u00a0This is my primer on how you get there from the IT viewpoint.<\/p>\n<p>I also put up four articles from Idealware. \u00a0These are all older (2007 to 2009), they&#8217;re all still pretty relevant, although some of you might debate me on the RSS article:<\/p>\n<ul>\n<li><a href=\"https:\/\/techcafeteria.com\/2007\/01\/27\/better-organization-through-document-management-systems\/\">Better Organization\u00a0Through\u00a0Document\u00a0Management Systems<\/a>\u00a0outlines what a document management system can do for you and the types of systems available.<\/li>\n<li><a title=\"Permanent Link to XML, API, CSV, SOAP! Understanding The Alphabet Soup Of Data Exchange\" href=\"https:\/\/techcafeteria.com\/2007\/10\/27\/alphabet-soup-data-exchange\/\" rel=\"bookmark\">XML, API, CSV, SOAP! Understanding The Alphabet Soup Of Data Exchange<\/a>\u00a0is a fairly techie primer on the nuts and bolts of data integration. \u00a0Unlike the Healthy article, which is a high-level guide, this one talks about XML and CSV syntax. \u00a0Very useful if you&#8217;re the one charged with moving that data from ETapestry to Salesforce.<\/li>\n<li><a title=\"Permanent Link to The Perfect Fit: A Guide To Evaluating And Purchasing Major Software Systems\" href=\"https:\/\/techcafeteria.com\/2008\/09\/27\/the-perfect-fit-a-guide-to-evaluating-and-purchasing-major-software-systems\/\" rel=\"bookmark\">The Perfect Fit: A Guide To Evaluating And Purchasing Major Software Systems<\/a>\u00a0is a big one, covering the process of buying a new CRM or ERP system from needs assessment to contract negotiation. \u00a0One of the most useful things I ever wrote, completed right after doing a close to million dollar project with a very well-known, nonprofit-focused fundraising system vendor.<\/li>\n<li><a title=\"Permanent Link to Using RSS Tools to Feed Your Information Needs\" href=\"https:\/\/techcafeteria.com\/2009\/03\/27\/using-rss-tools-to-feed-your-information-needs\/\" rel=\"bookmark\">Using RSS Tools to Feed Your Information Needs<\/a>\u00a0is everything that you need to know about using RSS to bring information to you. Just do me a favor and substitute &#8220;Feedly&#8221; everywhere the article mentions &#8220;Google Reader&#8221;!<\/li>\n<\/ul>\n<p>This leaves only one significant piece of my nptech writing missing on the blog, and that&#8217;s my chapter in <a href=\"http:\/\/www.nten.org\/blog\/2008\/11\/25\/managing-technology-meet-your-mission\">NTEN&#8217;s &#8220;Managing Technology To Meet Your Mission<\/a>&#8221; book about Strategic Planning. Sorry, <a href=\"http:\/\/smile.amazon.com\/Managing-Technology-Meet-Your-Mission\/dp\/0470343656\">you gotta buy that one<\/a>. However, a <a href=\"http:\/\/www.slideshare.net\/peterscampbell\/strategic-planning-tig-2014\">Powerpoint that I based on my chapter is here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I ask because my articles are up, including my big piece from NTEN&#8217;s Collected Voices: Data-Informed Nonprofits on Architecting Healthy Data Management Systems. I&#8217;m happy to have this one available in a standalone, web-searchable format, because I think it&#8217;s a bit of a \u00a0signature work. \u00a0I consider data systems architecture to be my main talent;<br \/><a class=\"moretag\" href=\"https:\/\/techcafeteria.com\/?p=1842\">+ Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,82],"tags":[161,104,199,387,132,87,263,123,101,109,84,173,85,136],"class_list":["post-1842","post","type-post","status-publish","format-standard","hentry","category-nptech","category-tech","tag-book","tag-data","tag-data-integrity","tag-data-management","tag-document-management","tag-goodwill","tag-integration","tag-lillick","tag-nten","tag-open-source","tag-rss","tag-strategic-planning","tag-strategy","tag-vendors"],"_links":{"self":[{"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/posts\/1842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1842"}],"version-history":[{"count":3,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/posts\/1842\/revisions"}],"predecessor-version":[{"id":1846,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/posts\/1842\/revisions\/1846"}],"wp:attachment":[{"href":"https:\/\/techcafeteria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}