Excel Dashboard Built to Analyze Jumia E-commerce Product Performance

·3 views

A data analyst developed an interactive Excel dashboard to examine product performance on Jumia, a major e-commerce platform. The project began with a thorough data cleaning process that addressed missing values, duplicate entries, negative review counts, and inconsistent formatting to ensure reliable results. Since sales figures were unavailable, review counts were used as a substitute measure for customer engagement. The cleaned dataset was further enriched by calculating discounts, grouping products by price and rating tiers, and flagging incomplete records to support clearer comparisons. The project demonstrates how structured data preparation and visualization in Excel can generate actionable business insights even when source data is imperfect.

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)

7 Key Lessons for a Successful Odoo CRM Implementation in Real ERP Projects

Implementing Odoo CRM requires understanding an organisation's existing sales process before any configuration begins, rather than jumping straight into building pipeline stages. Experts recommend keeping the CRM pipeline simple and purposeful, as overly complex pipelines reduce user adoption among salespeople. Data migration deserves treatment as a separate project, since customer records spread across multiple platforms often carry duplicates, errors, and outdated entries that must be cleaned before import. Businesses are advised to fully explore Odoo's standard features before commissioning custom development, as unnecessary customisation adds long-term maintenance costs. These practical lessons, drawn from real ERP deployments, aim to help organisations avoid common pitfalls and achieve a more effective CRM rollout.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

12 API Security Best Practices Developers Should Treat as Non-Negotiable

APIs power modern software ecosystems but remain among the most frequently exploited attack surfaces in cybersecurity. Experts recommend adopting OAuth 2.0 with PKCE and OpenID Connect, enforcing multi-factor authentication, and issuing short-lived JWT tokens to secure API access. Fine-grained authorization checks at the object, function, and field levels are critical, as Broken Object Level Authorization consistently ranks as the top API vulnerability. Developers are also advised to apply least-privilege principles by minimizing token scopes and stripping unnecessary data fields from responses. Encrypting all traffic — using TLS 1.3 externally and mutual TLS between internal services — ensures no network hop is treated as inherently trusted.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why IoT Data Needs Device, Measurement, and Timestamp Defined Before Storage

Storing IoT sensor data effectively requires clarifying three core attributes before designing any schema: the source device, the measurement type, and the precise timestamp of observation. A raw value like 72.4 is meaningless without the context of what produced it, what physical quantity it represents, and when it was recorded. Engineers are advised to use a simple modeling worksheet per signal to surface gaps early, such as missing units or unclear time semantics. Collection frequency also matters, since signals like vibration and temperature differ in density and interpretive value. Timestamp ambiguity — whether it reflects when a sensor observed a condition or when a system received the message — should be resolved explicitly before any schema is written.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Moves Kubernetes App to AWS EKS Without Code Changes, Platform Hurdles Remain

A developer migrated a Node.js Kubernetes application from a home k3s server to Amazon EKS as a portability experiment, keeping the application code, container image, Helm chart, and Argo CD delivery pipeline entirely unchanged. The EKS control plane took under six minutes to provision, and once the delivery path was operational, Argo CD deployed two healthy replicas and self-corrected a manual scaling change within five seconds. However, three infrastructure assumptions had to be revisited: private endpoint access was needed for the worker node to reach the control plane, an AWS-specific load balancer values file was required for external traffic, and the originally planned t3.medium instance type was ineligible for the account, requiring a switch to a c7i-flex.large node. Terraform was used to provision only the minimal resources needed — one EKS 1.36 cluster, one worker node, and supporting networking components — deliberately limiting cost and scope for a short-term test. The experiment confirmed that the application and its delivery contract were portable across Kubernetes platforms, while also exposing cloud-specific infrastructure concerns absent in a home lab.

0 comments Read more at DEV Community