- Docente: Francesco Bergamaschi
- Credits: 8
- SSD: SECS-P/08
- Language: English
- Teaching Mode: Traditional lectures
- Campus: Bologna
- Corso: First cycle degree programme (L) in Management and Marketing (cod. 8406)
Learning outcomes
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
Course contents
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
Readings/Bibliography
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).
Teaching methods
Lectures in class and practical applications in laboratory.
Assessment methods
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.
Teaching tools
Blackboard, slides, PCs.
Office hours
See the website of Francesco Bergamaschi