{"id":551,"date":"2026-10-26T17:04:28","date_gmt":"2026-10-26T16:04:28","guid":{"rendered":"https:\/\/erikagherardi.it\/lab\/training-dashboard\/"},"modified":"2026-10-26T17:35:26","modified_gmt":"2026-10-26T16:35:26","slug":"training-year-dashboard","status":"publish","type":"lab_project","link":"https:\/\/erikagherardi.it\/en\/lab\/training-year-dashboard\/","title":{"rendered":"Training dashboard"},"content":{"rendered":"

How it started<\/h2>\n

After a few months as a program manager, I wondered whether it was possible to understand how the training was really going without going crazy over Excel files.<\/p>\n

So I tried to build a system that analyses the Excel file of a single quarter, entirely locally, so as to have no network dependencies, and without relying on Claude or third parties, so as not to give access to confidential data.<\/p>\n

The first version was limited but very simple to use: you just dropped a report into the designated area and got back numbers and charts that are easy to read.<\/p>\n

How it grew<\/h2>\n

I used the charts from the first experiment to create a report for the client, who liked it very much. At that point I showed them the dashboard too, and we had several rounds of discussion to expand its features, adapting them to their specific needs.<\/p>\n

The latest version therefore lets you load all the files for the fiscal year to get a complete overview, with all the filters you need to get detailed, specific data when required. With so many new features, the interface was completely redesigned, to make it clearer to use.<\/p>\n

\n\"A<\/a>
Retailers quarter by quarter: the trend above, the exact numbers below. Retailers and figures are invented.<\/figcaption><\/figure>\n

What I learned<\/h2>\n

The traditional way of working \u2013 in this case Excel \u2013 can coexist with artificial intelligence that turns numbers and data into charts and trends that are easier to analyse.<\/p>\n

We are often held back by respect for the confidentiality and privacy of data, but AI can help us build systems that run locally without breaking agreements or regulations; you just have to start development from that basis instead of thinking about it when it is already too late.<\/p>\n","protected":false},"excerpt":{"rendered":"

A dashboard that turns the quarterly training reports into a picture of the whole year: attendance, trends and retailers, quarter by quarter. It started as curiosity and is still growing.<\/p>\n","protected":false},"featured_media":0,"template":"","project_status":[21],"project_type":[28],"class_list":["post-551","lab_project","type-lab_project","status-publish","hentry","project_status-ongoing","project_type-data"],"_links":{"self":[{"href":"https:\/\/erikagherardi.it\/en\/wp-json\/wp\/v2\/lab_project\/551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erikagherardi.it\/en\/wp-json\/wp\/v2\/lab_project"}],"about":[{"href":"https:\/\/erikagherardi.it\/en\/wp-json\/wp\/v2\/types\/lab_project"}],"version-history":[{"count":1,"href":"https:\/\/erikagherardi.it\/en\/wp-json\/wp\/v2\/lab_project\/551\/revisions"}],"predecessor-version":[{"id":567,"href":"https:\/\/erikagherardi.it\/en\/wp-json\/wp\/v2\/lab_project\/551\/revisions\/567"}],"wp:attachment":[{"href":"https:\/\/erikagherardi.it\/en\/wp-json\/wp\/v2\/media?parent=551"}],"wp:term":[{"taxonomy":"project_status","embeddable":true,"href":"https:\/\/erikagherardi.it\/en\/wp-json\/wp\/v2\/project_status?post=551"},{"taxonomy":"project_type","embeddable":true,"href":"https:\/\/erikagherardi.it\/en\/wp-json\/wp\/v2\/project_type?post=551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}