Week 5 Blog: K Means Clusters

This week, we focused specifically on reviewing some of the key procedures SAS offers for business statistics and data grouping such as Proc means, Proc freq, Prod univariate, Proc standardize, and Proc Fastclust, and of course, we continued our review of macros and passing variables through these functions to allow for faster variable analysis and processing.

There were 2 aspects of this week’s lesson I found most interesting…and challenging as well: 1. -Standardizing data (moving all the quantitative data to the same scale i.e. mean=0 and stand dev = 1. This concept was somewhat of a continuation of our project from week 2 where we analyzed stock price valuations based on a standardized scale. This step was necessary to produce clusters of data on the same scale. Then, after performing descriptive statistics on the standardized variables, we needed to unstandardized the data to make the numbers make sense from a business standpoint. 2 – creating clusters. Creating clusters using K-means was a brand new concept to me, but the methodology was fascinating – The computer picks random data points for the observations and begins to categorize the data in each bucket (K). The program then takes the average of each cluster and re-runs the program until all data is correctly categorized into their respective clusters.

Visualizing the k means clustering using the tasks mentioned above combined with proc SG plot, provided a clear depiction of the groups created by the program, and allows the analyst to see the natural groupings of the observations within the variables under consideration. I can see the value of performing K Means clustering in a variety of scenarios / industries. For example, K Means clustering could be used to credit fraud and cyber security attacks, but grouping data with similar characteristics and detecting outliers. This week’s lesson carried a lot of value and I’m sure we’ll continue to re-visit this concept of categorization and clustering throughout the class.

Week 4 Blog: Macros

This week, our focus was on building macros in SAS. I’m relatively familiar with building and structuring macros because of my prior experience with Excel VBA. Seeing how this same operation works in SAS was very enlightening – to me, it was very similar to building functions as opposed to building modules: building out the code first, and then wrapping the code in a macro and passing different variables through the variable fields specified. Building these macros into our assignment with several similar data sets to our first assignment drastically increase the efficiency and ease of summarizing various fields rather than manually building out new code for every new variable.

I think one of the core concepts here that pertains not just to building out code blocks, but especially formulating macros, is to get the code working first, because debugging macros (especially in SAS) is extremely difficult. Once the code is working appropriately, it’s easy to pass in the variables to automate your process. That’s probably the biggest take away from week 4’s lesson for me: build out small chunks of code first, get it working, then wrap it in a macro to automate it. As far as building macros in SAS, it’s my understanding that this skill set is not very prevalent in most industries, yet, it is very in demand as demonstrated by our last assignment which was to identify jobs in the market looking for SAS macro skills. I enjoyed learning the value of this skillset through this assignment and realized the tremendous value it can provide when used effectively.

Analytics Blog Week 2

This week, we really dove into SAS and experimented with its different capabilities such as proc import, proc export, proc means, data steps, lib names, correlations, plots, and more. Our first assignment introduced the Lag function, which comes in handy when looking at past records with respect to the current record you are on. In this assignment we took a look at the golden cross trading strategy and analyzed AAPL’s buy and hold strategy vs the golden cross strategy, reported the returns, and concluded which strategy was better with the small sample size. The lag function was invaluable because of its simplicity and practical use.

The next assignment was focused on portfolio analysis, and understanding risk as it relates to returns using the Sharpe Ratio and taking daily returns and risk measures and extrapolating them out. The Merge function was several times to pull in select data from from various sources and combine into one data set based on a common field. The most valuable piece of this assignment was learning to standardize data values, as this will likely be used over and over again in data analysis and throughout this course. By moving the values to a base of 1, we were able to perform weighted portfolio analysis and determine optimal investment weightings using proc means and correlation techniques.

My First Blog Post

Wake Forest Analytics Program

Week 1

It’s only been a few days since I’ve started the analytics program at Wake, but we have reviewed several key concepts that are essential to understanding the data analysis process; While I have some experience in analytics I think the following process cannot be over-reviewed or over-emphasized:

We reviewed the value of each step at a high level and talked through the importance of being able to communicate the final results to stakeholder. Leveraging this process takes time and practice, and only through time and dedications, can analytics practitioners harness the true power of the process. Each step has tremendous value and are never mastered due to the complexity and variety of analysis.

Software: We will be starting off using SAS, which I have limited experience with, but am intrigued with it’s power and versatility. When moving past spreadsheet analysis and simple data investigations, learning to program in SAS, R, or Python becomes a necessity.

-MH

This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.

Introduce Yourself (Example Post)

This is an example post, originally published as part of Blogging University. Enroll in one of our ten programs, and start your blog right.

You’re going to publish a post today. Don’t worry about how your blog looks. Don’t worry if you haven’t given it a name yet, or you’re feeling overwhelmed. Just click the “New Post” button, and tell us why you’re here.

Why do this?

  • Because it gives new readers context. What are you about? Why should they read your blog?
  • Because it will help you focus you own ideas about your blog and what you’d like to do with it.

The post can be short or long, a personal intro to your life or a bloggy mission statement, a manifesto for the future or a simple outline of your the types of things you hope to publish.

To help you get started, here are a few questions:

  • Why are you blogging publicly, rather than keeping a personal journal?
  • What topics do you think you’ll write about?
  • Who would you love to connect with via your blog?
  • If you blog successfully throughout the next year, what would you hope to have accomplished?

You’re not locked into any of this; one of the wonderful things about blogs is how they constantly evolve as we learn, grow, and interact with one another — but it’s good to know where and why you started, and articulating your goals may just give you a few other post ideas.

Can’t think how to get started? Just write the first thing that pops into your head. Anne Lamott, author of a book on writing we love, says that you need to give yourself permission to write a “crappy first draft”. Anne makes a great point — just start writing, and worry about editing it later.

When you’re ready to publish, give your post three to five tags that describe your blog’s focus — writing, photography, fiction, parenting, food, cars, movies, sports, whatever. These tags will help others who care about your topics find you in the Reader. Make sure one of the tags is “zerotohero,” so other new bloggers can find you, too.

Create your own website, free on WordPress.com.Create your own website.
Start free