Posts Tagged ‘Perficient Minneapolis office’

In a previous post, I introduced PowerQuery and demonstrated how to perform various SQL-like operations. This article gives a tour of PowerQuery’s M language that underlies each query. let and in If you select a query and click on the “Advanced Editor” button in the Home tab, you’ll see something like this: This is the […]

Microsoft’s PowerQuery is a neat tool that allows one to perform SQL-like operations on Excel tables. When investigating a database, I actually prefer using PowerQuery over raw SQL for a couple reasons: PowerQuery displays result sets that are much easier to look at than the a typical SQL plaintext result set. It’s easy to immediately […]

I’ve decided to write a tutorial on how to accomplish dependency injection in C# .NET, because the Microsoft documentation of dependency injection libraries is unfortunately way too sparse, and the Microsoft dependency injection tutorial is a little convoluted and complicated. Fortunately, C# .NET’s implementation of dependency injection is pretty straightforward. In my opinion, it’s way […]

I’ve decided to write some of my own documentation for common use cases of the Excel functions LOOKUP, VLOOKUP, HLOOKUP and XLOOKUP because the official documentation is pretty confusing. It uses “lookup value” as a synonym for “key”, when one would conventionally expect a “lookup value” to be a synonym for “value”! (After all, in […]

One might be confused or even angered when they learn about Scala’s convention regarding parenthesis usage for no-arg functions. The convention is this: given a no-arg function, you use put parentheses next to the function call only if the function has side effects. So, you would invoke a function named printCurrentState by writing printCurrentState(), since printCurrentState […]

Introduction to Spring Framework for Java This article walks through the basics of using Spring Framework for Java. From a very, very high level point of view, Spring Framework infers a program’s runtime behavior from labels that the programmer attaches to pieces of code. There are many different groupings of labels, and each grouping of […]

This article will take a relatively abstract look at the design pattern called dependency injection (or inversion of control). I feel that most articles about dependency injection get too bogged down in the particulars of whatever example is being used to demonstrate the structure. In this article, we’ll present pure abstraction. Well, maybe not pure abstraction- […]

In this article, we’ll explore the test-driven development practice of mocking. No, this won’t entail calling your developer teammates silly names! Specifically, we’ll use Java’s EasyMock package to get a sense of the functionality that a typical mocking library provides. Before we learn what mocking is, we first must consider the general scenario in which […]

SCRUM DAY MN is a leading not-for-profit event in the Midwest where local Scrum practitioners gather to share ideas, lessons learned and inspire others who might be at the beginning of their Scrum journey. The conference offered multiple hour-long workshops, covering a variety of content, with one thing in common: hands on. Throughout the day participants […]

Perficient’s Minneapolis colleagues are all about supporting the local community from large to small organizations and projects. Their latest Giving Back event featured The Sandwich Project, whose ultimate goal is to feed the homeless within the Minneapolis area not only around the holiday season but every day. Currently, they feed about 4,500 people per week […]

Our Minneapolis team has recreated their own Office Olympics competition, in an effort to put a fun twist to team building activities. A series of events has been planned a few weeks in advance, utilizing a high dose of creativity and office supplies at hand. Events put to test a variety of skills and ranged […]

Last year our Minneapolis office pioneered a community of practice called Define and Drive. The group is tailored towards the business consultant and project manager colleagues, with an aim of knowledge sharing on market-relevant skills, and fostering a sense of community. The founders of the group, Karla Kraft and Jennifer Edwards, came to the idea […]