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
Data Modeling with Microsoft Excel - Model and analyze data using Power Pivot DAX and Cube functions - cover

Data Modeling with Microsoft Excel - Model and analyze data using Power Pivot DAX and Cube functions

Bernard Obeng Boateng

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

Microsoft Excel's BI solutions have evolved, offering users more flexibility and control over analyzing data directly in Excel. Features like PivotTables, Data Model, Power Query, and Power Pivot empower Excel users to efficiently get, transform, model, aggregate, and visualize data.Data Modeling with Microsoft Excel offers a practical way to demystify the use and application of these tools using real-world examples and simple illustrations.This book will introduce you to the world of data modeling in Excel, as well as definitions and best practices in data structuring for both normalized and denormalized data. The next set of chapters will take you through the useful features of Data Model and Power Pivot, helping you get to grips with the types of schemas (snowflake and star) and create relationships within multiple tables. You’ll also understand how to create powerful and flexible measures using DAX and Cube functions.By the end of this book, you’ll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions.
Available since: 11/30/2023.
Print length: 316 pages.

Other books that might interest you

  • How Algorithms Shape Your Choices - cover

    How Algorithms Shape Your Choices

    Marcus Reed

    • 0
    • 0
    • 0
    Every time you scroll, click, or swipe, invisible systems are quietly deciding what you see next. How Algorithms Shape Your Choices takes readers behind the screen to uncover how recommender engines, attention metrics, and predictive models influence not only what we consume — but what we believe. In clear, accessible language, it reveals how the digital world builds personalized realities that guide our thoughts and behaviors without asking for permission. From filter bubbles to algorithmic bias, it traces how data-driven design became the most powerful force in modern life — and how understanding it is the first step toward reclaiming control. This isn’t a story about technology; it’s a story about human freedom in an age of invisible influence.
    Show book
  • The Petroleum Papers - Inside the Far-Right Conspiracy to Cover Up Climate Change - cover

    The Petroleum Papers - Inside...

    Geoff Dembicki

    • 0
    • 0
    • 0
    Burning fossil fuels will cause catastrophic global warming: this is what top American oil executives were told by scientists in 1959. But they ignored that warning. Instead, they developed one of the biggest, most polluting oil sources in the world—the oil sands in Alberta, Canada. As investigative journalist Geoff Dembicki reveals in this explosive book, the decades-long conspiracy to keep the oil sands flowing into the US would turn out to be one of the biggest reasons for the world's failure to stop the climate crisis. 
     
     
     
    In The Petroleum Papers, Dembicki draws from confidential oil industry documents to uncover for the first time how companies like Exxon, Koch Industries, and Shell built a global right-wing echo chamber to protect oil sands profits—a misinformation campaign that continues to this day. He also tells the high-stakes stories of people fighting back: a Seattle lawyer who brought down Big Tobacco and is now going after Big Oil, a Filipina activist whose family drowned in a climate disaster, and a former Exxon engineer pushed out for asking hard questions. 
     
     
     
    With experts now warning we have less than a decade to get global emissions under control, The Petroleum Papers provides a step-by-step account of how we got to this precipice—and the politicians and companies who deserve our blame.
    Show book
  • The Spontaneous Evolution Experience - The Choice to Become a New Species - cover

    The Spontaneous Evolution...

    Bruce H. Lipton PhD

    • 0
    • 0
    • 0
    A Momentous Change Is Upon UsIn his groundbreaking book, The Biology of Belief, Dr. Bruce Lipton outlined the evidence that our thoughts are just as important as our genes in controlling our health and evolution. As the emerging science of epigenetics shows, our beliefs and choices can control our biology down to a cellular level. According to Dr. Lipton, this startling scientific insight suggests a major evolutionary shift for the human species is on the horizon. With The Spontaneous Evolution Experience, he reveals how the forces of history—including dangerous trends like climate change and overpopulation—are creating the conditions for a transformation so profound that we could soon become an entirely new species. As Dr. Lipton explains, “Just as a terminally ill patient can have a ‘spontaneous remission,’ usually following a major life change or change in beliefs, I believe that human society is now on the verge of a similar evolutionary healing on a global scale.” Over the course of three fascinating audio sessions, Dr. Lipton examines the beliefs that have brought us to this precarious time—and what new beliefs will give humanity the chance to overcome the obstacles of today. Join this pioneering biologist as he presents a bold and hopeful vision of the next, “holistic” stage of human civilization—and what each of us can do to fully participate as co-creators of the world to come.
    Show book
  • Google for Grownups: Tools You’re Not Using (But you Should) - Unlock Hidden Google Features to Boost Productivity Discover Insights and Master Everyday Tech - cover

    Google for Grownups: Tools...

    Aarav Khadka

    • 0
    • 0
    • 0
    Discover the hidden powers of Google in Google for Grownups: Tools You’re Not Using (But you Should). This audiobook teaches practical tips, secret features, and advanced tricks for Gmail, Google Calendar, Google Maps, Google Alerts, and more. Perfect for professionals, students, and tech enthusiasts who want to boost productivity, organize life, and explore Google like never before.
    Show book
  • Marie Curie - History of the Pioneer Radioactivity Researcher - cover

    Marie Curie - History of the...

    Kelly Mass

    • 0
    • 0
    • 0
    Marie Salomea Skodowska Curie was a Polish-born, naturalized-French researcher and chemist who originated radioactivity research. She was the first woman to win the Nobel Prize, the first and only woman to win it two times, and the only individual to win the Nobel Prize in 2 different clinical classifications. 
    Her first Nobel Prize was co-won by her spouse, Pierre Curie, making them the first married set to win the reward and developing the Curie family tradition of 5 Nobel Prizes. She was the first woman to be selected as a teacher at the University of Paris in 1906. 
    Let’s take a look at what else she accomplished in her life.
    Show book
  • Keep Smiling - An Insider’s Look at Dental Care - cover

    Keep Smiling - An Insider’s Look...

    Jack Saroyan D.D.S.

    • 0
    • 0
    • 0
    This audiobook is narrated by an AI Voice.  
    Our teeth should last a lifetime. For many Americans this is not the case despite the world's best technology and treatment. Most dentists emphasize treatment over prevention. Daily oral hygiene is talked about but not taught to dental students or patients. Something is very wrong when regular patients with common gingivitis are referred to a periodontal specialist. It is time for dentists, patients and policy makers to be given an insider's look on the importance of oral hygiene habits and its effect on your dental and general health. 
    A folksy and engaging testimony to a great man and the dental profession to which he has devoted his life. Dr. Saroyan has weaved a story of his own experiences in dentistry with the basics of a dental education for the layperson emphasizing common sense prevention. As an advocate for optimum oral health, Dr. Saroyan looks at the controversies surrounding fluoridation and offers suggestions for a compromise. His insights into and opinions of dentistry and dental profession politics are deep and positions are always taken with the public’s health in mind. A great read for those who are in the profession and those who are interested in what goes on in their mouths. 
    This book is worthwhile reading for dental patients, aspiring dental students, and dental professionals. Doctor Saroyan is an exemplar of continued lifelong learning through serving the faculty of a dental school with his emphasis on prevention. Dr. Saroyan pulls no punches by revealing his frank and strong opinions in which dental public health can be improved by professional organized efforts.
    Show book