Data Bear – Power BI Training and Consulting

Call us Today! (020) 8720 6880 |
Power Bi

Power BI Training

Power BI Foundations Course


Introduction to Power BI Foundations Course

Supercharge your data analytics skills with our 2-day Power BI Foundations course! Whether you’re a business professional, data analyst, or aspiring data scientist, this comprehensive program will empower you to harness the full potential of Power BI.
Discover the world of Power BI as we guide you through its features, licensing options, and workflow. From Power BI Desktop to the Cloud Service, you’ll master the art of creating captivating visualisations and insightful reports. Unleash the power of data modeling and query building as you learn to extract, transform, and load data from diverse sources.

Our experienced instructors will demystify DAX formulas and time intelligence functions, equipping you with the tools to derive valuable insights from your data. You’ll gain hands-on experience in optimising report design, selecting the right visualisations, and enhancing interactivity. Plus, learn the best practices for governance, security, and collaboration in Power BI.

Don’t miss this opportunity to take your data analytics skills to new heights. Enroll in our Power BI Foundations course and unlock the potential of data-driven decision making. 

Get ready to revolutionise the way you analyse and present data with Power BI.

Course Prerequisites

As this course serves as an introductory to Power BI, no previous Power BI experience is required. Starting from the basics, the Power BI Foundations course is a comprehensive program that provides participants with a solid understanding of Power BI and its key features. Starting with an overview, participants learn about the value offering, licensing, and pricing options. They then explore Power BI Desktop, understanding its components, workflow, and how to connect to data sources.

The Power BI Foundations course also covers the Power BI Cloud Service, focusing on best practices for creating dashboards and securely sharing content across the organization.

With an emphasis on data modeling concepts, we teach best practices for handling different data structures and utilising star a schema for efficient analysis. Participants gain hands-on experience with data extraction, transformation, cleaning and loading processes. They also learn key report building concepts and functionality, that empower building compelling interactive reports for end users.

Additionally, the Power BI Foundations course introduces participants to DAX, the formula language in Power BI, and covers evaluation context, calculated measures, and time intelligence concepts. Governance and distribution is covered, including row-level security, creating group workspaces and sharing reports and dashboards inside a Power BI app. 

The course concludes with a review of key concepts, resources for further learning, and open discussions. Overall, participants develop the knowledge and skills necessary to leverage Microsoft Power BI effectively for data visualisation and analysis.

The key learning objectives

By the end of this 2-day course, participants will have developed a solid understanding of Power BI Desktop. They will have the necessary skills to design, model, and visualise data, and collaborate in Power BI cloud service to deliver compelling reports that address business needs effectively.

Understanding Power BI:

Participants will gain a comprehensive understanding of Power BI, including its features, value offering, and licensing options. They will grasp the overall workflow and components of Power BI Desktop and the Cloud Service.

Data Modeling and Query Building:

Participants will learn best practices for data modeling, including establishing relationships between tables and utilising star schema. They will acquire skills in extracting, transforming, and loading data from various sources, as well as applying common data transformations and building efficient queries.

Report Building and Visualization:

Participants will learn how to design and optimise reports, choosing appropriate visuals based on context. They will enhance report interactivity, customise visual elements, and utilise advanced features such as KPI cards, tooltips, drills, and conditional formatting.

DAX Formulas and Time Intelligence:

Participants will gain proficiency in using DAX formulas, understanding its syntax and commonly used functions. They will explore evaluation context and learn how to create calculated measures and utilise time intelligence concepts for analysing data over time.

Governance and Distribution:

Participants will understand the importance of governance in Power BI, including implementing row-level security, publishing models, and sharing reports and dashboards. They will also learn how to collaborate in group workspaces and publish Power BI apps for consumers.

Throughout the course, ample time will be provided for students to follow along with the instructor during demonstrations and labs. The labs are designed to reinforce the concepts learned in each module and provide hands-on practice in applying the skills

Why Choose Us?

Frequently Asked Questions

As Power BI Foundations training course starts with an introductory overview of Power BI, delegates who attend this course do not require any previous BI training or prior Power BI experience. The course is designed to guide delegates from zero to hero. We often have users who have been using the tool extensively attend our course and during the course they find that there were many ‘gaps’ in their learning. The training course adds value to both those who are new to Power BI and those who already have experience with the tool.

As our Power BI Next Level training course follows on from our Power BI Foundations course, delegates who attend this course are required to have completed the Foundations course or have practical experience and understanding of our Foundation course topics. This course is designed to provide delegates with a deeper understanding of Power BI Concepts enabling them to create highly effective reports.

Yes, when buying our ‘Immersive Bundle’ course, you will receive 20% discount on both courses. We have schedule these two courses to always run back-to-back, thus if you would like to be fully immersed you can attend the consecutive 4 days immersive training option. 

Some general requirements: All delegates need a laptop running Windows OS (BYO Laptop), Delegates will need to be able to download and install the latest version of Power BI Desktop on their laptop, or need to have the latest version pre-installed. Training files and a digital copy of the manual will be provided as well as a Power BI Pro accounts for use during the course. Those attending our online courses, should have access to 2 screens.

Our courses focus on understanding key concepts around how best to use the tool to solve business problems. This is a totally different way of thinking and thus requires a different approach. The success of our courses are grounded in our passion to focus on best practice concepts that empower a solid foundation to build upon. 

What distinguishes Data Bear as a Power BI training provider is that our company is an established Power BI partner with a vertical focus on implementing Power BI solutions. On top of this, we are also a Microsoft Gold Partner in Data Analytics. Our team includes a Microsoft MVP for 2019 – 2020 for their contribution around Power BI. The Microsoft Most Valuable Professional (MVP) award is given by Microsoft to technology experts who passionately share their knowledge with the community. We also have a Microsoft Certified Trainer (MCT). Microsoft Certified Trainers (MCTs) are certified premier technical and instructional experts in Microsoft technologies. As a consulting organisation with a central focus on Power BI, you have the benefit of receiving specialist training from instructors who draw on their industry experience to teach best practice to solve business problems.

Yes. Data Bear’s Power BI support services offers team augmentation that can be more cost-effective and efficient way to embrace and harness Microsoft technologies. As a Microsoft Gold Partner, Data Bear offers dedicated resources to contribute to your projects or ad-hoc tasks to help increase the quality of work whilst reducing time spent on development or problem solving. With our team at your service, you have access to a broader talent pool that are continuously upskilling to ensure enhance business efficiency and best practice. 

If you require our course content to be tailored to your specific needs, we suggest you request a private training session. In this scenario, one of our trainers will provide your team customised training. We also provide Power BI training using your own data (BYO data training).
Yes! We understand that some of your team may be located outside the UK and would thus prefer a remote learning option. Our live online remotely delivered courses will still cover all the same aspects as in-person training.

If you’re new to Power BI, then our Foundations course is the best option for you. This will give you a comprehensive overview of what the tool can do and how best to do so. The Power BI training exercises focus on ensuring that you will master the basics and have a solid best practice foundation around telling a compelling story with data. Our Next Level course allows a deeper focus on key learning concepts. If you are wanting to dive a little deeper into creating robust reports, then in addition to the Foundations course, the Next Level is a good option. 

Our team provides Power BI consulting and support services to organisations globally. Our experienced Power BI consultants have developed a ‘Requirements Analysis’ template which helps facilitate the process of communicating and collating your specific reporting requirements. We also provide mentorship, if your analysts need supercharging, our Power BI consultants will mentor them and ensure they are equipped to help create a ‘data culture’ in the organisation.

When booking a private class you can ensure that only your organisation’s team members are in the class. This provides freedom to ask specific questions around your usage scenarios and to focus on specific content as requested. Private class can be tailored to your needs. When booking a private class, we also offer significant discounts for larger groups.
Yes, when pricing our private Power BI training, we offer significant discounts (up to 70%) based on the number of delegates, and only charge for the first 5 delegates. We can deliver private bespoke training at your premises throughout the UK or as a live online session.

Yes, as it is important for IT to understand how governance and security are managed within the Power BI admin portal, we offer specific training focusing on empowering IT to manage Power BI roll-outs.

Yes, without end user training, consumers loose value by not knowing how to use some of the rich features Power BI offers. For example, there is native artificial intelligence (AI) within Power BI which could potentially unlock hidden insights with a simply click of a button. We ensure end users are empowered to derive significant value from a Power BI solution.

Interested in Discussing this Training course?

Chat with one of our trainers before booking

Got any Power BI Training Questions?