Data Mashup with Microsoft Excel Using Power Query and M

افزودن به بوکمارک اشتراک گذاری 0 دیدگاه کاربران 3 (1)

Finding, Transforming, and Loading Data from External Sources

مشارکت: عنوان و توضیح کوتاه هر کتاب را ترجمه کنید این ترجمه بعد از تایید با نام شما در سایت نمایش داده خواهد شد.

ترجمه این کتاب مشاهده همه کتاب های ترجمه نشده

Finding, Transforming, and Loading Data from External Sources

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 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. 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 world's 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 ready-to-use structures that fit the spreadsheet format
Execute M language functions for complex data transformations

Who This Book Is For
Excel users who want 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 rearrange such data to meet their own, specific needs.

لغو

گزارش تخلف

مغایرت عنوان کتاب با توضیحات و تصویر جلد
عدم رعایت حقوق نشر طبق قوانین جمهوری اسلامی ایران
محتوای مستهجن
توهین به قومیتها و محتوای نژادپرستی
توهین به اقیلیتهای مذهبی
اهانت به مقامات سیاسی و مذهبی
اشاعه ی کودک آزاری
سایر موارد

بستن

فرمت کتاب

ebook

زبان

english

تاریخ انتشار

2020

نویسنده

Adam Aspin

ناشر

Apress

شابک

9781484260173

20,000 تومان

خرید کتاب مطالعه نمونه درخواست ترجمه کتاب

خرید کتاب Data Mashup with Microsoft Excel Using Power Query and M

Data Mashup with Microsoft Excel Using Power Query and M

گزارش تخلف

فرمت کتاب

ebook

زبان

english

تاریخ انتشار

2020

نویسنده

ناشر

شابک

کتاب های مرتبط

Windows 8 Application Development with HTML5 for Dummies

Microsoft Excel Programmierung - Das Handbuch (Buch + E-Book). Automatisierung Mit VBA - Fur Excel 2007 - 2013. Vollstandig Uberarbeitet

Beginning REALbasic

Schaum's Outline of Visual Basic

Building Single Page Applications in .Net Core 3

Beginning Apache Spark Using Azure Databricks

Devsecops for .Net Core

The project managers guide to Microsoft Project 2019 : covers Standard, Professional, Server, Project Web App, and Office 365 versions

Building single page applications in .NET Core 3 : jumpstart coding using Blazor and C#

Introducing Disaster Recovery with Microsoft Azure