business-intelligence.md

Hardware and software requirements for Business Intelligence

 

Minimum Hardware Specifications

• 8 GB RAM
• 128 GB Storage (SSD would be preferrable)
• 2 Core CPU
• Windows 10, 64 bit

Important notice

Mac or Linux users can install MS-SQL server using Docker. Instead of Management Studio, Azure Portal Application can be used but without the diagrammatic capabilities. Power BI is NOT supported. Windows in a virtual machine can be an option, or dual boot.

Required software

You will need the MS-SQL Server database (RDBMS), the MS-SQL Server management interface and the Power BI desktop application. In detail you have to download:

1. Latest Version of SQL Server Developer

   • Download the Developer edition (SQL20XX-SSEI-Dev.exe)
   • Execute the SQL2019-SSEI-Dev.exe and perform a default installation.

2. Latest version of SQL Server Management Studio

   • Download and install the SSMS-Setup-ENU.exe file.

3. Latest version of Power BI

   • Download the Power BI Desktop and install the PBIDesktopSetup_x64.exe.

   

Demo databases for Business Intelligence

AdventureWorks download links

OLTP version of AdventureWorks 2012

DW version of AdventureWorks 2012

Restore instructions

Follow the below steps to restore a backup of your database using SQL Server Management Studio.

1. Open SQL Server Management Studio and connect to the target SQL Server instance.
2. Right-click on the Databases node, and select Restore Database.
3. Select Device and click the ellipses (...)
4. In the dialog Select backup devices, click Add, navigate to the database backup in the filesystem of the server, and select the backup. Click OK.
5. If needed, change the target location for the data and log files, in the Files pane. Note that it is best practice to place data and log files on different drives.
6. Click OK. This will initiate the database restore. After it completes, you will have the AdventureWorks database installed on your SQL Server instance.