Prática de Shadowing: Data Analyst Interview 2024 | SQL | POWER BI | Data Science | Mock Interview - Aprenda a falar inglês com vídeo

Escolha um modo de prática

Cada modo abre uma sala de prática em tela cheia.

260 frases

Se as frases estiverem muito curtas ou longas, clique em Edit para ajustá-las.

Hey, hi Dipali.

Yeah, hello sir.

Good afternoon.

I hope you're doing well.

Yes, I'm good.

All right.

So Dipali, I saw your resume and it feels like very much comfortable for this present domain.

So can you please walk me through your profile?

Yeah, actually I was working on Power BI as a Power BI developer in my previous company.

So I have total 4.5 of experience and relevant is a power BI is a two plus of experience.

And in this company, I was working for two domains like retail domains and rental domains.

So this both domains are US based.

So on this projects, my role and responsibilities are to creating the reports

and publish uh publishing into the power bi services when

when i was creating a report that time i was working data modeling data cleanings

and by using tags multiples of text functions ui options

and bar graphs charts we are using uh both

and creating a report into power bi desktops

and after creating we are sharing to the power bi services when i was sharing into the power bi services,

that time we are creating a dashboards and we set alerts

and subscription into the dashboards and that's all my daily works and said,

I was cleaning the data from my data sources.

I was working on three data sources,

Snowflake, SQL and SQL data sources.

Also, I was working three data sources to clean the data from these data sources.

Okay.

All my work.

So, Deepali, tell me what were your challenges while you were working,

you know, having some activities related to Power BI.

So what were the daily challenges you faced?

When I was working daily,

so that time I was facing data connectivity issues from like refresh modes for a shadow refreshes

and refreshes in Power BI services.

So many times I was facing these issues

and like multiples of DAX functions and as per our client requirements when we are working properly in DAX.

So in DAX I was facing multiples of issues.

So how did you handle it and what were the steps?

Firstly I learned what is the issue.

Then we will work on these issues where we are searching for Google

and we are learning for multiples of YouTube and multiples of channels and we handle these issues for my own purpose.

When I was not solving these issues,

so I go to the manager and give manager help.

Alright.

So Google and YouTube were the primary sources of getting.

Yeah fine super so you said

that you were i mean familiar with you know database somewhere sql

and so yes

so how would you rate yourself you know on a scale

of you know one to ten um for data sources yeah uh seven all right fine

so uh what are the dbms software you are familiar SQL and PostgreSQL,

Oracle, Snowflake, multiple sub software.

So did you handle somewhere data cleaning?

Yes.

Part of your job.

Okay.

So what did you do in the data cleaning part?

Can you please elaborate on that?

Yeah, when I was cleaning the data to check the null values,

duplicates and errors and remove these errors and null values and duplicate values from our data.

When your data type is is a numeric and your data,

sorry, actually your data type is a text,

but your column is a date function.

So you can assign this for data types.

So we are facing multiples of issues in our data cleanings.

Okay.

So Dipali, let's say I want to delete all the records in a table.

Okay.

What command are you going to use?

We are using the truncate command.

Because when we are using delete command,

when we are passing the condition to the delete function,

we delete the records.

But truncate is remove all records from our tables.

Okay, fine.

Done.

So are you familiar with somewhere primary key?

What is the primary key and foreign key?

Yeah, in our data tables,

there are like single primary keys,

like it's a numeric and there is a normal values in your primary keys.

But when we are going to the like as a learn

or we are like face to the as a DBA database administrator.

So we can learn in our table,

there are multiples of primary keys.

But we are basically used for only one primary keys at each cell or numeric type and there is no null values.

Okay.

So coming back to normalization,

what do you understand by the term normalization?

Normalization data sources are totally clean data and it is the process of organizing the data in our databases.

And it is a redundancy or inconsistency of dependencies in your data databases.

So is there any type of normalization?

Yes.

First NF, second NF, or third NF.

Okay.

Done.

So Dipali, have you come across the term indexing,

the concept of indexing in SQL?

Yeah.

100

Index is used for the retrieve the data from our data like columns or data.

101

We're getting the index for the numbering one, two, three.

102

Okay.

103

Are you sure on that again?

104

Oh, yes.

105

Okay.

106

Let's say if I want to delete the duplicate rows in a table.

107

So what command am I going to use?

108

We are using for group by function or having function using to duplicate roles.

109

Sure.

110

Yes.

111

Okay.

112

Fine.

113

So coming back to the Power BI part.

114

So apart from Power BI,

115

Have you used Tableau as your data visualization tool?

116

Yes.

117

Okay.

118

So can you brief me something about Tableau?

119

Yeah.

120

Mostly Tableau users are learned as compared to Power BI and Tableau.

121

So Power BI is the best and simple tools we are using and handling this.

122

But Tableau, I was personally using the Tableau and personally working in my previous company as a Tableau.

123

So like as compare Power BI,

124

Tableau is used huge amount of data sources.

125

But in Power BI, there are limits for the datasets.

126

And in Tableau, we are Tableau,

127

they are the same both tools,

128

like both are the same tools, Power BI and Tableau.

129

But the multiples of functions are different.

130

Like in Power BI, we are using DAX functions and in Tableau,

131

we are using MDax functions like majors calculated fields we are using in Tableau.

132

So which is your favorite chart that you use on Power BI?

133

Bar chart, line chart.

134

So tell me something about line chart uh

135

when uh like a line chart it's a show our data

136

like trend wise uh like date time wise we are showing the data into line chart

137

so like we have a like one years of data

138

and we see our sales of your latest three months like how what is the profit

139

and what is the sales of our data so that time we are using line charts.

140

So what about pie chart?

141

Yeah, pie chart is mostly used for categorize the data.

142

We show the content of amount,

143

overall total data in the pie chart like percent wise calculations,

144

percent wise or total revenue wise profit wise.

145

We are seeing pie charts.

146

So, okay.

147

Coming back to SQL again.

148

Okay.

149

So, Let's say, can I concate two different data types in SQL?

150

If so, if I can concate,

151

then how is it possible?

152

Yes, by using concatenate functions and operator using functions and operator using two different data types of data into SQL.

153

Can you please tell me about the use of views in SQL?

154

Yeah, when we create a database and we are using this data.

155

So that time we are using function in our SQL to use the databases.

156

And in data we using databases.

157

So that time we are working on a multiple of operations or functions in SQL databases.

158

So do you have any hands-on experience into Excel as well?

159

Yeah, I have basic knowledge about this.

160

I'm sorry, Excel.

161

Suppose in Excel, let's say I have a data set and I want to find out a specific month

162

or total number of orders that is placed.

163

On a specific month, the total number of orders that is placed.

164

So what function am I going to use?

165

Counties.

166

Counties.

167

Okay.

168

Super.

169

Done.

170

Let's say I want to find out the total sales transaction for couple of cities.

171

So what I am going to use?

172

Some functions.

173

Some functions.

174

Okay.

175

Done.

176

So, yeah.

177

And one more question.

178

So as a data analyst,

179

what are the challenges you faced as a data analyst overall?

180

Can you give me an overview on that?

181

Yeah, when we are working as a Power BI tools for Tableau tools,

182

so firstly, we give the data from our data sources.

183

So that time I was facing two data connectivity issues from data sources to getting data sources into my tools Power BI.

184

So firstly, we are facing multiples of issues for data connectivity.

185

And second is like we creating multiples of charts.

186

So that time I was using the DAX function.

187

So this issue is facing and third is like we are publishing your sharing your reports into the Power BI services.

188

So that time gateway issue is a multiple of times we are facing.

189

So have you faced, so as you told that you were working in a company,

190

so have you faced situation where you have to work with the company and meet the deadlines, tight deadlines.

191

In that case, what did you do?

192

I suppose, firstly, I was managing my deadline and my work

193

and I was fully dedicated and work daily to daily time to time for this work.

194

And so in case my work is not done for a deadline,

195

so that time I was going to go to the manager and postpone this deadline and I will work on,

196

give me a two to three days and I was finished my work.

197

Okay.

198

So what if the manager regrets,

199

I mean, sorry, rejects the deadline?

200

So what are you going to do at that time?

201

Personally, I was working full day or night on this task and completed this task.

202

Alright.

203

So don't you think that work-life balance is a must for an employer?

204

Yes.

205

Okay.

206

So coming back to again.

207

So where do you see yourself,

208

Tipali, in the next five years?

209

In a reputed company.

210

So I was working as a best designation in my own company.

211

Okay.

212

So I went through your resume.

213

I saw that you are a master in computer science.

214

Yes.

215

Why not into coding part?

216

Why into this Power BI and analysis part?

217

Why?

218

Actually, I like visualization, designing and creating reports.

219

So that's why I was going to the analysis part.

220

As compared to coding, coding is so vast and I was working coding for in my graduation and post-graduation days.

221

So, as compared to best part is to me for the analysis.

222

So Dipali, as you said that you are very much diversified to the work you do and and somewhere Volcaholic again.

223

So one more question.

224

Okay.

225

So if let's say in an emergency,

226

okay, I'm telling you to learn a tool and,

227

you know, dedicate yourself for the next department that is software testing.

228

Okay.

229

Yes.

230

So how comfortable are you with that?

231

Yeah, I'm comfortable with that because in my,

232

when I was start my career,

233

so that time I was working as a manual tester, junior manual tester.

234

Okay.

235

So at times of emergency,

236

you can assist them as well.

237

Yeah.

238

Yes, sir.

239

Fine.

240

Fine.

241

Fine.

242

Okay.

243

So Pan-India relocation is not an issue for you?

244

Yes, sir.

245

Not an issue.

246

Not an issue.

247

Fine.

248

All right.

249

So done.

250

I'm done from my end.

251

Okay.

252

And the HR will get back to you on my feedback.

253

Okay.

254

Yeah.

255

Yeah.

256

So have a good day.

257

Thank you, Dipali.

258

Thank you, sir.

259

Okay.

260

Thank you, sir.

Baixar aplicativo

Tudo o que você precisa para falar fluentemente

Pronúncia com IANota em cada frase

Prática de IPADomine cada som

VocabulárioMonte seu banco de palavras

Jogo de vocabulárioAprenda brincando

Escaneie o QR

Download on theApp Store Get it onGoogle Play

FOR YOU

Vídeo recomendado

Top 20 Data Analyst Interview Questions And Answers for 2026

124 frases

Content Moderation Most Important Interview Question and Answers | @CorporateWala | Ankit Yadav

Interview EnglishWorking Adults

14 frases

Ahmed Hosny | AI Data Annotator & LLM Evaluation Specialist

Interview EnglishWorking Adults

82 frases

Customer Support Mock Interview | Customer Support Interview Questions | Customer Support

Business EnglishInterview EnglishUniversity Students

313 frases

SALES Interview Questions & Answers! (How to PASS a Sales Interview!)

Interview EnglishWorking Adults

Top UIUX Design Interview Questions Asked in Deloitte, Accenture & Infosys

61 frases

Uber Data Engineering Mock Interview - Ride-Sharing Data Warehouse Schema

Interview EnglishUniversity StudentsWorking Adults

560 frases

QA Engineer Interview Questions and Answers (UPDATED 2026) AI, Accessibility, Automation.

Interview EnglishWorking Adults

60 frases

Contexto e Antecedentes

No vídeo intitulado "Entrevista de Analista de Dados 2024", a conversa gira em torno da experiência de Dipali como desenvolvedora Power BI. Com 4,5 anos de experiência total, ela detalha seu trabalho em dois domínios específicos: varejo e locação nos Estados Unidos. A entrevista proporciona um olhar profundo sobre as responsabilidades de um analista de dados, como a criação de relatórios e painéis no Power BI, além de mencionar os desafios comuns enfrentados, como problemas de conectividade de dados e a utilização de funções DAX. Essa experiência é extremamente relevante para quem deseja construir uma carreira na ciência de dados.

As 5 Principais Frases para Comunicação Diária

Hello, good afternoon. - Uma saudação básica e educada para iniciar conversas.
I saw your resume and it feels comfortable for this domain. - Usado para expressar conformidade com o perfil do candidato.
Can you please walk me through your profile? - Um pedido para que alguém explique sua experiência e habilidades.
I was facing data connectivity issues. - Uma descrição comum de desafios em análise de dados.
I will search for solutions on Google and YouTube. - Uma abordagem positiva para a resolução de problemas utilizando fontes online.

Guia Passo a Passo para Praticar Shadowing

Para aqueles que desejam aprimorar suas habilidades de conversação em inglês por meio da técnica de shadowing, este vídeo oferece uma ótima oportunidade. Aqui está um guia simples:

Escolha o vídeo: Comece assistindo ao vídeo completo com atenção. Preste atenção às expressões e ao vocabulário utilizado.
Escute atentamente: Ouça novamente, mas desta vez, pause frequentemente após cada frase ou ideia. Isso permite que você processe o que foi dito.
Repita em voz alta: Usando a técnica de shadow speak, repita imediatamente depois de ouvir cada frase. Tente imitar a entonação e o ritmo do falante.
Grave sua voz: Faça gravações de você mesmo praticando. Ouvir sua própria voz pode ajudar a identificar áreas para melhorar.
Reveja e refine: Assista ao vídeo novamente, agora focando em partes que você teve dificuldade. Vejo como seus resultados melhoraram ao longo do tempo.

Ao integrar a prática de conversação em inglês com recursos como vídeos no YouTube, você não apenas melhora sua pronúncia e fluência, mas também se familiariza com terminologia específica da área de interesse, como no campo de análise de dados. Experimente implementar o shadowing em inglês para aprimorar sua capacidade de comunicação de maneira eficaz.

Gramática neste vídeo

As estruturas que o falante mais usa, com as palavras exatas do vídeo:

Estrutura	No vídeo
Voz passiva be + particípio passado — o foco está no que acontece, não em quem faz	are basically used · is used · are learned
Present perfect have/has + particípio passado — uma ação passada que ainda importa agora	Have you used · have you faced
Past continuous was/were + -ing — uma ação em andamento em um momento do passado	was working · was creating · was sharing
Superlativos the -est / the most … — o maior ou o menor de um grupo	the best · your latest

O que é a Técnica de Shadowing?

Shadowing é uma técnica de aprendizado de idiomas com base científica, originalmente desenvolvida para o treinamento de intérpretes profissionais. O método é simples, mas poderoso: você ouve áudio em inglês nativo e repete imediatamente em voz alta — como uma sombra seguindo o falante com 1-2 segundos de atraso. Pesquisas mostram melhora significativa na precisão da pronúncia, entonação, ritmo, sons conectados, compreensão auditiva e fluência na fala.

Técnica de shadowing: leia o guia completo passo a passo →

Prática de Shadowing: Data Analyst Interview 2024 | SQL | POWER BI | Data Science | Mock Interview - Aprenda a falar inglês com vídeo

Escolha um modo de prática

Baixar aplicativo

Top 20 Data Analyst Interview Questions And Answers for 2026

How I faced rejections in interview | English conversation with RAM

english interview p2

Solving Easy SQL Interview Questions on Analyst Builder

Content Moderation Most Important Interview Question and Answers | @CorporateWala | Ankit Yadav

Ahmed Hosny | AI Data Annotator & LLM Evaluation Specialist

Customer Support Mock Interview | Customer Support Interview Questions | Customer Support

SALES Interview Questions & Answers! (How to PASS a Sales Interview!)

Top UIUX Design Interview Questions Asked in Deloitte, Accenture & Infosys

Uber Data Engineering Mock Interview - Ride-Sharing Data Warehouse Schema

QA Engineer Interview Questions and Answers (UPDATED 2026) AI, Accessibility, Automation.

IT Questions Speaking x3 v2

Contexto e Antecedentes

As 5 Principais Frases para Comunicação Diária

Guia Passo a Passo para Praticar Shadowing

Gramática neste vídeo

O que é a Técnica de Shadowing?