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.