Skip to main content
SpringerLink
Log in
Apress
Book cover

Beginning Power BI

A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop

  • Book
  • © 2017

Overview

Authors:
  1. Dan Clark

    1. Camp Hill, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Combine ever-popular Excel functionality with Microsoft's cutting-edge Power BI platform
  • Sort, clean, analyze, and visualize data using Excel 2016 and Power BI Desktop
  • Learn from an experienced instructor and multi-book author

  • 123k Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xvii
    Download chapter PDF

  2. Building Models in Power Pivot

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Introducing Power Pivot

      • Dan Clark
      Pages 3-18

    3. Importing Data into Power Pivot

      • Dan Clark
      Pages 19-54

    4. Data Munging with Power Query

      • Dan Clark
      Pages 55-75

    5. Creating the Data Model

      • Dan Clark
      Pages 77-99

    6. Creating Calculations with DAX

      • Dan Clark
      Pages 101-117

    7. Creating Measures with DAX

      • Dan Clark
      Pages 119-143

    8. Incorporating Time Intelligence

      • Dan Clark
      Pages 145-164

    9. Data Analysis with Pivot Tables and Charts

      • Dan Clark
      Pages 165-189

  3. Building Interactive Reports and Dashboards with Power BI Desktop

    1. Front Matter

      Pages 191-191
      Download chapter PDF

    2. Introducing Power BI Desktop

      • Dan Clark
      Pages 193-216

    3. Creating Reports with Power BI Desktop

      • Dan Clark
      Pages 217-249

    4. Publishing Reports and Creating Dashboards in the Power BI Portal

      • Dan Clark
      Pages 251-281

    5. Creating a Complete Solution

      • Dan Clark
      Pages 283-300

    6. Advanced Topics in Power Query

      • Dan Clark
      Pages 301-318

    7. Advanced Topics in Power BI

      • Dan Clark
      Pages 319-342

  4. Back Matter

    Pages 343-348
    Download chapter PDF
Back to top

Keywords

About this book

Analyze your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualizations and share them 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 second edition includes new material on advanced uses of Power Query, along with the latest user guidance on the evolving Power BI platform. Beginning Power BI is your hands-on guide to quick, reliable, and valuable data insight.

What You'll 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

Who This Book Is For

Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data



Reviews

“The goal of this book is to expose readers to the various tools in Microsoft’s self-service BI stack, built over Excel 2016, comprising Power Pivot, Power BI Desktop, Power Query, and DAX to enable them to analyze and gain insight into their data. … The book is easy to read and use because of its lucid style. It should interest Excel users looking to enhance their data analysis skills.” (Computing Reviews, August, 2017) 

Authors and Affiliations

  • Camp Hill, USA

    Dan Clark

About the author

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. Dan has published several books and numerous articles on .NET programming and BI development. He is a regular speaker at various developer/database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. In a previous life, he was a physics teacher; he is still inspired by the wonder and awe of studying the universe and figuring out why things behave the way they do. 

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation