import pandas as pddf = pd.read_excel('data.xlsx')df.groupby('region').sum()model.fit(X_train, y_train)import numpy as npplt.plot(forecast)df.dropna(inplace=True)from sklearn import metricsprint(df.describe())np.mean(returns) * 252
Home

Luminex Blog

Data. Decoded.

Playbooks, checklists and guides — everything we know about turning data into decisions.

Scroll Down

Playbooks · Guides

Our Work, Written Down

01 — Data Science

Data Science & Applied ML Playbook

Taking a model from experiment to production — features, tuning, explainability, drift detection and real-time serving.

Read Download
Data Science & Applied ML Playbook original guide cover
02 — Data Engineering

Data Cleaning & Preparation Playbook

8 patterns for cleaning dirty, missing and duplicated data across lakehouses and live pipelines.

Read Download
Data Cleaning & Preparation Playbook original guide cover
03 — Analytics

Data Analytics & Architecture Cheat Sheets

8 advanced analytics topics, the key rules we follow and a system diagram for each.

Read Download
Data Analytics & Architecture Cheat Sheets original guide cover
04 — Architecture

Data & Analytics Architectural Playbook

8 production design patterns — SQL query engines, index optimisation and more, with diagrams.

Read Download
Data & Analytics Architectural Playbook original guide cover
05 — Finance

Designing a P&L Dashboard Executives Actually Read

A masterclass in financial clarity — what to show leaders so they can decide fast.

Read Download
Designing a P&L Dashboard Executives Actually Read original guide cover
06 — Automation

Automating Monthly PDF Reports with pandas + ReportLab

Build, style, schedule and send your monthly reports automatically with Python.

Read Download
Automating Monthly PDF Reports with pandas + ReportLab original guide cover
07 — Data Cleaning

The Reproducible CSV Cleaning Checklist

A step-by-step framework to turn messy CSV files into analysis-ready data.

Read Download
The Reproducible CSV Cleaning Checklist original guide cover
08 — Strategy

From Metrics to Decisions: The KPI Ladder Framework

How raw data climbs into metrics, KPIs and finally real business decisions.

Read Download
From Metrics to Decisions: The KPI Ladder Framework original guide cover
09 — Google Sheets

ArrayFormula + Query: The Duo That Replaces 90% of Macros

Powerful Google Sheets automation without writing scripts or macros.

Read Download
ArrayFormula + Query: The Duo That Replaces 90% of Macros original guide cover
10 — Dashboard Design

Information Density Without Information Overload

Show the right amount of information, at the right level, at the right time.

Read Download
Information Density Without Information Overload original guide cover
11 — Excel

10 Power Query Patterns Every Analyst Should Know

Ten core Power Query patterns with visuals, examples and common mistakes.

Read Download
10 Power Query Patterns Every Analyst Should Know original guide cover
12 — Python & SQL

Advanced Python & SQL Script Suite

Ready-to-run Python and SQL code for 8 patterns, including CUPED A/B testing.

Read Download
Advanced Python & SQL Script Suite original guide cover