This Post is part of  SharePoint 2010 Installation Series

To increase Excel Services limits:

1. Navigate to SharePoint Central Administration > Application Management > Manage Service Applications.
2. Select your Excel Service Application.
3. On the Ribbon, click Manage.
4. Click Trusted File Locations and on the following page, select your trusted location. (Typically, this is listed as http:// in the Address column.)
5. In the Workbook Properties area, set the Maximum Workbook Size property to 2000 and the Maximum Chart or Image Size to 100 MB

A Good sample of SharePoint Services is

http://fo-developer-07/Pages/excelservicessample.aspx

Or your services web application url /Pages/excelservicessample.aspx

For more information about using excel services and good examples see this video here

And here

This Post is part of  SharePoint 2010 Installation Series

Content copied from here

To make full use of the server components you just installed, download the authoring tools to create and then publish your first Power Pivot-enabled workbook.

Open a port

If you are deploying a new server, you might need to open a port so that remote users can access your site.

• On the computer that hosts the Power Pivot server, click Control Panel, and then double-click Windows Firewall.
  
• Click Change Settings.
  
• Click Exceptions.
  
• Click Add port.
  
• In Name, enter a descriptive name, such as Port 80.
  
• In Port number, enter 80.
  
• For Protocol, use the default selection TCP.
  
• Click OK.
  

Grant Permissions

Users will need SharePoint permissions before they can publish or view workbooks. Be sure to grant Read permissions to users who need to need to view published workbooks and Contribute permissions to users who publish or manage workbooks. You must be a site collection administrator to grant permissions.

• In the site, click Site Actions.
  
• Click Site Permissions.
  
• Select the checkbox for the site collection Members group.
  
• On the ribbon, click Grant Permissions.
  
• Enter the Windows domain user or group accounts who should have permission to add or remove documents.
  Do not use e-mail addresses or distribution groups unless the application is configured for Claims authentication.
  
• Click OK.
  
• Select the checkbox for the site collection Visitors group.
  
• On the ribbon, click Grant Permissions.
  
• Enter the Windows domain user or group accounts who should have permission to view documents. As before, do not use e-mail addresses or distribution group if the application is configured for classic authentication.
  
• Click OK.
  

Install Power Pivot for Excel Add-in and Build a Power Pivot Workbook

After you have the server components installed in a farm, you can create your first Excel 2010 workbook that uses embedded Power Pivot data, and then publish it to a SharePoint library in a Web application.

Before you can build Excel workbooks that include Power Pivot data, you must start with an installation of Excel 2010, followed by the Power Pivot for Excel add-in that extends Excel to support Power Pivot data modeling.

For instructions on how to install Power Pivot for Excel and create Power Pivot data sources, see How to: Install the Power Pivot for Excel Add-in and Creating Power Pivot Workbooks in Excel.

Add Servers or Applications

Over time, if you determine that additional data storage and processing capability is needed, you can add a second Power Pivot for SharePoint server instance to the farm. For instructions, see How to: Scale a Power Pivot for SharePoint Deployment.

Pasted from <http://msdn.microsoft.com/en-us/library/ee210708(SQL.105).aspx>

After you install the Excel 2010 and Power Pivot for Excel 2010, use Power Pivot to create a workbook (say Test.xlsx).

b. Publish the workbook to the Shared Documents folder on the default Web site (http://machinename ).

c. Open SQL Server Management Studio, click Connect > Analysis Services and type http://<machinename>/Shared%20Documents/Test.xlsx into the Server Name field.

d. Click Connect.

A connection should appear in the Object Explorer and you should be able to browse the cube in your Excel workbook. This confirms that you have Power Pivot set up correctly.

Now that you have successfully installed and configured Power Pivot, you might want to configure Reporting Services on your SharePoint farm to enable additional functionality. Use the Reporting Services Installation and Configuration document to install and configure Reporting Services in SharePoint Integrated mode. You can then use Report Builder to create reports using Power Pivot workbooks that you have been published to a Power Pivot Gallery as data sources.

This Post is part of  SharePoint 2010 Installation Series

Navigate to central administration home page

navigate to central administration home page

Select application management and then create new site collection

Navigate to the new site collection site main page

And then select the tab create dashboards

Start using performance Point services

You will be redirected to /Pages/ppssample.aspx

Select run dash board designer

The dashboard designer will be installed

On your machine and then you will be ready to go and design

Your dashboards

This Post is part of  SharePoint 2010 Installation Series

• After restarting your computer log in as the farm administrator

  In my case Fo-dev-07-SP-Farm

  There are some IE8 bugs in the current UI…so push F12

• Click "Browser Mode: IE8 Compact View" and select "Internet Explorer 7".

  

• Open the central administration site / System Settings

  / Manage services in this farm

• Make sure the User Profile Service and User Profile Synchronization service

  Are started

My case User Profile Synchronization service is not started , click start

After starting the service you should wait a couple of minutes tell the timer jobs ends its work you can check that in the timer job status in the central administration

Also make sure the the two services forefront Identity are up and running

• Do and iisreset
• After that navigate back to the central administration / Application Management/

  Manage Service Applications

• Select User Profile Service Application
• Select Configure Synchronization Connections
• Select Create New
• Select "Walk me through the settings using this wizard" and Next
• Make the form look like this and then click ok

Now you have a new sync connection

• Go back to "User Profile Service Application" page from "Manage Service Applications"
• And then select Start Profile Synchronization
• Select "Start Full Synchronization" then click "OK".

• This will take a few minutes as a job is scheduled to do this
• For more information on the User Profile imports go to:

  C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\ and run MSIISClient.exe

• Now you can navigate to My site and see your activities but also note that the organization chart maps the organization properties of the user in the active directory

for more information about that Read this topic

This Post is part of  SharePoint 2010 Installation Series

Fix the Host Name Problem

Method 1: Disable the loopback check

Follow these steps:1. Click Start, click Run, type regedit, and then click OK.

2. In Registry Editor, locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa

3. Right-click Lsa, point to New, and then click DWORD Value.

4. Type DisableLoopbackCheck, and then press ENTER.

5. Right-click DisableLoopbackCheck, and then click Modify.

6. In the Value data box, type 1, and then click OK.

7. Quit Registry Editor, and then restart your computer.

Method 2: Specify host names

To specify the host names that are mapped to the loopback address and can connect to Web sites on your computer, follow these steps:1. Click Start, click Run, type regedit, and then click OK.

2. In Registry Editor, locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0

3. Right-click MSV1_0, point to New, and then click Multi-String Value.

4. Type BackConnectionHostNames, and then press ENTER.

5. Right-click BackConnectionHostNames, and then click Modify.

6. In the Value data box, type the host name or the host names for the sites that are on the local computer, and then click OK.

7. Quit Registry Editor, and then restart the IISAdmin service.

Open Environment Variables

Right-clicking My Computer and going to Properties then Advanced System Properties or by going to the System Control Panel and click Advanced System Properties.

From the Advanced System Properties Window go to Environmental Variables. From Environment Variables in System Variables go to Path and click Edit…

From the Exit System Variable Window, scroll to the end of Variable value:

Enter the exact text below, ensure that there are no spaces at the beginning or end of the statement.

;C:\Progra~1\Common~1\Micros~1\webser~1\14\bin

Click OK a few time to return to the desktop and reopen your Command Prompt, you should be able to use Stsadm and Psconfig without having to first navigate to SharePoint Root (formerly the 12 Hive) any longer.

This Post is part of  SharePoint 2010 Installation Series

Outgoing e-mail

1. Open SharePoint central administration
2. Select System Settings and then Configure outgoing e-mail settings
3. Make it looks like that

In my case i configured an smpt server however if you have exchange server you can simply replace the Outbound SMTP Server field with the exchange server full name.

Diagnostic logging

1. Open SharePoint central administration
2. Select Monitoring and then Configure diagnostic logging
3. Make it looks like that

Configure usage and health data collection

1. Open SharePoint central administration
2. Select Monitoring and then Configure usage and health data collection
3. Make it looks like that

Configure file size limits (Optional)

Out of the box, SharePoint allows you to upload files up to 50MB in size and Excel Services allows you to view files as large as 10 MB in a browser. Our new farm setup increases the Excel Services limit to 50MB. You can change these settings even further if users will be publishing and interacting with larger files.

To increase Web Application limits:

1. Navigate to SharePoint 2010 Central Administration > Application Management > Manage Web Applications.
2. Select SharePoint-80 and then, on the Ribbon, select General Settings > General Settings.
3. Change the Maximum Upload Size setting to the MB limit you want to set. (The maximum allowed by SharePoint is 2047MB.)

1. Open SharePoint central administration
2. Select Configuration Wizards
3. Select "Walk me through the settings using this wizard" and Next
4. Make the form look like this

1. Wait a while tell the wizard change it works
2. After that you are promoted to create a new site collection
3. Enter the following data and then click ok

1. Congratulations you have just activated all SharePoint services

This Post is part of  SharePoint 2010 Installation Series

Assign Permissions

Setup Admin and Fo-Dev-07-SP-Farm accounts must be assign the following roles in the sql server : dbcreator and securityadmin.

Open Start, Programs, Sql Server Management Studio

1. Connect to your Server Instance my case ( FO-DEVELOPER-07\GEMINIBI )
2. Pen the security / logins node
3. Located the Admin account if doesn’t exist create it
4. Right click properties / Server Roles
5. Check Security admin and dbcreator
6. Click ok
7. And then restart your server

Configure networking

At the end you need to configure networking if you are planning to deploy a farm with multiple SharePoint Server 2010 servers.

According to TechNet [1] you need to "ensure that SQL Server 2005 or SQL Server 2008 is updated to the required level and configured as follows":

SQL Server 2005: Local and remote connections are enabled and are configured to use the TCP/IP protocol.

SQL Server 2008: The TCP/IP protocol is enabled for the network configuration.

This Post is part of  SharePoint 2010 Installation Series

If you installed sql server with Power pivot … You should skip this step and proceed to the next step Sql Server Configuration

Avoid DataBase name with guids

In order to avoid creating the SharePoint config and content databases with names having guids

I would recomend you to run a command line as administrator and write the following code

cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN

psconfig -cmd configdb -create -server FO-DEVELOPER-07 -database FO_DEV_07_Wss_ADMIN_CONFIG -user

Fo-Dev-07-SP-Farm -password ****** -admincontentdatabase FO_DEV_07_Wss_ADMIN_CONTENT

Or make what ever names you would like to have for more information read this topic

SharePoint Installation Wizard

Click Start / All programs / Microsoft SharePoint 2010 Products

SharePoint 2010 Products Configuration Wizard

1. Click Next , Click yes and choose to create a new server farm
2. Select create a new server farm
3. Enter the Database server my case ( FO-DEVELOPER-07\GEMINIBI ) and DB name
4. For the farm user enter : Fo-Dev-07-SP-Farm
5. Enter a passphrase to secure farm configuration data. It is also needed if you join a new server to the farm. "Password1" is a good example
6. Select a port : 55555 and a authentication provider : NTLM
7. Click Next and Install and finish the installation Process

This Post is part of  SharePoint 2010 Installation Series

This topic is only for installing sql server without power pivot if you have already

Installed SQL server with power pivot by following the last step , you should skip this step and the next step SharePoint Configuration Wizard and proceed directly to the step

SQL Server Configuration

• Login as a server and domain controller administrator

If you installed visual studio 2010 before this step you will need to do the following

Create a .reg file and add this lines:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramewor\v2.0.50727\AssemblyFoldersEx\Chart Controls]

@="C:\\Program Files (x86)\\Microsoft Chart Controls\\Assemblies"

And then run the reg file

• Run SQL Server Setup with administrator permissions. Right-click Setup.exe, and select Run as Administrator.
  • Click Installation on the navigation pane to the left.
  • Click New SQL Server standalone installation or add features to an existing installation.
  • In Setup Support Rules, click OK if no problems were detected. Otherwise, follow the instructions on the page to correct the problems and then restart setup.
  • Accept Agreement and Click Next
  • On the Setup Role page, select the Sql Server Feature Installation

  

  • In Feature Selection, Select the following features

    

  • Click Next, Next, Next
  • On the server configuration Click "Use the same account for all SQL Server Services"

    And enter the settings for the user DEVSOLAR\Fo-Dev-07-SQLService

  

  • Click the Collation Tab and click Customize and selecet Latin1_General From the Drop down for the Database Engine

  
  

  • Click Ok , and Next
  • Database Engine Configuration dialog. Click on Add Current User to ensure that you are a SQL Server system administrator.
  • Click "Add.." and add the user "Fo-Dev-07-SP-Farm"

  

  • Click Next , to the end of the wizard and install the server