Munir Mandviwalla

In week twelve, we discussed cluster analysis which is grouping data so that elements in a group will be different from elements in other groups. Or the elements in a group will be similar to another group. […]

True! Transactional Data changes all the time because every transaction there is data added. This transactional leads to a dimension of the data cube.

Data warehouse is used for analyzing data. It is helpful for storing historical and recent data, which then is useful for writing reports for annual comparisons. A data mart appears as a layer included in the […]

True because data cubes seem to be more reliable than transactional data. I may be wrong, but aren’t data cubes created from transactional data? This means that converting transactional data into data cubes […]

Week nine was great to learn about how we can use extensive amount of data, and give it meaningful use by doing predictive and descriptive data mining. SAS is an application that assist with data mining by […]

In week ten, we learned about classifications and decision trees. This topic reminded me of the ERD Diagram concept. Decision trees are a model that predict of cases of a dependent variable based on one or more […]

In week nine, we learned about data mining the evolution of data analytics. The two methods that deal with data mining/analytics is prediction and description methods. These methods help assist employees and […]

username: bwarech

I think that the ETL process is very valuable and can come useful in many situations. There are many many times that databases have differences in them, and using prompts like CONCATENATE you are able to change […]

In week seven, our class focused on the concept, Extract Transform Load. This refers to the process in database usage and in data warehousing, which involves extracting data from outside sources and transforming […]

In week six, we learned about transferring data into dimensional modeling, such as Data Marts and Data Cubes. This helps with managers/employees who aren’t familiar with softwares like MySQL Workbench to retrieve […]

For week five, we continued learning about MySQL Workbench’s techniques such as creating and editing tables, retrieving data, and deleting that data. By creating and editing tables, we needed to add or delete […]

In week four, we learned about MySql Workbench which helps organize data into a database system. Not only collects, but it makes it easier for someone to retrieve the data as well. In MySQL Workbench, data is […]

In week four, we learned about MySql Workbench which helps organize data into a database system. Not only collects, but it makes it easier for someone to retrieve the data as well. In MySQL Workbench, data is […]

This week I learned how to manipulate SQL Queries to find specific information about data, from SELECT, COUNT, ORDER BY and more. This information is very valuable because when you are working with a database with […]