Practical Power BI & DAX - Level 3 Course

The Practical Power BI & DAX - Level 3 Course will teach you how to turn your data into stunning visuals or dashboards, like the one pictured on the left, with advanced data-analysis tools, AI capabilities, and user-friendly report-creation tools. We will take you step-by-step through the wide range of Power BI visuals, including the familiar bar, column, and pie charts and more sophisticated charts such as treemaps, ribbon and funnel charts, and waterfall charts. The course will also teach you the fundamentals of DAX, allowing you to perform advanced data analysis and create dynamic reports, and you will learn to use DAX functions to enhance your Power BI dashboards and reports. You will begin by exploring the fundamentals of DAX syntax and basic functions. Then you will discover how to create and use calculated columns for data analysis and how to develop simple and not-so-simple measures for dynamic reporting.

Microsoft Power BI is a business intelligence platform that allows users to connect to and visualise data to uncover insights and create interactive reports. It is used to turn data into visuals, help make better decisions, and can be used in conjunction with familiar tools like Microsoft Excel. Data Analysis eXpressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, enabling powerful custom calculations and dynamic aggregations, considerably enhancing data analysis and reporting.

The course teaches all you need to know about the major components of the Power BI application and DAX functions and is presented in a modern multimedia online format, with the constant support and guidance of your designated course tutor, who is there for you every step of the way. During the course, you will build stunning dynamic dashboards, like the one pictured below, combining multiple charts, tables, and KPI indicators that react automatically to filters.

So, for example, you can select a particular year and see the data for that year on all charts. Or you can select a particular region or department and see only data on every chart pertaining to your selection. You will be amazed at what you can achieve with your newly-found skills.

The course is based on the tried and tested learn-by-example methodology, where we provide detailed information on a topic, provide an example, and offer you the opportunity to try it yourself. As you progress through the course, you will complete a series of exercises and assignments that give you the valuable hands-on practice you need to become proficient in Power BI and DAX.

On successful completion of the course, students will receive the Distance Learning Centre Practical Power BI & DAX Diploma with feedback and analysis of your completed work, as well as an Open Awards Level 3 Quality Endorsed Unit Course Certificate.

Based on the proven "learn by example” principle which, as the name implies, provides real-world examples to illustrate a particular topic or technique, the courses are delivered through our on-line training portal via a standard web browser, such as Internet Explorer, Firefox, Chrome, Opera, or Safari.

The lesson notes are delivered through slides giving you the required information to work through each lesson and there are student files you will download to work on so you are putting into practice what you are learning. You will also be supported by a personal tutor who is available to provide feedback on your work at any time throughout the period of study.

There are no particular entry requirements as the course is set out for beginners, although students should have a general understanding of computer use and an existing knowledge of the Microsoft Excel software package would be advantageous.

You can start this course at any time, and you would be registered for a one-year period. You also have access to a personal tutor who can be contacted by email. Your tutor is available to assist with any queries and to mark your assignments.

As the course is self-study, you can complete it as quickly as you like. Support extensions are available if students do not complete the course within the one-year period.

You will be assessed on assignments which are detailed in the course materials and there will be a separate assignment to complete for each unit in the course.

These project-based assignments can be sent back to your course tutor by email.

On successful completion of this course students will receive our Practical Power BI & DAX Course Diploma with feedback on your work and providing the assignments have been completed to the required standards students will also receive a Level 3 Open Awards Quality Endorsed Unit Course Certificate with 8 Open Awards Credits.

The completion of this course alone does not lead to an Ofqual regulated qualification but may be used as evidence of knowledge and skills towards regulated qualifications in the future. To this end the learning outcomes of the course have been benchmarked at Level 3 against level descriptors published by Ofqual, to indicate the depth of study and level of difficulty involved in successful completion by the learner.

You can find further information on qualifications/certificates and their levels on the Ofqual's level descriptors page.

The certification is issued through Open Awards. Open Awards are an Awarding Body Organisation approved by Ofqual. Set up in 1981, Open Awards (Previously the North West Region of the National Open College Network - OCNNW) have been in business for over 30 years and are a not for profit organisation and a registered charity.