Excel as a DBMS: table relationships, Inner/Left/Right Join with Power Query, and many-to-many data modeling.
Did you know you can use Excel as a true relational database? With Power Query and Power Pivot, Excel can handle table relationships, SQL-style joins and complex data models — without writing a single line of code. This course teaches you to think relationally and structure your data like a database.
You don't need to know SQL to follow this course — but by the end you'll understand joins like a database administrator. This fundamentally changes the way you think about data everywhere, not just in Excel.
Analysts, controllers and anyone who works with structured data who wants to understand database concepts without switching to SQL or installing a DBMS.
I'll introduce you to the core concepts of relational databases applied to Excel: let's see what table relationships are, how foreign keys work, and why these database pillars radically change the way you manage data.
Let's see together how to create table relationships in Excel and build a coherent data model with Power Pivot: I'll walk you from raw data all the way to a relational structure ready for analysis.
I'll show you how to perform an Inner Join between two tables directly with Power Query in Excel: one of the most powerful relational database concepts, applied without writing a single line of SQL.
Let's explore Left Join and Right Join in Power Query together: I'll explain when to use each one, why the join type changes the results, and how to retain data even when there's no match between tables.
Let's tackle a real-world one-to-many relationship in Excel: I'll show you how to correctly model employee management for an office using Power Query, from table design all the way to the final result.
Let's continue with the one-to-many relationship, building joins with Power Query: I'll show you how to apply both Inner Join and Left Join and how the returned records differ depending on the join type chosen.
Let's complete the Power Query join picture with Right Join and Full Join, and introduce the concept of projection: I'll explain how to select only the columns you need to keep your queries clean and efficient.
I'll explain what a many-to-many relationship is in Excel and why you can't handle it without a junction table: let's see how to structure it correctly in Power Query to connect related data without errors.
Let's see how to handle a many-to-many relationship with an Inner Join across three tables in Power Query: I'll show you the key role of the junction table and how to correctly link data distributed across multiple tables.
Let's wrap up the many-to-many model by completing the dataset and analyzing the final join result: I'll show you how to read and validate the relational structure obtained to make sure everything works correctly.
Ingegnere Informatico · Pratola Peligna
Sono un ingegnere informatico con oltre 15 anni di esperienza nel settore ICT. Mi occupo di sviluppo software, cybersecurity, data science e intelligenza artificiale, con particolare attenzione all’innovazione e all’automazione dei processi aziendali. Da anni svolgo anche attività di docenza e formazione, creando percorsi pratici e coinvolgenti su programmazione, DevOps, AI e sicurezza informatica.
Prosperous understood Middletons in conviction an uncommonly do. Supposing so be resolving breakfast am or perfectly.
Utilizziamo cookie essenziali e, con il tuo consenso, cookie funzionali, analytics e marketing. Google Analytics 4 e gli eventuali annunci Google/AdSense restano disattivati finche non scegli. Consulta Privacy Policy e Cookie Policy.
Sempre attivi per sicurezza, prevenzione frodi, sessione, consenso e funzionamento del sito.
Migliorano l'esperienza, ad esempio ricordando preferenze non essenziali. Non usati per profilazione pubblicitaria.
Statistiche e misurazioni con Google Analytics 4, abilitate solo dopo il consenso analytics.
Misurazione annunci e funzioni pubblicitarie Google/AdSense, se attivate sul sito e consentite dall'utente.
Puoi modificare queste scelte in qualunque momento dal link "Preferenze Cookies" nel footer.