シャドーイング練習: The Simplest Way to Connect Claude and Power BI - YouTubeで英語スピーキングを学ぶ
C1
In this video, I'm going to talk about
162 文
文が短すぎたり長すぎる場合は、Editをタップして調整してください。
1
In this video, I'm going to talk about
2
that how do you connect Claude with Power BI so that when you give prompts in Claude,
3
Power BI acts automatically.
4
It's going to be a fun one.
5
Let's start.
6
Now, to be able to connect Claude with Power BI Desktop,
7
we need three applications, two of which you've already guessed it.
8
Yes, we need Claude Desktop.
9
That's one.
10
We need Power BI Desktop and we also need Visual Studio Code.
11
When you download Cloud Desktop,
12
you can be on the free version.
13
There is no need for you to be on the paid version,
14
although the amount of work
15
that you can do on the free version in Cloud Desktop is going to be limited
16
and Power BI Desktop is anyways free.
17
I would request you at the start that you install these three applications to begin with,
18
Cloud Desktop, Power BI Desktop,
19
I'm sure you have that, and also VS Code.
20
The installation process of any of these three applications is just the standard process.
21
There is nothing technical about it,
22
so I'll leave that onto you and after that,
23
I'll teach you that how do you connect all of these three and have Claude talk to your Power BI desktop.
24
The very first application that we'll be working inside is VS Code
25
and that is where we will install the MCP
26
or model context protocol server for Power BI officially given to us by Microsoft.
27
Now, I'm going to go over to extensions right here and in extensions,
28
I will search for Power BI.
29
You can see that I have already installed that.
30
So, there was a check mark there.
31
You can see that I have already installed that.
32
That's from Microsoft and I have gotten that already.
33
In case you haven't, you can just click on that and install.
34
There is going to be an install button right here.
35
You can just click on install and have this extension installed in your VS Code.
36
The important thing to note is
37
that there is no way Claude can talk to an application in your PC like Power BI Desktop.
38
So the way that it connects to Power BI Desktop is via this MCP.
39
Although we don't need VS Code for any coding purposes,
40
we would just want to take that MCP
41
that we have installed the model context protocol that we have installed feed
42
that into Claude so that Claude can connect to Power BI Desktop
43
and start interacting
44
and you can do a bunch of work in there quick
45
introduction in case you're liking the video thus far you're absolutely
46
going to love my courses on power bi dax data modeling m language
47
and power query i have these structured courses where i start talking about concepts fundamental concepts right from scratch
48
and then i take the students to the next level by
49
talking about how to think how to construct the logic of the problem
50
and start solving harder problems on your own hundreds
51
and thousands of students have joined my courses and they have provided some raving feedback.
52
In case you're interested, the link of the courses is going to be down in the description.
53
I look forward to seeing you inside the course.
54
Let's get back to the video.
55
Let's just see that once you've installed this MCP or extension in your VS Code,
56
how do we then take this and connect to Cloud?
57
The next thing that I'm going to do is open up a Windows Explorer window
58
and then I am going to go over to users to take the path where my MCP is installed
59
and then connect it to Cloud Desktop.
60
So take a look.
61
So I am in my C drive wherever you have installed your Windows and we have users in there.
62
This is me, Chandip Chhabra.
63
And then I'm going to go over to VS Code.
64
I have installed some extensions.
65
So I'll go in the subfolder con extensions.
66
The Power BI MCP extension is installed in this particular folder,
67
Analysis Services, Power BI Modeling MCP.
68
I'll just double click on that within
69
which I will go on to the server folder and I will find the Power BI modeling MCP.
70
Now this technically is the place in your entire Windows directory where the MCP server is kept.
71
I would want to take this position or this particular file and then feed it into Claude.
72
How do you do that?
73
Now if you actually open this particular file,
74
it's going to most likely open in a terminal window
75
or like a shell in a PowerShell window and you see this particular code right here.
76
You can copy this code and this is the code
77
that we will stick inside of Claude so that Claude can talk to Power BI.
78
And you can take a look that the path
79
that is mentioned in here is the very path that I have navigated to.
80
So C, users, my name,
81
VS code extensions, blah, blah, blah.
82
And here is the Power BI modeling MCV.
83
It's encapsulated in a JSON.
84
So I can just copy all of that from here.
85
Control c on that and now i'm going to feed this inside of claude the next thing
86
that i do is i open up claude desktop after i have closed the powershell window
87
that opened for the executable file next up i'm just going to go over to the top
88
and i will click on file
89
and then click on the settings in the settings i will roll down over to developer
90
and you can see that since i have already connected and that's my Power BI server already connected right here.
91
Now, I don't really want to disturb my connection at the moment.
92
I will just tell you how can you do that.
93
So obviously, you would not see this being connected at the moment.
94
So you can click on a button and I'm going to click on edit at the moment.
95
So I'll click on edit and this is going to give me the place where I can make the change.
96
You can see that there is a cloud desktop config JSON right here.
97
I'm going to open up this JSON on this json file
98
needs to point to where your mcp is now this particular file
99
which is json file you can open up in a text editor in a notepad plus plus
100
or in vs code
101
that we have just installed it doesn't matter we just want to modify this
102
if i double click on the file it opens up in my vs code something like this
103
and you can take a look that i have already copy pasted
104
that code that i copied it from the mcp there are a bunch of other things as well
105
which has helped me to connect in case the code
106
that MCP shows is not working somehow in case you would want to take a look at my code instead,
107
I can just paste this code somewhere down below the video and you can just paste this code instead.
108
Note that what is important is that the command line should point to the directory where your MCP is.
109
One more thing to note that you can see
110
that we have double slashes in here rather than actually having a single slash.
111
So make sure that you change your file directory to have double slashes everywhere
112
and rest everything is going to be all right.
113
Now once you've done this particular change and you've deleted the original code
114
that was kept here and replaced it with the code that we copied.
115
Save it, close it and you are done.
116
At this stage, you might have to restart your PC once again for that change to take effect.
117
But for now, I have two windows open side by side.
118
I have a sales model that is open,
119
which is where I have got a couple of tables listed right here.
120
They are connected.
121
And on the other side,
122
I have Claude Desktop open.
123
Now, I'm going to start prompting Claude Desktop.
124
One thing you should keep in mind is
125
that the way to check it
126
if Power BI is connected to Claude is by again going over to the three dots right here,
127
file and then settings, and then making sure that in the developer,
128
you have the Power BI MCP connected, something like this.
129
Once I've ensured that the connection is working,
130
then I can go and talk to Claude to just do some operations on my Power BI report.
131
Let's just try to get how many tables are loaded in the current model.
132
Let's just see what happens.
133
Cool.
134
After a bit of soul searching,
135
Claude has returned me the answer that there are six tables loaded.
136
We have sales table and you can see that here,
137
the calendar table, which is right here,
138
the products refunds, an empty measures table and the product names table,
139
which is right here.
140
Let's try one more prompt with Claude.
141
Let's just see if it can actually create my total sales calculation,
142
which is technically going to be the units from the sales table multiplied with the price in the products table.
143
Let's just see if it can figure that out on its own or not.
144
All right, that is done as well.
145
You can see that Claude has written the measure.
146
Go in every single row of the sales table,
147
take the units, multiply that with the VLOOKUP of the price.
148
And this particular measure, which is total sales measure,
149
has been added in our model automatically.
150
Let's just go.
151
And if I drag this measure to our visual,
152
as it gives me the correct results,
153
sure enough, it actually does give me the correct results.
154
Now, all of this seems very rosy and very attractive
155
and then you might just get a high that Claude can do literally everything in my Power BI report.
156
But the answer might quite be very different.
157
In the next video, I've explored
158
that how realistic is to develop a full-fledged enterprise-grade report with Power BI and using Claude prompts.
159
I'll highly recommend that you watch that video to get some reality check of what Claude can and cannot do.
160
I'll see you in that video.
161
Cheers.
162
click click click click click click
アプリをダウンロード
話したすべての文をAIが採点
TRENDING
人気動画
この動画で話す練習をする理由は？
この動画では、ClaudeとPower BIを連携させる方法が紹介されています。具体的な実例を用いることで、視聴者は実践的な英語を学ぶことができるため、IELTS スピーキング対策に非常に役立つ内容となっています。特にIT業界やデータ分析に興味がある方にとっては、専門的な用語やフレーズに触れることで、ビジネス英語のスキルを向上させる良い機会です。さらに、動画を通じて、音声を何度も聞き取り、反復して発音することができるため、英語シャドーイングにも最適です。
文法と文脈における表現
この動画で使用されているいくつかの重要な構文を分析してみましょう：
- 「How do you connect...」 - 質問形を使い、具体的な手順を明らかにする。
- 「We need three applications」 - 必要な要素を明示することで、理解を助ける構文。
- 「There is no need for you to...」 - 不要性を強調することで、視聴者の誤解を防ぐ。
- 「Let’s start with...」 - 行動を促すフレーズは、視聴者を引き込む効果があります。
- 「You can just click on...」 - 簡単な手順を示すことで、視聴者に自信を与える。
これらのフレーズは、特定のコンテキストでの適切な使用方法を学ぶための良い例です。
一般的な発音のトラップ
動画内での発音において注意が必要な言葉やアクセントには、以下のようなものがあります：
- 「install」 - この語の発音は、特に英語学習者が間違えやすい部分です。
- 「applications」 - 複数形の発音は、流暢さに影響を与える重要な要素ですね。
- 「extension」 - この単語の発音も重要で、文脈によっては関係性を誤解させる可能性があります。
これらの言葉を注意深く聞き、shadow speechを行うことで、発音を改善し、より自然な会話力を養うことができます。
シャドーイングとは？英語上達に効果的な理由
シャドーイング（Shadowing）は、もともとプロの通訳者養成プログラムで開発された言語学習法で、多言語習得者として知られるDr. Alexander Arguelles によって広く普及されました。方法はシンプルですが非常に効果的：ネイティブスピーカーの英語を聞きながら、1〜2秒の遅延で声に出してすぐに繰り返す——まるで「影（shadow）」のように話者を追いかけます。文法ドリルや受動的なリスニングと異なり、シャドーイングは脳と口の筋肉が同時にリアルタイムで英語を処理・再現することを強制します。研究により、発音精度、抑揚、リズム、連音、リスニング力、そして会話の流暢さが大幅に向上することが確認されています。IELTSスピーキング対策や自然な英語コミュニケーションを目指す方に特におすすめです。