Office 365 Power BI

Here’s a nice video showing the features of Power BI (Business Intelligence) for Office 365.

In essence it allows you to easily report on large data sets. There are plenty of really good examples of this already like:

No matter how small a business they can benefit from improved data analysis. Great thing is most already have the tools like Excel and Office365.

What really impressed me in the first video is the natural language queries that were performed towards the end of the video. Honestly, take a look at that and tell me that isn’t firstly really cool and really handy, especially for those no-IT type business owners.

There is so much opportunity around BI in the market and so few resellers seeming to grab it. Even down at the SMB level, BI is huge so if you are wondering how to make money as a reseller in the cloud look at getting into BI for your clients. In simple terms, BI helps customer understand their business by allowing them to quickly analyse their data. You won’t regret it I’ll bet.

Disabling SkyDrive Pro in Office 365

SkyDrive Pro in Office 365 is a personal area where users can store files. Every user in Office 365 currently receives 25GB of space allocated to them, that can be increased up to 100GB if desired. However, what happens if you don’t want users to have access to this web based file storage in office 365? Can it be disabled? Yes it can. Here’s how.

image

A user’s standard SkyDrive Pro looks something like that shown above. To remove this access the first thing you’ll need to do is login as an administrator to the Office 365 portal.

image

In the top right of the portal you’ll find an Admin option, which if selected will display the menu shown above. From this menu select SharePoint.

image

In the SharePoint admin center select user profiles from the menu on the left and then Manage User Permissions from the People section on the right.

image

You should see here that the group Everyone except external users has the rights to Create Personal Site. To prevent any future users from creating or accessing SkyDrive Pro simply Remove this group.

image

If the box is blank, as shown above then no new users will have access to SkyDrive Pro. You can of course individually add users and group in here for whom you wish to have the ability to create SkyDrive Pro at any stage.

What does that look like if a newly created user now attempts to access SkyDrive Pro?

image

When they try and access SkyDrive Pro from the menu across the top of their account by selecting SkyDrive they will be taken to the Newsfeed tab as shown above.

Can you remove the SkyDrive option from the menu bar across the top of the page? Not at this stage.

Now that is all well and good for NEW users, what about that already have SkyDrive Pro set up? Can that be disabled? Yes it can but the process is much more involved.

A users SkyDrive Pro is basically a SharePoint subsite created in the Site Collection:

http://-my.sharepoint.com

under /personal

Now the primary administrator for the Office 365 tenant (i.e. the first login assigned when the tenant was created) has full rights to the site collection

http://-my.sharepoint.com

however they only have read rights (like every other Office 365 licensed user) by default to another individuals SkyDrive Pro. Thus, if that administrator navigates to a users SkyDrive Pro they can view it but not make changes. This needs to be changed so the administrator can take control.

image

To change the ownership of an individual users existing SkyDrive Pro site you need to return to the SharePoint admin center and select Manage User Profiles from the People section in the right hand side of the screen.

image

Now run a search for the user whose SkyDrive Pro you wish to modify. In this case Lewis Collins as shown above.

image

On the right of the Account name you will find a down arrow which when selected will display the menu above. From this menu select Manage site collection owners.

image

By default you will see the users name listed as the Primary and Secondary Site Collection Administrator. You’ll need to remove the user from both locations and the recommendation would be to add the administrator so that the site still can be managed.

image

Thus now, Lewis Collins no longer should have access, only Robert Crane (i.e the tenant administrator) does.

Once that is saved the administrator should now be able to access the URL of the users SkyDrive Pro and be able to edit the site.

image

You’ll know you’ll be able to do that if when you select the Cog icon in the top right of the screen you see a menu like that shown above that includes the menu item Site Settings. Select this item to continue.

image

Select Site Permissions from under the Users and Permissions section in the top left of the page as shown above.

image

Select the user from the list by placing a check mark to the left of their name and then selecting Remove User Permissions from Ribbon menu.

Don’t forget that the user is still a member of the group Everyone except external users, so if you don’t also edit that security group in Office 365 and remove them from there they will continue to have read access.

If however no one except the administrator needs access to this users SkyDrive Pro Site then simply remove the group Everyone except external users using the same process above.

image

In this case we only want the administrator to have access so we have removed everything displayed. The administrator will continue to gain access to the site no matter what rights are modified in the actual SharePoint site because they where made a Site Collection administrator previously.

image

Return to Site Settings using the Cog in the top right hand corner of the window.

Now select Site collection administrators from the Users and Permissions section in the top right as shown above.

image

If any items appear in here that you don’t want to gain access (i.e. the user Lewis Collins) remove them and press OK to save.

image

Return to Site Settings again and this time select People and Groups at the top of the Users and Permissions section.

image

If the user appear here, place a check to the left of their name and then select the Actions menu.

image

From the menu select Delete users from Site Collection.

image

Press OK to continue.

You might ask why didn’t I do that first and remove the user from the Site Collection in one action? The reason is, I wanted to illustrate how many locations it is possible to provision rights. I would therefore highly recommend you check all areas I have run through here to ensure the user no longer appears.

So finally,

Before, with normal SkyDrive Pro access:

image

After, with no SkyDrive Pro access:

image

Now when a user visits their SkyDrive Pro they will no longer see any files or they will no longer be able to upload documents. Basically, they have no access.

You need to beware of the fact that a users SkyDrive Pro area is a dedicated SharePoint site in which the user has full admin rights when it is created. This means that can change permissions, create subsites with different permissions and so on. It is like giving users full access to a folder on a network drive.

The easiest way to prevent a user from accessing SkyDrive Pro is to disable the account or remove their rights to SharePoint, however the above scenario illustrates that you can still permit access to SharePoint but not SkyDrive Pro, even if SkyDrive Pro for that user has already been created. It is a lot of work to do that but at least you know how to if you need to. Just beware that there may be further permissions enabled by a user (perhaps giving buddy hidden access) that you may have to dig out. Finger crossed, most users won’t alter the defaults but beware they certainly have the power to if they want by default!

Office Web Apps improvements

You have always been able to work on documents simultaneously in Office Web Apps and Word on the desktop with SharePoint Online in Office 365, the only difference was that it would do a paragraph lock. This differed from the Google Docs approach which showed you real time editing of everyone. Basically you could follow every change they made to a document. Microsoft’s research indicated that was distracting to authors (and it is for me I know) so that is why they initially did it the way they did.

However, it seems that having the ability to see people individually editing every item in a document has won out, so Microsoft has now updated it’s Office Web Apps in SkyDrive and Office 365 to include this feature. You’ll get a better idea of what it looks like in this video:

This now makes the Office 365 editing experience more like that in Google Docs and removes a perceived difference between the products (and to be honest what appeared like a limitation in Office 365 even though it wasn’t). That is great news for Office 365 and makes the sell to customers who want a Google Apps like web editing experience much easier.

It will be interesting to see what Google does about this as puts the ball back in their court to come up with another differentiator. In fact, I think it puts the pressure squarely on them to come up with something as rich as what Office Web Apps is. Google Apps is looking pretty basic compared to Office Web Apps these days I reckon.

CIAOPS November Virtual Meeting–Resources

After a bit of a technical hiccup during the meeting yesterday I decided to re-record the video which you can now on my YouTube channel:

Here are the remaining resources I mentioned during the meeting:

Some resources on the Office 365 Public web site:

Office 365 Public website examples:

I hope to see you at the next meeting on December 4th featuring Boon Tee talking about on premise server integration with Office 365. Registrations will be available shortly.

Additional versions of recent SharePoint Online book

GSWSP2013E

As promised, additional versions (ePub and Kindle) of my latest book “Getting Started With SharePoint Online 2013 for Enterprises” are now available from:

www.ciaops.com/publications

Although this book is aimed at people with Office 365 E and M plans much of it still remains relevant for those on P plans.

I’d also appreciate you letting others know about this work as it takes many, many hours to create and edit these books and at a sale price of less that five dollars I REALLY need to sell a lot to even break even, so any assistance you can provide really does go a long way.

Look out for additional titles soon.

CIAOPS Virtual Technology meeting–reminder



Don’t forget the CIAOPS Virtual Technology meeting this Wednesday the 6th of November from 4pm Sydney time. Registrations are still available via:
https://ciaops1113.eventbrite.com.au/
At this meeting I’ll be doing a presentation and demonstration of the Office 365 public web site basics and capabilities. The details of the session are:
You may not be aware that every Office 365 plan that includes SharePoint Online comes with the ability to create a public website linked to any domain. In this demonstration you’ll learn how to configure this public website and how to customize it for your needs.
There will also be the usual news, product updates, general discussion as well as questions and answers.
So if you want to get the latest make sure you register now.
I look forward to seeing you on the day.

Training and certification opportunity from Microsoft

image

I am pleased to announce that Microsoft Australia is planning a new training and certification campaign, Ready, Cert, Go which I will be involved with.

To start off with there will be complimentary 60 minute instructor lead tutorial webcasts in November which will cover the topic to be offered in full day exam prep courses in December 2013 at Microsoft in Sydney.

Here are the links to the upcoming webinars:

Server and Tools

Monday – 4 November 2pm, System Center 2012 (Exam 70-247)

Tuesday – 5 November 12pm, SQL Server 2012 (Exam 70-462)

Wednesday – 6 November 12pm, Windows Server 2012 (Exam 70-410)

Thursday – 7 November 12pm, Windows 8 (Exam 70-688)

Friday – 8 November 12pm, Windows Azure (Exam 70-487)

You can register for these webinars at:

https://training.partner.microsoft.com/learning/app/management/registrationex/LMS_Registration.aspx?UserMode=0&Mode=0&ActivityID=852862

Business Productivity

Monday – 4 November 12pm, SharePoint 2013 (Exam 70-331)

Tuesday – 5 November 2pm, Lync (Exam 70-337)

Wednesday – 6 November 2pm, Exchange (Exam 70-341)

Thursday – 7 November 2pm, Office 365 (Exam 74-325) (with me!)

Thursday – 7 November 3pm, Office 365 (Exam 70-321) (with me!)

You can register for these webinars at:

https://training.partner.microsoft.com/learning/app/management/registrationex/LMS_Registration.aspx?UserMode=0&Mode=0&ActivityID=852931

Here are the dates for the Exam Preparation Sessions, designed to get you across the line, first time. It’s $150 per day and includes an Exam Voucher, which is usually $206:

Server and Tools

Monday – 9 December, System Center 2012 (Exam 70-247)

Tuesday – 10 December, SQL Server 2012 (Exam 70-462)

Wednesday – 11 December, Windows Server 2012 (Exam 70-410)

Thursday – 12 December, Windows 8 (Exam 70-688)

Friday – 13 December, Windows Azure (Exam 70-487)

You can register for these certification days at:

https://training.partner.microsoft.com/learning/app/management/registrationex/LMS_Registration.aspx?UserMode=0&Mode=0&ActivityID=852912

Business Productivity

Monday – 9 December, SharePoint 2013 (Exam 70-331)

Tuesday – 10 December, Lync (Exam 70-337)

Wednesday – 11 December, Exchange (Exam 70-341)

Thursday – 12 December, Office 365 (Exam 74-325) (with me!)

Friday – 13 December, Office 365 (Exam 70-321) (with me!)

You can register for these certification days at:

https://training.partner.microsoft.com/learning/app/management/registrationex/LMS_Registration.aspx?UserMode=0&Mode=0&ActivityID=852965

Even though I am giving the Office 365 content I have signed up myself for the SharePoint and Lync sessions as I see this as a great opportunity to not only learn about the product but also hopefully pass the certification. I’d love to do the Windows 8 and Azure sessions as well, alas, not to be this time.

I hope to see you there at the webinar or on the day.

Getting Started With SharePoint Online 2013 for Enterprises

GSWSP2013E

I am proud to announce the completion of another Office 365 book. This one is titled Getting Started With SharePoint Online 2013 for Enterprises and is the longest book I have written to date at 275 pages!

Abstract

This book helps novice users understand the basic usage and operation of SharePoint Online 2013 that is available via the Office 365 Enterprise and Mid-Sized plans. It examines the following basic components of SharePoint Online: Documents, Calendars, Tasks, Picture Libraries, Recycle Bin, Search, Site Notebooks, Public website and more. The reader will be taken through a tutorial process on how to use each item. Much has changed since previous versions of SharePoint and Office 365, however there are still some similarities. This book may also provide some insight into the basics of SharePoint Online 2013 for Small Business Office 365 plans as well. It will show you how to start interacting with SharePoint Online 2013 so it can be put to use in your business as well as provide a number of resources for continuing familiarity with SharePoint Online 2013.

This booked is aimed at users who have never used SharePoint Online 2013 or Office 365 plans.

Price = AU$4.95

You can purchase this directly from my publication page at:

http://www.ciaops.com/publications

along with all my other works. You can also view the table of contents to get a better idea of what the book contains. the ePub and Kindle version will be available soon from my publications page as well as other book resellers.