It’s always advisable to begin with the data view. You basically get the preview of what your data looks like. Here are a few things to take care of, before you actually start creating the dashboard.
-
Rename columns
We’re building the dashboard for the user. All the naming conventions and data types are going to appear at the surface and we want it to be as interactive as possible.
-
Delete Columns
Anything that’s not absolutely necessary in the model – delete it. Because it’s going to contribute to the size of the model and take up more system resources whilst processing.
-
Hide Columns
Columns that you need later for calculation purposes, but the user doesn’t necessarily need to see it, hide them. The hidden column will appear grayed out and won’t appear in the report view.
For more details have a look at this blog.