(10:07) Creating a report from the pivot table
(10:14) Inserting a pivot table
(11:11) Formatting the pivot table
(12:18) Creating an interactive chart from a pivot table
(15:11) Disable autofit column widths on update
(17:18) Linking data to a new table without pivot table formula
(18:06) Flexibility of charts and linking values out of the pivot table
(20:53) Creating a report on a page layout
(21:13) Preparing the data: Transferring the pivot table to a page layout
(21:52) Linking the labels and inserting the charts
(24:09) Inserting borders
(25:26) Creating a column marker
(26:40) Aligning the labels
(27:10) Linking the pivot table to the report
(27:59) Inserting a Slicer
(30:15) Designing a Slicer
(30:21) Adjusting columns and rows
(32:20) Creating your own Slicer style
(34:11) Setting format – whole Slicer: Fonts, borders, fill
(34:53) Editing Header: Fonts, borders, fill
(35:30) Editing selected item with data: Fonts, borders, fill
(36:29) Editing unselected item with data: Fonts, borders, fill
(37:19) Editing hovered selected item with data: Fonts, borders, fill
(40:28) Editing and viewing the reports
(41:37) Publishing reports to SharePoint
(44:30) Creating a static chart from a pivot table
(45:29) Copying the worksheet
(46:00) Refreshing the tables
(46:13) Exporting your worksheets to PDF
(47:11) Exporting your worksheets to Excel Workbook
(48:51) Synchronized Slicer: Changed pivot table
(50:38) Adjusting Slicer navigation: Synchronizing Slicer with the filter
(52:59) Q & A
(1:03:22) Zebra BI resources and social media presence
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.
Artificial Intelligence is transforming Business Intelligence and data analysis, offering powerful tools for data-driven decision-making. But where does AI fall short, and how can we bridge these gaps to maximize its potential?
Power BI can be a true game-changer for organizations looking to turn their data into actionable insights. But how do you leverage it to achieve its max potential -- and how do you make handling dashboards easier, more user-friendly, and more efficient? Join our FREE webinar and find out!
Master cost management with Zebra BI. Discover advanced techniques to optimize financial reporting, enhance budgeting accuracy, and make smarter, data-driven business decisions for long-term success.
Unlock the power of product portfolio analysis with Zebra BI in Power BI. Learn to visualize and analyze product performance, identify growth opportunities, and drive strategic business decisions with data-driven insights.
Join our webinar to explore the easiest way so far to do dynamic commentary in Power BI for clearer insights, quicker decisions, and smoother meetings.
September 8th
February 22nd
