test-post
What is the ROI of a dashboard ? – Part I – The Return
Not an easy question to answer, is it. Subjective terms like "better insights" or "improving decision making" don't really cut it as they cannot be measured Ideally you would want the dashboard that you have developed to increase revenue/decrease costs/reduce risk....
What do you do when someone shares a Power BI report with you ?
If you have never used Power BI, you fumble around trying to make sense of it and waste 30min of your life and then give up. What if I showed you a technique to browse a Power BI report efficiently and make your life easier. It’s called the FBI technique. Why FBI ?...
Which suburb in Brisbane has the highest number of mobile speed cameras ?
No one likes speed cameras. Especially when they are not clearly marked (fixed). So wouldn't it be nice to know the location of mobile speed cameras in your suburb ? Interact with this dashboard to get to know the location of speed cameras in your suburb. And also the...
Strategic colouring in Power BI-Part 8: Transforming a stacked column chart to highlight individual series
This is the eighth post in the Strategic colouring in Power BI series. Links to all the posts can be found here https://capstoneanalytics.com.au/master-post-for-strategic-colouring-articles/ Stacked column charts are hard to visualise especially when you have more...
Using DAX to prevent users from entering the detailed pages from a landing page until every slicer is selected
Suppose you have a landing page and you have a bunch of slicers on the page and you want the users to select at least one option on the slicers before they can enter the next page. It wasn't possible with bookmarks before as you couldnt switch bookmarks using...
Strategic colouring in Power BI-Part 7: Dynamically plotting yearly percentage sales of top N products and measuring against a dynamic target
This is the seventh post in the Strategic colouring in Power BI series. Links to all the posts can be found here https://capstoneanalytics.com.au/master-post-for-strategic-colouring-articles/ In the sixth post, we discussed how to isolate and visualise YTD data In...
Strategic colouring in Power BI – Part 6: Visually showcasing the years in which a selected product is the top product
This is the sixth post in the Strategic colouring in Power BI series. Links to all the posts can be found here https://capstoneanalytics.com.au/master-post-for-strategic-colouring-articles/ In the fifth post, we showcased how to visually determine the difference in...
Master post for strategic colouring articles
This is a master post which contains all the links to strategic colouring articles. This post will be updated as new articles focusing on strategic colouring are posted. Link to github repo containing all the Power BI files also included in the end Part 1 -...
Strategic colouring in Power BI – Part 5: Difference in sales from a base year for different segments
This is the fifth post in the Strategic colouring in Power BI series. Links to all the posts can be found here https://capstoneanalytics.com.au/master-post-for-strategic-colouring-articles/ In the fourth post, we discussed how to isolate and visualise YTD data In this...
Strategic colouring in Power BI – Part 4: Isolating and visualising YTD data
This is the fourth post in the Strategic colouring in Power BI series. Links to all the posts can be found here https://capstoneanalytics.com.au/master-post-for-strategic-colouring-articles/ In the previous post, we looked at how to isolate a category in a trend We...