Month: April 2014

Posted on

Top Rated Sessions at SPC14

Here is the top rated sessions from SPC14:

Office
365 service communications to customers		 Ian Hameroff 5.00
Yammer mining
– dig in and "listen" to what your big *social* data is saying		 Richard diZerega 4.91
SharePoint
2013 Search display templates and query rules		 Matthew McDermott 4.90
3rd party
JavaScript libraries you need to know		 Scot Hillier 4.87
SharePoint
Online Management and Control		 Chris Bortlik 4.87
Leverage what
you already know about SharePoint as you move into 2013		 Scott Jamison 4.86
The nuts and
bolts of upgrading to SharePoint 2013		 Todd Klindt 4.85
Making
SharePoint Collaboration Rock by Increasing Discoverability		 Scott Jamison 4.84
Advanced—and
Easy!—BI with Excel and SQL Server Data Mining		 Rafal Lukawiecki 4.83
Subordinate
integrity: Certificates for SharePoint 2013		 Spencer Harbar 4.83
Customizing
Search experiences with Azure Hosted Data and Bing Maps		 Rainer Asbach, Timo
Heidschuster, Johannes Lemmerer		 4.82
Futuristic
Search applications using Kinect and Yammer!		 Chris Givens, Ben
Lower		 4.82
Building
SharePoint Apps with Windows Azure Platform as a Service		 Kirk Evans 4.81
Complex
problem solving with the new HTML5 APIs		 Scot Hillier 4.80
Cargill:
Real-world challenges and value in introducing enterprise social		 Melanie Hohertz 4.80
Beyond
Deployment: How IT Can Inspire, Motivate And Drive Sustainable Adoption?		 Cyrielle Simeone, Dux
Raymond Sy, Steve Caravajal		 4.80
The strategy
behind building a successful social intranet		 Joel Oleson 4.80
Nationwide:
Building a World-Renowned Intranet with SharePoint 2013 and Yammer		 Jeff  Schumann, Chris  Plescia , James Tsai, Shawn Domer, Matt
Huber		 4.79
Multi-factor
authentication for SharePoint 2013 and SharePoint Online		 Liam Cleary 4.79
Comprehensive
User Profile Synchronization		 Spencer Harbar 4.78
Deep dive on
self-service data retrieval With Power Query		 Matt Masson 4.78
Build your
own REST service with WebAPI 2		 Scot Hillier 4.78
SharePoint
data security and compliance		 Liam Cleary 4.77
AMD: 13
Million Users. 54 Million page views. www.AMD.com on SharePoint 2013. Done.		 Bruce Weatherford,
Michael Mielke, Gil Canare, Katie Bowman		 4.77
SharePoint
Business Continuity Management with SQL Server Always On		 Neil Hodgkinson,
Wayne Ewington		 4.76
SharePoint
Online Performance – Designing your Pages to be Fast		 Phil Newman 4.76
Best Buy: The
rise of the ninjas—a SharePoint 2013 user adoption story		 Matthew Ruderman,
Sarah  Haase		 4.74
How to manage
and troubleshoot Search: A practical guide		 Brian Pendergrass,
Jon Waite		 4.73
Using
SharePoint as the canvas for student creativity and inspired solutions		 Louis Zulli Jr 4.73
Site
provisioning techniques with SharePoint apps		 Bert Jansen, Vesa
Juvonen		 4.73
Operational
reporting and dashboarding using Microsoft Business Intelligence Solutions		 John White 4.73
Federating
applications with Office 365 using Windows Azure Active Directory		 Paolo Pialorsi 4.72
Work like a
network: The power of Enterprise Social		 Jared Spataro 4.71
Managing
Search Relevance in SharePoint 2013 and O365		 David Louis
Hollembaek, Mikael Svenson		 4.71
Introducing
Codename Oslo and the Office Graph		 Cem Aykan, Ashok  Kuppusamy  4.71
Branding
Internet facing web sites with SharePoint in the cloud		 John Ross, Randy
Drisgill		 4.71
When should
we use SharePoint out-of-the-box, add third-party apps or build custom
solutions?		 Richard Harbridge 4.70
SharePoint
2013 Apps with AngularJS		 Jeremy Thake [MVP] 4.69
Stress
testing and optimizing SharePoint 2013 shredded storage with traditional and
RBS storage		 Chris McNulty 4.69
Simple
Options for Identity Management with Office 365		 Paul  Andrew   4.68
Deep dive:
SharePoint and Office App Security Model (OAuth & S2S) 		 Ted Pattison 4.68
Make your
SharePoint portal social in 1-2-3!		 Runar Olsen, Thomas
Molbach		 4.68
Best
practices for breaking down organizational barriers using Yammer		 Allison Michels,
Steve Nguyen		 4.67
Azure IaaS
and SharePoint 2013 WCM – better together!		 Barry Waldbaum, Frank
Marasco		 4.67
SharePoint
2013 demystified		 Dan Holme 4.66
Using Windows
PowerShell with SharePoint 2013 and SharePoint Online		 Shane Young 4.65
Anyone can
build a SharePoint App with Microsoft Access		 Jeff Conrad, Chris
Usher		 4.65
Automating
SharePoint operations and governance: site provisioning and group management		 Dan Holme 4.64
Search
architecture and sizing in SharePoint 2013		 Barry Waldbaum,
Thomas Molbach		 4.64
Developing
Cloud-Hosted Apps with MVC5		 Bob German 4.64
The Cloud:
Navigating the benefits and challenges of this disruptive innovation		 Dan Holme 4.64
Optimizing
SQL Server 2012 for SharePoint 2013		 Brian Alderman 4.64
Deliver
adaptive and personalized experiences for your SharePoint 2013 sites		 Ryan Sockalosky 4.64

 

Posted on

All O365 MVPs Blogs and Twitter Handles

Updated as of 6/3/1024:

Since I am doing a lot with the O365 APIs at the moment, I figured it would be good to drop the O365 MVP list in addition to the SharePoint one.  I also attached the script to follow all of them below.  So here you go:

Name Blog Twitter
Alberto Pascual (Alberto Pascual) Blog guruxp
Alexandru Dionisie Blog AlexDionisie
Alvaro dos Santos Rezende Blog
Amin Tavakoli Blog amintvk
Arnaud Blog
Ayman Mohammed El-Hattab Blog aymanelhattab
Ben Curry Blog
Benoit HAMET Blog benoit_hamet
Brendon Ford Blog stewartisland
Brett Hill Blog bretthill
Brian Nøhr Blog Bsnohr
Dan Holme Blog
Danny Burlage Blog
Darrell C Webster (Darrell Webster) Blog DarrellCWebster
Diogo Dias Heringer Blog
Dragan Panjkov Blog panjkov
Eunjoo Lee (Eunjoo Lee) Blog
Fernando Andreazi Blog fandreazi
Genki Watanabe Blog
Gilles Pommier Blog
Goran Husman Blog
HeeJin Lee (Hee Jin Lee) Blog
Igor Pavlekovic Blog igorpnet
Jeremy Dahl Blog
Jesper Ståhle Blog JesperStahle
Jethro Seghers Blog jseghers
JinHwan Woo Blog
Jorge Castañeda Cano Blog xorxe
Kazuhiko Nakamura (?? ??) Blog
Kelsey Epps Blog kelseyepps
Kerstin Rachfahl Blog himmlischeit
Laurent Miltgen-Delinchamp Blog
Loryan Strant Blog thecloudmouth
Malin Dandenell Blog
Mario Cortes Flores Blog
Markus Widl Blog markuswidl
Martina Grom Blog magrom
Masayuki Mokudai (????) Blog Office365Room
Mauricio Cassemiro Blog
Michael Kirst-Neshva Blog ankbs
Myles Jeffery Blog
Naoki Osada Blog
Nitin Sadashiv Paranjape Blog
Nuno Árias Silva (Nuno Árias Silva) Blog NunoAriasSilva
Paul Woods Blog paulwoods
Poo Ching Loong Blog
Raphael Köllner Blog ra_koellner
Rene Dominik Modery Blog modery
Robert D. Crane Blog
Sara Barbosa Blog Sarabarbosa
Sean McNeill Blog s_mcneill
Seiji Noro (?? ??) Blog
Steve Noel Blog CloudItca
Tomislav Bronzin (Tomislav Bronzin) Blog tbronzin
Vincent Choy Blog
Yoni Kirsh Blog
Yoshihide Sakamoto Blog
Zeljka Knezovic Blog zeljkak
Zoltan Zombory (Zombory Zoltán) Blog zomby_z
Peter van Hees Blog mrpetrovic
Posted on

SharePoint 2013 Birthday Reminder Workflow

I haven't seen anyone blog this in 2013 style, so here we go. This workflow will send an email to people every year on the day someone has a birthday.  Here's the step by step of how to create this birthday reminder workflow!

STEP 1:  Create a Birthday Calendar!

STEP 2:  Fire up SharePoint Designer 2013, connect to your site

STEP 3:  Create the workflow

  1. In the navigation, click "Workflows"
  2. In the ribbon, click "List Workflow", select your calender list

  3. For the name, type "Reminder Workflow"
  4. For the type, ensure that "SharePoint 2013 Workflow" is selected:

  5. Click "OK"

STEP 4:  Configure the "Set ExecuteDate" stage

  1. Rename "Stage 1" to "Set ExecuteDate"
  2. Click in the stage, start typing "Set a workflow variable", press ENTER
  3. Click the "workflow variable" link, then select "Create a new variable"
  4. For the name, type "ExecuteDate"
  5. For the value, select "DateTime"
  6. Click "OK"
  7. Click the "value" link, then click the "Fx" button
  8. For the data source, select "Current Item"
  9. For the Field, select "Start Time"
  10. Click "OK"
  11. Click below the set workflow variable action
  12. Start typing "If value equals", press ENTER
  13. Click the first "value" link, then click the "Fx" button
  14. Select "Workflow Variables and Parameters"
  15. Select "Variable: ExecuteDate"
  16. Click "OK"
  17. Click the "equals" link, change the value to "is less than"
  18. Click the second "value" link
  19. Click the "…" button, select "Current Date"
  20. Click "OK"
  21. In the if condition, start typing "Add Time to Date", press ENTER
  22. Click the "0" for the months, set it to "12", press ENTER
  23. Click the "date" link
  24. Click the "value" link
  25. For the data source, select "Current Item"
  26. For the Field, select "Start Time"
  27. Click "OK"
  28. Click the "Variable: date" link, select "Variable: ExecuteDate"
  29. Click below the "Set ExecuteDate" stage, in the ribbon, click "Stage", a new stage should be added
  30. Change the name of the new stage to "Pause For ExecuteDate"
  31. In the "Set ExecuteDate" stage's transition to stage area, start typing "go to stage", press ENTER
  32. Select the "Pause For ExecuteDate" stage
  33. The stage should look like this:

STEP 5:  Configure the "Pause For ExecuteDate" stage

  1. Start typing "If value equals", press ENTER
  2. Click the first "value" link, then click the "Fx" button
  3. Select "Workflow Variables and Parameters"
  4. Select "Variable: ExecuteDate"
  5. Click "OK"
  6. Click the "equals" link, change the value to "is greater than"
  7. Click the second "value" link
  8. Click the "…" button, select "Current Date"
  9. Click "OK"
  10. In the if condition, start typing "Pause until…", press ENTER
  11. Click the "this time" link, select the "Variable: ExecuteDate"
  12. Click below the "Pause For ExecuteDate" stage
  13. In the ribbon, click "Stage"
  14. Rename the new stage to "Send Email"
  15. In the "Pause For ExecuteDate" stage's transition to stage area, start typing "go to stage", press ENTER
  16. Select the "Send Email" stage
  17. The stage should look like this:

STEP 5:  Configure the "Send Email" stage

  1. Start typing "If value equals", press ENTER
  2. Click the first "value" link, then click the "Fx" button
  3. Select "Workflow Variables and Parameters"
  4. Select "Variable: ExecuteDate"
  5. Click "OK"
  6. Click the "equals" link, change the value to "equals (ignoring time)"
  7. Click the second "value" link
  8. Click the "…" button, select "Current Date"
  9. Click "OK"
  10. In the if condition, start typing "Email", press ENTER
  11. Click "these users"
  12. Select a sharepoint or ad group that you want to email
  13. For the subject, click the "Fx" button, select the "Current Item: Title", click "OK"
  14. In the body, type "Happy Birthday!"

  15. Click "OK"
  16. Below the Email action, start typing "Add Time", press ENTER
  17. For the month, type "12"
  18. For the two variables, set them to "Variable: ExecuteDate"
  19. Below the if condition, start typing "If value", press ENTER
  20. Click the first "value" link, then click the "Fx" button
  21. Select "Workflow Variables and Parameters"
  22. Select "Variable: ExecuteDate"
  23. Click "OK"
  24. Click the "equals" link, change the value to "is less than"
  25. Click the second "value" link
  26. Click the "…" button, select "Current Date"
  27. Click "OK"
  28. Below the if condition, start typing "Add Time", press ENTER
  29. For the month, type "12"
  30. For the two variables, set them to "Variable: ExecuteDate"
  31. In the "Send Emails" stage's transition to stage area, start typing "go to stage", press ENTER
  32. Select the "Pause For ExecuteDate" stage
  33. The stage should like this:

STEP 6:  Set the Workflow firing actions

  1. In the navigation breadcrumb, click the "Reminder Workflow" node
  2. On the workflow properties page, in the "Start Options" section, check the "Start workflow when an item is created" checkbox:

  3. Press "Ctrl-S" to save the workflow
  4. In the ribbon, click "Publish"

Create an item, fire the workflow!

Enjoy!
Chris

Posted on

Extending SharePoint 2013 REST APIs

As promised, here is my blog post on how to extend SharePoint 2013 REST APIs! This post is similar in technical depth as the Extending Ceres engine post here.

The general premise is to add your own end points to the REST APIs in an on-premise environment.  This is a totally valid scenario similar to extending sharepoint with your own Service Applications.  This technique is used by the Project Server team (totally different team from the SharePoint team) to extend the ProjectServer and ProjectData REST end points.  I have published the sample project here. Here are the high level steps of what you must do:

  1. Create a class decorated with ClientCallableType
    1. Set the name to the same name as the class
    2. Generate a new ServerTypeId set it
    3. Set the FactoryType to a Object Factory that you will create next
  2. Add methods and properties to the class, decorate with ClientCallable, ClientCallableMethod, ClientCallableProperty
  3. Create the Object Factory that inherits from ClientCllableObjectFactory (this will create an class instance using an identifier)
    1. Decorate the class with the Clietn
    2. CallableObjectFactory attribute, set the ServerTypeId to the one you generated for the class
    3. Implement the GetObjectById method
  4. Create a ServerStub class that inherits from Microsoft.SharePoint.Client.ServerStub
    1. Decorate the class with the ServerStub attribute, set the type to the class type, set the TargetTypeId to the ServerTypeId
    2. Implement a public constructor
    3. Override the following properties and methods
      1. TargetType (returns typeof(class))
      2. TargetTypeId
      3. TargetTypeScriptClientFullName (the name of your client target type you will create next)
      4. ClientLibraryTargets (what clients can call your rest endpoint)
      5. GetProperty Method
      6. InvokeConstructor method (for both the CSOM and REST calls)
      7. Constructor implementations called from InvokeConstructor
      8. InvokeMethod (this calls the object's method)
      9. GetMethods (this is required to tell the $metadata endpoint what is available)
      10. GetProperties (similar to GetMethods)
  5. Create another class in a .Client namespace
    1. Decorate it with the ScriptType attribute, set the name and ServerTypeId
    2. Make it inherit from ClientObject
    3. Create the properties and methods that match to your server side class
  6. Create a ScriptTypeFactory that implements the IScriptTypeFactory interface
    1. Implement the IFromJson method, use a switch statement to generate a Client class object based on the scriptType string
  7. Create the ProxyLibrary.xxx.xml file
    1. Deploy to the {SharePointRoot}/ClientCallable directory
  8. Open the project's AssemblyInfo.cs file
    1. Add a UrlSegmentAliasMap attribute
    2. Add a ClientNamespaceMap attribute
    3. Add a ClientTypeAssembly attribute
  9. Deploy the Farm Solution
  10. Perform an IIS Reset
  11. Hit a "_/api/$metadata" endpoint, you should see your end point displayed!

Enjoy!
Chris

 

Posted on

Random MVP Stats

Last year (2014), 24 never before SharePoint MVPs were honored:

firstname lastname blog twitter country
Alistair Pugin (Alistair Pugin) http://www.ecmninja.co.za alistairpugin South Africa
Brandon Atkinson http://brandonatkinson.blogspot.com/   United States
Chris McNulty   cmcnulty2000 United States
Christopher Clement http://christopherclementen.wordpress.com/ ClemChristopher Belgium
Colin Phillips http://mmman.itgroove.net itgroove_colin Canada
David Sánchez Aguilar http://davidsanchezaguilar.wordpress.com davidsancheza Costa Rica
Eric Riz   rizinsights Canada
Heber Lopes http://www.heberlopes.com.br heberolopes Brazil
Jason Warren http://www.habaneroconsulting.com/insightsby?Author=jason-warren jaspnwarren Canada
Keith Tuomi http://yalla.itgroove.net   Canada
Margriet Bruggeman http://www.sharepointdragons.com margrietvuur Netherlands
Marius Constantinescu http://nettitude.wordpress.com c_marius Switzerland
Melick Rajee Baranasooriya http://melick-rajee.blogspot.com/ MelickRajee Sri Lanka
Nicki Borell http://www.sharepointtalk.net/ NickiBorell Germany
Roger Haueter http://www.techtask.com techtask Switzerland
Chris Givens https://blogs.architectingconnectedsystems.com givenscj United States
Gokan Ozcifci http://gokanx.wordpress.com GokanOzcifci Belgium
Hemendra Agrawal (Hemendra Agrawal)     India
Hirofumi Ota   hrfmjp Japan
Miguel Tabera (Miguel Tabera) http://www.sinsharepointnohayparaiso.com migueltabera Spain
Romeo Donca (Romeo Donca) http://www.romeodonca.ro/ romeodonca Romania
Thomas Vochten http://thomasvochten.com ThomasVochten Belgium
Vlad Catrinescu http://www.absolute-sharepoint.com   Canada
Wesley Hackett http://weshackett.com weshackett United Kingdom

By Country Breakdown:

5    Canada
3    Belgium
3    United States
2    Switzerland
1    United Kingdom
1    Brazil
1    Costa Rica
1    Germany
1    India
1    Japan
1    Netherlands
1    Romania

 

Posted on

Current SharePoint MVP Blogs and Twitter handles

As of today 6/3/2014 (this is from your MVP Profile, so if you ain't here, its your own fault!).  Also a script to automatically follow all the MVPs is here and an OPML file to add to your RSS feed reader:

Name Blog Twitter
Michael Greth Blog mysharepoint
Daniel Wessels Blog mosslive
Robert L. Bogue Blog
Spencer J Harbar Blog
Ted Pattison Blog
Loke Kit Kai Blog
Andrew Connell Blog andrewconnell
Sahil Malik Blog
Shane Young Blog
Eli Z. Robillard Blog
Dave McMahon Blog
Steve Smith Blog
Pierre Vivier-Merle Blog
Todd S Baginski Blog toddbaginski
Wouter van Vugt Blog
Fabian Moritz Blog FabianMoritz
Matthew McDermott Blog MatthewMcD
Saifullah Shafiq Ahmed Blog walisystems
Liam Cleary Blog helloitsliam
Steve Sofian Blog ssofian
Penelope Coventry Blog pjcov
Ishai Sagi Blog ishaisagi
Rob Foster Blog
Ben Robb Blog benrobb
Andrew Woodward Blog
Reza Alirezaei Blog
Asif Rehmani Blog asifrehmani
David Mann Blog
Gaetan Bouveret Blog
Gary Lapointe Blog glapointe
Igor Macori Blog imacori
Joy Rathnayake Blog
Ed Musters Blog
Mohammed A. Saleh Blog mohkanaan
Stéphane Eyskens Blog stephaneeyskens
Agnes Molnar Blog
Juan Andrés Valenzuela Blog jandresval
Chris O'Brien Blog ChrisO_Brien
Paul Papanek Stork Blog pstork
Muhammad Imran Khawar Blog
Alex Pearce Blog
Debbie Ireland Blog debbieireland
Serge Tremblay Blog Sergepoint
Waldek Mastykarz Blog waldekm
Wes Preston Blog idubbs
Riwut Libinuko Blog cakriwut
Randy Drisgill Blog
Carsten Keutmann Blog
Alain Lord Blog djlordee
Valy Greavu Blog valygreavu
James Milne Blog JamesMilne
Sean Wallbridge Blog itgroove
John D. Ross Blog johnrossjr
Steve Curran Blog spsteve
Becky Bertram Blog beckybertram
Kanwal Khipple Blog kkhipple
Rouslan Grabar Blog
Nicolas Georgeault Blog ngeorgeault
Mirjam van Olst Blog mirjamvanolst
John Timney Blog
Mike Oryszak Blog
Wictor Wilen Blog
Todd Klindt Blog
Rob Windsor Blog robwindsor
Adams Chao Blog
Ai Yamasaki Blog ai_yamasaki
Jimy Cao Blog
Joris Poelmans Blog
Scot Hillier Blog
Hilton Giesenow Blog themossshow
Kamil Jurik Blog KamilJurik
Amanda Perran Blog
Julien Chable Blog
Eric Shupps Blog eshupps
Tobias Zimmergren Blog
Natalya Voskresenskaya Blog
Wei Du Blog
Ricardo Jose Munoz Blog
Claudio Brotto Blog
Fabian Imaz Blog FabianImaz
Yaroslav Pentsarskyy Blog
basquang Nguyen Blog
Martin Harwar Blog point8020
Serge Luca Blog
Andre Lage Blog aaclage
Michael Noel Blog
Mike Smith Blog TechTrainNotes
Marianne van Wanrooij Blog mariannerd
Yasir Attiq Blog
Shuguang Tu Blog
Christian Glessner Blog
Nick Kellett Blog
Giuseppe Marchi Blog PeppeDotNet
Ivan Sanders Blog iasanders
Elaine van Bergen Blog laneyvb
Sangha Baek Blog SanghaBaek
Patrick Guimonet Blog patricg
David Martos Blog
Cornelius J. van Dyk Blog
Kris Wagner Blog SharePointKris
Stephen Cawood Blog
Toni Frankola Blog tonifrankola
Destin N Joy Blog
Dux Raymond Sy Blog meetdux
Marc D Anderson Blog
Ruven Gotz Blog
Susitha Prabath Fonseka Blog
Xavier Vanneste Blog
Alberto Diaz Martin Blog adiazcan
Veronique Palmer Blog veroniquepalmer
Christian Stahl Blog CStahl
Dave Coleman Blog davecoleman146
Francesco Sodano Blog aresmarte1
Alexey Sadomov Blog sadomovalex
Rodrigo Pinto Blog ScoutmanPt
Michal Pisarek Blog
Shai Petel Blog shaibs
Peter Carson Blog
Samuel Zuercher Blog sharepointszu
Thorsten Hans Blog ThorstenHans
Alan Richards Blog arichards_Saruk
Ashutosh Singh Blog ashutosh80
Darko Milevski Blog
Geoff Evelyn Blog
Mark Rhodes Blog
Thuan Nguyen Blog nnthuan
Peter Holpar Blog
Pratik Ramesh Vyas Blog PratikVyas1982
Radi Atanassov Blog
Salvatore Di Fazio Blog Salvodif
Doug Ware Blog
Juan Pablo Pussacq Laborde Blog jpussacq
Scott Jamison Blog
Stanislav Vyschepan Blog gandjustas
Adis Jugo Blog adisjugo
Andrey Markeev Blog amarkeev
Christian Buckley Blog buckleyplanet
Lionel Limozin Blog limozinlionel
Antonio Maio Blog
Cathy Dew Blog catpaint1
Paul Olenick Blog
Seung-Jin Kim Blog
Sezai Komur Blog sezai
Andres Felipe Rojas Parra Blog arojaspa
Jean Paul Blog jeanpaulmvp
Nabil Babaci Blog nabilbabaci
Trevor Seward Blog NaupliusTrevor
Symon Garfield Blog symon_garfield
Chris Givens Blog givenscj
Amardeep Singh Blog aulakhamardeep
Brandon Atkinson Blog
Chris McNulty Blog cmcnulty2000
Christopher Clement Blog ClemChristopher
Chun Yi Pai Blog
Colin Phillips Blog itgroove_colin
Corey Roth Blog coreyroth
David Sánchez Aguilar Blog davidsancheza
Dmitri Plotnikov Blog xelikk
Edin Kapic Blog ekapic
Fabio Franzini Blog franzinifabio
Gokan Ozcifci Blog GokanOzcifci
Guillaume Meyer Blog guillaumemeyer
Jamie McAllister Blog
Jason Warren Blog jaspnwarren
Keith Tuomi Blog
Liang Han Blog
Margriet Bruggeman Blog margrietvuur
Marius Constantinescu Blog c_marius
Masaki Nishioka Blog
Nicki Borell Blog NickiBorell
Robert Voncina Blog R0b3r70SP
Thomas Vochten Blog ThomasVochten
Vijai Anand Ramalingam Blog
Vlad Catrinescu Blog
Alistair Pugin (Alistair Pugin) Blog alistairpugin
Anders Dissing Blog andersdissing
Adrián Diaz Cervera Blog AdrianDiaz81
Atsuo Yamasaki (?? ??) Blog
Augusto Simoes (Augusto Simoes) Blog augustosimoes
Benjamin Niaulin Blog
Benoît Jester Blog SPAsipe
Carlos Citrangulo Blog carlocitrangulo
Cheng Cheng (??) Blog
Chuantao Duan Blog
Dan Usher Blog
Elczar Peralta Adame (Elczar Adame) Blog
Eric Riz Blog rizinsights
Fabian G Williams Blog fabianwilliams
Fabrice Romelard (Fabrice Romelard) Blog fromelard
Fumio Mizobata (?? ???) Blog
Gustavo Adolfo Velez Duque (Gustavo Velez) Blog
Haaron Gonzalez (Haaron Gonzalez) Blog haarongonzalez
Hans Brender (Hans Brender) Blog HansBrender
Heber Lopes Blog heberolopes
Hemendra Agrawal (Hemendra Agrawal) Blog
Hiroaki Oikawa (?? ??) Blog HiroakiOikawa
Hirofumi Ota Blog hrfmjp
Ivan Padabed (???? ???????) Blog sharepointby
Jake Dan Attis (J. Dan Attis) Blog jdattis
Jasper Oosterveld (Jasper Oosterveld) Blog SharePTJasper
Jennifer Ann Mason Blog jennifermason
JeongWoo Choi Blog
John Liu (John Liu) Blog johnnliu
Joseph Tu (???) Blog
Jovi Ku Blog
Juan Carlos Gonzalez Martin (Juan Carlos González) Blog jcgm1978
Kevin Trelohan (Kevin TRELOHAN) Blog ktrelohan
Laura Derbes Rogers (Laura Rogers) Blog wonderlaura
Mahmoud CHALLOUF Blog
Marat Bakirov (????? ???????) Blog
Mark Stokes Blog MarkStokes
Matthias Einig Blog mattein
Melick Rajee Baranasooriya Blog MelickRajee
Miguel Tabera (Miguel Tabera) Blog migueltabera
Mikael Svenson (Mikael Svenson) Blog
Patrick Lamber Blog patricklamber
Roger Haueter Blog techtask
Romeo Donca (Romeo Donca) Blog romeodonca
Sonja Madsen Blog
Todd C Bleeker (Todd C Bleeker) Blog toddbleeker
Tom Resing Blog resing
Usama Wahab Khan (Usama Wahab Khan) Blog usamawahabkhan
Vielka Rojas Blog vkrojas
Vincent Biret Blog baywet
Wesley Hackett Blog weshackett
Yoshiaki Nishita (?? ??) Blog
Patrick Yong Blog
Jason Himmelstein Blog sharepointlhorn
John P White (John P White) Blog diverdown1964
Jussi Mori Blog JussiMori
Oksana Prostakova (?????? ??????????) Blog prostakova
Pierre Erol GIRAUDY (Erol GIRAUDY) Blog EROL_MVP
Juan Manuel (Manolo) Herrera (Juan Manuel Herrera Ocheita) Blog
Bjoern H Rapp (Bjoern H Rapp) Blog bjoern_rapp
Daniel McPherson (Daniel McPherson) Blog danmc
Devendra Velegandla Blog
Jamil Haddadin (Jamil Haddadin) Blog jamilhaddadin
Noorez Khamis (Rez) Blog nkhamis
Justin Liu (???) Blog FoxdaveJustin
Gavin Barron (Gavin Barron) Blog gavinbarron
Jason Kaczor (Jason Kaczor) Blog jjkaczor
Posted on

SharePoint 2013 Business Intelligence – Course 55063

The SharePoint 2013 Business Intelligence course has been published to Microsoft Learning partners!  It is the refresh of the wildly popular SharePoint 2010 Business Intelligence course.  Some of the highlights include:

  • Complete coverage of Power* tools (PowerView, PowerMap, PowerQuery, PowerPivot)
  • Labs on StreamInsight and HDInsight
  • Labs on Hadoop
  • Labs on Master Data Services (MDS) 

Here's the course outline:

  • Business Intelligence
    • Answer Business Intelligence Questions
  • Business Intelligence Center
    • Create the Business Intelligence Center
    • Explore SharePoint Business Intelligence Center
    • Explore Dashboard Designer
  • Data Mart & Data Warehouses and Master Data Services
    • Explore Data Formats
    • Create a Simple Data Warehouse
    • Explore the Extract stage
    • Explore Transform & Load stages
    • Realize the importance of primary/unique keys
    • Create Data Warehouse Granularity Levels
    • Create a Data Mart
    • Configure Master Data Services
    • Create Data sources in Master Data Services
    • Configure Master Data Services add-in
    • Connect to MDS data
    • Publish data changes
  • Business Connectivity Services and Secure Store
    • Explore External Content Types
    • Create a new External Content Type
    • Create an External List
    • Creating an Large External List using ECTs
    • Using Filters and External lists
    • Creating and Configuring Entity Profile Pages
    • Enable Revert To Self
    • Explore Office and BCS Integration
    • Explore BCS models using OData as source
    • Create external list from OData
  • Analysis Services, HDInsight and StreamInsight
    • Create Dimension and Fact tables with SSIS
    • Create a Analysis Services Database
    • Create a Cube
    • Create Dimensions
    • Create Fact Tables
    • Create a KPI
    • Install Hadoop for Windows
    • Configure Hadoop for Windows
    • Export Hadoop data
    • Render reports based on Hadoop data
    • Use and configure HDInsight
    • Install the Hadoop .NET SDK
    • Install HDFS ODBC driver
    • Build Reports using Excel and Power Query
    • Install StreamInsight
    • Setup demo application
    • Write StreamInsight queries
  • Filter Web Parts
    • Use each of the Filter Web Parts
    • Integrate User Profiles with Filters and Reports
  • Excel, Excel Services and Excel Web App
    • Create An Excel Report
    • Learn to use Excel Services
    • Create/Publish to Excel Services
    • Configure Excel Services
    • Shared Data Connections
    • Excel Interactive View
    • Explore Excel MDX features
    • Create a Slicer
    • Create an MDX Set
    • Use Excel Sparklines
    • Explore Filter Web Parts and Excel Services
    • Explore REST features of Excel Services
    • Explore the Excel Services Web Service
  • PowerPivot, Tabular Data Sources
    • Explore PowerPivot Functions
    • Use Basic PowerPivot
    • Use PowerPivot with Large DataSets
    • Create PowerPivot Linked Tables
    • Create Slicers
    • Install PowerPivot for SharePoint Addin
    • Install PowerPivot on Database Server
    • Configure PowerPivot for SharePoint
    • Publish to SharePoint
    • Automating Data Refresh
    • Analyzing Usage Data
    • Create a Tabular Model Project
    • Adding Data
    • Creating Relationships
    • Creating Calculated Columns and Measures
    • Creating Key Performance Indicators
    • Deploying Tabular models
    • Analyzing data in Excel
    • Import PowerPivot to SSAS
  • Reporting Services
    • Configure Reporting Services
    • Create a Reporting Services Report
    • Configure Reporting Services Web Part
    • Create Advanced Reporting Services report
    • Filter Web Parts and Reports
    • Create Report Part Gallery
    • Create a Report Library
    • Create Report Parts
    • Create a Report using Report Parts
    • Automated Report Delivery
    • Setup Reporting Services RSS Feed
    • Create and Use Data Feed Library
    • Utilize Reporting Services data in PowerPivot
    • Utilize PowerPivot data in Reporting Services
  • Power View, Power Query and Power BI
    • Create PowerView view
    • Utilize images in PowerView views
    • Create Chart Visualizations
    • Create Map Visualizations
    • Work with slicers
    • Work with multiples
    • Work with sorting
    • Work with Visualization Filters
    • Deploy to SharePoint
    • Export to PowerPoint
    • Install Power Query
    • Explore Power Query reports
    • Create Power Query reports
    • Install PowerBI Windows App
    • Configure PowerBI
    • Working with Power BI in O365
  • Performance Point
    • Explore Performance Service Application
    • Explore the Dashboard Designer
    • Create A Scorecard
    • Create A PP KPI
    • Explore Time Intelligence
    • Create Performance Point Reports
    • Create Filters
    • Create A Dashboard
  • Visio & Access Services
    • Use Visio Services
    • Publish a Visio to SharePoint
    • Utilize data driven Visio diagrams
    • Utilize Visio for site architecture diagram
    • Access and SharePoint integration
    • Removed features
    • Publish Access Database To SharePoint
    • Explore Access Services 2013
  • GeoSpatial Data, GeoLocation and Power Map
    • Populate a SQL Server Database using Shape2SQL
    • Utilize the new Spatial Data Types in SQL Server
    • Create a Reporting Services Report using Geospatial Data
    • Publish Geospatial Data to SharePoint
    • Utilize Bing Maps API
    • Create and use GeoLocation columns
    • Create a Map View
    • Explore SharePoint Store Map Apps
    • Install Power Map
    • Explore Power Map reports
    • Create Power Map reports
    • Create Power Map Tour and Scenes
    • Create Power Query Report
    • Create Power Map from Power Query data
    • Import Chart web part file
    • Utilize .NET Charts in 2013
Posted on

Project Server 2013 Development – Course 55077

Wow, 7 months later and this one is finally done!  So much changed between 2010 and 2013 in terms of development and all the documentation for older features just doesn't work anymore when thrown into SharePoint 2013…except in this course and labs!  I managed to get all the examples and other features working in 2013 using some of my in-depth knowledge of the various changes.  This course is one of the best I have ever done and is surely to be a hit!  Attached is the outline:

Course Outline

  • Project Server Introduction
    • Create a Project Web App Site
  • Project Service Interface (PSI)
    • Exploring PSI
    • Creating a PSI Proxy
    • Creating simple applications with PSI
    • Programming with PSI
    • Working with Projects
    • Working with the Queue System
    • Working with Resources
    • Working with Tasks
    • Implementing Impersonation with PSI
    • Run a Windows PowerShell Script to create a project
    • Create a PSI Extension
  • Client Side Object Model
    • Learn to work with Client Object Model (CSOM)
    • Creating Projects
    • Creating Tasks
    • Creating Resources
    • Creating Custom Fields
    • Creating Lookup Tables
    • Learn to work with JavaScript Object Model (JSOM)
    • Creating Projects
    • Creating Tasks
    • Creating Resources
    • Creating Custom Fields
    • Creating Lookup Tables
  • REST API
    • Working with REST
    • Using LINQ with OData
    • Working with OData Limits
    • Working with OData Filters
    • Creating Projects
    • Creating Resources
    • Creating Tasks
    • Creating Custom Fields
    • REST Authentication (Windows, Forms, O365)
  • Programming Project Server
    • Create a SharePoint Solution package
    • Create and deploy custom actions
    • Extend the JS Grid control events
    • Create an Project entity Event handler
    • Create an CustomField entity Event handler
    • Deploy and test event handlers
    • Debug event handlers
    • Create a remote event receiver
    • Deploy a remote event receiver
    • Create a PSI Extension
    • Create a Project Web Part that uses JS Grid
    • Deploy a Web Part Project
    • Configure a Web Part
  • Developing Reports
    • Setup Report Authors and Report Viewers
    • Configure SQL Server Login
    • Install Analysis Services
    • Install SQL Server AMO
    • Configure Excel Services
    • Configure Secure Store
    • Configure PerformancePoint
    • Working with Business Intelligence Center
    • Exploring Project Server Database Tables
    • Working with Sample Excel Reports
    • Uploading Excel Report in the Project Site
    • Creating Dashboard Reports
    • Creating Excel Services Reports
    • Creating PerformancePoint Reports
    • Creating Reporting Services Reports
    • Creating Analysis Services Reports
    • Create Strategy Drivers
    • Create Driver Prioritization
    • Perform Portfolio Analyses
  • Developing Apps
    • Exploring Project Server Apps
    • Creating and Configuring a Project Server App
    • Exploring SP.AppContextSite
    • Deploying a Project Server App
    • Publishing a Project Server App
    • Exploring SharePoint App Marketplace
    • Create a Project App
    • Create a Simple Task Pane App
    • Create an Advanced Task Pane App
    • Create a Project Office App
    • Create and deploy a Provider hosted App
    • Working with High Trust and Low Trust
    • Exploring Context Tokens
    • Exploring Access Tokens
    • Exploring Refresh Tokens
    • Using the SharePoint Web Proxy
    • Creating an App Package
    • Deploying an App Package
    • Creating a Seller Dashboard account
    • Create and Publish AppStore SharePoint App
  • Developing Workflows
    • Create Project Detail Pages
    • Create Workflow Stages
    • Create and Assign Workflows
    • Restart Workflows
    • Create a Project Server Workflow using Visual Studio
  • TFS and Project Server Integration
    • Install Team Foundation Server Extensions
    • Configure Team Foundation Server integration
    • Explore TFS and Project Server integration