6.1 Power Bi Report Example

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