Welcome to this course Certified Data Analytics Manager using Excel CDAME.
With me, Duncan Williamson
The idea of this video is to introduce you
to the course, just to give you an overview,
as well as extending a welcome on behalf of myself and Clariden.
By data analytics we mean the process of inspecting, cleaning,
transforming and modelling data, with the goal of discovering useful
information, suggesting conclusions and supporting decision making.
And in this course, we'll take a look at ten separate
sections, different types of data analysis, definitions and descriptions,
exactly what it is that we're talking about.
Then we'll take a look at data analytics with Excel.
That's setting the foundation for what we
mean by analytics and how Excel might help us.
Then we'll have a look at data analysis,
which is the next step along the pathway from analytics to analysis.
Fourth step of the way is to explore Excel lookup functions.
And there are many of them, by the way.
You'll have heard of VLOOKUP, no doubt.
But there's HLOOKUP index, match, offset,
indirect, and the newest one of all is Xlookup there's also Xmatch lesson
five more advanced data analysis and data tables.
It's exactly what it says.
So, having got to lesson four and looked at quite a number of different things,
we'll then take it a step further and look at some of these things in more detail
and add even more features and functions from Excel.
Exploring Data now we're starting to see
what's inside a set of data by ripping it apart and putting it back together.
Lesson seven take a look at data hierarchies.
Generally, I've limited that to KPIs key performance indicators, but not only.
For example, dates have hierarchies
in Excel and you can set hierarchies in Pivot tables.
As we'll see communication
and visualisation techniques splits into two, really.
The first section is communication
with charts and graphs, and the second half is
communication with tables as well as charts, as well as dashboards.
Lesson nine again,
I've got a similar title to lesson five, more Advanced or creative examples.
And again we get into this stage.
Now, lesson nine in a course like this, where we really are looking at some more
deep and detailed Excel functions, statistical and mathematical analysis
and so on, and we wrap up the course, lesson Ten, with a series of case studies.
And in the case studies almost chosen
at random, we'll have a look at weather data.
We'll have a look at covid-19 data with one
express idea, which is to explore the concept of exponential data.
It means something very specific.
And finally, I'm looking at the aircraft
fleets of Delta Airlines and Emirates Airlines.
Delta, based in America, has 1260 aircraft.
Emirates based in the United Arab Emirates, has 267 aircraft.
At the time I'm recording this.
And what we're essentially trying to do is
take the top level of their asset register and see what we can find out about
the planes, their ages, together with some hypothesis testing
and other statistical analysis, including seeing what we can find out about
the data and how you might use it in all sorts of ways.
In addition to analysing aircraft
certified data analytics manager using Excel, CDAME with me.
Duncan Williamson welcome to the course
I'm looking forward to working with you.
Thank you. Bye.