가야대학교 분성도서관

상단 글로벌/추가 메뉴

회원 로그인


자료검색

자료검색

상세정보

부가기능

Learn Power Query : a low-code approach to connect and transform data from multiple sources for Power BI and Excel /

상세 프로파일

상세정보
자료유형E-Book
개인저자Foulkes, Linda, author.
Sparrow, Warren, author.
서명/저자사항Learn Power Query :a low-code approach to connect and transform data from multiple sources for Power BI and Excel /Linda Foulkes and Warren Sparrow.
발행사항Birmingham, UK : Packt Publishing, 2020.
형태사항1 online resource (1 volume) : illustrations
소장본 주기Added to collection customer.56279.3
ISBN9781839215681
1839215682

서지주기Includes bibliographical references.
내용주기Cover -- Copyright -- About PACKT -- Contributors -- Table of Contents -- Preface -- Section 1: Overview of Power Pivot and Power Query -- Chapter 1: Installation and Setup -- Technical requirements -- Introducing Power Pivot -- Power Pivot Office versions and differences -- Introduction to Power BI -- Power BI versions and differences -- Mac/Apple -- Introduction to Power Query -- Features of Power Query -- Power Query Office versions and differences -- Installing Power Query in Office 2013 and 2010 -- Activating my Power Query/Pivot again
Launching Power Query, Power Pivot, and Power BI -- Launching Power Query within Excel -- Accessing Power Query from Power BI -- Summary -- Chapter 2: Power Pivot Basics, Inadequacies, and Data Management -- Technical requirements -- Creating a pivot table -- Creating a Power Pivot -- Creating a table in Excel -- Adding tables to the data model -- Creating relationships between tables -- Power Query to the rescue -- Creating a calculated column -- Creating a calculated field -- Creating a Power Pivot table -- Shortcomings of Power Pivot -- Problem 1 -- selecting multiple items
Problem 2 -- Power Pivot preview -- Problem 3 -- calculated fields -- Problem 4 -- Microsoft Office versions -- Summary -- Chapter 3: Introduction to the Power Query Interface -- Technical requirements -- The Power Query window and its elements -- The main ribbon and tabs -- The navigation pane or the Queries list -- Data table preview -- The Query Settings pane -- Working with APPLIED STEPS -- Investigating the View settings -- Using Advanced Editor -- Creating a basic power query -- Discovering the Load To... options -- Changing the default custom load settings
Loading queries to the worksheet manually -- Data profiling tips -- Column profile -- Column quality -- Column distribution -- Summary -- Chapter 4: Connecting to Various Data Sources Using Get & Transform -- Technical requirements -- A brief introduction to databases -- Connecting from a table or range -- Connecting data to the web -- Connecting from a relational database -- Connecting through Excel's Get & Transform tool -- Connecting through Power BI -- Understanding custom connections -- Connecting from Workbook -- Connecting from a folder -- Exploring data source settings -- From Excel
요약Section 2: Power Query Data Transformations -- Chapter 5: Transforming Power Query Data -- Technical requirements -- Turning data with the unpivot and pivot tools -- Refreshing data -- Basic column and row tools -- Removing columns -- Removing top or bottom rows -- Using the index column -- Creating a conditional column with the if...then...else statement -- Filtering data using the And/Or conditions -- Creating single-criteria filters -- Creating dynamic multiple-criterion filters -- Removing duplicate rows -- Replacing null values -- Working with the header row -- Splitting columns
요약This book will take you on a Power Query journey starting with shortcomings of other tools with regard to data analysis and management. Then we will delve in-depth into the Power Query interface; how to connect, combine, and refine data with really powerful query tools and learn to use the Power Query M formula language which opens up a whole ...
주제명(통일서명)Microsoft Excel (Computer file)
Microsoft Power BI (Computer file)
일반주제명Electronic spreadsheets -- Computer programs.
Business intelligence -- Computer programs.
Information visualization -- Computer programs.
Business -- Data processing.
Visual analytics.
언어독일어
기타형태 저록Print version:Foulkes, LindaLearn Power Query : A Low-Code Approach to Connect and Transform Data from Multiple Sources for Power BI and ExcelBirmingham : Packt Publishing, Limited,c2020
대출바로가기http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2527745

소장정보

  • 소장정보

인쇄 인쇄

메세지가 없습니다
No. 등록번호 청구기호 소장처 도서상태 반납예정일 예약 서비스 매체정보
1 WE00018779 005.54 가야대학교/전자책서버(컴퓨터서버)/ 대출가능 인쇄 이미지  

서평

  • 서평

태그

  • 태그

나의 태그

나의 태그 (0)

모든 이용자 태그

모든 이용자 태그 (0) 태그 목록형 보기 태그 구름형 보기
 

퀵메뉴

대출현황/연장
예약현황조회/취소
자료구입신청
상호대차
FAQ
교외접속
사서에게 물어보세요
메뉴추가
quickBottom

카피라이터

  • 개인정보보호방침
  • 이메일무단수집거부

김해캠퍼스 | 621-748 | 경남 김해시 삼계로 208 | TEL:055-330-1033 | FAX:055-330-1032
			Copyright 2012 by kaya university Bunsung library All rights reserved.