Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3

Video Transcription

00:00
I welcome back to Module six. Sequel and applications. This is less than one sequel. Reports were moving into some lesson 1.3 power bi I report example. And this lesson. We're going to take a query that I've written, and we're gonna import it into power bi eye and see if we can't get a nice chart from it.
00:20
Now I've tied together some sales person data
00:23
from the axiomatic, a database using some of that sample data.
00:27
So I've written this query which returns this sales persons data,
00:32
and it's grouped it by the CD, the name, the financial period
00:36
and some the amount. Now, if we scroll through this, we can see a lot of different amounts. But it's not very easy to see how well everyone is performing that quickly. So this seems like a nice data set that we could quickly
00:50
learn a lot about if we put it in a graph of some sort.
00:54
So what? I said, let's go ahead and get started
00:57
so we'll go ahead and launch power. Bi. I
01:00
now power bi I is a pretty advanced application and has a lot of capabilities.
01:06
Ah, that you could take advantage of if you get really good at it.
01:11
But you can still do a ton if you get really good at sequel by just importing the queries you've written
01:15
and graphing those queries.
01:18
So what we need to do is select get data
01:23
and we'll give it a second to, uh,
01:26
bring up her options. So database
01:29
my sequel database connect,
01:34
and we're going to type in our connection criteria again.
01:42
I believe it will remember the credentials Were you used last time so it may not prompt me for those credentials
01:49
And in the sequel statement, that is where we need to paste our query. So we're gonna go ahead and copy this
01:57
and
01:57
paste.
02:00
So let's go ahead and hit OK
02:05
and that queer will be available for download so you'll be able to download it.
02:08
Also a short quarry. So it's not that difficult to build a cz well,
02:12
and the neat thing about that quarry is it's easy to identify because
02:16
it has the floor inky constraints. Now there are lots of examples of tables in the axiomatic a sample database. They do not have the floor in key constraints.
02:24
So if you have looked around, You may have noticed that it's somewhat difficult,
02:29
the fine tables related to other tables, and that is the price that's paid for not putting a putting in foreign key constraints.
02:38
But
02:38
luckily, this data set had the foreign key constraints, so it was pretty easy to identify.
02:44
Now, if I go back, it's finished loading in the query results. So I'm gonna go ahead and click load
02:52
and this message pops up.
02:54
It's actually popping up for the
02:58
query that it's loading,
03:00
so we'll get the table
03:02
Query one and the columns available so we'll go ahead and
03:07
let's do a sales person, CD
03:09
name
03:12
and the Mount.
03:15
So there are all our people.
03:16
Let's go ahead and put that in a graft by clicking the graft button or the pie chart.
03:23
Now look at that.
03:25
We can very easily to see that Steve Church is our best salesperson. He's making almost
03:32
50% actually, 46.9%
03:36
of the sales, to be exact.
03:38
And is that somebody right there?
03:42
Yeah, Jason is not doing so well
03:46
with a 0.29%. Maybe he's new.
03:51
Thank you.
03:52
So we can see clearly
03:55
that the chart made reading that data very easy. The number one popped out
04:00
almost immediately.
04:01
Now there's a bunch of different options we could go through.
04:05
Let's see if we put in the financial period.
04:15
Well, they didn't load up. Let's see,
04:18
Take everything off, Say, Financial Period
04:27
and
04:29
Sales Person
04:30
and the Mount.
04:34
Okay,
04:35
so that Dad is not nearly as pretty.
04:41
So we can see
04:45
it's what it's done is it's split it out. We can see the Steve Church still doing really well.
04:49
It just looks odd split out this wing. So what? We're gonna go to
04:53
take out the financial period idea,
04:56
and that looks much better.
04:58
So when you move your quarry into power bi I depending on the data set that you're looking at, depending on what you want to visualize, it's really gonna have an impact on what kind of chart you decide to use
05:09
and how you decide to use that data within power. Bi I
05:12
So I hope you saw how easy it is to take queries that you've written
05:15
and introduce them into some of these reporting tools. Power bi. I just one of the tools out there. There's plenty of others like crystal reports, large analytics tableau, and, ah, a bunch of other ones that are both private and open source. So if you're looking for a reporting solution to tie into your sequel database,
05:33
you sure to check out one of those solutions
05:35
And in case that finishes this less and I hope you were able to get your power bi eye chart, working will be real. Look at that query running, and I will see you in the next lesson. Thank you.

Up Next

Introduction to SQL

This introduction SQL training course teaches SQL core concepts that are applied in professional environments. Once completed with the course, students will be able to query and interact with an SQL database, and know how to design database schemas.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor