reklama - zainteresowany?

Supercharge Excel. Learn How to Write DAX for Power Pivot - Helion

Supercharge Excel. Learn How to Write DAX for Power Pivot
ebook
Autor: MrExcel's Holy Macro! Books, Matt Allington
Tytuł oryginału: Supercharge Excel. Learn How to Write DAX for Power Pivot
ISBN: 9781836646747
stron: 219, Format: ebook
Data wydania: 2024-09-26
Księgarnia: Helion

Cena książki: 49,49 zł (poprzednio: 54,99 zł)
Oszczędzasz: 10% (-5,50 zł)

Dodaj do koszyka Supercharge Excel. Learn How to Write DAX for Power Pivot

Tagi: Analiza danych

This guide empowers you to master Excel and Data Analysis Expressions (DAX), guiding you from the basics of data modeling to advanced DAX functions. You'll begin by learning how to load and structure data effectively, then dive into essential DAX functions like SUM, COUNT, and FILTER, which are crucial for accurate data manipulation. As you progress, the book covers advanced concepts such as context transition, calculated columns, and time intelligence, enabling you to perform sophisticated data analyses.

By incorporating hands-on exercises, the guide ensures that you can apply what you've learned to real-world scenarios. You'll also explore advanced topics like disconnected tables and cube formulas, expanding your ability to create dynamic models and dashboards. Towards the end, the guide introduces transitioning from Excel to Power BI, helping you leverage your Excel expertise in a more powerful environment.

This book is perfect for technical professionals and Excel power users looking to enhance their data analysis skills and transition smoothly to Power BI. By the end, you'll have the knowledge and tools to take your data modeling and analysis to the next level.

Dodaj do koszyka Supercharge Excel. Learn How to Write DAX for Power Pivot

 

Osoby które kupowały "Supercharge Excel. Learn How to Write DAX for Power Pivot", wybierały także:

  • Data Science w Pythonie. Kurs video. Przetwarzanie i analiza danych
  • Excel 2013. Kurs video. Poziom drugi. Przetwarzanie i analiza danych
  • Zarz
  • Eksploracja danych za pomoc
  • Google Analytics od podstaw. Analiza wp

Dodaj do koszyka Supercharge Excel. Learn How to Write DAX for Power Pivot

Spis treści

Supercharge Excel. Learn How to Write DAX for Power Pivot eBook -- spis treści

  • 1. Concept: Introduction to Data Modelling
  • 2. Concept: Loading Data
  • 3. Concept: Measures
  • 4. DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
  • 5. Concept: Filter Propagation
  • 6. Concept: Lookup Tables and Data Tables
  • 7. DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
  • 8. DAX Topic: Calculated Columns
  • 9. DAX Topic: CALCULATE()
  • 10. Concept: Evaluation Context and Context Transition
  • 11. DAX Topic: IF(), SWITCH(), and FIND()
  • 12. DAX Topic: VALUES() and HASONEVALUE()
  • 13. DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED()
  • 14. DAX Topic: FILTER()
  • 15. DAX Topic: Time Intelligence
  • 16. DAX Topic: RELATED() and RELATEDTABLE()
  • 17. Concept: Disconnected Tables
  • 18. Concept: KPIs
  • 19. Concept: Multiple Data Tables
  • 20. Concept: Cube Formulas
  • 21. Moving from Excel to Power BI
  • 22. Next Steps on Your DAX Journey

Dodaj do koszyka Supercharge Excel. Learn How to Write DAX for Power Pivot

Code, Publish & WebDesing by CATALIST.com.pl



(c) 2005-2024 CATALIST agencja interaktywna, znaki firmowe należą do wydawnictwa Helion S.A.