Description
Power BI Training Course Specification – Beginner Level
An introduction to Power BI and Data Visualisation.
- How to use Power BI visuals effectively to gain insight to your data.
- How to use filters and slicers.
- How to use cross highlighting and its benefits.
- How to use drill up, drill down and drill through functionalities in visuals.
- How to use AI functions in Power BI.
- Exporting data into excel from Power BI.
- How to connect to Excel, csv and SharePoint files in PBI Desktop
- Basic data transformations in Power Query, including removing columns, changing column types, replacing values, splitting columns and filtering tables.
- How to add columns to your tables from Text, Number and Date & Time fields.
- Duplicating columns, renaming columns, and adding indexes.
- Types of Power BI Relationships.
- Power BI’s Model View.
- Power BI’s Table View
- How to create relationships between tables.
- Sorting Columns in Power BI tables.
- The differences between Power Query and Power BI’s Table View.
- Power BI’s Report View
- Creating a template page design, using backgrounds, shapes and text.
- Adding buttons and navigation tools.
- Adding to and modifying the Filter Pane.
- The three layouts of Power BI: Standard, On-object orientation and Mobile layout.
- Creating visuals, including bar charts, line charts, tables, matrices, cards, treemaps, maps and waterfalls.
- Adding filters and Slicers to your report.
- How to format visuals and the options available.
- How to add further analysis and insights, generated by Power BI.
- How to create and use Quick Measures
- The insights you can gain from Quick Measures.
- The benefits of using Quick Measures to Power BI beginners.
- An introduction to DAX & measures in Power BI.
- How to publish a report to your workspace.
- Creating a Dashboard
- Creating subscriptions and alerts.
