शैडोइंग अभ्यास: Data Analysis Essentials in Excel - वीडियो के साथ अंग्रेजी बोलना सीखें

अभ्यास मोड चुनें

हर मोड पूरी स्क्रीन का अभ्यास कक्ष खोलता है।

190 वाक्य

यदि वाक्य बहुत छोटे या लंबे हों, तो समायोजित करने के लिए Edit पर क्लिक करें।

Suppose you've received a large data set, it's unformatted and messy, and your manager is asking you some questions about it.

Hey, I have some doubts here.

Do you have a second?

So to answer his questions, we'll go over three essential data analysis skills, which are data cleaning, analysis, and data visualization.

So let's get into it.

Here's the Excel file, which you can download for free in the video description.

We need to make a few changes to the data set like suppose we want to merge the first

and the last name into one column we want to go ahead

and change the formatting of the sales persons here

so it's a bit more consistent

and a bunch of other things now the fastest way to do

that is using power query for that we're gonna head over to data

and under the data tab you'll see this get

and transform data area

and just click on from table slash range it should select the whole data set for us

and we'll just hit on okay there

and from here it's gonna load up the power query editor

this is really where we're gonna make all of the data cleaning changes

it's a lot faster than doing it using just excel

so the first step when cleaning data is to remove any duplicates

so under the order id

if there's more than one order id with the same number then it's probably a duplicate

so we can just right click on it

and hit on remove duplicates whenever we make a change it's going to be recorded under applied steps here

so you can always go back or you can even remove it

if you wanted to then for the dates they're currently formatted as numbers you can see over here

that it says whole number under date type so let's go ahead

and click on it and change that to a regular date

and you'll see that

that changes automatically to the normal date format then we said we wanted to merge the first name

and the last name

so select both columns by hitting the ctrl key we have both selected there

and then we just need to go to right click

and we'll go to merge columns from here we want a separator

which is just going to be the space sign for us

and we want to go ahead and call this something like names

and hit on okay and you'll see how we've been able to merge the first name

and the last in just a few clicks

if we keep scrolling through the data another thing

that stands out here is that the units have decimals so

if we're selling an item we should sell it in whole not a portion of it

so let's go ahead and switch this up by going over to transform

and from here you'll find the rounding under number column

and we want to go ahead and change

that to just rounding it up and you can see there

that we have the whole number one final thing

that we want to change is all of these salesperson column where they're not very well formatted

so we can head over to format under the transform ribbon as well

and first we want to go ahead and capitalize just each letter

so the first letter of a word like so

and we also want to trim these spaces

so we can go back under format and just click on trim now that's looking a lot better

now to go back to excel from here we just need to go over to the home tab

and then hit on close and load

and this is going to apply all the changes that we've made

so you can see here that it's created a new tab for us

and this time it has everything cleaned up we have the queries

and connections case we ever want to go back to it we can just right click

and hit on edit but we don't right now

so we'll just close out of

that later in the video we'll look at creating some awesome visuals but before

that let's get into the analysis section where our manager is

asking us some questions about the data hey thanks for cleaning up the data

if you don't mind can you summarize the revenue column

so here he's probably trying to understand what the average revenue is what the minimum

or maximum is and so on

so it's basically this whole revenue column here

now we can do this with individual formulas like the sum the average

and so on but there's a better way to do

that that's by going to the data ribbon

and then you'll find this data analysis option if you don't find

that just go over to right click

and click on customize the ribbon then head under add -ins

and you're going to want to select the analysis tool pack hit on go

and select it from here obviously I already have it for now so I'm just going to click inside of it

once we get this pop -up we want to head to an area called descriptive statistics

which is this one here

and hit on okay this is going to summarize all of our revenue data

so for the input range we want to select all our revenue numbers

so just ctrl shift down there

and then for the output let's say we just want it on top to the to the right here

so let's say i just put it on m2

And then I'm just going to put summary statistics.

That's going to give us all the information we want and hit on OK there.

And you can see that it's created this whole set of statistics from, hey, what's our main revenue?

What's our minimum, our maximum, the total revenue, the count and a ton of other useful data.

Awesome.

Thanks for putting this together.

Can you also show me the breakdown of revenue by salesperson?

We can do this by creating a pivot table

so just go ahead and select inside of the data go over to insert

and just click on pivot tables hit on okay there

and it's going to create a new tab where we can analyze

it then under pivot table fields let me just drag this along

so we can see it better we're gonna want to add the revenue

so that's gonna be over under values

and we're also going to add the salesperson that's gonna be under the rows

and now we have that full breakdown

but as you can see it's not really in order here

100

so we can right click on it go to sort

101

and sort largest to smallest

102

and it seems like anna has been the best performer for us thanks for

103

that now for our next marketing campaign we're trying to see

104

if we should target more of a male

105

or female audience do you have a breakdown for

106

that for this we can still use pivot tables

107

so let's go ahead and select this first one ctrl c to copy

108

and just paste it down below with ctrl v

109

and now we're gonna make all the changes

110

so this time instead of the salesperson and the rows we're gonna remove it

111

and let's add the gender in here

112

so we have the sum of revenue maybe we also want to see the units

113

so let's go ahead and drag

114

that in as well based on this you can see

115

that we should probably target females more as they're the bigger part of our audience

116

we can also get the proportion so the percentage here simply by right clicking on it

117

and then show values as a percentage of grand total

118

so with that you can see that we have 53 percent almost

119

that are female relative to around 47

120

that are male this is great thanks a lot for your help awesome

121

we can pretty much get any information on our data using pivot tables

122

but there's another ai tool that excel introduced

123

so let's take a look at it we'll head over to the table here under table one

124

and this time instead of going to pivot tables

125

we're gonna go under the home ribbon all the way to the right where it says analyze data

126

so let's click on that it's basically gonna create a q a box

127

and within it we can ask anything

128

so before we did a pivot table to find the revenue by salesperson we can also ask it here

129

so revenue by salesperson hit enter there and you can see

130

that we get the exact same breakdown so that's an awesome ai tool

131

that you might find handy and

132

if you want to learn even more about data analysis you can check out our excel for business

133

and finance course using the link in the description below

134

we won't just go over data analysis though we'll also cover

135

formatting best practices shortcuts building awesome visuals dashboards creating large dynamic financial models

136

and much more and

137

if you get stuck along the way

138

you can always ask us the course instructors any questions in the discussions forum and

139

if you want more than just excel

140

we also have several other courses on power bi AI financial accounting corporate finance

141

and more if

142

that sounds interesting check out the link in the description below all right back to the video now

143

that we've cleaned up and analyzed the data let's look at how to visualize it

144

and one of the easier ways to do that is using conditional formatting

145

so you can see over here that we have the the breakdown

146

that we did earlier with the revenue by salesperson

147

and suppose we want to visualize these numbers over here a bit better we can go ahead

148

and select them and then just go over to conditional formatting under the home ribbon

149

and then we'll select the data bars let's say we go for a red one over here

150

and you can see how easily we can tell the proportions now

151

and just how much anna brought in in revenue another great visual for data analysis is a scatter plot

152

so over here we have the cleaned data set

153

and suppose we want to see if there's a relationship between age

154

and revenue maybe older people tend to spend more money

155

so let's go ahead and select both just by clicking on the h here

156

and hitting ctrl shift down arrow then we'll go back up

157

and for the revenue we want to keep hitting that control key

158

so we also have this selected and again ctrl shift down from here we'll go over under insert it.

159

and right in the center here under charts we're gonna want to select the scatter

160

so this one right over here to drag this back up just hit ctrl x

161

and then scroll up to the top

162

and let's say i put it over here to the side with ctrl v

163

so it does seem like there's a bit of a trend where the older

164

they are the more money they're spending we can look at

165

that closer with a trend line just by right clicking

166

and going to add trend line it does look upward sloping we can even go ahead

167

and add the display equation so that we can see the numbers more precisely

168

so here's the equation and basically what this is telling us is

169

that for every increase of one year in age revenue goes up by around 340 dollars

170

so overall it's fair to say

171

that the older they are the more

172

they're going to spend one final visual we'll look at is a box plot

173

which is great for finding outliers in the data

174

so over here let's suppose

175

that we just take the revenue by hitting ctrl shift down then we're gonna head over under insert again

176

and this time under the very center here we're gonna click on

177

that and go to the box

178

and whisker i realize this is a funny looking chart

179

so let's go over and explain what it's saying

180

so the line right here

181

which is quite small is the median the x is gonna be the average for us then these top

182

and bottom parts are the extremes and these two here are the quartiles the first

183

and the third quartile and

184

if we had any outliers they would be showing us dots up over here

185

or down over here just to show you quickly let's say

186

i put another zero in here i'm just gonna put a huge number you can see

187

that it starts to show as an outlier there let me go back

188

so you can see this again for more on data analysis check out

189

this video over here going over five awesome data analysis tools

190

or take our excel course over here and i'll catch you in the next one

ऐप डाउनलोड करें

धाराप्रवाह बोलने के लिए ज़रूरी सब कुछ

AI उच्चारण स्कोरहर वाक्य का स्कोर

IPA अभ्यासहर ध्वनि में महारत

शब्दावलीअपना शब्द भंडार बनाएँ

शब्द गेमखेलते हुए सीखें

QR स्कैन करें

Download on theApp Store Get it onGoogle Play

FOR YOU

अनुशंसित वीडियो

220 वाक्य

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Daily ConversationUniversity Students

236 वाक्य

How I Consistently Study with a Full Time Job: My Scheduling Formula

Daily ConversationUniversity Students

310 वाक्य

Analyze SEC filings with Transformers for fun and profit

Daily ConversationUniversity Students

199 वाक्य

Stack Data Structure In STL | C++ Tutorial

Daily ConversationUniversity Students

172 वाक्य

DRY Often Makes Your Code Worse

Daily ConversationUniversity StudentsWorking Adults

236 वाक्य

The 7 Quality Control (QC) Tools Explained with an Example!

Daily ConversationUniversity StudentsWorking Adults

32 वाक्य

How to Formulate Research Questions: From Ideas to Actionable Data

Daily ConversationUniversity Students

83 वाक्य

What are KPIs and Metrics? | Data Fundamental for Beginners

Daily ConversationUniversity StudentsWorking Adults

इस पाठ की शब्दावली और बोलने के सुझाव

यह स्पीकिंग पाठ वीडियो “Data Analysis Essentials in Excel” पर आधारित है। सबसे ज़्यादा दोहराए गए शब्द ये हैं: revenue, click, ahead, select, analysis। इस वीडियो में शैडोइंग के लिए 190 वाक्य और 2200 शब्द हैं। बोला गया हिस्सा 11:51 लंबा है। वक्ता तेज़ बोलता है, लगभग 186 शब्द प्रति मिनट, इसलिए जुड़ी हुई और कमज़ोर ध्वनियाँ ज़्यादा मिलेंगी। 89% शब्द अंग्रेज़ी के 3,000 सबसे आम शब्दों में से हैं, इसलिए शब्दावली आसान है।

इस वीडियो की मुख्य शब्दावली

वीडियो के 15 सीखने लायक शब्द, उच्चारण और अर्थ के साथ:

शब्द	उच्चारण	अर्थ
select क्रिया	/sɪˈlɛkt/	चुनना, चयन करना
column संज्ञा	/ˈkɒləm/	स्तंभ, सुतून
ribbon संज्ञा	/ˈɹɪbən/	फ़ीता, फीता
dragon संज्ञा	/ˈdɹæɡən/	अज़दहा, अजदहा
analyze क्रिया	/ˈæn.əˌlaɪz/	विश्लेषण करना
duplicate क्रिया	/ˈd(j)uː.plɪˌkeɪt/	अनुकृति करना, अनुकरण करना
percentage संज्ञा	/pə(ɹ)ˈsɛntɪd͡ʒ/	प्रतिशतता
chart संज्ञा	/t͡ʃɑɹt/	लेखाचित्र, चार्ट
equation संज्ञा	/ɪˈkweɪ.ʒən/	समीकरण
scroll संज्ञा	/skɹoʊl/	पुस्तक
relative संज्ञा	/ˈɹɛl.ə.tɪv/	रिश्तेदार, नातेदार
formula संज्ञा	/ˈfɔː.mjʊ.lə/	सूत्र, फ़ॉरमूला
skill संज्ञा	/skɪl/	कुशलता, कौशल
introduce क्रिया	/ˌɪntɹəˈdus/	परिचय
summary संज्ञा	/ˈsʌm.ə.ɹi/	सारांश, ख़ुलासा

वीडियो में आने वाली फ़्रेज़ल वर्ब

शब्द	उच्चारण	अर्थ
go ahead क्रिया	/ˌɡoʊ əˈhɛd/	आगे बढ़ना

ध्यान देने योग्य उच्चारण

वक्ता 61 बार संक्षिप्त रूपों का प्रयोग करता है, जैसे gonna, we're, we'll। इन्हें वैसे ही छोटा बोलें जैसा आप सुनते हैं।

“sh” और “zh” की ध्वनियाँ: proportion /pɹəˈpɔɹʃən/, equation /ɪˈkweɪ.ʒən/, conditional /kənˈdɪʃ.ə.nəl/, visualize /ˈvɪʒuəˌlaɪz/, dashboard /ˈdæʃˌboɹd/
लंबे शब्द — बलाघात सही रखें: conditional /kənˈdɪʃ.ə.nəl/, capitalize /ˈkæpətəˌlaɪz/, separator /ˈsɛpəˌɹeɪtəɹ/, visualization /ˌvɪʒ.ʊ.ə.laɪˈzeɪ.ʃən/

हिंदी भाषियों के लिए मुश्किल ध्वनियाँ:

/v/ और /w/ का फ़र्क़ — /v/ में ऊपर के दाँत निचले होंठ को छूते हैं, /w/ में होंठ गोल होते हैं: query /ˈkwɪɹ.i/, equation /ɪˈkweɪ.ʒən/, relative /ˈɹɛl.ə.tɪv/, upward /ˈʌpwɚd/, descriptive /dəˈskɹɪptɪv/
/z/ — इसे “ज” (/dʒ/) न बनाएँ: analyze /ˈæn.əˌlaɪz/, columns /ˈkɑləmz/, summarize /ˈsʌməˌɹaɪz/, visualize /ˈvɪʒuəˌlaɪz/, capitalize /ˈkæpətəˌlaɪz/
शब्द की शुरुआत में s + व्यंजन — पहले “इ” न जोड़ें: scroll /skɹoʊl/, skill /skɪl/, scatter /ˈskætɚ/, sloping /ˈsloʊpɪŋ/

इस वीडियो से अभ्यास कैसे करें

पहले बिना बोले पूरा वीडियो एक बार सुनें और जो शब्द नहीं आते उन्हें लिख लें।
0.75× गति से शुरू करें, एक-एक वाक्य की शैडोइंग करें, और सहज लगने पर सामान्य गति पर लौटें।
अपनी आवाज़ रिकॉर्ड करें और मूल से तुलना करें, ख़ासकर select, column, ribbon जैसे शब्दों पर ध्यान दें।

शैडोइंग तकनीक क्या है?

शैडोइंग (Shadowing) एक विज्ञान-समर्थित भाषा सीखने की तकनीक है जो मूल रूप से पेशेवर दुभाषिया प्रशिक्षण के लिए विकसित की गई थी। विधि सरल लेकिन शक्तिशाली है: आप मूल अंग्रेज़ी ऑडियो सुनते हैं और तुरंत इसे ज़ोर से दोहराते हैं — जैसे वक्ता की छाया 1-2 सेकंड की देरी से। शोध से पता चलता है कि यह उच्चारण सटीकता, स्वर, लय, जुड़ी हुई ध्वनियाँ, सुनने की समझ और बोलने की प्रवाहशीलता में काफ़ी सुधार करता है।

शैडोइंग तकनीक: पूरी चरण-दर-चरण गाइड पढ़ें →

शैडोइंग अभ्यास: Data Analysis Essentials in Excel - वीडियो के साथ अंग्रेजी बोलना सीखें

अभ्यास मोड चुनें

ऐप डाउनलोड करें

How Modern Data Teams Work (Engineer, Analyst, Scientist, Architect, ML)

Handy CSS layout patterns, and fun ways to elevate them

Configure storage accounts | AZ-104 | Episode 16

Civil 3D course for beginners - Part 2 of 3

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

How I Consistently Study with a Full Time Job: My Scheduling Formula

Analyze SEC filings with Transformers for fun and profit

Stack Data Structure In STL | C++ Tutorial

DRY Often Makes Your Code Worse

The 7 Quality Control (QC) Tools Explained with an Example!

How to Formulate Research Questions: From Ideas to Actionable Data

What are KPIs and Metrics? | Data Fundamental for Beginners

इस पाठ की शब्दावली और बोलने के सुझाव

इस वीडियो की मुख्य शब्दावली

वीडियो में आने वाली फ़्रेज़ल वर्ब

ध्यान देने योग्य उच्चारण

इस वीडियो से अभ्यास कैसे करें

शैडोइंग तकनीक क्या है?