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

* https://msdn.microsoft.com/en-us/mt186501.aspx, ← 21.01.2020

• Scroll down to Download SSDT 2015 as an ISO image (optional)
• Select the English version
• Install it

• check installation:
  • Start SQLServer Data Tools
  • File → New → Project
  • Check, if you see the BI templates

• Continue
  • Click OK (then, it may take a minute)
  • in Menu → Project → xxxx Properties
  • Check, if you see the target server in the deployment window

• Check Database Server Explorer
  • Start View → Server Explorer
  • Click on the Icon Connect to Database
  • Server name: dwh.hdm-server.eu
  • Authentication: SQL Server Authentication
  • Login: testme
  • Password: testme
  • Database: TESTME
  • Test the connection

• http://www.bimodeler.com/, as of 30.09.2017
• Maybe, you have do download Java Runtime https://www.java.com/de/download/, as of 30.9.2017
  • Windows user have to select the 32 or 64bit version

• check installation:
  • Start BI Modeler
  • Check, if the menu items show up

• PowerBI Desktop https://powerbi.microsoft.com/en-us/desktop/, as of 09.01.2020

• Please install ENGLISH version!

• check installation:
  • Start PowerBI Desktop
  • Check, if the menu items show up

• check installation:
  • Start Excel
  • File → Account
  • Check, if you run Professional ProPlus

• activate power pivot
  • File → Options → Add-Ins → Manage COM-AddIns
  • Activate Microsoft Power Pivot for Excel

Note: If you don't have Professional ProPlus, you have to skip one exercise later.

SQL Server Management Studio (SSMS) enables you to manage a Microsoft Database.

• SSMS 18.4 is the latest general availability (GA) version of SSMS ← 09.01.2020
• Download from here ← 21.01.2020