Wednesday, February 23, 2011
Website Analytics Part Two: Browser vs Resolution Size
This Excel PivotTable represents slightly differing data than the previous comparison. This is a comparison of the varying Internet Browsers and their respective resolution size. The first thing that may be noticed is there are a lot of resolutions that are not listed, such as 1024x600, 1152x648, 1280x720, 1280x800, and 1600x900 being some of the unlisted resolution sizes. This may be due to incompatibility issues with the analytics program that gathered the data, or a multitude of other reasons that caused complications. The unknowns have been removed from the set displayed. The resolution size used by the visitors to a website is incredibly helpful when the web designer is attempting to determine how he should manage his site with regards who to cater to. From a quick glance at the chart, it is obvious that the web site should be compatible with Internet Explorer, Firefox, Chrome, and Safari, as these are the predominant browsers used. In addition, with regards to various sizing issues that may be encountered, the site should be tailored specifically towards the resolution sizes of 1280x1024 and 1024x768 as these are the most common. When confirming that your site is user-friendly and easy to navigate, these various browsers and resolution sizes should be the web designer's first priority when manipulating advertising space, adding gadgets, or adjusting banners, headers, footers, and sidebars. This will help the web designer cater to the majority of his consumers.
Website Analytics Part One: Operating System versus Browser
This is an Excel PivotTable that displays information taken from the analytics page of a website during a one month range. This has especially been filtered to only display Operating System vs. the Browser used. This gives an idea of the dominance of which browsers people are utilizing based on their operating system. From here, I'll break down each row individually in order to explain the acronyms used throughout. Operating systems are represented in the first column on the left.
First, we have the iOS, which is short for the iPhone OS. This operating system is used predominantly on iPhones and other Apple products, such as the iPad, iPod touch and the Apple TV. It is my belief that the data range that this information was taken from did not include mobile products, so it can be safely assumed that these only represent iPad visits to the site. As can be clearly seen by all 250 users of this OS, the only browser that users operating iOS utilize is Safari, which is Apple's default browser. This stands to reason as the iOS is more than likely incapable of utilizing any other browser.
The second OS down the list is Linux. Invented by a Finnish university student in 1991 and maintained since then through an open-source community, this has become the OS of choice for consumers believing in open source. As I currently have a desktop computer that runs Ubuntu(a linux derivative), it stands to reason that there are 79 out of 105 users from this OS that run Firefox, as it is included with Linux installs since it is also open-source. Installing the Chrome Browser is an option for those Linux users who tend to prefer the interface provided by it, which is why there are 26 users utilizing the Chrome browser on the Linux OS.
The third OS on the list is the Mac OS X, which is a unix-based graphical operating system that now acts as Macintosh's primary operating system. There is a little more diversity here than the iOS was allowed, as along with the Safari(Apples browser) browser, there are also users who use Firefox and Chrome. Safari is the most popular browser for this OS as it tops the chart with 64% of users, while Firefox comes in second with 23%, and Chrome receives the remaining 13% of users. Safari is included with the Mac OS X operating system, so it seems logical that it would be the dominant browser here.
The remainder of the Operating Systems are varying releases of Windows, and as such, I'll lump them into one category for simplification purposes. Out of the data presented, this is the first time we have seen the IE(Internet Explorer) browser with any representation. This is appropriate, as the IE browser is included with all Windows releases. The users on the Windows platform using IE is represented by 58% of users. The free, open-source browser Firefox browser comes in a distant second for this OS, with 26% of users utilizing Firefox. Google's Chrome comes in third with 15% of users. It may be noticed that there are a marginal number of Windows users who are using the Safari browser. It seems that Apple may have wasted their time by making Safari cross-compatible with the Windows platform, as a mere (1%) 76 out of 7114 users in this dataset are taking advantage of the ability to use the Safari browser.
Overall, from the data gathered from this website's visit data, which sells products that are compatible on any platform, the totals can be compared to estimate a few ideas for the percentage of the public using certain browsers. Windows seems to be the dominant operating system, with their included browser Internet Explorer topping the charts holding 46% of all users. Firefox comes in at second, with it's price(free) and compatibility with all operating systems allowing it a certain edge. Chrome holds a slight edge over Safari, only because of the number of users on the Windows platform outranking the Mac users. While there are certainly a plethora of other operating systems and browsers that have been excluded(either through lack of ability in gathering the information or after the fact in order to simply the analysis), there seems to be enough data here to substantiate the few claims that have been presented.
Wednesday, February 16, 2011
Data Assignment #1 --- Original post
This was the Motionmap comparing DaimlerChrysler, Toyota, GM, and Ford from 2005-2010.
Wednesday, February 9, 2011
MIS 385 Spring 2011
Motion Map Chart -- Our first Data Assignment was to create a MotionMap using information.
This is a chart representing data from Ford Motor and General Motors from 1996 until 2010. It includes data taken from CNN's Fortune 500 Listings, including Employees, Revenues, Profits, Assets, U.S. Fortune 500 Ranking, and Stockholder's Equity.
Source: CNN's Fortune 500
There are quite a few trends that can be witnessed from the various options displayed in this motion map. First let's take a look at the Line chart with Employees as the Y axis. This immediately displays that GM has been firing employees since 1994... In 1994, they had over 650, 000 employees...and now in 2010, they are at the 200,000 mark. As for Ford, they were at about 350,000 employees and kept that number steady until approximately 2006 when they also started to drastically reduce their number of employees.
Using the bubble motion chart option, with Revenue on the X axis, and Profits on the Y axis, it can be seen that it wasn't until 2002 that Ford experienced their first negative profits. Infact, it can be judged that based on the random variations of the bubble movements that Revenues and Profits are in no way correlated for Ford, as it is seemingly random. However, if you change the X axis to Assets, and keeping Profits on the Y axis, and looking at GM, it can be noticed that generally until 2005, GM was remaining profitable while assets were growing, all the way up to $479 billion in assets in 2005. It was in 2006 that GM realized a loss of $10.6 billion, possibly causing them to sell off assets(reducing to $186 billion in 2007). However, things didn't seem to get any better for GM, experiencing a loss of $38.7 billion in 2008. Continuing to reduce their assets in 2009, and experiencing another loss of $30.9 billion, this is approximately the time that the U.S. government bailed GM out. "On June 8, 2009, GM was reorganizing by bankrupty protection under the provisions of Chapter 11, Title 11, United States Code." (Source: Wikipedia ) In 2010, the chart shows that profits for GM go back to 0, however, this is slightly due to a lack of projecting any profits at all, as the company was reformed and profit numbers were skewed due to Net income not being included because it emerged from bankrupty, which apparently included forgiveness of debt, and that distorted results. ( Source: Fortune 500)
This is a chart representing data from Ford Motor and General Motors from 1996 until 2010. It includes data taken from CNN's Fortune 500 Listings, including Employees, Revenues, Profits, Assets, U.S. Fortune 500 Ranking, and Stockholder's Equity.
Source: CNN's Fortune 500
There are quite a few trends that can be witnessed from the various options displayed in this motion map. First let's take a look at the Line chart with Employees as the Y axis. This immediately displays that GM has been firing employees since 1994... In 1994, they had over 650, 000 employees...and now in 2010, they are at the 200,000 mark. As for Ford, they were at about 350,000 employees and kept that number steady until approximately 2006 when they also started to drastically reduce their number of employees.
Using the bubble motion chart option, with Revenue on the X axis, and Profits on the Y axis, it can be seen that it wasn't until 2002 that Ford experienced their first negative profits. Infact, it can be judged that based on the random variations of the bubble movements that Revenues and Profits are in no way correlated for Ford, as it is seemingly random. However, if you change the X axis to Assets, and keeping Profits on the Y axis, and looking at GM, it can be noticed that generally until 2005, GM was remaining profitable while assets were growing, all the way up to $479 billion in assets in 2005. It was in 2006 that GM realized a loss of $10.6 billion, possibly causing them to sell off assets(reducing to $186 billion in 2007). However, things didn't seem to get any better for GM, experiencing a loss of $38.7 billion in 2008. Continuing to reduce their assets in 2009, and experiencing another loss of $30.9 billion, this is approximately the time that the U.S. government bailed GM out. "On June 8, 2009, GM was reorganizing by bankrupty protection under the provisions of Chapter 11, Title 11, United States Code." (Source: Wikipedia ) In 2010, the chart shows that profits for GM go back to 0, however, this is slightly due to a lack of projecting any profits at all, as the company was reformed and profit numbers were skewed due to Net income not being included because it emerged from bankrupty, which apparently included forgiveness of debt, and that distorted results. ( Source: Fortune 500)
Subscribe to:
Posts (Atom)