Power BI 📈 EXPLAINED in Less Than 15 Minutes

Introduction to Power BI

     In this comprehensive 15-minute guide, Angelica Choo Quan walks through the steps of building your first Power BI report. The demonstration utilizes public data on failed banks in the United States from 2000 to the present, showcasing how Power BI can be used to connect, shape, cleanse, and visualize data. By the end of the video, viewers will have a clear understanding of how to create and publish a simple Power BI report using various features within the platform.

Step 1: Getting Started with Power BI Desktop

• Download Power BI Desktop via the Microsoft Download Center or the Microsoft Store.
• Choose "Blank Report" once the software is installed to begin building your report.

Step 2: Connecting to Data

To start the report, Angelica uses data available on data.gov, specifically information regarding failed banks. Here's the process for connecting to data:

• Choose a data source connector in Power BI, such as "Web" for online datasets.
• Paste the web link of the dataset into the Power BI connector and click "OK" to load the data.
• If authentication is required, select the appropriate method to access the data securely.

Step 3: Shaping and Cleansing Data in Power Query Editor

Before adding data to the report, it’s crucial to shape and cleanse it. Angelica demonstrates how to:

• Rename tables and columns to make them more understandable.
• Remove unnecessary columns by selecting "Choose Columns" from the ribbon.
• Create new columns, such as combining city and state information, using the "Column from Examples" feature.

Angelica emphasizes best practices, such as adopting clear naming conventions to improve data clarity and organization.

Step 4: Building the Data Model

Once the data is cleaned, the next step is to create the data model:

• Power BI automatically adds a date hierarchy when it detects date columns.
• Use DAX (Data Analysis Expressions) to create additional tables and calculations. Angelica demonstrates this by creating a date table.

Step 5: Establishing Relationships

In Power BI, relationships between tables allow you to filter and cross-reference data. Angelica shows how to:

• Link the newly created date table to the failed banks data table using a common date field.
• Use "many-to-one" cardinality to define the relationship between the tables.

Step 6: Creating Visualizations

Now that the model is built, Angelica demonstrates how to create visualizations to represent the data:

• Choose visualizations such as bar charts and maps to display key data insights.
• Modify the map visualization by adjusting the "Data Category" to "Place" for accurate geographic representation.
• Enable cross-filtering between visualizations to create interactive reports.

Step 7: Publishing the Report

Once the report is complete, Angelica shows how to publish it to the Power BI service:

• Save the report and select a workspace in Power BI Service to upload the report.
• Share the report with others, either by generating a link or embedding it in different platforms.

Angelica concludes by recommending the Power BI Beginner to Pro course for more in-depth training on Power BI, including topics like data modeling and DAX.

Conclusion

This video provides an excellent overview of how to build a simple Power BI report from start to finish. By following these steps, beginners can gain a practical understanding of Power BI and learn how to leverage it for data analysis and reporting. Whether you’re working with public data or creating internal reports, Power BI offers powerful tools for transforming raw data into actionable insights.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.