I recently came across an assignment for Tableau that required me to find the total number of business days in each month over several years. When originally presented with the data, all I had to go off of was the Continue reading Calculating the Number of Business Days
Problem: When performing a transaction within a TRY..CATCH block, part of the instructions within the transaction gets executed even if an error occurs. This anomaly breaks the ACID rules of atomicity. A solution or workaround is needed to keep transactions Continue reading SQL Transaction Anomaly
Elasticsearch : Elasticsearch is a search engine that can index new documents in near real-time and make them immediately available for querying. Elasticsearch is based on Apache Lucene and allows for setting up clusters of nodes that store any number Continue reading Setting Up ElasticSearch+Logstash+Kibana
Step 1: If you are Installing kafka on aws , you need to change the Instance type to m3.2xlarge. 1.A : Login to your aws account and stop your instace First. Then use the fallowing steps to change the Instance Continue reading Getting Started with Kafka
My recent project is to analysis airlines delay in 2008. Airlines delay is always a problem that brings lots of trouble to both customers and airlines carriers. An airline delay is a flight arrives later than its scheduled time. Here Continue reading Airline Delay Analysis with Tableau 9.0
To be able to construct valid and efficient graphics, you should always make sure that your data is clean and easy to manage in order to begin creating visualizations. Within the software itself, Tableau gives you many options to be Continue reading Preparing Data for Tableau Analysis II
Learning code can seem like a very intimidating task to do. There are dozens of different languages, a multitude of platforms, and an insane list of commands and functions that make you think “is all of this really worth learning?” Continue reading Wanna Learn Code?
There are many ways data scientists can make error in sampling the population. Using non random samples will usually not give a good presentation of the population. Taking a survey in a specific neighborhood will not result in a good Continue reading Some sources of error in data collection.
Big data. Its become the talk of the town these days. It seems that there is not a company left in the country that hasn’t delved into this field, and if there are any, it’s only a matter of time Continue reading What is Big Data?
Statistics deal with collecting, organizing, analyzing, interpreting, and presenting data. There are two types of statistics: Descriptive and inferential. Descriptive statistics summarizes data from a data set using mean, median, mode, standard deviation…etc. On the other hand, Inferential Statistics makes inferences about populations using Continue reading Which type of Statistical Test should we use?