82149 - STRATEGIC INFORMATION SYSTEM LABORATORY

Course Unit Page

Academic Year 2018/2019

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