Learn Power Query (notice n° 73153)
[ vue normale ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 03647cam a2200289zu 4500 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | FRCYB88900525 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20250107233343.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 250108s2020 fr | o|||||0|0|||eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781839219719 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | FRCYB88900525 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | FR-PaCSA |
| Language of cataloging | en |
| Transcribing agency | |
| Description conventions | rda |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Foulkes, Linda |
| 245 01 - TITLE STATEMENT | |
| Title | Learn Power Query |
| Statement of responsibility, etc. | ['Foulkes, Linda', 'Sparrow, Warren'] |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Name of producer, publisher, distributor, manufacturer | Packt Publishing |
| Date of production, publication, distribution, manufacture, or copyright notice | 2020 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | p. |
| 336 ## - CONTENT TYPE | |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type code | c |
| Source | rdamdedia |
| 338 ## - CARRIER TYPE | |
| Carrier type code | c |
| Source | rdacarrier |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | Discover how you can combine data from various sources to create data models to suit your business requirements with the help of this clear and concise guide Key Features Understand how Power Query overcomes the shortcomings of Excel Power Pivot in handling complex data Create customized dashboards and multi-dimensional reports using Power Query and Power BI Learn the Power Query M language and write advanced queries using custom functions Book Description Power Query is a data connection technology that allows you to connect, combine, and refine data from multiple sources to meet your business analysis requirements. With this Power Query book, you'll be empowered to work with a variety of data sources to create interactive reports and dashboards using Excel and Power BI. You'll start by learning how to access Power Query across different versions of Excel and install the Power BI engine. After you've explored Power Pivot, you'll see why Excel users find it challenging to clean data in Power Pivot and learn how Power Query can help to tackle the problem. The book will show you how to transform data using the Query Editor and write functions in Power Query. A dedicated section will focus on functions such as IF, Index, and Modulo, and creating parameters to alter query paths in a table. You'll also work with dashboards, get to grips with multi-dimensional reporting, and create automated reports. As you advance, you'll cover the M formula language in Power Query, delve into the basic M syntax, and write the M query language with the help of examples such as loading all library functions offline in Excel and Power BI. Finally, the book will demonstrate the difference between M and DAX and show how results are produced in M. By the end of this book, you'll be ready to create impressive dashboards and multi-dimensional reports in Power Query and turn data into valuable insights. What you will learn Convert worksheet data into a table format ready for query output Create a dynamic connection between an Access database and Excel workbook Reshape tabular data by altering rows, columns, and tables using various Power Query tools Create new columns automatically from filenames and sheet tabs, along with multiple Excel data files Streamline and automate reports from multiple sources Explore different customization options to get the most out of your dashboards Understand the difference between the DAX language and Power Query's M language Who this book is for This Power Query book is for business analysts, data analysts, BI professionals, and Excel users looking to take their skills to the next level by learning how to collect, combine, and transform data into insights using Power Query. Working knowledge of Excel and experience in constructing and troubleshooting Excel formulas and functions is expected. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | |
| 700 0# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Foulkes, Linda |
| 700 0# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Sparrow, Warren |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Access method | Cyberlibris |
| Uniform Resource Identifier | <a href="https://international.scholarvox.com/netsen/book/88900525">https://international.scholarvox.com/netsen/book/88900525</a> |
| Electronic format type | text/html |
| Host name | |
Pas d'exemplaire disponible.
Réseaux sociaux