How to … install the software you required for BI Academy Hands-Ons Labs on my PC?

Software we use

We are using the following software to run all our hands-ons labs:

  • 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

There is no database installation required because we use our own cloud based SQL Server.

Here is an installation guide.

SQL Server Data Tools in Visual Studio 2017

We are using SSDT in VS 2017, because there is a stand-alone installer.

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

.

Dimensional Fact Modeller

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

PowerBI

  • Please install ENGLISH version!
  • 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.

SQL Server Management Studio

SQL Server Management Studio (SSMS) enables you to manage a relational database (called Database Engine), a Multidimensional Database (called Analysis Services) and the ETL backend server (called Integration Services).

  • SSMS 18.8 is the latest general availability (GA) version of SSMS ← 11.02.2021
  • Download from here ← 11.02.2021
  • Please install the English language version.
  • The installation is quite easy. Just click install and SSMS will do the rest within 5 – 10 min.

After successfull installation, open SSMS, click on ToolsOptionsDesigners and uncheck “prevent saving changes that require table re-creation”. Otherwise, you will not be able to save any database schema changes.