intelligence – STL

Emotional Intelligence enables teams to reach their full potential.

What is it?

Emotional intelligence (EI) refers to an individual’s ability to recognise their emotions and understand how these emotions impact on others. An emotionally intelligent team relates to the ability of a group to manage and harness emotions for positive outcomes. However, an emotionally intelligent team is not simply a combination of individual emotional intelligence and self-awareness, but rather, the result of active team development.

As noted by Daniel Goleman in his 1998 work, Working with Emotional Intelligence, each of us only has part of the information and skills we need to do our jobs. We depend on the group mind – the collective experiences, skills, and knowledge within the team – to complete tasks, making collaboration essential to project and organisational success.

Group mind, as Goleman explains, helps to save time when seeking new solutions and amplifies individual capability. However, tapping into this cumulative knowledge is only possible if the team trust each other and work well together. The team must be emotionally intelligent.

At the core of every team are the relationships that make that team great or contribute to its demise. Here are five signs of an emotionally intelligent team:

1 They create, communicate and monitor ‘The Rules’

‘The Rules’ refer to the spoken and unspoken standards of work, behaviour and attitude team members expect from each other. They closely represent team values and apply to everyone. The team will not only clarify ‘The Rules’ for newcomers but will also monitor each other’s adherence to them.

An emotionally intelligent team will recognise the impact of their actions on others and so will choose to work and behave in a cohesive way, thus creating a sense of identity.

2 They pay attention

Emotionally Intelligent team members will pay attention to the needs and feelings of others. Demonstrating empathy and recognising the impact of your words or actions on the feelings of another is a sign of high EI. Listening attentively is important for building rapport and relationships, both of which are crucial for an emotionally intelligent team. Staying focused in discussions, questioning to understand, encouraging input, and accepting different perspectives is key to being able to make high quality team decisions.

3 Their work environment is psychologically safe.

Psychological safety is the belief that you won’t be punished when you make a mistake; that it’s okay to speak your mind and to question the status quo. Open and honest communication has a snowball effect for building emotional intelligence. This is because the more you question and the more you learn, the more aware you become. This type of team behaviour creates enormous breakthroughs for a company in terms of new ideas. It also builds the level of confidence and trust that defines high performing teams.

4 They are aware of their strengths and weaknesses

Emotionally Intelligent teams have a collective awareness of each other’s strengths and can use them to the benefit of the team as a whole. They have a strong desire to improve and will actively seek and provide feedback. They will also prioritise team learning, conducting post action reviews to identify learning points.

An emotionally Intelligent team is attuned to their own feelings while working and will step back from the work to address situations that are driving unproductive emotions, while low EI teams will just plough ahead.

5 They work as one

Members of teams with high EI feel part of a worthwhile group. They recognise that they work better together than apart and are likely to reach higher levels of collaboration and productivity. High EI team members know how to keep each other inspired and motivated. They are better able to deal with stressful situations as a result.

Emotionally intelligent teams build good relations with other teams and will function as a group across organisational boundaries.

Conclusion

It’s easy to identify teams with high emotional intelligence: They are likely to be your highest-performing teams. They lift each other up and give everyone a chance to shine. Naturally, that translates into real results for the business.

As we begin planning for 2023, we hope you’ll consider setting aside the time and resources to develop the emotional intelligence of your team.

DAX (Data Analysis eXpressions) is the function language in Power BI desktop. When DAX is used to create measures, it can hard to understand the logic at times. Especially one function, the Calculate function, can be challenging.

We visit the mysterious Calculate Function for the third time, in this four part series of blogs.

The Calculate function reacts differently to row, column, filter, and table context than the other DAX functions and the Calculate function is important for nesting other functions.

In this blog post you will see some examples of how the calculate function works with time-intelligence.

Time Intelligence

The time-intelligence functions that enable you to control data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.

Most time-intelligence functions need to be nested inside the Calculate function.

In this example, sales need to be compared up against previous year.

The structure of the Calculate function:

CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])

In all the examples the expression will be total sales and in the filter arguments, the time-intelligence functions will be nested.

First, the SamePeriodLastYear function.

All time-intelligence functions need to know the primary key in the Dates table (Calendar Table).

Last year = CALCULATE([sales],SAMEPERIODLASTYEAR(Dates[Dates]))

Below in the example a Gauge visual is used. The Sales are added to Value and above measure to Target. The page is filtered to show 2016 by a slicer.

The blue part of the Gauge chart (£20.42m) is the sales for 2016, and the line in the Gauge chart (£13.99m) is last year. In this example 2015.

Below the page is filtered by two slicers to February 2016. The blue part of the Gauge chart (£20.42) is the sales for February 2016, and the line in the Gauge chart (£13.99) is February 2015. The combination of the Calculate and SamePeriodLastYear function will always go back to the same period last year. In this case, to February 2015.

In the next example of the combination of the Calculate and SamePeriodLastYear function. The sales growth needs to be visualised.

The DAX measure used for this: % Growth = DIVIDE([sales]-[Last year],[Last year],0)

The sales minus last year’s sales divided with last year’s sales.

The Last year sales measure from the previous example above, has just been reused here. In the Matrix below right, the Matrix display the percentage difference from previous year and same month previous year.

Matrix

Conclusion

I call the Calculate function the mother of DAX functions. It is the most important DAX function (my opinion), but to get the most out of it you will need to understand, how the function reacts to row, column, filter, and table context, and how the Calculate function takes care of other functions

This is part 3 of a series of blog posts as mentioned at the top about the mysterious Calculate function.

In the next blog post in this series, you will see how the mysterious Calculate function is different from other DAX functions when it comes to filter context.