Loading
Notes
Study Reminders
Support
Text Version

Workflow of Power BI - Lesson Summary

Set your study reminders

We will email you at these times to remind you to study.
  • Monday

    -

    7am

    +

    Tuesday

    -

    7am

    +

    Wednesday

    -

    7am

    +

    Thursday

    -

    7am

    +

    Friday

    -

    7am

    +

    Saturday

    -

    7am

    +

    Sunday

    -

    7am

    +

The key points from this module are:

Introduction to Power BI

BI stand for stands for business intelligence.
This is the BI workflow: information, transformation, presentation.
There are four technologies that go directly into your spreadsheet: Power Query, known as "Get and Transform", Power Pivot, Power View and Power Maps.

Connecting to data set

The steps for Connecting to the data set:

Open Power BI Desktop
Select Get data and choose from the many different data sources, web or text csv files.
Click the Connect button.
Click Load to import the data into Power BI Desktop.

A tour of Power BI visualizations

The basics on the map are items to control the visualization standpoint from a visual standpoint

Tables are kind of lightweight reporting tools.

The matrix is a pivot table with really good branding but no filter.

A treemap is really good for naturally hierarchical data.

A bar and column chart are slightly different things, there are a few small differences between the two in power bi but they are generally the same thing.

The card is one of the most used visualizations and it's perhaps the most simple and basically, it gives you a report some sort of aggregated report of numbers.

Slicers modify the filter context, so the information displayed changes based on what we switch on and off.

Drilldowns allow you to advance to the next level and are compatible with area and column charts.

Q&A visual can be kept as a Q&A on your report if you want to give others the ability to investigate, or it can be turned into a standard visual.