On July 19, 2018, Microsoft Corp. announced the financial results for the quarter ended June 30, 2018, as compared to the corresponding period of last fiscal year. The results are impressive, for example: Revenue was $30.1 billion and increased 17% Operating income was $10.4 billion and increased 35% Net income was $8.9 billion GAAP and $8.8 […]
Author Archive for: lapajne
You are here: Home / Andrej Lapajne
About Andrej Lapajne
CEO at Zebra BI
15 years of experience in BI and software development and 10 years as consultant. Studied computer science, painting and management accounting. Currently working on his Ph. D. on visual languages.
He has implemented reporting systems and business intelligence dashboards in pharmaceutical, telco, retail, FMCG, manufacturing, media, insurance, banking, energy, public administration and high tech industries.
As consultant, mentor or trainer helped numerous companies sort out their business reports, presentations and especially BI dashboards. Once labelled "a genious or a madman" by J. Peltier for discovering a new visualization trick in Excel.
Entries by Andrej Lapajne
Zebra BI Visuals, the only IBCS®-certified software solution for Power BI, has just been updated to version 1.3 that brings several exciting new features that make it easier to create convincing and clear visual business presentations in Power BI. This release is available for existing subscribers as well as a free trial and delivers improved comparisons […]
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
You can create better reports. Here we present 3 excel report templates for the 3 cornerstone financial reports. Recipes how to create them included.
2016 was the year of the product releases. Well, heck, so were the rest of them 😉 And so will be the next one. We can't help it, we're the product people. But before we dive into product releases, let us share a few stories that we'll remember best from 2016.
In the recent update of The New York Times's article Who Will Be President? the authors used an interesting and a slightly controversial infografic, consisting of 16 sparklines. The graphic depicts the trends of Donald Trump's winning probabilities in the states, where his chances have increased most over the last two weeks. Unfortunately, the visualization fails to convey a proper picture of the […]
Whether it is sales-vs-budget or costs-vs-budget, every company uses variance analysis to track the actual performance against their goals. In this webinar you'll learn how to design efficient variance reports using Excel and Zebra BI.
This time we'll take a deep dive into the 2014 annual report of Bill & Melinda Gates Foundation to find out if data visualization can help explain their consolidated financial statements. As Stephanie Evergreen pointed out in her intriguing article, there's a lot of room for improvement in annual reports of non-profits and foundations (to […]
Recently, my attention was drawn to an interesting analysis of The Hottest Startup Sectors In 2016, written by Tomasz Tunguz. It shows the trend of investments into 16 major startup markets and tries to expose the gap between seed and Series A investment dollars. The arrangement of charts into a "small multiples" chart matrix is an excellent […]
Charts should provide a clear and practically immediate insight into the underlying dataset. Especially if we're talking about one single chart, created from a tiny, almost trivial dataset. If we cannot achieve that, how will we tackle the complexity of our business and social environment in the age of big data? Let's take the following example […]
Have you ever tried making small multiples in Excel? I have. Several times. It's possible. Everything is possible in Excel, but some things just take forever. And when you're done and realize you'd like to change it just slightly, it takes forever again. Countless times I was in a situation where small multiples of, say, 12 […]
How do your financial reports look? All too often, they fall somewhere between messy spreadsheets and dashboards, full of poorly labelled and inappropriate charts, that simply do not get the message across to the decision-makers. Countless reports and presentations are created throughout organizations on a daily basis, all in different formats, lengths, shapes and colors, […]
In this article we will explain how to choose the right chart for your data. Or more precisely, for your message. There are 3 fundamental rules that you should always follow when deciding which chart to use. If you learn these 3 rules, there is a good chance that you will get it right no matter […]
IBCS Annual Conference 2015, the key event for reporting professionals to exchange experience with their peers, thought leaders, consultants and software developers, will be held on June 19th at Royal Philips Global Headquarters in Amsterdam. The conference will offer practical case studies of rolling-out IBCS (International Business Communication Standards) in established corporations, as well as focused discussions […]
On May 13 we released Zebra BI version 1.3.1. and we're very happy to announce that it is now also available in the Spanish language. Since Zebra BI is already in use in Spanish companies and is just entering the Latin American market, we hope this will ensure even better user experience to our Spanish-speaking users.
A butterfly chart is a special type of bar chart, often used to represent two data series side by side, such as comparing male vs. female, displaying positive vs. negative opinions, presenting election results (e.g. republicans vs. democrats), etc. In general, you may use it as an alternative to a regular bar chart or a […]
What do you do when a thing that you have been thinking of for more than 5 years and work so intensively and passionately on, is realized? Well, I get a little empty and a little emotional. So I hope you don't mind if this story turns out slightly emotional. Drive. That's what we do […]
As many of you may know the HICHERT®IBCS conference is currently taking place in Frankfurt. We are present by sponsoring the event and presenting Zebra BI to wide audience of management reporting professionals. With the official launch we are also presenting many new features, such as one-click scaling of multiple charts, colorblind-safe color scales, enhanced charts, […]
We are ready! Zebra BI version 1.0 will be officially launched at the [email protected] conference in Frankfurt on 24th of June 2014. After getting valuable feedback from our beta testers, we have implemented some exciting new features, fixed open issues and are now prepared to LAUNCH! We will publish the official Zebra BI version 1.0 […]