Skill Up Card - Course Bundles

Pricing is per delegate, giving you huge savings over the cost of individual courses.

  • UK = £2,000 + VAT per Skill Up Card
  • Ireland = €2,400 per Skill Up Card
skill up card logo - Nexus Human

Next-Level PowerBI / Intermediate PowerBI (TTDPB02)

4.6 out of 5 rating Last updated 05/12/2024   English

Jump to outline

Global Schedule

GTR = Guaranteed to Run

15 Jan 25 Book
15:00 - 23:00 Live Online 1,695
05 Mar 25 Book
15:00 - 23:00 Live Online 1,695

24 Apr 25 Book
15:00 - 23:00 Live Online 1,695
11 Jun 25 Book
15:00 - 23:00 Live Online 1,695
30 Jul 25 Book
15:00 - 23:00 Live Online 1,695
17 Sep 25 Book
15:00 - 23:00 Live Online 1,695
29 Oct 25 Book
14:00 - 22:00 Live Online 1,695
10 Dec 25 Book
15:00 - 23:00 Live Online 1,695
Duration

2 Days

12 CPD hours

Overview

Working in a hands-on learning environment led by our expert facilitator, students will learn how to:
-Identify and retrieve data from data sources and understand the different connection methods.
-Optimize query performance
-Profile and examine the data and apply data shape transformations
-Develop a scalable and performance data model
-Enhance the data model with DAX using measures, calculated columns and tables
-Use variables and aggregations to optimize model performance
-Design and create reports and dashboards
-Select and add appropriate visualizations
-Create paginated reports
-Perform Advanced Analytics
-Create and manage workspaces
-Manage datasets and dataset refresh
-Apply row-level security

Description

Next Level Power BI for Experienced Users is a two-day course that provides attendees already experienced with Microsoft Power BI basics with a hands-on exploration of intermediate and beyond level features. This course is geared for attendees ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise's other line-of-business tools.

Prerequisites

This is an Intermediate PowerBI course geared for experienced users who wish to leverage the tool„¢s more advanced capabilities.

Get Started with Microsoft Data Analytics
Overview of Data Analysis
Roles in Data
Introduction to Power BI
Building Blocks of Power BI
Touring and Using Power BI
Prepare Data in Power BI
Introduction to getting data
Getting data
Select a Storage Mode
Fix Performance Issues
Identify and Resolve Data Import Errors
Cleaning, Transforming, and Loading Data
Profiling Data and Examining Structures
Identify column headers and names
Shaping Table Structure
Unpivot and Pivot columns
Apply user-friendly value replacements
Use Advanced Editor to Modify M Code
Designing a Data Model in Power BI
Introduction to Data Modeling
Joins and Relationships
Star Schemas
Configure Table and Column Properties
Modeling Challenges
Creating new Hierarchies
Create Model Calculations using DAX in Power BI
Introduction to DAX
Calculated Columns
Understanding Context
The CALCULATE() Function
Using Relationships Effectively
Time-Intelligence
Optimize Model Performance
Introduction to Performance Optimization
Performance Analyzer
Implement Table Granularity
Optimize Performance
Introduction to Aggregations
Managing Aggregations
Create Reports
Design a Report Layout
Choosing Effective Visualizations
Adding Visualizations to Reports
Format and Configure Visualizations
Basic Interactions
Configure Conditional Formatting
Design for Accessibility
Apply Slicing, Filtering, and Sorting
Publish and Export Reports
Create Dashboards
Introduction to Dashboards
Set Mobile View
Configure Data Alerts
Explore Data by Asking Questions
Configure Data Classification
Create Paginated Reports
Introduction to Paginated Reports
Getting Data
Create a Paginated Report
Work with Charts and Tables
Publish the Report
Perform Advanced Analytics
Introduction to Advanced Analytics
Explore Statistical Summary
Identify Outliers
Advanced Analytics Custom Visuals
Introduction to AI Visuals
Create and Manage Workspaces
Introduction to Workspaces
Create a Workspace
Create Apps
Monitor Usage and Performance
Data Protection
Manage Datasets in Power BI
Introduction to Datasets and Parameters
Dataset Scheduled Refresh
Incremental Data Refresh Settings
Manage and Promote Datasets
Troubleshooting Service Connectivity
Bonus Content / Time Permitting

Row-level Security
Security overview in Power BI
Row-level security
Static Method
Dynamic Method
Connect to OData feeds
Additional course details:

Nexus Humans Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the ITS Data Analytics course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

FAQ for the Next-Level PowerBI / Intermediate PowerBI (TTDPB02) Course

Available Delivery Options for the Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training.
  • Live Instructor Led Classroom Online (Live Online)
  • Traditional Instructor Led Classroom (TILT/ILT)
  • Delivery at your offices in London or anywhere in the UK
  • Private dedicated course as works for your staff.
How many CPD hours does the Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training provide?

The 2 day. Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training course give you up to 12 CPD hours/structured learning hours. If you need a letter or certificate in a particular format for your association, organisation or professional body please just ask.

Which exam does the Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training course prepare you for?

The Next-Level PowerBI / Intermediate PowerBI (TTDPB02) prepares you for the Yes official exam. You can take this exam at any exam center across Ireland including, Dublin, Cork, Galway, Northern Ireland or live online where ever you are. Exams vary in duration and if required you can request with the provider for any accommodations appropriate for you.

What is the correct audience for the Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training?

This is an Intermediate PowerBI course geared for experienced users who wish to leverage the tool's more advanced capabilities.

Do you provide training for the Next-Level PowerBI / Intermediate PowerBI (TTDPB02).

Yes we provide corporate training, dedicated training and closed classes for the Next-Level PowerBI / Intermediate PowerBI (TTDPB02). This can take place anywhere in Ireland including, Dublin, Cork, Galway, Northern Ireland or live online allowing you to have your teams from across Ireland or further afield to attend a single training event saving travel and delivery expenses.

What is the duration of the Next-Level PowerBI / Intermediate PowerBI (TTDPB02) program.

The Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training takes place over 2 day(s), with each day lasting approximately 8 hours including small and lunch breaks to ensure that the delegates get the most out of the day.

What other terms do people search for when looking for this course?

Popular related searched include PowerBI.

Why are Nexus Human the best provider for the Next-Level PowerBI / Intermediate PowerBI (TTDPB02)?
Nexus Human are recognised as one of the best training companies as they and their trainers have won and hold many awards and titles including having previously won the Small Firms Best Trainer award, national training partner of the year for Ireland on multiple occasions, having trainers in the global top 30 instructor awards in 2012, 2019 and 2021. Nexus Human has also been nominated for the Tech Excellence awards multiple times. Learning Performance institute (LPI) external training provider sponsor 2024.
Is there a discount code for the Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training.

Yes, the discount code PENPAL5 is currently available for the Next-Level PowerBI / Intermediate PowerBI (TTDPB02) training. Other discount codes may also be available but only one discount code or special offer can be used for each booking. This discount code is available for companies and individuals.

Jump to dates

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable. To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.

What people say about us


Top