NewData Canvas: turn any spreadsheet into a dashboard, free

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.

Get in touch Explore free guides

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.

Try Data Canvas free Play with a sample

Data Canvas showing a retail sales dashboard with revenue, units, discount and price figures and a revenue trend chart

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.

Good decisions need good data. Good data needs structure, tests and automation. That is what I build.

Everything your data needs. Nothing it doesn't.

Analytics engineering that turns raw data into numbers you can trust, delivered automatically.

Analytics engineering

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.

Dashboards and BI

See it all at a glance.

Power BI dashboards designed around the decisions you make, refreshed automatically.

Reporting automation

Reports that build themselves.

Python and Google Apps Script automations that collect, clean and send data on schedule, with checks that catch errors first.

Data analysis

Answers, not just numbers.

Which products, customers and channels really drive profit, what the trends say, and what to do next.

Websites

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 conversation

Clean code.
Clear results.

The same craft behind every project: readable SQL, tested Python and modern Swift. Pick a language to see it run.

top_customers.sql

Simple from start to finish.

A clear process with no surprises.

Discover

Talk through the decisions to be made, the questions that can't be answered yet, and the data already available.

Build

Model, test, automate and visualise the data step by step, with regular check-ins along the way.

Hand over

Document everything and explain it in plain language, so the team can run it with confidence.

The toolkit.

Proven tools, chosen to fit what organisations already run on.

SQLPythonpandasdbtSnowflakePower BIDAXPower QueryDuckDBPostgreSQLExcelGoogle SheetsApps ScriptGitGitHub ActionsSwiftSwiftUIScriptableJinjaYAMLSQLPythonpandasdbtSnowflakePower BIDAXPower QueryDuckDBPostgreSQLExcelGoogle SheetsApps ScriptGitGitHub ActionsSwiftSwiftUIScriptableJinjaYAML

Data modellingStar schemasData qualityETL and ELTAutomationDashboardsTime intelligenceWindow functionsAPIsJSONCI/CDDocumentationCybersecuritySEOWeb designData modellingStar schemasData qualityETL and ELTAutomationDashboardsTime intelligenceWindow functionsAPIsJSONCI/CDDocumentationCybersecuritySEOWeb design

Built, 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

About me.

Technical depth, business sense, and a habit of explaining things clearly.

Hi, I'm Alessandro.

I'm an analytics engineer and data scientist with over seven years' experience across big tech, media, consulting and financial services. Originally from Italy, I'm now based in London. I've been helping organisations turn scattered data into reliable, automated reporting, and I'm happiest when a process that used to take hours runs quietly on its own.

I hold an MSc in Cyber Security with Distinction and a BSc in Data Science, so I build with care: secure, tested and documented. I work in English, Italian, Spanish and French, and I share what I learn in free guides and cheat sheets.

Request my full CV LinkedIn

CV highlights

Experience

Data, analytics and automation, Big Tech companyLondon, 2025 to present. AI assistant integrations, a unified analytics tool in Swift and Python, automated data pipelines and executive reporting that went from hours to minutes.
Analytics Manager, leading media and entertainment companyLondon, 2023 to 2025. Forecasting models, automated dashboards in SQL, Python, Tableau and Power BI on GCP and Adobe Analytics data, A/B testing, and mentoring a graduate analyst.
AI and Data Consultant, Big Four professional services firmLondon, 2022 to 2023. ETL for internal staffing decisions, a finance dashboard that sped up an automotive client's supply chain decisions by 35%, and data work for healthcare and infrastructure clients.
Data Scientist, leading UK wealth management firm2020 to 2022. BI dashboards for finance, investment and marketing teams, a Snowflake schema built from scratch, and Python and Power Automate bots.
Commercial Analyst, Fortune 500 electronics distributorItaly and UK, 2018 to 2019. Market analysis for EMEA strategy and supplier coordination.

Education

MSc Cyber Security and Human Factors, DistinctionBournemouth University, 2018 to 2020. Thesis on GDPR and e-learning platforms.
BSc Data ScienceUniversity of Gloucestershire, 2022 to 2023.
BA Foreign and International LanguagesUniversity in Italy, 2014 to 2018.

Skills

Python, SQL, Swift and SwiftUI, C++. Snowflake, MS SQL Server, Matillion, Pentaho. Power BI and DAX, Tableau. AWS, Microsoft Azure, Google Cloud. Data modelling, ETL, forecasting, A/B testing, reporting automation, Git.

Certifications

AWS Certified Cloud Practitioner
Microsoft Certified: Azure Data Fundamentals
Dataiku MLOps Practitioner
Machine Learning Engineering for Production (MLOps), DeepLearning.AI
Business Analytics: From Data to Decision, Imperial College Business School
SQL for Data Science, University of California, Davis
Using Python to Interact with the Operating System, Google

Published research

Languages

Italian (native), English (fluent), Spanish (advanced), French (basic).

The Git commands data teams actually use, on one printable page.

Open and save as PDF

New: 60 levels

Data Puzzles.

Thirty SQL and thirty Python challenges, from first SELECT to wizard level. Earn stars, unlock tiers, and meet Quack Overflow, the rubber duck who gives hints.

Start playing

Job hunting?

Interview prep.

Real analytics engineer and data analyst interview questions with model answers, flip flashcards, a quiz and a 7-day game plan.

Start preparing

Latest guides and news.

What's changing in data, and how to do things properly.

What'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

What's new, 7 min

What'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

Guide, 9 min

SQL window functions, explained

The single most useful SQL skill after joins. Rankings, running totals and period-over-period comparisons, without self-joins.

SQLDatabases

Guide, 12 min

Your first dbt project, step by step

How analytics engineers turn SQL scripts into tested, documented, version-controlled pipelines.

dbtSQLData modelling

Guide, 11 min

Getting started with Snowflake

The concepts that make Snowflake different, and the SQL you need on day one.

SnowflakeSQLDatabases

Guide, 10 min

Star schema data modelling

The data model behind fast, trustworthy dashboards. Facts, dimensions and the one decision that matters most: grain.

Data modellingSQLPower BI

Browse all 23 resources

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.

Email me

alessandro@ecclesieagazzi.com
Based in the UK and Italy. Open to remote work across Europe and beyond.

Analytics,engineered.