Google data studio

  What is Google data Studio or Looker studio- Looker Studio is now Google Data Studio .It is a tool for data visualization ,but not for data cleaning ,the data cleaning should be done out side of it. What is Google data Studio official site- https://lookerstudio.google.com How to use it- Use it for free by logging in with your gmail.  Examples- On my blog (click)

  Category Original Function Excel Formula Equivalent Looker Studio (Google Data Studio) Equivalent Notes Aggregation AVG(X) `AVERAGE(X)` `AVG(X)` Aggregation COUNT(X) `COUNT(X)` or `COUNTA(X)` `COUNT(X)` Excel: `COUNT` counts numbers, `COUNTA` counts non-blank cells. Aggregation COUNT_DISTINCT(X) `SUM(--(MATCH(UNIQUE(X),UNIQUE(X),0)=ROW(UNIQUE(X))-MIN(ROW(UNIQUE(X)))+1))` (Array formula for older Excel) or `COUNTA(UNIQUE(X))` `COUNT_DISTINCT(X)` Excel: `UNIQUE` function is available in newer Excel versions ...

   How to upload your  images in Google data studio  If you generated your own image and wish to add it then how to generate and share its link safely ? The answer is very simple and following are the steps- 1- Open google drive ,login to your gmail there you can access your drive for free. 2-Upload your image in drive . 3-Select the three dots at right of the uploaded image and rename it . 4- From the same three dots make it shareable click the three dots then "share " option in share option from drop down at bottom select "anyone with the like". Doing that makes the image public. 5-Use above link in table visual of Google Data studio.