Movies with LGBT – Data visualization of LGBT movies

admin

Data Source : http://www.the-numbers.com/

All the movies under the keyword=LGBT are used in the analysis below.

Image

[click for larger image]

Box office revenues over the years for LGBT movie keyword

Image

[click for larger image]

Number of movies by year

Image

[click for larger image]

Click here for Interactive Treemap visualization of LGBT movies

Image

[click for larger image]

 

 

Click here for Interactive Treemap visualization of LGBT movies

Dec
12

The Benefits and Risk of Using a Dashboard

dash_editor

If you are considering trying out some business intelligence software you may be wondering what the benefits really are. You will probably more than likely wonder if there are any risks involved also, especially if you are going to be using your dashboard to deal with sensitive information. Many sites and articles will tell you that there are great benefits involved with using a dashboard solution such as Excel Dashboard, but not very many specify exactly what those benefits are.

  • Saves Money
  • Bridges gap between planning and action
  • Allows long term planning
  • Greater focus on performance and analysis

Saves Money:

This is one of the principle benefits of most forms of information technology. Whereas previously hours of manpower would have to be invested into collecting and charting the data in just one single graph, business intelligence solutions like Excel Dashboard can provide up-to-date detailed reports in seconds. When the cost of paying a team of accountants to create a single report is considered, business intelligence solutions are an undeniable bargain.

Bridges gap between planning and action:

In most large organisations there is a vast gap between the managerial staff who make decisions and those further down the ranks who are in charge of putting these decisions into action. With effectively laid out dashboards, higher up executives can get realtime data of the day-t0-day dealings of any aspect of the business and instantly see how their plans are being put into effect.

Allows Long Term Planning:

Using the analytical features of Excel Dashboard enables dashboard users to extrapolate data forward in time and gain predictions on future performance. Even without activating these analytical features, it is possible to plan ahead for possible issues and problems based on the volume of data and detail in each report.

Greater focus on performance and analysis:

With an Excel dashboard generating KPI reports and other business related reports, the managerial staff of any business will find their focus shifting towards correctly analysing the data provided. Once the benefits of a dashboard are recognised, the emphasis will be on using the data provided effectively in order to boost performance.

The benefits of dashboard solutions are clear and valuable. In the next post we will discuss any risks that should be accounted for, such as data security etc.

Oct
10

What Not To Do When Creating a Dashboard

dash_editor

When used properly, dashboards are highly effective business intelligence tools. However there are many mistakes that can be made when designing a dashboard,  that can ultimately result in a less effective and sometimes even confusing layout.

Some of the primary things to avoid when creating dashboards are:

  • Clutter
  • Lack of Focus
  • Irrelevant charts
  • Clutter:

When you design your Excel dashboard you should keep in mind that you want reports that are clear, succinct and to the point. What you definitely do not want, is a dashboard that is so full of various charts and data that it is impossible to get a clear overview.

  • Lack of Focus:

To create an effective dashboard, the designer must first know exactly what information he or she wants to receive from the dashboard. There is no point including a chart on the amount of water purchased for the staff canteen, or the figures spent on a specific advertising campaign, when this sort of data can be included in more general charts focussed on expenses. If you want that kind of specific detail, you can include it through drill down features, or even create a separate dashboard for detailed expenses. Always remember that a dashboard should display KPIs (Key Performance Indicators), that help managers and executives decide what changes and decisions should be made to boost the company’s performance. The designer of the dashboard therefore needs to know exactly what the KPIs are, so that the dashboard can reflect the relevant information.

  • Irrelevant Charts

Again this is a very key error that can easily happen when putting together an Excel dashboard. Even small business generate a huge wealth of information, and just about any aspect of a business’ day-to-day operations can be charted and potentially included in a dashboard. It is therefore necessary to be clinically precise when creating your dashboard. Remember you can always go back and edit the specifications if you find that you have included certain charts that are irrelevant to your decision making, or if you have omitted data that is highly important. Business intelligence software such as an Excel dashboard can make an immediate difference to how you run your business, but it is important to constantly adapt your software to your needs and to your operation.

Image

Oct
10

Some Background Information on Dashboards (Part 1)

dash_editor

The first Dashboards begin to be used for the purposes of business intelligence in the mid 1980s. However these programs had limited capabilities, and were often limited to executives within an organisation. Since then dashboards have developed and become wide spread.

Dashboards currently fall under the category of Business Intelligence Systems, with multiple layers that are tailored to various users within a company.  They are designed to integrate data from multiple sources, such as documents, communication programs and data files in order to create reports and highlight potential problems.

As business intelligence software developed, programs were able to create basic reports from data files. However these reports were limited to certain areas, and the applications were not capable of creating comparative analyses. Nowadays one of the key features of business intelligence and dashboard technologies is the ability to perform comparative analysis. These multi-layered reports are presented visually. The two key aspects of dashboard technologies are now visualization and integration. In each dashboard key performance indicators are highlighted and displayed, and any changes or complications are immediately visible.

Sep
9

Key Performance Indicators with Excel Dashboard

dash_editor

If you are running a business, large or small, your focus and the focus of your business intelligence software will always be directed towards your key performance indicators.  Your key performance indicators may reflect two or more aspects of your business. For example, you will always need to know how successful your enterprise is. You may also have laid down some long term goals. Key performance indicators can show you how you are progressing towards fulfilling those aims.

Excel Dashboard can track your business’ performance, and specifically focus on any Key Performance Indicators you specify. For example you can direct your dashboard to focus on sales results or market share.

It is especially important to be able to compare the performance of your company against that of other groups in the same industry. This sort of comparative analysis can take a long time, however Excel Dashboard can do it for you in minutes.

You can also use Excel Dashboard to compare data and figures from various sales quarters to each other. This helps you to see your overall performance over a longer period of time and indicates how you are progressing towards certain performance aims you may have established.

In short, any decisions that are made by the highest levels of management within a company should be as informed as possible. With Excel Dashboard Key Performance Indicators are instantly visible, and detailed but clear overviews of any aspect of business performance can be generated instantly.

Sep
9