Computers and Internet, Sharepoint, Social Networking, Uncategorized

SharePointPower – free 2013 site to try

SharePointPower – Trying out the site so I can play with SharePoint 2013 – looks good so far and it is free.
http://www.sharepointpower.com/Pages/default.aspx

Unleash the power of SharePoint
What you get:

Free unlimited SharePoint Site Collections and Subsites
Total 1GB Storage Space
Upto 10 Users to collaborate with
200 Alerts
SharePoint 2013 Enterprise Features
Available to you in 20 Languages
SharePoint Power brings you the ease of having your own SharePoint 2013 sites for the purpose of learning, training and showcasing your work to the world. It is hard to stand up your own SharePoint environment in order to get started on the platform. With SharePoint Power you get your own Tenant Administration site that gives you full control on your site collection administration and permission aspects.

They have Getting started guides for:
Beginners, Developers, Administrators, Power Users, Organizations and Evaluaters.

I am trying out the Power User first.

Pretty excited because I haven’t had time to look at 2013 yet and have to start thinking about budgeting for upgrade in 2014.

Standard
Sharepoint

Links from SharePoint Admin Training

Some of the links above point to SharePoint 2007 content. The instructions and funtionality is still applicable to SharePoint 2010.
Standard
Dynamics GP, Microsoft Office, Sharepoint, Uncategorized

Deploying Business Intelligence to the end user with PowerPivot

Retrieve data using queries in Microsoft SQL Server®2005 and 2008, Microsoft SQL Server Reporting Services, Microsoft FRX, SmartList Builder software & Microsoft Excel®2010 with PowerPivot software

Deploy PowerPivot in SharePoint 2010 to give staff access to data

With PowerPivot you can create browser based Business Intelligence pages in SharePoint by uploading Excel workbooks with the PowerPivot add in using SQL queries and views to pull real time data from multiple sources including SQL Databases, Excel Workbooks and Microsoft Dynamics GP, Forecaster, Encore and your Association Management System.

Background Information

§ I love collecting code and re-using it as much as possible to save time and money and leverage SharePoint.

§ I gather views by searching the internet sites like “GPUG’s Share My Code” site, SharePoint Users groups and CodePlex.

§ I belong to several users groups including GPUG, TheSUG, AUG and FEDSPUG where I get valuable information on SharePoint tips and tricks.

§ What is a PivotTable?

§ A PivotTable report is an interactive table that automatically extracts, organizes, and summarizes data.

§ PivotTables allow you to summarize and analyze large amounts of data in excel.

§ PowerPivot allows you to connect to Tables, Views or write a query to pull data into a list from multiple sources

§ What is required to install PowerPivot for Excel?

§ Microsoft Office 2010 and the add on PowerPivot for Excel

§ What is required to deploy Excel PowerPivot reports to SharePoint?

§ SharePoint 2010 SP1, Windows®2008 R2, Microsoft SQL Server 2005 and 2008, Office 2010, PowerPivot and Power View software

§ Download Powerpivot from the Microsoft site

§ http://www.microsoft.com/en-us/bi/powerpivot.aspx

§ It is an Add in that self installs when you open Excel.

§ Open Excel

§ Create a new Blank Workbook

clip_image003
clip_image004

§ Row Fields are fields from the source data that are assigned to a row layout in a PivotTable.

§ Column Fields are fields from the source data that are assigned to a column layout.

§ Report Filters are fields from the source data that act as filters in a PivotTable report

§ Items are the subcategories of a row, column, or report filter.

§ Values Fields are fields from the source data that contain values to be summarized.

§ The Data Area is the range of cells in a PivotTable report that contains summarized data.

clip_image006

clip_image007

clip_image009

§ Components of PowerPivot for SharePoint

Client and server components integrate with Excel and Excel Services in a SharePoint farm.

On a SharePoint farm, Analysis Services runs on an application server where it is paired with related services that handle requests for PowerPivot data.

§ PowerPivot client and server components

clip_image011

PowerPivot Web service runs on a web application server.

It redirects requests from the web application to a PowerPivot System Service instance in the farm.

An Analysis Service server instance in SharePoint integrated mode completes the deployment. It loads, queries, and unloads data.

It also processes data if the workbook is configured for PowerPivot data refresh.

clip_image013

clip_image015

Standard
Membership, Microsoft Office, Sharepoint

New App for the Ipad or Iphone for SharePoint access from Harmon.ie

I tested a New App for the Ipad or Iphone for SharePoint access from Harmon.ie that is now available in iTunes under harmon.ie: SharePoint Mobile Client. It is for the iPad, iPhone, iPod Touch and it is under the category: Business.

I was looking for an easy way to access files in SharePoint from the Ipad and found the SharePoint mobile client, Harmon.ie. This app works with SharePoint Windows authentication or forms based authentication so I did not have to do anything to our environment or the Ipad to use the app other than enter the URL and then choose the authentication mode.  I was able to access our intranet through Windows authentication and then our website using a test member record with forms based authentication.

Security is an important factor in a corporate environment and Harmon.ie does not store documents locally on the mobile device which is a big plus for me with the staff using more personal devices on our corporate intranet.

We have seen a rise in members using the Ipad to access our website which requires a new way of thinking on how members consume information that we are provide through SharePoint. External users (association members) can download the free lite version  to view files uploaded for them in our committee collaboration Form-based Authentication site.  This product will make it easy for any of our members that currently have iPhones and iPads to access reports and files.

I was able to access my SharePoint sites from my IPad quickly without looking at instructions or documentation.  The interface is clean and easy to understand.

The bar across the bottom allows access to the sites, files, updates, previous locations (History) and people.

harmonie picksharmonie

You can check-in, check-out and update documents. It also prompts user save changes to SharePoint.  You can also mark a document and library location as favorites using “breadcrumbs” and view a list of recent visited locations from the bar at the bottom.

I was able to open document types including Excel, Word, PowerPoint and Adobe documents using quick view or quick look.  I was also surprised that I was able to open documents using the SkyDrive app on my IPad  and download using SkyDrive or drop box.

I uploaded pictures and documents from my iPad to SharePoint just by clicking on forward arrow in drop box and the harmonie option came up and allowed me to save files. I saved  e-mail attachments to SharePoint from an open email without any issues.

I am going to be setting up my sites for my members so I am looking forward to the ability to view colleagues’ profiles and contact them via e-mail or phone. This will be a nice addition to our member directory by giving members and staff the ability to find people in SharePoint by entering department, skills, expertise and other keywords.

The other nice feature is that you can see profiles of the colleague who last modified a document and get updates when documents are modified so you can easily contact the person who modified the document with one click.

The Harmon.ie app allows you to scroll through all the SharePoint content on the iPad  and quickly access any documents that you have permission in the document library. The interface for the documents allows you to quickly see all the information about a file including the modification date and user,  version, size and file type. Once you click on the file you can use the send button to email a link or the document or you can just copy the link to use in another document.  You can open the document to view with the Harmon.ie quick viewers or use one of your preinstalled iPad apps that works with the different file types. The files can also be checked out if you want to prevent other users from changing the file while you are working on it.

I have been using the Harmon.ie add in for Outlook which has allowed me to add meta data quickly to multiple files from outlook so I am looking forward to using this app on the iPad for the times that I am out of the office and need to quickly get to a file on the intranet or workspace.

I would definitely recommend downloading this app and trying it out.

Standard
Dynamics GP, Sharepoint

Microsoft Dynamics GP Business Analyzer–New reporting tool

The Microsoft Convergence conference has come to an end so it is time to go back to work and implement the new products that were demonstrated  in the sessions. The new Microsoft Dynamics GP Business Analyzer is the first product that I am going to install from the GP 2010 installation disk.  This will allow my end user to run their reports from the desktop without having to log into GP.  This will save time for the users who just want to run a quick report.

It requires SQL 2008, Dynamics GP 2010 R2 and Reporting services 2008 or later. You can pull from a GP database that is on SQL 2005 but the reporting services must be running on SQL 2008 or later. Lync turns on extra features but is not required for the installation.  If you want the map functionality then you need SQL 2008 R2.

To install Business Analyzer you get the installation Disk for GP2010R2 and look under additional products.  Select GP Business Analyzer.  You need to enter where your reporting services server is so if you don’t know you need to go to the Reporting services configuration manager and look under the web service URL – this is your reporting services server location.

After Business Analyzer is installed you go to Start – Programs – Business Analyzer and the configuration window opens. You select the role and it will add default reports.

The top window is the primary report area where your report is displayed. You can use any reports written in SQL reporting services.  you can resize the report areas, use charts, pull from multiple companies, upload photos or images.

The actions are on the left hand side where they are buttons for information, view and drill back.

This looks like it could provide a simple platform to deploy reports.  I am going to try to install on a terminal server and see if staff can log in and run reports remotely.

Should be fun to play with since you can run any reports in it – It can connect to any datasource so it is not just tied to GP.

Standard