- 37
- 55 132
Corporate Skiller
India
Приєднався 26 вер 2013
Learn skills for the daily work.
This channel intends to make learning of tools used for corporates simple, and easy by making videos which are small, and simple to understand. This channel would cover different tools used in corporates on a day to day basis by analysts and others like Power BI, Excel, VBA Macros, SQL, Power Automate and many more
We also have a special playlist on ESG/ Sustainability, which talks about topics in ESG and also about career opportunities in ESG.
I can also help you to create awesome dashboards. You can reach out to me on my fiverr account to place a order request for the same.
Link to my fiverr profile- www.fiverr.com/s/zKEAev
You can reach out to my linkedin profile- www.linkedin.com/in/pavankumar-shetty-8b4697a2/
#corporateskiller #Powerbi #Excel #Macros #Tuturials #Beginners #powerbidesktop #educational #microsoftoffice #Productivity #corporate #analytics #esg #ghgaccounting #ghg #emissions #sustainability #career
This channel intends to make learning of tools used for corporates simple, and easy by making videos which are small, and simple to understand. This channel would cover different tools used in corporates on a day to day basis by analysts and others like Power BI, Excel, VBA Macros, SQL, Power Automate and many more
We also have a special playlist on ESG/ Sustainability, which talks about topics in ESG and also about career opportunities in ESG.
I can also help you to create awesome dashboards. You can reach out to me on my fiverr account to place a order request for the same.
Link to my fiverr profile- www.fiverr.com/s/zKEAev
You can reach out to my linkedin profile- www.linkedin.com/in/pavankumar-shetty-8b4697a2/
#corporateskiller #Powerbi #Excel #Macros #Tuturials #Beginners #powerbidesktop #educational #microsoftoffice #Productivity #corporate #analytics #esg #ghgaccounting #ghg #emissions #sustainability #career
BOOKMARKS in PowerBI | Navigating Dashboard using Bookmarks and Buttons in PowerBI | Sales Dashboard
Video on BOOKMARKS in PowerBI is a PowerBI tutorial for beginner, and aims to clarify the concept of PowerBI bookmarks.
This Video Tutorial on PowerBI is divided into sections below:
1:20: Activating bookmarks & creating bookmarks
2:00: Adding bookmarks into buttons for navigation
2:45: How bookmarks forms basis for navigation within dashboard
Please like and subcribe to my channel for more videos
#corporateskiller #datavisualization #powerbi #bookmarksinpowerbi #powerbidesktop #bookmarks #dashboard #tutorialforbeginner #tutorial #videotutorial #educational #careergrowth #dataanalysis #powerbi_training #navigation This channel intends to make learning of tools used for corporates simple, and easy by making videos which are small, and simple to understand.
This channel intends to make learning of tools used for corporates simple, and easy by making videos which are small, and simple to understand. This channel would cover different tools used in corporates on a day to day basis by analysts and others like Power BI, Excel, VBA Macros, SQL, Power Automate and many more
You can reach out to my linkedin profile- www.linkedin.com/in/pavankumar-shetty-8b4697a2/
#Skilldevelopment #Careergrowth #Professionaldevelopment #Leadershiptraining #Timemanagement #Projectmanagement #Innovation #Businessstrategy
This Video Tutorial on PowerBI is divided into sections below:
1:20: Activating bookmarks & creating bookmarks
2:00: Adding bookmarks into buttons for navigation
2:45: How bookmarks forms basis for navigation within dashboard
Please like and subcribe to my channel for more videos
#corporateskiller #datavisualization #powerbi #bookmarksinpowerbi #powerbidesktop #bookmarks #dashboard #tutorialforbeginner #tutorial #videotutorial #educational #careergrowth #dataanalysis #powerbi_training #navigation This channel intends to make learning of tools used for corporates simple, and easy by making videos which are small, and simple to understand.
This channel intends to make learning of tools used for corporates simple, and easy by making videos which are small, and simple to understand. This channel would cover different tools used in corporates on a day to day basis by analysts and others like Power BI, Excel, VBA Macros, SQL, Power Automate and many more
You can reach out to my linkedin profile- www.linkedin.com/in/pavankumar-shetty-8b4697a2/
#Skilldevelopment #Careergrowth #Professionaldevelopment #Leadershiptraining #Timemanagement #Projectmanagement #Innovation #Businessstrategy
Переглядів: 154
Відео
Drill through in power bi | Cross report function in power bi | Using Live Power bi Dashboard
Переглядів 67211 місяців тому
This power bi video tutorial will show how to use the cross reporting feature/ drill through feature in powerbi. Video tutorial in power bi desktop will help you understand : 00:14: Introduction on drill through in power bi 01:15: More on drill through feature 01:30: Enabling drill through in power bi desktop 02:00: Creating new tab in power bi desktop 02:40: Drill through options 02:45: Keepin...
How to be successful in life motivation?
Переглядів 264Рік тому
Welcome to our corporate motivation journey! In this powerful video, we delve into the secrets of igniting motivation within your team and creating a thriving, high-performing workplace. Join us as we uncover the best practices, strategies, and techniques used by leading organizations to inspire their employees and drive success. 🎥 Watch the full video to: Learn how to foster a positive work en...
Job opportunity Work as a Analyst, Procurement Analyst, Strategic Sourcing
Переглядів 293Рік тому
This video is part of the larger video series, where we will look at career opportunities after MBA. Are you ready to embark on an exhilarating career journey after completing your MBA? Look no further! In this thrilling video, we will dive deep into the world of sourcing and procurement analysis, uncovering the remarkable opportunities that await you. Join us to know more on Sourcing analyst/ ...
Power BI Dashboard in Hindi | Tender Analysis| Saving Analysis | Case study | IN HINDI
Переглядів 683Рік тому
Welcome to our comprehensive Power BI tutorial, where we'll take you on a journey from Excel to stunning interactive dashboards. In this video, we'll cover everything you need to know to harness the full potential of Power BI Desktop. From importing and transforming data to linking datasets and building powerful visuals, you'll learn how to create compelling reports and gain valuable insights. ...
LIVE SESSION: POWER BI DASHBOARD CREATION: 27th May - 11 AM IST
Переглядів 31Рік тому
Get ready for an exciting PowerBI session where we'll create a dynamic dashboard from scratch! Join me live on UA-cam as we delve into the world of data analysis and visualization. Save the date: Saturday: May 27, 2023 Time: 11 AM IST To participate, simply register for the session using the following link: lnkd.in/gnky49zT During the session, we'll focus on a procurement case study, exploring ...
Boosting Insights: How to Analyze Average Sales per Return Customer in Finance Using DAX Measures?
Переглядів 211Рік тому
In this tutorial, you'll learn how to leverage the power of DAX measures to calculate and analyze average sales per return customer in finance. We'll cover step-by-step instructions on how to use DAX measures to filter data and calculate the average sales amount for each customer who has made a return purchase. This will give you valuable insights into your customers' purchase behavior and help...
Row level security in power bi: Use Row-Level Security for limiting user Access
Переглядів 862Рік тому
In this tutorial video, you'll discover how to protect your Power BI dashboard with Row-Level Security. In this tutorial, we're taking an example, where we have Global sales data and we want to limit the visibility of the data as per country. How do we do this? 1:00: We create a table with Sales as per different products 1:30: We go into Mange roles & create different roles as per country 3:00:...
Transforming Daily Sales Data into Weekly Sales Reports with Power BI
Переглядів 16 тис.Рік тому
Transforming Daily Sales Data into Weekly Sales Reports with Power BI
Career in Sustainability | ESG career | Exploring Job Opportunities |Trends in the Sustainability
Переглядів 11 тис.Рік тому
Career in Sustainability | ESG career | Exploring Job Opportunities |Trends in the Sustainability
How to Use SUMX to Create Efficient Power BI Dashboards with DAX Measures
Переглядів 869Рік тому
How to Use SUMX to Create Efficient Power BI Dashboards with DAX Measures
Simplifying Data Analysis: How to Conditionally Format Cards in Power BI in Less Than One Minute
Переглядів 152Рік тому
Simplifying Data Analysis: How to Conditionally Format Cards in Power BI in Less Than One Minute
CREATE a Simple POWER BI DASHBOARD using ADD NEW COLUMN, CARD and SLICER
Переглядів 117Рік тому
CREATE a Simple POWER BI DASHBOARD using ADD NEW COLUMN, CARD and SLICER
How to use vlookup in excel ? | Names in both the tables doesn't exactly match
Переглядів 105Рік тому
How to use vlookup in excel ? | Names in both the tables doesn't exactly match
How to connect 2 or more datasets or tables? Creating Relationships between Multiple Datasets
Переглядів 3,1 тис.Рік тому
How to connect 2 or more datasets or tables? Creating Relationships between Multiple Datasets
Excel to Power BI: How to Load Data and Create Charts
Переглядів 13 тис.Рік тому
Excel to Power BI: How to Load Data and Create Charts
What is PowerBI? Guide to Downloading & Installing Power BI Desktop
Переглядів 274Рік тому
What is PowerBI? Guide to Downloading & Installing Power BI Desktop
How to call our target work num to child datasets in detail report 😮
Could you please explain it more?
@corporateskiller5825 can you please make video on how to create detail report in birt,
With mulipule datasets
@@ri-tl8eh Yes, will be creating more videos , dealing with reports from multiple datasets
@corporateskiller5825 I am eagraly waiting
Hi, I have a postgraduate degree in Environmental Science and Management. Is it possible for me to build a career in ESG? If so, could you please let me know how? Thanks in advance.
Hi Anjali, Surely, you can pursue a career in ESG as you've background in Environmental science.
Icompleted the bcom I can do the esg for the job
You can do, but you might to either gain experience in the same field or do some certifications for having an understanding of esg
What about Environment law and journalist
Hi @sanuktakaran yes they both have good opportunities
@@corporateskiller5825 how to proceed ?
Hi sir, I’m a mining engineer and I have been working in several mines from last 6 years. If I want to switch to ESG, do I need to start from getting degree in environmental engineering or can I directly take courses and concentrate on certification part.
Certifications would help. However, it also depends a lot on your career ambitions. If you want to pursue a career in sustainable technological development then your background in engineering would be great importance, but if you're thinking of switching towards reporting then it would need certifications and a completely new career direction
I am currently working with banking industry and i want to do CFA ESG certificate.so is this help me to get good job ???
Where to do this course suggestions please
You can go to unccelearn.org/ for courses on ESG
Pl make videos on Scope 1, 2 & 3.
Sure, I will make it😊
Hi sir can u please make video on end to end project with large data set using direct query in power bi??
Hi, sure, I will make a video with large data sets, keep supporting my channel
@@corporateskiller5825 okay sir
Can a finance student apply for this ESG data analyst?
Yes you can..
@@shubhendugautam3491 okk
Sir i m law Graduate how to work in sustainability field.... Scope n future
Scope is there, but you would need to do some research, if the individual goal match with the skill sets required for the role
I am a CA......what can I do in ESG in India?
Hi Ritvik, there are few certifications which are free offered by UN learning platforms, which you could start with to learn more about ESG
Did you get all the information about this course? I was also thinking of doing this course but did not know where to get this information.
@@szhhzhz no
Please reduce bgm
Thank you for your feedback, will keep that input for upcoming videos
Nicely explained👌
Thanks a lot 😊
I am interested in esg specialist. But where can we free course for this. I am from sustainable background and wanted to do certification also can you tell about importance of certification. And to become esg specialist what exams we have to gives what are the skills sets one should have. And where can get materials for esg specialist exam. Thanks
Uncc learning portal is where you can get the free courses, but certifications like auditor certification is something, needs investment, but would require substantial investment
@@corporateskiller5825 thank you
Hello, Sir I am a Petroleum Engineer & Doing job as an Energy Analyst (Includes Collecting Esg Datas), What Are options for me to get into proper esg Field? Can you tell me?
Certifications could be helpful to get into ESG space, however, would advice you to research properly before deciding to jump in to these courses, as these courses have high investment and getting job on basis of this is not assured, alternatively grow career wise in your field and do some ghg accounting audit certifications
@@corporateskiller5825 thanks!
good explanation bro
Thank you!
Sir make video on scope 2 and 3 also
Sir please make videos on all the 3 scopes
Sure! Please subscribe to my channel for encouragement 😊
🙂 *promo sm*
Here we can also use the concat funcation by concating year with the week no.. am i right ?
Yes, you can use that to concatenate year with week no. Please do subscribe to my channel to support us.
@@corporateskiller5825can you make a video on daily work of Power vi developer and Data Analyst..like how they make reports on the data
Hi Pavan, I wish to connect with you for more insights related to the procurement and supply chain profile. Can you please share your email ID?
Hi, yes, my email I'd is shettypavankumar1@gmail.com, but you could also check one of my video which is in hindi, it has a procurement case study
Good videos if someone is looking to explore the vertical 👍🏻👍🏻
Thanks for your support Mohit!!
I have weekly sales data in different sheets. Like, I have weekly sales data for year 2011 and 2012. Each week sales data has its own sheet. I'm given with current week sales data too. The sheets I'm talking about consists dates and sales. My question how shall I deal with them? As I have to build weekly sales dashboard.
Hi Tabish, You can combine 2 identical tables in Power query by using Append queries and selecting both the tables. This will convert them into a single table
Please do subscribe to my channel to support us.
@@corporateskiller5825 will this impact redundancy? When I'll be modelling. Moreover, how to add new week tables to it. Is it good to make a folder out of it or combine them. I've subscribed to your channel.
If I combine them. Will it cost redundancy? And, as each weekly sale has 2000+ rows. Is it efficient to combine them all. As its weekly datasheet for 2 years.
Combining or appending would add all your rows below the current rows. So, we won't make cost redundant
I have the sales report of different products with date column run from left to right. Latest sales are being added in right most of the table as column. All power BI sales report examples come with one single set of date column running from top to bottom. What difference does it make if my sales report dates are from left to right?
You might have to rearrange it in power query from left to right to top-down. Go to power query editor, click all columns and click on Transpose. It will make columns run top down as you see in my video. Please subscribe to my channel for your support.
my "build a visual" pane doesn't show what yours does. I don't see the "add drill through visuals here" section. Im on version 2.124.1554.0 64-bit (December 2023)
Did you try adding the feature by going into the options as shown in my video? Once you do that, please close and reopen power bi desktop
I completed my graduation in hotel management.. to get into corporate world I did pgdm in financial management and now I m working as an accountant in a firm. Can I get jobs if I take online certifications in CFA esg or Garp csr
These certifications could be helpful to get into ESG space, however, would advice you to research properly before deciding to jump in to these courses, as these courses have high investment and getting job on basis of this is not assured
Hello Sir. I'm pursuing LLB. Are there any opportunities for lawyers in ESG ?
Hi, Yes, ESG involves regulation and to decode these regulations, understand the terminologies, implications, who better than lawyers!!
@@corporateskiller5825 Thanks Sir 👍🏻
Hi, Dear skiller, Find your video Good one Keep Going
Thank you for Support!!
Hi sir, what is the education qualification required for esg ? I am pursuing company Secretary course
Hi Shreya, in terms of educational qualifications to enter into ESG a degree in environmental education, Social studies, Policy making or even finance can help you get into ESG related roles in some consulting companies. There are some MBA colleges like XIMB, which also offers courses like MBA on sustainability. I would suggest you to do a basic research, however I can also create a separate video on ESG educational requirements. Please subcribe to my channel for videos on ESG.
Sure sir thanks! I have already done my mba in finance. Currently we have a subject in cs of esg . Would it be useful for me to attain a job as an esg analyst if i complete my CS
@@shreyas9065 Since you're doing MBA in finance and have a background in commerce, my suggestion would be to pursue career in finance related field and then if you still are drawn towards ESG then do some certification and move into ESG consulting in Big 4.
nice, your explanation was straightforward and helpful for creating filters that can be assigned to various users when publishing. I am wondering if that's the key or only advantage over using a slicer(s)?
Row level security is not just a filter, it is a way to only share the required information with the relevant stakeholders
Sir, can u share this sample datasets, since the one you posted aren't working.
I will share
Environmental sustainable analysis PG deploma job oppertunies please. Doing in canada
I think, it would need a little more research on the pros and cons
Please bring more videos
Sure, Sanyukta!Thanks for watching!
Different colleges and courses@@corporateskiller5825
@@corporateskiller5825 sir how can we connect to discuss career-related questions?
CSR comes under S or G?
CSR is related to social aspect, so it will. Come under S part
How to calculate sales per week without creating new column? Please explain it
Hi, will make a separate video on that, Thanks!
Hello sir , I'm doing my masters in social work and I'm looking forward to doing ESG is that suitable for my baground can i get better opportunities in future.
Yes, your educational background would be relevant in ESG especially the Social and governance aspect
Sir please more about career in esg@@corporateskiller5825
Hello sir , Currently I am in the field of data analytics So can I be an ESG analyst ?
Hi, Thank you for asking questions. Yes, there are ways to get into ESG analyst roles. Decarbonization topic would have maximum chance in the analytics side of ESG. Would suggest you to complete some courses on UNCC learn to get a basic understanding of ESG
Hi can you tell smthng more , is it a well paying career line ?
Super useful contant. Sir, i have done Environmental engineering and now preparing for masters in sustainability in Germany. According to you is it a good decision to do masters in Germany in sustainability course ? Note : I just want to study at there and don't want to ger PR !
Hi Dishant, Thanks for motivating me to create more content. Regarding doing masters in Germany, I would say, it would definitely add value in your resume. But do consider ROI( return on investment) as a factor as well.
I am a postgraduate in Botany. Can i pursue my career in ESG
Yes, people from Environmental fields have an edge. However, if you're deciding to pursue career in ESG, I would suggest you familiarise also with different standards and ungc principles, GRI and SASB .
Hi Can you do a walkthrough of ghg accounting methodology?
Hi, Thank you for the suggestion , I will make one video on this
Nicely used graphics . 👌
Thanks Jinu!!
Hi sir, Could you please provide this dataset for practice purpose. It's very useful to us.
Hi Rowthula, I have uploaded the file for you to practice. Link to the file -file.io/67aczYi8j8Ck. Please download before Jun, 22 before link expires. Also, please LIKE and SUBSCRIBE to my channel for more videos on powerbi and more
Tq, tnx alot
How to download the file, I cant find it.
@@rowthulaphani4473 file.io/T7dcAgo6Ynd6 (try this link) if it doesn't work please share your gmail id, i will share over email. Thanks!!
Hello Sir, how to gain the practical knowledge of GHG accounting? Can you suggest some resources or yourself share any information regarding it.
Hi Prachi, To gain knowledge on Ghg accounting, refer GHG protocol, you can download ghg corporate standards, it's a pdf and has the basics on Ghg accounting. I will also make videos on that in the coming weeks.
Do subscribe 😊
Nice video. A whole new vertical to explore for other than the traditional ones. Looking forward to more such videos.
Thank you Sumedh!!
Very nice 👌
Thankyou Jinu!
Great video, yes more videos would be helpful on making a career in ESG (on best affordable education options and path selection.)
Thanks Karishma, i will try to come up with a video on that!!
How is IGMPI institute for this new Delhi
Need more videos
Sure!!
I am unable to see select load... Wt should I do
You should be able to see load . But in case you're not able to see, try to update the power bi desktop by downloading again. If still not able to see, then please use transform option and then close and apply.
Hello Brother The data set is having the sales column. But after loading the data into the power bi it shows sum of the sales. So that the values in the data set differ from the values of the chart created in power bi. Is it ok, how to get the only sales insted of sum of sales. please clarify my dought.
Hello Brother, Thanks for checking in, we have imported data into power in the same format as in the Excel file, if you see the video around 5:50 mins. The point you're referring too, is actually a aggregation function. So, when we use charts for visual representation, there are some columns in the table which becomes the x or y column of the chart and then there are some data like for instance sales in this case. When we add sales into values of the chart, it will aggregate it as per the columns in x or y axis and by default it will take sum function. We can also convert it to count, average etc. You would get a much better idea when you play around after downloading the power bi desktop..i hope my response was useful to you..Thanks!!