Pencil Analytics

Who we are

Pencil Analytics is an advisory and analytics firm founded by a team of experienced consultants with deep expertise in the private sector across Saudi Arabia. We specialize in transforming complex business data into clear, actionable insights, designing dashboards, predictive models, and decision systems that connect pricing, promotions, finance, and operations. Our approach combines analytical precision with business understanding to help organizations operate more efficiently, make smarter decisions, and drive sustainable profitability.

Vision

To continuously elevate the standard of business analytics and consulting by delivering distinguished, precise, and high-quality services that create a positive and measurable impact on business performance. We aim to empower our clients through innovative analytical solutions that enable them to achieve their goals more effectively and efficiently.

Mission

To provide integrated analytical and advisory solutions that simplify decision-making, enhance profitability, and strengthen execution across business functions. Through a blend of technical expertise, strategic insight, and automation, Pencil Analytics enables clients to convert data into strategic advantage, fostering a culture of efficiency, innovation, and sustainable growth.

Our Goals

We continuously strive to develop our capabilities and enhance our expertise to ensure operational excellence and efficiency. Our strategy is built on maintaining a high standard of quality that meets client expectations and drives long-term, sustainable success. At Pencil Analytics, we believe that “perfection is a moving target”, a constant pursuit that pushes us to innovate, refine, and deliver better results every day.

FMCG & Retail

In the FMCG and retail industry, we support companies in turning operational and commercial data into strategic advantage. Our expertise covers pricing, promotions, sales performance, supply chain analytics, and margin optimization, helping clients achieve full visibility across their value chain. Through dashboards, automation, and data-driven insights, we enable management teams to track execution, evaluate performance, and improve profitability , ensuring stronger alignment between strategy, operations, and market execution.

Dashboards

🛒Sales Dashboard▶
Track YTD/MTD/daily sales vs budget, targets, and last year , with margin and mix insights.
📈Price Elasticity Dashboard▶
Model price sensitivity and promotion effectiveness to forecast demand and revenue impact.
📦Volume Dashboard▶
Tiering shift analysis between this year and last year across products/channels to understand structural changes in sold volumes.
🎯Target Phasing▶
Support the business by assigning phasing and tracking progress on a daily, weekly, or monthly level.
🗂️Project Tracker▶
Seasonal dashboard tracker or a new-launch tracker with core KPIs (e.g., sales, margin, distribution, and more).
📍Inventory Dashboard▶
Support supply chain by monitoring availability in stores, overstock, slow/fast movers, ERP movements, days of sales for materials, fill-rate, OTIF, planning visibility, and average stock movement by segment.
🧾P&L Dashboard▶
Help relevant departments understand current and next month closing outlook considering aged stock, rebates, costs , consolidating the numbers into a single view (costing included).
📊Margin Analysis Dashboard▶
Evaluate gross profit across multiple verticals by blending P&L, price-mix effect, customer tiering, and promo performance , highlight where growth is occurring, by whom, and whether margin is organic.
🏷️Promotions Dashboard▶
A dedicated dashboard to manage and evaluate promotions at a detailed level (slots, mechanics, ROI, execution).
🤖ML Forecasting Output Dashboard▶
Visualize machine-learning predictions vs actuals with accuracy tracking and exception flags to guide intervention.
🛡️GRC Dashboard (Dumping & Near-Expiry)▶
Governance dashboard tracking dumping behavior and near-expiry goods with alerts and accountability metrics.
➕…and more▶
We tailor dashboards to emerging needs across sales, finance, trade marketing, and operations.

Whatever visibility your business needs , we’ll surface it.

Files that fuel & support the business

To fuel dashboards and streamline operations, we organize the flow of requests and make it easy to trace changes and approvals.

🧰Pricing Tools in Excel▶
Create structured pricing tools with validations and approval paths. Submissions are consolidated and visualized in dashboards , including the impact of approved prices on sales and margins.
📤Automation File Submission▶
Standardize file intake (e.g., price requests, listings, claims) with controlled templates that flow into the data model automatically.
🧩Macro-Enabled Files▶
Macro workflows for repetitive tasks (validation, formatting, enrichment) to reduce manual time and error.
🐍Python Steps for Consolidation▶
Automate consolidation of recurrent inputs (from teams or regions) and push clean tables to BI or ERP.
📝Data Entry Flow Automation▶
Reduce manual data entry by routing forms to the right owners; audit changes and maintain version history.

Automation

We automate the plumbing behind the scenes so teams can focus on decisions , not manual work.

🔄Refresh Pipelines▶
Scheduled data refresh, reconciliation checks, and error notifications.
✅Approval Routing & Audit Trails▶
Automated approval steps with full traceability and role-based controls.
📣Alerts & Exceptions▶
Notify owners when KPIs deviate or when data quality fails tolerance thresholds.
📡ERP/BI Publishing▶
Publish approved prices, assortments, or targets directly into ERP/Power BI with controls.
🗄️Centralized Storage & Versioning▶
Single source of truth with version control to protect integrity and speed up collaboration.

How we deliver

1. Discover
Map KPIs, data sources, and pain points.
2. Design
Solution blueprint & data model.
3. Build
Prototype dashboards/tools with real data.
4. Scale
Automate refresh, harden, secure, and train users.
5. Evaluate & Improve
Measure impact, iterate, and optimize continuously.

Reach Out to Us

We’d love to learn about your challenges and share how we can help.

Tip: Try clicking on the “Pencil Analytics” logo at the top for a different experience.
After all, discovering new perspectives , even in design , can lead to clearer insights and better decisions.
Imagine what we could achieve together when that same mindset is applied to your business.