Tahir Hussain “Bob” Babar from the SAP HANA Academy showcases how to construct visualizations in SAP Lumira.

After opening up a locally stored document containing data, enriching and cleansing some of the data and creating a geographic hierarchy in the prepare tab, Bob begins to build visualizations of his data.

First, Bob explores the visualization tab detailing how to add measures and attributes, how to create and duplicate multiple visualizations, and how to add data filters to the visualizations.

Bob first throughly details how to build a bar chart (specifically a column chart) in SAP Lumira. Dragging an attribute for state onto the blank canvas in the middle designates that attribute for the X-axis and dragging the sales revenue measure onto the canvas designates that measure for the Y-axis. This quickly creates a column chart for sales revenue per state. SAP Lumira puts certain restrictions on how measures and attributes can be visualized. For example, in a bar chart measures always go on the Y-axis and attributes always go on the X-axis.

Next, Bob details some of the additional features SAP Lumira offers for modifying visualizations. A trellis allows a user to have more than one chart displayed on a page. Bob demonstrates how a trellis works by splitting up his sales by state revenue chart into three charts by putting the year attribute into first the rows trellis option and then the columns trellis option. This creates two different visualizations of the same information.

After saving his chart, Bob shows how to duplicate his chart in order to re-format it using filters. A user can filter their charts by selecting a group of certain variables of the different attributes and in Bob’s example he choses to filter his chart by the line (attribute) variable of jackets. Then Bob modifies another duplicated chart by dragging the year attribute into the X-axis’ legend color option to plot the sales revenue of jackets per state by year.

After one simple click, Bob transforms the bar chart into a stacked column chart that visualizes the sales revenue by state and year for the jacket line. Next Bob profiles how to create a column chart with 2 Y-axes by adding an additional measure of target. Column charts with 2 Y-axes are great for quickly comparing different measures side by side. Bob shows the ease in which the order of the displayed measures can be changed by using the drag and drop functionality in a 3D column chart.

Next Bob showcases the various options for line charts. Bob advices that line charts are best used to visualize time. Bob runs through the five line chart options by creating different visualizations of the sales revenue and target by year.

Bob then profiles the different options SAP Lumira offers for pie charts. Bob notes that the trellis feature is very useful when creating pie charts especially when depicting time. Finally, Bob showcase the table option, which visualizes the hard data numbers in a tabular format.

Bob’s informative tutorial video showcases how to visualize data using bar charts, line charts, pie charts, and tables in SAP Lumira.

Screen Shot 2014-03-03 at 10.33.04 AM.png

View other tutorials on SAP Lumira at the SAP HANA Academy.

SAP HANA Academy – over 500 free tutorial technical videos on using SAP HANA.

-Tom Flanagan

SAP HANA Academy

Follow @saphanaacademy

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply