Rejoignez-nous pour un voyage dans le monde des livres!
Ajouter ce livre à l'électronique
Grey
Ecrivez un nouveau commentaire Default profile 50px
Grey
Abonnez-vous pour lire le livre complet ou lisez les premières pages gratuitement!
All characters reduced
Supercharge Excel - Learn How to Write DAX for Power Pivot - cover

Supercharge Excel - Learn How to Write DAX for Power Pivot

MrExcel's Holy Macro! Books, Matt Allington

Maison d'édition: Packt Publishing

  • 0
  • 0
  • 0

Synopsis

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.
Disponible depuis: 26/09/2024.
Longueur d'impression: 219 pages.

D'autres livres qui pourraient vous intéresser

  • Big Data and Analytics for Beginners - A Beginner's Guide to Understanding Big Data and Analytics - cover

    Big Data and Analytics for...

    SAM CAMPBELL

    • 0
    • 0
    • 0
    This comprehensive guide is tailored for those taking their first steps into the dynamic realm of big data and analytics, providing a clear and accessible roadmap to demystify the complexities of these powerful technologies. 
    As our digital footprint grows exponentially, understanding how to harness and interpret vast amounts of data has become essential. This book serves as your indispensable companion, introducing you to the fundamental concepts, tools, and techniques that underpin the fascinating fields of big data and analytics. 
    From unraveling the core principles of big data to exploring the three Vs—Volume, Velocity, and Variety—each chapter unfolds a new layer of knowledge, building a solid foundation for readers without prior experience in the field. Real-world examples and case studies illustrate how big data and analytics are driving transformative changes across industries, from healthcare and finance to marketing and beyond. 
    Delve into the analytics lifecycle, unraveling the different types of analytics—descriptive, diagnostic, predictive, and prescriptive—and discover how these insights can revolutionize decision-making. Gain hands-on knowledge of the tools and technologies essential for budding analysts, demystifying the Hadoop framework, exploring cloud storage, and understanding the ETL (Extract, Transform, Load) process. 
    "Big Data and Analytics for Beginners" is your key to unlocking the potential within the vast world of data. Engaging, practical, and beginner-friendly, this book is designed to empower you with the knowledge and confidence to embark on your journey into the exciting landscape of big data and analytics. 
     
    Voir livre
  • Spectroscopy - Science Spectronomy and Astronomy Explained - cover

    Spectroscopy - Science...

    Arnoud Varens

    • 0
    • 0
    • 0
    In the vast expanse of the cosmos, where stars twinkle in the night sky and galaxies swirl in the abyss, a remarkable dance of light and matter unfolds—a dance that has captivated the human imagination for centuries. This dance, illuminated by the science of spectroscopy, is what this book seeks to explore and explain. 
    Spectroscopy, the study of the interaction between matter and electromagnetic radiation, may sound complex and esoteric, but at its heart lies a simple and profound idea: the colors of light can reveal the secrets of the universe. From the examination of distant stars to the analysis of molecules in a laboratory, spectroscopy is the key that unlocks the hidden stories encoded in light. 
    This book is your guide to the fascinating world of spectroscopy, spanning from the fundamental principles that underpin this science to its myriad applications across various disciplines. We will journey together through the realms of chemistry and biology, where spectroscopy plays a vital role in unraveling the mysteries of molecules and cells. We will then venture into the realm of astronomy, where spectroscopy serves as a cosmic tool, allowing us to explore the composition, motion, and evolution of celestial objects. 
    This book is designed for curious minds seeking to understand the inner workings of the universe. Whether you are a student just beginning your scientific journey, a seasoned researcher, or simply an inquisitive reader, this book aims to provide you with a comprehensive and accessible overview of spectroscopy and its applications.
    Voir livre
  • Meditation for Focus and Flow - cover

    Meditation for Focus and Flow

    Inner Light

    • 0
    • 0
    • 0
    Feeling scattered, distracted, or creatively blocked? Meditation for Focus and Flow is your go-to audio guide to sharpen your mind, clear mental clutter, and tap into a deep, effortless state of productivity. Whether you're working, studying, or creating, this audiobook offers guided meditations specifically designed to enhance concentration, boost clarity, and activate a state of flow where time seems to disappear. 
    Using a blend of breathwork, mindfulness techniques, and subtle focus-enhancing cues, each session helps you drop into the present moment and stay there—fully alert, calm, and in control. No more fighting distractions or forcing productivity. These meditations retrain your brain to access laser-like focus naturally, with ease and intention. 
    Whether you have 10 minutes or an hour, press play and let Meditation for Focus and Flow guide you into that zone where ideas move freely, tasks get done, and distractions melt away. 
    Perfect for writers, entrepreneurs, students, or anyone who wants to do less multitasking and more meaningful, focused work. 
    Clear your mind. Lock in. Flow forward.
    Voir livre
  • Guarding Against Online Identity Fraud - A Simple Guide to Online Security - cover

    Guarding Against Online Identity...

    Tim Trott

    • 0
    • 0
    • 0
    The internet can be a fearful and frightening place, especially when we hear about things like online identity theft. As scary as they may seem, there are some simple steps that anyone can take to protect ourselves from those dangers. 
    This audiobook will explain what those threats are, and what you can use to guard against being a victim. It’s all broken down in simple terms you can understand. Once you have a basic understanding of how the pieces fit together, you can then protect yourself from danger. 
    We will define the terms, like Phishing and Pharming, explain what identity theft is, and what to do to avoid and defend against it. 
    Voir livre
  • Mastering AI Game Development with Unreal - Unleash Creativity Empower Gameplay and Transform Player Experiences with Advanced AI Techniques in Unreal Engine - cover

    Mastering AI Game Development...

    Hrishikesh Andurlekar

    • 0
    • 0
    • 0
    Elevate your Unreal Engine skills with This Essential Guide to AI-Driven Game Development!
    Book Description
    In the rapidly evolving world of game development, integrating Artificial Intelligence (AI) into your Unreal Engine projects is no longer optional—it’s essential. Mastering AI for Unreal Engine is your definitive guide to unlocking the transformative power of AI, propelling your games beyond the ordinary and into the realm of cutting-edge, immersive experiences. 
    Through a step-by-step approach, you will explore a wide range of AI techniques, including pathfinding, behavior trees, perception systems, and the powerful Environment Query System (EQS). Each chapter delves into the theoretical underpinnings of these AI components, followed by hands-on exercises and real-world examples that demonstrate their integration within Unreal Engine. We will learn to create intelligent, dynamic, and engaging game experiences by leveraging the power of AI. 
    What sets this book apart is its deep dive into emerging AI frameworks like the Mass Framework, giving you a strategic edge in adopting the latest trends and technologies that are shaping the future of gaming. You’ll learn how to optimize your AI systems, enhance performance, and master debugging techniques critical for smooth, efficient development processes. 
    Mastering AI for Unreal Engine doesn’t just teach you AI—it empowers you to innovate, create intelligent game worlds, and stand out in the fiercely competitive game development landscape. 
    Table of Contents
    
    1. Introduction to Unreal Engine
    2. Unreal Blueprints
    3. Understanding AI in Games
    4. Navigation and Pathfinding
    5. Behavior Trees and Blackboards
    6. AI Perception
    7. StateTree
    8. Environment Query System
    9. SmartObjects
    10. Debugging AI in Unreal Engine
    11. Mass Framework and Future Trends in GameAI   
    Index
    Voir livre
  • A Dignified Life - Revised and Expanded: The Best Friends™ Approach to Alzheimer’s Care: A Guide for Care Partners - cover

    A Dignified Life - Revised and...

    MPH David Troxel, MSW Virginia Bell

    • 0
    • 0
    • 0
    More than 5 million Americans are currently living with Alzheimer's disease or a related form of dementia. By the year 2030, experts estimate that as many as 66 million people will be faced with this life-altering disease. These statistics impact millions of caregivers. Compared with all types of caregivers, those who assist someone with dementia experience the highest levels of burnout, depression, poor health, and premature death. A Dignified Life, Revised and Expanded offers hope and help. 
     
     
     
    Ten years ago, the first edition of A Dignified Life changed the way the caregiving community approached Alzheimer's disease by showing caregivers how to act as a Best Friend to the person. Firmly grounded in the latest knowledge about dementia, this expanded edition offers a wealth of tips and advice. 
     
     
     
    While medical treatment of the disease hasn't changed, our understanding and awareness of treating people in a more caring way has changed. With no cure, respectful care by effective and compassionate care partners is the only real "treatment" available. The Best Friends Approach is successful because it sustains people's connection to their world, their loved ones, and themselves. A Dignified Life shows how to bring dignity, meaning, and peace of mind to the lives of both those who have Alzheimer's and dementia and those who care for them.
    Voir livre