Analyzing Data with Power Bi and Power Pivot for Excel
Description
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 questionsAbout 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
Analyzing Data with Power Bi and Power Pivot for Excel (ISBN-13: 9781509302765), written by Alberto Ferrari, Marco Russo, was published by Pearson Education in 2017-04-19. The Analyzing Data with Power Bi and Power Pivot for Excel textbook is widely used in colleges and universities across the country. You can rent or buy Analyzing Data with Power Bi and Power Pivot for Excel (Paperback) from Valore, along with many other new and used textbooks. Valore provides affordable textbooks, trusted sellers, and fast delivery to help you succeed in your studies.
Description
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 questionsAbout 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
Analyzing Data with Power Bi and Power Pivot for Excel (ISBN-13: 9781509302765), written by Alberto Ferrari, Marco Russo, was published by Pearson Education in 2017-04-19. The Analyzing Data with Power Bi and Power Pivot for Excel textbook is widely used in colleges and universities across the country. You can rent or buy Analyzing Data with Power Bi and Power Pivot for Excel (Paperback) from Valore, along with many other new and used textbooks. Valore provides affordable textbooks, trusted sellers, and fast delivery to help you succeed in your studies.
Frequently Asked Questions
The most affordable way to get Analyzing Data with Power Bi and Power Pivot for Excel by Alberto Ferrari, Marco Russo is usually renting. We offer flexible rental periods, as well as options to buy it used or new at a discount. Check the pricing table above for the current lowest price.
Used books and rentals do not guarantee an active access code. If your professor requires a platform like Connect, MindTap, or MyLab for homework, you may need to purchase an access code separately.
We know the syllabus moves fast! Standard shipping usually takes 3-5 business days, but we offer expedited shipping options at checkout so you can get Analyzing Data with Power Bi and Power Pivot for Excel before your first major assignment.
You can rent Analyzing Data with Power Bi and Power Pivot for Excel (9781509302765) for a standard 125-day semester term or a 90-day quarter term, with options to extend your rental. You just need to return it by the due date listed on your order.
Yes! We have a textbook buyback program. If you purchase the physical copy of Analyzing Data with Power Bi and Power Pivot for Excel, you can enter your ISBN (9781509302765) into our sell back page at the end of the term to see the current offer, print a shipping label, and get paid. Just make sure to check out our sell back condition guide first so you know what we accept!
We understand schedule changes happen. You can return Analyzing Data with Power Bi and Power Pivot for Excel for a refund within 14 days after the delivery of your item, provided it is in the same condition it was sent in. See our return policy for more information.
Yes! If your professor only requires the online homework platform (like Connect, MindTap, or MyLab), you can purchase a standalone access code for Analyzing Data with Power Bi and Power Pivot for Excel without buying a physical book, provided we currently have the standalone code in stock.