Power BI on Premises from Start to Finish

Unlock the full potential of your on-premises data with our expert-led Power BI course, perfect for analysts and IT professionals aiming to deliver impactful, local data visualizations without relying on cloud solutions.

Course Thumbnail

Essential Skills Gained

Checkmark

Utilize Power BI Desktop to develop robust reports.

Checkmark

Implement data modeling for efficient analytics.

Checkmark

Design interactive and visually appealing data visualizations.

Checkmark

Ensure secure and scalable deployment on Power BI Report Server.

Format

  • Instructor-led
  • 2 days with lectures and hands-on labs.

Audience

  • Data Analysts
  • BI Developers
  • IT Professionals
  • Business Intelligence Managers

Description

Interested in using the self-service data analytics functionality of Power BI but are not sure where to start? Interested in Power BI and want to keep your data local as you do not want data hosted in the cloud? This unique class will explain how to deploy Power BI locally with Power BI Report Server in order to provide the capability available for Power BI Reporting on your server, without having to go to the cloud. This two day class is designed to introduce users to Power BI Desktop and learn how to develop reports while using the tips and techniques learned through years of client consulting to provide a scalable analytic solution.  The class will include demonstrations and exercises to provide attendees with a through explanation of all the material presented. Knowing how things work in the real world is an important component needed for successful training experience as this provides the ability to answer questions posed outside of the prepared material.  Attendees will benefit from having an instructor who has delivered a number of successful Power BI implementations. This class is developed and taught by Ginger Grant, a Microsoft Data Platform MVP and Microsoft Certified Trainer.  She has many years of experience implementing customer solutions using the Microsoft Data Stack.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

DAY 1

  1. Power BI Desktop Walkthrough

  2. Data Modeling for an effective report solution

  3. Adding data from different sources

  4. Developing initial aggregations, including Totals and Averages

  5. Designing interactive visually appealing data visualizations

  6. Creating Time based calculations, such as Same Period Last Year and Rolling 12 Month values

  7. Cleaning up badly formatted data

DAY 2

  1. Visualization Color and Layout Techniques

  2. Power BI Report Server Walkthrough

  3. Power BI Deployment and Access

  4. Security Techniques for Reports and Data

  5. Automatic Data Refresh

  6. Administration considerations

  7. Mobile Deployment of Power BI Reports

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.