Power BI Level 1 Course Outline
Special Note to New Hampshire ResidentsThis course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.
Introduction to Power BI
- Power BI - basic concepts
- Get started with Power BI
- Power BI Pro content - what is it?
- Power BI vs. Power BI Pro
Connect to Data
- Get data for Power BI
- Important considerations for connecting to data in Power BI
- Get data from Excel, Power BI Desktop, and CSV files into Power BI
- Bring whole Excel files into Power BI
- Publish to Power BI from Excel
- Refresh Excel, CSV, and Power BI Desktop files stored in OneDrive
- Replace an Excel, Power BI Desktop, or CSV file in Power BI
- Reduce the size of an Excel workbook to view it in Power BI
- Tutorial: Connect to the Power BI samples
Data Fundamentals
- Explore a dataset in Power BI
- Rename a dataset in Power BI
- Delete a dataset from Power BI
Organizational Content Packs
- Organizational content packs: an introduction
- Tutorial: Create and publish an organizational content pack
- Work with organizational content packs
Natural Language Querying with Q&A
- Untitled page
- Q&A in Power BI
- How to use Power BI Q&A
- Tutorial: use Power BI Q&A with the Retail Analysis sample
- Make your data work well with Q&A in Power BI
- Create featured questions for Power BI Q&A
- Tips for asking questions with Power BI Q&A
Creating Reports
- Reports in Power BI
- Create a new Power BI report
- The report editor...Take a tour
- Open a Power BI report in Reading View
- Interact with a report in Reading View in Power BI
- Go from Reading View to Editing View in Power BI
- Interact with a report in Editing View in Power BI
- About filters and highlighting in Power BI reports
- Add a filter to a report in Power BI
- How to use report filters
- Aggregates in Power BI reports
- Save a report in Power BI
- Rename a report in Power BI
- Add a page to a Power BI report
- Page display settings in a Power BI report
- Tutorial: Change the display settings for a page in a Power BI report
- Reorder pages in a report in Power BI
- Delete a page from a Power BI report
- Delete a report from Power BI
Visualizing Your Data
- Visualizations in Power BI
- Visualization types in Power BI
- Tutorial: Part I, Add visualizations to a Power BI report
- Tutorial: Part 2, Add visualizations to a Power BI report
- Change the type of visualization in a Power BI report
- Getting started with color formatting and axis properties
- Tips and tricks for color formatting in Power BI
- Drill down in a visualization in Power BI
- Move, resize, and pop-out a visualization in a Power BI report
- Change how a chart is sorted in a Power BI report
- Change the aggregation in a chart (sum, average, maximum, etc.) in Power BI
- Text Boxes in Power BI reports
- Tutorial: Customize visualization title, background, and legend
- Tutorial: Customize X-axis and Y-axis properties
- Tutorial: Basic Area chart
- Tutorial: Combo Chart in Power BI
- Tutorial: Filled Maps (Choropleths) in Power BI
- Delete a visualization in Power BI
Creating Dashboards
- Dashboards in Power BI
- Display dashboards and reports in Full Screen mode
- Create a Power BI dashboard
- All about dashboards
- Dashboard tiles in Power BI
- Pin a tile to a Power BI dashboard from a report
- Pin a tile to a Power BI dashboard from the Q&A question box
- Pin a tile from one dashboard to another dashboard
- Tips for designing a great Power BI dashboard
- How should I share my dashboard?
- Share (and unshare) a dashboard from Power BI
- Edit a tile -- resize, move, rename, pin, delete, add hyperlink
- Create a big number tile for a Power BI dashboard by asking a question
- Create a big number tile from a Power BI report
- Add an image to a dashboard
- Display a dashboard tile in full screen mode (In-focus mode)
- Rename a Power BI dashboard
- Delete or remove a dashboard
Appendix
- Frequently Asked Questions
View outline in Word
BBC110