We are offering an online Power BI Course. The course provides learners with the opportunity to gain an understanding of how to use Power BI. This is an increasingly popular product being used by many companies to deliver reporting and analysis of all types.
What is Microsoft Power BI?
Microsoft Power BI is a part of the Microsoft suite of products. It is a commonly used Business Intelligence software. The programme develops interactive visual reports. It creates dashboards for managerial and business information. It builds your ability to understand business insights into an organisation. The programme can data cleanse, analyse organisational data, recognise patterns and produce reports. Power BI is set to become part of business in all organisations.
Course Content
This course contains a range of modules in Power BI training. It gives the full range of training and can be taken by anyone interested in Power BI.
Getting Started with Power BI
- Getting Started and the Power BI Service
- Creating a dataset using Excel
- Create a Visualisation and view a report
- Exploring the dashboard and adding a widget
- Using quick insights for a dataset
- Working with and modifying Tiles
- Building Blocks of the system
Power BI Data
- Overview of Power BI Desktop
- View Data Sources, Access Data, Text File, Excel File
- Enter to Power BI Desktop
- Cleanse and Transform Data
- Save/Refresh Data Model
- Query Editor
- Append/Merge a Query
Model your Data
- Create Relationships, Calculated Columns,
- Measure, Quick Measure, Calculated Table
- Work with a Time Based / Date Table
- Optimise the Data Model
Visuals
- Simple Visualisations / Combination Charts / Using Slicers
- Scatter Charts, Gauges and Cards
- Map Visualisations and Table / Matrix
- Filter / Highlight
- Modify Colours, Shapes, TextBoxes and Images in Reports
- Customise Tooltips
- Bookmarks and Assign Bookmarks to Images
- Work/format with Report Pages
- Page-Level Tooltip
Enhance Power BI
- Data Profiling
- Create and use a What if Parameter
- Use Conditional Formatting for Visual Titles
- Add Buttons to a Report
- Set-Up/format Filter Pane
- Use Drill-Through
- Add a Column from an Example
- Get Data from a Web Page by Example
Analysis of Data
- Publish Reports from Power BI Desktop
- Create, modify, and share a Dashboard
- Dashboard Tile
- Manually Republish / Refresh Data
- Print and Export
- Create/modify an App Workspace
Power BI Tips with Ben Howard (Microsoft MVP)
- Import Data from CSV/TXT/Excel File
- Enter, Clean and Manipulate Data
- Save a Report as a Template
- Create New Data Fields
- Introduction to Visualisations
- Drill-Through Filters and Slicers
- Comb Datasets / Create Relationships
- Publishing a Report
Dates and Duration
6 hours of learning time. You have access to the course for one year and can complete the course anytime during that period. The Power BI Course Online forms part of Office 365 training.
Course Requirements
It is recommended that you have advanced Excel skills to take this training. Please visit our Power BI and Excel Course or our Excel Courses page if you need Excel skills.
Benefits of the Power BI Course Online
- We are partnered with a Microsoft Certified Academy, so the information is up-to-date and of a high standard.
- Our training programs are set to an international standard
- Our qualifications are CPD Accredited and internationally recognised.
- Our trainers are experienced in using Power BI in the workplace and developed material to be highly practical.
Outcome
Certificate of the CPD Accredited Microsoft Power BI from a Microsoft Academy.