What will I learn?
This session focuses on the key steps associated with building a typical business report.
Learn how to build ‘measures’ (calculations) and ‘calculated columns’ and when to use one over the other. We also cover the most common DAX functions and how and when to use them.
This session is designed for those people who already use Power BI but want to be more creative and dynamic when building business reports.
To attend you should have some experience of importing and working with files of different types.
Click below for more detail of what is covered.
-
Creating Dynamic Reports
- Import data from an Excel workbook.
- Review the quality of the imported data and remove unwanted records.
- Understand the difference between a ‘measure’ and a ‘calculated column’.
- Consider how the information will be presented in the report and identify the tiles you want to use.
- Determine how the report consumer may wish to filter / slice and drill into each tile to expose various levels of granularity.
- Build some basic measures (calculations) & calculated columns that will be used in the report.
- Resize, group and format tiles to get the desired look and feel as well as being easy to read and interact with.
- Understand the difference between a standard table and a matrix and when to use one over the other.
- Make sure the report has clearly defined sections & boundaries which are aligned and balanced with other tiles.
-
Create a title for the report so report consumers understand the purpose of the report.
What’s Included in Our Courses?
We pride ourselves on delivering first class training that meets your staff’s needs. Here’s what to expect:
- Your own booking specialist to help you choose the best training for your needs.
- A choice of online or face to face training, delivered by our friendly and highly experienced trainers.
- Free pre-course IT skills assessments to help establish which level of training is required.
- Lots of interaction and practical examples to keep everyone focused and to embed learning.
- Post-training support from certificates, user guides, workbooks and a summary of the delegate feedback.
Why Choose To Learn With TrainingU?
We’ve helped hundreds of mid-level and blue chips train all their team members since 2006. Got questions? Speak to one of our team now on 0333 344 6630.
Established over a decade ago, we are a team of knowledgable training and software rollout experts.
We are passionate about delivering excellent training and software rollout support that makes a real difference to you and your teams. We strive to exceed your expectations in all that we do.
We pride ourselves on listening and offering a personal and reliable service to each and every client that we work with. We seek to build a strong and lasting relationship and to become your go-to training partner.
Our trainers are experts in their subject matter, bring a wealth of experience and have a natural ability to make everyone feel comfortable and to bring out the best in learners.
To discuss your requirements
in more detail
Or call us on 0333 344 6630