(2:32) Bad example of variance report
(5:41) Zebra BI Variance report template
(9:44) Bad example of Profit & Loss report
(11:33) Zebra BI Profit & Loss report templates
(23:21) Bad example of Cash flow report
(24:49) Zebra BI Cash flow report template
(29:15) Creating Sales vs. Budget report in Excel – variance charts
(32:08) Inserting a page layout
(32:41) Inserting a bar chart
(33:43) Inserting a lollipop/pin chart
(34:27) Editing titles
(35:00) Scaling charts
(35:59) Inverting the colors in case of a negative scenario
(36:43) Creating Profit & Loss report in Excel - waterfall charts
(37:18) Inserting a waterfall chart
(38:05) Ungrouping/separating the charts
(40:20) Adjusting the data outliers
(42:37) Creating Cash Flow report in Excel – bridge charts
(42:53) Inserting a bridge chart
(46:18) Inserting the comments
(47:08) Creating PowerPoint slides – static, linked
(52:12) Q & A
Share this
Ready to start uncovering actionable insights from your data?
Explore Zebra BI for Office and Power BI, or start a trial instantly and test our tools on your data. You can also contact us to help you build your first test report and create a custom package for your business.
Join our live webinar to learn how to use Zebra AI to turn raw finance and business data into executive-ready dashboards that help Controlling & FP&A teams explain performance.
Discover how to build a sales dashboard that shows real results in context — spotlighting top performers, uncovering gaps, and driving action with clear, trusted data.
Discover how to build a sales dashboard that shows real results in context — spotlighting top performers, uncovering gaps, and driving action with clear, trusted data.
Join our live webinar to learn how to build a self-service BI environment that combines flexibility with a single source of truth. Discover how to balance freedom and governance, ensure data accuracy, and scale trusted, decision-ready analytics across your organization.
Discover how to speed up your Power BI reports and dashboards using proven best practices. In this free webinar, Zebra BI’s experts will show you how to optimize your data model, streamline visuals, and cut report load time from 15 seconds to under 1. Join us and learn how to build faster, smarter reports that scale.