7 hours 36 minutes
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.
Now I've tied together some sales person data
from the axiomatic, a database using some of that sample data.
So I've written this query which returns this sales persons data,
and it's grouped it by the CD, the name, the financial period
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
learn a lot about if we put it in a graph of some sort.
So what? I said, let's go ahead and get started
so we'll go ahead and launch power. Bi. I
now power bi I is a pretty advanced application and has a lot of capabilities.
Ah, that you could take advantage of if you get really good at it.
But you can still do a ton if you get really good at sequel by just importing the queries you've written
and graphing those queries.
So what we need to do is select get data
and we'll give it a second to, uh,
bring up her options. So database
my sequel database connect,
and we're going to type in our connection criteria again.
I believe it will remember the credentials Were you used last time so it may not prompt me for those credentials
And in the sequel statement, that is where we need to paste our query. So we're gonna go ahead and copy this
So let's go ahead and hit OK
and that queer will be available for download so you'll be able to download it.
Also a short quarry. So it's not that difficult to build a cz well,
and the neat thing about that quarry is it's easy to identify because
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.
So if you have looked around, You may have noticed that it's somewhat difficult,
the fine tables related to other tables, and that is the price that's paid for not putting a putting in foreign key constraints.
luckily, this data set had the foreign key constraints, so it was pretty easy to identify.
Now, if I go back, it's finished loading in the query results. So I'm gonna go ahead and click load
and this message pops up.
It's actually popping up for the
query that it's loading,
so we'll get the table
Query one and the columns available so we'll go ahead and
let's do a sales person, CD
and the Mount.
So there are all our people.
Let's go ahead and put that in a graft by clicking the graft button or the pie chart.
Now look at that.
We can very easily to see that Steve Church is our best salesperson. He's making almost
50% actually, 46.9%
of the sales, to be exact.
And is that somebody right there?
Yeah, Jason is not doing so well
with a 0.29%. Maybe he's new.
So we can see clearly
that the chart made reading that data very easy. The number one popped out
Now there's a bunch of different options we could go through.
Let's see if we put in the financial period.
Well, they didn't load up. Let's see,
Take everything off, Say, Financial Period
and the Mount.
so that Dad is not nearly as pretty.
So we can see
it's what it's done is it's split it out. We can see the Steve Church still doing really well.
It just looks odd split out this wing. So what? We're gonna go to
take out the financial period idea,
and that looks much better.
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
and how you decide to use that data within power. Bi I
So I hope you saw how easy it is to take queries that you've written
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,
you sure to check out one of those solutions
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.