A brilliant new feature is now available in Power BI – Split column into rows. To understand why we need it, you must go and read the article – Analyzing badly captured Survey data or feedback forms. This method used Power Query concepts of Split and Unpivot. Now these have been combined into a single, intelligent command called Split columns into rows. It sounds confusing at first. But soon you will realize that it is an amazing tool. Learn it just 4 minutes.
Raw data looks like this
And you get a report like this. No need to use formulas or do any manual work.
You must have the May 2017 update for Power BI Desktop installed.
Continue reading Split column into rows
This is a short post. It is like an FYI mail. Excel never understood any dates before 1900. We got used to that limitation over the decades. But Power BI does understand Dates before 1900. The best part is, you do not have to take any specific action. It just works.
Here is the raw data and the Power BI output.
If you try this in Excel, it just will not work. Now that you know this, starting using Power BI with Dates before 1900.
Mind you, the Power BI documentation says that the earliest limit is 1900. It still works for dates before 1900. Drill down is also supported. Here is the same data at Day level.
This ability may make historians and archeologists partially happy. There time scales are huge and Power BI does not support that much of a range. But still, it is an improvement worth knowing about.
We want Skype for Business (SFB) to work exactly like WhatsApp, Snapchat, etc. It should be available all the time and notify when someone wants to chat with me. The chats should continue. SFB on mobile keeps logging of periodically. Which makes it painful to wait every time you want to resume chat. The solution to keep SFB mobile always on is simple.
SFB Mobile always on : Change setting
Go to Settings and choose Keep running in background. That’s it.
Monitor this for a few days and check its impact on battery life. This is not necessarily a set and forget type of option. You may want it ON when you have good battery power and you are expecting lots of chats / meetings to happen.
If you have unreliable connection, low battery power, and are not expecting a busy day, turn off the setting.
While we are at it, here are some additional options you should think about.
Continue reading SFB mobile always on
Cross-tab data is where you have row headings as well as column headings. Consolidating (combining) multiple blocks of such data is a laborious process. Usually the rows and columns do not match across data blocks. You need to do a lot of copy-paste to bring them in the correct order before you can add a formula. Using a 20 year old unknown but powerful feature of Excel you can Consolidate Cross-Tab Data in minutes. You just select the data blocks and let Excel do the dirty work of matching row and column names.
Additional Resources : Consolidate Cross-Tab Data
I have already covered this topic as a step-by-step article. Now I have created a video (9 min). You can download the sample file used in the video and try it yourself.
Continue reading Consolidate Cross-Tab Data in minutes
In a meeting with large number of participants, there are few speakers. Questions and comments by the audience are typically typed in the chat window. Speakers take a pause periodically to view the chat and look for questions worth answering. There will be lot of people posting stuff. The question is, how do you Differentiate yourself in SFB meeting chat?Often good questions or comments are missed by the presenters due to time pressure.
Differentiate yourself in SFB meeting chat
Solution is simple. Right click in the chat textbox and choose Font… Choose Purple color and increase the font size to 12 (default is 10). Why purple, because blue is usually reserved for hyperlinks. Red is not a good choice. Any other color which stands out is fine. I have found purple to be the best on light blue background which is default shading.
Now your comments will be more prominent – visually.
Do not make the font size too big, otherwise it will appear very rude.
A simple but effective way to Differentiate yourself in a SFB meeting!
You can also use emoticons if relevant. But a person scanning the chat text will not take emoticons seriously – because many people use emoticons just because they like using them.
You can also use the exclamation mark to attract attention.
Now your text is shown with the High Priority icon. No need to change font color or size. This is a one-time toggle. For next use, you have to click the icon again before sending text. DO NOT overuse it. If you do, people will ignore all exclamations!
Try it out and let me know if it works. Of course, these are not the only ways of standing out in a crowded chat. I have thought of and used these techniques. I am sure you also have your own ideas. I would love to learn from you. Please post your methods in the comments section.
More Skype for Business stuff
- SFB Mute Mic :Meeting Etiquette
- SFB audio joke – “Can you hear me?”
- SFB Mute Mic :Meeting Etiquette
- SFB Etiquette: Do not talk when you join a meeting
Mail trails tend to grow longer and longer. SFB can help you Stop long mail trails. In fact it provides three different ways to achieve this. Unfortunately, hardly anybody noticed these features due to wrong naming of buttons. Read on to find out how. Reading time 5 minutes.
Continue reading Stop long mail trails using Skype for Business