Kumaran1987

 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 

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

 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.Product...

 Sql Query with Where clause select ProductSubcategoryID, size, StandardCost, ListPrice, class, style from  Production.Product where ProductSubcategoryID is not null and  size is not null and StandardCost <> 0.00 and  ListPrice <> 0.00 and  class is not null and  style is not null     -- Complex SQL query with where, group by, having clauses and top, rank, dense_rank, row functions select Top 20 ProductSubcategoryID,  Max(StandardCost) as MaximumStdCost,  Max(ListPrice) as MaxListPrice, Max(ListPrice) - Max(StandardCost) as MaxDifferenceStandardFin, Max(ListPrice) / Max(StandardCost) as CostPriceRatio, Rank() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as DistinctRankMaximumCostPriceRatio, Row_Number() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as RankMaximumCostPriceRatio, DENSE_RANK() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as DistinctRankwithNextSequence from  Production.Pro...