Thanks for Giving

on 26 November 0 Comment

A post to be thankful for all the resources available with just some keystrokes!  Sometimes you are at 99% of your project being complete but you just need that extra bit of functionality to make it work.  And thanks to the internet, and the info sharing community, finding solutions is just that much easier.

So my turn to share a simple solution of how to Automatically Refresh Calculated Fields in SharePoint Lists. Surprisingly, calculated fields do not refresh unless there is a change to the list item.
examples:

  • Calculating a ‘Status’ based on some date conditions
  • Calculating the number of days it took a list item from start to completion

Using Power Automate, it’s possible to have a recurring task that will update respective list items in order to recalculate those fields with just a few steps –

  1. Create a hidden column – format as ‘Date’.  In this example, the field is named ‘Refresh’
  2. Determine which existing columns will serve as the criteria in your situation – the example will use the item Status (‘field_7’)
  3. Create a new flow in Power Automate
    • Use a recurring schedule.
    • Get Items and filter the query to the items to be recalculated
    • Update Items (adding ID from Dynamic Content will ‘Apply to each’) with today’s date (Expression ‘utcNow()’) in the hidden ‘Refresh’ field.  This also serves as a way to confirm that the flow works.

Be mindful that these list items will then show a modification date by the flow owner.

Hope this helps!

So Tell Me About Yourself

on 22 October 0 Comment

Well, this blog is about Tips for the Everyday, so let’s look at what it takes to interview. Colleges should definitely make this a required course prior to graduating, as well as companies for their own employee development.  I am realizing that I have lot of work to do in this area, so I am learning to –

Be SPY

  • Be Specific
  • Be Prepared
  • Be Yourself

S

Be Specific – keep track of all your work and what your impact was.  Take the time to document and write them down – whether it’s for your annual review or for an interview, this will serve you well.  We all get busy, and move on quickly to the next project, but it’s good to take those few minutes and do a post-launch capture. Your interviewer or sometimes even your manager won’t know what you’ve accomplished and where you made an impact, so it’s up to you to let them know. They unfortunately won’t/can’t buy what you don’t sell.  Feeling impostor syndrome?  Think of it as sharing information versus marketing or sales. Keeping your work fresh in your mind should help address majority of the questions that will inevitably come your way.

Template suggestion:

  • Project Name:
  • Description:
  • Role:
  • Technical Skills applied:
  • Soft Skills applied:
  • Difficulties & Solutions:
  • Learnings:
  • Impact to Organization: man hours saved, $ saved/brought in, what did it enable, what risks did it lower, downtime averted, etc.

P

Be Prepared – That elevator pitch of who you are and why they need you specifically.  Add three more Ps for Practice Practice Practice.  Introverted like me?  300 Ps!!!  This is not the time to downplay your work.  Remember, your accomplishments only appear easy to yourself, and that’s because you’ve had years of experience and learning behind it.  Something that takes you 10 minutes, will take someone else days if at all.

From this youtube video, tips on what should be in your elevator pitch – don’t forget to think about it from the interviewer’s perspective as well –

  • Who you are
  • Why you’re qualified
  • Why you’re here

Y

Be Yourself – You want to make sure that you are bringing your authentic self.  You too are looking to find a match from an organization who will value you as you are as well as provide development.  So no matter how well your skills fit the role, if your personal being doesn’t mesh with the company and its people, the situation most likely won’t last very long, and discord will ensue.

Not looking for a job or a change, be prepared anyway!  Use this for your performance reviews and be proud of sharing your accomplishments.  Now that I’ve written this all down, time to take my own advice and work on myself.

 

Be SPY (specific, prepared, yourself), so you don’t bomb the interview!

 

 

Community!

on 25 September 0 Comment

Last week I was fortunate to be back at Universal Orlando, this time for the Microsoft Power Platform Conference.  Biggest takeaway, getting to know people.  Sure you can get to know strangers or even those you know without going to a conference, but being somewhere offsite really does have its value.  Where else can you meet people as part of a Pokemon Go group discussing Power Apps?  (Spoiler:  I did not have enough stardust to do any trades with anyone…)  Or get together with women in tech (and a few male allies) to realize you are not alone in your situations.

Being an innate introvert who has no problem wandering off by myself, it does take some extra energy to talk with people. But it is worth it.  We’re all here to share and help each other.  And cliche as it sounds, being part of a community is key. (If you were there, you would get the “Community!” reference)

So, as hard as it can be, join a group, meet new people.  It is okay.  And who knows, it could be more.

And where else could I have met these Guys Not in A Cube?!!!  Bananas!

 

Workouts and Workarounds

on 12 September 0 Comment

Sometimes you want a feature in Power BI that doesn’t seem to exist.  Luckily, Power BI is full of hidden ‘features’ that allow you to do what you seemingly could not do.

Same with workouts.  Convention would have you on your back to do some good old fashioned crunches, straining your neck along the way.  But hey, why not do these standing up?  Sure you can’t lift both legs off the ground at the same time, but you can still get results another way.

With Power BI, the trick seems to be start with the way you can do it, and then switch over to the method you would like to ‘carry over’ the features that are available in one functionality to the other.  An example –

Default:  Advanced Filter – only 2 conditions
Workaround:  Using Basic Filter – select the number of options to equal the number of advanced conditions needed.  Then switch to Advanced filter, et voila!

 

 

There are some other examples that are in the back of my head… will try to post them as they surface back to top of mind.

Light & Dark

on 04 September 0 Comment

The return from summer vacation equals jet lag coming from the opposite side of the hemisphere.  (Managed to get to that place in the photo a few posts back!)

So as I write this in the early hours of the morning, I think of all the great data visualizations out there that have a dark theme.  While they look great and impressive at first glance, I’ve found that dark theme is not practical for everyday business use.  After all, how many times do you see other forms of presentations that convey data in dark mode?

It would be interesting to find out the stats on how well data is conveyed via dark vs light mode, and for which use cases.

My thoughts purely –

DARK
One-off presentation
Printed color material – magazines, posters, brochures
Informational

LIGHT
Day-to-day operational
Printed black/white material – newspapers
Screen based – accessed digitally
Action oriented

 

What works even better is to use a combination of dark & light mode in the same presentation, based on the content, bringing that much-needed contrast and focus in design to help viewers process the information accordingly.

 

Back to jet lag, not being a morning person, it is however a great opportunity to experience the calmness of a beautiful sunrise for a few days.  From darkness to light.

 

 

(Just a little) Patience

on 31 July 0 Comment

Today’s post – Patience.

Hubby and I were discussing what we’ve learned about having kids, is that sometimes, a lot of times, almost all the time, we get derailed from one task as we need to tackle five other tasks thrown in by the offspring whilst attempting the original one.

Same with BI data, reports, and dashboards oh my.

I may have a little more appreciation now for the BI team pushing back on my request for a couple more fields to be integrated into the dataset.  How hard could it be?  (On the other hand, I was waiting for more than a year to even get to this point of response).  Seemingly straightforward requests are almost never that.  One possible reason to go sideways with this request – the field is from a different table not part of the current dataset, which leads to going to the next team to integrate this portion, who will push back because they don’t have this on their roadmap.

So just be patient with your teams.  Sometimes adding or modifying a field leads to a domino effect of unintended and usually unwanted consequences.  And on the flip side, err on the side of caution when agreeing to these changes because you will no doubt encounter these obstacles lobbed at you like kids with grenades.

 

all i need is a little patience

123456