Angad Singh AOIT Internship Summer 2016

Date: 8/26/17 Activities: Wrapping up loose ends Technical Information: OpenDataSoft, Naviline, MS Outlook The last day of work was both interesting and sad. We didn't have much to do since our data stories were done and we couldn't start anything new because it was our last day. I've grown attached to this place and I will miss it a lot once school starts. A lot of the day was spent talking to a lot of the employees there that we might not see again. We entered in our final hours in Naviline and sent our final report in Outlook. This internship was truly all I could ask for. I learned so many things in the ten weeks I was at Cary, both technical and soft skills. I would never have learned how to use programs like SAS VA had I worked somewhere else. The interpersonal skills that I learned were what I felt were the most valuable thing I took from this experience. The data stories group project was an entirely different animal than the group projects in school. Going...

Date: 8/22/16 Activities: Finalizing data stories, meetings Technical Information: OpenDataSoft, HTML I've finally reached the final week of my internship. At this point, all of our data stories are final. We've had a few final meetings with some of the employees to make sure that everything looks good. It's very satisfying to see our completed work after weeks of hard work. As we finish our stories, the other interns are wrapping up their own work. They've installed hundreds of new phones throughout the Town of Cary buildings. Most of my frustration came with compatibility issues with SAS VA. I worked very hard to learn how to use the software and make many graphs to represent the raw data that I was given. First there were numerous problems with getting the queries to work properly. It took an entire week of editing to make it work. All of that work was basically wasted when I found out that I could not use my graphs for the data stories.

Date: 8/17/16 Activities: Working with our boss and PR to finalize our data stories Technical Information: OpenDataSoft, HTML The editing and revising process is still ongoing. This is taking significantly longer than I had initially expected. Its hard to get it all done because when we change something, something else gets messed up. For the most part, the graphs are done, we just need to finalize the colors. The main thing we're still working on is how we're going to divide up the different sections in the most logical manner possible. I learned that I like to work in small groups rather than by myself. It keeps me motivated and it's simply more fun to collaborate. It would be better to have a little more space; currently all of the interns are in one huge cubicle. It can be quite distracting being so close to everyone. I've also learned that I would like a job where there's a little bit of everything. I've been mostly working on the same thing the wh...

Date: 8/9/16 Activities: Continuing the Data Stories Technical Information: OpendataSoft, HTML Our open data story project started off relatively small, but it has continually grown the past month. We used to only have one story; now we have nine. With this dramatic increase in the number of stories, we are working harder than ever. We spend a lot of time in the quiet break room brainstorming and perfecting our work. We will have a meeting with the PR people soon to discuss our stories and how they will roll it out. Heading into this internship, I wasn't very sure as to what I wanted to study in college. However, this experience has had a great influence on that. I have started looking at doing something like statistics as a degree. Working with data is something that I really enjoy and I didn't really know that before this summer.

Date: 7/29/16 Activities: Introduction to Sales Force Technical Information: Sales Force, Town of Cary FAQ page A few days ago, Jack, Poorna and I were introduced to the business platform known as Sales Force. This platform has a wide variety of uses, but its primary focus is communicating with customers. Jack just left for a one week vacation; as a result, we have taken a break from the data stories. We spent the entire day revamping the FAQ section of the ToC website; this is the area of work that Zoe, Sydney and Mary Beth deal with. It was nice to have a break from the work I'd been doing for the last few weeks. My duties and role has certainly expanded since I started. I'm now working on multiple different projects at the same time. Before I only worked on my own things, but I've recently worked with a lot of the other interns. Nowadays, it feels like we have more responsibility because we have been under less supervision than before.

Date: 7/22/16 Activities: Written Component, visit to fire department Technical Information: OpenDataSoft, SAS VA Work on the data stories continues. We have received plenty of feedback and we are in the process of making the necessary changes. It also appears that this project will be bigger than we initially expected; we will be making multiple data stories. Today, Wilson, Jack and I went on a visit to the fire department and meet Fire Chief Kane. It was interesting to receive a request from another department to do work in a program that I had just learned. Unfortunately, Jack was given the task and I was given full responsibility of the Parks and Rec data. My main contribution has been creating the different visualizations for the open data story. We've put a lot of work into it and I'm really excited that my work will make its way on to the official Town of Cary website.

Date: 7/11/16 Activities: Graph creation, written component Technical Information: OpenDataSoft, SAS VA We have made significant progress on our first data story. Our primary focus is age groups and attendance in different Cary facilities. Unfortunately, we are unable to use VA graphs on our webpage, so we now have to work exclusively with OpenDataSoft. As we finish up creating the graphs, the three of us have started work on writing the written component to go along with the graphs. So far, all of my expectations have been met. The hours are very reasonable and the work is quite interesting and different. As this is my very first working experience, the interactions with my fellow interns has been quite fun.

Date: 7/4/16 Activities: Graph Creation Technical Information: OpenDataSoft, SAS VA At this point, I have watched enough tutorial SAS VA videos to be able to perform the basics of the program. A lot of today has been spent on messing around with the raw data from the Parks and Rec department. Jack and I created several graphs do gain a better idea of which graphs are best for which task. We have been tasked with our main project for the summer; we will create Data Stories for the Town of Cary website. Basically, we will interpret several different data sets and create both visual and written components for the consumption of the citizens. We will use OpenDataSoft to create HTML visualizations. My past experiences with computers both in and out of the classroom have served me well so far. My certification in MS Outlook made the transition to my new email client very smooth. Some of my SAS programming knowledge also came in handy when understanding the SAS VA software. The main ...

Date: 6/24/16 Activities: SAS VA videos Technical Information: SAS VA, MS Outlook Reflection: So far, the two main programs/software I've been dealing with is SAS Visual Analytics and Microsoft Outlook. Outlook is our email client, and I use it everyday to communicate with my boss and coworkers. SAS VA is very exciting for me because I have never used it before. It allows the user to upload an incredible amount of data and create a wide variety of charts and other visualizations. For now, I am watching a lot of tutorial videos to learn how to use the program. The atmosphere here at Cary is quite relaxed; everyone is very nice in there is plenty of cooperation, with some friendly competition sprinkled in. We all dress buisness casual, but it's fine to wear the occasional t-shirt on Fridays. Despite the relaxed atmosphere, everyone works very hard to complete all of their daily tasks.

Date: 6/13/16 Activities: Tour of Cary Technical Information: Naviline     Today was my first day as a Technology Services Data Analyst. I will work for the Town of Cary Technology Services department.Their job is to provide the citizens of Cary (its customers) with phone lines, tech support, the internet, and other technology services. My primary job will be to analyze the department's data and interpret it into visual representations. My goal is to help improve the Town's operations. There are six other interns with me here: Jack C, Poorna, Sydney, Zoe, Mary Beth, and Jack R. Jack C and Poorna are the other two Technology Services Data Analysts that I will work more closely with.     This day was more about getting familiar with our surroundings. We were taken on a full tour of the office and Cary; we also met the employees that we would be working with on a regular basis.