-
Blake S Ford commented on the post, Bonus Marks: SAS Account Setup, on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
my username is tud16345
-
Blake S Ford commented on the post, Q&A: Week 6 (100 second reflection), on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
In week 6 we learned about dimensional modeling. We learned the differences between data marts and data cubes and how each are used to view data. A data warehouse is a database with all of the information in one […]
-
Blake S Ford commented on the post, Q&A : SQL Select, on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
1. SELECT COUNT(*) FROM HRdata.faculty, HRdata.department WHERE `Faculty.DepartmentID` = `Department.DepartmentID` AND Department Name = “Management Information Systems”
2. SELECT FirstName, LastName FROM […]
-
Blake S Ford commented on the post, Q&A: Week 5 (100 second reflection), on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
In week 5 we continued learning how to use My SQL. We learned new commands and how to use them. We focused on Add, Insert into, Delete, and Update. During class we spent a lot of time doing in class […]
-
Blake S Ford commented on the post, Q&A: Week 4 (100 second reflection), on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
During week four we mainly focused on learning the basics of My SQL Workbench. My SQL Workbench is used to find data by using unique queries. We were taught queries like; group by, select, where, from, and […]
-
Blake S Ford commented on the post, Q&A: Week 3 (100 second reflection), on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
In week 3 we learned about creating Entity Relationship Diagrams (ERD). Seeing these diagrams helped me understand the relationships between the entities, attributes, etc.. It was nice to see the diagrams in […]
-
Blake S Ford commented on the post, Q&A: Week 3 – MGM case, on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
A person is considered a “whale” by spending thousands to millions of dollars each time they step into the casino. This money has to be spent on table games and slots, not in the buffet. Regardless of how much […]
-
Blake S Ford commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Referential integrity is used to link tables together and maintain their relationships. The keys allow there to be a relationship between the various tables and the data included in each.
-
Blake S Ford commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
We covered the topic of Entity Relationship Management (ERD). We learned about the cardinal symbols for one to one relationships versus one to many relationships and what they are used for. These diagrams […]
-
Blake S Ford commented on the post, Q&A: Week 1 Inclass Exercise, on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Data is extremely valuable to companies like Facebook and LinkedIN. First off these sites attract many companies attention as a great place to advertise their products. Everything a person does on one of these […]
-
Blake S Ford commented on the post, Q&A: Week 1 (100 second reflection), on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
You need data to get information. There are two types of data; transactional and analytical. Transactional is data captured when generated, while analytical data is used for managerial decisions. The four […]
-
Blake S Ford commented on the post, ICE 5.1 Telling a Story through Visualization, on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Not necessarily, a team can win without star players. In baseball the main concern is getting on base and scoring runs. If you have a team of average or above average hitters your team could potentially be a […]
-
Blake S Ford commented on the post, ICE 5.1 Telling a Story through Visualization, on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
I know we touched on how grocery stores use data, but I did some more research on how they are achieving competitive advantage through the use of data. I took a look at Ukrop’s Super Markets. Through strategic […]