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

APIs all day long

We at the Puzzler Brigade love us some APIs. We have used 3 to enrich our solution.

First we are using the Marvel API to get superhero images and information about each super hero on our Hero Dashboard.

Screen Shot 2016-02-27 at 2.34.31 PM

Next we are using the Flickr API to get images of the cities our operations are taking place in. We are using longitude and latitude to search for images in the area of the operations (Latitude, Longitude is attached to each Operation Room). We then append “Skyline” to get better results.

Screen Shot 2016-02-27 at 2.34.19 PM

We are also using Chart Holdr for getting mockup dummy stats.

Screen Shot 2016-02-27 at 3.03.04 PM

We are going for the Stairway to Heaven badge!

Badge-StairwayToHeaven

 

 

 

Final Delivery – DQC Comics – Hero 4 Hire

DQC-Comics proudly announce Hero 4 Hire. The ultimate superhero management platform!

For our customers we provide webforms and mobile applications for your superhero needs

The hero will be within your disposal at the time of your choosing.

For our superheroes we provide great overview of their assignments. When a customer places an order the superhero will be notified.  office 365 group and planner for collaboration and overview.

For management we provide a platform for resource planning of all of the superheroes. With Great dashboards we provide the right people with the right information, at the right time to be able to make valuable business decisions.

fff

We hereby claim the “Extreme business Value” , “Killer App” nad “Consumer Commercial”

 

Posted in DQC

Puzzler Brigade ASPC2016 Final Submission

Our Danger Room situational awareness Office 365 solution is something that any Superhero would want to have in their utility belt. It allows “Task Masters” back home to monitor and keep our Superheroes up to date with what is happening around them.

Check our what we can offer you for only $499 a month per Hero!