the CourseGrinder!

This Azure Function will analyze the business competency and operational data and update the SharePoint lists accordingly.

image

How it works
  1. Get all users with user profiles that are active
  2. Get all departments from the Departments-list.
  3. Run a rule analysis on the employees and the operational status
  4. Update the Departments-list with the result from the rules.
What’s supported?

Right now, it detects whenever someone loses skills or competencies that they need to have, as well as if they’re nearing the maximum age.

PowerUser Lovin’

The Power User has a window where she can choose what to administer.
image

Choose a course and drag and drop the available modules you would like to have in the course, and rearrange them in whichever order you want. The interface for administrating steps in a module is exactly the same.
image

Dragging and dropping is the way to go! Smilefjes
image
Got a smart phone? Here’s how it looks on that:
image

Competance is always The Factor!

In EDU:POINT either the Bot or the Business Factor Analyzer and/or the end user itself will enlist and take courses. Finalized with an exam to update Skills, CV and also BFA grabs that score.Here’s the look and feel for the end users:

image

Track your progress in the status window. Thumbs up for every module that you have finished, and right arrow for the remaining modules. Click on the RED button for the next module (you can’t skip a module, no Sir!), and read information about the module if you’d like to know more.
image

When the user has started the next module, he or she will have to go through all the steps in the module, and perhaps even answer some questions to get to the next step. All done by content type hub and BFA magic! Smilefjes
image

At the end
image

Off course it’s responsive design, works on any device.

PowerBi – Dynamics 365

How to add custom fields to your power bi datasets.
As we know this is not supperted in powerbi online.
Found a neat little trick.
Get Power BI desktop
Add Data From Dynamics 365.

 image

Go to developer resources in Dynamics 365
Copy the url to the organization service: for me that was https://edupoint.api.crm4.dynamics.com/XRMServices/2011/Organization.svc
Edit
and make the endpoint OrganizationData.svc

 image

Connect. Presto! You now have access to your custom field data.

 image

Eport your dataset to powerbi online.

HR Manager -you got help!

Here is the >PS script to help HR! the Excel file inside Office365 for full control on the users. Get full control on licenses, whos leavin’ (your’ fired!) and whos hired, lisenses and assets.
PART1:

We got an Excel file
image 

Managers can easyli add new users or modify existing users. (also you got versioning and Nintex WorkFlos to support that)
image
Put the users in to that Azure AD as a dude with approp access rights (aka admin guy)
Simply just run this PowerShell script. That uses WebDav to add the Office365 dimenzione to yor laptop.

And offcourse a full data report on the users you entered metadata from AzureAD, huraiiij you can use this to modify users attribs
image

I have no Idea why MS got IsBlackBerryUser attrib inside Azure
image
Here’s the PowerShell script:
#PART 1 – Connect to MSOL
$Cred = Get-Credential # Create a variable $cred
Connect-MsolService -Credential $cred
# E3, E5, Small Business etc
Get-MsolAccountSku
#
# lookilook
# Get-MsolUser

#PART 1 – Connect to MSOL
$Cred = Get-Credential # Create a variable $cred
Connect-MsolService -Credential $cred
# E3, E5, Small Business etc
Get-MsolAccountSku
#  leave those things in your bag
# Set working directory to maped drive
cd i:\
# PART2 Map network drive against O365
$mappath = ‘\\aspc2017.sharepoint.com@SSL\DavWWWRoot\SiteAssets’ #Replace yourtenant
        NET USE I: $mappath /PERSISTENT:YES
        Sleep -seconds 7  # this is just in case it takes a while
# PART 3 Bulkimport Users
# -DisplayName,FirstName,LastName,UserPrincipalName,Department,PassWord,UsageLocation,LicenseAssignment
#
$users = Import-Csv “Users.CSV”
$users | ForEach-Object {
New-MsolUser -DisplayName $_.DisplayName -FirstName $_.FirstName -LastName $_.LastName -UserPrincipalName $_.UserPrincipalName -Department $_.Department -PassWord $_.PassWord -UsageLocation $_.UsageLocation -LicenseAssignment $_.LicenseAssignment } | Export-Csv -Path “\UsersAdded\MatrixUsersCSV.csv” -NoTypeInformation
# PART 3 Bulkimport Users
# -DisplayName,FirstName,LastName,UserPrincipalName,Department,PassWord,UsageLocation,LicenseAssignment
#
$users = Import-Csv “Usersmore.CSV”
$users | ForEach-Object {
New-MsolUser -DisplayName $_.DisplayName -FirstName $_.FirstName -LastName $_.LastName -UserPrincipalName $_.UserPrincipalName -Department $_.Department -PassWord $_.PassWord -UsageLocation $_.UsageLocation -LicenseAssignment $_.LicenseAssignment } | Export-Csv -Path “\UsersAdded\MatrixUsersCSV.csv” -NoTypeInformation
# OPTIONAL PART 4 (Your’ fired says Donald, just simply delete users from the report file > achaaa that’s cool ai???
#####################
#XXX Bulk delete XXXX
#####################
# Remove the # if you like to delete the  users from the export file
#users = Import-Csv \usersadded\MatrixUsersCSV.csv
#$users| foreach-object {
#Remove-MsolUser -UserPrincipalName $_.userprincipalname -Force}
#
####
# XXX Delete non licensed users XXX
# Get-MsolUser -All -UnlicensedUsersOnly | Remove-MsolUser -Force

Thank You! Smilefjes

Excel add-in updated – fresher now

After some feedback from the judges that our excel add-in was dull and rather boring, we decided to freshen it up a little. It now uses Office UI’s bootstrap-style scaling for the table data, so it looks a little better, and we also added the ability to add a nice color-coded chart which can be refreshed to contain the live data from the bar.

BeerApp3

 

Aiming for the office ui fabric bonus and

Glossy and dashing dashboards.

Let’s say the Mole Man’s armies have attacked New York yet again, and our brave heroes would like to celebrate the victory with a beer. If the Hulk showed up at Point One Arms, as all super heroes do after a battle, he would not be very pleased if his favourite beer was out of stock.

Therefore, the poor SHIELD agent in charge of the bar for the evening must be able to check the stock, and order refill while fighting off one of Mole Man’s creatures. To do that, the site must be responsive on all devices; desktop, tablet and mobile.

The interface uses a Flat UI bootstrap framework, and a responsive PnP spe-seattle-responsive CSS as a foundation, and added a few bits and tweaks on our own.

We have updated the navigation and header bar a bit. We have also added a button that will hide the sharepoint and office 365 topbars in case you need more space for your dashboards on your surface, helge. Not everyone is as vertical as Fredrik. Your choice is stored in localStorage so it persists between sessions.

Open:
open

Closed:closed

Desktop view:1 2 3 4

On a tablet:tablet

On a mobile phone:Screenshot_2016-02-27-10-58-47

 

We’re aiming for the Glossy Pixels badge:

glossy