you can use an excel file to create data set in sap lumira.

follow the steps given below.

step 1 − go to file → new (create a data set).

step 2 − select a source − load an excel worksheet as a dataset and click the next icon at the bottom.

step 3 − browse the path of .xls file. you have an option to choose the first row as column names. you can hide a particular column from .xls by selecting the select all option.

step 4 − you can click the advance option to select a custom range. you can also include hidden rows and columns. once correct options are selected, click the create button at the bottom.

step 5 − all the data with integer values appear under measures and all the columns appear under dimensions. this data will come under the prepare tab.

step 6 − go to the visualize tab at the top to create the visualization on top of the data set.