Course Details
Microsoft Power BI (Business Intelligence), is a suite of business analytics tools to analyse data and share insights. Power BI dashboards provide a 360-degree view for business users with their most important metrics in one place, updated in real time, and available on all their devices.
With one click, users can explore the data behind their dashboard using intuitive tools that make finding answers easy. You can also access your data and reports from anywhere with the Power BI Mobile apps, which update automatically with any changes to your data.
If you are a data analyst delivering reporting and analytics to your organisation, Power BI lets you be productive and creative with what you build. Power BI Desktop is a feature-rich data and report authoring tool.
Combine data from unrelated databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically.
With over 20 built-in visuals and a vibrant community of custom visualizations, create stunning reports that communicate your message effectively. With the Power BI service, publish reports securely to your organisation and setup automatic data refresh so everyone has the latest information.
Benefits to you
If you are a data analyst delivering reporting and analytics to your organisation, Power BI lets you be productive and creative with what you build. Power BI Desktop is a feature-rich data and report authoring tool.
Course Contents
- Introduction
- The Building Blocks of Power BI
- Starting Microsoft Power BI
- First Visualisation
- Adding A Matrix of Data
- Simple Charts
- Maps
- Adding A Card
- Adding Slicers
- Interactivity in Dashboards
- Formatting Reports
- Entering Your Own Data
- Databases and Power BI
- Filtering Data Using Queries
- Power Charts
- Drilling into and Expanding Chart Data Hierarchies
- Drill Down & Drill Up
- Including and Excluding Data Points
- Formatting Charts
- ToolTips
- Chart Analytics
- Further Maps and
- Creating ArcGis Maps
- Filtering Data
- Introduction to Power Bi Query Editor
- Power BI Query Editor Query Toolbar
- Transforming Data with Power BI Query Editor
- Applied Steps Menu
- Common Transformation Tasks
- Moving Columns
- Splitting Columns
- Split A Column by Position
- Split A Column Using Far Left or Far Right
- Concatenating Columns
- Merging Multiple Columns
- Filtering Data
- Exporting Power Query Data to A Power BI
- Removing Duplicates
- Filtering Rows with Errors
- Sorting A Table in Power Query
- Text Transformations
- Extracting left, Right and Middles Values
- Unpivoting Columns
- Creating A Custom Column
Who should attend?
Employees looking to improve the data beyond Microsoft Excel