MARC 닫기

• LDR

  05668cam a2200625Ii 4500

• 001

  000001334939

• 005

  20210114163634

• 006

  m d

• 007

  cr unu||||||||

• 008

  201027s2020 enka ob 000 0 ger d

• 019

  ▼a  1176508353
  ▼a  1178651391

• 020

  ▼a  9781839215681

• 020

  ▼a  1839215682

• 020

  ▼z  9781839219719

• 035

  ▼a  2527745
  ▼b  (N$T)

• 035

  ▼a  (OCoLC)1202027449
  ▼z  (OCoLC)1176508353
  ▼z  (OCoLC)1178651391

• 037

  ▼a  CL0501000159
  ▼b  Safari Books Online

• 040

  ▼a  UMI
  ▼b  eng
  ▼e  rda
  ▼e  pn
  ▼c  UMI
  ▼d  N$T
  ▼d  YDX
  ▼d  EBLCP
  ▼d  UKAHL
  ▼d  248023

• 050

  ▼a  HF5548.4.M523

• 082

  ▼a  005.54
  ▼2  23

• 100

  ▼a  Foulkes, Linda,
  ▼e  author.

• 245

  ▼a  Learn Power Query:
  ▼b  a low-code approach to connect and transform data from multiple sources for Power BI and Excel /:
  ▼c  Linda Foulkes and Warren Sparrow.

• 260

  ▼a  Birmingham, UK:
  ▼b  Packt Publishing,
  ▼c  2020.

• 300

  ▼a  1 online resource (1 volume):
  ▼b  illustrations.

• 336

  ▼a  text
  ▼b  txt
  ▼2  rdacontent

• 337

  ▼a  computer
  ▼b  c
  ▼2  rdamedia

• 338

  ▼a  online resource
  ▼b  cr
  ▼2  rdacarrier

• 504

  ▼a  Includes bibliographical references.

• 505

  ▼a  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

• 505

  ▼a  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

• 505

  ▼a  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

• 505

  ▼a  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

• 520

  ▼a  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

• 520

  ▼a  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 ...

• 588

  ▼a  Description based on online resource; title from cover (Safari, viewed October 27, 2020).

• 590

  ▼a  Added to collection customer.56279.3

• 630

  ▼a  Microsoft Excel (Computer file)

• 630

  ▼a  Microsoft Power BI (Computer file)

• 650

  ▼a  Electronic spreadsheets
  ▼x  Computer programs.

• 650

  ▼a  Business intelligence
  ▼x  Computer programs.

• 650

  ▼a  Information visualization
  ▼x  Computer programs.

• 650

  ▼a  Business
  ▼x  Data processing.

• 650

  ▼a  Visual analytics.

• 655

  ▼a  Electronic books.

• 655

  ▼a  Electronic books.

• 700

  ▼a  Sparrow, Warren,
  ▼e  author.

• 776

  ▼i  Print version:
  ▼a  Foulkes, Linda
  ▼t  Learn Power Query : A Low-Code Approach to Connect and Transform Data from Multiple Sources for Power BI and Excel.
  ▼d  Birmingham : Packt Publishing, Limited,c2020

• 856

  ▼3  EBSCOhost
  ▼u  http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2527745

• 938

  ▼a  YBP Library Services
  ▼b  YANK
  ▼n  301388221

• 938

  ▼a  EBSCOhost
  ▼b  EBSC
  ▼n  2527745

• 938

  ▼a  Askews and Holts Library Services
  ▼b  ASKH
  ▼n  AH37406767

• 938

  ▼a  ProQuest Ebook Central
  ▼b  EBLB
  ▼n  EBL6267446

• 990

  ▼a  강리원

• 991

  ▼a  eBook

• 994

  ▼a  92
  ▼b  N$T