January 15, 2014 – As a data engineer at her “day job,” PASS VP of Marketing Denise McInerney has a special affection for business analytics. We caught up with her ahead of Feb. 5’s 24 Hours of PASS: Business Analytics Edition to see what she’s looking forward to at the free day of online business analytics learning.
Podcast: Listen to Denise talk more about business analytics, business intelligence, and PASS’s upcoming training opportunities in this podcast interview with SearchSQLServer.com.
What is 24 Hours of PASS: Business Analytics Edition?
24 Hours of PASS: BA Edition (24HOP: BA) is a day of free, live, back-to-back webcasts on how to get the most from your data, presented by some of the most knowledgeable and top-rated speakers from the world of business analytics and business intelligence. This edition features 12 live sessions – each with its own Q&A segment – followed by 12 hours of on-demand replay in case you miss a session or want to rewatch your favorites.
Thanks to our sponsors – Microsoft, Cisco, Confio, Dell Software, and SQL Sentry – we’re able to bring 24 Hours of PASS: BA edition to BA and BI professionals at no cost. In true PASS fashion, it’s a great community event that brings data professionals from around the world together to connect, share, and learn.
In the week since registration opened, each 24 Hours of PASS: BA session already has at least 700 registrations. So we’re looking forward to a blow-out event!
What will the sessions cover?
The sessions will cover best practices and the latest tips on everything from data analytics and visualization, predictive analytics, and data science to Big Data and information delivery, strategies, and architecture. We have sessions on Excel 2013, Power BI and Power Query, the Enterprise Data Warehouse, Parallel Data Warehouse, querying in DAX, data visualizations in SQL Server Reporting Services, and more.
And whether you’re a BA/BI novice or ready for advanced techniques, we have a session for you. I love it that we have “Predictive Analytics for Absolute Beginners” – our most popular session so far – as well as “Advanced Analytics in Excel 2013.”
Who should attend?
If you’re passionate about business analytics, this event is for you: data and business analysts, data scientists, data architects, BI professionals, IT pros… Whether you’re already working in analytics or looking to make a transition or just learn more about this fast-changing industry, you’re going to come away with practical information that you can use right away for managing, analyzing, and sharing business information and insights.
What’s your favorite part of 24 Hours of PASS?
For the past 2 years, I’ve been responsible for PASS’s online training opportunities as Director of Virtual Chapters and 24 Hours of PASS. And although as PASS VP of Marketing I’m no longer directly in charge of 24 Hours of PASS, I still feel a special connection to the event.
Since 2009, 24 Hours of PASS has grown into a well-known and well-loved event in the SQL Server community. And what’s not to love? Excellent content from top experts in the field delivered directly to your computer – wherever you’re located in the world – for free.
I’m thrilled that we’ve expanded this valuable training opportunity to BA and BI professionals. At last year’s first 24HOP: BA event, we saw almost 30,000 registrations across 89 countries. It’s just a fantastic complement to the free online learning that our Business Analytics, BI, Big Data and other Virtual Chapters provide throughout the year, as well as a great preview event in the lead-up to the upcoming PASS Business Analytics Conference in May.
What is 24HOP: BA’s relationship to the PASS BA Conference?
All 24HOP: BA speakers will also be delivering in-person sessions at the PASS BA Conference May 7-9 in San Jose, CA. So it’s a nice sneak peek at the world-class business analytics sessions and speakers who will be on tap there. If you enjoy 24HOP: BA, you’re going to love the BA Conference.
When is 24HOP: BA again?
Please join us from the comfort of your office, home, or home office on Wednesday, Feb. 5, beginning at 8am PT (11am ET, 16:00 GMT) for a great day of business analytics learning. Tell your friends, and make sure you follow us on Twitter at @PASS24HOP / #pass24hop for all the latest updates.
How do you register?
Seating in the virtual meeting room is limited, so you’ll want to register now and make sure you’re in the session early the day of the event. From the website, just select the individual sessions you want to register for – or like some die-hard attendees who attend them all, click “Select All” – and then click Register. You’ll receive an email confirmation containing your meeting access links and can add the events to your calendar through the iCal links.
I’m looking forward to having as many business analytics professionals as possible join us for this great online event. Make sure you register today!
January 7, 2014 – The 2013 elections cycle highlighted some issues with how ballots are generated for the annual PASS Board of Directors elections. Historically, all PASS members – identified as those for whom we have a unique email address – have been eligible to vote. Under this broad definition, however, it is common for members to have multiple unique email addresses in the system and to thus receive multiple ballots.
In an effort to reduce the number of duplicate ballots sent out, the PASS Board has established more specific eligibility requirements for voting. In a recent meeting, the Board agreed that to receive a ballot, members must have a completed PASS profile.
PASS has added new fields to the myProfile section of sqlpass.org to help us better serve the community. The additional information will also help us de-dupe member data for eligible voters before sending ballots. As part of a new membership drive, we are encouraging all members to update or fill out their profiles and review them for completeness and accuracy.
All members who complete their profiles – including the new fields – by June 1, 2014, will receive a ballot to vote in the PASS elections, with one caveat: All completed profiles will be checked for duplication, and those identified as duplicate will be eliminated from the ballot send out.
Looking forward to your feedback on this change in voter eligibility, and please complete or set up your profile as soon as you can!
Immediate Past President
January 7, 2014 – 2013 was a wonderful year for PASS. We grew in service to data professionals around the world across many areas – adding 31 local PASS Chapters, six new Virtual Chapters, and the inaugural PASS Business Analytics Conference – and welcomed over 16,000 new members. With 2013 now in our rear-view mirror, it’s time to look at what lies ahead for PASS.
Before we dive into the coming year, I want to thank Rushabh Mehta, Douglas McDowell, and Rob Farley for their many years of service to the PASS community as they leave the Board of Directors. Their hard work and dedication will be sorely missed.
Let’s also take a moment to welcome the new Directors joining the Board for 2014-2015: Amy Lewis, Jen Stirrup, and Tim Ford. Amy will be taking over PASS Programs, Jen will lead Virtual Chapters, and Tim will be responsible for the SQLSaturday portfolio. You can read about all the Board portfolio assignments on the PASS blog.
As PASS continues to grow, the Board understands the need for Directors to shift away from their historical role as “doers” and toward setting direction through strategic thinking. We have been taking measured steps as part of this transition. And after the 2013 elections, I shared the vision that myself, Adam Jorgensen, and Denise McInerney have for PASS as your Executive Committee (ExeCo).
Vision statements are good, but actions are better. So to start, every Board member is outlining their portfolio tasks so that we make certain they roll up to our higher-level goals and that we hold each other accountable. In my years on the Board, we have had a lot of great ideas but struggled with follow-through and accountability. We are aiming to change that in 2014.
I’ve asked all Board members to submit their goals for 2014 before Jan. 13. The ExeCo will then review the goals before the Board’s January in-person meeting and provide feedback about any tasks not aligned with the overall vision.
With your help – and the leadership of dedicated Board members – I’m looking forward to hitting the ground running this year.
Let’s make 2014 a year to remember, together.
December 19, 2013 – As CA announced at PASS Summit 2013, it has relinquished its two Founding Partner seats on the PASS Board of Directors, currently held by Rick Bolesta and Neil Buchwalter. A 1999 founding partner member of PASS along with Microsoft, CA has witnessed the organization’s membership grow to 100,000+ data professionals over the past 14 years, and we thank CA, Rick, and Neil for all their support and contributions. Read more about CA and its relationship with PASS.
In light of CA’s departure, the Board has revised the PASS bylaws to address the company’s vacant vendor-appointed seats. The proposed bylaw changes amend Section VI.2., Composition and Qualifications, to reduce the number of both voting Directors and vendor-appointed Directors and to remove CA from appointing vendor-appointed seats.
The proposed bylaw changes are open for member review now through Wednesday, Jan. 22. Please take a few minutes to read over the changes and send any comments or questions to email@example.com.
The Board will be discussing your feedback at its January in-person meeting. Once finalized and approved by the Board, the updated bylaws will be posted on the PASS Governance page.
– Bill Graziano
December 10, 2013 – Congratulations to all PASS local Chapters that helped refer their members to PASS Summit 2013. Sixty-nine Chapters participated in the program and earned anywhere from $50 to $1000 for their respective Chapters. Gift cards will be sent to each participating Chapter leader early next week. Find out how much your Chapter earned:
Chapter Amount Chapter Leader
Atlanta Business Intelligence Group $450 Teo Lachev
Atlanta SQL Server User Group; Atlanta Microsoft Database Forum $500 Donald Wert
Belgian SQL Server User Group $50 Frederik Vandeputte
Calgary PASS $150 Noel Tan
Canada - British Columbia (Vancouver) $100 Richard Baumet
CBusPASS $100 Dave Schutz
Central New Jersey SSUG $100 Linda Zhang
Central PA SSUG $100 Dustin Jones
Charleston SQL Server User Group $50 Ryan McKnight
Charlotte BI Group $350 Jason Thomas
Charlotte SQL Server User Group $200 Peter Shire
Chicago SQL BI User Group $150 Marcello Benati
Chicago SQL Server User Group $500 Aaron Lowe
Cincinnati PASS $50 Anthony Mattas
Denver SQL Server User Group $250 Steve Wake
Eugene Area SQL Server User Group $50 Dan Guzman
FoxPASS $150 Jes Borland
French SQL Server User Group/Groupe des Utilisateurs
Francophone de Microsoft SQL Server (France) $150 Arian Papillon
Hampton Roads SharePoint and SQL Users Group $50 Susan Lennon
Houston Area SQL Server User Group $1,000 Nancy Hidy Wilson
IndyPASS $650 Ray Lucas
Inland Empire SQL Server User Group $50 Shannon Shields
Iowa SQL Server User Group $250 Juan M. Moya
Israeli SQL Server User Group $150 Guy Glantser
Jacksonville SQL Server Users Group $150 Devin Knight
Kansas City SQL Server User Group $300 Andrew Cross
KnoxSQL - SQL Server User Group $250 Arlene Gray
Louisville SQL Server User Group $50 Dave Fackler
Malibu SQL Server User Group $150 Steve Rezhener
Microsoft Business Intelligence Community (MSBIC) $50 Greg Taylor
Microsoft Business Intelligence User Group of South Florida $200 Luis Figueroa
Midlands PASS $50 Kenneth Brian Kelley
Minnesota Microsoft BI User Group $450 Dan English
Minnesota SQL Server User Group $750 Paul Timmerman
Nashville SQL Server User Group $100 Tamera Clark
Netherlands Antilles (Curacao) $50 Roy Ernest
New England SQL Server Users Group $100 Adam Machanic
New Jersey SQL Server User Group $100 John Dempsey
North Texas SQL Servers Users Group $650 Sri Sridharan
Northern Virginia SQL Server Users Group $250 Jim Rotan
Oklahoma City SQL Server Developers Group $350 Kristin Ferrier
Olympia Area SQL Server User Group $100 Greg Larsen
Omaha SQL/BI User Group $200 John Morehouse
Oregon SQL $50 Arnie Rowland
PASS DC $50 Chris Bell
Philadelphia SQL Server User Group $800 Vince Napoli
Pittsburgh SQL Server Users Group $50 Gina Walters
Portland SQL Server User Group $200 Ken Starnes
Quad Cities PASS Chapter $350 Sheila Acker
Rochester PASS $100 Matt Slocum
Russian SQL Server User Group $50
Sacramento SQL Server User Group $150 Mitch Bottel
Salt Lake City SQL Server User Group $100 Pat Wright
San Antonio SQL Server User Group $100 Jim Steiner
Southwest Missouri SQL Server Users Group $100 Anthony Young
SQL PASS Edmonton $100 Harry Zheng
SQLPASS in Detroit $150 Joseph Fleming
St. Louis SQL Sever User Group $100 Julie Bloomquist
Steel City SQL User Group $50 John Baldwin
Tampa Bay SQL User Group $50 Jose Chinchilla
Toronto SQL Sever User Group $100 Karen Lopez
Triad SQL Business Intelligence User Group $300 Katherine Fraser
Triad SQL Server User Group $50 Kevin Goode
Triangle Area SQL Server Users Group $50 Brett Tomson
Victoria SQL Server User Group $1,000 Jonathan Mears
Wellington SQL Server User Group $50 David Curlewis
West Michigan SQL Server User Group $200 Josh Fennessy
Wichita SQL Server User Group $50 Patrick Purviance
Winnipeg SQL Server User Group $50 Michael Defehr
All current PASS Board members were on stage to help answer questions from the community. Here’s a quick recap of the top three questions and answers:
Q: There are concerns in the community that duplicate votes occurred in the recent PASS Board elections. How did PASS review the votes, and how did this affect the election results?
A: The election results remain unchanged even when taking duplicates into account. Eligible voters were determined by unique email address and date entered into the system. All submitted ballots were compared to registration lists for paid PASS events. Duplicate ballots were discovered based on first name, last name, and address. Ballots were also compared to our membership data (people who fill in the member profile on sqlpass.org), and additional duplicates were uncovered based on identical first and last name and identical voting pattern.
Q: What are PASS’s plans to host another Summit event outside of the Seattle area?
A: This Summit in Charlotte, NC, is the first time we’ve been out of Seattle since 2007! It has been a great success, but we are going to spend some time analyzing the pros and cons of hosting outside of Seattle before we decide to move to different locations. Booking facilities for events of this size happens years in advance, and we are booked in the Seattle area for the next 3 years.
Q: There was some confusion among PASS Chapter leaders about how to reach out to local SQLSaturday event registrants.
A: Any Chapter Leader involved in organizing a SQLSaturday event may use the SQLSaturday sponsor opt-in list to append registrant contact information to their Chapter email list.
Cross-posted from my blog
October 14, 2013 – As I type this, I’m on an airplane en route to my 12th PASS Summit. It’s been a very busy 3.5 months since my last post on my work as a Board member. Nearing the end of my 2-year term, I am struck by how much has happened, and yet how fast the time has gone.
But I’ll save the retrospective post for next time and today focus on what happened in Q3. In the last three months, we made progress on several fronts, thanks to the contributions of many volunteers and HQ staff members. They deserve our appreciation for their dedication to delivering for the membership week after week.
The Virtual Chapters continue to provide many PASS members with valuable free training. Between July and September of 2013, VCs hosted over 50 webinars with a total of 4300 attendees.
This quarter also saw the launch of the Security and Global Russian VCs. Both are off to a strong start, and I welcome these additions to the Virtual Chapter portfolio.
At the beginning of 2012, we had 14 Virtual Chapters. Today we have 22. This growth has been exciting to see. It has also created a need to have more volunteers help manage the work of the VCs year-round. We have renewed focus on having Virtual Chapter Mentors work with the VC Leaders and other volunteers. I am grateful to volunteers Julie Koesmarno, Thomas LeBlanc, and Marcus Bittencourt, who join original VC Mentor Steve Simon on this team.Thank you for stepping up to help.
Many improvements to the VC websites have been rolling out over the past few weeks. Our marketing and IT teams have been busy working a new look and feel, features, and a logo for each VC. They have given the VCs a fresh, professional look consistent with the rest of the PASS branding, and all VCs now have a logo that connects to PASS and the particular focus of the chapter.
24 Hours of PASS
The Summit Preview edition of 24HOP was held on July 31 and by all accounts was a success. Our first use of the GoToWebinar platform for this event went extremely well. Thanks to our speakers, moderators, and sponsors for making this event possible. Special thanks to HQ staffers Vicki Van Damme and Jane Duffy for a smoothly run event.
Coming up: The 24HOP Portuguese Edition will be held November 13-14, followed December 12-13 by the Spanish Edition. Thanks to the Portuguese- and Spanish-speaking community volunteers who are organizing these events.
July Board Meeting
The Board met July 18-19 in Kansas City. The first order of business was the election of the Executive Committee who will take office January 1. I was elected Vice President of Marketing and will join incoming President Thomas LaRock, incoming Executive Vice President of Finance Adam Jorgensen ,and Immediate Past President Bill Graziano on the ExeCo. I am honored that my fellow Board members elected me to this position and look forward to serving the organization in this role.
Visit to PASS HQ
In late September, I traveled to Vancouver for my first visit to PASS HQ, where I joined Tom LaRock and Adam Jorgensen to make plans for 2014. Our visit was just a few weeks before PASS Summit and coincided with the Board election, and the office was humming with activity. I saw first-hand the enthusiasm and dedication of everyone there. In each interaction I observed a focus on what is best for PASS and our members. Our partners at HQ are key to the organization’s success. This week at PASS Summit is a great opportunity for all of us to remember that, and say “thanks.”
PASS Summit—of course! I’ll be around all week and look forward to connecting with many of our members over meals, at the Community Zone, and between sessions.
In the evenings, you can find me at the Welcome Reception, Exhibitor’s Reception, and Community Appreciation Party. And I will be at the Board Q&A session Friday at 12:45pm.
The newly elected ExeCo and Board members take office January 1, and the Virtual Chapter portfolio is transitioning to a new director. I’m thrilled that Jen Stirrup will be taking over. Jen has experience as a volunteer and co-leader of the Business Intelligence Virtual Chapter and was a key contributor to the BI VC's expansion to serving our members in the EMEA region. I’ll be working closely with Jen over the next couple of months to ensure a smooth transition.
October 11, 2013 – With the PASS Board of Directors elections completed and thousands of community members and volunteers gathering at PASS Summit 2013 in Charlotte next week, it’s time to meet your Board portfolio leaders for the coming year. It’s been a pleasure, as one of my first tasks as incoming PASS President, to match up Directors with the project portfolios where they can put their skills, experience, passions, and energy to best use.
Here are the portfolios for 2014:
- James Rowland-Jones led our Global Growth portfolio over the past year, helping us gather feedback and lay the groundwork for better supporting the global community, including converting two seats on the PASS Board to regional seats. JRJ will remain with Global Growth and also lead Special Projects.
- Sri Sridharan began his term on the Board last year with the reinstated Volunteers portfolio and will continue the important tasks of growing PASS’s volunteer pool, better organizing volunteer efforts, and recognizing volunteers’ valuable contributions.
- Wendy Pastrick will continue leading our Global Chapters portfolio, working to grow and support local user groups with a great team of Community Evangelists and Chapter Leaders and Regional Mentors throughout the world.
- Amy Lewis, newly elected to the Board, will begin her term heading up the Programs portfolio. Working with Director Adam Jorgensen, Amy has served as co-manager of PASS Programs for 2 years, helping improve processes and lead the team that selects sessions for PASS Summit and the PASS Business Analytics Conference.
- Jen Stirrup, elected to the new EMEA regional seat on the Board, will put her experience as PASS BI Virtual Chapter co-leader to valuable use in guiding the Virtual Chapters portfolio.
- Tim Ford, elected to the new US/Canada regional seat, will take over the SQLSaturday portfolio. A passionate SQLSaturday supporter, Tim organized Kalamazoo, MI’s first SQLSaturday. Over 80 SQLSaturdays were held throughout the world in FY2013, and we’re expecting continued growth of these popular free, 1-day training events as we focus on meeting the needs of even more data professionals around the globe.
The 2014 PASS Board also includes the PASS Executive Committee – consisting of myself; Executive VP, Finance, Adam Jorgensen; VP, Marketing, Denise McInerney; and Past President Bill Graziano – and Founding Partner Board members from CA and Microsoft.
The transition to new assignments is underway, and new portfolio leaders will be meeting with community leaders and volunteers at Summit to get a jump-start on their projects. Make sure you say “Hi” at Summit, join us at the Board Q&A on Friday, Oct. 18, and volunteer to pitch in on your favorite projects. We can’t wait to get down to business!
– Thomas LaRock
October 4, 2013 – The PASS Anti-Harassment Policy (AHP), adopted in 2012, continues to be in effect this year at PASS Summit 2013, helping ensure that all attendees feel welcome and safe at the conference.
One of the cornerstones of PASS is our sense of community, and the AHP furthers our goal of inclusion, standing behind the right of all who come to our event to experience a harassment-free Summit.
PASS is a leader among technical organizations for its promotion and support of women. Our AHP further demonstrates our leadership in this area.
Other technical conferences have had incidents of harassment and inappropriate behavior. Most of these did not have a policy in place prior to having a problem. In addition to making all attendees aware of our policy and what is appropriate behavior at Summit and other events, having the AHP means PASS will be prepared should there be an incident.
Alleged violations of the AHP should be reported to any member of the conference staff, who will then contact the Duty Officer, a designated member of the staff responsible for taking a full report. The Duty Officer will notify the Anti-Harassment Review Committee (AHRC) of the complaint.
The AHRC is the body authorized by the PASS Board of Directors to take action in response to a violation of the AHP. The process document provides guidelines for how the AHRC will conduct its inquiries.
PASS members can be confident that all parties will be treated fairly and with sensitivity. All AHRC activities will be conducted with the utmost discretion.
Having an anti-harassment policy demonstrates our commitment to providing a professional, positive atmosphere at Summit. Everyone at Summit is expected to follow the policy. We ask that any attendee who experiences or witnesses harassment contact a member of staff so that any issues can be addressed.
October 3, 2013 – PASS is aware of the issue around duplicate ballots in the most recent election. After voting closed, PASS reviewed and analyzed all submitted ballots, and we confidently stand behind the final election result. We are also actively discussing ways we can improve the process prior to the next election cycle. Please bring your questions and ideas to the Board Q&A on Friday, Oct. 18, at PASS Summit. If you can’t attend, feel free to submit your questions the week of Summit (Oct. 15-18) via Twitter using #passvotes or email us at AskBoD@sqlpass.org.