Browsed by
Category: Reporting

Exporting to Excel from PowerShell without having Excel installed

Exporting to Excel from PowerShell without having Excel installed

Comments 0 Comment

TLDR In case you don’t have time reading my writing about PowerShell and the coding process and just would like to have a script up and running feel free to jump right to the end of the blog post where the final scripts are provided. What’s this all about? As a BI/Analytics Practitioner my most common tool for communicating data to business users is Excel. I have been working to build a modern analytics infrastructure leveraging OLAP cubes for a…

Read More Read More

A matter of data visualization

A matter of data visualization

Comments 0 Comment

Some time ago my boss asked me for advice on a report he just created. Here’s an example with sample data of what he liked to visualize: For different dates we have a count of objects which had a specific final status. You can reproduce the sample data using the following select statement: query-with-inline-sample-data Goal of the visualization should be to show the distribution across the different status and the overall development of the measured data. Our first approach was…

Read More Read More

Create your own shapefile

Create your own shapefile

Comments 4 comments

This blog post is about creating custom shapefiles to support your own visualizations. A shapefile is a vector graphic used for visualisation of spatial data (like maps) by numerous BI frontends or reporting tools.  The blogpost was inspired by a presentation on “free visualisation with the CSP C8 Frontends” given by Matthias Jüstel and Ivo Pawlow at the Cubeware Infotag 2015 in Rosenheim. The presenters repeated their presentation in a webcast on 25.02.2016 which can be viewed on the Cubeware…

Read More Read More