Introduction | Content | Example: Mondrian Schema | Scheme decomposition | Root of the schema template: schema_template.xml | Cube | Table | Dimension | Hierarchy | Level | Measure | CalculatedMember | CalculatedMemberProperty | Validation of Relational Schema and Template Consistency | Usage Example | Generate the Schema | Conclusions

Introduction | Question Definition Styles | Simple Style | Extended Style | Question Definition Process | Define the category | Define questions | Definition function | Definition using a CSV file or an Excel file | Definition using a data frame | Generate the XML file | Kind of questions | Essay (essay: '') | True/False (truefalse: '') | Numerical (numerical: '') | Short Answer (shortanswer: '') | Multiple Choice (multichoice: '') | Ordering (ordering<|>h: h or ordering<|>v: v) | Drag and Drop into Text (ddwtos: '') and Select Missing Words (gapselect: x) | Matching (matching: '') | Drag and Drop Markers (ddmarker: '') | Conclusions

Introduction | Datasets | sigugr.gpkg | sat.tif | mdt | clc.gpkg | Data Transformation | Other transformations | Clipping | Data Storage in PostGIS | Layer storage | Style management | Data Publication on GeoServer | Conclusions

Introduction | CORINE Land Cover | The clc package | Document Structure | Data Included in the Package | Class-Based Operations | Create an object of class clc | Plot of Vector CLC Data | Clipping CLC Data to a Region of Interest | Saving CLC Data and Styles | Copying Styles | Converting CLC Data to Raster Format | Applications of the Generated Raster | Visualizing the Raster Data | Getting the Raster | Conclusions

Introduction | Exercises and exams definition process | Object creation | Exercise definition | Definition of answers in exercises | Template definition | Generation of the exam instances | Conclusions

Introduction | An illustrative example | Definition of levels | Definition of relationships | Obtaining information | Conclusions

Introduction | Dimensional modelling | Star schema and constellation definition | Star schema definition | Star schema rename | Constellation definition | Cleaning and conforming data | Obtaining components | Star schema | Constellation | Definition of updates | Updates application | Dimension enrichment | Incremental refresh | Exporting results | multistar | Query functions | Conclusions

Introduction | Dimensional modelling and star schemas | Dimensional modelling | Dimensions and dimension attributes | Facts and measures | Star schemas | Dimension tables | Surrogate keys | Special dimensions | Fact table | Primary key | Grain | Multiple fact tables | Conformed dimensions | Additional operations | Cleaning and conforming data | Dimension enrichment | Incremental refresh | An illustrative example | Starting data sets | Dimensional modelling data according to age range | Dimensional modelling data according to cause | Star schema definition and transformation: Constellations | Star schema definition for data according to age range | Star schema definition for data according to cause | Star schema transformation, cleaning and conforming data | Star schema rename | Definition of updates | Updates in the where dimension | Updates in the when dimension | Updates in the who dimension | Updates application | Enrich the who dimension | Enrich the where dimension | Constellation definition | Refresh operations for data according to age range | Refresh operations for data according to cause | Filter and purge operations | Exporting results | Star schema | Constellation | multistar | Query functions | Conclusions | References

Introduction | Definition process | Creating an object | Definition of general aspects | Definition of instances | Selection of levels and attributes | Generation of the result | Getting the dimension table | Other configuration options | Dimension table features | Table name | Surrogate key | Renaming the attributes | Names of the parts of the day | Configuration of day and week levels | The first day of the week | Numbering of weeks in the year | Get date range of weeks | Change the definition function of an attribute | Conclusions | Bibliography

Introduction | Starting data sets | Generation of star database refresh structures | Refresh structures | Transformation code | Instances included in the structure | Incremental refresh | Existing fact instances | Incremental refresh operation | Changes in transformation operations | New transformation function | Conclusions

Introduction | Data sets | 122 US Cities Mortality Reporting System | Database of US cities | Flat tables | Create flat_table objects | flat_table attributes and measures | Mortality Reporting System | Measures | Attributes | US cities | Capital status | Joining flat tables | Joining US cities and capital status tables | Joining Mortality Reporting System and US cities tables | Flat table transformation | Separate measures | Transform column names | Transform measure names into attribute values | Definition of the star databases | MRS Cause star database | MRS Age star database | Constellation | Conclusions

Introduction | Stars and constellations | Include geographic information layers | Query functions | star_query() | select_fact() | select_dimension() | filter_dimension() | run_query() | Exploitation of the result | Obtaining layers with geographic information | Get a geolayer object | Operations on variables | Data representation | Conclusions

Introduction | Dimensional modelling and star databases | Dimensional modelling | Dimensions and dimension attributes | Facts and measures | Star databases | Dimension tables | Surrogate keys | Special dimensions | Fact table | Primary key | Grain | Constellation | Conformed dimensions | An illustrative example | Data sets | Star Schema | Dimensions | Facts | Rename fact measures and dimension attributes | Constellations | Definition of star databases | Constellation definition | Export results | tibble list | dm object | Single tibble list | Conclusions | References

Introduction | Example star_database object | Select only one star database | dm class object | List of tibble objects | From component tables | From flat tables | Relational database | xlsx file | csv files | geomultistar::multistar object | Conclusions

Introduction | Get a multistar object | Get a multistar object from the rolap package | Generate a multistar object | Add fact tables | Add dimension tables | Relate dimensions | Additional operations on the multistar object | geomultistar query functions | dimensional_query() | select_fact() | select_dimension() | filter_dimension() | run_query() | Add geographic information | Define geographic dimensions and attributes | Run queries adding geographic information | Get wide tables | Conclusions

Introduction | American Community Survey 5-Year Estimates | An illustrative example | Obtaining the data | Data selection | Generation of results | acs_5yr_geo class format | rolap package objects | Conclusions

Introduction | Star databases and deployments | Star databases | Deployment | Contents of the constellation and the relational database | Another deployment | Incremental refresh | New data | Incremental refresh process | Incremental refresh result | Star database | First deployment | Second deployment | Checking star database copy synchronization | Conclusions

Introduction | Role-playing and role dimensions in a star database | Flat table with the initial data | Star schema | Star database | Star database with a role-playing dimension and role dimensions | Role-playing and role dimensions in a constellation | Second star database | Constellation | Conclusions

Introduction | Data and object creation | Data | Creation of objects of the satres class | Results obtained | Band selection | Get available bands | Select bands | Other transformation functions | Merge tiles | Clip bands | Conclusion

Introduction | An illustrative example | Getting the data | Merging and classifying data | Using the results | Conclusions

Introduction | An illustrative example | Pivot table | Obtaining a flat table | Transforming a set of pivot tables | Pivot table operations | Pivot table import | Operations that return an object | Operations that return a list of objects | Pivot table definition | Define pivot table characteristics | Remove rows and columns | Pivot table transformation | Transform labels | Transform values | Flat table generation | Generation from a pivot table | Generation from a list of pivot tables | Conclusions