Creating Reports And Dashboards In Microsoft Power BI

Microsoft Power BI is a powerful business analytics service that can be used to transform data from multiple sources into interactive, visual reports and dashboards that can be viewed on any device. 

With Data Analysis and Business Intelligence being vital to business success, this course will give you the knowledge and tools to create highly visual reports and dashboards to facilitate and accelerate evidence-based decision making.

You Will Learn How To:

• Use Power BI to draw out information and intelligence from business data
• Create engaging and interactive reports using different data visualisations
• Implement a consistent and appropriate style for reports and dashboards
• Consider how information is perceived and understand the application of accepted best practices
• Understand the importance of stories when using information
• Use workspaces, dashboards, and Apps in the Power BI online service
• Publish and share reports within the organisation

Course Content:

• Overview of Power BI
• What is Power BI used for
• Power BI within the business intelligence toolkit
• Introduction to the Power BI Desktop
• Introduction to the Power BI service
• Creating Visualisations
• Types of visualisations
• Where to use the different type
• Finding the right visualisation for the right information
• Adding and using visualisations
• Using the canvas
• Adding data to visualisations
• Adding dynamic analytics lines
• Formatting Reports, Dashboards and Visualisation
• Reports compared to dashboards
• Considering the story
• Laying out the page to ensure recognition
• Appropriate formatting for different visualisations
• Conditional formatting to aid understanding
• Applying colour theory in Power BI
• Dashboard design specific considerations
• Best practices applied to formatting
• Ensuring consistency with themes and templates
• Considerations for mobile report layout
• The importance of accessibility and culture
• Structuring Information in Visualisations
• Setting sort orders
• Creating hierarchies
• Using data groups
• Using Interactivity
• Enabling investigation with engaging interactions
• Controlling interaction behaviours
• Using filters
• Cross filtering and cross highlighting
• Using drilldowns
• Understanding drillthroughs
• Working with bookmarks
• Making use of buttons
• Using Slicers to Filter Data
• Adding and using slicers
• Different types of slicers
• Formatting and controlling slicer behaviours
• Synchronising slicers across multiple pages
• Taking Advantage of Tooltips
• Using standard tooltips
• Creating customised tooltips
• Using Maps for Geographical Representation
• Different types of Maps
• Using maps
• Matching geographic data to maps
• Visualising data with maps
• Extending the Range of Power BI Visualisations
• Different sources and security concerns
• AppSource for Power BI
• Using the Power BI Online Service
• Publishing Reports and Dashboards
• Using Workspaces for collaboration
• Dashboards in the Power BI service
• Using apps to distribute reports and dashboards
• Different audience within an app
• Sharing individual reports
• Introduction to row level security
• Introduction to cross report drillthrough
• Editing reports in the Power BI service
• Reusing a master set of data across multiple reports