Last Updated:

As an Amazon Associate I earn from qualifying purchases.

Power BI is a business analytics tool and service made by Microsoft. It was first released in 2013. Power BI allows you to make interactive visualizations, reports, and dashboards with business intelligence capabilities. Here’s a list of the best Power BI tutorials, best Power BI books and best Power BI courses.

Best Power BI tutorials 2019

by Manuel Lorenz and Maximilian Schwarzmüller will help you learn Power BI fast. This tutorial is for absolute beginners. You will learn how to use Microsoft Power BI tools, including Power BI Desktop, Power BI Service, and Power BI Developer tools. This Power BI step by step tutorial will teach you how the different tools work together. You will be able to analyze data from different data sources and create their own datasets. Starting from basics, you will make you way to advanced Power BI features.


You will learn:

  • Learn how to use the different tools of the Power BI ecosystem.
  • Understand Power BI Desktop and its components.
  • Use the Query Editor to connect to various sources.
  • Work on the Data Model.
  • Data Model views.
  • Create calculated columns and measures.
  • Build relationships between different tables.
  • Create Power BI reports with different interactive visualization types.
  • Create dashboards with to share and publish your results.
  • Access your results from multiple devices with Power BI Mobile.
  • Create custom visuals using TypeScript.

PROS

  • Go from beginner to advanced
  • Over 40,000 students
  • Over 10 hours of content

CONS

  • Basic Data Analysis skills will be helpful

SUMMARY

Learn Power BI from the Best Power BI tutorial for beginners in 2019.

by Chris Dutton will help you learn Power BI desktop. You will learn to transform, analyze and visualize data with Power BI Desktop. This Power BI tutorial will teach you to build professional business intelligence reports from scratch. You will connect to hundreds of data sources, build complex relational models and design interactive dashboards.


The Power Bi project has four key objectives:

  • Connect & Transform the Raw Data
  • Build a Relational Data Model
  • Add Calculated Fields with DAX
  • Design Interactive Reports

Each objective will teach many Power BI features. The objectives and what you will learn are:

1) Connect & Transform the Raw Data

  • Intro to the query editor
  • Types of data connectors
  • Basic table transformations
  • Text, number & date tools
  • Index & conditional columns
  • Grouping & aggregating data
  • Pivoting & unpivoting
  • Modifying, merging & appending queries
  • Connecting to folders
  • Defining hierarchies & categories
  • Query editing best practices

2) Build a Relational Data Model

  • Intro to database normalization
  • Data (“Fact”) tables vs. Lookup (“Dimension”) tables
  • Creating table relationships
  • “Star” vs. “Snowflake” schemas
  • Active vs. Inactive relationships
  • Relationship cardinality
  • Connecting multiple data tables
  • Filtering & cross-filtering
  • Hiding fields from report view
  • Data modeling best practices

3) Add Calculated Fields with DAX

  • Intro to data analysis expressions (DAX)
  • Calculated columns vs. Measures
  • Row context vs. Filter context
  • Dax syntax & operators
  • Common function categories
  • Basic date & time formulas
  • Logical & conditional statements
  • Text, math & stats functions
  • Joining data with related
  • Calculate, all & filter functions
  • Dax iterators (sumx, averagex)
  • Time intelligence formulas
  • DAX best practices

4) Design Interactive Reports

  • Intro to the report view
  • Adding objects & basic charts
  • Formatting & filtering options
  • Matrix visuals
  • Slicers & timelines
  • Cards & kpis
  • Map visuals (basic, fill, arcgis)
  • Treemaps, lines, areas & gauges
  • Editing report interactions
  • Adding drillthrough filters
  • Linking to report bookmarks
  • Using “What-if” parameters
  • Managing & viewing roles
  • Data viz best practices

PROS

  • Hands-on and Project based
  • Over 17,000 students
  • Over 9 hours of content

CONS

SUMMARY

Best Power BI Desktop tutorial in 2019. 

by Kirill Eremenko and SuperDataScience Team will help you learn Power BI from scratch. This Power BI course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet. This Power BI tutorial will help you learn how to create treemaps, waterfall diagrams, bar charts, doughnut charts and pie charts. You will connect Power BI to data sources and visualize data in the form of various charts, plots, and maps. Everything needed to convert raw data into data visualizations with Power BI is taught. You will learn Power BI features that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.

You will learn:

  • Connecting Power BI to different datasets
  • Drilling down and up in your visualization and calculate data
  • Visualize data in the form of various charts, plots, and maps
  • Convert raw data into compelling data visualizations using Power BI

PROS


  • Over 14,000 students
  • Over 4 hours of content

CONS

  • Some might find it too short

SUMMARY

This is one of the best Power BI tutorials for Data Science in 2019.

Powerful Reports and Dashboards with Microsoft Power BI

by Ian Littlejohn will help you learn to use Power BI in minutes. You will learn to create reports, analyze data and develop interactive dashboards in minutes by watching the video content provided. This learning courses will help you gain valuable insight and intelligence from your business and marketing data very quickly. Using the drag and drop capability of Microsoft Power BI, you will easily create a wide range of graphs and visualizations. The Power BI business courses contains:

  • Introduction to Power BI.
  • Creating your first online report and dashboard.
  • How to download the Power BI Desktop Designer.
  • Loading, transforming and filtering data in Power BI.
  • Creating tables and reports.
  • Using graphs and visualizations.
  • Creating relationships between tables of data.
  • Creating powerful calculations, key metrics and key performance indicators.
  • Creating interactive dashboards.
  • Publishing dashboards to Power BI.

Some of the latest online videos include:

  • Using the new Table and Matrix visualizations.
  • Creating Drill through between different sheets.
  • Add new Power BI themes from the Community Theme Gallery.
  • Learning custom visualizations from Microsoft Office Store.
  • Share your dashboards and reports using Power BI apps and App workspaces.
  • Relative Date Filters.
  • Quick Measures.
  • Ribbon Chart.

Thu is one of the best Power BI desktop courses in 2019.

Power BI Essentials: Introduction to Microsoft Power BI

Power BI Essentials: Introduction to Microsoft Power BI by Grant Gamble is a comprehensive introduction. These online video training tutorials will teach you how to import and model data and create reports. You will learn how to use the Power BI service for making dashboards, collaboration and content sharing. By the end of the courses, you will be confident in using the main components of Power BI.

Power BI Desktop Masterclass – Data Analysis for Everyone

by Paula Guilfoyle will teach you how to become an expert in Power BI Desktop, a combination of Excels Power Features (Power Pivot, Power Query and Power View) all in a standalone package. This courses will teach you how touse the power of basic DAX to create calculations and comparisons across tables of data from many sources. You will learn how to connect multiple data sources and visualize them. This is one of the best online video training courses.

Best Power BI books 2019

Bestsellers

Bestseller No. 1
Power BI: A Comprehensive Beginner’s Guide to Learn the Basics of Power BI from A-Z
  • Jones, Daniel (Author)
  • English (Publication Language)
  • 141 Pages - 11/03/2019 (Publication Date) - Independently published (Publisher)
Bestseller No. 2
Mastering Microsoft Power BI: Expert techniques for effective data analytics and business intelligence
  • Powell, Brett (Author)
  • English (Publication Language)
  • 638 Pages - 03/29/2018 (Publication Date) - Packt Publishing (Publisher)
SaleBestseller No. 3
Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
  • Holy Macro Books
  • Collie, Rob (Author)
  • English (Publication Language)
  • 308 Pages - 01/01/2016 (Publication Date) - Holy Macro! Books (Publisher)
SaleBestseller No. 4
Microsoft Power BI Dashboards Step by Step
  • O'Connor, Errin (Author)
  • English (Publication Language)
  • 304 Pages - 12/01/2018 (Publication Date) - Microsoft Press (Publisher)
Bestseller No. 5
Introducing Microsoft Power BI
  • Amazon Kindle Edition
  • Ferrari, Alberto (Author)
  • English (Publication Language)
  • 351 Pages - 07/07/2016 (Publication Date) - Microsoft Press (Publisher)
Bestseller No. 6
Applied Microsoft Power BI (4th Edition): Bring your data to life!
  • Lachev, Teo (Author)
  • English (Publication Language)
  • 474 Pages - 01/01/2019 (Publication Date) - Prologika (Publisher)
SaleBestseller No. 7
Supercharge Power BI: Power BI Is Better When You Learn to Write DAX
  • Allington, Matt (Author)
  • English (Publication Language)
  • 186 Pages - 06/01/2018 (Publication Date) - Holy Macro! Books (Publisher)
SaleBestseller No. 8
Pro Power BI Desktop
  • Aspin, Adam (Author)
  • English (Publication Language)
  • 800 Pages - 12/09/2017 (Publication Date) - Apress (Publisher)
SaleBestseller No. 9
Analyzing Data with Power BI and Power Pivot for Excel (Business Skills)
  • Microsoft Press
  • Ferrari, Alberto (Author)
  • English (Publication Language)
  • 256 Pages - 04/29/2017 (Publication Date) - Microsoft Press (Publisher)
Bestseller No. 10
Microsoft Power BI Cookbook: Creating Business Intelligence Solutions of Analytical Data Models, Reports, and Dashboards
  • Powell, Brett (Author)
  • English (Publication Language)
  • 802 Pages - 09/27/2017 (Publication Date) - Packt Publishing (Publisher)

Applied Microsoft Power BI (4th Edition): Bring your data to life!

Applied Microsoft Power BI (4th Edition): Bring your data to life!
  • Lachev, Teo (Author)
  • English (Publication Language)
  • 474 Pages - 01/01/2019 (Publication Date) - Prologika (Publisher)

by Teo Lachev and Edward Price will help you learn and master. This book is ideal for beginners and experienced Power BI developers. The content here helps you learn to implement Power BI solutions for descriptive, real-time, and predictive analytics. You will learn how to integrate custom applications with embed reports, and implement custom visuals to present data. Creating interactive reports and dashboards is the prime focus. The online book provides all the Power BI code used.
You will learn:

  • Get instant insights from cloud services and files.
  • Explore data with interactive reports.
  • Learn to assemble dashboards with a few clicks.
  • Access BI content on mobile devices.
  • Create sophisticated data models.
  • Implement business calculations.
  • Import data from virtually anywhere.
  • Cleanse, transform and shape data.
  • Get insights from data.
  • Deploy to cloud and on premises.
  • Implement organizational BI solutions.
  • Learn to automate Power BI.
  • Report-enable custom applications.
  • Build custom visuals.
  • Apply machine learning.
  • Enable sharing and collaboration.

This is one of the best Power Bi books in 2019.

Microsoft Power BI Dashboards Step by Step

Sale
Microsoft Power BI Dashboards Step by Step
  • O'Connor, Errin (Author)
  • English (Publication Language)
  • 304 Pages - 12/01/2018 (Publication Date) - Microsoft Press (Publisher)

Microsoft Power BI Dashboards Step by Step by Errin O’Connor will help you learn to build Power BI dashboards. This official Power Bi book from Microsoft is perfect for beginners. You will get all the guidance, examples, and code needed to be an expert in Power BI.

This book will teach you to:

  • Successfully design, architect, and implement Power BI.
  • Take full advantage of any Microsoft Power BI platform, including Power BI Premium.
  • Make upfront decisions that position your Power BI project for success.
  • Build rich, live dashboards to monitor crucial data.
  • Aggregate data and data elements from numerous internal and external data sources.
  • Develop dynamic visualizations, including charts, maps, and graphs.
  • Bring data to life with stunning interactive reports.
  • Ensure dashboard security and compliance.
  • Drive user adoption through effective training .

This is one of the best Power BI books in 2019.

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

Sale
Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop
  • Clark, Dan (Author)
  • English (Publication Language)
  • 368 Pages - 03/06/2017 (Publication Date) - Apress (Publisher)

Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop by Dan Clark will help you get started with Power BI. This book is written for Power BI beginners. You will harness the power of Power BI to build scalable and robust data models. This Power BI book teaches you each Power BI feature step-by-step with screenshots. Power Query advance uses along with Power BI platform tips are included.

This Power BI book will help you 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.

This is one of the best Power BI books for beginners in 2019.

Pro Power BI Desktop

Sale
Pro Power BI Desktop
  • Aspin, Adam (Author)
  • English (Publication Language)
  • 800 Pages - 12/09/2017 (Publication Date) - Apress (Publisher)

Pro Power BI Desktop by Adam Aspin will help you learn Power BI Desktop like a professional. You will learn all the latest Power Bi desktop features including combo charts, Cartesian charts, trend lines, use of gauges. This book covers Power BI desktop topics like Top-N features, bin data into groupings, chart the groupings, new techniques for detecting and handling outlier data. You will learn to take data from any source and produce amazing dashboards and reports. How to add metrics and KPIs to your projects with ease is explained.

You will learn Power BI desktop features including:

  • Turn raw data into understandable insight.
  • Combine data from multiple sources into a cleansed and coherent data model.
  • Create dashboards that help in monitoring key performance indicators of your business.
  • Build interdependent charts, maps, and tables to deliver visually stunning information.
  • Share business intelligence in the cloud without involving IT.
  • Deliver visually stunning and interactive charts, maps, and tables.
  • Find new insights as you chop and tweak your data as never before.
  • Adapt delivery to mobile devices such as phones and tablets.

This is among the best Power BI Desktop books in 2019.

Analyzing Data with Power BI and Power Pivot for Excel

Sale
Analyzing Data with Power BI and Power Pivot for Excel (Business Skills)
  • Microsoft Press
  • Ferrari, Alberto (Author)
  • English (Publication Language)
  • 256 Pages - 04/29/2017 (Publication Date) - Microsoft Press (Publisher)

by Alberto Ferrari and Marco Russo will help you learn Power BI to build the best data models. You will learn to combine Excel with Power BI to design data models for maximum efficiency and effectiveness. This Power BI book will introduce you to the basic techniques of building data models in Excel and Power BI. Packed full of real-world examples, you will look at reports like experienced data modelers.

This Power BI book will help you:

  • 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.

This is one of the best Power BI books for Excel in 2019.

Power Pivot and Power BI: The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016

Sale
Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
  • Holy Macro Books
  • Collie, Rob (Author)
  • English (Publication Language)
  • 308 Pages - 01/01/2016 (Publication Date) - Holy Macro! Books (Publisher)

by Rob Collie and Avichal Singh will help you learn Power BI quickly, so you can build reports fast. The content here will help you learn Power BI, Power Pivot and Power Query. It then dives into DAX formulas, which is Power Pivot’s core feature. You will learn in a simple and step-by-step way. Everything you learn will help you save a lot of time in Power BI.
This Power BI book will teach you:

  • Difference between calculated columns and measures.
  • How formulas can be reused across different reports.
  • Merge disjointed sets of data into unified reports.
  • Filter certain columns in a pivot.
  • Create time-intelligent calculations in pivot tables.
  • Learn Power Query.
  • Use Power BI Desktop and PowerBI.com and learn how the fit into the Excel excosystem
  • Power BI best practices

Last update on 2019-12-11 / Affiliate links / Images from Amazon Product Advertising API