الاستماع والقراءة

خطوة إلى عالم لا حدود له من القصص

  • اقرأ واستمع إلى ما تريده
  • أكثر من مليون عنوان
  • العناوين الحصرية + أصول القصة
  • 7 يوم تجربة مجانية، ثم 9.99$ يورو في الشهر
  • من السهل الإلغاء في أي وقت
جرب مجانا
Details page - Device banner - 894x1036
Cover for DAX Cookbook : Over 120 recipes to enhance your business with analytics, reporting and business intelligence: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence

DAX Cookbook : Over 120 recipes to enhance your business with analytics, reporting and business intelligence: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence

اللغة
اللغة الإنجليزية
الصيغة
تصنيف

كتب واقعية

Solve real-world business problems by learning how to create common industry key performance indicators and other calculations using DAX within Microsoft products such as Power BI, SQL Server, and Excel.

Key Features

• Learn to write sophisticated DAX queries to solve business intelligence and data analytics challenges

• Handle performance issues and optimization within the data model, DAX calculations and more

• Solve business issues with Microsoft Excel, Power BI, and SQL Server using DAX queries

Book Description

DAX provides an extra edge by extracting key information from the data that is already present in your model. Filled with examples of practical, real-world calculations geared toward business metrics and key performance indicators, this cookbook features solutions that you can apply for your own business analysis needs.

You'll learn to write various DAX expressions and functions to understand how DAX queries work. The book also covers sections on dates, time, and duration to help you deal with working days, time zones, and shifts. You'll then discover how to manipulate text and numbers to create dynamic titles and ranks, and deal with measure totals. Later, you'll explore common business metrics for finance, customers, employees, and projects. The book will also show you how to implement common industry metrics such as days of supply, mean time between failure, order cycle time and overall equipment effectiveness. In the concluding chapters, you'll learn to apply statistical formulas for covariance, kurtosis, and skewness. Finally, you'll explore advanced DAX patterns for interpolation, inverse aggregators, inverse slicers, and even forecasting with a deseasonalized correlation coefficient.

By the end of this book, you'll have the skills you need to use DAX's functionality and flexibility in business intelligence and data analytics.

What you will learn

• Understand how to create common calculations for dates, time, and duration

• Create key performance indicators (KPIs) and other business calculations

• Develop general DAX calculations that deal with text and numbers

• Discover new ideas and time-saving techniques for better calculations and models

• Perform advanced DAX calculations for solving statistical measures and other mathematical formulas

• Handle errors in DAX and learn how to debug DAX calculations

• Understand how to optimize your data models

Who this book is for

Business users, BI developers, data analysts, and SQL users who are looking for solutions to the challenges faced while solving analytical operations using DAX techniques and patterns will find this book useful. Basic knowledge of the DAX language and Microsoft services is mandatory.

© 2020 Packt Publishing (كتاب إلكتروني): 9781839215223

تاريخ النشر

كتاب إلكتروني: 18 مارس 2020

واستمتع آخرون أيضًا...

  1. Mathletics: How Gamblers, Managers, and Fans Use Mathematics in Sports, Second Edition
    Mathletics: How Gamblers, Managers, and Fans Use Mathematics in Sports, Second Edition Wayne L. Winston
  2. Advanced Analytics with Power BI and Excel
    Advanced Analytics with Power BI and Excel Dejan Sarka
  3. Hyperwars: Eleven Strategies for Survival and Profit in the Era of On-Line Business
    Hyperwars: Eleven Strategies for Survival and Profit in the Era of On-Line Business Bruce Judson
  4. A Joosr Guide to... Good to Great by Jim Collins: Why Some Companies Make the Leap - and Others Don't
    A Joosr Guide to... Good to Great by Jim Collins: Why Some Companies Make the Leap - and Others Don't Joosr
  5. A Degree in a Book: Electrical And Mechanical Engineering: Everything You Need to Know to Master the Subject - in One Book!
    A Degree in a Book: Electrical And Mechanical Engineering: Everything You Need to Know to Master the Subject - in One Book! David Baker
  6. Beautiful Game Theory: How Soccer Can Help Economics
    Beautiful Game Theory: How Soccer Can Help Economics Ignacio Palacios-Huerta
  7. Sustainable Investing: What Everyone Needs to Know
    Sustainable Investing: What Everyone Needs to Know H. Kent Baker
  8. Geopolitics Energy Transition Critical Materials 2023
    Geopolitics Energy Transition Critical Materials 2023 International Renewable Energy Agency IRENA
  9. A Joosr Guide to... The Innovators by Walter Isaacson: How a Group of Hackers, Geniuses and Geeks Created the Digital Revolution
    A Joosr Guide to... The Innovators by Walter Isaacson: How a Group of Hackers, Geniuses and Geeks Created the Digital Revolution Joosr
  10. Space to Grow: Unlocking the Final Economic Frontier
    Space to Grow: Unlocking the Final Economic Frontier Brendan Rosseau
  11. Business Employee Mentoring
    Business Employee Mentoring RWG Publishing
  12. A Joosr Guide to... Influence by Robert Cialdini: The Psychology of Persuasion
    A Joosr Guide to... Influence by Robert Cialdini: The Psychology of Persuasion Joosr
  13. Leading Quality: How Great Leaders Deliver High-Quality Software and Accelerate Growth
    Leading Quality: How Great Leaders Deliver High-Quality Software and Accelerate Growth Ronald Cummings-John
  14. The Venturesome Economy: How Innovation Sustains Prosperity in a More Connected World
    The Venturesome Economy: How Innovation Sustains Prosperity in a More Connected World Amar Bhidé
  15. The Mobile App Mastery: Innovate, Design, and Thrive in the App Ecosystem
    The Mobile App Mastery: Innovate, Design, and Thrive in the App Ecosystem Marcus Devlin
  16. The New Mind Readers: What Neuroimaging Can and Cannot Reveal about Our Thoughts
    The New Mind Readers: What Neuroimaging Can and Cannot Reveal about Our Thoughts Russell Poldrack
  17. Digital Mavericks: A Guide to Web3, NFTS, and Becoming the Main Character of the Next Internet Revolution
    Digital Mavericks: A Guide to Web3, NFTS, and Becoming the Main Character of the Next Internet Revolution Debbie Soon
  18. Not Working: Where Have All the Good Jobs Gone?
    Not Working: Where Have All the Good Jobs Gone? David G. Blanchflower
  19. Magical Mathematics: The Mathematical Ideas That Animate Great Magic Tricks
    Magical Mathematics: The Mathematical Ideas That Animate Great Magic Tricks Persi Diaconis
  20. The Extraordinary Power of Leader Humility: Thriving Organizations – Great Results
    The Extraordinary Power of Leader Humility: Thriving Organizations – Great Results Marilyn Gist
  21. Revolutionize Your Learning: Secrets to Retain Knowledge Effortlessly: "Transform your learning! Discover powerful audio lessons to effortlessly retain knowledge and ace your exams."
    Revolutionize Your Learning: Secrets to Retain Knowledge Effortlessly: "Transform your learning! Discover powerful audio lessons to effortlessly retain knowledge and ace your exams." Cyrus Godfrey
  1. A Country Doctor
    A Country Doctor Sarah Orne Jewett
    2.8
  2. PMP Pro: Transform Your Exam Success with Game-Changing Secrets: "Elevate your PMP exam results! Dive into transformative audio lessons for peak performance on test day."
    PMP Pro: Transform Your Exam Success with Game-Changing Secrets: "Elevate your PMP exam results! Dive into transformative audio lessons for peak performance on test day." Arden Blakewood
  3. Summary - I’m Still Here: Based On The Book By Austin Channing Brown
    Summary - I’m Still Here: Based On The Book By Austin Channing Brown Library Of Stories
    1
  4. Desconexión Digital: Meditaciones Guiadas para Calma y Claridad
    Desconexión Digital: Meditaciones Guiadas para Calma y Claridad Refeser
  5. Summary - Emotional Intelligence 2.0.: Based On The Book By Travis Bradberry And Jean Greaves
    Summary - Emotional Intelligence 2.0.: Based On The Book By Travis Bradberry And Jean Greaves Fastbooks Publishing
    4
  6. Nature’s Symphony of Serene Forest Cricket Sounds Mixed With Piano Rhythms For Deep Calm & Relaxation: Experience Soothing Nights for Restful Sleep & Mindfulness Using Enhanced BGM 8D Audio
    Nature’s Symphony of Serene Forest Cricket Sounds Mixed With Piano Rhythms For Deep Calm & Relaxation: Experience Soothing Nights for Restful Sleep & Mindfulness Using Enhanced BGM 8D Audio Cedar Skye
  7. Summary - Freakonomics: Based On The Book By Steven Levitt And Stephen Dubner
    Summary - Freakonomics: Based On The Book By Steven Levitt And Stephen Dubner Fastbooks Publishing
    4
  8. Django Unchained - The Ultimate Trivia Collection: From The Movie Directed By Quentin Tarantino
    Django Unchained - The Ultimate Trivia Collection: From The Movie Directed By Quentin Tarantino Film Trivia Metaverse
  9. 100 Quotes About Inner Peace That Will Transform Your Life: Finding Serenity Amidst Life's Turmoil
    100 Quotes About Inner Peace That Will Transform Your Life: Finding Serenity Amidst Life's Turmoil The Quotes Library
    5
  10. GED Secrets: Elevate Your Success and Conquer the Exam Today: "Boost your GED prep! Unlock engaging audio lessons for ultimate exam success today!"
    GED Secrets: Elevate Your Success and Conquer the Exam Today: "Boost your GED prep! Unlock engaging audio lessons for ultimate exam success today!" Ronan Cade
  11. Extended Summary - Maybe You Should Talk To Someone: Based On The Book By Lori Gottlieb
    Extended Summary - Maybe You Should Talk To Someone: Based On The Book By Lori Gottlieb Quick Reading Library
  12. Extended Summary - Braving The Wilderness: Based On The Book By Brene Brown
    Extended Summary - Braving The Wilderness: Based On The Book By Brene Brown Quick Reading Library
    2
  13. Summary - Eat To Live: Based On The Book By Dr. Joel Fuhrman
    Summary - Eat To Live: Based On The Book By Dr. Joel Fuhrman Fastbooks Publishing
  14. Summary - 1620 - A Critical Response To The 1619 Project: Based On The Book By Peter W. Wood
    Summary - 1620 - A Critical Response To The 1619 Project: Based On The Book By Peter W. Wood Library Of Stories
  15. Summary - Everything Is F*Cked: Based On The Book By Mark Manson
    Summary - Everything Is F*Cked: Based On The Book By Mark Manson Fastbooks Publishing

دائمًا برفقة Storytel

  • أكثر من 200000 عنوان

  • وضع الأطفال (بيئة آمنة للأطفال)

  • تنزيل الكتب للوصول إليها دون الاتصال بالإنترنت

  • الإلغاء في أي وقت

الكتب الأكثر استماعًا

شهري

قصص لكل المناسبات.

9.99 $ / شهر
7 يومًا مجانًا
  • حساب واحد

  • حساب بلا حدود

  • 1 حساب

  • استماع بلا حدود

  • إلغاء في أي وقت

جرب الآن

سنويا

قصص لكل المناسبات.

83.88 $ /سنة
7 يومًا مجانًا
وفر 30%
  • حساب واحد

  • حساب بلا حدود

  • 1 حساب

  • استماع بلا حدود

  • إلغاء في أي وقت

جرب الآن

6 أشهر

قصص لكل المناسبات.

53.64 $ /6 أشهر
7 يومًا مجانًا
وفر 11%
  • حساب واحد

  • حساب بلا حدود

  • 1 حساب

  • استماع بلا حدود

  • إلغاء في أي وقت

جرب الآن