Power BI Services

 
Power Query Icon.png

Data Acquisition & Transformations 

The process of connecting to your data for nearly any source, whether it's online or on-premises, where it can be transformed, shaped, or cleaned to align with any business requirements. Then importing the transformed data into the Data Model. All of this is done with a revolutionary data shaping tool built into Power BI, called Power Query. Learn the best practices and techniques for importing and transforming your data with these tools.

 

 
 
Data Model.png

Data Modeling

After going through the Data Acquisition process, it's important to learn how to leverage data modeling design principles. Principles such as building fact-type vs dimension-type tables, star vs snowflake schema’s and their performance impacts, and writing optimized DAX measures to create advanced metrics and insights. All these principles work together to turn your data into something that tells a compelling story.

 

 
 
Computer Report (Blue).png

Report & Dashboard Design

Equal importance needs to be placed on the design of the report itself. Learn about the art and science behind visual cues, chart types and selection, color theory, and minimalist design approaches. Plus report design can be enhanced by adding elements such as: drillthrough, bookmarks, report page tooltips, what-if scenarios, conditional formatting, and custom visuals.All of these, plus many other design techniques help deliver feature-rich reports that are intuitive, easy to use, and aesthetically pleasing.

 

 
 
Online Report.png

Report Publishing & Online Services

Another common hurdle people experience is figuring out how to share reports and content after they've finished development. There are important steps involved when it comes to sharing reports online effectively and securely, as publishing a report is only the first step. Important next steps include sharing the content with the correct users, scheduling automatic refreshes, creating workspaces and apps, and setting up row-level security so the data is secured.

 

 

Remote Consulting & Training

 
Online Training (Blue).png

Office Hours (Remote Consulting)

Have a problem that needs immediate help? Havens Consulting offers remote consulting for Power BI, Excel Power Pivot, and Power Query.

We'll happily setup a remote meeting using Zoom, Skype for Business, Microsoft Teams, or whatever remote conference software you prefer. From there we can help to diagnose and fix whatever issue you might be having.

If you're interested in setting up remote consulting, or if you just have general questions. Please visit our contact & support page below.


 
Custom Training (Blue).png

On-Site Trainings

We also provide on-site and instructor-led trainings to help teams adopt either Power BI, Excel Power Pivot, or Power Query for self-service business intelligence and analytics. Our curriculum is designed by the Founder of Havens Consulting, Reid Havens. Reid has extensive experience developing trainings and curriculums for multiple consulting companies, online publishers, and universities.

Among the organizations Reid has developed content for, he wrote multiple training curriculums for PowerPivotPro, and taught them as a Principal Consultant at dozens of companies around the world. He also developed college level classes for Bellevue College and The University of Washington.

Our approach to all of these curriculums is to train through hands-on labs and in-person guidance, attendees will learn to build and share stunning visualizations and valuable data insights using the tools found in Power BI and Excel. Our expertly designed framework mirrors the report development process, allowing attendees to apply their learnings quickly and easily back at their desks.

See below to find out more about our standard training offerings, including outlines for each day of content.


Standard Training Offerings

 
Experience (Blue).png
 

Designing Impactful Reports in Power BI

(One Day)

This training covers essential design principles and the necessary features available to build impactful reports in Power BI Desktop, and then share in the Power BI Service.

You will learn about methodologies such as: visual cues, chart types and selection, color theory, and minimalist design approaches. Students will also learn about how to enhance report design by adding elements such as: drillthrough, bookmarks, report page tooltips, what-if scenarios, conditional formatting, custom visuals, and more.

Best practices and recommendations will build upon the methodologies and features to provide a strong report design foundation.

This training will appeal to those new to Power BI and report design, and also for those already working with Power BI (for these individuals, this training will help fill in any gaps in your knowledge).

 
Data Model.png
 

Building Effective Data Models in Power BI

(Two Day - Part 1)

This training covers data modeling fundamentals and the necessary features available to build rich effective data models in Power BI desktop, which can be published to the Power BI service. Where users can access to build impactful reports.

You will learn about data modeling fundamentals through a development methodology that covers: creating model tables with Power Query, understanding model relationships, enhancing data model design with usability features and calculations, enforcing row-level security (RLS) through user roles, and more.

Best practices and recommendations will build upon the methodologies and features to provide a strong data modeling foundation.

This training will appeal to those new to Power BI and data modeling, and also for those already developing in Power BI Desktop (for these individuals, this training will help fill in any gaps in your knowledge).

 
DAX.png
 

Creating Calculations and KPIs with DAX in Power BI

(Two Day - Part 2)

DAX, which stands for Data Analysis Expression, Is the expression language in Power BI that allows the creation of advanced calculations, metrics, and KPIs. This training covers the fundamentals, theory, and the necessary functions to start writing measures in DAX.

You will learn about DAX fundamentals such as: identifying data types, understanding syntax and model reference types, filter context types, applying context transition, working with iterator functions, creating time intelligence calculations, and more.

Best practices and recommendations will build upon the methodologies and features to provide a strong data modeling foundation.

This training will appeal to those new to the DAX language, and also for those already developing measures with DAX (for these individuals, this training will help fill in any gaps in your knowledge).

All three days combine to offer a complete end-to-end Power BI training package, which combines 18 modules, 40+ exercises, 450+ slides, and content designed by a Microsoft MVP