Data can be pulled from many different sources - Excel, SAP, SQL Server databases, Finance systems, SharePoint etc - and all combined into interactive dashboards that provide insights into how your company is performing.
This 1 day hands-on course introduces Microsoft Power BI and provides an understanding of how its features and functionality will assist business reporting.
Delegates who have an interest in the analysis of data, and making fact-based decisions within the organisation.
Delegates should have a good depth of web browser knowledge, and be familiar with Microsoft Office functionality.
Delegates should have, at least, a basic understanding of reporting and data analysis.
Delegates will benefit from having a known data-set to work with, a set of questions to be answered and reports to be drafted.
Introduction to Power BI
Power BI Licensing - Pro and Free
Power BI Features and Functionality
Power BI Web Service
Connecting to Data Sources
Power BI Queries
Data Cleansing and Manipulation
Importing Excel Data
Data Modelling
Relational Data
Calculated Columns
Building Measures
Working with Time Based Data Sets
Visualisations
Chart Types and User Interface
Slicers
Insights
Building Dashboards
Introduction to Data Analysis Expressions (DAX)
Power BI Administration
Content Packs
Publishing, Sharing and Embedding
App Workspaces