-
Dominic C. Perilli wrote a new post, Flash Research Paper – Data Centers & Networking – Mart Doyle, on the site Dominic C. Perilli 3 months, 1 week ago
Currently, our Tier I data system is costing the company $25.6 million per year in downtime. I recommend implementing a Tier III system, which will reduce this cost by 94% per year by limiting the effect of […]
-
-
Dominic C. Perilli wrote a new post, E-Portfolio Extra Credit Assignment, on the site Dominic C. Perilli 1 year ago
Klout (klout.com) is a new type of social media analytics being used to measure the influence level of individuals using Twitter, Facebook, etc. Klout measures influence by gauging the public’s reaction to a […]
-
Dominic C. Perilli commented on the post, Extra Point to The Final Exam, on the site DATA ANALYTICS 1 year, 1 month ago
Dominic Perilli
-
Dominic C. Perilli commented on the post, W12 Discussion Questions, on the site DATA ANALYTICS 1 year, 1 month ago
2. SpotCrime.com is an example of OLAP analysis. This is because information is classified by the Address, Time, and Type dimensions and presented visually on a map. There is an online central server that […]
-
Dominic C. Perilli commented on the post, W11 Discussion Questions, on the site DATA ANALYTICS 1 year, 1 month ago
Clustering allows the manager to take a broad perspective of customers using clusters, or pools of data. Customers are grouped into clusters by household income, interests, etc. If a manager wants to research the […]
-
Dominic C. Perilli commented on the post, W9 Discussion Questions, on the site DATA ANALYTICS 1 year, 1 month ago
Data Mining is the extraction of information to discover patterns and other trends in the data set. Data Mining does not analyze business statistics such as company profitability, sales margins, etc.
-
Dominic C. Perilli commented on the post, W8 Discussion Questions, on the site DATA ANALYTICS 1 year, 2 months ago
1)
Extract, Transform, Load (ETL) is the process of copying data from the transactional database to the analytical database. In other words, it’s the movement of data from the relational database to the […]
-
Dominic C. Perilli commented on the post, W6 Discussion Questions, on the site DATA ANALYTICS 1 year, 2 months ago
ALTER is a DDL statement and it allows you to make changes to a whole database or a table. You would use ALTER when you want to add a new column into a table or a new table into a database.
INSERT is a DML […]
-
Dominic C. Perilli commented on the post, W5 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
You can split SQL into two parts:
Data Manipulation Language (DML) – update date using commands like DELETE, UPDATE, and SELECT. This allows you to edit specific data.
Data Definition Language (DDL) – allows […]
-
Dominic C. Perilli commented on the post, W4 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
ERD is used to make models for SQL, which is called backward engineering. When you use SQL to create the code for ERD, it is called forward engineering.
-
Dominic C. Perilli commented on the post, W4 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
ERD is the basic modeling for the SQL. Once the ERD Model is created, it can be inputted into the SQL server. From the server, a user can query certain types of information that will be extracted from the ERD model.
-
Dominic C. Perilli changed their profile picture 1 year, 3 months ago
-
Dominic C. Perilli commented on the post, W2 Discussion Questions, on the site DATA ANALYTICS 1 year, 3 months ago
Requirements are the pieces of information that allow us to create an accurate model. It’s important to gather the correct requirements so that the model will perform exactly that task that it’s meant to be built […]
-
Dominic C. Perilli commented on the post, In-class Exercise #1: Gathering Requirements 1/23, on the site DATA ANALYTICS 1 year, 3 months ago
Dominic Perilli, Ken Brown, Steve Ferraiolo
1. Age
2. Gender
3. Relationship Status
4. Location
5. Horoscopes
6. Hobbies
7. Favorite music
8. Favorite movies
9. User likes to take/post many […] -
Dominic C. Perilli commented on the post, W1 Discussion Questions, on the site DATA ANALYTICS 1 year, 4 months ago
Transactional data is real-time, raw data that is being recorded with the intent to convert to Analytical data. Certain companies use trend analysis to forecast sales approaches or marketing schemes. The type of […]
CONNECT