To ease understanding, our articles are based on very simple Excel tables. But what if the data structures are more complicated or you’d like to build dynamic reports, linked directly to your database? Well, Zebra can handle that, too! Read on to find out how you can do that.
The good thing about Zebra BI is that you can prepare tables in numerous ways and with several technologies within Excel. You can take advantage of any of the following options to create dynamic charts, automatic reports and live dashboards:
- Plain Excel cells with values and/or formulas, that you just enter manually or possibly link with Excel formulas.
- Pivot Tables, that can be inserted either from Excel data or connected directly to external data sources.
- OLAP Pivot Tables, connected directly to OLAP data sources, such as MS Analysis Services.
- PowerPivot tables.
- Data tables created with popular Excel analytic tools, such as SAP Business Objects Analysis for Office and many others.
We have designed Zebra BI to work with all of the above-mentioned technologies! That’s one of the features that make Zebra BI a powerful reporting tool, regardless of how you extract and prepare your data. Especially with pivot tables including slicers Zebra Bi creates a meaningful report which updates your charts if you slice the data in your pivot table.