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.
Log in to save your progress and obtain a certificate in Alison’s free Introduction to Analysis with Power BI Desktop online course
Sign up to save your progress and obtain a certificate in Alison’s free Introduction to Analysis with Power BI Desktop online course
Please enter you email address and we will mail you a link to reset your password.