I think the most important data visualization is “explore”. I believe that a great infographic will give the viewer the necessary data and background info for them to draw their own insights as well as encourage their intellectual curiosity about a subject. You will never be able to fit every piece of relevant data on one infographic. It should…[Read more]

I got the chance to hear about Mr.Olivera’s a few time previously through my SPO and I thought that having him talk about it with a data based focus was very interesting. What stood out the most to me was when he went over what data they look for on their site for different stages of their startup. I also thought when he spoke about looking…[Read more]

The New York Times article “Data Breaches Dent Singapore’s Image as a Tech Innovator” covers Singapore’s recent data breach where healthcare information for 1.5 million citizens were compromised. In the healthcare data that was compromised were the health r…[Read more]

A piece of conventional wisdom that I heard while working in manufacturing a few summers ago was that ” Long production runs are the most cost effective ways to produce products”. As opposed to doing shorter production runs that occur to match exactly what the customer orders. To test this I would gather and compare data from long production…[Read more]

The mos important takeaway from Data Analytics for me was learning both MySQL and getting an into to RStudio. Having a knowledge and the skill set to use different analysis tools has helped me in my ability to be able to transform and extract value from data. It shows employers that I have the ability to pick up on new technologies quickly and…[Read more]

A Thanksgiving-themed question clustering could be used to answer is ” What demographic of people naps for the longest period of time on Thanksgiving afternoon?”. The data needed for this cluster would be the length of naps from people on Thanksgiving day. You would also need their geographic location as well as their age and gender..

A business example for using a decision tree could be finding out what demographic is most likely to go on cruises for a travel agency so they no who to market to. They would want to collect data about a sample groups, age, income level, marital status, children, past cruising experience, and how often they vacation. For advice for selecting…[Read more]

A business question that could be answered with a data cube could be ” What is our most profitable product? :.The facts that could be measured would be unit variable cost, fixed cost, and selling price, as well as units sold.

In my internship at Crayola I noticed that they stored product number in two different ways. The first was the internal number in which the breakdown of the number gave insights on the product’s type, materials, and country of origin. They also stored it as an external version which was simply a random number assigned by a retailer. This…[Read more]

I thought this infographic on ideal temperatures for beverages was a really good example of data visualization. It easily displayed the relevant information without the need for words or complex diagrams and was also interesting to look at…[Read more]

A topic that I would really like to go over again is subselect for MySQL. as I feel like I would improve with more practice and explanation I would also like to go over cardinality for ERDs as I feel like that would best prepare me for the exam.

A join is often needed to retrieve information as it is common that data is connected through multiple tables. An example where you might need a join is at a doctors office when you want to connect a patient with an appointment in order to get their medical history in order to know what medicine they are currently on.

I think that the hardest parts for me are cardinality and attributes on relationships. Unless the cardinality is specifically stated in the project I find it hard to immediately grasp what it is and I tend to overthink it. I find it help to just think about it logically and use what I consider to be the most correct cardinality. I also find it…[Read more]

Over the summer I interned at Crayola in the Sales Department. One of the projects I worked on was analyzing order data from different types of retailers in order to gain further insight on the last two years trends in the market by segment . I looked at types and quantity of products ordered as well as time of year in relation to key seasons. I…[Read more]