41554 blogs · [ { "id": "01a08727-2665-7085-8c6e-943bf5ba18be", "title": "\"Untrustworthy\" is not a diagnosis", "url": "https://www.amitkohli.com/series/untrustworthy-is-not-a-diagnosis/", "published_at": "2026-08-17T00:00:00+00:00" }, { "id": "01a08727-2665-7085-8c6e-943bf66bda78", "title": "Your CASE WHEN is not a specification", "url": "https://www.amitkohli.com/series/your-case-when-is-not-a-specification/", "published_at": "2026-08-10T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389921a193b2", "title": "One Row Per What?", "url": "https://www.amitkohli.com/series/one-row-per-what/", "published_at": "2026-08-04T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992282b51b", "title": "There's no such thing as a quick question", "url": "https://www.amitkohli.com/series/theres-no-such-thing-as-a-quick-question/", "published_at": "2026-07-27T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992315aa92", "title": "01/02/2026 is two different days", "url": "https://www.amitkohli.com/series/01/02/2026-is-two-different-days/", "published_at": "2026-07-20T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899236b849f", "title": "Scaffolding for AI", "url": "https://www.amitkohli.com/series/scaffolding-for-ai/", "published_at": "2026-07-13T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899239f3fed", "title": "If you don't have a data dictionary, start here", "url": "https://www.amitkohli.com/series/if-you-dont-have-a-data-dictionary-start-here/", "published_at": "2026-07-06T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389923a228b2", "title": "What are agents and skills for an agent?", "url": "https://www.amitkohli.com/series/what-are-agents-and-skills-for-an-agent/", "published_at": "2026-06-29T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389923e7b108", "title": "Reporting is not insight", "url": "https://www.amitkohli.com/series/reporting-is-not-insight/", "published_at": "2026-06-22T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992469a66e", "title": "The problem with averages", "url": "https://www.amitkohli.com/series/the-problem-with-averages/", "published_at": "2026-06-15T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389924f71e26", "title": "How do you know when you've outgrown your tool?", "url": "https://www.amitkohli.com/series/how-do-you-know-when-youve-outgrown-your-tool/", "published_at": "2026-06-08T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899251bc423", "title": "How to know when your spreadsheet has outgrown Excel", "url": "https://www.amitkohli.com/series/how-to-know-when-your-spreadsheet-has-outgrown-excel/", "published_at": "2026-05-28T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389925250ed1", "title": "This is why your VLOOKUP isn't working", "url": "https://www.amitkohli.com/series/this-is-why-your-vlookup-isnt-working/", "published_at": "2026-05-21T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389925c191de", "title": "Treat the AI like an employee", "url": "https://www.amitkohli.com/series/treat-the-ai-like-an-employee/", "published_at": "2026-05-14T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992638d498", "title": "Your AI problems are not staff problems", "url": "https://www.amitkohli.com/series/your-ai-problems-are-not-staff-problems/", "published_at": "2026-05-07T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389926e96abc", "title": "Report or Dashboard?", "url": "https://www.amitkohli.com/series/report-or-dashboard/", "published_at": "2026-04-30T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389926fc8413", "title": "Before you build another AI agent, write a quality charter", "url": "https://www.amitkohli.com/series/before-you-build-another-ai-agent-write-a-quality-charter/", "published_at": "2026-04-23T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899274e0687", "title": "What does AI actually do to your organisation?", "url": "https://www.amitkohli.com/talks/what-does-ai-actually-do-to-your-organisation/", "published_at": "2026-04-16T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389927f854f9", "title": "Prompting Foundations: how to talk to chatbots", "url": "https://www.amitkohli.com/talks/prompting-foundations-how-to-talk-to-chatbots/", "published_at": "2026-03-12T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389928f6ab7c", "title": "Why Flat Classification Fails", "url": "https://www.amitkohli.com/series/why-flat-classification-fails/", "published_at": "2026-02-12T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389929dfe014", "title": "Knowledge Graphs 101: Mapping 52 Weeks of Data Concepts", "url": "https://www.amitkohli.com/series/knowledge-graphs-101-mapping-52-weeks-of-data-concepts/", "published_at": "2026-02-05T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992acbcf08", "title": "Every dataset is an argument you didn't write down", "url": "https://www.amitkohli.com/series/every-dataset-is-an-argument-you-didnt-write-down/", "published_at": "2026-01-29T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992b4f55d3", "title": "Why you can't answer next year's questions (disaggregated data)", "url": "https://www.amitkohli.com/series/why-you-cant-answer-next-years-questions-disaggregated-data/", "published_at": "2026-01-22T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992be89bda", "title": "How a 'quick Excel' becomes a $500k data project that fails", "url": "https://www.amitkohli.com/series/how-a-quick-excel-becomes-a-500k-data-project-that-fails/", "published_at": "2026-01-15T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992cd62c5c", "title": "Your Excel File is Doing Three Jobs (and failing at all of them)", "url": "https://www.amitkohli.com/series/your-excel-file-is-doing-three-jobs-and-failing-at-all-of-them/", "published_at": "2026-01-09T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992d359ab9", "title": "Shaping the future - Intro to Data Portal & Dashboard", "url": "https://www.amitkohli.com/talks/shaping-the-future-intro-to-data-portal-dashboard/", "published_at": "2025-10-24T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992d99053b", "title": "Shaping the future of social care data - System Overview", "url": "https://www.amitkohli.com/talks/shaping-the-future-of-social-care-data-system-overview/", "published_at": "2025-10-24T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992e418a14", "title": "From Fragmentation to Transparency - Using AI to Democratise Social Care Data", "url": "https://www.amitkohli.com/talks/from-fragmentation-to-transparency-using-ai-to-democratise-social-care-data/", "published_at": "2025-10-15T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992f0a9b6d", "title": "What is RAG and how to get it right", "url": "https://www.amitkohli.com/talks/what-is-rag-and-how-to-get-it-right/", "published_at": "2025-10-02T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38992f84537b", "title": "Growing Pains in RAG (intro level)", "url": "https://www.amitkohli.com/talks/growing-pains-in-rag-intro-level/", "published_at": "2025-01-28T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389930241d99", "title": "Growing Pains in RAG (super-techie version)", "url": "https://www.amitkohli.com/talks/growing-pains-in-rag-super-techie-version/", "published_at": "2025-01-16T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389930498a86", "title": "Adventures in RAG: Are Chocolate Covered Pickles Delicious?", "url": "https://www.amitkohli.com/talks/adventures-in-rag-are-chocolate-covered-pickles-delicious/", "published_at": "2024-10-18T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389930609ed7", "title": "Data is STILL Useless", "url": "https://www.amitkohli.com/talks/data-is-still-useless/", "published_at": "2024-09-05T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389930682147", "title": "Match the feeling, not the question", "url": "https://www.amitkohli.com/blog-legacy/match-the-feeling-not-the-question/", "published_at": "2024-08-08T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993091bdf6", "title": "Match the feeling, not the question", "url": "https://www.amitkohli.com/post/match-the-feeling-not-the-question/", "published_at": "2024-08-08T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389930dd4731", "title": "Access to Justice - Lawtech Panel", "url": "https://www.amitkohli.com/talks/access-to-justice-lawtech-panel/", "published_at": "2024-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993184eee4", "title": "Data is Useless", "url": "https://www.amitkohli.com/talks/data-is-useless/", "published_at": "2024-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993242633e", "title": "SDG Direction Estimation", "url": "https://www.amitkohli.com/blog-legacy/sdg-direction-estimation/", "published_at": "2023-07-30T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389932fffc44", "title": "SDG Direction Estimation", "url": "https://www.amitkohli.com/post/sdg-direction-estimation/", "published_at": "2023-07-30T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899339f90e4", "title": "an R-user's guide to Python for data science", "url": "https://www.amitkohli.com/blog-legacy/an-r-user-s-guide-to-python-for-data-science/", "published_at": "2023-03-15T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389934395ef4", "title": "an R-user's guide to Python for data science", "url": "https://www.amitkohli.com/post/an-r-user-s-guide-to-python-for-data-science/", "published_at": "2023-03-15T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389934890cc5", "title": "10 reasons why Random Forest is the only algorithm you will need", "url": "https://www.amitkohli.com/blog-legacy/10-reasons-why-random-forest-is-the-only-algorithm-you-will-need/", "published_at": "2022-10-19T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993516cfdb", "title": "10 reasons why Random Forest is the only algorithm you will need", "url": "https://www.amitkohli.com/post/10-reasons-why-random-forest-is-the-only-algorithm-you-will-need/", "published_at": "2022-10-19T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389935d95381", "title": "How are SDG Indicators interconnected?", "url": "https://www.amitkohli.com/blog-legacy/how-are-sdgs-interconnected/", "published_at": "2022-07-20T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389936044606", "title": "How are SDG Indicators interconnected?", "url": "https://www.amitkohli.com/post/2022-07-20-how-are-sdgs-interconnected/", "published_at": "2022-07-20T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389936e610b5", "title": "Knowledge Graphs but, like, for Everything", "url": "https://www.amitkohli.com/talks/knowledge-graphs-but-like-for-everything/", "published_at": "2022-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899373b26de", "title": "Natural Language Processing for Data Science for Good", "url": "https://www.amitkohli.com/talks/natural-language-processing-for-data-science-for-good/", "published_at": "2021-04-19T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389937cf36df", "title": "Introduction to Network Analysis", "url": "https://www.amitkohli.com/talks/introduction-to-network-analysis/", "published_at": "2021-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389938820b4f", "title": "Interactive COVID map by LSOA", "url": "https://www.amitkohli.com/blog-legacy/interactive-covid-map-by-lsoa/", "published_at": "2020-11-08T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389938c55396", "title": "Interactive COVID map by LSOA", "url": "https://www.amitkohli.com/blog/interactive-covid-map-by-lsoa/", "published_at": "2020-11-08T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899396e3baf", "title": "Introducing CarbonFootprintR, the cool way to figure out the carbon footprint of your in-person event", "url": "https://www.amitkohli.com/blog-legacy/introducing-carbonfootprintr-the-cool-way-to-figure-out-the-carbon-footprint-of-your-in-person-event/", "published_at": "2020-07-31T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993a43825b", "title": "Introducing CarbonFootprintR, the cool way to figure out the carbon footprint of your in-person event", "url": "https://www.amitkohli.com/post/introducing-carbonfootprintr-the-cool-way-to-figure-out-the-carbon-footprint-of-your-in-person-event/", "published_at": "2020-07-31T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993ae8ae78", "title": "How to create an R package, easy mode", "url": "https://www.amitkohli.com/blog-legacy/how-to-create-an-r-package-easy-mode/", "published_at": "2020-01-07T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993bcfb9aa", "title": "How to create an R package, easy mode", "url": "https://www.amitkohli.com/blog/how-to-create-an-r-package-easy-mode/", "published_at": "2020-01-07T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993c99785b", "title": "Problems with data", "url": "https://www.amitkohli.com/blog-legacy/problems-with-data/", "published_at": "2020-01-07T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993ce90921", "title": "Testing, Testing, 123!", "url": "https://www.amitkohli.com/talks/testing-testing-123/", "published_at": "2020-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993d494fe7", "title": "Plot shapes for 100000 movies using new package thePlotThickens", "url": "https://www.amitkohli.com/blog-legacy/plot-shapes-for-100000-movies-using-new-package-theplotthickens/", "published_at": "2019-03-08T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993dd5173c", "title": "DBBUDDY - Offline Data Collection for Impact", "url": "https://www.amitkohli.com/talks/dbbuddy-offline-data-collection-for-impact/", "published_at": "2019-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993dda8e1f", "title": "R is for Reconciliation", "url": "https://www.amitkohli.com/talks/r-is-for-reconciliation/", "published_at": "2019-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993e551ec4", "title": "Is there more violent crime in my hood than in the rest of London?", "url": "https://www.amitkohli.com/blog-legacy/crime-statistics-in-london/", "published_at": "2018-09-23T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993eb67c05", "title": "Is there more violent crime in my hood than in the rest of London?", "url": "https://www.amitkohli.com/post/crime-statistics-in-london/", "published_at": "2018-09-23T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38993f9abfcf", "title": "Introducing the Monitoring and Evaluation Bullet Chart", "url": "https://www.amitkohli.com/introducing-the-monitoring-and-evaluation-bullet-chart/", "published_at": "2018-03-16T10:27:20+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389940476a7b", "title": "Data Tools - Databases and CRM Systems", "url": "https://www.amitkohli.com/talks/data-tools-databases-and-crm-systems/", "published_at": "2018-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389940c9e87d", "title": "From Raw Data to Real Insights", "url": "https://www.amitkohli.com/talks/from-raw-data-to-real-insights/", "published_at": "2018-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899417ecad3", "title": "LEAP, and How to Bring Data to Life in Your Organisation", "url": "https://www.amitkohli.com/talks/leap-and-how-to-bring-data-to-life-in-your-organisation/", "published_at": "2018-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389941b8ea79", "title": "Why Should We Care About Social Network Analysis?", "url": "https://www.amitkohli.com/talks/why-should-we-care-about-social-network-analysis/", "published_at": "2018-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389942ab359e", "title": "Setting up twitter streamR Service on an Ubuntu server", "url": "https://www.amitkohli.com/setting-up-twitter-streamr-service-on-an-ubuntu-server/", "published_at": "2017-11-07T15:56:06+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389942e478de", "title": "Announcing ShinyTester - a package that helps you build Shiny apps", "url": "https://www.amitkohli.com/announcing-shinytester-a-package-that-helps-you-build-shiny-apps/", "published_at": "2017-02-01T17:16:57+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389943121dae", "title": "Ethiopia Theory of Change Event", "url": "https://www.amitkohli.com/talks/ethiopia-theory-of-change-event/", "published_at": "2017-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389943b0b923", "title": "Making International Development Data Not Useless", "url": "https://www.amitkohli.com/talks/making-international-development-data-not-useless/", "published_at": "2017-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389943e11fdd", "title": "Tanzania COP Learning Event", "url": "https://www.amitkohli.com/talks/tanzania-cop-learning-event/", "published_at": "2017-01-01T00:00:00+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389944cc42c9", "title": "Pop quiz! What is this chart saying?", "url": "https://www.amitkohli.com/pop-quiz-what-is-this-chart-saying/", "published_at": "2016-11-09T01:06:19+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899450d96e9", "title": "Heart-shaped wordcloud, celebrating Colombia peace treaty", "url": "https://www.amitkohli.com/heart-shaped-wordcloud-celebrating-colombia-peace-treaty/", "published_at": "2016-09-27T03:53:07+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899455b745e", "title": "Track your local R scheduled tasks with CommandCenter2000!!!", "url": "https://www.amitkohli.com/track-your-local-r-scheduled-tasks-with-commandcenter2000/", "published_at": "2016-05-29T17:32:02+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38994565bce4", "title": "I'm leading the Accra R-User Meetups!", "url": "https://www.amitkohli.com/im-leading-the-accra-r-user-meetups/", "published_at": "2016-05-24T20:06:27+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38994603fdb5", "title": "Make dashboard Tiles/Notecards in R", "url": "https://www.amitkohli.com/make-dashboard-tilesnotecards-in-r/", "published_at": "2016-02-25T19:47:39+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389946987046", "title": "KPI dashboard in R with animated icons", "url": "https://www.amitkohli.com/kpi-dashboard-in-r-with-animated-icons/", "published_at": "2016-02-12T10:08:04+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899470990ae", "title": "I'm proudly featured on r-bloggers!", "url": "https://www.amitkohli.com/im-proudly-featured-on-r-bloggers/", "published_at": "2016-02-05T00:10:08+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389947d2c47d", "title": "R Tagosphere!", "url": "https://www.amitkohli.com/r-tagosphere/", "published_at": "2016-01-31T17:41:10+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389947dd3cad", "title": "Who is it hard to shop for?", "url": "https://www.amitkohli.com/who-is-it-hard-to-shop-for/", "published_at": "2015-12-04T19:57:57+00:00" }, { "id": "01a08727-2666-73ac-a0c5-3899488c5389", "title": "10 things you didn't know about taxi costs in Accra", "url": "https://www.amitkohli.com/10-things-you-didnt-know-about-taxi-costs-in-accra/", "published_at": "2015-11-16T16:46:47+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389949522072", "title": "How to move ODBC DSN information from one computer to another", "url": "https://www.amitkohli.com/how-to-move-odbc-dsn-information-from-one-computer-to-another/", "published_at": "2015-10-29T19:02:49+00:00" }, { "id": "01a08727-2666-73ac-a0c5-389949e5190b", "title": "Clickable list of the best animations since 1900, gathered the geek way.", "url": "https://www.amitkohli.com/list-of-the-best-animations-since-1900-gathered-the-geek-way/", "published_at": "2015-10-22T13:51:20+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38994a7cb408", "title": "Locations for 75000 dams", "url": "https://www.amitkohli.com/locations-for-75000-dams/", "published_at": "2015-10-20T20:30:39+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38994ab39cb5", "title": "Chick flicks vs action movies!", "url": "https://www.amitkohli.com/chick-flicks-vs-action-movies/", "published_at": "2015-10-13T22:41:44+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38994b90783a", "title": "Sentiment analysis on my girlfriend's text messages", "url": "https://www.amitkohli.com/sentiment-analysis-on-my-girlfriends-text-messages/", "published_at": "2015-09-11T13:22:14+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38994c050e2c", "title": "Excel is how I do maps...", "url": "https://www.amitkohli.com/excel-is-how-i-do-maps/", "published_at": "2015-07-08T15:15:55+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38994c21851e", "title": "Irrigated Crop Calendar Vizualisation", "url": "https://www.amitkohli.com/irrigated-crop-calendar-vizualisation/", "published_at": "2015-07-02T09:37:04+00:00" }, { "id": "01a08727-2666-73ac-a0c5-38994ccab72f", "title": "Simplified renewable water resources, visualized", "url": "https://www.amitkohli.com/simplified-renewable-water-resources-visualized/", "published_at": "2015-07-01T16:37:00+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa5061e2a91", "title": "The Reddit effect...", "url": "https://www.amitkohli.com/the-reddit-effect/", "published_at": "2015-05-01T19:32:56+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa506649a9c", "title": "The Reddit effect…", "url": "https://www.amitkohli.com/the-Reddit-effect/", "published_at": "2015-05-01T19:32:56+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa506e0d16e", "title": "Global dam capacity visualization", "url": "https://www.amitkohli.com/global-dam-capacity-visualization/", "published_at": "2015-03-06T10:04:00+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa50705686b", "title": null, "url": "https://www.amitkohli.com/irrigation-area-treemaps/", "published_at": "2015-03-04T19:16:41+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa507fce762", "title": "Transboundary surface water flow", "url": "https://www.amitkohli.com/transboundary-surface-water-flow/", "published_at": "2015-03-04T19:05:38+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa508a01b77", "title": "Chord progressions of 5000 songs!", "url": "https://www.amitkohli.com/chord-progressions-of-5-000-songs/", "published_at": "2015-03-01T00:00:00+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa5090fbc67", "title": "Best way to make a custom palette with ggplot2", "url": "https://www.amitkohli.com/best-way-to-make-a-custom-palette-with-ggplot2/", "published_at": "2015-02-27T18:38:44+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa509acd0bd", "title": "Best way to unclog drains", "url": "https://www.amitkohli.com/best-way-to-unclog-drains/", "published_at": "2015-02-19T18:00:47+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa50a658e4d", "title": "Excel basics", "url": "https://www.amitkohli.com/excel-basics/", "published_at": "2015-02-16T18:32:22+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa50ae48d95", "title": "Cover images for facebook, google+, whatever", "url": "https://www.amitkohli.com/cover-images-for-facebook-google-whatever/", "published_at": "2014-11-12T00:37:33+00:00" }, { "id": "01a08727-2667-727d-9cdf-baa50bbc09ec", "title": "Arduino theremin concert", "url": "https://www.amitkohli.com/arduino-theremin-concert/", "published_at": "2014-11-11T00:52:47+00:00" } ] posts Claim your blog

Back to amitkohli.com

Blog · corpus.blog/blogs/amitkohli.com/posts

amitkohli.com

amitkohli.com

2026

"Untrustworthy" is not a diagnosis original ↗

17 Aug 2026

Your CASE WHEN is not a specification original ↗

10 Aug 2026

One Row Per What?original ↗

4 Aug 2026

There's no such thing as a quick question original ↗

27 Jul 2026

01/02/2026 is two different days original ↗

20 Jul 2026

Scaffolding for AI original ↗

13 Jul 2026

If you don't have a data dictionary, start here original ↗

6 Jul 2026

What are agents and skills for an agent?original ↗

29 Jun 2026

Reporting is not insight original ↗

22 Jun 2026

The problem with averages original ↗

15 Jun 2026

How do you know when you've outgrown your tool?original ↗

8 Jun 2026

How to know when your spreadsheet has outgrown Excel original ↗

28 May 2026

This is why your VLOOKUP isn't working original ↗

21 May 2026

Treat the AI like an employee original ↗

14 May 2026

Your AI problems are not staff problems original ↗

7 May 2026

Report or Dashboard?original ↗

30 Apr 2026

Before you build another AI agent, write a quality charter original ↗

23 Apr 2026

What does AI actually do to your organisation?original ↗

16 Apr 2026

Prompting Foundations: how to talk to chatbots original ↗

12 Mar 2026

Why Flat Classification Fails original ↗

12 Feb 2026

Knowledge Graphs 101: Mapping 52 Weeks of Data Concepts original ↗

5 Feb 2026

Every dataset is an argument you didn't write down original ↗

29 Jan 2026

Why you can't answer next year's questions (disaggregated data)original ↗

22 Jan 2026

How a 'quick Excel' becomes a $500k data project that fails original ↗

15 Jan 2026

Your Excel File is Doing Three Jobs (and failing at all of them)original ↗

9 Jan 2026

2025

Shaping the future - Intro to Data Portal & Dashboard original ↗

24 Oct 2025

Shaping the future of social care data - System Overview original ↗

24 Oct 2025

From Fragmentation to Transparency - Using AI to Democratise Social Care Data original ↗

15 Oct 2025

What is RAG and how to get it right original ↗

2 Oct 2025

Growing Pains in RAG (intro level)original ↗

28 Jan 2025

Growing Pains in RAG (super-techie version)original ↗

16 Jan 2025

2024

Adventures in RAG: Are Chocolate Covered Pickles Delicious?original ↗

18 Oct 2024

Data is STILL Useless original ↗

5 Sept 2024

Match the feeling, not the question original ↗

8 Aug 2024

Match the feeling, not the question original ↗

8 Aug 2024

Access to Justice - Lawtech Panel original ↗

1 Jan 2024

Data is Useless original ↗

1 Jan 2024

2023

SDG Direction Estimation original ↗

30 Jul 2023

SDG Direction Estimation original ↗

30 Jul 2023

an R-user's guide to Python for data science original ↗

15 Mar 2023

an R-user's guide to Python for data science original ↗

15 Mar 2023

2022

10 reasons why Random Forest is the only algorithm you will need original ↗

19 Oct 2022

10 reasons why Random Forest is the only algorithm you will need original ↗

19 Oct 2022

How are SDG Indicators interconnected?original ↗

20 Jul 2022

How are SDG Indicators interconnected?original ↗

20 Jul 2022

Knowledge Graphs but, like, for Everything original ↗

1 Jan 2022

2021

Natural Language Processing for Data Science for Good original ↗

19 Apr 2021

Introduction to Network Analysis original ↗

1 Jan 2021

2020

Interactive COVID map by LSOA original ↗

8 Nov 2020

Interactive COVID map by LSOA original ↗

8 Nov 2020

Introducing CarbonFootprintR, the cool way to figure out the carbon footprint of your in-person event original ↗

31 Jul 2020

Introducing CarbonFootprintR, the cool way to figure out the carbon footprint of your in-person event original ↗

31 Jul 2020

How to create an R package, easy mode original ↗

7 Jan 2020

How to create an R package, easy mode original ↗

7 Jan 2020

Problems with data original ↗

7 Jan 2020

Testing, Testing, 123!original ↗

1 Jan 2020

2019

Plot shapes for 100000 movies using new package thePlotThickens original ↗

8 Mar 2019

DBBUDDY - Offline Data Collection for Impact original ↗

1 Jan 2019

R is for Reconciliation original ↗

1 Jan 2019

2018

Is there more violent crime in my hood than in the rest of London?original ↗

23 Sept 2018

Is there more violent crime in my hood than in the rest of London?original ↗

23 Sept 2018

Introducing the Monitoring and Evaluation Bullet Chart original ↗

16 Mar 2018

Data Tools - Databases and CRM Systems original ↗

1 Jan 2018

From Raw Data to Real Insights original ↗

1 Jan 2018

LEAP, and How to Bring Data to Life in Your Organisation original ↗

1 Jan 2018

Why Should We Care About Social Network Analysis?original ↗

1 Jan 2018

2017

Setting up twitter streamR Service on an Ubuntu server original ↗

7 Nov 2017

Announcing ShinyTester - a package that helps you build Shiny apps original ↗

1 Feb 2017

Ethiopia Theory of Change Event original ↗

1 Jan 2017

Making International Development Data Not Useless original ↗

1 Jan 2017

Tanzania COP Learning Event original ↗

1 Jan 2017

2016

Pop quiz! What is this chart saying?original ↗

9 Nov 2016

Heart-shaped wordcloud, celebrating Colombia peace treaty original ↗

27 Sept 2016

Track your local R scheduled tasks with CommandCenter2000!!!original ↗

29 May 2016

I'm leading the Accra R-User Meetups!original ↗

24 May 2016

Make dashboard Tiles/Notecards in R original ↗

25 Feb 2016

KPI dashboard in R with animated icons original ↗

12 Feb 2016

I'm proudly featured on r-bloggers!original ↗

5 Feb 2016

R Tagosphere!original ↗

31 Jan 2016

2015

Who is it hard to shop for?original ↗

4 Dec 2015

10 things you didn't know about taxi costs in Accra original ↗

16 Nov 2015

How to move ODBC DSN information from one computer to another original ↗

29 Oct 2015

Clickable list of the best animations since 1900, gathered the geek way.original ↗

22 Oct 2015

Locations for 75000 dams original ↗

20 Oct 2015

Chick flicks vs action movies!original ↗

13 Oct 2015

Sentiment analysis on my girlfriend's text messages original ↗

11 Sept 2015

Excel is how I do maps...original ↗

8 Jul 2015

Irrigated Crop Calendar Vizualisation original ↗

2 Jul 2015

Simplified renewable water resources, visualized original ↗

1 Jul 2015

The Reddit effect...original ↗

1 May 2015

The Reddit effect…original ↗

1 May 2015

Global dam capacity visualization original ↗

6 Mar 2015

https://www.amitkohli.com/irrigation-area-treemaps/original ↗

4 Mar 2015

Transboundary surface water flow original ↗

4 Mar 2015

Chord progressions of 5000 songs!original ↗

1 Mar 2015

Best way to make a custom palette with ggplot2 original ↗

27 Feb 2015

Best way to unclog drains original ↗

19 Feb 2015

Excel basics original ↗

16 Feb 2015

2014

Cover images for facebook, google+, whatever original ↗

12 Nov 2014

Arduino theremin concert original ↗

11 Nov 2014