POWER BI: PRACTICAL USE

– Introduction to the world of Business Intelligence, Fundamental Concepts.
– Connecting to Data. Using Different Data Sources: Power BI and Excel.
– Desktop Version, Online Service, and Mobile App.
– Importing Excel Files with PowerPivot Databases and PowerView Reports.

– Data Shaping. Combining Data. Editing Data.
– Creating Direct Query Calculated Fields. Grouping Rows.
– Transforming Columns Using Pivot.

– Data Visualization in Power BI Desktop. Creating and Editing Relationships.
– Filters and Sorting.
– Measures and Calculated Fields: Differences.
– Basics of DAX Functions in Power BI Desktop. Categorizing Data in Power BI Desktop. Grouping Data Automatically.

– Creating a Date Table.
– Date Functions for Use with a KPI Date Table.
– Calculation Functions and Contexts. Quick Measures.

– Tables and Charts. Basic Operations. Creating Visuals.
– Editing and Formatting Visuals.
– Sorting by another column.
– Report, page, and visual level filters. Chart types and management of axes, dimensions, and measures.

. – Playback axes and animated charts. Changing the interaction between visual objects. Inserting maps and options.
– Inserting text boxes, images, and shapes.
– Drill analysis and hierarchies. Inserting “What if” parameters. Mobile layout view. Import custom visualizations.

– Saving and publishing a report to the Power BI Reports and Dashboards service.
– Sharing your work. Applying restrictions to data in Power BI apps.
– Getting answers from your data: How to use Power BI Q&A. Overview of Power BI mobile apps.