Power BI – Data Preparation Workflow

Steps in preparing Power BI Click on “Get Data”, select your source data. Click on “Edit Queries”. If there are individual date columns (Year, Month and Day): Then click on “Add Column”, “Add Custom Column”. Name the column as “TempDate”. Put in the custom column formula. Then click on “OK”. Select the generated column, and click on “Date”, “Parse”. A new “ParseDate” column will be…


Power BI – Add Custom Column – Date

In Power BI Desktop, if you an Excel with columns of year, month and day, and needed to create a custom date column. To create this custom date column, here’s the formula. =Text.From([Day]) & “-” &  Text.From([Month]) & “-” & Text.From([Year])   This is different from a hierarchy column where you can just drag and drop.


Migrating from Google Apps to Office 365

Office 365 deployment guide https://technet.microsoft.com/en-us/library/hh852466.aspx   Migrate email and contacts to Office 365 for business https://support.office.com/en-us/article/Migrate-email-and-contacts-to-Office-365-for-business-a3e3bddb-582e-4133-8670-e61b9f58627e   Change Management: Switching from Google Apps to Office 365 for business https://support.office.com/en-us/article/Switching-from-Google-Apps-to-Office-365-for-business-6c4b9ed0-e59a-4a9c-b0fd-049c1cf9f2eb?ui=en-US&rs=en-US&ad=US


SharePoint 2013 Workflow Tutorials

Getting started with SharePoint Server 2013 workflow https://technet.microsoft.com/en-us/library/jj227177(v=office.15).aspx Workflow actions quick reference (SharePoint 2013 Workflow platform) https://msdn.microsoft.com/en-us/library/office/jj164026.aspx SharePoint 2013 Workflow – Task Process Designer https://www.youtube.com/watch?v=ji5wxt4fcKc Developing SharePoint 2013 workflows with SharePoint Designer https://www.youtube.com/watch?v=A75qEwSd2kE SharePoint 2013 Approval Workflow With Dynamic Approvers https://www.youtube.com/watch?v=Vhwz_OJkP8g SharePoint Designer 2013 – Call Web Service Video External Version https://www.youtube.com/watch?v=dW6g9WR2Y8o&index=3&list=PL66r0mRA8am80Qsp6tRM1L_cdY3hos8Q8


Office 365 Starter

At Microsoft, we care deeply about supporting compliance with specific standards and regulations related to data security and privacy as required by our customers in various geographies and industries. We consider compliance a core feature of our services, and we make significant investments in this area to ensure that that we are continuously innovating on…


Enable Administrator to access all users' OneDrive for Business

Download, install and run the SharePoint Online Management Shell http://www.microsoft.com/en-us/download/details.aspx?id=35588 Replace <domain> with your domain name and <tenant> with your SharePoint Online tenant name. $objCreds = Get-Credential Connect-SPOService -Url https://<tenant>.sharepoint.com -credential $objCreds $colUsers = Get-SPOUser -Site https://<tenant>-my.sharepoint.com/ | Where-Object {$_.LoginName -like '*<domain>.com*'} $colUsers = $colUsers.LoginName | ForEach-Object { $_.TrimEnd("<domain>") } | ForEach-Object { $_.TrimEnd("@") } $colUsers |…


SharePoint hybrid training videos

SharePoint hybrid training videos http://technet.microsoft.com/en-us/library/dn769084(v=office.15).aspx http://msdn.microsoft.com/en-us/sync/dn769084(v=office.12).aspx Summary: All three topologies are supported: Inbound, Outbound and Bi-drectional


Color Code Calendar Events in SharePoint 2013

Here's a good step-by-step on doing color coding on SharePoint 2013 Calendar. http://summit7systems.com/color-code-calendar-events-in-sharepoint/


Bulk remove user from Office 365

Prepare a CSV File to Import New Exchange Online Users:http://help.outlook.com/en-us/140/ee441218.aspx#required You can refer to the steps below to bulk remove the users: 1.Create a CSV file that contains all the users you want to remove: The CSV file should include the five required attributes: Name, EmailAddress, FirstName, LastName, Password.   2.Install and Configure Windows PowerShell…