Pivot tables are a popular and powerful tool used in data analysis and data manipulation. They provide a simple way to summarize, aggregate and analyze large amounts of data in…
Continue readingKibana – Open Source Visualisation
Learn visualisation and the database concepts with Kibana. A good way to learn Json based datasets and elastic search. Kibana is also called as the charting tool for Elastic stack.
Continue readingUse of structs, arrays, unnest and crossjoin in BigQuery
These are some of the new concepts introduced by Google query datasets using Google tool BigQuery. BigQuery supports large JOINs, and JOIN performance is good. However, BigQuery is a columnar…
Continue readingLaTeX for better documentation
LaTeX is a software system for document preparation. LaTeX attempts to follow the design philosophy of separating presentation from content, so that authors can focus on the content of what…
Continue readingPandas
Pandas are used for reading the data from Excel, CSV or json files. It will allow you to read data in a matrix format and save it as a dataframe….
Continue readingPython for automation
Although Python is famous for its use as a Data Science language, It can also be used to automate manual work. Main libraries used for this purpose are as follows:…
Continue reading