Sharepoint Info

Marimekko charts (or simply mekko charts) are essentially stacked charts that use two dimensions to display data. The heights of individual segments, as well as their widths, may be variable. The widths of individual columns are scaled, so that the combined widths of them completely fill the total chart area. Also, there is no gap between two consecutive columns, which lets users easily notice the differences in the thicknesses of the columns. The following are some of the most significant advantages that marketers can receive from Marimekko charts.

Observing Investment-Profit Relationships

Plotting the investments along one of the axes and profits along the other, marketers can observe how the two are related, and can also get the message across to the top-level management. This not only helps the management understand where they should invest more, but also pinpoint areas where the returns over investment are tapering off after a certain limit. What's even better is that these figures can be presented in the form of absolute values or percentages, depending on the type the top-level management is comfortable with.

Analyzing Market Penetration Rates of Competitors

Using a Marimekko chart, marketers can easily compare the market penetration rates of their company, and that of the competitors. A marketer can plot the market penetration rates of both companies along the same axis on the chart, and simply introduce a dotted line where the penetration rate of the competitor ends. That way, the top-level management can understand at a glance the areas that need additional budget allocation, or refined strategies in targeting prospective clients/customers.

Studying Hierarchical Data to Identify Profitable Market Segments 

This is where things get a bit tricky, but if this can be done properly, it can be the key to better profits and efficient usage of investments for a company. By studying which market segments show highest rate of adoption for products/services offered by the company, marketers can identify where to focus their resources for higher returns. When done right, this may help the company venture into new markets, or strengthen their hold over sectors where it is already present.

Bottom line – a Marimekko chart can help marketers analyze data and zone in on the exact bits necessary for making executive decisions. Building Marimekko charts with data in collaboration platforms like Microsoft SharePoint used to be a difficult task, since it involved a long and tedious coding process. Not any more. Now there are third party chart web parts available, which allow marketers to build a mekko chart with just a few clicks. Also, by using a SharePoint chart web part that lets users dig deep into business data, layer by layer, marketers can zero in on the exact bit of data that the top-level management needs, to make investment decisions.

Marimekko charts, or mekko charts, are excellent tools for marketers, who need to explain the reasons for profit/loss of a business to the management and perform focused marketing analysis to identify ways of improving profit margins. 

Resource Links:

https://www.think-cell.com/en/support/manual/mekko.shtml

http://www.mekkographics.com/market-analysis-toolkit/

http://www.mekkographics.com/mapping-the-financial-data-analysis-market-in-a-marimekko-chart/

It is important to master the art of chart creation to ensure that data visualization is efficient. Irrespective of how detailed a table or list on a spreadsheet is, it can be very difficult for you to find sufficient information among the columns and rows. The problem can be solved in SharePoint 2016 with smooth Microsoft Excel online connectivity. It allows users to directly create charts with the help of data that is stored in Microsoft Excel worksheets, along with an online part. There are also 3rd party tools to make data visualization very easy for users. Find out about some of the major charts that can be created to display the data.

Line charts:

There are simple line charts that can be easily created, and can be useful when users have to showcase changes in styles that occur over time.

Scroll charts:

For users, plotting a lot of data in only one chart is a significant dilemma. Scroll charts are available with built-in scroll bars and let users make the chart simply longer on either or both axes and let the data fit.

Column charts:

These are very effective for comparing of the worth of various items in a predefined value range, and the charts appear amazing on any type of display size. These can be beautified with shading and colors to make them more attentive for viewers. These charts can be utilized for revenue comparison between various divisions of an agency.

Bar charts:

Bar charts allow data comparison in multiple categories, and often come in sample graphics and user manuals. These are among the chart types that can be recognized most easily. These best work when over two categories are distributed to be displayed in only one chart.

Pie chart:

This is one of the earliest types of charts that most people are familiarized with, and you can use the pie chart for displaying data between various categories. The charts should ideally be used to showcase results from surveys, and these can offer fast an idea about the categories chosen by users.

Combination charts:

These charts bring together a wide variety of simple charts, and can be created when dissimilar and varied data sets need to be showcased on a single chart.

Bubble charts:

Professionals love these charts to deal with the visualization of data, while displaying the correlation between data sets. Bubble charts have an amazing appearance, whether they are showcased in 3D or 2D, and varied shades and colors are used to highlight them. How big the bubble should be actually depends on how strong the relation is between the data that is included, letting observers understand fast how strong the correlation between the various elements that are included is.

Funnel charts: