Atjaunināt sīkdatņu piekrišanu

Master Your Data with Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow Second edition [Mīkstie vāki]

4.64/5 (43 ratings by Goodreads)
  • Formāts: Paperback / softback, 256 pages, height x width x depth: 273x209x209 mm, weight: 657 g, Illustrations
  • Izdošanas datums: 01-Nov-2021
  • Izdevniecība: Holy Macro! Books
  • ISBN-10: 1615470581
  • ISBN-13: 9781615470587
  • Mīkstie vāki
  • Cena: 38,05 €
  • Grāmatu piegādes laiks ir 3-4 nedēļas, ja grāmata ir uz vietas izdevniecības noliktavā. Ja izdevējam nepieciešams publicēt jaunu tirāžu, grāmatas piegāde var aizkavēties.
  • Daudzums:
  • Ielikt grozā
  • Piegādes laiks - 4-6 nedēļas
  • Pievienot vēlmju sarakstam
  • Formāts: Paperback / softback, 256 pages, height x width x depth: 273x209x209 mm, weight: 657 g, Illustrations
  • Izdošanas datums: 01-Nov-2021
  • Izdevniecība: Holy Macro! Books
  • ISBN-10: 1615470581
  • ISBN-13: 9781615470587
Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power Query is powerful, the interface is subtle—there are tools hiding in plain sight that are easy to miss. Go beyond the obvious and take Power Query to new levels with this book.
Foreword v
Chapter 0 The Data Revolution
1(10)
Chapter 1 Power Query Fundamentals
11(16)
Chapter 2 Query Management
27(16)
Chapter 3 Data Types and Errors
43(16)
Chapter 4 Moving Queries Between Excel & Power BI
59(16)
Chapter 5 Importing from Flat Files
75(16)
Chapter 6 Importing Data from Excel
91(14)
Chapter 7 Simple Transformation Techniques
105(16)
Chapter 8 Appending Data
121(14)
Chapter 9 Combining Files
135(20)
Chapter 10 Merging Data
155(22)
Chapter 11 Web Based Data Sources
177(10)
Chapter 12 Relational Data Sources
187(16)
Chapter 13 Reshaping Tabular Data
203(26)
Chapter 14 Conditional Logic in Power Query
229(18)
Chapter 15 Power Query Values
247(28)
Chapter 16 Understanding the M Language
275(22)
Chapter 17 Parameters and Custom Functions
297(22)
Chapter 18 Date and Time Techniques
319(24)
Chapter 19 Query Optimization
343(20)
Chapter 20 Automating Refresh
363(8)
Index 371