Jhansi Rani Kunaparaju

 3)Load weather. nominal, Iris, Glass datasets into Weka and run Apriori Algorithm with different support and confidence values. Loading WEATHER.NOMINAL dataset 1. Select WEATHER.NOMINAL dataset from the available datasets in the  preprocessing tab. 2. Apply Apriori algorithm by selecting it from the Associate tab and click start 3. The Associator output displays the following result. === Run information === Scheme: weka.associations.Apriori -N 10 -T 0 -C 0.9 -D 0.05 -U 1.0 -M 0.1 -S -1.0 -c -1 Relation: weather.symbolic Instances: 14 Attributes: 5  outlook  temperature  humidity  windy  play === Associator model (full training set) === Apriori ======= Minimum support: 0.15 (2 instances) Minimum metric <confidence>: 0.9 Number of cycles performed: 17 Generated sets of large itemsets: Size of set of large itemsets L(1): 12 Size of set of large itemsets L(2): 47 Size of set of large itemsets L(3): 39 Size of set of large itemsets L(4): 6 Best rule...

 Exp 2: 3). Write ETL scripts and implement using data warehouse tools ETL is the most important process in SSIS tool. ETL is used to Extract, Transform, and Load the data into a data warehouse. ETL is a process responsible for pulling out the data multiple data sources, transforming the data into useful data, and then storing the data into a data warehouse. The data can be in any format xml file, flat file, or any database file. It also ensures that the data stored in the data warehouse is relevant, accurate, high quality, and useful to the business users. It can be easily accessed so that the data warehouse can be used effectively and efficiently. It also helps the organization to make data-driven decisions by retrieving the structured and unstructured data from multiple data sources. ETL diagram  //Click on the link and draw the diagram from the link// 4. Perform Various OLAP operations such as slice,dice, roll up, drill up and pivot  OLAP OPERATIONS:  OLAP having...

  1.experiment 2 . Design multi-dimensional data models namely Star, Snowflake and Fact Constellation schemas forany one enterprise (ex. Banking, Insurance, Finance, Healthcare, manufacturing, Automobiles, sales etc). What is Schema?  Schema is a logical description of the entire database. Star Schema:  A star schema is the elementary form of a dimensional model, in which data are organized into facts and dimensions .  This dimension table contains the set of attributes. The following diagram shows the sales data of a company with respect to the four dimensions, namely time, item, branch, and location .  There is a fact table at the center. It contains the keys to each of four dimensions .  Snowflake Schema:  Some dimension tables in the Snowflake schema are normalized.  The normalization splits up the data into additional tables.  Fact Constellation Schema:  A Fact constellation means two or more fact tables sharing one or more dim...