{"id":90512,"date":"2025-06-02T09:58:15","date_gmt":"2025-06-02T09:58:15","guid":{"rendered":"https:\/\/outliereditor.co.za\/?p=90512"},"modified":"2025-11-17T17:37:41","modified_gmt":"2025-11-17T17:37:41","slug":"this-week-in-charts-30-may-2025-african-visas-ai-african-markets","status":"publish","type":"post","link":"https:\/\/outliereditor.co.za\/index.php\/2025\/06\/02\/this-week-in-charts-30-may-2025-african-visas-ai-african-markets\/","title":{"rendered":"This week in charts: 30 May 2025 (African visas, AI, African markets)"},"content":{"rendered":"\n

A weekly wrap of the top stories of the week, using data. Subscribe to receive this via email every Friday<\/a>. <\/p>\n\n\n\n

Stack Overflow killed by AI<\/h2>\n\n\n\n

In the world of computer programming Stack Overflow<\/a> is a giant. For more than a decade it was the go-to site to ask tech-related questions.<\/p>\n\n\n\n

At its peak more than 300,000 questions* were posted on Stack Overflow every month. And many of those questions had dozens or even hundreds of responses.<\/p>\n\n\n\n

Stack Overflow was enormous.<\/p>\n\n\n\n

Which is why Naspers\u2019 Prosus was happy to spend $1.7-billion to buy the site<\/a> in August 2021. Many will argue that it was an overly expensive buy, but based on Stack Overflow\u2019s performance it could have worked out.<\/p>\n\n\n\n

But it didn\u2019t.<\/p>\n\n\n\n

In November 2020 ChatGPT was publicly launched and now new data<\/a> shows how activity on Stack Overflow plummeted in the following two years from more than 200,000 questions a month to just a few thousand as developers turned to AI for answers. Today most of Prosus\u2019 investment in Stack Overflow has been written off and Stack Overflow is all but dead.<\/p>\n\n\n\n

*Note<\/em><\/strong>: the question data includes all posts, including deleted posts, as an indicator of activity. <\/em>The data is from here<\/em><\/a>.<\/em><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Africa fact<\/h2>\n\n\n\n

Every week from now on, we\u2019re going to make a chart about our home continent in this Africa Fact section. We think it\u2019s time to turn our attention away from Trump and the tech bros for a moment and look closer at our fellow Africans.<\/p>\n\n\n\n

Last week we looked at South Africa\u2019s trade with the United States, China, Germany and India. This week, we\u2019ve looked at who SA trades with in Africa.<\/p>\n\n\n\n

Mozambique is South Africa\u2019s biggest African trade partner and exports reached close to R120-billion in 2024. It\u2019s one of the top 5 countries we export to, according to the SA Revenue Service. SA\u2019s other top partners are, not surprisingly, its immediate neighbours, Namibia, Botswana, Zimbabwe and Zambia.<\/p>\n\n\n\n

Nigeria is the African country South Africa imports the most from. In 2024, imports reached R46.7-billion, almost entirely crude petroleum, according to the Observatory of Economic Complexity<\/a>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Price of rejection<\/h2>\n\n\n\n

Africans lost more than $70-million<\/strong> in rejected Schengen visa fees in 2024. Nigerians were hit particularly hard with more than 45% of applications made being rejected, followed by residents of Ghana who saw 44.5% of their applications rejected.<\/p>\n\n\n\n

Each Schengen visa application costs \u20ac90 (around R1,800) and is non-refundable.<\/p>\n\n\n\n

Data from the European Commission shows that there were 111,201 applications by Nigerians for Schengen visas in 2024, and only 58,808 of those were granted. That means that almost $5-million was spent (and lost) by Nigerians who had their visa applications turned down.<\/p>\n\n\n\n

South Africans fare a lot better than the rest of the continent when applying for visas. A relatively small 5.6% of the 193,768 visas applied for in 2024 were rejected. This still amounts to more than $1-million in lost fees (ZAR 19.7-million to be exact), even if it is a lot less than the rest of the continent.<\/p>\n\n\n\n

The average rejection rate for Schengen visas for all countries is 16.9% while the rejection rate for African applications is 27%.<\/p>\n\n\n\n

The ONE campaign did a deeper dive into the data in their excellent Aftershocks newsletter this morning<\/a> if you want more detail.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Poor performance<\/h2>\n\n\n\n

South Africa\u2019s eight big metropolitan municipalities serve nearly half of all the households in the country and have both the budget and capacity to hire skilled professionals, says Tsakani Maluleke, the Auditor-General of South Africa (AGSA).<\/p>\n\n\n\n

You\u2019d expect them to set the standard when it comes to spending their budgets effectively and keeping track of their finances. Alas, this is not the case, by the looks of the latest auditor-general\u2019s report.<\/p>\n\n\n\n

If you look at a map of the country, there are very few municipalities that are bright green \u2013 the colour of a good audit.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

And when it comes to the metros, Cape Town was the only one to get a clean audit.<\/p>\n\n\n\n

Johannesburg has been getting an \u201cunqualified with findings\u201d result for years now and seems unable to take the step into green. Ekurhuleni lost its clean status two audits ago and Tshwane clearly has work to do.<\/p>\n\n\n\n

In her report, Maluleke was blunt: metros are \u201cplagued by poor revenue management, debt collection and budgeting practices, coupled with financial losses due to poor-quality spending.\u201d<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We shouldn\u2019t really be surprised that the Gauteng metros are in a mess. Since the local government elections three and a half years ago, Johannesburg has had six mayor changes, and Tshwane has had four.<\/p>\n\n\n\n

With such instability in the leadership, it\u2019s little wonder that spending is of \u2018poor quality\u2019. The water crisis and potholes are evidence of that.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1387,1380],"tags":[],"newsletter-post":[],"site":[],"class_list":["post-90512","post","type-post","status-publish","format-standard","hentry","category-the-outlier","category-this-week-in-charts"],"acf":{"post_style":"bc","show_on_front":"Yes","link_through":"Yes","big_number":"","big_number_caption":"","big_number_link":"","big_number_background":"","big_number_text_colour":"#000000","big_number_icon":false,"big_number_wide":"yes","featured_chart":{"ID":90515,"id":90515,"title":"Visas","filename":"Visas.png","filesize":91147,"url":"https:\/\/outliereditor.co.za\/wp-content\/uploads\/2025\/06\/Visas.png","link":"https:\/\/outliereditor.co.za\/index.php\/2025\/06\/02\/this-week-in-charts-30-may-2025-african-visas-ai-african-markets\/visas\/","alt":"","author":"1","description":"","caption":"","name":"visas","status":"inherit","uploaded_to":90512,"date":"2025-06-02 09:41:47","modified":"2025-06-02 09:41:47","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/outliereditor.co.za\/wp-includes\/images\/media\/default.png","width":810,"height":810,"sizes":{"thumbnail":"https:\/\/outliereditor.co.za\/wp-content\/uploads\/2025\/06\/Visas-150x150.png","thumbnail-width":150,"thumbnail-height":150,"medium":"https:\/\/outliereditor.co.za\/wp-content\/uploads\/2025\/06\/Visas-400x400.png","medium-width":400,"medium-height":400,"medium_large":"https:\/\/outliereditor.co.za\/wp-content\/uploads\/2025\/06\/Visas-768x768.png","medium_large-width":768,"medium_large-height":768,"large":"https:\/\/outliereditor.co.za\/wp-content\/uploads\/2025\/06\/Visas.png","large-width":810,"large-height":810,"1536x1536":"https:\/\/outliereditor.co.za\/wp-content\/uploads\/2025\/06\/Visas.png","1536x1536-width":810,"1536x1536-height":810,"2048x2048":"https:\/\/outliereditor.co.za\/wp-content\/uploads\/2025\/06\/Visas.png","2048x2048-width":810,"2048x2048-height":810}},"flourish_chart_id":"","flourish_sub_title":"","flourish_chart_width":"medium","is_newsletter_post":"No","chart_url":"","background_colour":"#0089AA","text_colour":"#FFFFFF"},"_links":{"self":[{"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/posts\/90512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/comments?post=90512"}],"version-history":[{"count":3,"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/posts\/90512\/revisions"}],"predecessor-version":[{"id":90524,"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/posts\/90512\/revisions\/90524"}],"wp:attachment":[{"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/media?parent=90512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/categories?post=90512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/tags?post=90512"},{"taxonomy":"newsletter-post","embeddable":true,"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/newsletter-post?post=90512"},{"taxonomy":"site","embeddable":true,"href":"https:\/\/outliereditor.co.za\/index.php\/wp-json\/wp\/v2\/site?post=90512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}