82149 - STRATEGIC INFORMATION SYSTEM LABORATORY

Scheda insegnamento

Anno Accademico 2018/2019

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

Programma/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 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