Book description
Analyze company data quickly and easily using Microsoft’s powerful data tools. Learn to build scalable and robust data models, clean and combine different data sources effectively, and create compelling and professional visuals.
Beginning Power BIis a hands-on, activity-based guide that takes you through the process of analyzing your data using the tools that that encompass the core of Microsoft’s self-service BI offering. Starting with Power Query, you will learn how to get data from a variety of sources, and see just how easy it is to clean and shape the data prior to importing it into a data model. Using Power BI tabular and the Data Analysis Expressions (DAX), you will learn to create robust scalable data models which will serve as the foundation of your data analysis. From there you will enter the world of compelling interactive visualizations to analyze and gain insight into your data. You will wrap up your Power BI journey by learning how to package and share your reports and dashboards with your colleagues.
Author Dan Clark takes you through each topic using step-by-step activities and plenty of screen shots to help familiarize you with the tools. This third edition covers the new and evolving features in the Power BI platform and new chapters on data flows and composite models. This book is your hands-on guide to quick, reliable, and valuable data insight.
What You Will Learn
- Simplify data discovery, association, and cleansing
- Build solid analytical data models
- Create robust interactive data presentations
- Combine analytical and geographic data in map-based visualizations
- Publish and share dashboards and reports
Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data
Table of contents
- Cover
- Front Matter
- 1. Introducing Power BI
- 2. Importing Data into Power BI Desktop
- 3. Data Munging with Power Query
- 4. Creating the Data Model
- 5. Creating Calculations with DAX
- 6. Creating Measures with DAX
- 7. Incorporating Time Intelligence
- 8. Creating Reports with Power BI Desktop
- 9. Publishing Reports and Creating Dashboards in the Power BI Portal
- 10. Introducing Power Pivot in Excel
- 11. Data Analysis with Pivot Tables and Charts
- 12. Creating a Complete Solution
- 13. Advanced Topics in Power Query
- 14. Advanced Topics in Power BI Desktop
- 15. Advanced Topics in Power BI Data Modeling
- Back Matter
Product information
- Title: Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics
- Author(s):
- Release date: February 2020
- Publisher(s): Apress
- ISBN: 9781484256206
You might also like
book
Data Analysis with Microsoft Power BI
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Microsoft Power BI Data Analyst Certification Guide
Gain the knowledge and skills needed to become a certified Microsoft Power BI data analyst and …
book
Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, 2nd Edition
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's …
book
Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition
Analyze your company's data quickly and easily using Microsoft's latest tools. You will learn to build …