Sticky post

insights from E-Commerce retail data set

We are using Bigquery as our data warehouse solution and using standard SQL as query language . For dataset we use Google’s Google Analytics logs of an merchants website. You need to enable your bigquery account which has a daily limit and there after it is cost effective. Click Navigation menu > BigQuery. Click Done. BigQuery public datasets are not displayed by default in the BigQuery web UI. To open the public datasets project, open https://console.cloud.google.com/bigquery?p=data-to-insights&page=ecommerce in a new browser window. In the left pane, in the Resource section, click data-to-insights. In the right pane, click Pin Project. Explore ecommerce data Problem :  Your data analyst team exported … Continue reading insights from E-Commerce retail data set

BigQuery ML(move your model towards data and not data towards model)

Overview BigQuery ML enables users to create and execute machine learning models in BigQuery using standard SQL queries. BigQuery ML democratizes machine learning by enabling SQL practitioners to build models using existing SQL tools and skills. BigQuery ML increases development speed by eliminating the need to move data. BigQuery ML functionality is available by using: The BigQuery web UI The bq command-line tool The BigQuery REST API An external tool such as a Jupyter notebook or business intelligence platform Data Analyst is a Machine learning engineer now? Machine learning on large data sets requires extensive programming and knowledge of ML frameworks. These … Continue reading BigQuery ML(move your model towards data and not data towards model)

Sticky post

Query GitHub data using BigQuery

BigQuery is Google’s fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes of data without needing a database administrator or any infrastructure to manage. BigQuery uses familiar SQL and a pay-only-for-what-you-use charging model. BigQuery allows you to focus on analyzing data to find meaningful insights. In this post we’ll see how to query the GitHub public dataset to grab hands on experience with it. Sign-in to Google Cloud Platform console (console.cloud.google.com) and navigate to BigQuery. You can also open the BigQuery web UI directly by entering the following URL in your browser. Accept the terms of service. … Continue reading Query GitHub data using BigQuery

Explore a BigQuery Public Dataset

Storing and querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. Google BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google’s infrastructure. Simply move your data into BigQuery and let us handle the hard work. You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data. You access BigQuery through the GCP Console, the command-line tool, or by making calls to the BigQuery REST API using a variety of client libraries such … Continue reading Explore a BigQuery Public Dataset

Sticky post

Be different build a machine learning model with some extra line in your SQL query and grab attention

By the introduction you probably get it and yes we are talking about Biguery ML . BigQuery ML enables users to create and execute machine learning models in BigQuery using standard SQL queries. BigQuery ML democratizes machine learning by enabling SQL practitioners to build models using existing SQL tools and skills. BigQuery ML increases development speed by eliminating the need to move data. SEND FEEDBACK BigQuery ML  Documentation Introduction to BigQuery ML Overview BigQuery ML enables users to create and execute machine learning models in BigQuery using standard SQL queries. BigQuery ML democratizes machine learning by enabling SQL practitioners to … Continue reading Be different build a machine learning model with some extra line in your SQL query and grab attention

Sticky post

Become A Marketing Expert By using Google Cloud products learn the Art of Asking with a Browser

First thing first We will discuss what is Bigquery and why we are choosing Bigquery….. BigQuery is Google’s fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to … Continue reading Become A Marketing Expert By using Google Cloud products learn the Art of Asking with a Browser

Sticky post

Visualizing BigQuery data in a Jupyter notebook with SQL

BigQuery is a petabyte-scale analytics data warehouse that you can use to run SQL queries over vast amounts of data in near realtime. Data visualization tools can help you make sense of your BigQuery data and help you analyze the data interactively. You can use visualization tools to help you identify trends, respond to them, and make predictions using your data. In this tutorial, you use the BigQuery Python client library and Pandas in a Jupyter notebook to visualize data in the BigQuery natality sample table. SEND FEEDBACK BigQuery Visualizing BigQuery data in a Jupyter notebook Contents Objectives Costs Before you begin Setting … Continue reading Visualizing BigQuery data in a Jupyter notebook with SQL

End To End Scalable Machine Learning Project On Google Cloud With Beautiful Front End with Big Data-II

This is the last post of our blogs full hands on tutorial of machine learning at scale with Big data on cloud so holds your hand tight as its about to finish . If you ditch me like my past girlfriends i will still be same desperate for your response and hope that one day you will see my previous posts that I am providing here. Exploring the dataset and visualizing it. Building Machine learning regression model using DNN. So let’s build the final concepts and serve what we build in web . So at first we will talk about: … Continue reading End To End Scalable Machine Learning Project On Google Cloud With Beautiful Front End with Big Data-II

End To End Scalable Machine Learning Project On Google Cloud With Beautiful Front End with Big Data

As the title suggest we will be using Big data(structured) as our resource , We will use GCP as our platform and we will use python as our saviour and kubernete for deployment and Finally we will have a working Machine learning project of our own. Note: The code and concept is taken from Google cloud tutorial on coursera So with out further wasting your time let’s start: So why data science projects or ML model with Big data are different than what we used to build on our github to showcase its the memory ……got it again right memory … Continue reading End To End Scalable Machine Learning Project On Google Cloud With Beautiful Front End with Big Data