Microsoft Power BI Data Analyst

This Power BI Data Analyst Training Course will discuss the various methods and best practices that align with business and technical requirements for modelling, visualising, and analysing data with Power BI. The course will also show how to access and process data from various sources, including relational and non-relational data.

Description

In this course, you will:

  • Ingest, clean, and transform data.
  • Model data for performance and scalability.
  • Design and create reports for data analysis.
  • Apply and perform advanced report analytics.
  • Manage and share report assets.

Course Outline

  • Module 1: Discover data analysis
  • Module 2: Get started building with Power BI
  • Module 3: Get data in Power BI
  • Module 4: Clean, transform, and load data in Power BI
  • Module 5: Design a data model in Power BI
  • Module 6: Add measures to Power BI Desktop models
  • Module 7: Add calculated tables and columns to Power BI Desktop models
  • Module 8: Use DAX time intelligence functions in Power BI Desktop models
  • Module 9: Optimise a model for performance in Power BI
  • Module 10: Design Power BI reports
  • Module 11: Configure Power BI report filters
  • Module 12: Enhance Power BI report designs for the user experience
  • Module 13: Perform analytics in Power BI
  • Module 14: Create and manage workspaces in Power BI
  • Module 15: Enhance Power BI report designs for the user experience
  • Module 16: Manage datasets in Power BI
  • Module 17: Create dashboards in Power BI
  • Module 18: Implement row-level security

Prerequisites

Successful Data Analysts start this role with experience of working with data in the cloud.

Specifically:

  • Understanding core data concepts.
  • Knowledge of working with relational data in the cloud.
  • Knowledge of working with non-relational data in the cloud.
  • Knowledge of data analysis and visualisation concepts.

Similar events

This introductory course is perfect for users who are looking to make a bigger impact with the way they report on data through visualisations. The course will be of particular benefit to team leaders, management at all levels, or anyone who needs to commission the production of reports or dashboards. Please note that this course does not cover PowerBI Pro, PowerBI accessed via Microsoft 365 or SharePoint Services.

More Information

This course is for Experienced Software Developers who are completely new to C++ programming or those with elementary skills in C++, who need to gain hands-on experience of developing commercial applications.

More Information

Our ITIL® 4 Foundation training course will enable you to understand a new way to look at IT Service Management (ITSM) through a Service Value System (SVS). Our ITIL® 4 Foundation training course will educate you on how to manage IT services and achieve business value within an enterprise. It is a widely accepted approach in IT Service Management (ITSM) and will introduce you to the core principles of ITIL® best practices and concepts.

More Information

CM2 is the global enterprise standard for enterprise change and configuration management and provides a comprehensive methodology for managing the configuration of a product, system, and/or service throughout its life. It provides the most robust framework and quality management platform for creating and maintaining a digital enterprise with complete end-to-end ecosystem traceability.

More Information

This course introduces the technology fundamentals of most SAP applications (incl. SAP S/4HANA and SAP Business Suite), how SAP systems function, as well as an introduction to different user interfaces, such as SAP Fiori or SAP GUI. The training contains hands-on exercises in an SAP S/4HANA system and other SAP applications. The course will also introduce learners to the SAP strategy and provides an overview of cloud topics.

More Information

This course provides you with fundamental knowledge on how to ensure a smooth operation of SAP systems running on Application Server ABAP (AS ABAP). AS ABAP is the technological foundation of SAP S/4HANA as well as SAP Business Suite systems. In this five-day training, you will learn how to perform various administrative tasks to keep the SAP system running.

More Information

This course provides learners with a thorough overview of the deployment options available with the GROW and RISE with SAP offerings, including the platforms, processes, services and tools available to them as a customer and/or an SAP implementer. The learner will explore Business Transformation as a Service, SAP Digital Discovery Assessment, sell and delivery qualifications (e.g. PartnerEdge), and the Partner Demonstration Landscape.

More Information

This course guides learners through the fundamental requirements and knowledge necessary for customer project team key users, IT Professionals, Solution Architects, and Project Managers who are beginning their journey into RISE with SAP S/4HANA Cloud, private edition implementations.

More Information

This is the Adobe Authorised course for new users of Adobe Photoshop. Produce and edit images to meet professional industry standards.

More Information

Please register on any session showing, this will not be the date the course takes place. Upon registration your e-learning will then be booked and all of the log in details sent to you. You can undertake the training as soon as you have received this..

More Information

Learn everything you need to start working as a Systems Engineer. While saving you hours every week. Learn the full systems engineering product development lifecycle, understand all of the jargon and have confidence in producing deliverables on your project from Day 1.

More Information

This course is for Experienced C++ programmers, who are looking to gain advanced skills and programming techniques using C++

More Information

Gain core knowledge and experience to successfully implement and manage security programs and prepare for the 2024 CISSP certification. This 2024 updated course is the most comprehensive review of information security concepts and industry best practices, focusing on the eight domains of the CISSP-CBK (Common Body of Knowledge) that are covered in the CISSP exam.

More Information

This course is an introduction to Python and its main data analysis libraries, Pandas and Matplotlib for delegates with some understanding of programming concepts. It is a two-part course, the first is an introduction to Python programming, the second introduces Python's data analysis tools. For the programming environment we use JupyterLab on the Anaconda platform. Anaconda is one of the most, if not the most, popular Data Science platforms.

More Information