{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["report2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"report2","index":0,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[10,2,10,3],[10,4,10,5],[11,2,11,3],[11,4,11,5],[12,2,12,3],[12,4,12,5],[13,2,13,3],[14,2,14,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[27,2,27,3],[28,2,28,3],[31,2,31,3]],"flags":["formulas_cached_only"]}
[null,"1.","Record Nr.",null,"UNINA9910159490103321"]
[null,null,"Autore",null,"Titus Eve"]
[null,null,"Titolo",null,"Basil of Baker Street"]
[null,null,"Pubbl/distr/stampa",null,"Oasis Audio"]
[null,null,"ISBN",null,"1-62188-677-8"]
[null,null,"Disciplina",null,"813/.54"]
[null,null,"Lingua di pubblicazione",null,"Inglese"]
[null,null,"Formato",null,"Musica"]
[null,null,null,"Livello bibliografico","Monografia"]
[null,null,null,"Sommario/riassunto","Baker Street Mice -- BewareSo far the twins are safe. They'll stay that way if you do what we say. We've decided to make your Baker Street cellar the headquarters for our gang. Everybody must be out in 48 hours. It's Basil's job to move you all out, just the way he moved you in. Better make it fast And leave the furniture -- we need it.This is the only warning you'll get. And listen -- if you don't follow our orders, you'll never set eyes on those twins again"]
[null,"2.","Record Nr.",null,"UNINA9910767566303321"]
[null,null,"Autore",null,"Motamedisedeh Omid"]
[null,null,"Titolo",null,"The Ultimate Guide to Functions in Power Query : Turn Raw Data into Actionable Insights / / by Omid Motamedisedeh"]
[null,null,"Pubbl/distr/stampa",null,"Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024"]
[null,null,"ISBN",null,"9781484297544"]
[{"$nulls":4},"1484297547"]
[null,null,"Edizione",null,"[1st ed. 2024.]"]
[null,null,"Descrizione fisica",null,"1 online resource (410 pages)"]
[null,null,"Disciplina",null,"005.54"]
[null,null,"Soggetti",null,"Database management"]
[{"$nulls":4},"Artificial intelligence - Data processing"]
[{"$nulls":4},"Data structures (Computer science)"]
[{"$nulls":4},"Information theory"]
[{"$nulls":4},"Database Management System"]
[{"$nulls":4},"Database Management"]
[{"$nulls":4},"Data Science"]
[{"$nulls":4},"Data Structures and Information Theory"]
[null,null,"Lingua di pubblicazione",null,"Inglese"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Monografia"]
[null,null,null,"Note generali","Includes index."]
[null,null,"Nota di contenuto",null,"Chapter 1: Introduction to Power Query -- Chapter 2: Data Types -- Chapter 3: Number Functions -- Chapter 4: Text Functions -- Chapter 5: Date and Time Functions -- Chapter 6: List Functions -- Chapter 7: Record Functions -- Chapter 8: Table Functions -- Chapter 9: Extracting from Data Sources -- Chapter 10: Other Functions."]
[null,null,null,"Sommario/riassunto","This book is a complete guide to using functions in Power Query and is designed to help users of all skill levels learn and master its various functions. The Ultimate Guide to Functions in Power Query begins with an introduction to Power Query and an overview of the different types of functions available, along with detailed explanations of how to use each of them. You’ll learn how to leverage power functions to process and transform large datasets from various sources and discover advanced techniques such as creating custom functions and using conditional statements. The book also covers best practices for using functions, including tips on how to optimize query performance and troubleshoot common errors. Using practical example applications, author Omid Motamedisedeh demonstrates how to optimize your data "]
[{"$nulls":4},"processing workflows, saving time and boosting productivity. By the end of the book, readers will have a deep understanding of Power Query functions and be ableto apply their knowledge to a wide range of data analysis tasks. You will: Master the fundamentals of Power Query, including how to load and transform data from various sources Understand all the functions available in Power Query, including text, date/time, logical, numeric, and more Deploy functions to transform data and perform complex calculations Employ advanced techniques such as custom functions, conditional statements, and working with parameters Optimize query performance, handle errors, and use the M language effectively Leverage real-world examples and exercises to hone your skills and gain practical experience with the tool."]