Course description
Microsoft Power BI - Introduction
There are three parts to creating a Power BI Desktop report, all of which are covered by this two-day course. Firstly, you’ll learn how to get data from all manner of different sources, using Query Editor to manipulate the results; secondly, you’ll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more); and thirdly, you’ll learn how to create calculated columns and measures using basic DAX language. You’ll also learn how to use Power BI Web, and get an overview of Power BI Mobile.
Upcoming start dates
Suitability - Who should attend?
Delegates will need to have a good working knowledge. You will be self taught or would of attended our Excel Level 1 course.
Who’s it for?
Existing users of Microsoft Power Bi who wish to learn how to use Power Bi effectively.
Outcome / Qualification etc.
- Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.
- Course Completion Certificate will be awarded on successful completion of the course.
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 Acudemy Training
100% certified & specialised trainers delivering face-to-face, webinars and on-site courses
5 locations where courses are being delivered, with a concentration on Central London
More than 90% of satisfied individuals and organisations (2000+ students trained so far)
Expenses
Are any Financial Options Provided?
- 0% Interest Free payments available.
Continuing Studies
- Data Analysts
- Project Manager
Request info
ACUDEMY - MAKING LEARNING SIMPLE
ACUDEMY is a Global training provider of bespoke and accredited courses. Reskill or Upskill for the modern workplace. Outdated competency frameworks are a thing of the past. Upskill or Reskill with popular leading programmes that are focused on Outcome rather...