- Docente: Francesco Bergamaschi
- Crediti formativi: 8
- SSD: SECS-P/08
- Lingua di insegnamento: Inglese
- Modalità didattica: Convenzionale - Lezioni in presenza
- Campus: Bologna
- Corso: Laurea in Management e marketing (cod. 8406)
Conoscenze e abilità da conseguire
At the end of the course students understand and masters a broad array of issues managers face in the selection and management of information technology. They understand how to design and implement an information system. Moreover they learn how to use most diffused tools to manage strategically information. The student learns how information technology systems support business operations and help implement business strategies
Contenuti
The course provides the most advanced tools for Business Intelligence (BI) calculations and reports. It will be concentraded on DAX language, including its extremely advanced features, and on intense practice to become a BI Professional.
Data Models (Star, Snowflake, Header/Tail)
Normalization / Denormalization
Imported tables vs Linked tables
Calculated columns vs Measures
Row context vs Filter context
RELATED and RELATEDTABLE
Context Transition
CALCULATE and CALCULATETABLE
FILTER
Multiple row and filter context, nested
ALL Functions
X Functions (iterators)
HASONEVALUE
Disconnected tables
Time intelligence
Granularity issues
Many to many relationships
Sets
Perspectives
Hierarchies
CROSSFILTER
Advanced DAX applications (New and Returning Customers)
Cube formulas
DAX as a query language (DAX studio)
EVALUATE
Linked-Back Tables
Hints on SQL Server Analysis Services and SQL
Power BI dashboards
Testi/Bibliografia
Collie, Singh / Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016, Holy Macro! Books, 2016 (2nd edition)
Allington / Learn to Write DAX, Holy Marco! Books, 2016.
Ferrari, Russo / Microsoft Excel 2013 - Building Data Models with PowerPivot, Microsoft, 2013.
Ferrari, Russo / The Definitive Guide to DAX, Microsoft, 2015.
Ferrari, Russo / Analyzing Data with Microsoft Power BI and Power Pivot for Excel 2016, Microsoft, 2017.
Ferrari, Russo / Introducing Power BI, Microsoft, 2016.
Murach / MySQL, Mike Murach & Associates Inc, 2015 (2nd edition).
Metodi didattici
Lectures in class and practical applications in laboratory.
Modalità di verifica e valutazione dell'apprendimento
Practical test in laboratory on a real Business Intelligence issue to solve, producing a real and practical report/dashboard/automation solution plus a few measures to write in multiple ways to show a real understanding of the DAX syntax.
Strumenti a supporto della didattica
Blackboard, slides, PCs.
Orario di ricevimento
Consulta il sito web di Francesco Bergamaschi