Embedding Tableau Public Dashboard into the web application

Prashant Kamble — Tue, 05 Jan 2021 20:37:54 +0000

Tableau Public is a free platform to publicly share and explore data visualizations online. Anyone can create visualizations using free Tableau Public Edition.

Steps to embedding tableau public dashboard into the web application with Embed code:

1. Sign in to Tableau Public with your login credentials,

2. Once you logged in to Tableau public, open any existing dashboard and click on the “Share” button.

3. After clicking the “Share” button, the Share pop-up box will come.

4. Then copy Embed code from the Share pop-up box. Create a simple HTML file name Test.html and paste copied Embed code into the <body> tag of the HTML file.

Below is the sample HTML code for reference,

<html>
<head>
  <title>Embedding Tableau public reports into the web application</title>
</head>
<body>
    <div class='tableauPlaceholder' id='viz1609851260284' style='position: relative'>
        <noscript><a href='#'><img alt=' ' src='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;Te&#47;TeslaStockPrices_16097083454810&#47;TeslaStockPrice&#47;1_rss.png' style='border: none' /></a>
        </noscript>
        <object class='tableauViz'  style='display:none;'>
        <param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> 
        <param name='embed_code_version' value='3' /> 
        <param name='site_root' value='' />
        <param name='name' value='TeslaStockPrices_16097083454810&#47;TeslaStockPrice' />
        <param name='tabs' value='no' /><param name='toolbar' value='yes' />
        <param name='static_image' value='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;Te&#47;TeslaStockPrices_16097083454810&#47;TeslaStockPrice&#47;1.png' /> 
        <param name='animate_transition' value='yes' />
        <param name='display_static_image' value='yes' />
        <param name='display_spinner' value='yes' />
        <param name='display_overlay' value='yes' />
        <param name='display_count' value='yes' />
        <param name='language' value='en' />
        </object>
        </div>                
        <script type='text/javascript'>                    
        var divElement = document.getElementById('viz1609851260284');                    
        var vizElement = divElement.getElementsByTagName('object')[0];                    
        if ( divElement.offsetWidth > 800 ) { vizElement.style.width='1300px';vizElement.style.height='927px';} 
        else if ( divElement.offsetWidth > 500 ) { vizElement.style.width='1300px';vizElement.style.height='927px';} 
        else { vizElement.style.width='100%';vizElement.style.height='2127px';}                     
        var scriptElement = document.createElement('script');                    
        scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js';                    
        vizElement.parentNode.insertBefore(scriptElement, vizElement);                
        </script>
</body>
</html>

5. Save the Test.html file and double click on it.

6. It will open in the browser and we can see the Dashboard.

It was a simple example of embedding a tableau public dashboard. You can use the Embed code in your web application in various ways.

Check out my Tableau Public profile Prashant Kamble

What is Data Warehouse in Business Intelligence?

Prashant Kamble — Sun, 13 Dec 2020 12:10:21 +0000

In business intelligence, data warehouses serve as the backbone of data storage. Data warehousing and business intelligence are terms used to describe the process of storing all the company’s data in internal or external databases from various sources with the focus on analysis, and generating actionable insights through online BI tools.

A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process.

Business intelligence (BI) is a technology-driven process for analyzing data and delivering actionable information that helps executives, managers and workers make informed business decisions.

Data warehouse Architecture :

Operational System
An operational system is a method used in data warehousing to refer to a system that is used to process the day-to-day transactions of an organization.

Flat Files
A Flat file system is a system of files in which transactional data is stored, and every file in the system must have a different name.

Meta Data
A set of data that defines and gives information about other data.
Meta Data used in Data Warehouse for a variety of purpose, including:

Meta Data summarizes necessary information about data, which can make finding and work with particular instances of data more accessible. For example, author, data build, and data changed, and file size are examples of very basic document metadata.

Lightly and highly summarized data
The area of the data warehouse saves all the predefined lightly and highly summarized (aggregated) data generated by the warehouse manager.

The goals of the summarized information are to speed up query performance. The summarized record is updated continuously as new information is loaded into the warehouse.

End-User access Tools
The principal purpose of a data warehouse is to provide information to the business managers for strategic decision-making. These customers interact with the warehouse using end-client access tools.

The examples of some of the end-user access tools can be:
Reporting and Query Tools
Application Development Tools
Executive Information Systems Tools
Online Analytical Processing Tools
Data Mining Tools

Data Warehouse in the Cloud:

A cloud data warehouse is a system, which uses the space and compute power allocated by a cloud provider to integrate and store data from disparate data sources. It is employed for data structured storage, analysis and reporting.

Cloud Data Warehouse vs Traditional Data Warehouse Concepts

Difference Between Business Intelligence and Data Warehouse :

DEV Community: Prashant Kamble