>> Next up we have Lucrecia Krause,
who'll be presenting business architecture using Power BI.
Lucrecia is an experienced technology professional.
She started her career in programming,
then moved into, program management,
business analysis, business architecture,
and improvement initiatives with Hewlett Packard.
Lucrecia studied computer science,
has an MBA and postgraduate and Strategic Quality Management.
She's very passionate about process design,
improvements and data for decision-making.
Can't wait to hear from you Lucrecia.
>> Hello everyone.
Thank you for having me here at the Power BI, Women Summit.
I'm going to be talking about
business architecture and how we
can implement that using Power BI.
My name is Lucrecia Krause,
I manage a group of
business analysts at the University of Central Florida.
I'm going to start defining what is business architecture.
Business architecture is a discipline that represent a holistic,
multidimensional business view of capabilities.
The end-to-end delivery,
information on organizational structure and
how these relationships among business views on the strategies,
products, policies, initiatives, and stake holders.
These slides, the sources is Wikipedia.
What business architecture helps
organization is to answer different business questions,
how the organization implements strategies.
Then the business architecture is going to help us
identify who is implementing the strategy, where,
why, what, how,
the how well we are doing in the business,
when and the whys?
What I am going to be presenting is
three business architecture activities
that we can implement using Power BI.
But we can get very creative,
is a lot of visuals and is not only three.
We can implement a lot of
the business architecture using Power BI.
The first one that I'm going to be covering is the who.
When we are trying to answer the who is in the business,
is who is doing the work question,
the best place to start is with
the organization, organizational chart.
These are the charts that we see that
are embedded into Office 365.
In other organizations, they use visual or other visuals.
The nice thing that if we do it in Power BI is that we can apply
the visuals as we are filling other layers of the organization.
The first one that we are going to be exploring is the when,
trying to answer the who is doing the work question.
The best place to start is with
the organization, organizational chart.
For this one, what we need is to import
the data file that contains the employee information.
In my case, I did it with Excel but with
all the plugins and we can pick from any source.
What is important is that we have the employee ID,
the name, the job title,
and something that is really important is the manager.
That way we are reflecting
the hierarchy to who is the employee reporting to.
I have here a very simple example
that if it has the employee name, the title,
the department manager, and the city,
what you see that it's important for
these particular org chart as I was saying is the hierarchy.
We have the CIO and then we have
the Department Manager or Director that is reporting to the CIO,
and then we have
other employees that are reporting to the manager.
Here is the visual that I'm using,
is the org chart by MAQ This
is a free chart that you can import in Power BI.
Just search by org chart,
and then you import the visual you selected,
and then you are going to select the employee ID,
the parent ID is going to be the manager,
and then you can have by job level or by city,
or you can have different levels or groups.
This is how it's going to look like.
Then we can also
add filters and we can slice information in different views.
The second one is the how.
When we are trying to answer the how question,
how they work is performed,
the process view in Power BI work really well.
A process mining in Power BI,
let us view the organizational details on how the work is done.
The nice thing with the Process Mining is that
usually we have a process that you seen in visual,
but we don't know if all the steps are being followed.
With the Process Mining,
the nice thing is that we can bring a log file
and then we see the exact steps and everything that is happening.
Usually organizations have their process in, let's say visual.
With visual you'll have how the process is designed to be.
But the nice thing,
if we analyze the data with actual logs,
using the process mining is going to let us
see the exact flow of how everything is being done.
I'm going to show you.
In this one, I import them path now,
Process Mining, Visual is also free.
For this one, we will need a log file with activity,
who is performing the activity,
and at a minimum,
a start and end time stamp.
Then we select the path.
Now, process mining visual.
From here, we are going to have a case ID,
then we have an event.
In this case, I'm ordering by month.
This is how the process map is drawn for us.
This is not a process of how we are designing it,
but this is the actual how the process is really happening.
If you see in this one,
we are seeing that the process for
some cases are starting at the very beginning,
but then we have others that are starting in a different phase,
so they are jumping the initial activities.
Then we have a couple of variants.
Is a very nice view because we can identify,
why is that we are having these variants,
how we can improve it or if it's something that is acceptable but
it's really handy to be able to see the process as this,
so we can compare if it's really performing
the way that we were intending to have the process.
Then the last one that I'm going to be showing is the, where.
When we are trying to answer the where question,
Power BI has many map visualization options that can help us,
the where our costumers,
employees, vendors or suppliers are located.
These extra layer of adding the location,
a Power BI is really powerful.
For this particular visual,
we need a file.
In this case I'm doing employee location,
but I as I was saying it can be anything that we want to map.
It can be costumers, vendors, employees.
In this particular case,
I have a lot that contains the employee location,
city and county.
But you can have a city and country.
The only thing that I advise is four the cities,
if it's duplicate cities,
we need to make sure that we clean the data because if it's
the same city in one country and in another country,
then it can mark the wrong city,
so we just need to be careful how we are cleaning the data.
In the visualization that I
selected is the one that is called the filled map.
Is the one that looks like this.
This one is a standard visualization in Power BI.
Here I have employee ID, the job level,
the start date, and the employee location.
Then from here visuals map the fields in employee location.
Then this is how it looks.
Thank you, everyone.
It was a pleasure to be here.
Thank you very much for the opportunity.
Just to recap, we review
three visuals that we can use
to implement the business architecture.
The first one is the organizational chart.
For this one, we use the organizational chart by MAQ software.
Then the next one,
it was the process visual.
This one is the path now, process mining.
Then the last one,
it was the visual for the maps, the filled map.
This one is a visual that is already part of Power BI.
Thank you very much.
If you have questions,
please feel free to reach out.
My LinkedIn is L-U-C-R-E-C-I-A,
last name K-R-A-U-S-E. Lucrecia Krause.
Thank you very much and have a great day.
>> Thank you for your session on
business architecture in Power BI Lucrecia.