From Data to Value — AI-Powered Data Literacy
Understanding, cleaning, interpreting and visualising data in Excel; AI-powered data analysis with a Copilot focus. A 6-module, 1-day hands-on workshop.
Duration
1 Day
Modules
6 Modules
Level
Beginner–Intermediate
Format
In-Class
What You Will Gain
Understanding the distinction
between data, information and insight; recognising data types and data quality dimensions
Working with tidy
data principles in Excel; detecting and cleaning dirty data (duplicates, inconsistent formats, an introduction to Power Query)
Interpreting data with
pivot tables and summary statistics; avoiding the correlation-causation trap
Performing AI-powered data
analysis with Copilot, ChatGPT, Claude and Gemini; verifying outputs and respecting corporate data red lines (KVKK)
Building a data
story with the right chart choices; enriching data and preparing an AI-supported 30-60-90 day personal data plan
Curriculum Roadmap
6 ModulesThe data-information-knowledge distinction (DIKW); data types; the data lifecycle in organisations; data quality dimensions; why data literacy matters in the AI era; a personal data inventory exercise.
Excel as the corporate world's de facto database; real cases (gene renaming, Reinhart-Rogoff); tidy data principles; dirty data types; the cleaning toolkit (filters, duplicates, text functions, an introduction to Power Query); a dirty dataset cleaning workshop.
Summary statistics literacy (mean vs median, distribution, outliers); Anscombe's quartet; pivot table logic; comparison, trend and share perspectives; correlation vs causation; answering business questions with pivots.
The AI tool map (Copilot in Excel in focus; ChatGPT, Claude, Gemini); data-analysis prompt patterns; a live Copilot demo; the output verification discipline; KVKK and corporate data red lines; a hands-on AI analysis round on your own device.
A chart-choice decision tree; the anatomy of a bad chart; Nightingale's rose diagram; rapid visualisation in Excel; creating and improving charts with AI; data enrichment with XLOOKUP/Power Query; a chart makeover workshop.
From insight to action; a one-page data report structure for executives; bringing together the day's red-thread dataset journey; the 30-60-90 day personal data plan; the commitment round.
Your Trainer
Serkan Sentuna
Trainer & Consultant & AI Architect
20+ years of training and development experience. 2,000+ professionals trained.