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
-
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
-
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
-
>
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 Tools – Options – Designers and uncheck “prevent saving changes that require table re-creation”. Otherwise, you will not be able to save any database schema changes.
