Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
Advanced Analytics with Power BI and Excel - Learn powerful visualization and data analysis techniques using Microsoft BI tools along with Python and R - cover

Advanced Analytics with Power BI and Excel - Learn powerful visualization and data analysis techniques using Microsoft BI tools along with Python and R

Dejan Sarka

Publisher: Orange Education Pvt Ltd

  • 0
  • 0
  • 0

Summary

Empowering You to Master Business Intelligence and Solve Real-world Analytical Problems.DESCRIPTIONIn today's analytics landscape, proficiency in Excel and Power BI is practically a prerequisite for a successful career. This book provides a concise yet comprehensive exploration of these foundational elements of modern Business Intelligence (BI).Comprising ten chapters, this book covers the entire development journey of a Power BI analytical solution, spanning from data modeling and preparation to report creation, publication, and dashboard and app deployment. It offers insights into security measures and performance optimization, ensuring a well-rounded understanding of the BI ecosystem. Furthermore, it delves into advanced topics, such as leveraging data science algorithms within reports, offering readers an extensive learning experience. The book takes a holistic approach to these technologies, offering a contrast to the narrow perspectives often adopted by contemporary BI professionals who rely solely on a single tool or language. The book allows data enrichment through calculations that can be achieved using various languages, including SQL queries at the source, Power Query Formula Language, M, Python, R, and DAX. By the end of this book, you will master these options but be able to also weigh their pros and cons to make informed decisions.TABLE OF CONTENTS 1. Introducing the Theoretical Background for Democratizing Analytics2. Acquiring and transforming data from multiple sources3. Power Query Transformations and Formula Language (M) Overview4. Building a simple analytical solution with Power Pivot in Excel5. Enhancing the model and business analysis with DAX6. Creating reports in Power BI Desktop7. Using the Power BI Service8. Data Science in Power BI 9. Optimizing Power BI models and reports10. Deploying, Maintaining, and Securing Power BI Assets       Index
Available since: 10/13/2023.

Other books that might interest you

  • Climate Worrier: A Hypocrite’s Guide to Saving the Planet - cover

    Climate Worrier: A Hypocrite’s...

    Colm O’Regan

    • 0
    • 0
    • 0
    Bestselling author Colm O’Regan is a worrier. A professional one. Caution is his watchword. Risk aversion is his love language. Now Colm is grappling with the biggest worry of all: the whole ‘planet being on fire’ thing and how exactly we can help. 
    Don’t worry, this isn’t a book telling you how to live off the grid and make your own planet-friendly soap from woodlice (that’s the sequel). Instead, Climate Worrier is about the journey, about trying (and often failing) to be part of the solution to the big issues, while not despairing at the endless hypocrisies that come from also being part of the problem. It’s about trying to be become the greenest version of yourself; about joining the ranks of those who give a shit and do a bit. 
    So if you’ve fretted about: 
    - using your diesel car to get closer to nature, 
    - eating your ethical food off a plastic plate, 
    - existing 
    and have a general feeling we’re all doing too little, too late, Climate Worrier is the book for you. 
    In Climate Worrier, O'Regan offers a humorous and relatable take on the struggles of trying to live an environmentally friendly lifestyle. His essays on the topic are both enlightening and entertaining, making this book a top pick for environmentalists and conservationists alike. 
    For fans of Emer Mclysaght (Oh My God, What a Complete Aisling), and Britney Spears (The woman in me). 
    HarperCollins 2022
    Show book
  • A Country of Two Agricultures - cover

    A Country of Two Agricultures

    Wandile Sihlobo

    • 0
    • 0
    • 0
    Nearly three decades after the dawn of democracy, South Africa has remained a country of 'two agricultures'. On the one hand we have a subsistence, primarily non-commercial, black farming segment. On the other hand, however, we have a predominantly commercial and white farming sector that is well-resourced and has access to domestic and international trade networks.
    These disparities can be traced back to South Africa's painful history where, for decades, black farmers were on the margins of government support and also experienced land dispossession and livestock plunder.
    A Country of Two Agricultures focuses less on history and more on the present and the future, explaining why these disparities have persisted in the democratic era, and what it will take to overcome them. It aims to contribute to a better understanding of the variety of agricultural forces, taking into account both questions of domestic political economy and external factors, as well as to bring to light new risks and opportunities.
    Wandile Sihlobo offers insights into the role of agriculture in the South African economy from an agricultural economy perspective, and provides political economy insights that are rooted in the experiences of farming communities on the ground and right through the value chain.
    Beyond insights on the realities this book offers the government, the private sector, and anyone interested in the betterment of the South African economy, tools to grapple with this duality, and proposes a framework for bolstering the black farming segment for growth and competitiveness – and ultimately food security.
    Wandile Sihlobo is the Chief Economist of the Agricultural Business Chamber of South Africa (Agbiz) and the author of Finding Common Ground: Land, Equity and Agriculture.
    Show book
  • Here Where Death Delights - A Literary Memoir - cover

    Here Where Death Delights - A...

    Mary Jumbelic M.D.

    • 0
    • 0
    • 0
    Mary Jumbelic has been obsessed with death since the loss of her father when she was 13. The sudden departure of her dad, the mother left behind, and her position as an only child led her to grow up quickly. Yet the why and how of her father's death plagued her. She chose to view an autopsy at the age of 15 and discovered a science that explained the process. College, medical school and becoming a forensic pathologist wasn't a given. She struggled before ultimately deciding on a career as a medical examiner.For 25 years, she analyzed corpses and explained to families what had happened to their loved ones, something that hadn't been done for her. She faced blood, gore, violence, and grief in urban and country morgues. She worked for the federal government and internationally in mass disasters. This daily confrontation challenged her to re-live her own loss. She became an advocate in recognizing preventable injuries to help reduce fatalities. Dr. Jumbelic developed a way to honor the person's life by speaking for them in courts, classrooms, and interviews. How did she finally integrate death into her own life so filled with hope? This is her journey.Mary Jumbelic, M.D., is a board-certified forensic pathologist who has performed thousands of autopsies. She received awards from the National Transportation Safety Board and the New York State Senate, and has been recognized by the National Organization of Women as a trailblazer. This is her first book, an interweaving of personal and professional stories that demystify death. She lives with her husband in Central New York. Her motto is "I speak for the dead. They speak for me."
    Show book
  • Mayo Clinic Guide to Gut Health - Restore Your Microbiome Enhance Digestion and Improve Your Health from the Inside Out - cover

    Mayo Clinic Guide to Gut Health...

    M.B.B.S. Sahil Khanna

    • 0
    • 0
    • 0
    A comprehensive guide to understanding your gut, its influence on your health, and what you can do to protect it. 
    Digestion may be its primary job, but your gut is pulling double duty behind the scenes. Sometimes referred to as the body’s “second brain,” your gut plays an important role in everything from immunity and brain function to metabolism and skin health. 
    Within your gut resides a bustling community of trillions of microorganisms working 24/7 to fight off harmful invaders, create essential nutrients, and keep your body running like a well-oiled machine. When this delicate ecosystem, known as the gut microbiome, is thrown off balance, it can trigger a range of health issues. 
    Mayo Clinic Guide to Gut Health is an expert-driven resource from Mayo Clinic gastroenterologists that explores everything you need to know to take control of digestive issues.
    Show book
  • Extinctions - How Life Survives Adapts and Evolves - cover

    Extinctions - How Life Survives...

    Michael J. Benton

    • 0
    • 0
    • 0
    Cutting-edge techniques across biology, chemistry, physics, and geology have transformed our understanding of the deep past, including the discovery of a previously unknown mass extinction. This compelling evidence, revealing a series of environmental crises resulting in the near collapse of life on Earth, illuminates our current dilemmas in exquisite detail. 
     
     
     
    Beginning with the oldest, Professor Michael J. Benton takes us through the "big five" die outs: the Late Ordovician, which set the evolution of the first animals on an entirely new course; the Late Devonian, apparently brought on by global warming; the cataclysmic End-Permian, also known as the Great Dying, which wiped out over 90 percent of all life on Earth; the newly discovered Carnian Pluvial Event; and the End-Cretaceous asteroid. He examines how global warming, acid rain, ocean acidification, erupting volcanoes, and meteorite impact have affected conditions on Earth, and how life survived, adapted, and evolved. 
     
     
     
    In Extinctions, listeners will learn about revolutionary new tools used to uncover ancient extinction events and processes in forensic detail, and how scientists are improving our understanding of the deep past. New research allows us to link long-ago upheavals to crises in our current age, the Anthropocene, with important consequences for us all.
    Show book
  • How To Turn Back Time - cover

    How To Turn Back Time

    Michael Mathiesen

    • 0
    • 0
    • 0
    A new theory of Time Wave Modulation and the Time Doppler Effect. Could have an impact as big or bigger than when Einstein published his General Theory of Relativity. Your aid and support is requested in helping the author get the proof of his theory of Time Waves through the upcoming European Space Agency's (ESA) huge new Laser Interferometer Space Antenna (LISA)   
    If you have ever thought about turning back time to solve one of the greatest mysteries in your life - this book is for you! 
    When this brave new theory is proven by the largest scientific experiment in history - over 15 million Kilometers sent into space, if you own this book, you'll be able to explain the science that will change everything to your friends and family.  Einstein's theory of Relativity is one of the greatest new science of the last century.  Michael Mathiesen's new theory of Time Wave Relativity will be the most important new science of this century.
    Show book