Modeling the data
Now that the data has been loaded, there are a few modeling techniques that should be applied to the model. Due to the mash up nature of the Tabular Models, you will likely need to do the following common clean up operations:
- Update column names
- Fix data types and formats
- Add relationships
You will learn how to do each of these in this recipe.
Getting ready
Before you can model data, you will need data in your model. If you have not loaded data yet, refer to the previous recipe on loading data.
How to do it…
You will be working in SSDT to make the changes.
- Our first change is to update the column names. The column names should be user-friendly and easy to understand.
- You can rename the column by right-clicking on the column and selecting ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
