How to output the Office 365 Roadmap as a spreadsheet

If you want to stay on top of what’s coming soon for Office 365, the Office blog will be the source for major announcements, but you’ll also want to keep an eye on the Office 365 roadmap – which also covers Office Online and Outlook.com. If the Office blog is going to cover a feature, the news will be there first, but smaller features may only be covered in the roadmap.
roadmap-650-80

A bit of a friction I’ve run into quite a bit, is that because there’s so much goodness in the pipeline that it’s kind of clunky to try and advise people as to what’s on deck, what’s been launched and everything in between – clearly some of the major new feature sets getting launched are pretty hard to miss as there will generally be a major post on the Office blogs about it. However, often the peripheral improvements are useful to have good optics on.

Everyone loves tabular data, so let’s get this sucker into a spreadsheet so we can crunch the data easier!

Due to the number of features in the mix, it’s kind of essential to get the info from those two sources into a spreadsheet to be able to crunch it and also track it in the long term (monitor for changes).

I used a few Chrome Extensions, primarily “Data Scraper”, whipped up the XPath formulas required and exported as CSV.

Chrome Extensions Used:
Data Scraper: https://chrome.google.com/webstore/detail/scraper/nndknepjnldbdbepjfgmncbggmopgden?utm_source=chrome-app-launcher-info-dialog
Recipe Creator: https://chrome.google.com/webstore/detail/recipe-creator/icadidhenmiokjlmpdgjikdoknhfgkhg?utm_source=chrome-app-launcher-info-dialog
Xpath Helper: https://chrome.google.com/webstore/detail/xpath-helper/hgimnogjllphhhkhlmebbmlgjoejdpjl?utm_source=chrome-app-launcher-info-dialog

Here’s the Data Scraper rules I used – the XPath pattern used is to define the main repeating container of info, then divvy up the contents as they will be added as columns in Excel:

Container: //article/div[2]/div/div/div[1]/div
Status: ../../../div[1]/div[1][contains(@class, “feature-group”)]/div[1]
Title: ./div[1]/div[1]
Description: ./div[2]/div[1]
Link: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__more-info”)]/a[1]/@href
Category 1: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][1]
Category 2: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][2]
Category 3: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][3]
Image: ./div[2]/div[3]/div[contains(@class, “feature-image clear-fix col-md-12”)]/img[1]/@data-original

Note:
This article does not advocate automatically polling the Office 365 Roadmap page. No one likes bots hammering their pages – you are obligated to play nice according to Microsoft.com’s terms of use. This extensions/scripts described here work on the clientside browser only. Please manually download an offline copy of the page and do your work on that.

Join the #CodeGeneration Movement

Building on Microsoft’s recent announcement to invest $75 million in community programs to increase access to computer science education for all youth worldwide, Microsoft Canada is launching the #codegeneration movement – to inspire Canadian youth (13 -18 year olds) to learn more about coding. #codegeneration will run from now until Computer Science Education Week (December 7-13). 

Join the Movement!

Help us spread the word and teach Canadian youth to create with technology. Anyone can code, it’s simple and easy.

  • Coding Challenges: For the next five weeks, Microsoft will be issuing coding challenges at www.CodeGeneration.ca. Students who complete these weekly challenges will have the chance to win points towards prizes while learning the basics of coding; and parents and teachers can find resources to help them lead students in these challenges themselves.
  • “Hour of Code” Sessions: As a founding corporate supporter of Code.org, Microsoft is offering free Preparation Webinars with live chat for questions and answers on November 24 and December 1.  Ready to hold your own Hour of Code with your students – download your toolkit today and lead them through a Minecraft tutorial.  Or schedule a field trip to a local Microsoft Retail Stores during Computer Science Education Week to give young developers the opportunity to learn coding. For more info, please visit the In-Store event section at a store near you.

Spread the word!

Power BI goes prime time

by James Phillips, Corporate Vice President, Microsoft Business Intelligence Products Group

Today is an exciting milestone, as we release the new Power BI service and Power BI Desktop. When I first unveiled our GA date earlier this month, I emphasized the importance of the innovation we’re delivering, and how it leads to discovery and insight for our users.

With the impressive list of the new features and capabilities, plus the advances in our Power BI service and the new Power BI Desktop, we already have plenty to talk about. But the news doesn’t stop there.

We’re inviting you to disrupt the way you do business by bringing you this cloud-hosted, business intelligence and analytics service that connects to your data. We want you to experience the team’s mantra of, ‘five seconds to sign up, five minutes to wow!’

Part of this simple discovery is connecting to your data. We’re rolling our new content packs weekly – ensuring that business users can connect to and experience their data without technical setup. This means you can connect to your data in popular services like Quickbooks and Salesforce, and view a curated collection of dashboards and reports that continuously update with the latest data from these services.

We also contributed our Power BI visualization framework and its complete library of visuals to the open source community to enable customers and partners to easily extend and build custom visuals. The project is available on GitHub, and in the future, customers and partners will be able to extend and bring custom visuals into Power BI for use in their dashboards, reports and content packs.

Power BI sets the standard for modern business intelligence, and it isn’t going unnoticed. With over half a million people, from 45,000 organizations in 185 countries trying out the preview, I’m thrilled by all the value Power BI is delivering to our users.

For example, at the Boys & Girls Clubs of Greater Fort Worth in Texas they are using Power BI to understand how their various programs are performing and their impact on the kids they serve. With a mission to change each kid’s life for the better, the leaders at the Boys and Girls Club use Power BI to see their data update in real time and discover new insights visually to take action.

At Metro Bank in London, the team is using Power BI to quickly and accurately provide information to guide analysis and decision-making as they set out to create fans, not customers.

With all the new features and capabilities we’re delivering today, plus our commitment to a weekly release cadence, I know we’ll continue to have great customer stories like the two above to tell.  Join the 500,000+ people who have tried Power BI to start discovering the stories your data will tell.

Office 365 Custom App Launcher Tiles feature being deployed now

The ability to create custom tiles in your Office 365 tenancy has just been pushed to a much wider audience as of July 22.

From https://support.office.com/en-us/article/Add-custom-tiles-to-the-My-apps-page-and-app-launcher-1136115a-75af-4497-b693-640c4ce70bc6

In Office 365, you can quickly and easily get to your email, calendars, documents, and apps using the Office 365 app launcher (learn more). The tiles in the app launcher are those that have been promoted, or pinned, from the My apps Page (learn more). The My apps page includes all of the apps you get with Office 365 as well as custom apps that you add from the SharePoint Store or Azure AD.

In addition to these, you can add your own custom tiles to the My apps page that point to SharePoint sites, external sites, legacy apps, and more. Once there, you can pin them to your app launcher and instruct your users to do the same. This makes it easy to find the relevant sites, apps, and resources to do your job. In the below example, a custom tile called “Contoso Portal” is used to access an organization’s primary SharePoint site.

Custom tile on Office 365 app launcher

Tip   To perform these steps, you must be an administrator with access to the Office 365 admin center.

Add a custom tile to the My apps page

  1. Sign in to Office 365 with your work or school account.
  2. Select the app launcher icon App launcher button and choose Admin.
  3. Choose Company Profile in the left navigation.

    Company profile in Office 365 admin center

  4. Choose Custom tiles.
  5. Choose Add custom tile plus button to create a new custom tile.

    This opens the Add or edit a custom tile window.

    Add custom tile window

  6. Enter a Tile name for the new tile. The name will appear in the tile.
  7. Enter a URL for the tile. This is the location where you want your users to go when they select the tile.

    Tip   If you’re creating a tile for a SharePoint site, navigate to that site, copy the URL, and paste it here. The URL of your default team site looks like this: https://<company_name>.sharepoint.com

  8. Enter a Description for the tile. You see this when you select the tile on the My apps page and choose App details.
  9. Enter an Image URL for the tile. The image appears on the My apps page and app launcher.

    Tip   The image should be 50×50 pixels, stored in SharePoint Online, and shared with everyone. You can, for example, put it in a library on your team site then generate an anonymous guest link and use that as the URL. If you can’t generate an anonymous link, make sure external sharing is enabled in SharePoint Online.

  10. Choose Submit to create the custom tile.

Your custom tile now appears on the My apps page for you and your users..

To add the custom tile to the app launcher

  1. Select the app launcher icon App launcher button and choose My apps.
  2. Select the ellipsis and choose Pin to app launcher.

    Pin tile to app launcher

Important   Both you and your users need to perform these steps to promote custom tiles from the My apps page to the app launcher.

Edit a custom tile

  1. In the Office 365 admin center, choose Company Profile in the left navigation.
  2. Choose Custom tiles.
  3. Select a custom tile and choose Edit tile.

    Edit custom tile for app launcher

  4. Update the Tile name, URL, Description, or Image URL for the custom tile (see earlier description).
  5. Choose Submit.

To delete a custom tile, follow steps 1-3, choose Remove tile and then Delete.

What’s next?

In addition to adding tiles to the app launcher, you can add app launcher tiles to the Office 365 navigation bar (learn more). To customize the look and feel of Office 365 to match your organization’s brand, see Customize the Office 365 theme.

Microsoft Ignite Conference 2015 Roundup

Here is my presentation from last weeks Victoria Office 365 User Group in Victoria, BC.

“Microsoft’s Ignite Conference in Chicago last month was a huge event- 23,000+ attendees -and a lot of genuinely interesting technology news came out of it . I’ll share with you here my take on the big items of the event, flavoured through my lens of SharePoint/Office 365.

The core concepts: Microsoft is taking a mobile-first, cloud-first approach with three top priorities: to usher in an era of more personal computing, to reshape work and productivity with enhanced products and processes, and to build trust in a reliable, extensible cloud service offering.

What’s more, for us here in Canada, a lot of these announcements take on huge new relevance as Microsoft just announced on June 2 (http://reimagine.microsoft.ca/en-ca/) that they are opening data centers located on our soil. This opens up the doors to a Government and Private industry base that previously had been not able to leverage these services.

I will talk a bit on the upcoming on premise version of SharePoint 2016, the latest in Office 365 (including Delve/Office Graph), and more. ”

Speaker:  Keith Tuomi, FCV Interactive
Duration: 30 minutes
Audience: Business Professionals (Managers, Project Managers, etc.)
Technical Level: 200

Microsoft MVP Virtual Conference Day 2 – On Now! (free)

A big thank you to those of you who joined us for the Microsoft MVP Virtual Conference Day 1.  For those of you who logged on early to see Steve Guggenheimer’s keynote, you’ll know that we experienced an unfortunate technical issue during the keynote address, which resulted in it not being broadcast.

The good news: although you couldn’t see the session, we kept the cameras rolling.  As a result, while the rest of the videos from vConf won’t be ready, we have worked all day to make an archive recording of his address available to you, today.  You can now view the keynote at your convenience here or tune in here for a streamed broadcast of the keynote tomorrow, Friday, May 15th at 7 AM PDT.  This won’t interrupt your conference schedule as it will be played before the start of the first regularly scheduled session.

Please be sure to join us for Day 2 for some more amazing content and to catch Guggs’ keynote!

To join any of the individual tracks, please use the links below:

Keynote
https://managedevents.eventbuilder.com/event?eventid=m1b3u0

Developer Day 2
https://managedevents.eventbuilder.com/event?eventid=c4a0z3

IT Pro Day 2
https://managedevents.eventbuilder.com/event?eventid=l2t4h9

Consumer Day 2
https://managedevents.eventbuilder.com/event?eventid=z5b6q1

LATAM Day 2
https://managedevents.eventbuilder.com/event?eventid=u6s0t6

Brazil Day 2
https://managedevents.eventbuilder.com/event?eventid=t5p4g6

Thank you,

Microsoft MVP Virtual Conference Team

Microsoft Ignite Conference: Day 4 Round-Up

Last day of the MS Ignite conference for me. Let’s take it to the bridge:
Bridge

Another metaphor? You betcha:

– Cloud vs on-premise
– Microsoft as Service Provider vs Shrink Wrapper
– Unified experiences vs Diversified devices
– People-driven Intranets vs Intranet-driven people
– Windows OS as a true personal & biz life and productivity platform vs Windows OS as a 900 pound gorilla

My top picks for Day 4 in the SharePoint/Office 365 realm (with a little .NET 5 in there to maintain my Dev street cred):

My last-day sessions:

JEA: A PowerShell Toolkit to Secure a Post-Snowden World

When asked what to do about corporate hacking, Ex NSA Director Michael Hayden replied, “Man up and defend yourselves.” Edward Snowden then rocked the world by disclosing privileged NSA information. JitJea stands for “Just In Time, Just Enough Admin.” It’s a Windows PowerShell toolkit that admins use to perform functions without giving them admin privileges.

MVP Panel: SharePoint On-Premises, Online and Everything in Between
Imagine five great minds coming together to talk about Microsoft SharePoint across the board, be it within Microsoft Office 365, in Microsoft Azure, on-premises and certainly hybrid. Via a panel Q&A format, these MVP experts expose how online and hybrid improvements increase both deployment scenarios and value. This session is designed to help ITIs and ITDMs find the right cloud formula to deploy based on practical business and technical considerations. This is a must-not-miss session for any IT pro!

How to Decide When to Use SharePoint and Yammer and Office 365 Groups and Outlook and Skype
Your users may struggle with these questions: Should I share a message via Skype for Business instead of Yammer, Office 365 Groups, or Exchange? Should I collaborate on data using an Excel sheet or a SharePoint list? Should I share a file in Outlook, in a meeting, from OneDrive for Business, on Yammer, in a Group, or in a SharePoint site? This session is the ‘How To’ user’s guide What happens when your users can’t decide what technology or feature to use? They use what they know, or what’s easy; even if better options exist. In this session, Richard and Kanwal help you maximize the value of your Office 365 investment by providing the guidance you need to help your users make better, more effective decisions on how they get work done.

Experts Unplugged: Office 365 Security

OneNote for OneLife: From Notes to Productivity and Platform
OneNote is awesome. Really. Knowledge, learning and info on the bleeding edge benefits from structure – but not too much structure. We all need a place to inscribe understanding, without having to go overboard on the word-processing end of things.  I’m always thrilled to hang out with the OneNote crew as I sometimes wonder if they know they have the future of Education and Wikis in their hands.

Microsoft OneNote gives you one place for your notes and other content with you, anywhere now that OneNote is across all platforms and devices. Write by hand, type, record, snap a picture, clip from the web, or use a growing number of other partner apps and devices and OneNote saves it. Organized or not, you can easily find your notes in any form (text, writing, picture, or audio) with OneNote search. This session demonstrates end-user productivity scenarios at work to give you a clear understanding of how OneNote can help drive adoption of Office 365 with cross-platform, real-time collaboration, and extensibility with OneNote API. You’ll walk away wanting to use, evangelize, and build on OneNote personally or for your organization.

Microsoft Ignite Conference: Day 3 Round-Up

I’ll kick off Day 3’s post with another imprint of pure experience. Scale- On-premise, Cloud, Global, Local. The rush/distraction/tunnel vision of being one of 23,000+ people moving through the Microsoft Ignite conference, contrasted with simple but essential logistics like bio-breaks and food, are a big parallel for me to the distinct juncture we are at in technology:  empower everyone at a mass scale, but make sure the human details are taken care of, and that everyone has a voice.

The entrance hall may resemble a slightly above average shopping mall scene for most, but in context, on the ground, it was more like the entrance to a spaceship waiting to take off:
Entrance

Existential experiences aside, I waited a full 5 minutes for cell phone guy to abandon his hostile takeover of Microsoft (pleading eye contact included), and finally realized that was 5 minutes I would never get back, so I snapped my obligatory “largest Expo Hall ever” pic:
Microsoft
Really, words don’t help much with describing the scale of this event. 23,000 of the world’s finest Microsoft-oriented IT professionals in not one, but two Conference centers daisy-chained together. Being from Canada, the SCALE of business in America is always impressive-  this time it was the hammer of Thor (axe of Abe Lincoln?). There were numerous, well-attended core educational/interactive groups with all the best of the Microsoft team providing direct interaction with attendees. These were no tradeshow stunt doubles, but really the actual program leads and people who make things move at Microsoft. Super high quality interactions all over the floor.

Office 365

TechNet is my bible, which would make Joanne & KC here (Senior Content Writers for Microsoft), pretty high up in the toga-wearing department:
TechNet Rocks

Aside from the separate, colossal pool of core Microsoft and Partner & Vendor talent present in the Expo Hall, here’s the top sessions from day 3, on the SharePoint/Office 365 tip (with some guest appearances from OneNote & Visio, as I love both):

Whats New for IT Professionals in SharePoint Server 2016
What's New for IT Professionals in SharePoint Server 2016

“Engineering paths directly influenced by SP Uservoice” See: https://sharepoint.uservoice.com/forums/282887-customer-feedback-for-sharepoint-server
“Durable Links- permalinks based on resource ID. Move Docs freely, URL stays the same”
“No downtime CU patching”
“OneDrive integration big priority for Engineering team”

 

This article describes initial investments made in installation and deployment of SharePoint Server 2016: http://blogs.technet.com/b/wbaer/archive/2015/05/12/what-s-new-in-sharepoint-server-2016-installation-and-deployment.aspx

MinRole for the win!!
image10_00727E0C

Embrace the BYOD Revolution: Effectively Manage a Multi-Device, Multi-Generational Workforce


A major business transformation is brewing in the enterprise today. Mobile technologies, business velocity, geographically dispersed and multi-generational workforce are converging to deliver the promise of responsive organizations. Organizations that miss this paradigm shift will face dire consequences. How can you effectively manage this shift, ensure that it will be sustainable and reap the benefits of being a responsive organization? In this session, learn how to apply practical steps and effective techniques to manage your multi-device and multi-generational workforce.

MVP Panel: Sample Apps and Intelligent Solutions Showcasing Office Graph and Delve Extensibility

Preparing for a meeting, but not sure what documents are relevant? Writing a proposal and looking for similar documents to help you out? Interested in what your colleagues are working on to stay updated? With the new Office Graph, answers to those questions are within your reach. In this demo-packed session, we show you how the Office Graph works and how it can be used when building custom apps and enriching existing solutions and portals. All scenarios are backed up by real-life solutions that you could use in your organization.

Microsoft Ignite Conference: Day 2 Round-Up

Day 2 started off with a walk to the shuttle bus under the looming John Hancock building. Infrastructure into the Cloud, this pic worked out well as a deep ol’ metaphor 🙂 :
John Hancock

Here’s some of the most awesome SharePoint/Office 365 sessions from Day 2:

There are over 150 Day 2 sessions available for immediate viewing.

Source: Microsoft Ignite Day 2 Sessions On-Demand

Here’s my takeaways from the sessions I had scheduled:

Microsoft Office 365 Groups Overview and Roadmap

“It’s not an email, it’s a conversation.”
Dynamics CRM and Group’s integration.

Office 365 Groups helps you collaborate by easily bringing together your colleagues and the applications you need to get work done. Office 365 Groups leverages a standard definition for team membership and permissions across Microsoft Exchange, SharePoint, and later Skype for Business, Yammer and the rest of Office 365, managed through Microsoft Azure Active Directory. This session provides an overview of Office 365 Groups, demonstrates its capabilities today, and provides a roadmap for future investments.

Designing and Applying Information Architecture for Microsoft SharePoint and Office 365

Provide Clear Guidance
Make it Easy
Keep it Simple, Stupid
Define > Design > Implement > Govern

This session demonstrates a proven process for defining, designing, implementing, and governing your information architecture (IA). IA is more than just columns and metadata. Learn how the different components available in SharePoint and Microsoft Office 365 can be leveraged to their fullest potential and your users’ ultimate benefit to content organization and discovery.

Managing Change in an Office 365 Rapid Release World

Selective First Release! Roll out first release changes to selected users only. ’nuff said.

Before moving to Microsoft Office 365, your team planned each and every change or update before your users saw anything new or different. Now in a services-first world, changes are introduced at a rapid pace, sometimes before you or your help desk may be prepared. Office 365 provides communications to help you manage change, stay informed, and inform your users. Learn how to best use the Office 365 Message Center, Roadmap.office.com, and Success.office.com to get ahead of updates and help your business take advantage of the latest and greatest Office 365 has to offer.

Microsoft Office 365 Groups Deep Dive
Office 365 Groups helps you collaborate by easily bringing together your colleagues and the applications you need to get work done. Office 365 Groups leverages a standard definition for team membership and permissions across Microsoft Exchange, SharePoint, and later Skype for Business, Yammer, and the rest of Office 365, managed through Microsoft Azure Active Directory. This session follows the introduction session “Microsoft Office 365 Groups Overview and Roadmap,” and covers the following topics: architecture, administration, security and compliance, and extensibility.

All in all a great day- I was also lucky enough to be able to work at the Microsoft MVP Booth (in the “Microsoft on Microsoft” section of the Expo Hall). Very rewarding to answer questions about the MVP program and connect with people from around the world.

MS MVP Booth

MVPS

Yammer session recordings & slides from Microsoft Ignite 2015

Courtesy of Office 365 Product Manager (and awesome dude) Christophe Fiessenger:

Please find below a list of all Yammer sessions recordings and slides that were delivered at Microsoft Ignite, May 4-8, 2015 in Chicago. For all other sessions recordings and slides please check out the Ignite session catalog.

A BIG THANK YOU to all speakers that delivered the Yammer love!

The rise of dynamic teams – BRK1106 – Bryan Goode, Alan Lepofsky
Yammer Roadmap – BRK2103 – Juliet Wei, Gadi Ben Zvi
Yammer Enterprise Administration – BRK3111 – Martina Grom, Sameer Sitaram
Yammer Identity and User Management – BRK3132 – Martina Grom, Sameer Sitaram
Yammer of Team Collaboration – BRK2190 – Lindsay Matthews, Jay Sethna
Yammer IT Mythbusters – BRK2201 – Naomi Moneypenny, Chad Slipka
The Social Journey: The Customers’ Perspective – BRK2101 – Andrea Berry, Greg Nemeth, Mary Lou Theobald, Michael Wetzel, Steve Somers
Designing for innovation at Yammer – BRK2199 – Gadi Ben Zvi, Jay Laney
The Social Intranet: Integrate Yammer into Your Microsoft SharePoint Experience – BRK3201 – Eric Overfield, Naomi Moneypenny
How to Decide When to Use SharePoint and Yammer and Office 365 Groups and Outlook and Skype – BRK2102 – Kanwal Khipple, Richard Harbridge
Gain Organizational Insights with Yammer Data Mining and Analytics – BRK2119 – Steve Nguyen, Tammy Young Heck
Enterprise Social, from “Ooh, Shiny” to Business Success – BRK1103 – Melanie Hohertz
Yammer Mining: Dig in and “Listen” to What Your Big *Social* Data Is Saying – BRK4127 – Richard diZerega
Become a Yammer Power User: From Zero to Hero in 75 minutes – BRK2171 – Dawn Gartin, John Pan
Developing with Yammer: Extensibility and API Overview – BRK4109 – Gregory Love, Ryan Braastad, Christina Fan
The Microsoft Enterprise Social Journey: How We Did It – BRK2187 – Chris Slemp
Become a Productivity Ninja: Enter the Productivity Dojo – BRK2105 – Angus Florance, Steve Somers, Steve Nguyen