Office 365 Planning, Migrating, Adoption resources

Microsoft have gathered a range of resources for Office 365 covering SharePoint, Office and Skype for Business as well as planning and end user adoption at http://fasttrack.office.com/. When you get there click about a bit, a lot of the “good stuff” is a couple of clicks down.

These resources are of use to you if you have recently moved to one of the many varieties of Office 365. I’ll be reviewing this in more detail myself next month as part of revamping my own SharePoint site.

Go Explore…

Fresh OneNote resources for Schools

Always looking for new uses of OneNote and found two that I’d like to share with you.

Free eBook for teachers: “Liberating Genius: The First 20 Days” by Angela Maiers – which is an e-book using OneNote as its “host”. This has got me thinking about going beyond my current use of OneNote as a scrapbook for course resources to using it for courseware.

College prep planning resources and virtual event for students use OneNote as a resource to support an online session. Its aimed at american students going to college, but its worth Australian and other schools getting a copy to explore the approach.

Power BI Windows 10 universal app and Power BI Desktop update

As people may know I am currently doing the Data Analysis course via Duke University and Coursera. While I am my data kick I am keeping track of news of new and updated tools. And so I have two bits of news:

Microsoft has released an update for Power BI desktop and also a universal app (to suit Windows tablets, phones and PCs). I will explore these tools further after I have complete the current module of the data analysis course.

Office 365 Tools for Lawyers and Legal Professionals

Broadening the base of potential Office 365/SharePoint Online users is the Legal Matters Center for Office 365. I attended an early session on this at the Ignite conference in Chicago.

Resources can be found at:

PowerPivot Reference Card

This card is an excellent reference for PowerPivot users. Its also free and available Giving Back: “Steal” this Reference Card!

The host web site http://www.powerpivotpro.com/ is also worth bookmarking!

 

Business Metrics for Data-Driven Companies

Signed up for “Business Metrics for Data-Driven Companies” the first course of a 5-course series, the Excel to MySQL: Analytic Techniques for Business Specialization. Enjoyed the Microsoft edX course I did recently, so I thought I’d do more.

Thought it was a fit and should help with the questions I get from Business Analysts on Excel and SharePoint Courses.

Microsoft: DAT206x Excel for Data Analysis and Visualization

Successfully completed (97%) the edX course: Microsoft: DAT206x Excel for Data Analysis and Visualization!

Learned a lot and filled in some gaps in my knowledge especially with Power Query and Power BI. I’d recommend it, keep an eye out for it! Looking forward to my certificate.

Now I am keen to learn more – looking at Excel to MySQL: Analytic Techniques for Business Specialization which is a series of courses and a project. Have to get enrolled by Nov 9 for the first course.

 

Ben Wellington: How we found the worst place to park in New York City — using big data

This is an excellent Ted talk about open data, gives practical examples and raises the need for consistent standards for data provided by Government.

There is a follow on discussion needed here about government making data public and in a form where the public can explore it and draw their own conclusions and effectively debate and discuss government plans and proposals.

If you follow this talk back to Ted, you will find a whole set of Data related talks, I recommend the one by Amy Webb.

 

Add data to you Power Pivot using Power Query in 25 minutes

Lesson Two

Give me 25 minutes and I will show you how to add data to an existing Power Pivot using Power Query. Add data from Excel and CSV files.

This process is useful if you need to periodically add new data e.g. monthly.

Give me 28 minutes to introduce you to Power Pivot

Make your first step into Business Intelligence tools by using data in Excel worksheets and Power Pivot

Learn how to:
– add to data model
– create relationships
– add calculated columns
– create a pivot table
– see one approach for grouping by dates

Lesson One in a series where I aim to introduce you to the “Power Tools” for Excel 2013 and SharePoint

 

My US Trip Sway

Via Sway, pictures from my trip, San Francisco, Petaluma and Chicago on my way to Microsoft Ignite!

SharePoint 2013, Lync Courseware Review

I often get asked for suggestions for courseware. Not all training providers have their own material for all products.

So here are a couple of quick reviews of courseware for a couple of increasingly popular topics.

My aim is to find some resources to recommend, so that I can use my time to prepare additional  materials and exercises to cover custom topics and not preparing the core courseware.

Background

  • I recently purchased the e-book editions of both books from Watsonia Publishing
  • I have read the workbooks but at time of writing have not used them in a course
  • I am not getting a commission for these reviews

SharePoint 2013

  • INF1432
  • ISBN: 978-1-925121-31-5
  • Watsonia Publishing
  • For SharePoint Readers, Authors and Site Managers 978-1-925121-46-9

This material would require trainer to prepare a demo site (and ideally save a template) and permission groups, etc. ahead of time.

My usual approach is to make a typical student site with worked examples of lists and libraries as a starting point, make a template including content, and then make X copies of the site, one for each student.

Initial Thoughts

  • good overview at start
  • has basic set up notes and some sample files to use for uploading etc (student files are an “exe”, which my firewall was not keen on – why are downloads still executable files?
  • screen captures are current at time of this review for on premise SharePoint. For SharePoint online, there are some differences in the upper part of the screen. A handout could cover the differences.
  • Could be used for SharePoint 2013 on premise or online (as part of Office 365)
  • where it is a bit awkward  (as is most SharePoint courseware) is spreading list and library topics over three chapters. I tend to explore lists in detail and then libraries, my purpose here is to expose people to lists and common SharePoint functionality. When we move from lists to libraries, they have gained two things (a) a general understanding of the interface and how consistent it is and (b) most people have found at least one list they can use, so they have broadened their view of SharePoint from just libraries…
  • the previous point is a long standing beef of mine that courseware and courses should follow how people will use the features or product.

Re-arranging the workbook, I’d see a course using this book like this:

Day One

Theme – using and exploring SharePoint (moving to creating later in the day)

  • Getting to Know SharePoint
  • Navigating a SharePoint Site
  • Documents Lists and Libraries
  • OneDrive for Business
    • Syncing would be a key topic here
    • Sharing
  • Social Networking
    • particularly newsfeed, hash tags, following documents and people
  • Introduction to Lists (my heading, featuring content from:)
    • Working With Files and Items
    • Working With Calendars
    • Creating Lists and Libraries
    • exploring a range of lists, (contacts, calendar, issue tracking) exploring
      • datasheet view
      • connecting to Outlook, Excel
      • Alerts, Recycle Bin
  • Introduction to Libraries (my heading, featuring content from:)
    • Working With Files and Items
    • Creating Lists and Libraries
    • focusing on
      • Uploading, adding new documents
      • Editing documents
      • Checkout
      • Version control
  • Creating Views

Day Two

Theme is creating resources, features, in SharePoint

  • Searching in SharePoint
    • I’d do this on day 2, to be sure content added on day 1 has been indexed and can be found
  • Custom Lists and Libraries
    • content from Document Management (varying levels of content from here depending on client need)
    • creating custom lists (eg to replace registers in spreadsheets – in book in in “Creating Lists and Libraries” but could use an additional handout)
    • adding metadata to a library ( in “Creating Lists and Libraries”)
    • creating views using the metadata (in “Creating Views”)
  • Working With Workflows
  • Managing Security
  • Creating a Site
    • a blend of Preparing Your Training Site/ Working With Personal Sites/Creating Team Sites
    • I’d leave this for day 2, after permissions and groups, as “creating a site”
    • includes navigation, look and feel options
  • Authoring Web Part Pages
    • doing this later than in the book, after people have created lists, libraries and views and can bring it all together for their end users in one place
  • Other Collaboration Sites
  • SharePoint resources online (my heading, not in the book)

Topics I’d leave out

  • Custom Workflows – this is SharePoint Designer, and for good reason, most users wont get anywhere near SharePoint Designer – custom workflows could be covered as a later advanced session using an app from the store.
  • Working With Search – this is more advanced search config, might be a topic for an advanced session.

To find the workbook, search for Watsonia Publishing and INF1432

In Summary

I could see this as viable courseware for two day course for contributors, owners and managers, with some additional handouts and some tweaking of sequence.

Other SharePoint resources I’d recommend

I’d recommend teams on a course get one each of the following

The Apress book

The first book is not courseware, but it is an excellent post course reference. It gives in detail the steps you need for any process a site user, contributor or owner will need.

SharePoint 2013 User’s Guide: Learning Microsoft’s Business Collaboration Platform, Fourth Edition

  • By: Tony Smith
  • Publisher: Apress
  • Pub. Date: June 12, 2013
  • Print ISBN-10: 1-4302-4833-5
  • Print ISBN-13: 978-1-4302-4833-0
  • Pages in Print Edition: 536

The Microsoft Press Book

I recommend this second book as a tool to use with your own end users, post course. While I often call this the “SharePoint Picture Book”, I mean this in the sense it is easy to follow for end users. Its actually pretty comprehensive in its range of topics.

Microsoft SharePoint 2013 Plain & Simple

  • By: Johnathan Lightfoot, Michelle Lopez, and Scott Metker
  • Publisher: Microsoft Press
  • Pub. Date: May 15, 2013
  • Print ISBN-10: 0-7356-6700-4
  • Print ISBN-13: 978-0-7356-6700-6
  • Web ISBN-10: 0-7356-7214-8
  • Web ISBN-13: 978-0-7356-7214-7
  • Pages in Print Edition: 440

Microsoft Lync Online

  • Watsonia Publishing
  • INF1422
  • ISBN: 978-1-925121-35-3

Lync, especially as part of Office 365 is a moving target.  At time of writing the screen captures matched the current product. Lync is about to become Skype for Business, which may require an update of the courseware.

The sequence of topics from Creating contacts to Presenting is in a logical order, and covers all of the skills people will need for using Lync for IM, ad hoc discussions and meetings. The skills covered in meetings and presenting could also be used for delivering small group on line training.

The topics covered are:

  • Lync Contacts
  • Instant Messaging
  • Working With Calls
  • Meetings (includes Recording)
  • Presenting
  • The Lync Mobile App
  • Lync Options

I think for most groups a 3-4 hour session would give plenty of hands on and practice.

To find the workbook, search for Watsonia Publishing and INF1422