Excel 2016 comes with built-in
functionality that brings ease and speed to getting and transforming your
data—allowing you to find and bring all the data you need into one place from
multiple sources.
Power Query for Excel can be
found under the Get & Transform section on the Data tab.
This set of features provides
an intuitive and consistent experience for discovering, combining, and refining
data across a wide range of sources, including tables in public websites,
corporate data in databases and cubes, cloud-based sources like Azure,
unstructured data like Hadoop, and services like Salesforce.
The standard steps to follow
are:
Connect – make connections to data
sitting in the cloud, in a service, or locally
Transform – shape the data to meet your
needs; the original source remains unchanged
Combine – create a data model from
multiple data sources, and get a unique view into the data
Share – once your query is complete
you can save it, share it, or use it for reports
While some data analysis
efforts focus on a few of these steps, each step is important in the data
analysis and transformation process.
No comments:
Post a Comment