Archives

March 28, 2024
How to Calculate Months Between Two Dates in Excel
Using our guide, you'll learn how to calculate the number of months between two dates in Excel.
March 28, 2024
How to Separate First and Last Names in Excel
Our step-by-step guide will teach you how to easily separate first and last names in Excel. Read & save for later!
March 28, 2024
How to Create and Maintain Interactive Dashboards in Power BI
Learn how to create and maintain interactive dashboards in Power BI with our comprehensive guide.
March 25, 2024
Data Storytelling with Power BI Comments: Shaping Insights and Decisions in 2024
Find out why you should include comments in Power BI reports to deliver clear context and insights, which will help you make informed and strategic decisions.
March 25, 2024
How to Calculate Percent Change in Excel
Follow this step-by-step guide and learn how to calculate percent change in Excel.
March 21, 2024
Data Visualization Trends 2024: Don't Get Left Behind – Discover What's Next
Explore 2024's data visualization trends for better business insights, integrating AI, interactive reports, and cross-platform collaboration.
March 19, 2024
How to Calculate Compound Interest in Excel
Using this simple guide, you will learn to calculate compound interest in Excel easily.
March 19, 2024
How to Clear All Filters in Power BI
Check out our step-by-step guide to learn how to clear all Power BI filters.
March 18, 2024
How to Calculate and Interpret Financial Ratios in Excel
This comprehensive guide will teach you how to calculate and interpret financial ratios in Excel.
PowerPoint
March 16, 2024
How to Prepare Financial Statements in PowerPoint
Follow our step-by-step guide to create professional and visually appealing financial statements in PowerPoint.
March 15, 2024
How to Pull Information From Another Sheet in Excel
Learn how to easily extract data from another sheet in Excel with our step-by-step guide.
March 15, 2024
How to Perform Pricing Analysis in Excel
Learn how to perform pricing analysis in Excel with our comprehensive guide.
March 14, 2024
Understanding Business Insights: The Ultimate KPI Cheat Sheet
Learn how to understand business performance metrics across industries with Zebra BI's Ultimate KPI Cheat Sheet.
December 19, 2023
7 Best Practice Tips for Presenting Financials to the Business
In this collaboration between the FP&A Guy and Zebra BI learn the 7 best practice tips for presenting financials to the business.
December 4, 2023
The Future of Data Storytelling: Actionable Intelligence [AI, Power BI, and Office]
Learn about Actionable Intelligence and its role in data storytelling. AI is the future, but Power BI and Office are here to stay.
November 29, 2023
Leila Gharani x Zebra BI: How To Design A Perfect Excel Dashboard From Scratch
Discover key tips for Excel dashboard creation with Leila Gharani's tutorial and enhance your skills using Zebra BI's advanced tools for optimal analysis.
PowerPoint
October 27, 2023
How To Create Professional PowerPoint Slide Decks: Zebra BI's Ultimate 2023 Guide
Explore expert tips for creating professional PowerPoint for FP&A analysts. Learn to create consultant-level, visually engaging presentations efficiently.
September 21, 2023
Financial Analysis in Power BI: How To Do Financial Benchmarking Right [Fortune 500 Companies Real Data Examples]
Dive into financial analysis in Power BI: Master financial benchmarking with real Fortune 500 data examples using Zebra BI visuals.
September 6, 2023
Zebra BI Tables: The Best Matrix & Table Visual on The Market in 2024
Explore Zebra BI Tables for efficient report space, clear visuals, and easy use. Ideal for modern business challenges with advanced visuals and IBCS compliance.
August 24, 2023
The Ultimate 2023 Bar Chart Guide
Uncover the process of crafting effective bar charts. Dive deep into Excel and Zebra BI's rich capabilities for a superior data presentation.
August 15, 2023
Scenario Analysis with Zebra BI: The Essential 2023 Guide to Avoiding Costly Business Mistakes
Explore the power of scenario analysis with Zebra BI. Seamlessly transition between Power BI, Excel, and PPT for informed business decisions.
August 7, 2023
Interactive Excel Dashboards: Master Cross-Visual Filtering In 3 Easy Steps like in Power BI
Explore Cross-Visual Filtering in dashboards. Enhance interactive data analysis in Excel & Power BI for sharper insights and informed business choices.
June 29, 2023
How to create a Horizontal Waterfall Chart in Power BI: Ultimate 2023 Guide
Discover how to create a Horizontal Waterfall Chart in Power BI for impactful, dynamic data visualization. Transform your reports with ease.
June 29, 2023
9 Common Mistakes of an FP&A Analyst – And How to Avoid Them
Unearth 9 common mistakes made by FP&A analysts in our comprehensive guide. Learn from past missteps and turn them into stepping stones for success in your FP&A journey.
June 27, 2023
How to Subtract Multiple Cells in Excel
Learn how to easily subtract multiple cells in Excel with our step-by-step guide.
June 23, 2023
How to Get Search Option in Slicer in Power BI
Learn how to add a search option to your slicer in Power BI with this step-by-step guide.
June 21, 2023
Adjusted Financial Statements & Adjusted EBITDA: How to Unlock Their True Power in Excel
Delve into the intricacies of adjusted financial statements and adjusted EBITDA with our comprehensive guide. Elevate your financial reporting with Zebra BI for Excel.
June 21, 2023
5 Essential Steps on How to Count Rows in Power BI: A Comprehensive Guide
Learn how to count rows in Power BI with our step-by-step guide.
June 21, 2023
How to Concatenate Multiple Columns in Power BI
Learn how to concatenate multiple columns in Power BI with ease using our step-by-step guide.
June 21, 2023
How to Combine Two Columns in Power BI: 2 Ways Explained
Discover how to seamlessly combine two columns in Power BI. Enhance data structure, refine analysis, and boost report performance effectively.
June 21, 2023
How to Change Date Format in Power BI
Learn how to easily change the date format in Power BI with our step-by-step guide.
June 16, 2023
How to Add Index Column in Power BI (DAX)
Learn how to easily add an index column to your Power BI Dax table with our step-by-step guide.
June 16, 2023
How to Add Filter Button in Power BI: 6 Key Steps for Better Analytics
Learn how to add filter button in Power BI. Boost your analytics with intuitive filtering. Simplify data insights with our easy-to-follow guide.
June 16, 2023
How to Add Checkboxes in PowerPoint: A Comprehensive 5-Step Guide for Engaging Presentations
Learn how to add check boxes in PowerPoint with this step-by-step guide.
June 14, 2023
Mastering the 80/20 Rule: How to Make a Pareto Chart in Excel
Elevate your data analysis skills by mastering the Pareto principle in Excel. Uncover the benefits of Zebra BI for insightful, efficient charting.
June 13, 2023
Power BI: How to Insert Row Numbers in Table Visual
Learn how to add row numbers to your Power BI table visual with this step-by-step guide.
May 31, 2023
Balance sheet in Excel
Conquer the creation and analysis of a balance sheet in Excel with our comprehensive guide. Learn to gather data, calculate ratios, draw insights, and present effectively.
May 30, 2023
Financial Statements Cheat Sheet: Your Secret Weapon in Financial Analysis
Master the world of financial analysis with our handy financial statements cheat sheet. Your passport to easy understanding of balance sheets, income statements, and more!
PowerPoint
May 29, 2023
Cracking the code: What are liquidity ratios & how to present them effectively?
Dive into liquidity ratios and understand key ratios like current and quick. Learn how to visualize them effectively for impactful business presentations.
PowerPoint
May 28, 2023
What is EBITDA, how to calculate EBITDA, and how to present it
Discover what EBITDA is, learn how to calculate it, and explore ways to effectively present it for strategic financial analysis in our comprehensive guide.
May 25, 2023
Charting New Territories: How Data Visualization Using AI is Revolutionizing Business Insights
Unveil the future of business intelligence as we delve into data visualization using AI, revealing game-changing tools and a glimpse at what's to come.
May 24, 2023
Breaking it down: The Top 5 FP&A Tools for Excel in 2023 That You Can't Afford to Miss
Unlock the full power of Excel with the top 5 FP&A tools of 2023. Streamline analysis, modeling, reporting and visualization for data-driven success.
May 22, 2023
Top 8 Management Reports in Power BI in 2024
Explore the top 8 management reports in Power BI and elevate your analytics with the advanced capabilities of Zebra BI in our comprehensive guide.
PowerPoint
May 14, 2023
Best practices for creating PowerPoint template for business presentations
Dive into our comprehensive guide on creating an effective PowerPoint template. Empower your business presentations with visually stunning, clear, and impactful slides. Learn the best practices today.
May 14, 2023
5 Essential Steps to Mastering Your PowerPoint Consulting Presentation
Master the art of creating compelling consulting presentations with PowerPoint. Discover top consulting firms' practices and enhance your skills.
PowerPoint
May 12, 2023
How to use PowerPoint to create compelling sales presentations
Maximize your sales presentations with Zebra BI for PowerPoint - your go-to for stunning data visualization and captivating narratives.
PowerPoint
May 5, 2023
6 Powerful Tips for Crafting Outstanding Investor PowerPoint Presentations
Ace your investor PowerPoint presentations with our comprehensive guide on building impactful stories, emphasizing essential metrics, and skillfully employing visuals.
April 28, 2023
How to use Excel for financial statement analysis: 8 brilliantly simple tips
Master the art of financial analysis with our comprehensive guide. Learn how to use Excel for financial statement analysis and drive business success.
April 26, 2023
Best practices for using Excel for data visualization
The ultimate guide for using Excel for data visualization. Learn everything you need to create convincing and impactful reports and dashboards.
April 26, 2023
How to Use Excel for Market Analysis in 4 Simple Steps
Learn to use Excel for market analysis with our step-by-step guide. Dive into your data, create effective visuals using Zebra BI for Office, and make data-driven decisions fast.
April 24, 2023
4 Foolproof Tips for Using Excel for Break-Even Analysis 
Get the most out of your break-even analysis in Excel with our 4 game-changing tips. This easy-to-follow guide will take you through it step by step.
April 24, 2023
How to Use Excel for Inventory Management: The Essential Guide for 2023
Discover how to use Excel for inventory management in our essential 2023 guide. Master sorting, filtering & analytics to optimize your business.
April 21, 2023
Best practices for creating Excel charts for financial reporting
Learn everything you need to create accurate, impactful & actionable financial reports using Excel charts. Based on best practices only!
April 19, 2023
5 Must-Know Tips for Using Pivot Tables in Excel for Financial Analysis
Pivot tables for financial analysis: your new Excel BFF! Uncover their power to turn complex data into crystal-clear insights. Click, learn, and conquer!
April 18, 2023
Master the Art of Data Transformation: Use Power Query to Transform Data in Excel
Want to up your data transformation game? Our guide on how to use Power Query to transform data in Excel is here to help!
PowerPoint
April 18, 2023
7 Tips for Creating Effective Financial PowerPoint Presentation: Best Practices and Techniques
Discover expert tips for creating impactful financial PowerPoint presentations that engage your audience and deliver key insights effectively.
March 31, 2023
Stacked Bar Chart in Excel: How to Create Your Best One Yet
Stacked bar charts allow you to break down your data into segments, which provides your stakeholders with a comprehensive view of the information at hand. Learn how to create your best stacked bar chart in Excel with next-level features using Zebra BI for Office.
March 22, 2023
Must-Know Tricks for Interactive Excel Dashboards in 2024
Learn the must-know tricks for creating compelling interactive Excel dashboards that deliver key business insights at a glance. Level up your reporting while saving yourself some precious time.
March 21, 2023
Cash Flow Statement in Excel: How To Create A Good One In 2023
Learn how to create a powerful cash flow statement in Excel for your business. Track your cash inflows and outflows with accuracy and identify trends, risks, and opportunities.
March 10, 2023
Top 3 Financial Statements in Excel: Income Statement, Balance Sheet & Cash Flow
To gain insight into their financial health and progress, most companies need to prepare three essential reports – income statement, balance sheet and cash flow statement. Let's explore them one by one.
PowerPoint
March 7, 2023
PowerPoint Waterfall Charts: How To Create One That Doesn't Suck
Discover the art of creating dynamic waterfall charts in PowerPoint with our in-depth guide. Ideal for beginners and advanced users seeking to enhance their presentation skills!
PowerPoint
December 9, 2022
Actionable reporting in Excel & PowerPoint: How to convert boring reports into data stories
Tired of messy spreadsheets with bad visualizations? It's time to put them to rest and learn how to present the most important insights fast.
November 30, 2022
Price Volume Mix Variance Analysis in Power BI
Find out how to perform a Price Volume Mix Analysis in Power BI to see how price, volume and product mix changes affect your revenue.
November 24, 2022
Excel Report Templates: Build Better Reports Faster
If you take just a couple of minutes, you can rethink your approach to creating and designing your business reports. In this article, you can find key Excel report templates for some of the most commonly used business reports.
October 5, 2022
Power BI Performance Optimization Checklist
Slow-loading reports are a waste of everyone's time. But this checklist can help. Optimizing Power BI performance has never been easier!
September 22, 2022
Power BI Performance Optimization: How to Make Your Reports Run Up to 10X Faster
Speed up your reports & decrease load time to under a second. Power BI performance optimization has never been so simple! Includes checklist.
May 16, 2022
Top 9 Power BI Dashboard Examples
Get inspired with our actionable Power BI dashboard examples. Try them out using interactive embeds and download the PBIX files to make them your own.
April 25, 2022
Time intelligence in Power BI: Advanced DAX techniques
This guide will discuss time intelligence in Power BI: using advanced DAX functions to to eliminate seasonality and fluctuations from your reports.
March 14, 2022
Consolidating KPIs in Power BI: the only guide you'll ever need
Master 3 ways to consolidate your KPIs in Power BI. Make your dashboards easier to use, more understandable and actionable.
December 21, 2021
How to create a KPI dashboard in Power BI to make smarter decisions faster
How to design KPI dashboards and landing pages in Power BI that are actionable and understandable. Turn data into a smarter decisions driver.
October 3, 2021
How to choose the correct chart type for your Power BI report
Learn the criteria you need to consider when choosing the charts for your report and discover the most suitable chart types with examples.
May 27, 2021
How to Implement Writeback Comments in Power BI Using Power Apps
In this guide you'll learn how to create simple Power Apps that will add dynamic writeback comments to your Power BI reports and dashboards.
April 22, 2021
IBCS - Achieve Consistent Reporting Across Your Company
Get to know the basics of IBCS, learn how to redesign a sales dashboard, and find out how to implement IBCS in your organization.
April 1, 2021
The Most Effective Power BI Dashboard Tips and Tricks
We gathered the most effective Power BI dashboard tips and tricks to make your life easier - from layout and tooltips to small multiples and help tutorials.
March 29, 2021
Power BI for Business Analysts: The top tools you need in your toolbox
Learn all about designing sales vs. plan performance dashboards, cost vs. budget analyses, income statements and forecasts, and more.
March 24, 2021
Power BI Dashboard Design: Avoid These 7 Common Mistakes
This tutorial explores the most common mistakes in Power BI dashboard design. A dashboard redesign and follow-along PBIX example included.
March 17, 2021
Supercharge Your Power BI Dashboards with Small Multiples
Learn how to create amazing Power BI dashboards with small multiples. We provide multiple examples, so you can try it on your own data next!
March 9, 2021
Tableau vs Power BI: The Superstore Challenge
Take a single case and work with both tools, Tableau and Power BI, to see what they offer and compare the features.
February 19, 2021
Live interview with Andrej Lapajne: What’s the Future of Reporting and the Job of a Controller?
How does the future of reporting look like? How will controllers need to adapt to it? Hear it for yourself from Zebra BI CEO and Founder, Andrej Lapajne.
January 27, 2021
Power BI Productivity Features: Build your reports amazingly FAST!
This tutorial outlines some of the best practices and step-by-step Power BI productivity features that work like magic. Themes, templates, and more.
January 25, 2021
Power BI themes: Deep dive into visual styling of Power BI reports
Custom themes are one of the best features in Power BI. You can control almost every property of every report element with a custom Power BI theme.
December 10, 2020
The Definitive Guide to Income Statements in Power BI
Learn how to make income statements in Power BI more understandable, actionable, flexible and quicker to create. Includes follow-along PBIX file.
December 3, 2020
Price Volume Mix Variance Analysis in Excel
Find out how to perform a Price Volume Mix Analysis in Excel to see how price, volume and product mix changes affect your revenue.
November 12, 2020
Top 5 Power BI DAX tricks for super effective Power BI dashboards
Learn 5 powerful Power BI DAX tricks to take your Power BI reports and dashboards to the next level. Includes follow-along PBIX example.
October 26, 2020
How to Create Dynamic Comments in Power BI: How to Start
Commenting can make or break your Power BI reports. We will show you basic & advanced ways of commenting to make your life easier.
October 23, 2020
Dynamic Comments in Power BI
Learn everything about dynamic commenting, different methods of commenting, its features, and usability in reporting.
May 28, 2020
How to manage working capital in times of COVID-19 crisis?
We prepared a comprehensive set of working capital management strategies to help companies overcome the economic threat of COVID-19.
May 11, 2020
Impact of COVID-19 on the global stock markets – Live Data
We built an interactive dashboard that shows the unprecedented stock market volatility of the world’s top 200 companies during the COVID-19 pandemic.
July 30, 2019
Custom Power BI Visuals Can Turn Your Reports Around
Power BI provides practically anyone with a powerful tool, to explore data and find insight. Find out how to make use of its functionalities.
April 11, 2019
The Best Power BI Visuals (Built-in and Custom) for Actionable Reports and Dashboards
It has never been this easy to visualize and tell stories with your data. We'll focus on some built-in and custom visuals to make your reports more actionable.
February 20, 2019
Burning Questions: How to Add a Monthly/YTD Switch to a Power BI Dashboard?
Learn how to create a switch in Power BI dashboard that allows you to switch between Monthly and YTD views by using Data Analysis Expressions (DAX).
February 12, 2019
Top 5 New Productivity Features in Zebra BI Custom Visuals for Power BI
The latest version of Zebra BI for Power BI brings a bunch of new features that bring new flexibility to standardized reports.
January 7, 2019
7 things that you can do in Zebra BI visuals that are hard to do in Power BI
Power BI is a powerful tool for analyzing and visualizing data, but it falls short in some areas. Find out how Zebra BI visuals can make your life easier.
August 8, 2018
Mastering Variance Reports in Power BI
We explained the different types of variance reports and how to set them up in Microsoft Power BI to make reports clear and easy-to-understand.
July 30, 2018
Microsoft income statement - FY18 Q4 financial results in Power BI
See an example of using Power BI capabilities with the advanced visualization capabilities of Zebra BI used for redesigning Microsoft's income statement.
June 1, 2018
Build Spectacular Power BI Dashboards using Zebra BI custom visuals
Get to knowall of the features that Zebra BI offers and how they contribute to better reporting experience in Power BI.
March 1, 2018
How to Design Income Statements in Excel
If there is one report that's a business constant, it's the income (profit & loss) statement. Learn how to create an actionable income statement in Excel
June 30, 2017
A different way to present cash flow statement
This is a guest post by Saša Butina, a consultant at SASH reporting. See more about SASH reporting at the end of the post.
June 21, 2017
Excel Waterfall Charts: How To Create One That Doesn't Suck
Learn how to create a visually appealing waterfall chart in Excel with our step-by-step guide. From beginners to experienced users, our guide provides all the necessary tips and tricks to impress your audience.
September 17, 2016
Trump's Chances - Redesign of The New York Times's Infografic
This visualization fails to convey a proper picture of the trends due to inconsistent scaling of charts. Learn 3 alternative solutions how to adress this problem.
August 18, 2016
Difference highlight: the fastest way to improve your reports and dashboards
Good data visualization removes all unnecessary items and emphasizes the important values. One of the best tools for this is a difference highlight.
July 7, 2016
How to create interactive reports and dashboards in Excel
Updating your monthly, weekly and daily reports in Excel can be a tedious task. Fortunately, you can use some of the native Excel functions to automate it.
March 24, 2016
Top 3 Ways to Report your Variance Analysis in Excel
There are a couple of different ways to perform variance analysis. Learn how to easily do it in Excel in 3 ways and improve your reporting.
March 23, 2016
8 Steps to Creating an Efficient Variance Report
The internet is full of bad examples of variance reports. Follow this guide to see how we turn one such example into a great and efficient variance report.
March 3, 2016
Struggling to visualize your data? Zebra BI's got you covered!
Whether it’s waterfall charts, variance charts, or lollipop charts, Zebra BI has everything you need to visualize your data for all to understand.
February 5, 2016
The fastest way to insert lollipop charts in Excel
Lollipop charts can be used in similar situations as bar charts and column charts, but they have the advantage of producing a cleaner-looking picture.
January 19, 2016
Designing Financial Statements for Non-Profits & Foundations - The Gates Foundation example
This time we'll take a deep dive into the 2014 annual report of Bill & Melinda Gates Foundation. Check how we redesigned their financial statement.
January 12, 2016
How to visualize trends for multiple markets, products, etc.
Recently, my attention was drawn to an interesting analysis of The Hottest Startup Sectors In 2016. See how we analyzed and redesigned the data.
January 7, 2016
Why are some charts difficult to understand?
Charts should provide a clear and practically immediate insight into the underlying dataset. Learn how you can take control of the complexity of big data.
October 9, 2015
Making small multiples in Excel
Everything is possible in Excel, but some things just take forever. Find out how Zebra BI can help you create small multiples in just 1 click!
October 8, 2015
Designing financial reports, dashboards and business presentations
Design your reporting tools more clearly ans consistently throughout your company. Get to know the importance of IBCS standards in reporting.
August 13, 2015
How to Choose the Right Business Chart - A 3-step Tutorial
In this article we will explain how to choose the right chart for your data. Or more precisely, for your message.
July 21, 2015
How to create an IBCS compliant profit & loss report in a few minutes
We'll show you how you can create the standard profit & loss report (income statement) that is IBCS compliant in just few minutes!
June 16, 2015
Exclusive interview with Dr. Rolf Hichert, part 3 of 3
Explore the importance of software in the implementation of IBCS reporting standards in a company and what the future holds.
June 3, 2015
Exclusive interview with Dr. Rolf Hichert, part 2 of 3
Learn some practical tips to successfully implement IBCS in your company, as well as why Mozart didn't add a little 3D effect to notes in his sheet music.
May 18, 2015
On using Butterfly (aka Tornado) charts
Find out what data could be presented with butterfly charts and how to get the most out of this type of data presentation.
May 12, 2015
Exclusive interview with Dr. Rolf Hichert, part 1 of 3
Learn why it's important to introduce standardization in reporting, some examples, and what are the most important concepts in IBCS.
May 8, 2015
The 3 steps to implementing management reports in a pharmaceutical company
The project made in collaboration with a Serbian pharmaceutical company aimed to make management reports more transparent, visual and automated.
April 22, 2015
Infographic: How to Choose the Right Chart
This infographic will teach you everything you need to know to always select the perfect chart. Link to free whitepaper with more information included.
March 26, 2014
Young adults' living conditions getting worse - a redesign of The Guardian Datablog's visuals
The article is based on Eurofound’s European Quality of Life Survey (EQLS), a representative survey of those aged 18 and over in Europe.
February 14, 2014
Happy Valentine's Day! But hey, where is the romance?
We created a quick analysis with our Zebra BI to see if data on Valentine's Day spending and gifts conveys any important messages.
November 12, 2013
Small Multiples – 16 are better than one
Small multiples are the best design solution for a lot of problems in data presentation. Learn how to produce them in less than one minute with Zebra BI.