Derive Insights from BigQuery Data by Google Cloud

The lab assesses our ability to write SQL, query datasets, loading data into BigQuery, troubleshooting common syntax errors, and using Looker Studio, etc.

The code.

Time Series Forecasting.

Air Quality in India (PM 2.5), using ARIMA Model.

The data had limitations and were accounted for, thus still with possibilities for improving the model for production. For example, the test now is extrapolating for about two days but can be retrained as the actual values are realized.

Click for the notebook.

Streamlit apps using Snowflake backend.

1) An app for ordering custom smoothies, click here.

2) Another app for the kitchen to manage orders, here.

A prototype of this was built for Data Application Builders Workshop by Snowflake. This version published is improvised to be more meaningful and practical. Has covered #Streamlit, #SnowSQL, #SnowPark, and other Snowflake features for data applications.

EDExplore

A simple widget for interactive EDA / QA.

An IPyWidget I wrote, as a tiny package for those who use Pandas in Jupyter Notebooks. This should enable the user to think of new things and work on actual challenges than writing repeated - boring conditions, especially when the volume of work is very high!

Documentation: https://nagapv.github.io/edexplore/intro.html

Improvised two visualizations part of a course (not of the problem set), inspired by minimalist principles of Edward Tufte. Read more.

Simple explanations for simple problems!

Why overwhelm the stakeholders with unnecessary details? Full post.