Title
Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources,New
Sold by Ergodebooks, an authorized reseller.
Returns accepted within 30 days | support@ergodebooks.com
Shipping Information
- Free Standard Shipping — United States only
- Processing Time: 1–3 business days
- Estimated Delivery: 3–5 business days after dispatch
- Double-boxed, fully insured & discreetly packaged
- Tracking number sent via email once dispatched
- Orders over $250 require signature upon delivery. Taxes calculated at checkout.
Returns & Refund
Returns accepted within 30 days of delivery.
Damaged or Defective Item
Free return shipping + replacement or full refund
Wrong Item Received
Free return shipping + replacement or full refund
Change of Mind
Return shipping at customer's expense · 25% restocking fee applies
Payment Option
Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excels 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. Leading databases are covered, including Microsoft Azure data sources and web sources, and you will learn how to access those sources from your Microsoft Excel spreadsheets.Getting data into Excel is a prerequisite for using Excel's analytics capabilities. This book takes you beyond copying and 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, and other sources.Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows 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 are an Excel user, you won't want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the worlds leading analytics tool.What You Will Learn Connect to a range of external data, from databases to Azure sources Ingest data directly into your spreadsheets, or into PowerPivot data models Cleanse and prepare external data so it can be used inside Excel Refresh data quickly and easily to always have the latest information Transform data into readytouse structures that fit the spreadsheet format Execute M language functions for complex data transformationsWho This Book Is ForExcel users who want to access data from external sourcesincluding the Microsoft Azure platformin order to create business intelligence reporting, dashboards, and visualizations. For Excel users needing to cleanse and rearrange such data to meet their own, specific needs.
⚠️ WARNING (California Proposition 65):
This product may contain chemicals known to the State of California to cause cancer, birth defects, or other reproductive harm.
For more information, please visit www.P65Warnings.ca.gov.
- Q: What is the main focus of the book 'Data Mashup with Microsoft Excel Using Power Query and M'? A: The book focuses on teaching readers how to load external data into Microsoft Excel using Power Query, covering connections to various databases and data sources for reporting, dashboarding, and business intelligence.
- Q: Who is the author of this book? A: The author of the book is Adam Aspin.
- Q: What specific features of Microsoft Excel does this book cover? A: The book provides a thorough explanation of Excel’s Get and Transform feature set, guiding users on how to connect to external databases and web sources.
- Q: Is this book suitable for beginners in Excel? A: While the book is beneficial for all Excel users, it is particularly aimed at those who have some familiarity with Excel and want to enhance their skills in accessing and transforming external data.
- Q: What kind of data sources can I learn to connect to? A: Readers will learn to connect to various data sources, including Microsoft Azure, Oracle Database, and SQL Server, among others.
- Q: How many pages does the book contain? A: The book has a total of 412 pages.
- Q: What edition of the book is available? A: The book is published as the 1st edition.
- Q: When was the book published? A: The book was published on July 17, 2020.
- Q: What essential skills does this book aim to teach? A: The book aims to teach skills such as cleansing and preparing external data for use in Excel, refreshing data quickly, and executing M language functions for complex data transformations.
- Q: What type of binding does this book have? A: The book is available in paperback binding.