Need to Know Podcast–Episode 143

Marc and I have a chat about the latest developments in the Microsoft Cloud. There is plenty of both Office 365 and Azure news to cover this week so listen in for all the latest updates.

Don’t forget to send us your feedback at feedback@needtoknow.cloud

You can listen to this episode directly at:

https://ciaops.podbean.com/e/episode-143-cloud-news/

or on Soundcloud here:

Subscribe via iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send us any feedback or suggestions you may have for the show.

Resources

@marckean

@directorcia

Azure news from Marc

New Office 365 Health Dashboard available

New Yammer integration with Groups rolling out

Visio for Office 365 now available

Domain joining servers to Azure AD

Random content for SharePoint

This episode is brought to you by:

 

 

https://cpem.io/tJ01Hzu2k.js

Office 365 adoption spreadsheet

https://github.com/directorcia/Office365/blob/master/o365-azure-usage.xlsx

One of the challenges with Office 365 is that it needs to be seen as a platform rather than a single product.

Unsurprisingly, the most common service implemented in Office 365 is email. This is mostly because people don’t know what else their suite contains.

It is therefore important, for many reasons, that IT reseller enable every service in Office 365 that customers have access to do. At ther very least, they should be ensuring customer know about everything that is available to them. Unfortunately, I don’t see that being done well. The main reason for that is simply most resellers don’t have a system to help drive adoption. Hopefully, my spreadsheet above, that you can download and use for yourself, might help a bit.

What I have done is created a new tab for each Office 365 service. So for example, there is an E5 tab that lists all the customers in order and then has columns for each of the items in that service. For example in E5 there is Meeting Broadcast, Cloud PBX, Delve Analytics, Power BI Pro, Customer Lockbox and so on. Then there is a tab for Email, Delve, Yammer, Team Sites, etc.

The idea is that for each service you go in and enter a usage number as a percentage. This represents how much of that feature the client knows about and is using. Where do the actual percentage figures come from? In the spreadsheet I have created they are entered manually, however there is nothing stopping you getting them from the Office 365 utilisation stats in the Admin Console or even the Power BI Office 365 adoption content pack. I’d suggest that the idea is to keep things as simple as possible to start with and improve it from there.

Now that there are figures for all the individual items, these are then rolled up into a Summary tab at the front of the spreadsheet. I have also used conditional formatting to highlight those which are below an acceptable level. This allows you, at a glance, to see where you need to placing your energy to lift usage within your customer base.

By converting the lists of items to a table I can now sort by any column I choose. Thus, if I sort the Total column from top to bottom I can see my best and worst users over all. I can repeat that process for any column as well to see which users have the overall worst take up of something like Yammer say.

I can therefore look at the spreadsheet by row, i.e. per customer, to identify what services any individual business is not using. However, I can also look at the results by column, i.e. by service. That would allow me to focus say on Yammer and target the lowest adoption, then move to the next lowest adoption. I could look across all my columns and run a campaign to target the lowest service usage.

Even though the spreadsheet is pretty basic, the concept is rather powerful I reckon. It allows to more easily target those customers with low adoption of Office 365 products. It also allows a IT resellers to start setting goals like – ‘Our aim for this month is to get average Yammer user above 50% for all our customers’. It provides sales and business development types an easy way to target the biggest opportunities in their customer base. And so on, and so on. There are lots of ways that you can use the information that this spreadsheet provides.

Of course, you can take my concept and extend it any way you desire. You can of course simplify it to start out. Use it anyway you want to help your business drive more Office 365 adoption. The important thing is that it gives you a system that you can work to, automate, outsource, delegate, etc. Systems are for winners, so take what I have done, modify it for yourself and go out there and win!

Selling Office 365 Azure options

One thing that many IT resellers don’t appreciate is that when you get Office 365 you also get Azure. You don’t get the “full” Azure that allows you to run things like VMs (that requires a paid subscription), but you get a version with a limited subset of features. These included features that typically relate to Azure AD.

You enable the included Office 365 Azure AD by following these steps:

Enabling your Office 365 Azure AD access

Once you do that you can then use features like:

– Tenant branding

– Single Sign On web portal

– Cloud password reset

– etc

So there are a swag of features in Office 365 Azure that most resellers don’t know exist and are also not generating revenue from.

The above spreadsheet provides a framework to help IT resellers create a product offering around some of these features.

The spreadsheet has a number of tabs:

Summary = summary of generated revenue

Setup = costing for the initial setup of these advanced Office 365 Azure features

Maintenance = costs for the ongoing maintenance of these features

Extend = costs for extending these features beyond the standard provided

So let’s work through an example to give you a better idea of how to use this framework.

Start on the Setup tab. Start in cell C3 which is the fixed costs for Branding an Office 365 tenant. The figure you’d enter in here is you cost to do the branding. Let’s say that it costs about $100 worth of labour. Thus, we enter 100 here.

Cell D3 is the cost per user of enabling this service. Because branding is tenant wide there is no per user set up so there is probably nothing that can be entered here.

Cell E3 is other incidental costs for setting up the service. In the case of branding that may mean things like graphic design, etc. In this example, let’s enter 20.

Cell F3 is where you enter the total number of users in the tenant. For this example enter 15.

The Total column should now calculate to $120 which is the total cost of you enabling this service for the customer. Cell H3 converts that total cost to a per user cost.

Now in cell J3 you enter the margin (as a percentage) you want to add on top of your costs. Here enter 25.

The Total Sell column should now show $150 and cell L3 shows this sell price as a per user cost.

So that’s the product for setting up tenant branding. You can now move to the Maintenance tab and repeat the process to determine a maintenance product for branding. In this case there is probably not a maintenance product you can create for tenant branding since it is kinda a one shot deal. Likewise, there is probably not a product you can create about extending tenant branding beyond what is provided out of the box.

Therefore, let’s move to the second item – SSO portal.

You repeat the same costing and sell process in the Setup tab. There will however this time be a per user set up cost as each user needs their own unique portal. With that line completed on the Setup tab you now have another product.

Moving to the Maintain tab for SSO Portal you can create an ongoing product because updates will be required to the portal, so enter the costs, add some margin and determine the sell price. There’s your next product.

The SSO Portal can be extended with the addition of an Azure AD Premium license to add more features, thus we can again repeat the process for on the Extend tab for the SSO Portal. Part of the costs here will be the costs of an add on license for Azure AD Premium for each user. When complete, there’s another product.

If you now complete the rest of the spreadsheet you should have quite a few products you can now sell to customers individually or bundle up and include elsewhere. Easy eh?

Here’s you challenge. Use this framework and go out to your existing customer base with the products you have created here and sell at least $1,000 of new “products” you didn’t have before you read this post. You should be able to easily accomplish that within a week without too much effort. Start now and let me know how you go and how much more than $1,000 you actually make!

CIAOPS Need to know Webinar–March 2017

Webinar time again! The free March webinar will features the usual cloud updates and news along with open Q & A but our deep dive will focus on Microsoft Teams. You’ll learn what Teams is, how to enable it, create new Teams and determine the resources that they use. Teams is a fundamental change in the way collaboration works inside a business so make sure you don’t miss this event.

You can register now for free at:

March Webinar Registration

The details are:

CIAOPS Need to Know Webinar – March 2017
Thursday 16th of March 2017
11am – 12am Sydney Time

All sessions are recorded and posted to the CIAOPS Academy.

There of course will also be open Q and A so make sure you bring your questions for me and I’ll do my best to answer them.

The CIAOPS Need to Know Webinars are free to attend but if you want to receive the recording of the session you need to sign up as a CIAOPS patron (for only USD$10 per month) which you can do here:

https://www.patreon.com/ciaops

or purchase them individually at:

http://www.ciaopsacademy.com/

Also feel free at any stage to email me directly via director@ciaops.com with your webinar topic suggestions.

I’d also appreciate you sharing information about this webinar with anyone you feel may benefit from the session.

Announcing the free CIAOPS Cloud lecture series

lecture-series

I am please to announce that I have created a new free lecture series at the CIAOPS Academy which you can find here:

Cloud Lecture Series

This is a free series of short topics that I have recorded at my face to face events. Topics include both business and technology and are mainly aimed at an IT Professionals audience. There is information in there to help you grow your cloud business as well as understand technologies like Office 365.

I’ll continue to add to this series over time as I do more events so enrol for free and ensure you check back regularly for the latest content.

February Webinar Resources

https://docs.com/d/embed/D25191508-8189-6254-8310-001748698594%7eMd4186d87-61d5-259a-4d26-00a8bd86cfff

Our February webinar event is all done. You can see the slides either above or download them directly from here:

February 2017 Need to Know Webinar

If you are not a CIAOPS patron you want to view or download a full copy of the video from the session you can do so here:

http://www.ciaopsacademy.com/p/february-2017-need-to-know-webinar/

you can also now get access to all webinars via:

http://ciaops-academy.teachable.com/courses/need-to-know-webinars

for a nominal fee.

Thanks to everyone who attended and I hope to see you again next month when the focus session will be on Microsoft Teams.

Need to Know Podcast–Episode 139

You can’t stop the presses so we’re back with a heap of Azure and Office 365 news. We round up all the Microsoft cloud happenings and then jump into our super special guest, Christophe Fiessinger, Office 365 program manager from Microsoft to talk all about his presentation at Microsoft Ignite Australia:

Get the Latest on Office 365 Groups – Overview, What’s New and Roadmap

You’re invited to discover Microsoft Office 365 Groups. It’s the key component of our group collaboration solution, enabling you to move from task to task with cross application group membership (managed in Azure AD). Office 365 apps that are leveraging groups include Outlook, SharePoint, Yammer, OneNote, Skype for Business, Planner, Power BI, and Dynamics CRM. We’ll unlock the following topics: overview & demonstration, administration, and product roadmap.

Don’t forget to send us your feedback at feedback@needtoknow.cloud

You can listen to this episode directly at:

https://ciaops.podbean.com/e/episode-139-christophe-fiessinger/

or on Soundcloud here: 

Subscribe via iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send us any feedback or suggestions you may have for the show.

Resources

@cfiessinger

@marckean

@directorcia

Azure news from Marc

New Groups integration abilities

Team Flows

Power BI Reports in SharePoint

Azure backup, instant file recovery

Azure CAT

This podcast is brought to you by:

https://cpem.io/tJ01Hzu2k.js?w=640&h=360

 

Need to Know Podcast–Episode 137

Another special Microsoft Ignite Australia 2017 podcast focused on the presenters. This time we are talking with Michael Friedrick about his upcoming sessions:

Jenkins and Azure

See why Jenkins is a great pipeline tool and how you can use it increase the quality and speed of you deployments to Azure. Experience demos on multi-branch pipeline deployment from GitHub to Azure using Jenkins, and see how it integrates with tooling like Microsoft Teams for notifications.

and

Node.js + Azure App Service = 🙂

Explore how open and flexible the Azure App Service is and how easy it is to get going with Node. In a series of demos, you’ll see how automated deployments using Github, custom deployments showing the ability to add additional tasks using Grunt/Gulp and other automated tools, and look at multi branch deployment using a custom CI/CD pipeline. We will also explore Azure Functions, Azure App Service on Linux and deploying Node to Azure using Open tooling such as VS Code.

Don’t forget to send us your feedback at feedback@needtoknow.cloud

You can listen to this episode directly at:

https://ciaops.podbean.com/e/episode-137-michael-friedrich/

or on Soundcloud here: 

Subscribe via iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send us any feedback or suggestions you may have for the show.

Resources

@fredderf204

@marckean

@directorcia

https://jenkins.io/

DevOps fundamentals video

Micheal’s Blog

 

https://cpem.io/tJ01Hzu2k.js?w=640&h=360