Power BI Desktop reports for Excel BI users

Targeted audience

Professionals and technicians

Content

Importing a Model

• Importing a Power Query and Power Pivot model into Power BI Desktop
• Demonstration of using a dataset in the Power BI service as a centralized data source

Quick Tour of Familiar Features from Excel BI

• See how to work with Power Query in Power BI Desktop
• See how to manage the model in Power BI Desktop (relationships, calculated columns, and measures)

Visualizing Data

• Overview of different visualizations
• Textual visualizations: tables, matrices, single-field cards, multi-row cards
• Graphical visualizations: histograms or bar charts, pie and donut charts, line graphs, scatter plots, and bubble charts
• Geospatial visualizations: Bing and ArcGIS maps
• Formatting the report and controlling the layout of elements
• Adding data to a visualization
• Defining and applying filters
• Adding a slicer
• Using visualizations as navigation tools and for drilling into data
• Adding custom visualizations from the Office Store
• Adding an animation by defining a play axis for scatter plots and bubble charts