To edit data in Power BI Desktop, fire up the Query Editor, which tracks the steps you take with your data model. You can reduce data using a filter, or by reducing selected and nonselected rows and columns.
- [Instructor] We're continuing here…with our dataset from from the prior movie,…which came from an Excel spreadsheet called StatePops.…While this is a lovely dataset,…it is not yet in the shape I need it to be in…to work with it in Power BI and use it…for state by state analysis.…For example, we have a total row…at the bottom and we don't need that.…We also have information on the District of Columbia…and if our intention is to only compare states,…then you need to eliminate the…District of Columbia from our dataset.…
One way to do that that's very easy…is to simply get rid of the rows…that were never admitted to the Union…because the United States wasn't…and the District of Columbia wasn't.…Now, it's really easy.…It's compelling, even to jump up here…and say, well, let's then get rid…of the blanks in this column.…And we can do that, and notice at the bottom…what we have is we don't have…50 rows, now, which is what we want.…We have 52 rows and 50 filtered rows.…In other words, that data hasn't gone away.…
It is still right here.…
Author
Gini von Courter
Released
9/5/2018Looking for study partners?
Join the Data Analytics study groupDiscover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization. In this course, Gini von Courter helps you get started with this powerful toolset. Gini begins by covering the web-based Power BI service, explaining how to import data, create visualizations, and arrange those visualizations into reports. She discusses how to pin visualizations to dashboards for sharing, as well as how to ask questions about your data with Power BI Q&A. She also provides coverage of Power BI Mobile—explaining how to use it to view and share your data—and shows how to use the data modeling capabilities in Power BI Desktop.
- Working with cloud-based and on-premises data sources
- Creating reports with data visualizations
- Modifying existing reports
- Creating and managing data dashboards
- Asking questions with Power BI Q&A
- Enabling Microsoft Cortana for Power BI
- Sharing Power BI datasets, dashboards, reports, and workbooks
- Using Power BI Mobile and Power BI Desktop
Skill Level Intermediate
Duration
Views
-
Introduction
-
Invitation1m 17s
-
-
1. Get Started with Power BI
-
Overview: Power BI concepts9m 35s
-
Sign up for Power BI3m 33s
-
-
2. Get Data
-
Connect to a SaaS solution4m 16s
-
Upload a local CSV file3m 42s
-
Connect to a sample2m 17s
-
3. Create a Report with Visualizations
-
Explore the Power BI portal4m 52s
-
Overview: Visualizations6m 23s
-
Using visualizations3m 54s
-
Create a new report2m 14s
-
Format a visualization4m 34s
-
Create chart visualizations7m 27s
-
-
4. Modify and Print a Report
-
Print a report page1m 51s
-
Send a report to PowerPoint1m 37s
-
5. Create a Dashboard
-
Create and manage dashboards3m 22s
-
Add a tile to a dashboard4m 29s
-
-
6. Ask Questions about Your Data
-
Tweak your dataset for Q&A3m 30s
-
7. Share Data with Colleagues and Others
-
Publish a report to the web3m 34s
-
Manage published reports3m 5s
-
Share a dashboard5m 59s
-
Use an app workspace2m 52s
-
Publish an app4m 43s
-
8. Use Power BI Mobile Apps
-
Sharing from Power BI Mobile3m 13s
-
9. Use Power BI Desktop
-
Get data6m
-
Reduce data7m 31s
-
Transform data8m 47s
-
Relate tables7m 43s
-
Conclusion
-
Next steps1m 15s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Reduce data