Analyzing Data with Microsoft Power BI 20220815


What is Power BI?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.

The parts of Power BI

Power BI consists of several elements that all work together, starting with these three basics: A Windows desktop application called Power BI Desktop. An online SaaS (Software as a Service) service called the Power BI service. Power BI mobile apps for Windows, iOS, and Android devices.

Get Power BI Desktop

With Power BI Desktop, you can build advanced queries, models, and reports that visualize data. You can also build data models, create reports, and share your work by publishing to the Power BI service. Power BI Desktop is a free download.

To get Power BI Desktop, you can use one of the two approaches.

  1. Install as an app from the Microsoft Store.
  2. Download directly, as an executable you download and install on your computer.

Workbook B:



Get started with Power BI Desktop

This tour shows you how Power BI Desktop works, what it can do, and how to build robust data models and amazing reports to amplify your business intelligence.

Workbook C:


Connect to data in Power BI 


Data sources 

Data view in Power BI Desktop 


Import data from a web page 

Refresh data 


Data refresh 

Incremental refresh for datasets 

What are commonly used data sources?

What is an example of a public data set that is commonly used in data analysis?

What is the data source format available for this public data set?

How do we connect Power BI to these data sources?

1) Manual Entry

2) Web

3) Spreadsheet Input

4) CSV


6) XML

7) SQL

Post a Comment