Skip to content

Latest commit

 

History

History
58 lines (36 loc) · 3.59 KB

Microsoft_BI_Suite.md

File metadata and controls

58 lines (36 loc) · 3.59 KB

Starter Kit and Resources for Microsoft Business Intelligence Suite

Required Setup

  • Microsoft SQL Server Developer Edition
  • Microsoft SQL Server Management Studio
  • Analysis Services (SSAS) (SQL Server Component and Visual Studio Extension)
  • Integration Services (SSIS) (SQL Server Component and Visual Studio Extension)
  • Power BI Desktop
  • Visual Studio 2019 Community
  • AdventureWorks sample databases

Microsoft SQL Server Developer Edition

For Windows, download the latest version of MSSQL Server Developer edition. This is free software and requires no registration.

Execute the SQL2019-SSEI-Dev.exe, choose Download Media at a specified location

Use ISO packaging, mount and install

After checking your computer, select Custom Installation and ensure that Database Engine, Integration Services, Analysis Services are all selected for installation. Add current user in all cases when prompted.

For authentication, choose mixed mode authentication (it may be shown as SQL Server and Windows Authentication mode). If you are asked for a user name, use sa, and for the password use passw0rd (we will only use publicly available sample data for the project so we are ok with basic security)

SQL Server Management Studio

For Windows, download the latest version of MSSQL Server Management Studio. This is free software and requires no registration.

Once it is installed, run it and it will connect to the SQL Server that you installed in the previous step

For authentication, choose SQL server authentication, and enter the user name and password which you created in the previous step for the SQL Server

AdventureWorks databases

Go to this page and download the following two databases (they are free to download and use):

Be careful with the database names, there are many databases available on that page with similar sounding names. Be sure that you have selected the right ones.

The installation of the databases in MSSQL Server will be shown in one of the course sessions.

Development IDE

Visual Studio 2019 Community or better with the Data storage and processing workload installed, including the SQL Server Data Tools component.

SQL Server Development Tools

  1. The SQL Server Analysis Services Projects extension installed for Visual Studio.
  2. The SQL Server Integration Services Projects extension installed for Visual Studio.

Power BI

Download Power BI Desktop and install the PBIDesktopSetup_x64.exe or download it from the Windows Store

Other tools

  1. Git, download and install Git Version Control
  2. Create a Github account