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.

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.


Create a great Windows 8 app

Begin your 30-day journey to create a great Windows 8 app. Get started here and receive:
• Insider tips and tricks on Windows 8 application development.
• Personal on-the-phone access to a Windows 8 architect*.
• An exclusive one-on-one design consultation*.
• An opportunity to get expert help from a Microsoft Services Engineer at an App Excellence Lab.
Your new Windows 8 app could be mere days away.

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


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

§ Open Excel

§ Create a new Blank Workbook


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




§ 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


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.




Warm Up With ASAE’s Greater Washington Network Happy Hour

Do you really need a reason to get out of the office and network with ASAE’s 8,000 GWN contacts? Come to our 2/09/12 happy hour at DC’s hotspot Station 4. #ASAE. Free entry and appetizers. Near metro.

Who:  There are 8,000 members in ASAE’s Greater Washington Network. It’s a mix of association professionals at all levels and those who work with them. Many of them show up at the Happy Hours.

What: ASAE’s Greater Washington Network Happy Hours. Held several times a year.  A great, free way, to make new connections and catch-up with old. Join us for the next one on February 9th, 2012.

Where: Station 4 on the SW waterfront. Rated 3-4.5 stars by Yelp and others. Elegant, great bar, cool food. Walk from the green line Waterfront Metro Station.

When: Thursday February 9th, 5:00 – 7:00 PM.

Why: Do you really need a reason to expand your association connections? Career, career, career.

How: Here’s a link to get more information, for tweeting, LinkedIn posting, etc.

About Station 4

Revitalizing the SW waterfront at 1101 4th St. SW, near Arena Stage.

Close to the metro and a short walk from Waterfront Metro Station on the Green Line.

Fun place to network and a trendy take on American food. Elegant, fun and a great bar.

Thursday night, February 9th, from 5:00 – 7:00 PM.


More about the ASAE Superswap on July 20, 2011 at 10:00 am

Learn from other association professionals and share your knowledge about marketing, technology, and member engagement at the next Superswap brought to you by the ASAE of Greater Washington. This program mixes professional development, networking with peers, and great conversation in the association community.
Share some of the following details about the Superswap:
• The next Superswap takes place on July 20th, 10:00 AM, at the ASAE Conference Center, in downtown DC, on I Street.
• The July Superswap features sessions on marketing, technology and professional development.
• The Superswaps are designed to provide peer-learning, but also opportunities to see old friends and colleagues in the Association Community.
• Lunch is served between our morning and afternoon session.
• Superswaps are planned and sponsored by the ASAE of Greater Washington.

How to Structure, Mobilize and Motivate Volunteers to Maximize Member Engagement and Retention
Laurie Kulikosky, CAE is currently director of strategic development at the American Society of Transplant Surgeons. She was formerly senior manager, membership development at the Consumer Electronics Association. She went to Uva and currently serves on the ASAE Membership Section Council.
Kevin Whorton is a former association exec responsible for working with volunteers at NAHB and ASHP, and has been a volunteer and has chaired special interest groups, conferences, fundraising and membership for ASAE, DMANF, and HomeAid NYC.
Session Description:
In every association, our work as staff is supplemented by another, much larger and fragmented workforce—those who volunteer to help us.
How can we work with this amorphous blob to maximize their efficiency in helping us—and to engage them properly to build relationships that will enhance their careers and strengthen member-staff relationships?
In this discussion we’ll work with case studies & examples—yours and ours—and leverage some of the lessons of Decision to Volunteer and other lessons from the association and not-for-profit communities.
You’ll leave with at least five tips on how to better work with your volunteers for the good of the order.


Virtual? Face to Face? Hybrid? What is the education model of the future?
Carol Hamilton, Senior Director, Training Services, AFSA: Association of International
Greg Ruby, holds five professional industry certifications: Certified Meeting
Professional (CMP), Certified in Exhibitions Managment (CEM), Certified Association
Sales Executive (CASE), Certified in Meetings Management (CMM),and Certified
Tourism Ambassador (CTA). In addition to belonging to IAEE, Greg is a member of the Professional Convention Management Association (PCMA), Meeting Professionals International (MPI), American Society of Association Executives (ASAE), Green Meetings Industry Council (GMIC) and the Trade Show Exhibitors Association (TSEA).
Greg currently serves as a member of IAEE’s Expo! Expo! Advisory Committee, as well as serving on PCMA’s Social Media Task Force. Greg also volunteers his time for the Convention Industry Council (CIC), helping to review CMP applicants and helping draft “green” standards for meeting venues as part of their APEX Green Meetings & Events Practices Panel.
Session Description:
As demographics and budgets change, professional development delivered by Associations is undergoing a transformation. With this trend, decision-makers will need to answer some key questions about the future of professional development. What will be the desire to meet face to face versus virtually? How will hybrid meetings (a blend of face to face and virtual) be used to engage different audiences? Join your colleagues to explore options and learn from success what works and what the future may hold for different methods of education and professional development delivery.


Attendee Marketing: How do we get butts in seats?


Dave Martin, Vice President – Marketing & Content, Electronic Retailing Association

Scott Oser, Scott Oser Associates

Session Description:

Getting your target audience to attend your meetings is not as easy as it once was. Come share your marketing struggles and successes to butts in seats.


Cultivating Win-Win Relationships with Your Volunteers


Cathy Smalley Pales,President, Powerful Purpose Leadership, LLC.

Session Description:

Association members become volunteers for a variety of reason, including the fulfillment of personal and professional needs. Your association also has needs to be addressed. How well are your association’s needs and the needs of volunteers aligned? Come to this session prepared to share and hear success stories as well as learning practical strategies for needs alignment.


Tales from the Bleeding Edge: When Should You Upgrade Technology?


Marianne Woehrle, Director of Information and Technology at CTAM

James Marquis, ClassFive

Session Description:

Technology upgrades can be a challenge, and sometimes produce unintended consequences. Join us for a conversation about things that might affect your decision to upgrade. What advice would you give others planning to update their CMS, Association Management System or Website?


Fad or Fantastic? Exploring the Merits of New Online Tools…

Session Description:

With so much hype about new tools and technologies circling the globe every day, it can be a challenge to separate “fad” from “fantastic.” Join us for a conversation about technology fads. Be prepared with a couple of favorite “fads” or “fantastics” and hear about others from your Association colleagues.


David Hollender , Chief Online Strategist, Mind Sky


ASAE Superswap will be on July 20, 10:00 AM, at the ASAE Conference Center, in downtown DC, on I Street

Join ASAE Greater Washington for another great Super Swap! This month we will create tracks for attendees to follow two swaps on the same functional topic to give you more time to exchange ideas with your peers. This half-day session includes six 90-minute swaps on various topics, with three swaps running concurrently in the morning and three in the afternoon. Morning refreshments and a networking lunch will be provided.

AM Swaps:

How to structure, mobilize and motivate volunteers to maximize member engagement and retention.

Virtual? Face to Face? Hybrid? What is the education model of the future?

Should you upgrade your technology? If I had only known.

PM Swaps:

How do we satisfy volunteers and the needs of the association?

Attendee Marketing: How do we get butts in seats? Scott Oser & Dave Martin

Fad or Fantastic? Exploring the Merits of New Online Tools.

Time:9:30 a.m. Registration opens
10:00 – 11:30 a.m. – Morning Swaps
11:30 a.m. – 12:30 p.m. – Networking Lunch
12:30 – 2:00 p.m., Afternoon Swaps
Fee: $19 members; $39 nonmembers
This minimal cost includes lunch and beverages throughout the day.

Attendance cancellations must be received within three business days before the program begins.

Non-members that attend can receive 15% off of a one-year ASAE membership when signing up at the event. Check with ASAE staff for an application.ASAE Superswap


Convergence in Atlanta 2011

The Microsoft Convergence conference in Atlanta is over and I have so much information and new ideas that I don’t know where to begin.  This is the seventh Convergence conference that I have attended with each one getting a little better than the last.  The GP Users group did a great job this year with sessions and interactive discussions.  I really felt that I it was a good investment of my time and money.

Talking to the Experts allowed me to get the information that I needed to connect and pull the correct data for my reports.  I found some great tips and tricks for Outlook that I can take back and show to staff. I learned about the ignore function, clean up conversation, quick link to one note and all about the quick steps.  I found a Microsoft Project manager that is going to help me with some outlook issues that I have not been able to get fixed.  I had a great time at the birds of a feather round tables networking with other GP users.

I also had some time to develop some great ideas for reports and new uses for SharePoint and Smartlist builder.

I can now install Management reporter and migrate our reports without using a vendor (this is a real money saver!)   I found out about the things that I will need to look out for and that I need to delete all the old reports before attempting the migration.

I can’t wait to get started on the new projects!