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

  • The Backwoods of Everywhere - Words From a Wandering Local - cover

    The Backwoods of Everywhere -...

    R. E. Burrillo

    • 0
    • 0
    • 0
    Throughout personal essays spiked with humor and natural science, archaeologist R. E. Burrillo widens his range beyond his popular Behind the Bears Ears. 
     
     
     
    After an upstate New York childhood and a bartending stint in New Orleans's French Quarter, seasonal resort work led R. E. Burrillo to the desert Southwest, whose redrock landscapes were a source of stability through mental and physical illness. In The Backwoods of Everywhere, archaeologist Burrillo excavates his past, examining Indigenous and tourist cultures, the complexities of American archaeology, and what it means to be a local. From the ancient canal systems of Phoenix, Arizona, to the modern Mayan communities of the Yucatan Peninsula, to the depths of the Grand Canyon, Burrillo brings listeners on an entertaining romp chock-full of history, ecology, cultural preservation, and personal stories. 
     
     
     
    In the vein of Bill Bryson, Tim Cahill, and Ellen Meloy, Burrillo's is a fresh voice in humor-spiked nature writing and cultural commentary. Running throughout the wide-ranging topics of The Backwoods of Everywhere are themes of place and locality, and how these vary between cultures and individuals. Marrying the intensely personal with the complex and technical, Burrillo's candid voice brings humor, wonder, irony, and wit to each thought-provoking essay.
    Show book
  • Ecology - Understanding Ecosystems and the Interconnectedness of Life - cover

    Ecology - Understanding...

    Jeron Iris

    • 0
    • 0
    • 0
    Ecology is the branch of biology that deals with the relationships between living organisms and their interactions with their environment. This scientific discipline explores how organisms coexist within ecosystems, interact with one another, and adapt to their surroundings. The study of ecology is vital because it provides insight into the functioning of natural systems and the impact human activities have on the environment. It emphasizes the interdependence of all life forms, from microscopic bacteria to the largest animals, and underscores the intricate balance necessary for sustaining life on Earth. 
    At its core, ecology is concerned with understanding the distribution and abundance of organisms, as well as the processes that shape these patterns. It is a multidisciplinary field that draws from biology, geography, geology, chemistry, and physics. Ecologists examine how factors such as climate, geography, and natural resources influence the diversity of life in different habitats. They also study the effects of human intervention, such as deforestation, pollution, and climate change, on ecosystems.
    Show book
  • Humanoid Robots & Drones: How the Age of Smart Machines Will Revolutionize Our World - cover

    Humanoid Robots & Drones: How...

    Dr. Nick Coman, I. A.I.

    • 0
    • 0
    • 0
    “Humanoid Robots & Drones: How the Age of Smart Machines Will Revolutionize Our World” is a 24‑lecture audio expedition for anyone who likes their wonder with measurements. We chase robots, humanoids, and drones through restaurants, farms, warehouses, hospitals, disaster scenes, stadiums, and city skies—treating each as a solvable puzzle. How does a drone hold position in wind? Why does a humanoid’s shape matter for doors and stairs? When does a non‑humanoid robot beat a humanoid? More often than you’d guess.
     
    You’ll learn the working grammar of the field: motors, cameras, lidar, batteries, and the ugly truth about friction, glare, and radio noise. You’ll see how a drone’s navigation, thermal views, and geofences turn into defect lists, not pretty video; how warehouse robots schedule intersections; why “stop distance” and “payload versus endurance” make or break a plan; and how soft‑skinned humanoids handle the “last ten centimeters” that buildings were designed for human hands. We translate regulation and risk into simple playbooks you can actually use—what the rules permit, what insurers demand, and what keeps neighbors calm.
     
    Expect case studies with receipts: drone light shows that replace fireworks with quiet pixels; roof and bridge inspections before breakfast; farm rigs that spray where plants actually are; hospital runners and delivery bots that save steps and shoulders; telepresence poles and companion robots that help real people on real Tuesdays. The tone is sharp, funny, and unromantic: we puncture hype, celebrate craft, and name failure modes out loud.
     
    By the end, you’ll be able to read a spec sheet like a mechanic, design a credible first deployment, and argue—politely but mercilessly—about the next 10, 25, and 50 years. If you want an operator’s guide to the robots, humanoids, and drones that already work (and the ones that almost do), buckle in. The robots are clocked in, the drones are charged, and class is wheels‑up.
    Show book
  • Quiet Collapse The: How Everyday Choices Shape the Planet’s Future - cover

    Quiet Collapse The: How Everyday...

    Alex Southwick

    • 0
    • 0
    • 0
    We often imagine environmental destruction as something loud and spectacular — burning forests, melting ice, rising seas. But what if the real collapse is happening quietly, in our shopping carts, kitchens, wardrobes, and inboxes? 
    The Quiet Collapse reveals how the rhythms of daily life — what we eat, buy, drive, and even stream — are silently transforming the planet’s systems. Through vivid storytelling and clear-eyed investigation, this book uncovers the hidden environmental costs behind ordinary habits, from the water footprint of a cup of coffee to the carbon trail of a single online purchase. 
    Yet this isn’t a story of despair. Author Alex Southwick shows that the same everyday actions fueling the problem also hold the power to change it. By reconnecting personal choice with planetary impact, The Quiet Collapse invites readers to see themselves not as passive participants in crisis, but as active agents in renewal. 
    Illuminating, hopeful, and unflinchingly honest, this is the book that makes climate change feel both intimate and actionable — not a distant catastrophe, but a quiet revolution beginning in our own lives.
    Show book
  • The Relentless Pursuit of Peace - A Roadmap to Mental Health - cover

    The Relentless Pursuit of Peace...

    Max Coates

    • 0
    • 0
    • 0
    Mental Health is very much on the agenda. This book demystifies a lot of the issues that can affect the majority. It shows how small changes can bring significantly better outcomes.
    Show book
  • Mastering the Art of Virtual Work - cover

    Mastering the Art of Virtual Work

    Patricia Shepard

    • 0
    • 0
    • 0
    Mastering the Art of Virtual Work: A Comprehensive Guide to Building and Managing a Successful Virtual Assistant BusinessBasically a virtual assistant will be able to carry the workload given simply because of the focused nature of the particular assignments given. In most cases such virtual assistance capabilities are much more refined and thus able to handle the delegated task with ease.Hiring the services of virtual assistance would effectively mean hiring someone who is an expert in his or her own field.The need to teach the individual would not be a factor in the equation nor would there be a need to constantly monitor the situation to ensure the desired results are forthcoming.With the use of virtual assistance the assignments can be done within the timelines, as the reputation of the virtual assistance depends broadly on the ability to produce the work effectively and accurately with the time frame agreed upon.In this audiobook, you will learn about A Comprehensive Guide to Building and Managing a Successful Virtual Assistant Business, So what are you waiting for, download a copy of Mastering the Art of Virtual Work today!
    Show book