Unisciti a noi in un viaggio nel mondo dei libri!
Aggiungi questo libro allo scaffale
Grey
Scrivi un nuovo commento Default profile 50px
Grey
Iscriviti per leggere l'intero libro o leggi le prime pagine gratuitamente!
All characters reduced
Master Your Data with Power Query in Excel and Power BI - Leveraging Power Query to Get & Transform Your Task Flow - cover

Master Your Data with Power Query in Excel and Power BI - Leveraging Power Query to Get & Transform Your Task Flow

MrExcel's Holy Macro! Books, Miguel Escobar, Ken Puls

Casa editrice: Packt Publishing

  • 0
  • 0
  • 0

Sinossi

This book equips you with the essential skills to master Power Query in Excel and Power BI. Starting with the basics, you'll learn query management, data types, and error handling, establishing a solid foundation. You'll explore techniques to move queries between Excel and Power BI, ensuring seamless workflow integration. As the guide progresses, you'll delve into data import methods from flat files, Excel, web-based, and relational sources, while performing key transformations like appending, combining, and reshaping data.Advanced topics such as conditional logic, Power Query values, and M Language fundamentals will enhance your ability to customize and optimize queries. The book also covers the creation of parameters and custom functions, alongside applying sophisticated date and time techniques.Finally, you'll learn to optimize query performance and automate data refreshes, ensuring your analysis remains current. By the end of this guide, you'll have the confidence and expertise to effectively transform and manage data using Power Query, significantly enhancing your data analysis capabilities in Excel and Power BI.
Disponibile da: 26/09/2024.
Lunghezza di stampa: 386 pagine.

Altri libri che potrebbero interessarti

  • Family Constellations & Healing Generational Trauma - Real Life Stories & Steps to End Inherited & Ancestral Cycles - cover

    Family Constellations & Healing...

    Dr. Ameet Aggarwal ND

    • 0
    • 0
    • 0
    Do you struggle with generational trauma, chronic illness, or mental health patterns that seem to have no clear cause in your own life? 
    You are not alone. As groundbreaking research in epigenetics - and Bert Hellinger, founder of Family Constellations - reveal, we often carry the unresolved trauma of our ancestors in our bodies. The persistent fear, the unexplained physical pain, or even deep-seated mental health struggles may not belong to you at all. It may be a systemic entanglement—a burden passed down through inherited family trauma. 
    In this Family Constellations Guidebook, Dr. Ameet Aggarwal—voted one of the Top 43 Naturopaths worldwide—bridges the gap between Bert Hellinger's systemic insights and modern holistic health. 
    Inside these real life stories, you will discover:The Science of Systemic Entanglement: Academically grounded explanations of how trauma travels through generations and manifests as physical symptoms or chronic mental health struggles.A Holistic Health Revolution: Witness the profound link between family history and the body. Discover how resolving systemic knots impacted physical health, including chronic shoulder pain, epilepsy, and the emotional roots of cellular disease and cancer.The Gestalt Therapy & Somatic Connection: Learn how somatic healing and the "Here and Now" principles of Gestalt therapy allow you to bypass intellectual defenses and access the body's wisdom directly. 
    Why This Book is Essential: 
    From addressing chronic anxiety to uncovering the hidden loyalties behind physical illness, you heal your mind, body & soul.
    Mostra libro
  • Among the Forest People - cover

    Among the Forest People

    Clara Dillingham Pierson

    • 0
    • 0
    • 0
    Another delightful children's book by Clara Dillingham Pierson about various forest animals - what they do, and what they are like. Each one also giving subtle moral and life lessons to young children. - Summary by Claire Schreuder
    Mostra libro
  • Artificial Intelligence with Python for Beginners - Comprehensive Guide to Building AI Applications - cover

    Artificial Intelligence with...

    James Ferry

    • 0
    • 0
    • 0
    "Artificial Intelligence with Python for Beginners: A Practical Guide to Building AI Applications" is your gateway to understanding and harnessing the power of artificial intelligence using Python. Whether you're a novice programmer, a student eager to explore the world of AI, or a professional looking to expand your skill set, this book offers a comprehensive introduction to the fundamentals of AI and practical guidance on building AI applications. 
    Starting with the basics of Python programming, you'll learn essential concepts and techniques that form the foundation of AI development. From there, you'll delve into the exciting world of machine learning, exploring supervised and unsupervised learning algorithms using popular libraries such as Scikit-learn. Through hands-on projects, you'll gain experience in data analysis, predictive modeling, and evaluation, preparing you to tackle real-world problems with confidence. 
    The journey continues with a deep dive into deep learning, where you'll discover the power of neural networks for tasks like image classification and natural language processing. Using TensorFlow and Keras, you'll build and train neural networks from scratch, mastering essential techniques for model architecture design, training, and evaluation. 
    As you progress, you'll explore advanced topics such as reinforcement learning, diving into algorithms that enable agents to learn through trial and error. Through practical projects and step-by-step tutorials, you'll develop skills in problem-solving, decision-making, and optimization, equipping you to tackle a wide range of AI challenges. 
    Throughout the book, emphasis is placed on hands-on learning, with plenty of code examples, exercises, and projects to reinforce your understanding. By the end, you'll have the knowledge and confidence to build your own AI applications, from predictive models and recommendation systems to intelligent agents and chatbots.
    Mostra libro
  • Battling Drought - cover

    Battling Drought

    Scientific American

    • 0
    • 0
    • 0
    The extreme drought in the US Southwest has brought the issues of water use and management to the forefront of media attention. Historically, arguments over water rights have plagued this area since the days of John Wesley Powell, and disputes mark the relations between states, city-dwellers, farmers, and environmentalists to this day. Add to that the challenges of climate change, which is altering rainfall patterns the world over, and the imperative to rethink water management policies becomes acute. 
    Battling Drought takes a long look at the situation in the American Southwest from the early engineering projects, such as building the Hoover and Grand Coulee dams, which were designed to tame the rivers, to the recycling and restoration efforts of today. Projects like the recycling of wastewater in Santa Rosa, CA, and the restoration of the Aral Sea in Central Asia offer both optimism and lessons for change. However, the story of the Himba in Africa—who have, so far, successfully blocked building a dam on a nearby river—illustrates that changing attitudes is often like trying to change the flow of a river. It’s an upstream battle. While successful projects like these move us toward that goal, new technologies, methods, and crops are still needed to combat diminishing water supplies. A common saying is that someone “spends money like water.” Over the last century, we’ve learned that water might be the more precious of the two.
    Mostra libro
  • The Mycophile’s Handbook - From Spores to Harvest: Your Comprehensive Guide to Mushroom - cover

    The Mycophile’s Handbook - From...

    Jackson Reynolds

    • 0
    • 0
    • 0
    For anyone interested in learning more about the world of fungi, "The Mycophile's Handbook: From Spores to Harvest: Your Comprehensive Guide to Mushrooms" is an indispensable resource. This book, written by seasoned mycologists, provides a comprehensive look into the production of mushrooms, encompassing everything from sophisticated cultivation methods to the fundamentals of mushroom biology. Readers will discover how to grow a range of mushrooms at home or on a bigger scale with concise explanations and helpful tips. 
    The book starts off with an overview of the taxonomy, ecology, and life cycle of mushrooms—a fascinating subject in and of itself. The many kinds of mushrooms, from edible kinds to therapeutic species, and their distinctive qualities will become more transparent to readers. 
    Readers will find comprehensive directions for producing mushrooms from spore to harvest as they work their way through the book. The subjects addressed include choosing appropriate substrates, vaccinating spawn, controlling environmental factors, and resolving frequent issues. Whether you want to produce medicinal mushrooms for therapeutic purposes or exquisite mushrooms for culinary delights, this manual offers the information and direction you need to be successful. 
    The book covers mushroom production methods as well as culinary and medicinal applications, emphasizing the nutritional content and possible health advantages of mushrooms. There are many delectable recipes and remedies that will inspire readers to include mushrooms in their diet. 
    For mushroom enthusiasts of all levels, "The Mycophile's Handbook" is an indispensable reference that is thorough, approachable, and authoritative. Whether you're a novice seeking to get started or a skilled producer wishing to improve your techniques, this guide includes all the information you need to start your fulfilling mushroom adventure.
    Mostra libro
  • Why Your Phone Knows You Better Than Your Friends - cover

    Why Your Phone Knows You Better...

    Felix Crane

    • 0
    • 0
    • 0
    This audiobook is narrated by an AI Voice.  
    Discover how your smartphone has become the most intimate surveillance device in history, collecting data that reveals more about you than you know about yourself. This unsettling audiobook examines how mobile devices track every location, communication, search, purchase, and app interaction to construct psychological profiles of unprecedented accuracy. Learn why tech companies understand your habits, desires, vulnerabilities, and intentions better than people who have known you for years based solely on phone usage patterns. The narrator reveals specific data collection practices that transform innocent-seeming activities into psychological intelligence that predicts your behavior with disturbing accuracy. Discover how phone data reveals health conditions, financial status, relationship problems, and mental states you have shared with no one through patterns invisible to you but obvious to algorithms. Understand why you willingly carry the ultimate surveillance device everywhere, granting access to your life that no previous authoritarian regime could have imagined. This audiobook examines the business models that incentivize maximum data extraction, the psychological manipulation techniques that keep you engaged despite harm, and the impossibility of informed consent for data practices too complex for anyone to understand. Learn practical strategies for reducing phone surveillance and reclaiming privacy within the constraints of digital dependence. Essential listening for anyone carrying a smartphone who wants to understand what they are actually carrying.
    Mostra libro