中彩网|首页|官网电脑版

                                Normalized Tables

                                This post is also available in: Italian


                                MATRIX


                                NORMALIZED

                                Most excel users wish to read data in a matrix- computers need tables. Fast Excel Development uses normalized data and pivot tables to calculate in efficient structure and report data in a way that people like to see.

                                Normalized tables specify a systematic structure for data with each fact relationship appearing only once. For instance, the Item Master carries Item attributes and any calculation or report that needs them will query this table.

                                Normalized data eliminates fact inconsistencies and ensures calculations on a field can be performed in a single column. This both speeds up and simplifies calculation logic. The oft-found alternative to normalized tables, matrices, are never used for calculation or data storage but instead generated where required with pivot tables.

                                Next: Stacking, Exploding and Pivoting tables.

                                Leave a Reply

                                Scroll to Top

                                                              culture

                                                              reading

                                                              culture

                                                              society

                                                              game

                                                              culture

                                                              culture

                                                              Mobile phone

                                                              culture