Portrait photo of Peter Flucher

Peter Flucher

Data Analyst — Power BI, SQL & Data Models · Graz

Understanding the connections means you can spot the problems — and change the technology.

I build data models that make connections visible — and translate between technology, people and theory.

Call me Email CV (PDF, German)

At a Glance

 Overview

Today

Two part-time roles, one craft: data models that business departments actually use.

Data Warehouse Specialist

Supernova Groupsince

Part-time, Graz (hybrid). Planning, building and running a data warehouse (Power BI / Fabric, SQL, Python).

Data Analyst

Neurothsince

Part-time, Graz. Building data models and reports from a marketing perspective (Power BI / Fabric, SQL, Python) — and translating between business and technology.

 Overview

Eight Years at XAL

How does a systems analyst end up planning the company’s data model? Station by station.

Systems Analyst — Product Engineering & Product Management

XAL GmbH, Graz (lighting industry) –

  • Led the Power BI committee (2022/23): planned a new data-warehouse architecture on the Microsoft stack — two ERP systems, PIM and SharePoint as sources; models and reports in Excel and Power BI (SQL, SSAS); coordination of DWH changes via Azure DevOps.
  • Project lead for the introduction of the new EU energy labels (2020–2022).
  • Product owner of the in-house PIM (2016–2023; Django/Python/PostgreSQL; backend of the product website with more than 10,000 products).
  • Built and rolled out many small tools — Excel, Power BI, Power Automate, Power Apps, SharePoint, SmartSheet; and analogue: pin boards, cards, flip charts.
  • Organisational development of new roles and processes in product development (2016–2018).
 Overview

The Start-up

A year on my own account — and the fastest school I ever attended.

Founder

Forgetit.io –

Built a time-management app. An intense year in the start-up community — lean startup, agile, Kickstarter, social media. Grew out of the University of Graz start-up garage.

 Overview

Education

Project management first, then seven years at the University of Graz — business studies, sociology, start-up garage — and finally teaching others.

University

University of Graz2008 – 2015

Business studies, sociology, start-up garage.

Getting in came first: the university entrance exam 2008 – 2010, taken without a school-leaving certificate. Then three semesters of business studies (2010 – 2011, 45 ECTS) and the move to sociology (2011 – 2014, exams worth 168 ECTS, without a final thesis). Last the Gründungsgarage at the Institute of Corporate Leadership and Entrepreneurship (2014 – 2015), where the iOS app “Forget it!” took shape — which became the founding of Forgetit.io in 2015.

Generalist Project Manager

Activity2006 – 2007

Two-semester programme of 1,175 hours.

Systemic project management, NLP, plus basics in accounting, controlling, labour law and coaching.

Certificates

  • Certified Apprenticeship Trainer WIFI Styria, 2022
  • Professional Scrum Master I Scrum.org, 2015
  • IPMA Level D Activity, 2007
  • NLP Practitioner Activity, 2007
  • Paramedic Jägerbataillon 25, 2003

School

BORG Hasnerplatz1998 – 2002

MHS Ferdinandeum1994 – 1998

Engelsdorf Primary School1989 – 1994

Upper school in the computer science branch, before that a music middle school.

 Overview

Skills

Stars are claims. That is why every rating comes with its source — and below it the same thing counted in hours.

Data & Analysis

Power BI, SQL & data models

Daily since 2016: star schemas, DAX, SSAS models, report design — at XAL, Neuroth and Supernova.

Data visualisation

My own Power BI visual, ggpbi: the grammar of graphics in TypeScript and D3 — geoms, scales and facets, with no R or Python runtime. Read the full piece

I ported the same core to Elm as well.

Statistics

Development & AI

Python, Django & SQL backends

AI in everyday work

Working with People

Project management

From film sets via IPMA and Scrum to the EU energy labels: part of every station since 2003.

Organisation & leadership

Scrum & agile methods

Storytelling

Marketing & start-up

Languages

German native

English business fluent

French basic

Line chart: cumulative hours per skill from 1994 to 2026, nine coloured curves and a dashed line at 10,000 hours that two curves cross
The same skills, calculated rather than claimed: an hour of learning counts as two hours of practice. Exactly two curves cross the line at 10,000 — the two with five stars. Drawn with ggpbi.
 Overview

Film (2003 – 2008)

Before data came film: five years in production, unit management and art department — project management under real-time conditions.  Filmography on Crew United

Production & Unit Management

Production Assistant

“Menschen & Mächte: Erzherzog Johann” — documentary, ORF; RAN-Film01 – 06/2008

Production Assistant

“Erlebnis Österreich: Der Schöckel” — documentary, ORF; RAN-Film09 – 12/2007

Director, Writer & Editor

“Zwischen-Pass” — my own short film06 – 09/2006

Assistant Unit Manager

“Oneline Life: Play Hard Go Pro” — documentary

Set Unit Manager & Art Department

“Jenseits” — feature film06 – 07/2005

Assistant Unit Manager

“Shiver: Stehst Du still” — music video

Assistant Unit Manager

“Wie Schnee hinter Glas” — short film

Art Department & Props

Set Props

“Oben Ohne” — TV series, ORF; Star*Film

Set Props

“Novotny & Maroudi” — TV series, ORF08 – 09/2005

Set Decorator

“Heile Welt” — short film

Art-Department Internship, then Set Props

“8x45: Bis in den Tod” — TV series, ORF01 – 03/2005

Props Assistant (internship)

“In einem anderen Leben” — TV movie, BR12/2003 – 01/2004

 Overview

Interests

What I think about when nobody sets a deadline.

AI — private & everywhere

Deep into AI since 2023, professionally and privately — from prompting to the question of what the models are doing to our work.

Systems Theory

Gareis’ “Happy Projects!” kicked off my interest in systems theory. It was also the decisive reason to enrol in business studies — and later to switch to sociology.

 All 177 books

Actor-Network Theory

ANT is a sociological approach that describes how actors — human and non-human — are connected and influence each other.

 ANT on Wikipedia

Far-Eastern Theories

“The Web That Has No Weaver” showed me a lot about the holistic thinking of Asian theories. TCM and feng shui work fine without our cause-and-effect thinking.

Making Data Visible

My CV as a data model: timeline, competence curves, an interest budget — computed instead of claimed.

 The curves

Getting Things Done

GTD is a productivity technique by David Allen that turns chaos into orderly lists.

Hiking in the mountains with children

Hiking

Chess

  1. e2–e4 e7–e5
  2. f2–f4
 Overview

What I read

I am not what I read. But what someone reads says a lot about them.

So I tried to reconstruct which books shaped me — 207 works, print and audio, since school. And then asked the question that only comes up once both lie side by side: what gave the most for its pages?

THICK & POWERFULTHIN & POWERFULTHICK & QUIETTHIN & QUIETMixing Humans and Nonhumans Together: The Sociology of a Door-Closer — Bruno Latour — read 2011Doing Gender — Candace West, Don H. Zimmerman — read 2012Die Gemütsruhe — Lucius Annaeus Seneca — read 2023Ein glückliches Leben — Lucius Annaeus Seneca — read 2023Die Kürze des Lebens — Lucius Annaeus Seneca — read 2023Die Kunst, sich selbst zu managen — Peter F. Drucker — read 2022Poetik — Aristoteles — read 2000Vom dreifachen Gebrauch des Messers — David Mamet — read 2001Die Kunst der Filmregie — David Mamet — read 2001Die Kunst des Krieges. Der Klassiker der Konfliktstrategie — Sun Tzu — read 2023Die fünf entscheidenden Fragen des Managements — Peter F. Drucker — read 2022Anleitung zum Unglücklichsein — Paul Watzlawick — read 2006Philosophie der Stoa — Epiktet — read 2023Rebalancing Society — Henry Mintzberg — read 2018Der Fürst — Niccolò Machiavelli — read 2023Wie wir uns erfinden. Eine Autobiographie des radikalen Konstruktivismus — Heinz von Foerster, Ernst von Glasersfeld — read 2006Wahrheit ist die Erfindung eines Lügners — Heinz von Foerster, Bernhard Pörksen — read 2006Archetypen — C. G. Jung — read 1999Einführung in den Konstruktivismus — Heinz von Foerster, Ernst von Glasersfeld, Peter M. Hejl — read 2006Zhang Yimou und Wong Kar-Wai — Josef Schnelle, Rüdiger Suchsland — read 1997Grundkurs Filmanalyse — Werner Faulstich — read 2013Bedtime Stories for Managers — Henry Mintzberg — read 2018Die Kunst des professionellen Schreibens — Howard S. Becker — read 2011Das Verschwinden der Kindheit — Neil Postman — read 2014The Obstacle Is the Way — Ryan Holiday — read 2022Ego Is the Enemy — Ryan Holiday — read 2022Joel & Ethan Coen — Peter Körte, Georg Seeßlen — read 1997Quentin Tarantino — Robert Fischer, Peter Körte, Georg Seeßlen — read 1997Das Design der Gesellschaft — Stephan Moebius, Sophia Prinz — read 2015Beratung ohne Ratschlag — Sonja Radatz — read around 2018Abenteuer Change Management — Manfred Höfler — read around 2015Filme schreiben — Syd Field — read 2002Selbstbetrachtungen — Marc Aurel — read 2023(Fast) Alles einfach erklärt — Niklas Kolorz — read around 2019Scrum: The Art of Doing Twice the Work in Half the Time — Jeff Sutherland, J. J. Sutherland — read 2014Getting Things Done — David Allen — read 2009Stillness Is the Key — Ryan Holiday — read 2023Parenting with a Story — Paul Smith — read 2016Drehbuchschreiben — Syd Field — read 2002Der Baum der Erkenntnis — Humberto R. Maturana, Francisco J. Varela — read 2006Der Witz und seine Beziehung zum Unbewußten — Sigmund Freud — read 2002Roman eines Schicksallosen — Imre Kertész — read 2005Lead with a Story — Paul Smith — read 2016David Lynch und seine Filme — Georg Seeßlen — read 1997Mein letzter Seufzer — Luis Buñuel — read 1999Die große Verführung — Robert Levine — read 1999Deep Work — Cal Newport — read 2022Reassembling the Social — Bruno Latour — read 2012Managing — Henry Mintzberg — read 2018Urban Assemblages — Ignacio Farías, Thomas Bender — read 2015The Mind Map Book — Tony Buzan, Barry Buzan — read 2009Statistik — Günter Bamberg, Franz Baur, Michael Krapp — read 2010The Leader's Guide to Radical Management — Stephen Denning — read 2015The Lean Startup — Eric Ries — read 2014The Leader's Guide to Storytelling — Stephen Denning — read 2015Stanley Kubrick und seine Filme — Georg Seeßlen — read 1997Käuferverhalten — Foscht, Swoboda — read 2010The Essential Drucker — Peter F. Drucker — read 2022The Power of Habit — Charles Duhigg — read 2022Art Worlds — Howard S. Becker — read 2014Elon Musk — Ashlee Vance — read 2022Learn You a Haskell for Great Good! — Miran Lipovača — read 2020Kinder brauchen Märchen — Bruno Bettelheim — read 200412 Rules for Life — Jordan B. Peterson — read 2022Das Prinzip Verantwortung — Hans Jonas — read 2012Mintzberg on Management — Henry Mintzberg — read 2018Story — Robert McKee — read 2002Thinking, Fast and Slow — Daniel Kahneman — read June 2026The Signal and the Noise — Nate Silver — read 2025Das große Buch der chinesischen Medizin — Ted J. Kaptchuk — read 2002The Tragedy of Great Power Politics — John J. Mearsheimer — read 2011Maps of Meaning — Jordan B. Peterson — read 2022Happy Projects! — Roland Gareis — read 2006Benjamin Franklin: An American Life — Walter Isaacson — read 2022Grundlagen des Managements — Schreyögg, Koch — read 2010Die Traumdeutung — Sigmund Freud — read 2005Steve Jobs — Walter Isaacson — read 2022Einstein — Walter Isaacson — read 2022The Grammar of Graphics — Leland Wilkinson — read 2018Projektmanagement — Gerold Patzak, Günter Rattay — read 2006Einführung in die Allgemeine Betriebswirtschaftslehre — Günter Wöhe, Ulrich Döring — read 2010Soziologie — Anthony Giddens, Christian Fleck, Marianne Egger de Campo — read 2011Krieg und Frieden — Leo Tolstoi — read 2022Krieg und FriedenMixing Humans and Nonhumans Toge…SelbstbetrachtungenDas große Buch der chinesischen…ManagingWie wir uns erfinden. Eine Autob…Der Witz und seine Beziehung zum…Die TraumdeutungDer Baum der ErkenntnisWahrheit ist die Erfindung eines…Art WorldsDie Kunst des professionellen Sc…Reassembling the SocialStoryDas Verschwinden der KindheitthickthinLength →lowhighImportance →
  • Sociology
  • Philosophy & Stoicism
  • Management
  • Film & screenwriting
  • Systems thinking
  • Psychology
  • Data & technology
  • Literature & biography
83 books: horizontally thick to thin, vertically unimportant to important, colour is the genre. Top right are the stars — much effect for few pages. Drawn with ggpbi. The page counts are estimates.
200020052010201520202025Mixing Humans and Nonhumans Together: The Sociology of a Door-Closer — Bruno Latour — read 2011Doing Gender — Candace West, Don H. Zimmerman — read 2012Die Gemütsruhe — Lucius Annaeus Seneca — read 2023Ein glückliches Leben — Lucius Annaeus Seneca — read 2023Die Kürze des Lebens — Lucius Annaeus Seneca — read 2023Die Kunst, sich selbst zu managen — Peter F. Drucker — read 2022Poetik — Aristoteles — read 2000Vom dreifachen Gebrauch des Messers — David Mamet — read 2001Die Kunst der Filmregie — David Mamet — read 2001Die Kunst des Krieges. Der Klassiker der Konfliktstrategie — Sun Tzu — read 2023Die fünf entscheidenden Fragen des Managements — Peter F. Drucker — read 2022Anleitung zum Unglücklichsein — Paul Watzlawick — read 2006Philosophie der Stoa — Epiktet — read 2023Rebalancing Society — Henry Mintzberg — read 2018Der Fürst — Niccolò Machiavelli — read 2023Wie wir uns erfinden. Eine Autobiographie des radikalen Konstruktivismus — Heinz von Foerster, Ernst von Glasersfeld — read 2006Wahrheit ist die Erfindung eines Lügners — Heinz von Foerster, Bernhard Pörksen — read 2006Archetypen — C. G. Jung — read 1999Einführung in den Konstruktivismus — Heinz von Foerster, Ernst von Glasersfeld, Peter M. Hejl — read 2006Zhang Yimou und Wong Kar-Wai — Josef Schnelle, Rüdiger Suchsland — read 1997Grundkurs Filmanalyse — Werner Faulstich — read 2013Bedtime Stories for Managers — Henry Mintzberg — read 2018Die Kunst des professionellen Schreibens — Howard S. Becker — read 2011Das Verschwinden der Kindheit — Neil Postman — read 2014The Obstacle Is the Way — Ryan Holiday — read 2022Ego Is the Enemy — Ryan Holiday — read 2022Joel & Ethan Coen — Peter Körte, Georg Seeßlen — read 1997Quentin Tarantino — Robert Fischer, Peter Körte, Georg Seeßlen — read 1997Das Design der Gesellschaft — Stephan Moebius, Sophia Prinz — read 2015Beratung ohne Ratschlag — Sonja Radatz — read around 2018Abenteuer Change Management — Manfred Höfler — read around 2015Filme schreiben — Syd Field — read 2002Selbstbetrachtungen — Marc Aurel — read 2023(Fast) Alles einfach erklärt — Niklas Kolorz — read around 2019Scrum: The Art of Doing Twice the Work in Half the Time — Jeff Sutherland, J. J. Sutherland — read 2014Getting Things Done — David Allen — read 2009Stillness Is the Key — Ryan Holiday — read 2023Parenting with a Story — Paul Smith — read 2016Drehbuchschreiben — Syd Field — read 2002Der Baum der Erkenntnis — Humberto R. Maturana, Francisco J. Varela — read 2006Der Witz und seine Beziehung zum Unbewußten — Sigmund Freud — read 2002Roman eines Schicksallosen — Imre Kertész — read 2005Lead with a Story — Paul Smith — read 2016David Lynch und seine Filme — Georg Seeßlen — read 1997Mein letzter Seufzer — Luis Buñuel — read 1999Die große Verführung — Robert Levine — read 1999Deep Work — Cal Newport — read 2022Reassembling the Social — Bruno Latour — read 2012Managing — Henry Mintzberg — read 2018Urban Assemblages — Ignacio Farías, Thomas Bender — read 2015The Mind Map Book — Tony Buzan, Barry Buzan — read 2009Statistik — Günter Bamberg, Franz Baur, Michael Krapp — read 2010The Leader's Guide to Radical Management — Stephen Denning — read 2015The Lean Startup — Eric Ries — read 2014The Leader's Guide to Storytelling — Stephen Denning — read 2015Stanley Kubrick und seine Filme — Georg Seeßlen — read 1997Käuferverhalten — Foscht, Swoboda — read 2010The Essential Drucker — Peter F. Drucker — read 2022The Power of Habit — Charles Duhigg — read 2022Art Worlds — Howard S. Becker — read 2014Elon Musk — Ashlee Vance — read 2022Learn You a Haskell for Great Good! — Miran Lipovača — read 2020Kinder brauchen Märchen — Bruno Bettelheim — read 200412 Rules for Life — Jordan B. Peterson — read 2022Das Prinzip Verantwortung — Hans Jonas — read 2012Mintzberg on Management — Henry Mintzberg — read 2018Story — Robert McKee — read 2002Thinking, Fast and Slow — Daniel Kahneman — read June 2026The Signal and the Noise — Nate Silver — read 2025Das große Buch der chinesischen Medizin — Ted J. Kaptchuk — read 2002The Tragedy of Great Power Politics — John J. Mearsheimer — read 2011Maps of Meaning — Jordan B. Peterson — read 2022Happy Projects! — Roland Gareis — read 2006Benjamin Franklin: An American Life — Walter Isaacson — read 2022Grundlagen des Managements — Schreyögg, Koch — read 2010Die Traumdeutung — Sigmund Freud — read 2005Steve Jobs — Walter Isaacson — read 2022Einstein — Walter Isaacson — read 2022The Grammar of Graphics — Leland Wilkinson — read 2018Projektmanagement — Gerold Patzak, Günter Rattay — read 2006Einführung in die Allgemeine Betriebswirtschaftslehre — Günter Wöhe, Ulrich Döring — read 2010Soziologie — Anthony Giddens, Christian Fleck, Marianne Egger de Campo — read 2011Krieg und Frieden — Leo Tolstoi — read 2022Krieg und FriedenMixing Humans and Nonhumans…SelbstbetrachtungenDas große Buch der chinesisc…ManagingWie wir uns erfinden. Eine A…Der Witz und seine Beziehung…Die TraumdeutungDer Baum der ErkenntnisWahrheit ist die Erfindung e…Art WorldsDie Kunst des professionelle…Reassembling the SocialStoryDas Verschwinden der KindheitYear read →lowhighImportance →
The same books, horizontally the year instead of the thickness: screenwriting before 2003, constructivism around 2010, Stoicism after 2020. 75 of the 83 years are estimates.

Impact is a ranking from conversation, not a measurement — and which skill a book feeds is an estimate. Both are marked as such in the source data; the complete model is at lebenslauf.json.

 Overview

Projects

What gets built when nobody sets a deadline.

ggpbi logo

ggpbi — Grammar of Graphics for Power BI

My own open-source project · TypeScript & D3 · MIT licence · github.com/efelcie/ggpbi · Last updated

Power BI ships a fixed list of chart types. Anyone who needs something else reaches for an R or Python visual — those need an installed runtime and end up delivering an image: no cross-filtering, no native tooltips.

ggpbi takes the other route. It brings the grammar of ggplot2 to Power BI — fields map to aesthetics, geoms stack as layers — but as a native TypeScript/D3 visual. No runtime, no R, no Python. It renders as fast as any built-in visual and works in the Power BI Service.

Screenshot of Power BI Desktop: three ggpbi visuals on the iris data set — scatter plot, density curves per species and box plots — in one report
Three ggpbi visuals in one report, on the iris data set: scatter plot, density curves per species, box plots. Cross-filtering and tooltips like any built-in visual — no R, no Python, no runtime.

A report like this is built by dropping fields into wells; the Format Pane writes the ggpbi chain from them. And the other way round: since version 0.5 the code view is a real editor, with an optional vim mode. What you change there writes back into the Format Pane — editor and pane are two doors into the same room. The editor speaks three languages: the ggpbi chain, ggplot2 in R, and ggpbir, the report’s JSON format.

And outside Power BI

ggpbi is an ES module with D3 underneath — Power BI is one of the places it runs, not the only one. Both charts on this page are drawn with it: the hours up in the skills section and the book matrix. And really with it — the code below is exactly what draws them, not a simplified example. The library is only fetched once the page is up; until then an SVG stands there, and it stays if anything goes wrong. 

ggpbi()                       // the hours
  .data(hours)                // 2 x learning + practice
  .aes({ x: 'Jahr', y: 'Gewichtet',
         color: 'Skills' })
  .geom('hline', { yintercept: 10000,
                   linetype: 'dashed' })
  .geom('line', { size: 2 })
  .size(640, 400)
  .renderTo(element);
ggpbi()                       // the books
  .data(books)
  .aes({ x: 'Umfang', y: 'Wirkung',
         color: 'Genre', label: 'Titelkurz' })
  .scale({ x: { labels: () => '' },
           y: { labels: () => '' } })   // no ticks
  .geom('point', { size: 4, alpha: 0.72 })
  .tooltip({ fields: ['Titel','Autor','Gelesen'] })
  .geom('text', { repel: true, size: 10 })
  .geom('vline', { xintercept: middle })
  .renderTo(element);
Two charts, the same chain. ggpbi drops empty labels — which is why only the fifteen most important books carry a title, and repel pushes them apart until none covers another.

What’s in it

Geoms: point, line, bar, col, area, text, boxplot, violin, histogram, density, smooth (lm, loess, moving average), segment, pointrange, plus the reference lines hline, vline and abline.

Grammar: aesthetics (x, y, color, fill, size, shape, alpha, group, label), positions (identity, stack, dodge, fill, jitter), scales (linear, log, sqrt, time, category) with locale-aware number and date formats, faceting by row and column, and gghighlight-style highlighting.

Power BI native: cross-filtering by click, native tooltips, context menu, report themes, high-contrast mode and style presets.

Two fields are enough to start: one in X, one in Y. ggpbi picks the geom from the scale types — number and number give a scatter plot, category and number a bar chart, date and number a line, a number on its own a histogram.

Status: version 0.5.0 — about 16,000 lines of TypeScript across 51 modules, 67 test files. Not on AppSource yet; it installs by file import in Power BI Desktop.

I ported the same core — scales, axes, label engine — to Elm, to see what survives of the grammar when the compiler flags every gap. The chart above is the TypeScript version.

Contact

Scrolled all the way down? Then we should talk.

+43 664 5057058 mail@peter.flucher.name LinkedIn GitHub

Personal Information

Date of birth

Based in 8073 Feldkirchen bei Graz

Country Austria

Contact

Email mail@peter.flucher.name

Phone +43 664 5057058

Website peter.flucher.name

Online

LinkedIn

github.com/efelcie