Join Gini von Courter for an in-depth discussion in this video Transforming Data, part of Power BI Features in Depth.
- View Offline
- Exercise Files
…The Transforming workbook has two queries in it.…The first query is US regional and…state population information for 2010 and an estimate for 2013.…Then we have a table that is historical data…population information from the US Census from 1790 to 1860.…And we'll use these two sets of data to be able to look at…the different tools that are available in the editor for shaping information.…
I'm going to begin with this data set.…Which is a lovely data set.…And go to Query and click Edit.…And the first thing I'd like to do is take this key column.…And move it, so that it is first.…Because if I'm going to have a key,…I'd like it to be out there hanging out on the left hand side.…Notice that I have information about when different states were admitted to…the Union, and I have the District of Columbia as non-admitted.…And I have a total down here for the United States.…
And I also don't want to display that total as a data set.…So if I wanted strictly to display state data,…one way I could do that would be to say, I'd like to filter this so that…
AuthorGini von Courter
- Understanding data analysis and business intelligence
- Installing Office BI add-ins
- Searching for online data with Power Query
- Shaping data in the Query Editor
- Connecting to data sources
- Modeling data with Power Pivot
- Enhancing PivotTables and PivotCharts with PowerPoint
- Visualizing geospatial data with Power Map
- Creating and formatting Power View reports
- Sharing your data using Power BI for Office 365
Skill Level Intermediate
1. Getting Started: Self-Service, Power BI, and BI Tools
2. Using Power Query to Get Data
3. Modeling Your Data with Power Pivot
4. Enhancing PivotTables and PivotCharts with Power Pivot
5. Expanding the Data Model in Power Pivot
6. Visualizing Geospatial Data with Power Map
7. Creating and Formatting Power View Reports
8. Creating Other Power View Visualizations
9. Sharing Your Data Using Power BI for Office 365
Next steps2m 59s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.