Beginning Power BI (2nd Edition)


File Size: 9.40 Mb

Description
Self-service business intelligence (BI)—you have heard the hype, seen the sales demos, and are ready to give it a try. Now what? You have probably checked out a few web sites for examples, given them a try, and learned a thing or two, but you are probably still left wondering how all the pieces fit together and how you go about creating a complete solution. If so, this book is for you. It takes you step by step through the process of analyzing data using the tools that are at the core of Microsoft’s self-service BI offering: Power Query, Power Pivot, and Power BI.

Quite often, you need to take your raw data and transform it in some way before you load it into the data model. You may need to filter, aggregate, or clean the raw data. I show you how Power Query allows you to easily transform and refine data before incorporating it into your data model. Next, I show you how to create robust, scalable data models using Power Pivot. Because Power Pivot is the core tool you will use to create self-service BI solutions, I cover it extensively in this book. Next up, I show you how to use Power BI Desktop to easily build interactive visualizations that allow you to explore your data to discover trends and gain insight. Finally, I show you how to deploy your solution to the Power BI Service for your colleagues to use.

I strongly believe that one of the most important aspects of learning is doing. You can’t learn how to ride a bike without jumping on a bike, and you can’t learn to use the BI tools without actually interacting with them. Any successful training program includes both theory and hands-on activities. For this reason, I have included a hands-on activity at the end of every chapter designed to solidify the concepts covered in the chapter. I encourage you to work through these activities diligently. It is well worth the effort.

Content:-
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Part I: Building Models in Power Pivot
Chapter 1: Introducing Power Pivot
Chapter 2: Importing Data into Power Pivot
Chapter 3: Data Munging with Power Query
Chapter 4: Creating the Data Model
Chapter 5: Creating Calculations with DAX
Chapter 6: Creating Measures with DAX
Chapter 7: Incorporating Time Intelligence
Chapter 8: Data Analysis with Pivot Tables and Charts
Part II: Building Interactive Reports and Dashboards with Power BI Desktop
Chapter 9: Introducing Power BI Desktop
Chapter 10: Creating Reports with Power BI Desktop
Chapter 11: Publishing Reports and Creating Dashboards in the Power BI Portal
Chapter 12: Creating a Complete Solution
Chapter 13: Advanced Topics in Power Query
Chapter 14: Advanced Topics in Power BI
Index

Author Details
"Dan Clark" is a senior business intelligence (BI)/programming consultant specializing in Microsoft technologies. He is focused on learning new BI/data technologies and on training others how to best implement the technology.




Download Drive-1

You May Also Like These E-Books:-

No comments:

Post a Comment