Author: datapandasadmin

| |

Entity Relationship Diagram – ERD and Cardinality Symbols Simple Explanations

Bydatapandasadmin

Understading cardinality notation and being able to explain them will go a long way in your database design and implementation. Here we look at a simple explanation of the symbols. (Credit to Data Warehousing for Business Intelligence by University of Colorado System on Coursera) Symbols in the above diagram and their meanings: – Oval: means 0 –…

Superset Caravel BI Tool Installation and Visualizations on Heroku

Superset Caravel BI Tool Installation and Visualizations on Heroku

Bydatapandasadmin

Superset (formerly called Caravel ) BI Tool by  http://airbnb.io/superset  is a free Data Visualization tool which you can harness its powers for your visualization analytic needs. If you are finding problems installing on your windows PC or you simply want your own online version you can simply sign up FREE with Heroku (at least choosing…

Populating Superset Caravel MySQL database tables with Data via Heroku

Populating Superset Caravel MySQL database tables with Data via Heroku

Bydatapandasadmin

If you installed  your Superset (Caravel) BI Tool with Heroku and if you are finding it difficult to initially populate your MySQL database tables with Data and you will be using MySQL the default database that come with your installation, then you can follow these steps to get data into Superset. (By the way, you…

SQL Statement Query Clause Evaluation Order – Which Part of SQL Statements Execute First and in What Order?
|

SQL Statement Query Clause Evaluation Order – Which Part of SQL Statements Execute First and in What Order?

Bydatapandasadmin

Which Part of SQL Statements Execute First and in What Order. It is very important to understand which parts of the SQL Statement executes first and which part comes next until full completion. The diagram below gives an overview of the execution order. The steps in which the SQL statement is executed are as below:…

Connect Google Big Query to Talend Open Studio and Pull Data From Big Query

Connect Google Big Query to Talend Open Studio and Pull Data From Big Query

Bydatapandasadmin

This is just a quick guide to connect Google Big Query to Talend Open Studio for  Big Data and use query to retrieve Data from Big Query into Talend. This means you will need the Talend Open Studio for Big Data Integration version. (You will have to download and install that if you do not have that…

NullPointerException – Eg 1 When Instance of an Object Is set to Null and It Is Used as A reference

Bydatapandasadmin

java.lang.NullPointerException exception is one of the most popular errors in Java and it is caused by so many issues. One of such issues is when an objected is initiated to a Null value and then its reference is used to call a method or a variable. Example is in the code below. /* * To…

Free Entity Relationship and Relational Schema Diagram Tool
| | | |

Free Entity Relationship and Relational Schema Diagram Tool

Bydatapandasadmin

ERDPLUS One tool I generally use when working on a projects, mini tasks and exploration is the ERDPLUS tool . It is quite simple and easy to use. It is a Free tool as well. Below are some diagrams I generated when i first got in contact with with tool. ERD DIAGRAMS: 1. 2.  A…

|

Creating Oracle PL/SQL Tables for Intercollegiate Athletic Database – Data Warehousing

Bydatapandasadmin

Creating Oracle  tables for Intercollegiate Athletic Database. Part of Assignment one of Data Warehousing for Business Intelligence on Coursera –1 CREATE TABLE FACILITY CREATE TABLE FACILITY( FACNO VARCHAR(12), FACNAME VARCHAR(255) NOT NULL, CONSTRAINT PK_FAC PRIMARY KEY (FACNO) ); –2.REATE TABLE EMPLOYEE CREATE TABLE EMPLOYEE( EMPNO VARCHAR(12), EMPNAME VARCHAR(255) NOT NULL, DEPARTMENT VARCHAR(100) NOT NULL, EMAIL VARCHAR(50) NOT…