Analyzing Data with Power BI and Power Pivot for Excel

By Alberto Ferrari & Marco Russo

Analyzing Data with Power BI and Power Pivot for Excel - Alberto Ferrari & Marco Russo

More by Alberto Ferrari & Marco Russo : Analyzing Data with Power BI and Power Pivot for Excel

Related Books

Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will:• Gain an understanding of the basics of data modeling, including tables, relationships, and keys• Familiarize yourself with star schemas, snowflakes, and common modeling techniques• Learn the importance of granularity• Discover how to use multiple fact tables, like sales and purchases, in a complex data model• Manage calendar-related calculations by using date tables• Track historical attributes, like previous addresses of customers or manager assignments• Use snapshots to compute quantity on hand• Work with multiple currencies in the most efficient way• Analyze events that have durations, including overlapping durations• Learn what data model you need to answer your specific business questions About This Book• For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data

Recent Posts
Creative Selection
The Book of Why
Ghost in the Wires
Adobe Photoshop CC Classroom in a Book (2018 release), 1/e
CompTIA Security+ All-in-One Exam Guide, Fifth Edition (Exam SY0-501)
(ISC)2 CISSP Certified Information Systems Security Professional Official Study Guide
Mastering Apple TV 4K - The Ultimate User Guide To Apple TV Using Siri Remote
Dawn of the New Everything
Roblox Kindle Fire OS Game Guide Unofficial
Agile Web Development with Rails 5.1
Effective C++
My iMovie
Watch Os 3 for the Apple Watch: An Easy Guide to the Best Features
How to Create a Successful Website with Wordpress
Dive into Java Script
CCNA Data Center DCICT 200-155 Official Cert Guide
CompTIA A+ Certification All-in-One Exam Guide, Ninth Edition (Exams 220-901 & 220-902)
SQL Short Course (Database Programming)
iPhone X Pro Guide
The Art of Invisibility
Adobe Illustrator CC Classroom in a Book (2018 release), 1/e
Excel 2016 Bible
iPhone 8 Advanced Guide
Iphone X: Beginner’s Guide
Getting Started with CNC
Barron's AP Computer Science A, 8th edition with Bonus Online Tests
Adobe InDesign CC Classroom in a Book (2018 release), 1/e
Fusion 360 for Makers
Mastering Microsoft Power BI
Effective Modern C++
Prediction Machines
The Java Language Specification, Java SE 8 Edition
Computer Science Made Simple
Exploring Raspberry Pi
Excel Power Pivot and Power Query For Dummies
IT Architecture For Dummies
Python Crash Course
Outlook 2013 For Dummies
SharePoint 2016 for Dummies
A Newbie's Guide to Apple Watch
CEH v9
XML: Visual QuickStart Guide
"Is This Thing On?"
Carry On
Microsoft Project 2016 Step by Step, 1/e
PHP for the Web
Cisco ASA
The Absolute Beginner's Guide to Binary, Hex, Bits, and Bytes! How to Master Your Computer's Love Language
Java All-in-One For Dummies
Microsoft Power BI Cookbook
Mobile Genealogy
JavaFX For Dummies
Python for Beginners
iPad For Dummies
Tutor for Safari for iPad
CompTIA A+ Practice Tests
Python Machine Learning: Machine Learning Algorithms for Beginners - Data Management and Analytics for Approaching Deep Learning and Neural Networks from Scratch
Streaming Systems
Investigating Cryptocurrencies
Python Testing with pytest
Rails Crash Course
Springer Handbook of Model-Based Science
Java Deep Learning Essentials
Learning Microsoft Azure
Engineering a Compiler: Second Edition
iCloud Starter Guide
Know Your iPad: Tutorials and User Guides
Machine Learning for Dummies
Iphone 8: Beginner’s Guide
Getting Started with D3
The Beginners Guide to Using the Newest Apple TV (Fourth Generation - 2015)
Invent Your Own Computer Games with Python, 4E
Web Scraping With Python
Malware Data Science
Google Chrome Add Ons: Top 50 Add Ons
The Master Algorithm
Excel 2016 All-in-One for Dummies
iPhone X Tips, Tricks and Tweaks
CompTIA Security+ Study Guide
Eloquent JavaScript, 3rd Edition
Effective Java, 3/e
iPhone X For Dummies
CompTIA Network+ Certification All-in-One Exam Guide, Seventh Edition (Exam N10-007)
Excel Formulas and Functions For Dummies
Beginning Java Programming
SQL For Dummies
The Future of Leadership
Wireshark for Security Professionals
iPad Pro Guidebook
Agile Project Management Methodology for Beginners: Scrum Project Management for Beginners
How Computers Work, 9th Edition, Multi-Touch Version
#iPadOnly. The First Real Post-PC Book [iPad Version]
Macbook Pro 2017 With Touch Bar: The Complete Guide
C Programming Absolute Beginner's Guide, 3/e
iTunes and iCloud for iPhone, iPad, & iPod touch Absolute Beginner's Guide