Hey Guys,
We post programming tutorials for everyone,which will be structured at three level - Basic, Intermediate and Advance.
We will be focusing on Excel, EXCEL VBA, SQL, Basic SAS, Advance SAS, Google Data Studio, Power BI,R, Python, Dynamic Dashboard and Machine Learning.
Hope these tutorials helps you learn and improve your knowledge.
Happy Learning and Lets create something out of nothing!!
Watch Learn Rise Repeat.!!!!
Пікірлер
Found a solution after 2 days of the error 🤯
Thank you, this has been a big help!
Saviour!!
Is that option still available?, couldn't see these settings in the latest version.
Hi! Almost found what I was looking for in this awesome video, thanks. Do you know if there’s a way to use a data range control as a calendar table? This is, that it uses two different date columns to filter? Both columns are in the same blended table. Thanks in advance.
What about pivot tables?
This function doesn't work properly for me in my blended data source. For some reason, the default aggregation is disabled.
Is it possible to use this slider for dates like power BI? so that user can easily slide in between the dates
Currently in data studio you can only use numeric values in slider.
what if i have more than one date in my data source, and i want to filter from a specific one
you can put that another date column as filter on your report page.
@@thedatamillennials how do i do that?
Hi Rebeca, if you are still struggling, then i would request you to please get on a quick call, so that i can help you to sort it out.
I have a similar question: how can I use two different date columns in the same date range control? Sthn like a calendar table.
thanks
You're welcome! 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
I didn't know it is that simple by re-designing the pivot table format! Million thanks! I have been silly the whole time :D
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:- [email protected]
Thank you
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:- [email protected]
Stupid video need how to prepare data/
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.
What if i want to sort column A and i want the corresponding data in column B will go along with it.
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:- [email protected]
how to save union data into a new table?
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.
Dear Atul... How if I want to count multiple values in one cell using Looker Studio. For example | Date | Category | |2024-5-5 | P1;P2;P3 | |2024-4-3 | P1;P3;P4 | |2024-3-3. | P2;P4 | |2024-2-2 | P1;P3 | I want to show data, how many P1, P2, P3, P4 for some period of time. Fox example: |Category. | Total. | %. | |P1 | 3 | 30%| |P2 | 2 | 20%| |P3 | 3 | 30%| |P4 |. 2 | 20%| Total | 10 | 100%| Thank. you
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.
No
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:- [email protected]
Is the quality ❤ i would like to share this video every in my status
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:- [email protected]
Thank you, this was a lifesaver
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:- [email protected]
Hi! Do you know how do I get the max value of the another column? Example, If I have three competitors, want to know the price of the leader (most sales) competitor. Thank you.
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.
thanks
I set the 15 minitues schdule. but its not working. could you tell me whats problem please.
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:- [email protected]
@@thedatamillennials issue solved. thanks for your reply
Welcome brother
It would be better if you can create one folder kind of structure for this all interview question. It would be easy to access.
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:- [email protected]
I've been practice SQL query since last few days. All the resources were confusing me as it shows all the different ways to write highest salary. Thank you so much for putting all the basic possible ways to write this query. Much needed.
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:- [email protected]
I love love love this so much ! Thank you for your video.
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:- [email protected]
This only happens when the user is an Editor, how about user when he has been given Viewer access and needs the background Data- Everyone using a Dashboard can't be given Editor access.
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:- [email protected]
How can I select multiple items in the drop down?
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:- [email protected]
Thank youuuuuu
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
What if we use limit instead of row number?
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:- [email protected])
Thank you 😊
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
Excellent Video. Practical 👏
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
i have find laterally good source best channel ....❤
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:- [email protected]
Thank you so much
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:- [email protected]
can we add multiple variables. like internet users And total Population . also can we add statistic data labels to locations
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:- [email protected]
Thank you very much
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:- [email protected]
Thank you! This addressed all the issues that I was having trouble resolving!
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:- [email protected]
Thank you so much, it's been taking years to know this 🥹
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:- [email protected]
Good 👍
thankyou
👍👍
thankyou
👍👍
thanks
👍👍
thanks
👍👍
thanks
👍👍
thanks
👍👍
thanks
👍👍
thanks
👍👍
thanks
👍👍
thanks
👍
thanks