The new Microsoft Excel API has its own built-in chart resource, allowing you to drive visualizations from the spreadsheet API. I’m sure the suite of business focused visuals they provide by default will meet a few of the common needs of the average business user.

To help make the Excel API, D3.js visualization be more embeddable and shareable, I recommend providing a caching option that would take a JSON snapshot of the spreadsheet data and allow it to be shared via link, embedded with a copy / paste, email, or any other common channel for collaboration.

In my option, Microsoft Excel took a very active initiatives to integrate the most popular and advanced technology into Excel to attract more users to use Excel.

Reference:https://dzone.com/articles/who-is-getting-to-work-on-the-excel-api-to-d3js-vi

Marketing dashboard could be misleading when you analysis all the different variables and get the data visualization towards your direction in mind. Here are a few ways your dashboard may be lying to you.

Ambiguous or poorly captured metrics: There’s nothing more dangerous than a dashboard that does a poor job of collecting data. Data integrity is the key to dashboard success and ambiguous inputs can send an entire company into a tailspin. What’s most dangerous is the fact that ambiguous data can easily pass for accurate insights.

Oversimplification of data: There’s something to be said for simplifying data so it’s easy to digest, but there’s immense danger in oversimplifying the information that matriculates through the dashboard. In most cases, this is the result of a lack of context.

Hidden biases in the design: Humans design dashboards and the algorithms that cause them to function. Humans make mistakes all the time. This occasionally leads to hidden biases in the way dashboard systems are designed. The result is skewed data that causes you to act in a certain way.

In my option, it is very important to keep eyes on those points that could makes dashboard lying. There are a variety of dashboard technologies to make data more honest and accurate. We shall apply models to clean our data from the source and then try different methods to discover the data. When we design the data visualization, we should minimize our biases by switching positions and claims.

http://www.campaignlive.com/article/marketing-dashboard-lying-you/1424653#1eehRyDuqIpYzAVY.99

Data Studio is the newest free reporting tool from Google. It’s great for doing analysis on a variety of data sets, including MySql databases, Google Sheets and several Google products like BigTable, AdWords, YouTube, Analytics and DoubleClick. As with most Google products, direct integrations with the other big players are sorely missing, and for agencies, that means there’s no integration with Bing Ads, Facebook Ads or others that compete with Google for advertising dollars.

 

In my option, this data visualization and analysis tool is very beneficial for business analyst to analyze advertising revenue and cost with data integration from Google products such as AdWords, Search Console , Youtube. It will be more beneficial to integrate with other ads sources. In all, I think it is a great tool to boost some daily work tasks for analysts.

A review of free PPC reporting solutions from Google

Visualization is helping golfers to improve their movement. The visualization can help to compare a real and imagined action and the golfer can stimulate the same muscle that would use to perform the read action. To visualize a shot, a golfer need to get a clear picture of the path the ball will travel on to reach the target. The other way is to visualize is to actually see himself or herself hitting the shot. The visualization can also help a golfer to make swing change to create new neural pathway and make the change part of “muscle memory”.

In my option, visualization shall not be limited to the use in business but also extend its use into sports training. I personally have been took a visualization class and it helped me to show how different I swing each time with statistical charts. I also try to memory my position and strength of the best swing as the visualization pointed out. In all, I believe the visualization is a great way to enhance performance of the sports training.

http://www.businessmirror.com.ph/the-power-of-visualization-for-golf/

Key performance indicators (KPIs) can aid in measuring BI and analytics performance. The key challenges for creating a KPI is to meet business objectives, and use knowledge to generate value form a successful business intelligence system. Dashboard is to present this KPI in a form for management review. Dashboard will provide real-time presentation of KPIs and allows for drill-down.

In my option, the KPI shall not be limited to presenting the business process and results. It shall also make recommendations for actions to improve business process. After some actions are implemented, the dashboard can reflection the changes of KPI based on those actions. Dashboard shall adopt more machine learning and deep learning algorithms. In this way, dashboard can be more intelligent to make recommendations for senior executives.

http://searchbusinessanalytics.techtarget.com/feature/Defining-and-using-KPIs-in-a-successful-business-intelligence-system

6. jQuery

jQuery is another  JavaScript library to work on event handling, animation.  jQuery has easy to use API and it has When working on a web project, it takes less time to complete simple tasks and it is compatible with most web browsers. jQuerty can control DOM and Ajax application. jQuery separates HTML and JavaScript code which makes the code cleaner.

7. Ember.js

Ember.js is a mix of Angular.js and React.js. It is similar to Angular.js when syncing data. The two-way data exchange makes web application faster and more scalable. Developers can create front-end elements. It is similar to server-side Virtual DOM to provider better performance and scalability. Its community also provides sample code and libraries.

8. Polymer.js

Polyer.js is userful to create HTML5 and its main focus in to extend functionality and able to create own tags. For example, a developer can create an element with its own fuctionality similar to that element in HTML5.

9. Three.js

Three.js is another JavaScript library and it is popular for 3D development. Three.js uses WebGL and can be used to render 3D objects. It is better to use write web-based games such as HexGL.

https://opensource.com/article/16/11/15-javascript-frameworks-libraries

JavaScript is one of the best open source stance and the top programming language with number of repositories on GitHub. There are several useful libraries to share.

 

1. Augular.js

It is a JavaScript framework used by developers to create complex web applications. It supports MVC architecture. It uses data binding as one of the main concept and users can interact with the interface. When a new interaction is performed by the user, the view is then updated with the new values and turn the interaction with the model to be synchronized. The DOM is updated after the underlying logic.

 

2. Backbone.js

 

It is normally used to build simpler web application frameworks. And is ia a great fit for new beginners to lean web app development. It also supports MVC and it suppoets RESTful APT, proper state management and so on .

 

3. D3.js

It is a great to create complex and rich web applications with data manipulation features. It applies SVG, HTML, and CSS to build dynamic webpages. It can also bind data to DOM and enable data-driven events. It can create high-quality data –drirven web pages.

 

4. React.js

It is ideal to build highly scalable front-end user interfaces. It is build on a virtual DOM which acts as mediator between client-side and server-side and use it to improve performance. The changes on virtual DOM match with the server DOM, and make process faster than a traditional UI update.

 

https://opensource.com/article/16/11/15-javascript-frameworks-libraries

The first step is to reduce high dimensional data to lower dimension through Principal Component Analysis (PCA).

The second step is to access the signal- to –noise ratio in the data using project score and randomization.

The third step is to remove noise by variance filtering.The fourth step is to perform statistical test. And the last step is to use the graphs to refine the search for subgroups or clusters.

Source:http://www.genengnews.com/gen-articles/visualization-for-advanced-big-data-analysis/5947

Dashboard is not only used by companies executives, it can also be used by users for everyday life. GetCastor enables users to create a dashboard from the data such as calendars and the weather. Users can create or select widgets and adjust their importance by their preference. The application then retrieves the data via the user’s web and updates the dashboard.

The dashboard can be shown in TVs or tablets or phones. With this application, users can view their dashboard once they wake up and they can see their schedules of the day as well as some other important information.

Source: http://betakit.com/getcastor-lets-you-create-the-dashboard-relevant-to-your-everyday-life/

 

Dashboard can have a significant economic impact on business because it reduces the amount of time to process analytics and increased efficiency and effectiveness in marketing.

Better information = better planning = increased ROI

With real-time information, executives can view reports of KPIs from different departments. The high-quality data can help executives to better make decisions and adjust plans to changing conditions quickly and efficiently .

Dashboard is not just for executives. Dashboard can breaks down the report into different levels of employees in every organization. Executives can use dashboard to communicate missions to every employee.

Reference:

http://bigdata.cioreview.com/cxoinsight/how-executive-dashboards-are-changing-the-way-business-is-done-nid-23528-cid-15.html