kodegems.com

Get data with Power BI Desktop

By Ameen Khan

kodegems.com

By Ameen Khan

Learning Objectives

- Explore the data-centric features and tools of Power BI.

- Explore ways to find data.

kodegems.com

By Ameen Khan

Overview of Power BI Desktop

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

Download Power BI Desktop

kodegems.com

By Ameen Khan

https://aka.ms/pbidesktopstore

Window Store App

kodegems.com

By Ameen Khan

https://go.microsoft.com/fwlink/?LinkID=521662

Download From Web

kodegems.com

By Ameen Khan

Download sample data

kodegems.com

By Ameen Khan

https://kodegems.com/get-data-excel-sheet/

kodegems.com

By Ameen Khan

Explore Power BI Desktop

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

Launch Power BI Desktop

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

Explore the Report Building Environment

kodegems.com

By Ameen Khan

1-Ribbon - Displays common tasks that are associated with reports and visualizations.

2-Report view, or canvas - Where visualizations are created and arranged. You can switch between Report, Data, and Model views by selecting the icons in the left column.

3-Pages tab - Located along the bottom of the page, this area is where you would select or add a report page.

kodegems.com

By Ameen Khan

4-Visualizations pane - Where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.

5-Fields pane - Where query elements and filters can be dragged onto the Report view or dragged to the Filters area of the Visualizations pane.

kodegems.com

By Ameen Khan

Tip

kodegems.com

By Ameen Khan

Connect to data sources

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

1- Connect to data.

2- Import data into Power BI Desktop.

kodegems.com

By Ameen Khan

Choose data to import

kodegems.com

By Ameen Khan

Import from Excel Workbooks

kodegems.com

By Ameen Khan

Transform data to include in a Report

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

Launch Power Query Editor

kodegems.com

By Ameen Khan

Combine data from multiple sources

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

Add more Data Sources

kodegems.com

By Ameen Khan

Merge and Append queries

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

Write customized queries

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

Data Cleaning 

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

https://kodegems.com/get-data-excel-sheet/

kodegems.com

By Ameen Khan

Pivot and Unpivot

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

Practical Approach

kodegems.com

By Ameen Khan

Transpose Column

kodegems.com

By Ameen Khan

kodegems.com

By Ameen Khan

10 Top Cities Per Countries by Population

kodegems.com

By Ameen Khan

Check your knowledge

kodegems.com

By Ameen Khan

Congratulations!