Check out the sample mobile analytics dashboard by Percent Mobile. It is like google analytics, but for mobile device based traffic. I liked the way they presented the information of website traffic that is coming from mobile devices.
What is WOW about it?
The top portion of the dashboard shows quick summary. This is one of the key principles of any good dashboard. Displaying summary at the top and providing detail at bottom. This creates a logical flow and viewer can decide for herself which details to seek.
The bar charts below are executed well. Often we are tempted to use colors and rich formatting, but when you use simple colors, then naturally the attention shifts from formatting to information. I like the way the charts look subtle but still provide good information, thanks to labels.
What can be improved in this chart?
The mobile ecosystem area of the dashboard looks good but it is difficult to spot any trends. Few things I can think of to improve this are,
- Reduce the number of phones displayed here to say Top 5
- Try something else like a tag cloud, but with images. It adds novelty and drives attention to most important devices.
- Restructure information by dimensions like touch-screen devices, gaming devices, good old mobile phones so that viewer will know what type of devices are visiting the site more.
What is your opinion on this dashboard?
Cool or awful? How would you improve it?
More on dashboards: KPI Dashboards using Excel (6 part tutorial and downloads), Excel Dashboards theory, principles and tutorials
[Hat tip to Digital Inspiration for percent mobile]
2 Responses to “Top 10 Power BI Interview Questions & Answers”
Hello...
In Power BI I have data that includes months by name only (e.g. May, April, December...)
I need to build charts etc. but i need the months to go chronologically... not alphabetically... I cannot seem to find the fix to this.... once again, my data does NOT have an actual date attached to it (like 02/01/2023)....only month names... can i use a helper table wher i id the month names as numbers 1 thru 12? and if so, how do i manage this to work for me ?
Thank you.
~Keith
You need to setup an extra table to map each month name to a running number. A simple 12 row table like
Jan 1
Feb 2
Mar 3
..
Dec 12
Then create a relationship between this month table and your month column
Now, go to "table view" in Power BI and set the sort by column to month number for the month name column on this new table.
Finally, use the new table's month name whenever you need to refer to the month name in the visuals.
They will be chronologically arranged.