| LDR | | 05668cmm u2200625Ii 4500 |
| 001 | | 000000317896 |
| 003 | | OCoLC |
| 005 | | 20230525183636 |
| 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 248032 |
| 049 | |
▼a MAIN |
| 050 | 4 |
▼a HF5548.4.M523 |
| 082 | 04 |
▼a 005.54
▼2 23 |
| 100 | 1 |
▼a Foulkes, Linda,
▼e author. |
| 245 | 10 |
▼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 | 0 |
▼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 | 8 |
▼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 | 8 |
▼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 | 8 |
▼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 | 00 |
▼a Microsoft Excel (Computer file) |
| 630 | 00 |
▼a Microsoft Power BI (Computer file) |
| 650 | 0 |
▼a Electronic spreadsheets
▼x Computer programs. |
| 650 | 0 |
▼a Business intelligence
▼x Computer programs. |
| 650 | 0 |
▼a Information visualization
▼x Computer programs. |
| 650 | 0 |
▼a Business
▼x Data processing. |
| 650 | 0 |
▼a Visual analytics. |
| 655 | 4 |
▼a Electronic books. |
| 655 | 0 |
▼a Electronic books. |
| 700 | 1 |
▼a Sparrow, Warren,
▼e author. |
| 776 | 08 |
▼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 | 40 |
▼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 관리자 |
| 994 | |
▼a 92
▼b N$T |