Important rules of aggregation:

Dimension is text

Measures are numbers

For dimension we list unique values

For Measures we summarize the data

Level of Detaling is understanding



Comments

Post a Comment

Popular posts from this blog

Business Intelligence? RawData Collect the RawData Analyse the RawData Tranfoming it into information Information gives Knowledge Knowledge provides to Make decision Descison making leads to Profits/money
Read more

Visual Analytics

Visual analytics is useful in anlysing trends Visual analysisation we can also create. what are the visualizations we can create? many visualizations like scatter,histogram. There are three categories of datas where data falls Nominal-it cannott be compared ordinal-it be order,can compare ratio-compare,difference between,ratio data Nominal data examples: names of employee(name cannot be compared) ordinal data can be put in order...rating of employee(high,low)  ratio data : age of salary, salary of employee, ie first getting twice salary of second employee data should be categorised in that way. if student data is given ,identify it student id rank 1009          2 1008          8 1007         10 it is ordinal data department name of particluar company..it is nominal data. Based on the data given, create visualizations Scatter plot is used to relation between two sets of data. lets co...
Read more

Mysql

MySql: You deal with data every day… When you want to listen to your favorite songs, you open your playlist from your smartphone. In this case, the playlist is a database. When you take a photo and upload it to your account on a social network like Facebook, your photo gallery is a database. When you browse an e-commerce website to buy shoes, clothes, etc., you use the shopping cart database. Databases are everywhere. So what is a database?  By definition, a database is merely a structured collection of data. The data relate to each other by nature, e.g., a product belonged to a product category and associated with multiple tags. Therefore, we use the term  relational database . In the relational database, we model data like products, categories, tags, etc., using tables. A table contains columns and rows. It is like a spreadsheet. A table may relate to another table using a relationship, e.g., one-to-one and one-to-many relationships. Because we deal with ...
Read more