Видео

I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

Dear frnd, yes it might be a stupid video for you because you have to create data and then you have to practice to create customize heat map. you are commenting it as a stupid video because you wanted to have a readymade clean data for your practice but nothing is free in this life. you could have commented that you need this data for practice and i would have personally shared the data over an email. but instead of that you choose a different way and i wish you your different way would have helped you but i can understand your frustration. i am with you as i am with all my you tube community. please let me know brother if you need the data for practice. i would be happy to help.

​@@thedatamillennials Sorry bro was just frustrated. Had a pending task and wasn't able to find the solution. Once again sorry.

No Worries brother. Hope you were able to find the solution and best of luck.

hey apologies for the delayed response. you just just have to sort the data based on column A and rest all the data will sorted based on Column A only .. in case if column B has any formula, even then the values will start reflecting based on column A values . In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

To save the results of a UNION query into a new table in SQL, you can use a combination of the `CREATE TABLE` and `INSERT INTO` statements. Here’s a step-by-step guide for this process: 1. Create the New Table: First, you need to create the structure of the new table that will store the results of the UNION. The structure should match the structure of the result set of your UNION query. 2. Insert Data Using UNION: Use the `INSERT INTO` statement combined with your UNION query to populate the new table. Here is an example to illustrate the process: Suppose you have two tables, `table1` and `table2`, and you want to save the union of these tables into a new table called `new_table`. Step 1: Create the New Table ### Step 2: Insert Data Using UNION Next, use the `INSERT INTO` statement with your UNION query to insert data into the new table: sql INSERT INTO new_table (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM table1 UNION SELECT column1, column2, column3, ... FROM table2; ### Example Let’s say you have two tables with the following structure: table1: - id (INT) - name (VARCHAR) - age (INT) table2: id (INT) name (VARCHAR) age (INT) You want to union these tables and save the results into a new table called `new_table`. sql Step 1: Create the new table CREATE TABLE new_table ( id INT, name VARCHAR(255), age INT ); Step 2: Insert data using UNION INSERT INTO new_table (id, name, age) SELECT id, name, age FROM table1 UNION SELECT id, name, age FROM table2; By following these steps, you will create a new table and save the results of the UNION query into it.

To achieve this in Looker Studio (formerly Google Data Studio), you can follow these steps: 1. Prepare Your Data: Ensure that your data is imported into Looker Studio and is structured correctly. You might need to use Google Sheets or another data source that Looker Studio can connect to. Here's an example of how your data might look in a Google Sheet: ``` | Date | Category | | 2024-5-5 | P1;P2;P3 | | 2024-4-3 | P1;P3;P4 | | 2024-3-3 | P2;P4 | | 2024-2-2 | P1;P3 | ``` 2. Split Categories into Separate Rows (ETL): Looker Studio does not directly support the kind of string manipulation and aggregation you're looking for. Therefore, you need to preprocess the data. You can do this in Google Sheets or any ETL tool. Here’s how you can do it in Google Sheets: - Step 1: Split the category column into multiple columns. Use the `SPLIT` function in Google Sheets: A2: =SPLIT(B2, ";") This will split `P1;P2;P3` into separate cells. -Step 2: Unpivot the data. Convert the wide format to long format using an Apps Script or manually unpivoting: | Date | Category | | 2024-5-5 | P1 | | 2024-5-5 | P2 | | 2024-5-5 | P3 | | 2024-4-3 | P1 | | 2024-4-3 | P3 | | 2024-4-3 | P4 | | 2024-3-3 | P2 | | 2024-3-3 | P4 | | 2024-2-2 | P1 | | 2024-2-2 | P3 | 3. Connect the Prepared Data to Looker Studio: - Open Looker Studio. - Connect to the Google Sheet containing your prepared data. 4. Create Calculated Fields: - In Looker Studio, you can create a calculated field to count the occurrences of each category. - Create a calculated field for each category: - `P1 Count`: `COUNTIF(Category = "P1")` - `P2 Count`: `COUNTIF(Category = "P2")` - `P3 Count`: `COUNTIF(Category = "P3")` - `P4 Count`: `COUNTIF(Category = "P4")` - Alternatively, if you have a large number of categories or want a more dynamic solution, use a CASE statement: CASE WHEN Category = "P1" THEN 1 ELSE 0 END 5. Create the Visualization: - Add a new table to your report. - Use the Category field as the dimension. - Use the calculated fields for each category as the metrics. - Add another calculated field to sum the counts for the total: - `Total`: `SUM(P1 Count) + SUM(P2 Count) + SUM(P3 Count) + SUM(P4 Count)` - Add a calculated field to compute the percentage: - `%`: `SUM(P1 Count) / SUM(Total) * 100` (similarly for other categories) 6. Arrange the Table: - Ensure your table looks like the one below: | Category | Total | % | |----------|-------|-----| | P1 | 3 | 30% | | P2 | 2 | 20% | | P3 | 3 | 30% | | P4 | 2 | 20% | | Total | 10 | 100%| By following these steps, you can transform your data and visualize the count and percentage of each category over a specific period in Looker Studio.

Hey Apologies for the delayed response. thanks for going through my video. In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

thanks Akash. you words have really encourage me to work harder, so that i can help someone in need and I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

To achieve this in Looker Studio (formerly Google Data Studio), you can follow these steps: 1. **Prepare Your Data:** Ensure that your data is imported into Looker Studio and is structured correctly. You might need to use Google Sheets or another data source that Looker Studio can connect to. Here's an example of how your data might look in a Google Sheet: ``` | Date | Category | | 2024-5-5 | P1;P2;P3 | | 2024-4-3 | P1;P3;P4 | | 2024-3-3 | P2;P4 | | 2024-2-2 | P1;P3 | ``` 2. **Split Categories into Separate Rows (ETL):** Looker Studio does not directly support the kind of string manipulation and aggregation you're looking for. Therefore, you need to preprocess the data. You can do this in Google Sheets or any ETL tool. Here’s how you can do it in Google Sheets: - **Step 1:** Split the category column into multiple columns. Use the `SPLIT` function in Google Sheets: ``` A2: =SPLIT(B2, ";") ``` This will split `P1;P2;P3` into separate cells. - **Step 2:** Unpivot the data. Convert the wide format to long format using an Apps Script or manually unpivoting: ``` | Date | Category | | 2024-5-5 | P1 | | 2024-5-5 | P2 | | 2024-5-5 | P3 | | 2024-4-3 | P1 | | 2024-4-3 | P3 | | 2024-4-3 | P4 | | 2024-3-3 | P2 | | 2024-3-3 | P4 | | 2024-2-2 | P1 | | 2024-2-2 | P3 | ``` 3. **Connect the Prepared Data to Looker Studio:** - Open Looker Studio. - Connect to the Google Sheet containing your prepared data. 4. **Create Calculated Fields:** - In Looker Studio, you can create a calculated field to count the occurrences of each category. - Create a calculated field for each category: - `P1 Count`: `COUNTIF(Category = "P1")` - `P2 Count`: `COUNTIF(Category = "P2")` - `P3 Count`: `COUNTIF(Category = "P3")` - `P4 Count`: `COUNTIF(Category = "P4")` - Alternatively, if you have a large number of categories or want a more dynamic solution, use a CASE statement: ```sql CASE WHEN Category = "P1" THEN 1 ELSE 0 END ``` 5. **Create the Visualization:** - Add a new table to your report. - Use the Category field as the dimension. - Use the calculated fields for each category as the metrics. - Add another calculated field to sum the counts for the total: - `Total`: `SUM(P1 Count) + SUM(P2 Count) + SUM(P3 Count) + SUM(P4 Count)` - Add a calculated field to compute the percentage: - `%`: `SUM(P1 Count) / SUM(Total) * 100` (similarly for other categories) 6. **Arrange the Table:** - Ensure your table looks like the one below: | Category | Total | % | |----------|-------|-----| | P1 | 3 | 30% | | P2 | 2 | 20% | | P3 | 3 | 30% | | P4 | 2 | 20% | | Total | 10 | 100%| By following these steps, you can transform your data and visualize the count and percentage of each category over a specific period in Looker Studio.

Hey Apologies for the delayed response. There can be an issue with the data source but i would request you to please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

@@thedatamillennials issue solved. thanks for your reply

Welcome brother

hi pooja , i am about to do that ,i am going to create a github in which i am going to give the list of all question with the link. In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

thanks Pooja. I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

the user that has read only access can download the data but in case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

hey Rob, whenever you select a dropdown into you will be able to select single select or multiple select. if you switch to multiple select then you will be able to select multiple item. well by default in looker the drop down will have multiple select. In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics

Thankyou Didi

Yes you can use it , its totally depends on the situation and the further use of the output. lets say that you just need to show the output then you can use limit, but in case if you have to use the sql output as an input for further for transformation of data then you can not use limit. let me know your thoughts about it and incase if you want to discuss or brainstorm on any points in sql, python or data studio, please feel free to connect with me over a quick call (Email Id:- master.datamillennials@gmail.com)

I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics

Thanks for your response, it really encourage us to work harder. I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics

it really means a lot to us that you have shared your thoughts with us. I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

yes you can add multiple variables based on your requirement In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

You are welcome. In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

it really means a lot to us when you guys share your thoughts with us. it encourage us and motivate us to work a lot harder then we are doing currently. I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

it really means a lot to us when you guys share your thoughts with us. it encourage us and motivate us to work a lot harder then we are doing currently. I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com

thankyou

thankyou

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks

thanks