Andrej Lapajne
Andrej Lapajne is founder and CEO of Zebra BI. Zebra BI is a software company developing an Excel add-in, focused on empowering users to create standardized and impactful reports and presentations, which meet the IBCS® guidelines.
About
Management information design is Andrej’s great passion where he combines his knowledge of computer science, painting, visual communication and controlling. He has implemented reporting systems for major Slovenian companies in pharmaceutical, telecom, retail, FMCG, manufacturing, media, insurance, banking, energy, public administration and high tech industries. He has also worked for international companies like Coca-Cola, Sandoz, SandvikCoromant, Hypo Alpe-Adria Bank, Danfoss, Saubermacher, Atlantic Group and others.
Andrej studied computer science and painting. He has also finished studies at the School for Controlling in Ljubljana (a franchise of Controller Academie) and is a member of International Institute of Business Analysis (IIBA). He received training from HICHERT+FAISST in 2007 and has worked extensively with the SUCCESS formula of IBCS® ever since.
With more than 15 years of experience in IT, he has gained advanced knowledge of MS Excel, SharePoint and other reporting software. He is also an Excel trainer. He is currently working on his Ph. D. at the Faculty of Computer Science and Informatics, University of Ljubljana.
Andrej systematically explores information design, especially the opportunities of its use to support business decision making. He is a lecturer on information design at the Faculty of Computer and Information Science and Faculty of Economics in Ljubljana. In his academic research, he focuses on visual languages, the criteria of effectiveness of visual constructions and eye-tracking experimental research.
IBCS® Certified Consultant
Andrej Lapajne has successfully completed the IBCS® certification for successful design of reports and presentations at the IBCS Institute in August 2013.
Work samples
All samples are produced with Zebra BI.
Excel reports
Analytical dashboards
The following examples are from a company-wide interactive dashboard, implemented in MS SharePoint and Excel Services.
Reporting 2.0
The key goal of this solution is to overcome the pitfalls of a typical analytical dashboard: there are little or even no messages, comments or explanations. Therefore, we have developed a solution (implemented with MS SharePoint and Excel Services) which we call „Reporting 2.0“. We integrate Excel reports with a social collaboration platform in such a way that the managers get highly personalized quantitative and qualitative information. All information is accessible to end-users via a standard web browser. Since the SharePoint knows who the end-user is, it can present only relevant information to him.
Controlling department, market research analysts and HR specialists regularly write internal blogs, messages and comments. In this way, the people with most knowledge in the company actively contribute written explanations to the dashboard, answering the big “Why?” question in advance. The messages are tightly integrated with dynamic Excel reports and targeted to specific user groups. All comments are at the same time links to in-depth articles on the subject.
