Hima Gharat

The most important takeaway from this class was understanding where data comes and how it can be organized to be easily understood. The process of how data is transformed, stored, and relayed is important because it creates a foundation for further applications of data usage. I would explain to a future employer that I have background in SQL and…[Read more]

A Thanksgiving question that can be answered by clustering is what kind of pies do different age groups prefer. The data collected could different types of pies typically eaten during Thanksgiving (pecan, pumpkin etc). The data can be clustered by age group (for example: people ages 10-15 prefer pumpkin pie) and this data can be used by companies…[Read more]

A business question that can be answered using a decision tree is whether or not an insurance carrier should write coverage for a workers compensation risk for a potential client. The insurer should look into past injuries in the workplace, the nature of the client’s business (for example: if it is a construction company, it is riskier to write…[Read more]

A business question that can be answered using a decision tree is whether an insurance carrier should write a workers compensation risk for a potential client. The insurer should take into consideration previous losses the client has faced in regards to work place injury, the nature of the business the client is involved in, and safety measures…[Read more]

A business question that could be answered by a data cube is: Which make up brand is the most popular brand at Sephora. The dimensions would be the brand and the number of units sold. The Measurable fact would be the revenue made by each brand.

One way data can be stored differently can be seen when looking at phone numbers. Some data bases can store phone numbers as 123-456-7890, while others can store them as 1234567890.

https://www.greenandvibrant.com/sites/default/files/inline-images/hydroponic-gardening-infographic.png

This is a good example of a visual because it is easy to ready and makes the pint clear. It does not distort facts nor is it misleading. I appreciated how simple this graphic is and how the illustrations are visually pleasing but not confusing.

I would like to go over the cardinalities of ERDs and when an attribute is associated with a relationship, rather than an entity.

An example of when a join could be used can occur in a large company with many different departments and a large number of employees. A join can be created between departments and employees to show which specific employees work in a certain department,

The trickiest part of creating ERDs is paying attention to the cardinalities. It is important to look at the relationship between two entities and follow the wording of the prompt carefully, It is also tricky to figure out whether an attribute belongs with an entity or if it is related to a relationship.

At my first internship, I worked with urgent cares in our hospital network. I collected patient data from the urgent cares and used it to see how often patients were visiting urgent cares and for what ailments. If patients were visiting urgent cares more than the recommended amount, I would reach out to their primary care physicians to ensure the…[Read more]