Software required
We need the following software modules:
Microsoft's Visual Studio Data Tools
Stefano Cazzella's Dimensional Fact Modeler
Microsoft's PowerBI Desktop
Microsoft's Excel, incl. PowerPivot
Microsoft SQL Server Management Studio
Dimensional Fact Modeller
-
-
Windows user have to select the 32 or 64bit version

PowerBI
Microsoft Office 2016, Professional ProPlus
Note: If you don't have Professional ProPlus, you have to skip one exercise later.
SQL Server Management Studio
SQL Server Management Studio (SSMS) enables you to manage a Microsoft Database.