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

MSBI Installation 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


Learn for free ! Subscribe to our youtube Channel.

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.

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 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 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

 https://www.microsoft.com/en-in/download/details.aspx?id=42313

msbi1

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

msbi1

msbi1

msbi1

msbi1

msbi1

msbi1

Interested in learning MSBI? Click here to learn more in this MSBI Training in Hyderabad!

Now the installation process will initiate

msbi1

Click on Next –> Finish.

Recommended Videos

Leave a Reply

Your email address will not be published. Required fields are marked *