HOME > Detail View

Detail View

Power query for power BI and Excel [electronic resource]

Power query for power BI and Excel [electronic resource]

Material type
E-Book(소장)
Personal Author
Webb, Chris, 1975-.
Title Statement
Power query for power BI and Excel [electronic resource] / Chris Webb.
Publication, Distribution, etc
Berkeley, CA :   Apress :   Imprint: Apress,   2014.  
Physical Medium
1 online resource (xxi, 247 p.) : ill.
ISBN
9781430266921
요약
Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems. Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren’t going to be possible from just the GUI interface that is covered in most other books. You’ll have full command of the GUI, and you’ll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis. Teaches the basics of using Power Query to load data into Excel Helps you solve common, data-related problems with Power Query Shows how to write your own solutions in the powerful M language.
General Note
Title from e-Book title page.  
Includes index.  
이용가능한 다른형태자료
Issued also as a book.  
Subject Added Entry-Topical Term
Querying (Computer science).
Short cut
URL
000 00000nam u2200205 a 4500
001 000046041911
005 20200826165736
006 m d
007 cr
008 200814s2014 caua o 001 0 eng d
020 ▼a 9781430266921
040 ▼a 211009 ▼c 211009 ▼d 211009
050 0 0 ▼a QA76.625
082 0 4 ▼a 005.74/1 ▼2 23
084 ▼a 005.741 ▼2 DDCK
090 ▼a 005.741
100 1 ▼a Webb, Chris, ▼d 1975-.
245 1 0 ▼a Power query for power BI and Excel ▼h [electronic resource] / ▼c Chris Webb.
260 ▼a Berkeley, CA : ▼b Apress : ▼b Imprint: Apress, ▼c 2014.
300 ▼a 1 online resource (xxi, 247 p.) : ▼b ill.
500 ▼a Title from e-Book title page.
500 ▼a Includes index.
520 ▼a Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems. Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren’t going to be possible from just the GUI interface that is covered in most other books. You’ll have full command of the GUI, and you’ll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis. Teaches the basics of using Power Query to load data into Excel Helps you solve common, data-related problems with Power Query Shows how to write your own solutions in the powerful M language.
530 ▼a Issued also as a book.
538 ▼a Mode of access: World Wide Web.
630 0 0 ▼a Microsoft Excel (Computer file).
650 0 ▼a Querying (Computer science).
856 4 0 ▼u https://oca.korea.ac.kr/link.n2s?url=http://dx.doi.org/10.1007/978-1-4302-6692-1
945 ▼a KLPA
991 ▼a E-Book(소장)

Holdings Information

No. Location Call Number Accession No. Availability Due Date Make a Reservation Service
No. 1 Location Main Library/e-Book Collection/ Call Number CR 005.741 Accession No. E14030628 Availability Loan can not(reference room) Due Date Make a Reservation Service M

New Arrivals Books in Related Fields

Ramamurthy, Bina (2021)
윤관식 (2020)