MSBI Environment Setup

Hardware requirements for MSBI

  • GHz Pentium – III compatible (or) faster processor (2GHZ or fast recommended)
  • 512 MB of RAM or more than 2 GB
  • 1 GB free hard disk space for SQL Server installation files and samples

Kick-start your career in MSBI with the perfect MSBI training course now!

Watch this MSBI Tutorial full course for Beginners video

Youtube subscribe

Software requirements for MSBI

A Compatible OS (operating system.)

  • Click “Setup” –> Select the first option when the window opened, i.e., features added or New SQL, New SQL Server stand-alone installation
  • Click on the –> Components required
  • Instance Configuration.
  • Server configuration

Identify the same account, the password for every below services (or) different user id, a password for each service.

Become a Business Intelligence Architect

Get ready for the high-paying MSBI jobs with these Top MSBI Interview Questions and Answers!

Installation steps:

We need to install SQL Server and SQL Server tools before learning SQL Server MSBI. Download the enterprise edition using the below link. www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014

msbi1

The select option depends on your system configuration.

msbi1

The select language in which you preferred to download the ISO image.
msbi1

Extract the ISO image, select the edition. Before proceeding to the installation process it’s checking for the problems.

msbi1

And select the below option among these three.

  • SQL Server Feature Installation
  • SQL Server Power for SharePoint
  • All Features with Defaults

msbi1
Select the features: by default its checked all features.

msbi1

Once all feature rules are passed successfully, click on the next.

msbi1

Select the default option in instance configuration.
msbi1
Service credential settings
msbi1
msbi1
Select Windows authentication mode in database engine configuration.
msbi1Have a look at this informative tutorial on Top 7 MSBI Advantages over Other BI Tools and clarify all your doubts!

In analysis services configuration select server mode as multidimensional and data mining mode.

msbi1

msbi1

We need to install SQL server data tools. SQL Server for storing data creating table writing store and procedure etc. For data extraction, transformation, loading, reporting, analysis we are using data tools

SQL Server data tools installation:

Using the below link you can install the data tools

 Microsoft SQL Server Data Tools

msbi1

After downloading the file, then extract the “SSDTBI_x86_ENU” file and follow the screenshots.msbi1

msbi1

msbi1

msbi1

msbi1

msbi1

msbi1

Now the installation process will initiate

msbi1

Click on Next –> Finish.

Check out the MSBI Tutorial to understand MSBI Cheat Sheet for beginners.

Course Schedule

Name Date Details
MSBI Certification Training Course 30 Mar 2024(Sat-Sun) Weekend Batch
View Details
MSBI Certification Training Course 06 Apr 2024(Sat-Sun) Weekend Batch
View Details
MSBI Certification Training Course 13 Apr 2024(Sat-Sun) Weekend Batch
View Details