Self-service headcount analytics using Microsoft BI: salary analysis

Mike Burger Slalom Consulting

Mike Burger

In many companies, executives are often concerned about employee turnover. In this scenario, employee exit surveys have revealed that the staff and managers have stated that their salaries are lower than the market averages, and that the only reason they are leaving is due to significant salary increases. An HR analyst has been tasked with using both internal and external data to confirm or deny this theory. The salary analysis below was built using the Microsoft BI solution stack and can be implemented with any company that captures employee salary information. Read more of this post

Self-service headcount analytics using Microsoft BI: payroll analysis

Dan Bassett

Dan Bassett

As a CFO, you are responsible for budgeting and forecasting. Your organization’s ability to accurately budget and forecast helps drive investor and stakeholder confidence. In theory, one of the more basic costs to budget should be your employees and payroll, right?

You know how many employees you have, their relative cost, and how many employees you plan to hire. You also probably know how frustrating it can be to review monthly headcount cost reports (budget vs. actual) that contain large unexplainable variances throughout the year. Read more of this post

Self-service headcount analytics using Microsoft BI: cost-benefit analysis

Veronica Butler Slalom Consulting

Veronica Butler

An attractive employee benefits package that is affordable to a company can assist in recruitment and retention, reduce employee out-of-pocket expenses, and increase employee morale and loyalty. To keep employees healthy and provide a good work-life balance, executives review the standard components of healthcare options, retirement plans, and other incentives annually. Read more of this post

Self-service headcount analytics using Microsoft BI: succession planning

Jason Drucker

Jason Drucker

Many of today’s executives are concerned about the balance of resources across their company. Ideally, they would like a proper blend of experienced veterans and cost-efficient junior resources to fill out the roster, but currently have no simple insight into employee tenure and experience. As executives begin to think about this relatively unchartered territory of talent analytics, many questions are being asked, such as: Read more of this post

Self-service headcount analytics using Microsoft BI: spans & layers analysis

Brian Ringley

Brian Ringley

Spans & Layers is an organizational design methodology that is predicated on the fact that increasing managers’ “spans” (i.e., number of direct reports) and reducing the number of supervisory “layers” within an organization results in better communication throughout the company and a more efficient management process. The Spans & Layers analysis dashboard in our self-service headcount analytics solution helps companies quickly analyze their org. structures to understand and optimize the ratio of staff to manager to executives. Performing this exercise helps companies build a solid foundation for future innovation and growth. Read more of this post

Self-service headcount analytics using Microsoft BI: introduction

Brian Ringley

Brian Ringley

Slalom Chicago’s Information Management & Analytics practice recently implemented a self-service business intelligence (BI) headcount analytics solution for one of the largest retail real estate investment trust (REIT) companies in the United States. The client realized that it needed to be organized and adaptable in order to stay on top of an ever-changing business environment and to stay competitive within the market. To do this, the organization needed to shift to a people-focused model.

Read more of this post

How to get more bang for your MDM buck

Mike Burger Slalom Consulting

Mike Burger

One of the biggest problems with a lot of master data management (MDM) engagements is that there isn’t any solid proof that the quality of the data is actually improving over time. Without any proof, it is hard for data governance groups within organizations to prove the ROI for MDM implementations. We’ve helped organizations solve this issue with data quality analytics, using Slalom’s MDM framework and the Microsoft BI stack. Read more of this post

SQL Server 2014: features aimed to scale

BrianFranklin

Brian Franklin

Are your clients running SQL Server 2008, or perhaps even some lingering instances of SQL Server 2005? Are they migrating to SQL Server 2012? Most likely, you’re seeing your clients using a blend of versions. Luckily, there’s good news on the horizon: the release of SQL Server 2014 is right around the corner, bringing some interesting new features and smart enhancements to the table. The SQL Server 2014 Community Technical Preview (CTP) 2 was released to the public last October, and is the first and only production-ready build prior to release to market (RTM). Read more of this post

Creating geospatial mashups with Visual Fusion

Marek Koenig specializes in Business Intelligence, SharePoint and Custom Development.

Marek Koenig specializes in Business Intelligence, SharePoint and Custom Development.

Tell me if this sounds familiar: You’re asked by your boss to find the correlation between the data coming out of your data warehouse and some Excel spreadsheets. He wants to know why some of the call centers have been getting inundated recently with higher call volumes. Just looking at these two sources of data you’re having trouble finding a good answer to the question. You realize that the data includes addresses of your call centers and the areas that they support.

To achieve better insight and understanding, you can load up your data into Visual Fusion, a data visualization platform built by IDV Solutions. The data can then be consolidated into a single interactive view. No more having to go through different reports, trying to match it up with sales data, and seeing if socio-economic factors are related. Read more of this post

Upcoming webinar: maximize video in the enterprise

David Lozzi

David Lozzi

Microsoft SharePoint is a powerful solution that can manage content across organizations in a variety of ways. Recently, I had the opportunity, as part of a Slalom Consulting team, to work with RAMP and help create its enterprise product MediaCloud for SharePoint. We integrated RAMP’s impressive media solutions with SharePoint to provide a rich video experience inside SharePoint itself.

MediaCloud for Sharepoint enables team members to upload a video directly into SharePoint, which then handles processing, querying, etc., using RAMP’s secure cloud-based storage and delivery. Once the video is ready, the user is notified and video playback is accessible through RAMP’s custom player. The video is searchable through SharePoint, including spoken words—meaning users can stay in SharePoint from start to finish. As a result, organizations can get the most from their video content through the SharePoint solution they already have in place. Read more of this post

Follow

Get every new post delivered to your Inbox.

Join 130 other followers

%d bloggers like this: