wws4 - go beyond the bar chart - amazon s3€¦ · wws4 - go beyond the bar chart effective charts...
TRANSCRIPT
www.solverglobal.com
www.solverglobal.com
WWS4 - Go Beyond the Bar ChartEffective Charts With BI360
www.solverglobal.com
Session Objectives
• Consider the goals for charts and dashboards.• Build examples of less-frequently presented graphs and understand
why they are compelling for particular data visualizations.• Demonstrate some tips and best practices when creating and
presenting charts in BI360 reports.
www.solverglobal.com
Session Agenda
• The Waterfall Chart: • When to use: Analyzing components of a trend or
variance.• Speedometer Gauge:
• When to use: Mapping output against predetermined criteria.
www.solverglobal.com
Waterfall Chart
• Also known as a bridge chart.• Useful to emphasize just the
delta portion of a periodic time series between start and end points. Classic use case: cash flow across time.
• Well-suited to display the contributions of different variance components. We will build a budget analysis example together.
www.solverglobal.com
Waterfall Chart• The waterfall chart is a combo chart consisting of two columns for the budgeted
and actual net income, two line graphs displaying the adjustment to budgeted net income driven by each account category, and a scatter graph to provide data labels for the adjustments.
• The financial data needed from the data warehouse are provided in the "To Build" tab: the budgeted net income, the actual net income, and the variances by account category that contribute to the difference.
• Note that the budget net income plus the variances ties to the actual net income. This exemplifies data validation required pre-visualization required for successful charting.
• The completed template can be reviewed on the "Completed" tab. Results for parameters SUS/202103 are available on the “Published” tab.
www.solverglobal.com
Speedometer Chart
• Staple of business performance dashboards.
• Used to display results against predetermined measurements in a visually compelling form.
www.solverglobal.com
Speedometer Chart• The speedometer chart is a combo chart can be constructed with many
variations. Our version is a combo chart consisting of two doughnut charts and a pie chart.
• Once the gauge structure has been set up it can be reused easily with mapping to different performance indicators.
• The Google analytics data needed from the data warehouse are provided in the "To Build" tab. It consists of statistics by referral source, with referral source as a parameter.
• The completed chart template is available on the "Completed" tab. Results for parameter “Google” are available to review on the “Published” tab.
www.solverglobal.com
Key Takeaways & Resources
• Always think about what you are trying to communicate before committing to a chart style.
• Put yourself in the mindset of your audience – they may not be as familiar with the data as you.
• If necessary, temporarily modify your reports to create editable Excel elements in design mode.
• If necessary, select Open in Excel to execute dashboards including charts.
• If I have seen further it is by standing on the shoulders of Giants. – Isaac Newton
• Google is my friend. – MePower BI sessions:WPB3-Contribution Analysis with Power BIWPB5-Extending Data Warehouse Uses with BI360 and Power BITHPB6-Power BI with BI360 Data Warehouse
www.solverglobal.com
Your feedback is valuable:
www.solverglobal.comwww.solverglobal.com
THANK YOU!• Michael Buhlert• Solver• [email protected]
www.solverglobal.com