Megan Rolfes

Cigna held a two-day orientation at the headquarters in Connecticut for all interns, which was jam-packed with information and allowed us to start at our home offices feeling confident and prepared. Beyond that, there have been multiple training sessions for interns to attend together and we usually have to call in through WebEx from conference…[Read more]

Hi everyone! This summer I will be interning in Center City Philadelphia at Cigna. My internship is within the Technology Early Career Development Program (TECDP) and I will be working as a Production Support Systems Analyst in Group IT. In this role, I will be learning how to utilize various applications by understanding their different access…[Read more]

For me, the most important takeaways from this course were the technical skills I learned with using MySQL, R, and Excel, and also just gaining a better understanding of how you can look at a business’ data in various ways. I would explain to an employer that I can take what I’ve learned from this class, like clustering, decision trees,…[Read more]

A Thanksgiving question that can be answered using clustering is how many seats a family might need to have for the infamous “kids table”. In my family, all of our cousins and relatives usually get together for Thanksgiving, and the younger cousins tend to be at a separate table from the older cousins and adults. The data gathered would include…[Read more]

Decision trees could be used by any business that is taking on a new project. In making the decision about whether or not to accept the project, I would observe things like the cost of the project, its length, the amount of employees needed to work on it, etc. Collecting this data allows the business to determine if the project is a worthy…[Read more]

You might use a data cube to organize information for a singer/performer going on tour. Dimensions could include the different venues where they will perform, the time period/date of the concert, and location. The measured fact would be the number of tickets sold and would allow the artist to figure out how big their fan base is in different places.

An example of data that could be stored in two different formats could be student grades. One data source might represent a student’s grade in a class using the letter grade, while another source might use the specific number grade. For example, while one database would show a student’s grade as 95, the other would show it as an A. I would…[Read more]

Guide To Beating Insomnia

I think this infographic about how to beat insomnia does a great job presenting data in a concise way. It first explains what insomnia is and provides key stats, accompanying this information with clear visuals. Data is presented in a logical order, providing a list of symptoms after the initial…[Read more]

I would like to go over cardinality in ERDs, especially determining the min/max cardinality when it isn’t specifically stated in the problem statement.

I would like to go over cardinality in ERDs, especially determining the min/max cardinality when it isn’t specifically said in the problem statement.

A scenario where a join could be used is if you like a specific author and are looking to read a new book by them. You would have book in one table with a primary key of Book_ID and info like the genre, length, etc. Author would be in another table with a primary key of Author_ID and containing info like first name and last name. You can join…[Read more]

Personally, I find the most difficult aspect of ERDs to be cardinality. After narrowing down which nouns in the problem statement are relevant, assigning attributes to these entities and determining the relationships is fairly simple. Cardinality is especially tricky though because you have to understand the maximum and minimum number of times…[Read more]