My “live Performances” :-)

My presentations, Meetups and Webinars…See you in every PowerBI and SharePoint/Office 365 Meetup in Vancouver or Redmond!

I am going to be helping Charles Sterling (Chass), with his Power Apps presentation in Office 365 user group Redmond, this July

SQL Saturday Redmond PASS #613- Using PowerBI and Office 365 to enable Decision Support in Small Companies Slides Deck

 

Recording
SharePoint Saturday Vancouver 2017 – Product Management using Office 365 tools Slides Deck  Recording
SharePoint Saturday Calgary 2017 – Product Management using Office 365 tools Slides Deck
SharePoint Saturday Calgary 2017 – Give More Power To the users PowerBI and API, presenting with Scott Stauffer Slides Deck Recording
Vancouver PowerBI user group March 2017 meeting- My story with data and PowerBI The Dashboard Recording
Vancouver SharePoint user group October 2016 meeting- Give more Power to the users! PowerBI and API MeetUp Page
Webinar – November 2016 PowerBI as a Decision support methodology enabler  Recording

 

My thoughts on the technical aspects of manuall migration of an Access or other legacy forms application

Divide the migration to 3 different parts:

  1. The governance & Process flow
  2. The content- migrating the data
  3. The interface

Governance, planning and process flow

First of all decide what is going to be migrated and create a migration map and a document containing all the information.

Before any migration to the cloud I would like to refer you to the following article: Five pitfalls to avoid when migrating to the cloud

The most important one is: do not forget the what? who? and why business users are going to use it.

The simple understanding of who access what? which users are going to use this application and how? have a basic process flow and well defined personas for your application. If it is big enough, user stories will be needed as well.

After reviewing those topics you would be able to figure out the SharePoint solution architecture vs the existing one in Access. The how will be cleared, should you use several lists? how about groups? sites? PowerApps? maybe several pages just for the view and some custom made buttons?

2. Migrating the data –

    1. Create the data repositories – the lists, you can export the Access data by tables to Excel.
    2. SharePoint, unlike Access, is not a relational Data Base, that means that the data should be not normalized and hierarchy’s are not going to work the same unless a custom solution is applied.
    3. The easiest way is using the quick edit mode on a pre-created tables – yes that means basically rebuilding the Access solution

3. Migrating the interface

Prepare the solution – the data is going to reside in SharePoint lists? the access is going to be through list forms? another 3rd party solution? What is the user interface going to look like?

I would recommend to use Power Apps in order to achieve the forms look and feel and enjoy the benefits of the flow for any business rules you have mapped in the first part. The Power Apps can be connected to several data sources, hence creating the illusion of a relational DB after all. A very important tip, make all your editing in Power Apps desktop application. The online version is a bit, sneaky ;-).

Also on Quora

Calgary SharePoint Saturday

  • I was speaking in SharePoint Saturday Calgary April 1st 2017.

    Calgary SharePoint Saturday event site

    My first session was with the wonderful Scott Stauffer, his blog: http://scottstauffer.ca/about/ and the twitter feed: @SQLSocialite, you should follow him if PowerBI and SQL is somehting you find interesting. We have discussed PowerBI basics, made some jokes and showed the end users that you don’t have to be part of the IT team in order to be successful with PowerBI. 

    You can fins our session recording in my YouTube.

    Power BI & API: Give more power to the users!
    The 2nd session was more about Product Management and the art of the possible using SharePoint, powerBI and office 365.

    Product Management in SharePoint online and Office 365 end to end process

    Product Managment with Office 365.PNG

    I had lots of fun, mat new and old friends and was happy to share my experiments with SharePoint and data platforms.