If
you’re a Business analyst or a Big data enthusiast that love to use excel for analyzing
of data (or even if you’re not) apart from the normal stuffs below:
- Estimate time
and costs
- Create a
project schedule
- Monitor
schedule and budget
- Manage
resources and risks
- Document
lessons learned
- Create charts
for use in presentations and reports
I want us to take advantage of a few simple and
quick tools that Excel offers to help us make sense of the data and
present it in a more understandable fashion.
Below are things we should understand:
Table - Excel allows for a quick table configuration.
Filter/Sort – These are two very important and
useful features that we can use all the time. The column filter reflects on the
whole data. With the Sort feature we can order any column numerically,
alphabetically or even by date.
Pivot Tables – A useful and powerful tool included in
Excel to summarize a big table, by the quantities that are needed.
Data cleaning - This is a very
important part of data analyzing, especially when dealing with Big Data: we
want to select only the data that will give us meaningful results.
For example, if we have NA values, or if we find negative values in quantities
we know can only make sense as positive values, we can remove those rows.
No comments:
Post a Comment