User Tools

Site Tools


bicn01:f0003

Software required

We need 4 software modules:

  • Microsoft's Visual Studio Data Tools
  • Stefano Cazzella's Dimensional Fact Modeler
  • Microsoft's PowerBI Desktop
  • Microsoft's Excel, incl. PowerPivot

SQL Server Data Tools in Visual Studio 2015

* https://msdn.microsoft.com/en-us/mt186501.aspx, as of 25.4.2018

  • 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

Dimensional Fact Modeller

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

PowerBI

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

Microsoft Office 2016, Professional ProPlus

  • 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.

bicn01/f0003.txt · Last modified: 2018/12/04 08:39 (external edit)