Data in the real world is messy, never available in the shape that users need in order to analyze it and gain insights. Business analysts spend a significant percentage of their time cleansing, transforming and preparing data before it can be analyzed or visualized in any meaningful way.
Some of the most common issues include:
- Finding and accessing the data you need can be difficult.
- Connecting to different data sources often requires different tools and query languages.
- Data usually needs to be cleaned up and reshaped before performing meaningful analysis.
- If the data gets updated, you have to repeat the process all over again.
- Each data set may look different, making it hard to combine the data.
What if Excel could address these issues and allow you to complete all the data preparation tasks that used to take you days to just minutes? With the new Get & Transform capabilities, Excel 2016 provides a market-leading set of capabilities for discovering, connecting, reshaping and combining data. All of this can be seamlessly done via an interactive, easy-to-use, point-and-click user experience that allows any analyst to master their data.
Once you have done the work to prepare data from multiple sources, doing it again is as simple as a single button click. Excel keeps track of the transform steps you took, so when you click the Refresh button, up-to-date data is pulled in from the multiple sources and every transform step is replayed automatically.
Want to learn more?
Save the date to tune in for a free live stream of the Microsoft Data Insights Summit—Wednesday, March 22—as we walk through examples and tricks to fully take advantage of the Get & Transform capabilities in Excel 2016. Be prepared to learn everything you need to know about these new and revolutionary data preparation capabilities that will help you take your data analysis to the next level.
—Miguel Llopis, senior program manager specializing in data connectivity experiences in Excel and Power BI