Microsoft Power BI Training
Microsoft Power BI is a business analytics platform designed to transform data into actionable insights. Combining the strengths of Excel, Access, Power Query and Power Pivot, Power BI helps users prepare, analyse and visualise data using dashboards, interactive reports and advanced analytics tools.
Choose Your Power BI Course
Click a course below to view the full details
Creating & Using BI Dashboards
Introduction Microsoft Power BI Course
Duration: 1 Day
Delivery: Face To Face & Live Online
This course introduces you to the powerful tools of Microsoft Power BI, enabling you to transform raw data into dynamic visualisations and meaningful insights. Designed for beginners, it provides hands-on experience with the Power BI ecosystem, including Power BI Service, Power BI Desktop and Power BI Mobile.
Who Should Attend?
- Data Analyst
- Project Manager with a Data Focus
- Financial Analyst
- Database Manager
Course Requirements
No previous experience of Microsoft Power BI is required. Delegates should have knowledge of basic computer skills.
Course Content
- Power BI Data Sources: Gain an overview of Power BI's diverse data connection options.
- Connecting to SaaS Solutions: Learn to integrate Power BI with popular SaaS platforms.
- Importing Data Files: Upload local CSV files and refresh Excel-based data seamlessly.
- Exploring Sample Datasets: Connect to sample data for practice and testing.
- Visualisation Basics: Navigate the Power BI portal and explore its visualisation tools.
- Creating Reports: Build and arrange visualisations for impactful data storytelling.
- Customising Visuals: Format charts, maps, gauges and text visuals to suit your analysis.
- Using Filters and Slicers: Filter, sort and manage visualisations for targeted insights.
- Designing Dashboards: Pin tiles, reports and live pages to build intuitive dashboards.
- Quick Insights: Use Power BI's AI-driven tools to gain actionable insights.
- Power BI Q&A: Ask natural language questions to extract insights from your data.
- Sharing Dashboards: Publish and share dashboards and reports with colleagues.
- Collaborative Workspaces: Create and manage app workspaces for team collaboration.
- Power BI Mobile: Access and interact with dashboards and reports on mobile devices.
- Power BI Desktop Integration: Connect and transform data in Desktop for advanced control.
- Export and Embed Reports: Share reports via QR codes, SharePoint or directly on the web.
Power BI Master
Advanced Microsoft Power BI Course
Duration: 1 Day
Delivery: Face To Face & Live Online
The advanced Power BI course builds on existing knowledge and focuses on Power BI Desktop, Pro, data import, Query Editor, M language, table relationships, DAX measures and dashboard design for collaborative reporting.
Who Should Attend?
- Data Analyst
- Project Manager with a Data Focus
- Financial Analyst
- Database Manager
Course Requirements
Delegates should have attended the previous level of the Microsoft Power BI course at Pringle PCS or have equivalent working knowledge.
Course Content
- Understanding: Explore Power BI Desktop and Pro, and understand the Microsoft update process.
- Comparing Tools: Learn the differences between Power BI and Tableau for informed tool selection.
- Efficient Data Strategies: Master effective methods for importing and managing data.
- Data Uploading: Work with Excel, CSV, TXT files and folders for streamlined data integration.
- Database Querying: Query databases and upload data directly from PDFs for advanced versatility.
- Query Editor: Understand the steps involved in data transformation using Query Editor.
- Data Tools: Learn to transpose tables, unpivot data and append datasets for clean analytics.
- Splitting and Formatting: Split fields and columns, and format data using text and conditional formulas.
- Query Editor Techniques: Use fill up, fill down and calculated formulas.
- The M Language: Learn the foundations of M language to manage data transformations.
- Joining Data Tables: Combine data from multiple tables for comprehensive analysis.
- DAX Language: Understand the basics of DAX for creating measures and logical calculations.
- DAX Measures: Develop and evaluate measures using functions such as CALCULATE and ALL.
- DAX Functions: Use SUMX, COUNTX and parameter-harvesting functions for dynamic calculations.
- Quick Measures and Date Tables: Work with date tables and quick measures for data handling.
- DAX: Use IF statements, variables and advanced functions such as DATESBETWEEN.
- Designing for Collaboration: Focus on dashboard accessibility and design for collaborative success.
