- 61
- 9 458
Seraphim1176
India
เข้าร่วมเมื่อ 10 พ.ค. 2021
Welcome to my data analysis channel, where we dive deep into the world of data and empower you with Excel knowledge. This channel is dedicated to helping you master the art of data analysis using Excel as your trusted tool.
I cover wide rang of topics about Excel functionalities, from basic formulas and functions to advanced data manipulation and visualization techniques. We believe that Excel is a powerful tool that can unlock endless possibilities in data analysis, and we're here to demystify its complexities.
I also cover the data analysis concepts including data cleaning and preparation, statistical analysis and data visualization. Our goal is to equip you with practical Excel skills that you can apply in real-world scenarios, enabling you to make data-driven decisions with confidence.
Join our community and embark on a data analysis journey that will transform the way you work with data. Let's unlock the true potential of Excel together.
I cover wide rang of topics about Excel functionalities, from basic formulas and functions to advanced data manipulation and visualization techniques. We believe that Excel is a powerful tool that can unlock endless possibilities in data analysis, and we're here to demystify its complexities.
I also cover the data analysis concepts including data cleaning and preparation, statistical analysis and data visualization. Our goal is to equip you with practical Excel skills that you can apply in real-world scenarios, enabling you to make data-driven decisions with confidence.
Join our community and embark on a data analysis journey that will transform the way you work with data. Let's unlock the true potential of Excel together.
Module 30 - Transforming Data with Interactive Dashboards in Excel
Module 30 - Transforming Data with Interactive Dashboards in Excel
มุมมอง: 137
วีดีโอ
Module 29 - Interactive Dashboard in Excel ( Continued)
มุมมอง 1163 หลายเดือนก่อน
Module 29 - Interactive Dashboard in Excel ( Continued)
Module 28 - Interactive Dashboards in Excel (Part - 1)
มุมมอง 3684 หลายเดือนก่อน
Module 28 - Interactive Dashboards in Excel (Part - 1)
Module 21 - Treemap and Sunburst Chart in Excel
มุมมอง 584 หลายเดือนก่อน
Module 21 - Treemap and Sunburst Chart in Excel
Module 20 - Progress circle donut Charts in Excel
มุมมอง 784 หลายเดือนก่อน
Module 20 - Progress circle donut Charts in Excel
Module 19 - Guage/Speedometer in Excel
มุมมอง 1024 หลายเดือนก่อน
Module 19 - Guage/Speedometer in Excel
Module 18 - Pie Charts and Donut Charts
มุมมอง 664 หลายเดือนก่อน
Module 18 - Pie Charts and Donut Charts
Module 17 - Regression Analysis in Excel
มุมมอง 604 หลายเดือนก่อน
Module 17 - Regression Analysis in Excel
Module 14 - Data Distribution using Histogram
มุมมอง 324 หลายเดือนก่อน
Module 14 - Data Distribution using Histogram
Module 13 - Area Chart and Stacked Area Chart
มุมมอง 314 หลายเดือนก่อน
Module 13 - Area Chart and Stacked Area Chart
Module 11 - Bar Charts and Stacked Bar Charts
มุมมอง 194 หลายเดือนก่อน
Module 11 - Bar Charts and Stacked Bar Charts
Module 10 - Charts and Pivot Bar charts
มุมมอง 734 หลายเดือนก่อน
Module 10 - Charts and Pivot Bar charts
Module 8 - Trendline and Sparkline in Excel
มุมมอง 304 หลายเดือนก่อน
Module 8 - Trendline and Sparkline in Excel
Module 7 - Reading complex JSON files in Excel
มุมมอง 484 หลายเดือนก่อน
Module 7 - Reading complex JSON files in Excel
Module 5 - Searching and filtering in excel
มุมมอง 334 หลายเดือนก่อน
Module 5 - Searching and filtering in excel
Module 4 - WHAT-IF Analysis, Goal seek, WEEKNUM and DATEDIF Functions
มุมมอง 224 หลายเดือนก่อน
Module 4 - WHAT-IF Analysis, Goal seek, WEEKNUM and DATEDIF Functions
Module 3 - Advanced Conditional formatting
มุมมอง 354 หลายเดือนก่อน
Module 3 - Advanced Conditional formatting
Trim()
Any video on Capacity plan template creation please ?
Hi, I need help with capacity planning for call center
very helpful...
How to transpose the value present in first record in form as row ?
Apologies for the delayed response. I will check and get back to you by today
My output_df.head() didn't yield scores, just 0s and Nan, only displaying the first row. What could be the reason, please?
Please make sure all the neccessary libraries are installed - especially Panda library as pd implies panda - and try entering the below command to check if you are able to get the expected output. output_df = pd.DataFrame(columns=["column1", "column2"]) print(output_df.columns) Hope this helps
@@Sheet-Symphony I actually got this: FutureWarning: The behavior of DataFrame concatenation with empty or all-NA entries is deprecated. In a future version, this will no longer exclude empty or all-NA columns when determining the result dtypes. To retain the old behavior, exclude the relevant entries before the concat operation. output_df = pd.concat([output_df, pd.DataFrame({"ID": ID, "REVIEWS": REVIEWS, "POSITIVE_SCORE":
I did adjust using out = pd.concat([df, output_df]) but got sensitivity indexes with 'Nan' values in the model result. The ID and Reviews columns are okay.
Please you need to be a bit consistent .. been looking for more of WFM related things and you are gone forever :(
I am working on a project and will upload videos on forecasting and planning ASAP
@@Sheet-Symphony thank you so much .. looking forward to your knowledgeable video's.
Thank you so much! This was very helpful, exactly what I was looking for. Great explanation
Hello could you please let me know about the missing values in the data? Which approach did you follow in order to dela with the missing values?
Please let me know which missing values are you referring to, it would be great if you can mention the time stamp of the video where you need clarification.
@@Sheet-Symphony as I have mentioned am referring to the missing values in the dataset..i.e about the data cleaning process..few of the values in the dataset are missing..isn't it? How did you deal with them?
@@shruthiganesh6464 please refer my other video - End-to-End Project - Resume Project Challenge 5 - Tourism Insight - I have shown how to get the processed data for analysis and how to consolidate the data which includes missing values, what to consider and what to ignore.
Where can we find this template to try for ourselves? Have you made it available yet?
Sample dataset is available in my github link - github.com/travoholicspirit/Exploratorydataanalysis
why did you choose 14000 and 9000 in conditional formatting. pls tell
Hi, Thank you for your question. If you see the call patterns or use Max function of all the call volume numbers and Min function for all the numbers, we will get the maximum call volume number average as 14000 and minimum call volume average as 9000 - I did not use the max function and min function - I just observed the numbers manually and found the rough number for maximum value and minimum value to check if the call patterns based on max and min values.
👍
It was a very helpful video. Thank you very much. Waiting for more videos in details of Forecasting.
Thank you for your comment, means a lot. I will upload some more end-end projects on forecasting. Thanks again
Thank you 😊
Can you send dashboard link 🖇️
please go to my github repository to find the PowerBI file and datasets- github.com/travoholicspirit/Tourismproject
can you send me datasets
please go to my github repository to find the PowerBI file and datasets- github.com/travoholicspirit/Tourismproject
As per chatGPT: My responses are based on information available up until September 2021. Therefore, I don't have access to the specific estimated population numbers of Telangana districts for the years 2019 and 2020 based on the data from the Telangana government. There is no way get the data from chatgpt. Please explain how to get the data and show us in the video.
Sure..i tried many keywords to get the output from chatgpt..i will make a video of what to enter to get the projected population data from chatgpt
Thank you for watching this video
My request : can you please help me get project population for Telangana state districts wise for either 2019 or 2020 ChatGPT: Certainly, here is the estimated population for Telangana state districts based on Census 2011: Districts Population (2011) Adilabad 2,737,738 Bhadradri Kothagudem 1,066,656 Hyderabad 3,637,483 Jagtial 983,187 Jangaon 541,952 Jayashankar Bhupalapally 666,168 Jogulamba Gadwal 654,621 Kamareddy 972,625 Karimnagar 1,005,711 Khammam 2,565,412 Komaram Bheem Asifabad 515,835 Mahabubabad 797,747 Mahabubnagar 1,494,107 Mancherial 807,037 Medak 767,428 Medchal-Malkajgiri 2,933,098 Nagarkurnool 927,140 Nalgonda 1,618,416 Nirmal 709,418 Nizamabad 1,571,022 Peddapalli 795,332 Rajanna Sircilla 599,903 Ranga Reddy 5,296,396 Sangareddy 1,502,138 Siddipet 1,524,057 Suryapet 1,099,560 Vikarabad 927,140 Wanaparthy 518,776 Warangal Rural 753,756 Warangal Urban 1,129,299 Yadadri Bhuvanagiri 1,448,738 Please note that these figures are from Census 2011, and the actual population of the districts may have changed since then. For more up-to-date information, you can refer to the official websites of the Telangana government or the Indian Census Bureau. User These are the number according to the 2011 census report, please help me get the projected population number district wise for 2018 or 2019 or 2020 ChatGPT 2 / 2 I apologize for the confusion in my previous response. Here are the estimated population numbers for Telangana state districts as of 2020, based on data from the Telangana government: Districts Population (2020) Adilabad 725,313 Bhadradri Kothagudem 1,106,331 Hyderabad 10,004,144 Jagtial 852,656 Jangaon 512,539 Jayashankar Bhupalapally 612,638 Jogulamba Gadwal 634,472 Kamareddy 1,038,014 Karimnagar 1,116,227 User Please re-generate the previous response of with 2019 and 2020 district wise population details of telangana state ChatGPT Sure, here are the estimated population numbers for Telangana state districts as of 2019 and 2020, based on data from the Telangana government: Districts Population (2019) Population (2020) Adilabad 708,972 725,313 Bhadradri Kothagudem 1,086,240 1,106,331 Hyderabad 9,787,707 10,004,144 Jagtial 831,328 852,656 Jangaon 498,290 512,539 Jayashankar Bhupalapally 595,207 612,638 Jogulamba Gadwal 616,302 634,472 Kamareddy 1,006,362 1,038,014 Karimnagar 1,081,846 1,116,227 Khammam 1,501,968 1,532,054 Komaram Bheem Asifabad 498,925 510,008 Mahabubabad 752,568 772,345 Mahabubnagar 1,411,985 1,444,334 Mancherial 766,877 785,607 Medak 722,354 740,033 Medchal-Malkajgiri 2,772,492 2,837,425 Nagarkurnool 881,747 902,708 Nalgonda 1,536,324 1,570,073 Nirmal 677,291 693,857 Nizamabad 1,520,322 1,554,507 Peddapalli 771,413 790,834 Rajanna Sircilla 576,523 591,054 Ranga Reddy 5,074,982 5,190,908 Sangareddy 1,451,582 1,486,856 Siddipet 1,478,346 1,514,145 Suryapet 1,067,971 1,093,344 Vikarabad 899,423 921,009 Wanaparthy 504,125 516,189 Warangal Rural 733,618 751,185 Warangal Urban 1,100,983 1,126,841 Yadadri Bhuvanagiri 1,416,287 1,448,738 Please note that these figures are estimates and may differ from actual population numbers. User: Mulugu and Narayanapet 2019 projected populations is missing from the above list, please help me get the data ChatGPT I apologize for the oversight in my previous response. Here are the estimated population numbers for Mulugu and Narayanpet districts in Telangana state as of 2019, based on data from the Telangana government: Districts Population (2019) Mulugu 228,385 Narayanpet 382,959 Please note that these figures are estimates and may differ from actual population numbers. Regenerate response
You hardwork is quit appreciated....your projects based on real world data ...but a thing is, teach and apply each step instead of bringing a copy paste code.. Keep your screen visual good and clean for better understanding. ...on Power BI dashboard...Data processing is very important step otherwise new people will not be benefited... Bring teaching attitude in your style and things need more explanation for better understanding... Keep it..
Thank you for your feedback..i will definitely implement your advice in my next videos and make the video more detailed and comprehensive for any new learners to understand