오디오북 라이프의 시작

격이 다른 오디오북 생활을 경험해보세요!

  • 언제든 손쉽게 구독해지 가능
  • 월정액 11900원 부터
  • 무제한 청취
  • 총 5만권 이상의 영/한 오디오북
  • 온가족을 위한 다양한 오디오북
지금 바로 시작해보세요!
kr all devices
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

출시일

전자책: 2020년 3월 18일

다른 사람들도 즐겼습니다 ...

  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

언제 어디서나 스토리텔

  • 국내 유일 해리포터 시리즈 오디오북

  • 5만권이상의 영어/한국어 오디오북

  • 키즈 모드(어린이 안전 환경)

  • 월정액 무제한 청취

  • 언제든 취소 및 해지 가능

  • 오프라인 액세스를 위한 도서 다운로드

인기

스토리텔 언리미티드

5만권 이상의 영어, 한국어 오디오북을 무제한 들어보세요

11900 원 /월
  • 계정 1개

  • 무제한 청취

  • 사용자 1인

  • 무제한 청취

  • 언제든 해지하실 수 있어요

지금 바로 시작하기

패밀리

친구 또는 가족과 함께 오디오북을 즐기고 싶은 분들을 위해

매달 17900원 부터
  • 2-3 계정

  • 무제한 청취

  • 2-3 계정

  • 무제한 청취

  • 언제든 해지하실 수 있어요

2 개 계정

17900 원 /월
지금 바로 시작하기