I am a IT student and now facing problem in understanding data warehousing. I need to implement a data warehouse that will be used in State police department for crime analysis. But I am not sure how to do with measure. I will use star schema. I want to set the business question from the view of Chief office , so I guess the measures should be No of crimes, No of offender and No of victims, and I am not sure.. May I know the fact table (measures).
I would start by writing down everything you know about crime. For example:Police, Detectives, Locations, CrimeType, Crime Instance etc.
Theses could be your tables.
Link the data in the tables to make it into a database. The data in the tables may be something like:
Location: Name, Address, Type, creationDate, user Crime: Name, Severity, Punishment, creationDate, user CrimeIntance: Crime, Location, Date, Detective, creationDate, user
etc, etc - use your imagination