Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Essentials
Rating: 4.4 out of 5(19 ratings)
51 students

Power BI Essentials

Create Stunning Reports with Real-Time Data
Created byBigger Brains
Last updated 4/2021
English
EnglishSpanish

What you'll learn

  • Differentiate between Power BI Desktop and Power BI web service capabilities
  • Navigate the Power BI Desktop environment
  • Modify table elements and column properties
  • Create and customize visualizations to display your data including formatting, sorting, and filtering
  • Format report pages including text, shapes, and images
  • Create calculated columns using Data Analysis Expressions (DAX) for both strings and numbers
  • Create explicit measures and add measures to visualizations
  • Create interactive reports using real-time filters, hierarchies, and slicers
  • Publish a report to the Power BI Web App and create multiple dashboards specific to different audiences

Course content

1 section • 12 lectures • 1h 25m total length

  • Introduction3:33

    Connect data from multiple systems, clean and visualize it in Power BI Desktop, then publish to a web app for up-to-date, browser-accessible reports.

  • Using Power BI6:14

    Learn to download and install Power BI Desktop, sign in, and navigate the workspace, including visualizations, data view, fields, and relationships, while exploring how to add data and create reports.

  • Creating Data Connections5:19

    Use get data to connect directly to Excel, SQL Server, Analysis Services, CSV, or web data, choose table over worksheet, and load or edit with refreshable results.

  • Knowledge Check
  • Modifying Data Relationships7:00

    Power BI illustrates connecting to multi-table Excel data, auto-detecting relationships between tables like date and fact tables, and creating or managing one-to-many data relationships.

  • Working with the Power Query Editor9:49

    Master the Power Query Editor to clean and transform data in Power BI by managing applied steps, adjusting data types, renaming or removing columns, and reviewing the advanced editor code.

  • Transforming Data8:15

    Explore transforming data in Power BI with Power Query: split and merge columns, rename fields, adjust data types, replace values, and apply filters.

  • Knowledge Check
  • Creating Visualizations7:40

    Create visualizations in Power BI by building a clustered column chart from a date table, customize axis titles, sort by day number, and add a gauge KPI with a target.

  • Customizing Visualizations6:28

    Learn to create and customize Power BI visuals—from column charts and maps with bubbles to importing visuals from marketplace; use country data and sales amount to size bubbles, format pages.

  • Creating Calculations with DAX8:40

    Discover how to create new DAX columns in Power BI, including concatenating product key and name, calculating profit, and deriving gender labels with nested if.

  • Creating Calculated Measures5:46

    Learn to create measures in DAX for Power BI, using sum to calculate profit percentage and target sales, and compare with calculated columns.

  • Knowledge Check
  • Filtering and Splicing Reports8:24

    Explore filtering in Power BI with basic and top 10 value filters, view data by date hierarchy, and use slicers and focus mode to create interactive, publish-ready visuals.

  • Publishing Reports7:55

    Publish Power BI reports by saving to my workspace, view them in the Power BI app, and pin dashboards with gauge, map, and top products.

  • Knowledge Check

Requirements

  • While this course does not have prerequisites, learners may wish to have experience storing data in Excel and some knowledge of data relationships.

Description

Learn to create stunning reports with real-time data

In Microsoft's Power BI, you can connect to existing data to create modern data visualizations and reports. In this course, expert trainer Kathy Snizaski will teach you everything you need to know to design reports, charts, and dashboards and distribute them to your team.

First, you will learn to connect to data sources and create data relationships as the basis for your reports. Then Kat will walk you through creating a set of applied steps to clean and transform your data, and creating a variety of engaging visualizations with your data. Lastly, publish your reports to Power BI Web App, and learn to create multiple customized dashboards from one report.

Topics covered include:

  • Connecting to external data sources

  • Managing data connections

  • Cleaning up a data source including changing data types, modifying field names, and splitting and merging columns

  • Creating and customizing visualizations

  • Formatting report pages

  • Creating calculated columns and measure

  • Creating interactive reports using real-time filters, hierarchies, and slicers

  • Publishing reports to the Power BI Web App and creating multiple dashboards

Objectives. You will be able to:

  • Describe how Power BI enables real-time data sharing and reports by connecting to external data sources

  • Manage data relationships within Power BI

  • Create a set of applied steps to clean a data source including changing data types, modifying field names, and splitting and merging columns

  • Create and customize visualizations

  • Format report pages

  • Create calculated columns using Data Analysis Expressions (DAX)

  • Create explicit measures and add them to visualizations

  • Create interactive reports using real-time filters, hierarchies, and slicers

  • Publish reports to the Power BI Web App and create multiple dashboards


Eighty-five minutes of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Who this course is for:

  • Business users who manage large sets of data and create reports and dashboards for distribution to their teams or executives.

Report abuse