Developer Builds Interactive Excel Dashboard to Analyse Jumia E-commerce Data

·2 views

A developer has created an interactive Excel dashboard using transactional data from Jumia, one of Africa's largest e-commerce platforms. The project involved cleaning raw data by removing duplicates, fixing inconsistencies, and handling missing values before analysis. Excel functions such as IF, AND, AVERAGE, COUNTA, MIN, and MAX were used to categorise prices, discounts, ratings, and calculate key metrics. Pivot tables, charts, and slicers were incorporated to enable dynamic filtering and visual data exploration. The analysis concluded that consistent product quality and customer value matter more to sales performance than high discounts or large review volumes alone.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Six-Week GPU Fix for Whisper.cpp on Arch Linux Was One Package All Along

A developer spent several weeks trying to enable Vulkan GPU acceleration for whisper.cpp on Arch Linux after noticing the app detected his GPU but processed audio on the CPU instead. The official whisper-cpp package had Vulkan support disabled, and a dedicated whisper-cpp-vulkan alternative had temporarily disappeared from both the official repos and AUR. He built a custom package from source, set up automated CI pipelines, and published his own solution before a Reddit commenter's suggestion led him to investigate further. While setting up llama.cpp separately, he discovered a package called ggml-vulkan listed on the llama.cpp Arch Wiki page — the actual fix, hidden because both apps share the same backend but are documented separately. The solution, pacman -S whisper-cpp ggml-vulkan, was never surfaced by search engines because the relevant documentation lived on a different project's wiki page.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Amparo lets users apply for food aid by voice, in any language, no reading needed

A developer built Amparo, a voice-driven web app that helps people apply for food assistance without reading or typing a single word. The tool asks questions aloud, accepts spoken answers in any language, and uses Google Gemini to extract structured data from natural, conversational responses. ElevenLabs provides the multilingual voice output, while a Flask backend and a simple HTML page keep the interface accessible. Users can correct any answer at any time, and the completed application is delivered as a ready-to-submit PDF. The project was created for the DEV Community Weekend Challenge: Generosity Edition, addressing the problem of billions in unclaimed aid due to language and literacy barriers.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Shopify's AI commerce category filter works on zero of 190 tested stores

A technical investigation tested the category filtering capability of Shopify's agent-commerce endpoint, introduced in 2026, across 190 live storefronts. Researchers sent structured search_catalog requests using valid taxonomy category IDs and an impossible category ID to determine whether the filter meaningfully narrowed product results. Of the 190 stores that responded, 186 ignored category filters entirely and returned full unfiltered product sets, while four rejected all queries and none filtered correctly. Notably, the price filter worked correctly on 150 of the same 190 stores, confirming the endpoint itself was functional and isolating the failure to category filtering specifically. The authors clarified this is not a criticism of Shopify, noting the UCP standard is new and schema inconsistencies are expected at this early stage.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Only 1.3% of Shopify Stores Block AI Crawlers, Study Finds

A scan of 10,099 Shopify storefronts conducted between August 29 and September 2, 2026, found that just 133 stores — about 1.32% — block at least one AI crawler via robots.txt or meta tags. Training-focused bots such as GPTBot and CCBot were the most commonly blocked, while crawlers that fetch live data during user queries, like OAI-SearchBot and PerplexityBot, were almost entirely unblocked. Only six stores block OAI-SearchBot, the crawler ChatGPT uses when shoppers search for products in real time. A notable pattern emerged where 28 stores shared an identical list of eight blocked crawlers, suggesting merchants are copying configurations rather than making independent decisions. The findings highlight that the vast majority of Shopify merchants are taking no active steps to restrict AI systems from accessing their product catalogues.

0 comments Read more at DEV Community