Posts

Quantum Internet Benefits

Image
  The quantum internet is a network of quantum computers that are connected together using quantum communication. It has the potential to revolutionize many industries, including: Secure communications: The quantum internet would be inherently secure, as it would be impossible to eavesdrop on quantum communications without being detected. This could be used for applications such as secure financial transactions, government communications, and military applications. Quantum computing: The quantum internet would allow quantum computers to be connected together, which would allow them to solve problems that are currently impossible for classical computers. This could be used for applications such as drug discovery, financial modeling, artificial intelligence, and materials science. Quantum sensors: The quantum internet could be used to connect quantum sensors together, which would allow them to create a global network of sensors that could be used to monitor the environment, detect earthq

Google Analytics connected with Tableau Dashboard

Image
Hi, In this blog post we are gonna see about how to connect Google analytics with Tableau software Check this below video for more details,

How to create custom reports in Google analytics and flat file csv data ingest into SQL server ?

Image
 In this post, we gonna cover in Google analytics how to create custom reports from dimension and metrics? In this below video, I have explained about Customer who visited my website pages from which city there are visiting and which Internet service provider they used to get the details.

How to get Google Search Queries data from Visitors in Google Analytics?

Image
Let's say you have website, you wanna get the details about your customers / your visitors,  who had visited your webpage from google.  Do you wanna know about your website visitors who hit the Google website using some random keywords then this below video will give some ideas. insights about it.

How to check each customer views in Google analytics using User explorer option?

Image
 Hi In this blog spot will cover about user / customer viewed details on your webpages in Google analytics - I had temporary setup Google analytics for my blog, so whoever visited my web page ! I can able do the user explorer and understand about each user viewing behavior based google analytics dimensions and metrics related information - In this below video randomly queries that insights data and checking that who are all users has seen my web pages and other relevant details 

Exploring and Data Ingesting between Google Data Studio, Google Analytics and Microsoft SQL Server

Image
In this blog post,  will see about Exploring this blog's near Decade experience with Google Analytics and Google Data studio platforms   - Google Analytics - Insights intelligence tool to query and visualize   - Google Analytics - User Explorer  - Google Analytics Dashboard providing default data studio visual insights - Google Data studio - Behaviors and overviews  - From Google Data studio Export csv data and import data in SQL server databases  The above mentioned exploring the views, insights between Google Analytics, Google Data studio and Sql Server to ingest data viz'ed datas !! will be available in this below video with details

SQL Join Query - Building Complex Join Query - Day 5 #100days of SQL

Image
 Hi , In this blog post will check the join queries SQL Join function below diagram shows difference possibilities   Below queries has been executed on the video podcast -- will see about join query from the db table schema diagram -- will check about product and transaction history table on join  query select * from Production.Product  -- 504 records select * from Production.TransactionHistory  -- 113443 records -- inner join select * from Production.Product p inner join Production.TransactionHistory t on p.ProductID = t.ProductID  -- full join or full outer join select * from Production.Product p full outer join Production.TransactionHistory t on p.ProductID = t.ProductID -- right join or right outer join select * from Production.Product p right outer join Production.TransactionHistory t on p.ProductID = t.ProductID -- left join or left outer join select * from Production.Product p left outer join Production.TransactionHistory t on p.ProductID = t.ProductID  -- now will complex join

Connecting SQL Server with Power BI Data Viz !!

Image