One source of truth for the whole business.
Shop, till, CRM and spreadsheets brought together into a clean, tested and documented model in Snowflake, SQL and Python, or right-sized tools for smaller teams.
NewMeet Data Canvas
Analytics,
Analytics engineer
Analytics,
engineered.
I turn scattered data into reliable models, automated reporting and dashboards people actually trust, and I share what I learn along the way.
New, free and private
Data Canvas.
Drop in any spreadsheet and get a presentation-ready dashboard in seconds. Smart charts, headlines written from your numbers, and slides ready for Keynote or PowerPoint.
Understands messy files
Finds the real header row, skips titles, totals and footnotes, and reads dates, money and percentages in any format.
Picks the right charts
Trends, rankings, shares, breakdowns and what changed, each with a headline like "Revenue up 18% year over year".
Ready for your slides
Copy any chart straight into Keynote or PowerPoint, download 4K slides, or present full screen from the browser.
Private by design
Your file is read in your browser and never uploaded. No sign-up, no AI, no tracking.
Everything your data needs. Nothing it doesn't.
Analytics engineering that turns raw data into numbers you can trust, delivered automatically.
See it all at a glance.
Power BI dashboards designed around the decisions you make, refreshed automatically.
Reports that build themselves.
Python and Google Apps Script automations that collect, clean and send data on schedule, with checks that catch errors first.
Answers, not just numbers.
Which products, customers and channels really drive profit, what the trends say, and what to do next.
A presence that performs.
Fast, secure websites with analytics built in from day one.
Careers
Analytics and engineering roles.
Have a question about analytics or data engineering? I'm always happy to talk it through, so start a conversation below.
Start a conversationBuilt, not just talked about.
Personal projects where I solve real problems end to end, from raw data to a polished interface.
Social media analytics engine
A personal analytics platform that turns raw Instagram data exports into a recency-weighted affinity score for every account, with a unified dashboard on iPhone. Built with no external database, using only Google Drive, Apps Script and Scriptable.
Google Apps ScriptJavaScriptScriptableData modelling
Live London transport widgets
A system of iOS home-screen widgets that plans journeys in real time from Transport for London's open data, showing the next best route, departures and disruption at a glance.
REST APIsJSONScriptableiOS widgets
Data Canvas
Drop in any CSV or Excel file and get a presentation-ready dashboard: it detects dates, measures and messy layouts, picks the right charts, writes headlines from the numbers and exports slides. Everything runs privately in the browser.
JavaScriptData parsingSVG chartsData visualisation
Try Data Canvas
This website and its Learn hub
Designed and built from scratch: a fast, secure static site with 23 guides and cheat sheets, structured data for search engines, search and filtering, and print-ready layouts.
HTMLCSSJavaScriptSEOPython build
Clean code.
Clear results.
The same craft behind every project: readable SQL, tested Python and modern Swift. Pick a language to see it run.
Learn and play.
Free guides, printable cheat sheets, 60 coding puzzles and interview prep. No sign-up, no paywall.
60 levels, SQL and Python
Data Puzzles.
From your first SELECT to wizard level. Earn stars, unlock tiers, and meet Quack Overflow, the rubber duck who gives hints.
Start playing 54 flashcards and a quizInterview prep.
Real analytics engineer and data analyst questions with model answers, a quiz with instant feedback, and a 7-day game plan.
Start preparingCheat sheets
All cheat sheetsSELECTSQLCheat sheetdf.Python and pandasCheat sheetCOPYSnowflake SQLCheat sheetf(x)DAXCheat sheetfuncSwiftCheat sheetgitGitCheat sheet
Latest guides
Browse all 23What's new, 9 min
The data stack in 2026
Fewer tools, more open formats and AI built into the platform. What has changed, and what it means for data teams.
Analytics engineeringSnowflakedbt
Guide, 9 minSQL window functions, explained
The single most useful SQL skill after joins. Rankings, running totals and period-over-period comparisons, without self-joins.
SQLDatabases
What's new, 7 minWhat's new in Python 3.14
The October 2025 release brought some of the biggest changes to Python in years. Here is what matters for data work.
PythonWhat's new
About me
Hi, I'm Alessandro.
An analytics engineer and data scientist with over seven years' experience across big tech, media, consulting and financial services. Originally from Italy and now based in London, I'm happiest when a process that used to take hours runs quietly on its own.
7+ years in dataMSc with Distinction4 languages7 certifications
Questions, answered.
What does an analytics engineer do?
An analytics engineer turns raw data from different systems into clean, tested and documented data models that dashboards, reports and data science can rely on, and automates the process so it refreshes on its own. Read the full guide.
How can I get in touch or find out more?
Use the Get in touch section at the bottom of this page, or connect with me on LinkedIn. I'm always happy to talk about data, analytics engineering and interesting projects. Get in touch.
How do I start learning SQL?
Start with SELECT, WHERE, ORDER BY and GROUP BY on a small dataset, then move on to joins and window functions. Practise a little every day rather than reading for hours: writing real queries is what makes it stick. Try the SQL puzzles and keep the SQL cheat sheet open.
Should I learn SQL or Python first?
For analytics, start with SQL: most business data lives in databases and warehouses, and SQL is asked in almost every data interview. Add Python next for automation, data cleaning and analysis that goes beyond what SQL does well. Start with the pandas for Excel users guide.
What's the difference between a data analyst, an analytics engineer and a data engineer?
A data engineer builds the infrastructure that moves data reliably. An analytics engineer shapes that data into clean, trustworthy models. A data analyst uses those models to answer business questions. In smaller teams, one person often does all three.
How do I prepare for an analytics engineer interview?
Revise SQL joins, aggregation and window functions, be ready to sketch a star schema, know the basics of dbt and a cloud warehouse, and prepare five STAR stories with real numbers. Use the interview prep flashcards and quiz.
Is Data Canvas really private?
Yes. Data Canvas reads your file inside your browser. Nothing is uploaded to a server, there is no sign-up and no tracking, so it is safe to use with confidential spreadsheets. Try Data Canvas.
Let's make your
data work.
Tell me about the report you rebuild every week, the data you can't trust, or the data project you're trying to achieve. I reply within two working days.
alessandro@ecclesieagazzi.com
Based in the UK and Italy. Open to remote work across Europe and beyond.