Cross-Filter Interactive Dashboards in Excel
Download and do it yourself here: https://bit.ly/3rWXroY
Discover the art of designing interactive Excel dashboards with BI Specialist Matija Prijatelj. In this comprehensive tutorial, Matija breaks down the techniques to create dashboards that not only present your data visually appealingly but also filter it with the efficiency of Power BI.
Begin with an understanding of how pivot tables can revolutionize your data representation, explore the convenience of slicers for easy data filtering, and wrap up by getting hands-on with dynamic visual filters courtesy of Zebra BI.
Whether you're a beginner looking to elevate your Excel game or a seasoned professional seeking to refine your skills, this guide promises valuable insights.
Learn more about the visuals for Excel: https://bit.ly/485iqXh
Or download directly from: https://bit.ly/3rWXroY
Learn why you should not include tables in your reports: • Tables have NO place in FINANCIAL rep...
Enjoy this video and subscribe to learn more about reporting, business intelligence, and Zebra BI.
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:14 Sneak peek
02:17 The DATA
03:27 Structure of dashboard
04:10 Pivot tables
06:35 Visualizations
09:06 Interactive buttons
10:30 Slicers
13:33 Final dash & Power BI-like filtering
14:16 End
GET IN TOUCH Contact us on [email protected]
FOLLOW US ON SOCIAL
Get updates & reach out on our Social Media Profiles!
LinkedIn: / 5051039
Twitter: / zebrabi
Facebook: / zebra.bi
---------------------------------
🦓 ABOUT ZBI 🦓
---------------------------------
With Zebra BI, you can transform your Excel reports into professional, interactive visualizations that tell a story. And the best part? You don't need advanced BI skills to get started.
👉👉👉 Try Zebra BI for Office for free today and see just how simple it is to create charts that get results: https://zebrabi.com/excel-add-in/ 👈👈👈
ABOUT OUR CHANNEL Our channel is all about Actionable Reporting and has one goal: to enable everyone to create better reports. We cover Power BI, Excel, and PowerPoint reporting, business intelligence, business analytics, data storytelling, and related topics.
Check out our channel here:
/ @zebrabi
Don’t forget to subscribe!
CHECK OUT OUR OTHER VIDEOS
• • Price Volume Mix Analysis: Power BI T...
• • How to Create Waterfall Charts in Exc...
• • How To Link Excel Tables & Charts To ...
We make these awesome data visualization tools; check them out here: https://zebrabi.com/power-bi-custom-v...
https://zebrabi.com/excel-add-in/
https://zebrabi.com/powerpoint-add-in/
FIND US AT https://www.zebrabi.com/