Develop your business intelligence (BI) with Excel, a great application for discovering, merging, and refining data across wide-ranging sources.
With Power Query you can
- Find and connect data across a wide range of sources.
- Merge and shape data to match your data analysis requirements, or prepare it for further analysis by tools such as Power Pivot and Power View.
- Create custom views over data.
- Use the JSON parser to create data visualisations over Big Data and Azure.
- Perform data cleansing operations.
- Import data from multiple log files.
- Create a query from your social media likes and shares that render an Excel chart.
- Pull data into Power Pivot from new sources, such as XML, Facebook, Twitter and File.
- Use refreshable connections in folders.
- Share, manage and collaborate on queries as well as search data within your business.
Want to see Power Query working? Click here for the Power BI – Getting Started Guide, This guide includes a section that shows Power Query creating a workbook that connects externally, transforms, and then creates a data model. You can take this guide step by step, or simply jump to the Power Query section.
With Power Query, sharing and managing queries as well as searching data within your business just got a whole lot easier. Users can find and use shared queries (if it is shared with them) to use the fundamental data for their data analysis and reporting. To learn more about how to share queries, see Share Queries.
Microsoft Excel Training
Microsoft Excel is commonly used by businesses UK-wide, but few companies know how to make the most of its many features.
AMP’s training courses will help you to do just that, whether you’re a complete beginner or a seasoned spreadsheet veteran.
We explain some of the most useful features that Excel has to offer. We look at formulas and workbooks, and how you can present data in various forms.