Helps you master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. Provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to find data and pull that data into your local spreadsheet for further analysis. This book covers all the leading databases, including Microsoft Azure data sources and web sources, showing you how to access those sources from directly inside your Microsoft Excel spreadsheets. If you’ve ever copied and pasted into Excel—and who hasn’t?—then you’ll understand the value in this book. Getting data into Excel is prerequisite for anything that you would use Excel to do. This book takes you beyond just copy/pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server among others. Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. This book has you covered there too by showing you how to create datasets and transformations.  For advanced problems there is help on the M language that is built into Excel specifically to support mashing up data in support of business intelligence and analysis. If you’re an Excel user, then don’t be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world’s leading analytics tool. For all Excel users desiring to access data from external sources—including the Microsoft Azure platform—in order to create business intelligence reporting, dashboards, and visualizations. For Excel users needing to cleanse and otherwise to rearrange such data to meet their own, specific needs.  weiterlesen