DURATION
Four full days: 9:30am – 4:30pm
LOCATIONS
Exeter, Manchester, Liverpool, London, Bristol, Onsite at your premise, Remote Live Session via Teams
For onsite courses we can provide the rental of laptops with the software pre-installed.
SECTORS WE TRAIN
NHS and Healthcare, MOD, Police, Councils, Energy, Water
MICROSOFT POWER BI COMPLETE OVERVIEW AND OBJECTIVES
This 4-day course is intended for anyone new to designing and implementing self-service business intelligence solutions with Microsoft Power BI Desktop and the Power BI Service. The course structure is very comprehensive and provides a total immersion in the subject matter. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI is continually evolving, this course is regularly reviewed and updated to keep the content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience. Due to the very comprehensive nature of this course, the content delivered may vary depending on new and updated features, and client requirements.
The course structure takes a broad and practical approach to Power BI, defining best practices and demonstrating useful techniques that will prove extremely useful in the workplace. The content delivered will also help delegates prepare for the “PL-300 Microsoft Power BI Data Analyst” exam.
The first part of the course introduces the capabilities and components of Power BI before delving into the realms of discovering and loading data from a variety of sources. Primarily focussed on using Power Query to create robust queries, students will learn about issues surrounding data quality, how to cleanse data, how to transform and then restructure data, and how to mashup data from various sources by merging and appending data. We will also examine how to manage, structure, and parameterise queries. Although a lot can be achieved working with the user interface in Power Query, we will also delve behind the scenes and introduce the M language, highlighting ways in which existing code can be tweaked and how user defined code and functions can be implemented.
Part two of the course introduces students to tabular data modelling concepts, preparing the data in readiness for use in reports and dashboards. The importance of implementing relationships is also covered. In order to enhance the data model, students will also learn about the DAX expression language to enable them to implement calculated columns, measures, and calculated tables. Consideration is also given to implementing time intelligence in the design of data models.
In part three, you will learn how to create and design reports and implement visuals. We will first look at text-based visuals before moving on to graphical components like charts, gauges and KPIs (Key Performance Indicators). The implementation of maps in reports is also given coverage. To create interactivity in reports, students will also learn how to implement various types of filters and slicers.
Finally, in part four, we initially look at how we can further enhance the user experience by implementing features such as drillthrough reports, bookmarks, and showing and hiding content. Then, in order to share reports created in Power BI Desktop, we turn our attention to the Power BI Web Service. Attendees will learn how to publish reports to the Power BI Service and how to organize and secure content. The creation and use of dashboards will be considered, and different ways of sharing content will also be given coverage. We will look at user accessibility issues and consider how users, including mobile users, can interact with report content. Managing and refreshing datasets in the Power BI Service is also included.
Additionally, with the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.
Upon successful completion of this course, students will be able to:
🔹Understand the Role Power BI plays in Self-Service BI
🔹Understand the Constituent Parts of Power BI Desktop
🔹Discover and Load Various Types of Data
🔹Improve and Enhance Data Quality
🔹Transform Data
🔹Restructure Datasets
🔹Combine Data from Multiple Sources
🔹Parameterise Queries
🔹Implement a Tabular Data Model
🔹Create and Manage Relationships
🔹Understand the DAX Expression Language
🔹Implement Calculated Columns
🔹Implement and Work with Measures
🔹Implement Time Intelligence
🔹Create Reports with Text-Based Visuals
🔹Implement Conditional Formatting
🔹Create and Implement Charts
🔹Implement Gauges and KPIs
🔹Implement Maps
🔹Implement Slicers and Filters
🔹Implement Cross Visual Interactions
🔹Analyse Data with Advanced Visuals
🔹Enhance the Report Consumer Usability Experience
🔹Understand the Role of the Power BI Service
🔹Publish Reports
🔹Create and Manage Dashboards
🔹Manage and Secure Content in the Power BI Service
🔹Create and Distribute Apps
TARGET AUDIENCE
This course is aimed at anyone new to self‑service business intelligence who needs to quickly learn how to analyse and report on data using Power BI.
WHATS INCLUDED
🔹Professional instructor‑led training
🔹Courseware included
🔹Lunch provided
🔹Free on‑site parking at our Exeter training suite
🔹Certificate of completion
COURSE PREREQUISITES
There are no specific technical prerequisites for this course, but a familiarity with Power BI and/or relational database technologies may prove beneficial. The main consideration is to have a basic understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
WHY CHOOSE OUR MICROSOFT POWER BI COMPLETE TRAINING COURSE?
With years of experience delivering Microsoft Power BI courses to businesses and individuals, we make learning Power BI simple, practical, and enjoyable. The Complete course provides the ideal foundation for building your skills for work, study, and personal use.