Split column into rows

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

Split column into rows - raw data

And you get a report like this. No need to use formulas or do any manual work.

Split column into rows - Final Charts

You must have the May 2017 update for Power BI Desktop installed.

Continue reading Split column into rows

Power BI Dates before 1900

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.

Dates before 1900 - raw dataDates before 1900 - in a chart

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.

Drill Down

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.

Skype for Business SFB Live Book

Here is a list of all the articles I have written about Skype for Business. The list is shown in recommended reading order. It is a Live Book because whenever I post more articles related to SFB, I will update this list. Your suggestions and wish-list for new articles are most welcome. Just post these as comments.

Concepts

 

Confusion: Which communication option to use when?

Fun

SFB audio joke – “Can you hear me?”

Etiquette

SFB Mute Mic :Meeting Etiquette

SFB Etiquette: Do not talk when you join a meeting

Pause Screen Sharing while creating Polls in SFB

Smart Usage

Differentiate yourself in SFB meeting

Stop long mail trails using Skype for Business

Office Politics: Cheat Chat

What NOT to do!

How to delight your customers by making them wait in Lync / SFB lobby 🙁

When to use and how

Skype for Business: SFB Use Cases

Presenting Content using SFB

How to conduct simultaneous Remote and Local Training

Just ONE CLICK to start presenting using Skype for Business

Skype chat within Outlook for Web

Lync / Skype for Business Best Practice: Polls vs. Survey

SFB mobile always on while using mobile phones

 

More articles will be added soon.

SFB mobile always on

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.

SFB settings page   SFB mobile always on setting

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