Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have been told that I need to create a table dimension table. What I need to do is to create relationships to this table from ~10 other tables. The ~10 tables have various names for our locations. The Dimension table would hold the common name for the location that I want to present in a data visualization and therefore allow the data from the ~10 tables to be displayed in one visualizaton. How is this done? Any help is appreciated
Common Name | T1- Name | T2 - Name | T3 - Name | T4 - Name |
F1 | Fac1 | Facility1 | 1 - Fac | Fac - 1 |
F2 | Fac2 | Facility2 | 2 - Fac | Fac - 2 |
F3 | Fac3 | Facility3 | 3 - Fac | Fac - 3 |
F4 | Fac4 | Facility4 | 4 - Fac | Fac - 4 |
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |