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.