| Data Model provides tools for building relational databases directly in Excel |
| Excel Data Model |
| Data Model Window |
| Data View Vs. Diagram View |
| Database Normalization |
| Data Tables vs. lookup tables |
| Primay and Foreign Keys |
| Relationship vs. Merged Tables |
| How to create table relationship in Diagram view by click and drag |
| Always drag relationship from data table to lookup table |
| How to create table relationship using design tab |
| Connecting Lookups to lookups |
| How to modify table relationships |
| Active vs. Inactive Relationships |
| How to make a relation as active |
| Cardinality refers to uniqueness of values in a column |
| In Power piovt all relationships in data model should follow a "one-to-many" cardinality |
| Cardinality |
| One to one cardinality ( Bad) |
| Connecting multiple data tables |
| Always hide the foreign key columns in your data tables to prevent users from accidentally filtering on them |
| How to hide fields |
| Hierarchies are groups of nested columns that reflect multiple levels of granularity |
| How to create hierarchies |
| Data model best practices |
No comments:
Post a Comment