Power BI: Implementing the Other 90% – Live, Online, 1-Day Training with Eugene Meidinger


Join Pluralsight course author, speaker, and blogger Eugene Meidinger 04 Mar 2020 as he discusses and demonstrates the practicalities of getting Power BI up and running in your enterprise in this live, 1-day course!

Out of stock


One of the things Eugene Meidinger found frustrating when he first learned Power BI was all of the behind-the-scenes configuration required to bring Power BI to the enterprise. It was easy to find information about charts and graphs, but difficult to learn about how all the moving parts fit together.

This lecture and demonstrations (only) course focuses on two main areas:

  • Data Wrangling; and
  • Administration

Session 1: Database Theory

When creating a model, it is important to know Power BI is optimized for star schema in particular and filtering/aggregating in general. Within Power BI lies a columnar database that has really good compression. This means Power BI’s model can handle a certain amount of flattening/denormalizing gracefully.

Business users are Power BI’s target demographic. We begin our exploration of Power BI with a review of database fundamentals for business users, covering topics such as:

  • Primary keys
  • Normalization
  • Star schema

Power BI offers two data manipulation languages:

  • Power Query (M)
  • DAX
  • (3 languages if you include R!)

Session 2: Power Query (M)

Power Query is designed for business users. It started as an Excel add-in to assist users familiar with the Excel formula bar. One result: Power Query surfaces an intuitive graphical user itnerface (GUI), but behind the scenes M syntax is generated.

In this session, Eugene discusses and demonstrates tips and tricks for using Power Query to clean and prepare data.

Session 3: DAX

To model and add context to data Power BI users apply DAX. DAX appears deceptively simple, very similar to Excel formulas – but DAX requires thinking in terms of columns and filters, not in terms of rows.

In this session, Eugene scales some of the steeper slopes of the DAX language learning curve.

Session 4: Data Gateways

Many enterprises practice hybrid data management in which some data and services reside in the cloud while other data and services reside on-premises. Data gateways are a way to bridge the Power BI service (in the cloud) with on-premises data.

In this session, Eugene discusses and demonstrates Data Gateway installation and configuration. Topics include:

  • Scheduling data refreshes
  • Alternative query methods
  • DirectQuery

Eugene authored a Pluralsight course related to this session: Leveraging Timely On-premises Data with Power BI.

Session 5: Licensing and Deployment

In this session, Eugene compares and contrasts Power BI licensing scenarios, including:

  • Power BI Pro
  • Power BI Reporting Server
  • Power BI Premium

Because it can be difficult to keep up with all of the options, Eugene discusses and demonstrates several ways to deploy Power BI Reports:

  1. Personal workspaces
  2. App Workspaces
  3. Organizational content packs
  4. Publish to web
  5. Sharepoint
  6. Power BI Premium
  7. Power BI Embedded
  8. Power BI Report Server

Session 6: Security and Auditing

Securing Power BI and the data it surfaces is no longer optional.

In this session, Eugene discusses and demonstrates:

  • Data access management
  • Report access
  • Sharing configuration
  • Row-level security in Power BI and SSAS
  • Auditing via:
    • Unified Audit log for Office 365
    • PowerShell
    • Data Gateway configuration


In conclusion, Eugene says, “Overall I’m pretty proud of the contents. This is the kind of course I wish I had been able to attend 3 years ago.”

This course does not focus on…

  • Managing visuals
  • Report design
  • Configuring a dashboard

For information on these topics, Eugene recommends the free YouTube video: Power BI Dashboard in an Hour.

About Eugene

Starting out as an accidental DBA and developer, Eugene Meidinger now focuses primarily on BI consulting. He is a Pluralsight course author who has been working with seven years’ SQL Server experience. Eugene holds SQL Server certifications and regularly presents at community events including SQL Saturdays and his local user group.
His current focus is Power BI and related areas.

This is a live online class. The class is hosted at GoToWebinar, live with Eugene Meidinger on webcam, with a 90-minute lunch break. Audio is available via your computer audio or dialing into a US phone number – we recommend using a headset.

Interested in more Power BI, SSIS, Biml, and Azure Data Factory training?

Visit Andy’s SSIS Training page!
Expert SSIS
Mastering the SSIS Catalog
Master the Fundamentals of Azure Data Factory
From Zero to SSIS
Advanced SSIS