Course description
Microsoft Power BI: Introduction (Virtual Training with a Trainer)
While on SquareOne Training's Power BI Introduction course you will learn how to import and transform data from various sources, including files, databases, and the web. You will also explore key Power BI features like filtering, grouping, pivoting, merging queries, and working with relationships and hierarchies.
This course also covers DAX formulas, time intelligence, and creating dynamic visualisations such as tables, charts, maps, and KPIs. You will also discover how to share your reports by publishing them to the Power BI Service or exporting them to PDF.
After completing the course you will be able to use Power BI to create fully interactive and immersive dashboards and reports on all aspects of your business, helping you to gain insights and make the decisions that matter most in scenarios.
Upcoming start dates
Suitability - Who should attend?
Course Suitability
This SquareOne Training Powe BI is designed for individuals looking to enhance their skills in data transformation, analysis, and visualisation using Power BI. It is suitable for a range of participants, including:
Data Analysts - Those who regularly work with data from various sources and need to clean, transform, and visualise this data effectively.
Business Intelligence Professionals - Individuals responsible for creating reports and dashboards to inform business decisions.
IT Professionals - Those involved in managing data infrastructure and supporting business intelligence tools.
Managers and Decision Makers - Individuals who need to understand data insights and communicate them.
It is expected that learners will have a good grasp of Excel and wish to transform their Data Analytics skills to the next level.
Outcome / Qualification etc.
Learners will gain practical Skills and develop great knowledge to be able to:
- Transform raw data into meaningful insights.
- Build sophisticated data models and perform advanced calculations.
- Design and implement compelling visual reports.
- Share insights effectively within an organisation using these skills,
Learners will also receive a full certificate of attendance and extensive manual, benefitting them long into the future.
Training Course Content
Obtaining Data
Different data sources: Files, Databases, and the Web, Changing the Data Source.
Transforming Data
Removing Columns/Rows, Data Type Changes, Filters, Grouping, Split, Duplicate, Combine: Append and Merge Queries, Pivot/Unpivot, Columns: Add Column, Custom Function, Conditional Column, Index Column.
Relationships
Model View and Relationship Management, Join Kinds, Working with Related Tables, Hierarchies.
Introduction to DAX Formula & Measures
Formula, Measures, Quick Measure.
Date Tables and Time Intelligence
Creating Date Tables, Time Intelligence Formulas and Measures.
Visualisations
Table, Matrix, Charts, Maps, KPI (Key Performance Indicator), Conditional Formatting, Spatial Intelligence, Visualisation Manipulation, Filter: Basic and Advanced, Top 10, Slicer, Drill Through
Publishing/Sharing Reports
Publishing to the Power BI Service on the web, Exporting to PDF
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
Request info
Welcome to SquareOne Training – Where Your Learning Journey Takes Centre Stage! For over 30 transformative years, SquareOne Training has been the beacon of excellence in IT and personal skills training. We started our journey when computers were just making...
Case Studies
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Excel Templates For Mexichem
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.