Author Archives

I am a software engineer, business and systems analyst, program manager, and technical architect with a passion for delivering business strategy and technology. Over the past 15 years I have partnered with dozens of employers and clients to achieve goals across the corporate landscape.

• Power BI – Power Query Editor – Converting Dates From Another Locale – Expense Report Example

  By Christopher Brotsos on September 21, 2018 • ( 0 )

  

  Many of us work with data in Power BI that includes date and time information mined from sources in different locales or regions of the world than our own. In this post, I’m using a simple CSV of expenses that… Read More ›

• Microsoft Excel – WORKDAY and WORKDAY.INTL – Project End Date

  By Christopher Brotsos on September 20, 2018 • ( 0 )

  

  Both professionals and hobbyists depend on Microsoft Excel for scheduling and resource planning, and if that’s the case for you too, then the WORKDAY and WORKDAY.INTL formulas are two essential tools to have in your belt of Excel tools. Both… Read More ›

• Office 365 and SharePoint – Meaningful Human Resources (HR) Insights – Power BI Reports and Dashboards on Employee Lifecycle

  By Christopher Brotsos on September 18, 2018 • ( 0 )

  

  In the previous post, we saw Human Resources (HR) import SharePoint list data into Power BI Desktop, and now that groundwork will be used to publish employee lifecycle Power BI Reports and Dashboards to Office 365. The report will consist… Read More ›

• Office 365 and SharePoint – Meaningful Human Resources (HR) Insights – Prepping for Power BI Dashboards on Employee Lifecycle

  By Christopher Brotsos on September 18, 2018 • ( 0 )

  

  Human Resources (HR) can garner meaningful insights using Office 365, the basic Microsoft Power BI functions, and with straightforward SharePoint lists to hold employee lifecycle data. Over the next 2-3 posts, we’ll watch the HR team build Microsoft Power BI… Read More ›

• Office 365 and SharePoint – Company Directory – User Profiles and Expertise Search Results Refiners

  By Christopher Brotsos on September 17, 2018 • ( 0 )

  

  A couple of posts ago, we saw Human Resources (HR) provide the organization with a Company Directory based on Office 365 SharePoint User Profiles. We actually saw two versions, and the final one (at the end of the post) highlighted… Read More ›

• Office 365 and SharePoint – Employee Onboarding with Microsoft Excel and SharePoint Designer (SPD) Workflow

  By Christopher Brotsos on September 10, 2018 • ( 0 )

  

  I’m excited to share this solution around Human Resources (HR) Onboarding using Microsoft Excel and SharePoint Designer Workflows in Office 365 and SharePoint. This is a unique way to track Human Resources’ progress as they complete essential steps in the… Read More ›

• Office 365 and SharePoint – Company Directory and People Finder with SharePoint Search and User Profiles

  By Christopher Brotsos on September 10, 2018 • ( 1 )

  

  In Office 365 SharePoint, a company directory is useful for all employees, so when reading this post, the intent is not to imply that the Company Directory and People Finder we see in this blog post is only supposed to… Read More ›