Site Meter Microsoft Office » SharePoint Designer

SharePoint Designer

Track SharePoint blog usage with Microsoft adCenter Analytics

Monday, December 1st, 2008

If you blog on a SharePoint site like we do, chances are you want to know how many people visit your site, how they find it, and other information about your readership. Unfortunately, the native SharePoint usage reports are not much help for the kind of information you want to see.

However, there are a couple free Web analytics programs that are easy to hook up and use. One of the newest is Microsoft adCenter Analytics. Because the site says it’s a limited Beta, you have to register and then wait for an invitation to join the program. It typically takes a few days to hear back from them, but when you receive your invitation you can follow their simple instructions to create a profile and add the script to your site.

The thing is, their instructions don’t address what to do on a SharePoint site. So that’s where we come in. I’ve seen a few blog posts and videos out there about how to add other analytics scripts to a SharePoint blog, but they all seem either light on detail or leave out a key piece of information, so I shot my own video, Add Microsoft adCenter analytics to your SharePoint blog home page.

As the title suggests, I show only how to add the script to your home page. This will capture lots of great numbers about home page usage, but does not capture information about individual posts.

Microsoft adCenter Analytics

Learn about the latest adCenter AnalyticsBeta features and enhancements, including ten different customizable reports. This free, on-demand web analytics solution helps you easily understand user engagement and online marketing campaign performance. Today, we invite you to join our program: Microsoft adCenter AnalyticsBeta—formerly Project Gatineau.

Understand User Engagement
Track audience behavior—from click to conversion—all in one place. The application’s dashboard and advanced report graphics help you view your data at a glance, so you can make key decisions quickly and efficiently.

Gain Control—Tailor for the Right Audience and the Right Time
You can even assess performance of your other pay-per-click programs—including Google and Yahoo. Easily track ROI, conversion rates, revenue of banner, email, and direct response campaigns so you can monitor web site performance and better control the return on your marketing spend.

Gain Customer Intelligence and Insight
You can rely on adCenter Analytics to help you understand your site traffic, customer intent, behavior, and campaign performance. Build your own customized dashboard and review which campaigns are working well. This next-generation web analytics system puts key data at your fingertips, including: Dashboards
Traffic & History
Visitor Loyalty
Pages & Content
Referrals
Goals
Commerce
Paths
Funnels
Visitor Information

Get Started Today
Register now to realize the power of an end-to-end web tracking system.

The many faces of SharePoint

Saturday, November 29th, 2008

From the Microsoft Office Sharepoint Blog: So here it goes…. I’ll summarize four very different SharePoint offerings, some of them you probably weren’t even aware were based on SharePoint. Just for fun, I’ll call them Mini, Small, Medium, and Large-SharePoint.

Mini-SharePoint

Office Live Workspace, believe it or not, is built on SharePoint but highly customized and simplified for the end user. The idea is simple – create a workspace (which is like a folder), add files to it, then share it with others. Create and share Word, Excel, and PowerPoint documents, pictures, notes, and custom lists with anyone you want. Or use it to share files between work and home, which is a lot easier than emailing files back and forth.

I’ve created one workspace to share files with colleagues, another workspace to share photos with family, and a third workspace to organize forms and schedules for my vanpool.

Find out more at http://workspace.officelive.com

Small-SharePoint

Office Live Small Business is also built on SharePoint but highly customized with Web features, Web applications, and Web site tools. It includes a Web site, multiple email accounts, and Web applications ideal for the small business with up to 10 employees. The Web site features allow you to create a site without knowing a thing about HTML, Web design, or Web creation software. Use the included Web applications to manage and communicate with employees and customers. For simple file sharing, use the Office Live Workspace included with your account.

My goal this year is to move my mom’s real estate practice to the Web using this service.

Find out more at http://smallbusiness.officelive.com

Medium-SharePoint

SharePoint Online, along with Exchange Online, Communications Online, and Live Meeting make up the new Microsoft Online Services. Rather than installing and maintaining SharePoint Server, SQL Server, Exchange Server, and other server software in your office, just sign up for this business hosting solution and let Microsoft do the heavy IT lifting for you. The service can handle up to 500 individual PC users. Just launch a Web browser, and you have immediate access to your entire business environment.

I would highly recommend this service to any small business that has outgrown Office Live Small Business but is too small to manage a SharePoint deployment.

Find out more at http://www.microsoft.com/online

Large-SharePoint

SharePoint Server (Windows SharePoint Services and Office SharePoint Server). Last but not least, we have the actual SharePoint software in the box. For the large and enterprise organizations looking to deploy a completely customized and integrated content management solution across the organization, this is what you need. With SharePoint running on your corporate servers, you have complete control over your corporate Intranet, Extranet, and Internet presence, and you can build on the existing collaboration tools, managed business processes, and integration with Microsoft Office client applications.

This is what I use at work every day to communicate with colleagues, collaborate on projects, find critical business data, and actively monitor projects in my department and other departments.

Find out more at http://www.microsoft.com/sharepoint

I hope this clarifies the various SharePoint offerings that you or your business can choose from.

Using PivotTables to Analyze Data From a SharePoint List

Sunday, November 9th, 2008

Today’s author, Diego Oppenheimer, a Program Manager on the Excel team, talks about connecting PivotTables to data stored in SharePoint Lists:

Many of us on the Excel team have been approached by customers asking us how to create a connection to a SharePoint list. SharePoint lists can be exported easily by creating a Microsoft Office Excel Web Query. The connection can then be tied directly to lists or PivotTables in the workbook like any other Data Connection.

I have a SharePoint List that we use to upload and keep track of all project management reports. The list contains information like the project manager that uploaded it, the date, and the name of the reports as well as other automated fields created by SharePoint to make my life easier. Using the filters provided by SharePoint gives me a great way navigate my list quickly and easily but I am more interested in creating a macro view of the team reports so an easy solution would be to connect my SharePoint List to a PivotTable. The fact that my SharePoint List has more than 250 rows makes the use of a PivotTable even more appealing.

Creating the Connection and the PivotTable:

Once we have located the SharePoint list we want to export we go to “Export to Spreadsheet” in the “Actions” menu button.

When the message prompting us if we would like to open or save the Microsoft Office Excel Web Query click “Open” (or you can save for use later). If you haven’t started Excel yet this should start it up.

Click “Enable” to unblock the data connection.

If you had Excel already open you will get the the “Import Data” menu. In the case that you did not have Excel open already opening the connection will create a a resfreshable query table in the workbook.

From this menu we can choose to directly create a “PivotTable Report” a report and a “PivotChart” or just a query “Table”. Today I am interested in creating a PivotTable so I select “PivotTable Report” and hit “Ok”.

Now I can see all my uploaded reports in the PivotTable. To get a better view of what is going on we add the Project Manager field to Rows, Date to the Report Filter (so we can filter by date) and the Name field (the name of each one of our uploaded reports on the SharePoint List) to Values. By adding Name to Values we are essentially creating a count of how many name items we have in the data source.

We replace “Count of Name” with “# Reports” by editing in the formula tab like any other cell.

Now I can easily view the numbers of reports per project manager and filter by date as well as viewing the “Grand Total” number of reports. This is great but the team actually splits up in sub teams by area of expertise so I am going to group them to make this clearer.

We select all the members of the each team in the PivotTable and right click. Select “Group”. Now I can rename the Group label to better represent the teams. I name my groups “Finance”. “Technology” & “Operations”.

Combining the use of our Date filter and the groups we created we can easily see a macro view of all the project management reports.

As soon as new reports are populated into my SharePoint List I will be able to update the PivotTable (right click on the PivotTable then click “Refresh”).

Where does the connection live?

Like all other data connections in our work book we can access it by selecting the “Existing Connections” button under the “Data” tab.

We can see that our SharePoint List connection is shown under “Connections in this Workbook” and can now be used to create new PivotTables.

Multiple Microsoft Office Excel Web Queries can be used to monitor more than one SharePoint list at a time as well as to easily analyze the data in them using PivotTables and PivotCharts. The same as with all Office Data Connections you can now use this connection with multiple workbooks and update any connection changes in a single place.

Microsoft Office SharePoint Designer 2007

Friday, September 12th, 2008

Office SharePoint Designer 2007 provides the powerful tools you need to deliver compelling and attractive SharePoint sites and quickly build workflow-enabled applications and reporting tools on the SharePoint platform, all in an IT-managed environment.

1. Be more productive with next-generation Microsoft Web technologies.
Enjoy a new level of support for creating and customizing next-generation SharePoint Web sites and technologies. Microsoft Office SharePoint Designer 2007 has deep editing support for the technologies underlying Microsoft Windows SharePoint Services technology, such as ASP.NET 2.0, cascading style sheets, and Microsoft Windows Workflow Foundation.

2. Customize SharePoint sites exactly the way you want.
Choose the format and content of your SharePoint pages with Office SharePoint Designer 2007 — the customization tool for the entire SharePoint family. You can tailor SharePoint sites to your needs and set brand requirements using the latest ASP.NET technology, established Web standards such as XHTML, and cascading style sheets.

3. Easily make or undo changes across entire SharePoint sites.
Make format and layout changes to entire SharePoint sites simply by editing the master page and modifying the SharePoint cascading style sheets. Undo changes to the home page using the Revert to Site Template Page command in Office SharePoint Designer 2007.

4. Maintain control over site customization.
Site administrators and IT managers can control exactly how Office SharePoint Designer 2007 is used to help ensure information workers have an IT-managed and -compliant experience. Set up Contributor Settings for each role defined in the SharePoint site, and control access to specific actions.

5. Create workflows to automate business processes.
Automate business processes associated with SharePoint lists and document libraries using the Workflow Designer, a powerful and easy-to-use tool that comes with Office SharePoint Designer 2007. Set up custom workflow conditions and actions, link them to your SharePoint data, and deploy them with a single click, without installing server code.

6. Create interactive Web pages without writing code.
Office SharePoint Designer 2007 has a full set of tools to help you integrate data into SharePoint pages and present that data using XSLT in SharePoint sites. You can access tools for using XSLT Data Views, List View Web Parts, Web Part connections, ASP.NET controls, and workflow.

7. Integrate business data.
Create views and forms for working with a variety of data sources using tools supported by Office SharePoint Designer 2007. Build SharePoint Web pages that present and edit data coming from SharePoint lists and document libraries, XML files, Microsoft SQL Server databases, Web services, and enterprise systems.

8. Develop sites compatible with a wide range of browsers and Web standards.
Office SharePoint Designer 2007 has excellent support for creating Web pages based on Web standards such as XHTML and cascading style sheets and meeting Web accessibility requirements for Web Content Accessibility Guidelines WCAG and Section 508 (29 U.S.C. 794d), including built-in compatibility checkers for these standards.

9. Build advanced ASP.NET pages.
Office SharePoint Designer 2007 supports creating and editing ASP.NET pages. It provides the same level of support as Microsoft Visual Studio 2005 for ASP.NET control hosting, property editing, toolbox, and Microsoft IntelliSense technology in Code View.

10. Manage and help protect your site.
Use reports in Office SharePoint Designer 2007 to help manage your site by checking for broken links, unused pages, cascading style sheets usage, and master page usage. Site backup and restore features make it easy to save your site to a single file for helping to protect data or moving it to another server running Windows SharePoint Services technology.

About Microsoft Office

We’ll be discussing Microsoft Office products, the suites, updates and upgrades, tips and tricks. There are wonderful programs that Microsoft has come out with, especially Word, Excel and Outlook. There are programs for everyone out there, from home and student workers, small businesses and corporations. So, keep in contact, watch this space, as the saying goes, contact me with your tips, comments

Microsoft Office Author(s)
    » Brick-ONeil

Technology Channel Posts

  • How far do you go to be Green?
    Recycle, reduce and reuse are the hallmarks of the "Green Living" lifestyle and ecoists. There are many useful and easy to embrace ideas in going "Green". Such as recycling paper, metals, [...]
  • Expert: Microsoft Earned $1.5B From Vista Capable Program
    An expert has determined that Microsoft may have earned more than US$1 billion from its controversial Windows Vista Capable sticker program, which is still at the center of a class-action suit being [...]
  • Motorola Aura
    This new stainless steel handset is designed after luxury watches and defines artistry in the way mobile units are made and manufactured. The craftsmanship to this is unbelievably distinct. It [...]
  • The New Kids are taking Over: IE Lost Share to Firefox, Safari and Chrome in December
    Web sites saw visitors deserting Microsoft's Internet Explorer browser in favor of Apple's Safari, Mozilla's Firefox and Google's Chrome in December, according to Web analytics company Net [...]
  • A small update to the OneNote Table of Contents Powertoy
    John Guin has an update for OneNote:Over the in the OneNote Discussion Group, Mike made this request for a change to the Table of Contents Powertoy: "I have downloaded and used the TOC power toy. [...]
  • Servers Back Up on 451 Press
    Apologies for no new posts the past two days, the 451 Press Servers were offline due to a glitch. The little hamsters that power the wheels took a rest and are now fully charged and ready to go. [...]
  • Servers Back Up on 451 Press
    Apologies for no new posts the past two days, the 451 Press Servers were offline due to a glitch. The little hamsters that power the wheels took a rest and are now fully charged and ready to go. [...]
  • Happy New Year!
    I wish everyone a Happy New Year! Regular posting will resume this Monday. Thanks for continuing to visit this site. [...]
  • Tough sentences in China over huge piracy ring: Microsoft
    A Chinese court has issued tough sentences to members of a huge software counterfeiting ring, which distributed more than two billion dollars' worth of fake Microsoft goods, the company [...]
  • Office hours: Web life for grownups
    From the Office Hours Blog: Next time you're in a meeting listening to a manager who looks younger than your cat detail your role in your company's Social Media Future (aka Web 2.0), consider this: [...]

Hot Off The Press

  • Back-to-Back Fashion Miss for Kate Hudson
    Can you imagine a star donning on a back-to-back fashion miss all for one day? I guess we ought to ask Kate Hudson about that. Why she just deliberately failed to impress the fashion critics [...]
  • John Pelphrey press conference - Texas
    The Razorbacks and No. 7-ranked Longhorns tip off at 8:05 p.m. Tuesday from Bud Walton Arena. [...]
  • Random Wordbank Wednesday
    Hello once again everyone! Welcome to another mid-week random word bank. Unlike the 'contemplating' which prompts you or 'musical Monday' that inspires you, these wordbanks serve as a way to not [...]
  • On The Other Hand...
    The other pathway to knowledge would seem less amenable to logical processes. There are times when we simply 'know' something. Psychology has tried to tell us it's because much of our input is [...]
  • Guest Author Sandi Kahn Shelton on Finding Time to Write
    Sandi Kahn Shelton, author of 'Kissing Games of the World' is joining us here today to talk about a facet of our focus for the beginning of 2009 - getting that novel written. I hope you'll join me in [...]
  • Gimmicks, False Marketing, and Weight Loss
    After my experience of violently reacting to metformin (a very rare reaction, I’m told), saying that I’m ‘cautious’ about weight loss products is a huge understatement. Today I found a [...]
  • Anne Hathaway at the Palm Springs International Film Festival Awards Gala
    Since appearing as Mia Thermopolis in Disney’s The Princess Diaries, I can honestly say that I am an Anne Hathaway fan. However, since I promised for the New Year that Celebrity Fashion [...]
  • John Corbett....
    Technorati Tags: John Corbett,Chris in the Morning,Chris Stevens,Northern Exposure,Carry Bradshaw,Aiden,Sex and the City,Nia Vardalos,My Big Fat Greek Wedding,Bo Derek,The Wonder [...]
  • One Size Fits All
    I remember one Christmas, way too many years ago, when all I wanted was a baton. I was about 8, and wanted to be a majorette in the worst way. My Dad told me there was no way I was going to get a [...]
  • The Astrology of Fixed Stars: Much Ado About Algol
    January 7, 2009 Hello My chart is a bit confusing. I hope if you have any insight on it. It's full of good aspects (sun-moon trine, jupiter-saturn conjunction, moon conjunct midheaven and leo [...]