Full Day Workshop 9:00 am - 5:00 pm, Tuesday

WS 401 - Becoming a Master Power User in SharePoint and Office 365

Benjamin Niaulin - Sharegate

You may have discovered what’s in SharePoint and Office 365, listed the features and what they do or how you can benefit from them. But do you know how to use them and what the best way to implement them is?

This full day workshop not only covers what you have, but helps you learn how to use SharePoint and Office 365 as well as everything around them to best benefit your 'organization and empower you as a Power User.

  • Inside Out of a Team Site (Lists, Libraries, Content Types, Site Columns, Web Parts etc...)
  • Deep Dive into Search
  • Leveraging things like PowerApps to build mobile apps and forms as well as workflows
  • Basics of SharePoint Designer Workflows
  • Learning Dashboards with PowerBI connected to SharePoint

Take a day to master your role as a Power User for SharePoint and Office 365.

Level: ALL


Full Day Workshop 9:00 am - 5:00 pm, Tuesday

WS 402 - Beyond SharePoint Deployment: How Can IT Inspire, Motivate And Drive Sustainable Adoption?

Dux Raymond Sy - AvePoint
In most organizations today, SharePoint is nothing more than a glorified file share and while training is a critical component that can drive better adoption, it is not enough.
To make the most of your SharePoint investment, it is critical that your users take advantage of SharePoint's full capability to address their day-to-day business needs. The key to drive excitement, organizational buy-in and adoption is being able to provide relevant, business-contextual application that drives consistent, sustainable usage.
Join Dux Raymond Sy in this interactive workshop as he shares practical techniques on how you can drive sustainable SharePoint adoption in your organization.
In this workshop, you will learn how to:
  • Excite and inspire users with how SharePoint can support their daily business activities
  • Align business needs and SharePoint capabilities to deliver relevant business solutions
  • Identify training needs and delivery mechanisms
  • Implement gamification techniques as a learning strategy to motivate and encourage SharePoint usage
  • Groom champions from the business that can help promote the business benefits of SharePoint
  • Establish an effective SharePoint support structure for on-demand learning, peer to peer knowledge sharing and higher level technical assistance
  • Create a 12-month phased adoption program that facilitates change, empowers users and enables knowledge sharing within the organization

Level: Experienced

Full Day Workshop 9:00 am - 5:00 pm, Tuesday

WS 403 - Dashboards, in one day!

Treb Gatte - Tumble Road

Need to create stunning dashboards from your SharePoint data?

Yes you do! In this workshop, we’ll show you:

  • How should I approach my BI need?
  • What things should be considered when creating dashboards?
  • What are the best practices?
  • How much is this going to cost me to license?
  • What security aspects should concern me?
  • Why you should take this course

To save time and money, immediately and in the long run. Since we've been in your shoes before, we also discuss topics related to maintenance, implementation, security and design best practices.

According to Forrester, half of a department's annual reporting needs are ad hoc, which works out to be about 50 reports a year:

  • The fully loaded cost of an individual report is $3200-$6100
  • Each report can eat up up to 32 hours of time to develop and test
  • That's hundreds of thousands of dollars spent in throwaway report investment

Learn a faster, cheaper way to explore your data. Power BI is well suited to enable quick ad hoc reporting where you spend the majority of the time developing the data set, rather than the individual report. This helps you save money and reduces the cost of developing ad hoc reports.

Who should take this course

If your company uses Office 365 or SharePoint 2013/2016 and you are a:

  • Manager
  • Business Analyst
  • Power User
  • SharePoint Administrator
  • Consultant

Or if you work in these areas, you can definitely see value:

  • Marketing
  • Information Technology
  • Finance
  • Sales
  • Social Media

You need this class if you are expected to use data from Office 365 and SharePoint to do your job effectively. The class assumes no prior knowledge of Power BI and Data Concepts.

What is required for this class:

  • Install Microsoft Power BI Desktop on your laptop (recommended but not required)
  • We'll provide an Office 365 site for you to use for exercises

What you will learn:

In this training course you will learn how to create Production Dashboards using Power BI, from SharePoint list and document library data
You will learn how to use Power BI in a multitude of situations, including ad hoc analysis and the creation of formal dashboard.
You will learn about the Power BI components: Power BI Desktop, PowerBI.com, Power BI mobile applications and how they can be used with Office 365 and SharePoint
You’ll also receive an introduction into the core functions of Power BI; Data extraction, loading and transformation using Power Query Formula Language (“M”) and DAX.
You’ll receive some guidelines on how to extract Project data in fast manner
You will discover some data modeling practices that will ensure you have maximum flexibility in analysis. You'll also learn some visualization best practices to ensure you can tell your digital story effectively
You'll learn best practices for maintaining content with your organization
This course provides an end to end view of Power BI for Project reporting, so that you are able to use Power BI immediately for your needs

What you will get:

You'll get the tools to immediately get started on your design. You’ll receive:

  • Design spec that prompts the asking of the right questions
  • PowerPoint-based layout templates for dashboard paper prototyping
  • Tried and true BI design approach
  • 5 critical value-adds you will take back to your company
  • You'll have a jump start on a standard BI development approach
  • You'll deliver new insights into your data
  • You'll have a great understanding of how Power BI can be used and implemented
  • You'll learn techniques to make your dashboards perform well with SharePoint data
  • You'll gain insight into how others are leveraging Power BI within their companies


  • Introduction to Power BI
  • Gettin Data from SharePoint
  • Using Power Query M for Data Retrieval and Transformation
  • Data Modeling with DAX
  • Data Visualization Techniques
  • Content Administration and Deployment
  • Licensing and Planning Considerations 

Level: Introductory


Full Day Workshop 9:00 am - 5:00 pm, Tuesday

WS 404 - Mastering the SharePoint Framework

Andrew Connell - Voitanos

The new way Microsoft wants us to customize and extend SharePoint is to use the SharePoint Framework.

This model brings client-side development as a first class development model complete with packaging, deployment and real a full deployment lifecycle. But this model is very different from from what traditional SharePoint developers have been used to.

In this workshop you will learn what the SharePoint Framework is all about, what is involved in getting your environment setup to be productive and how to build custom components including client-side web parts and extensions. We will go from using no web frameworks to leveraging React, Angular, Vue.js, leveraging external services, performance tricks… you name it! This workshop is based on AC’s popular Mastering the SharePoint Framework online course… hey, if you register you’ll get a special deal on the course.

By the end of the day, you will be well on your way to being a SharePoint Framework Master!

Level: Intermediate


Full Day Workshop 9:00 am - 5:00 pm, Tuesday

WS 405 - Collaborating and Publishing Securely, Inside and Externally

Peter Carson - Envision IT

Microsoft’s modern SharePoint experience has really begun to come together. We started with new lists and libraries, then team and communication sites, and finally Office 365 groups. During this workshop we’ll go over how you can leverage these experiences to collaborate effectively both within and external to your organization, and securely publish content internally, to external users, and anonymously.
The chapters we’ll cover during this full day workshop are:

  • Overview of the modern sites and Office 365 Groups experience
  • Implementing a site request and provisioning process to provide governance
  • Light branding of your sites
  • Leveraging SharePoint Framework web parts to navigate to sites
  • Sharing your sites and groups with external users by leveraging Office 365 external sharing and Azure Active Directory B2B
  • Publishing your content from Office 365 to an Azure Website
  • Providing both anonymous and secure access to your Azure website

All the PowerShell, Azure Function, Flow, PowerApps, and SharePoint Framework code is published as an open source project. Coming out of the session, you’ll have a strong overview on how to build an Office 365 Intranet, an Extranet, and even a public website authored in Office 365 and hosted in Azure, plus the tools to make that happen.

Level: Advanced


Full Day Workshop 9:00 am - 5:00 pm, Tuesday

WS 406 - Cowboys versus Ninjas: A user adoption and innovation games workshop

Sarah Haase - US Bank

Driving effective user adoption for collaborative platforms like SharePoint and Office 365 is incredibly difficult. Most companies veer off-course, missing the opportunity to engage users, build internal communities and drive business engagement and value. The result: a muddle of unused SharePoint sites, negligible business buy-in and a maze of nested file repositories.

This full-day workshop explores common user adoption myths and explains the role social epidemics play in driving adoption of collaborative toolsets. You'll learn practical tips and tricks for engaging key user constituencies in your organization, learn key motivational techniques to drive technology adoption and explore how innovation games can help you drive shared understanding and build a unified vision.

By the time you complete this workshop,  you'll know how to inspire your SharePoint ninjas, channel your enthusiasts, wrangle your cowboys and work with (or around) your naysayers.

Level: ALL

Morning Workshop 9:00 am - 12:30 pm, Tuesday

WS 501 - Deep Dive into Content Types

Tom Robbins - Robbins Professional Group
Content Types are at the core of SharePoint.  Everything you create in SharePoint is based on some Content Type from Microsoft but you should create your own content types to help you organize and manage your data in ways that match how your business operates.

Content types enable you to organize, manage, and handle content in a consistent way across your sites. By defining content types for specific kinds of documents or information products, you can ensure that each group of content is managed in a consistent way. This Workshop explains basic concepts about content types, and will dive into how to build content types to enable implementation of business processes.

With most of the core features of SharePoint, including Search, using metadata, it’s critical for success that you understand and implement content types throughout. Is your Search struggling? Are you still using folders instead of metadata? Are you wondering why the move from network drives to SharePoint hasn’t realized the full power of the technology? You need to understand metadata and Content Types.

In this half day workshop, you will learn the basics and advanced topics around Content Types. You will learn to create content types that enable you to automate many typical business processes.

  • What are Content Types?
  • How do we create simple and complex Content Types to mimic our business content
  • Understand how to leverage Content Type Inheritance
  • Implement Information Management Policy on Content Types
  • Attach Workflow to Content Types to automate Approvals, Feedback gathering, and Disposition Approval
  • Attaching Content Types to Lists and Libraries for uniform deployment across Sites 
Level: Intermediate

Morning Workshop 9:00 am - 12:30 pm, Tuesday

WS 502 - A Beginner’s Guide to Client Side Development in SharePoint

Mark Rackley - PAIT Group

With the creation of SharePoint 2013's new SharePoint Hosted Apps and the continued momentum of companies moving to the cloud, Client Side development has quickly evolved from a once shunned technology into an essential skillset that all developers (especially SharePoint Developers) need to learn. In this workshop, attendees will be introduced to client side development in SharePoint learn essential skills that they can begin to use immediately.

Attendees will learn:

  • The pros and cons of client side development and how to get started
  • How to effectively interact with SharePoint using JavaScript to build powerful applications without the need for Visual Studio
  • What is jQuery and how to use it effectively
  • Debugging techniques that will stop you from wanting to pull your hair out
  • How to modify SharePoint’s default forms quickly and easily 
Level: Introductory

Morning Workshop 9:00 am - 12:30 pm, Tuesday

WS 503 - Get started with PowerApps and Flow

Knut Relbe-Moe - Valo Intranet

During this workshop I will show how to build some of the most used HR Forms with Powerapps to bring the applications to your mobile, and flow to for instance automatically send the applications to your manager for approval.

We will look into:
HR Forms:

  • Holiday application
  • Expense claim

IT Forms:

  • IT service request

In this workshop bring your laptop, create a Office 365 Trial account, to get you started, and we will create this applications together.

So if you plan to start to use Flow or Powerapps this session will guide you on the way.
Level: All

Morning Workshop 9:00 am - 12:30 pm, Tuesday

WS 504 - Site Collection Administrator Boot Camp

Scott Shearer - Haystax Technology

So, you just became a Site Collection Administrator – what now? Wondering how to set up security? Are your end users asking you to help automate business processes?

This workshop is designed to provide new SCAs and site owners with the skills they need to build, manage and maintain their sites and site collections.

Topics covered include:

  • SharePoint Security
  • Managing Users and Groups
  • List and Library features and maintenance
  • Out of the Box and Custom Content Types
  • Out of the Box SharePoint Workflows
  • SharePoint Designer Workflows
  • Site Structure
  • Site Templates
  • Governance Concepts
And more...

This demo-rich workshop is designed to provide you with ideas, tips and “how-to” knowledge that you can immediately implement. 

Level: Introductory


Afternoon Workshop 1:30 pm - 5:00 pm, Tuesday

WS 601 - Mastering PowerShell for Office 365

Vlad Catrinescu - Valo Intranet
Until you master PowerShell, you cannot have full control of your Office 365 tenant! PowerShell enables you automate boring tasks, and also gives you access to the more advanced settings that are not available in the Office 365 admin center. In this workshop, we will learn how to manage our users and licenses in Azure Active Directory, manage our SharePoint Online Sites, Exchange Online, Office 365 Groups as well as Skype for Business!

After finishing this workshop, you will be able to manage all the aspects of your Office 365 tenant, and automate multiple boring tasks.
Level: Intermediate

Afternoon Workshop 1:30 pm - 5:00 pm, Tuesday

WS 602 - A Deeper Dive into Client Side Development in SharePoint

Mark Rackley - PAIT Group

In this more in depth workshop, we’ll review the techniques learned in the earlier workshop and add on to them taking a deeper look at what you can do with Client Side Development in SharePoint. In this workshop users will learn:

  • How to use Third Party Libraries to take the SharePoint applications to the next level
  • How to use Custom Actions to deploy scripts across a site collection
  • How to use REST, CSOM, and SPServices to interact with SharePoint list data and create business logic 
Level: Intermediate

Afternoon Workshop 1:30 pm - 5:00 pm, Tuesday

WS 603 - The SharePoint Superhero: The SharePoint Business Analyst

Liz Sundet - Focal Point Solutions

If you already have a SharePoint BA role or looking to add one to your organization, this session will cover what should be expected of the Business Analyst and what falls outside the realm of the Business Analyst world. Learn some of the many tools and techniques that a business analyst uses every day to make their work valuable to the organization such as: Business Process Management, Mind Mapping, and Prototyping.

Finally, learn some of the skills and behavior characteristics to look for when developing a BA on your team to make your next SharePoint project a success. 

Level: Introductory

Afternoon Workshop 1:30 pm - 5:00 pm, Tuesday

WS 604 - SharePoint Deployment Planning

Stephanie Donahue - PAIT Group

Upgrading from a legacy version of SharePoint? Deploying SharePoint for the first time? Want to expand the use of your current environment?

Attend this workshop for a deep dive on all the critical items you need to cover during a SharePoint deployment:

  • The big decision – SharePoint 2013 v 2016 v SharePoint Online
  • Upgrade planning – what to be aware of
  • Site Architecture, Taxonomy, and Governance– tips, tools, and best practices
  • Phased deployment – it’s not over once you upgrade! (in the workshop version, this could be Building your Deployment plan)
  • User Adoption and Training – introducing a new version of SharePoint and keeping users excited 
Level: Intermediate