Training: Master Power BI
Microsoft
49 uur
Engels (US)

Training: Master Power BI

Snel navigeren naar:

  • Informatie
  • Inhoud
  • Kenmerken
  • Meer informatie
  • Reviews
  • FAQ

Productinformatie

In deze training verdiep je je in de wereld van Power BI. De training is verdeeld in vier hoofdstukken en je begint met ‘’Data Loading to Stunning Visualizations’’. In dit deel leer je basisrapporten maken, geavanceerde gegevensmodellering, diverse gegevensbronintegratie en geavanceerde visualisatietechnieken, zoals Sankey-diagrammen en Gantt-diagrammen. Ga verder met ‘’Power BI Service en Power Query’’, waarin Power BI-servicefuncties zoals delen, samenwerken en cloud-implementatie centraal staan. Daarnaast leer je dynamische dashboards maken, Power Query gebruiken voor datatransformatie en rapporten optimaliseren voor mobiele apparaten.

In het hoofdstuk ‘’Advanced Topics in Power BI’’ leer je over Power BI-beheer, beveiliging, prestatie-optimalisatie, toegangsbeheer, gegevensgateways en bescherming. Je onderzoekt ook realtime dataverbindingen en prestatie-verbeteringstechnieken, zoals caching. Het laatste hoofdstuk ‘’Power BI Artificial Intelligence’’ behandelt de diverse aspecten van AI in Power BI, van het automatisch genereren van inzichten tot het creëren en integreren van machine learning-modellen. Ook maak je kennis met AI-grafieken en natural language processing voor het verwerken van gegevens.

Inhoud van de training

Master Power BI

49 uur

Data Loading & Visualization in Power BI: Getting Started

Power BI is a popular and widely used business intelligence and data visualization tool developed by Microsoft. It empowers organizations to transform raw data into meaningful insights and interactive visualizations, enabling more informed decision-making. You'll begin this course by getting a big picture understanding of what Power BI has to offer, including three core features: data connectivity for easy data loading, transformation and modeling options, and visualizations. Next, you'll install Power BI desktop from the Microsoft Store, and explore its user interface. You'll see where you can build your reports, view your data and set up modeling relationships. Finally, you will access data from a file and learn how to transform and process that data so it can be used for data analysis and visualizations. You will work with Power Query to rename column headers and remove duplicates, learn to merge and split columns, and view data profile, quality, and distribution. When you have your data in the right format, you'll load the data into Power BI and set up a simple bar chart visualization in your report.

Data Loading & Visualization in Power BI: Loading Data from Databases

Power BI offers a seamless and efficient way to connect and retrieve data from databases. It supports a wide range of database systems including, but not limited to, SQL Server, Oracle, MySQL, and PostgreSQL. Users can establish connections to these databases by providing connection details such as server addresses, authentication credentials, and database names. You will start this course by loading files stored in SharePoint into Power BI. You will authenticate yourself to SharePoint from Power BI to access, process, and load data. Then, you'll visualize the data with pie and donut charts. Next, you'll load data from SQL Server into Power BI. You'll discover the difference between the Import mode and the DirectQuery mode. Lastly, you'll import data from a MySQL database, connect to MySQL using root credentials and user credentials, and learn to reset credentials and configure new ones.

Data Loading & Visualization in Power BI: Loading Data from Cloud Storage

Power BI offers robust capabilities to seamlessly retrieve data from various cloud storage services, facilitating efficient integration of cloud-based data into reports and visualizations. It supports connections to popular cloud platforms, including Microsoft Azure Blob Storage, Amazon S3, Google Cloud Storage. In this course, you will learn how to import data into Power BI from BigQuery on the Google Cloud Platform (GCP). You will create a service account with the permissions necessary to access and load data. Next, you will work with S3 buckets on Amazon Web Services (AWS) and create an Identify and Access Management (IAM) user with the credentials necessary to access and work with S3. You will write a Python script to connect to S3 and load and import data into Power BI. You will then access and retrieve data from Azure Blob Storage to load it into Power BI for analysis and use a connection string to authenticate and authorize Power BI to Azure storage. Finally, you will import data by making REST API calls and from embedded HTML in a web page using a Web connector and build visualizations such as pie charts, line charts, treemaps, and area charts in your Power BI report.

Data Loading & Visualization in Power BI: Data Modeling

Power BI's data modeling capabilities empower users to craft sophisticated data relationships, calculations, and hierarchies. With the ability to establish meaningful connections between different data tables through relationships, users can seamlessly integrate disparate datasets and facilitate the creation of dynamic calculated columns and measures for in-depth analysis with Data Analysis Expressions (DAX). Hierarchies further enhance exploration by enabling intuitive drilldowns in your data. In this course, you will explore calculated tables and perform operations such as UNION, INTERSECT, and NATURALINNERJOIN to craft new tables. You will work with calculated columns and create and use calculated measures. Next, you'll learn how to create and model relationships between your tables, explore cardinality, and uncover the concept of cross-filter direction that influences the flow of filters across relationships. Finally, you'll explore hierarchies in Power BI, working with both default and custom hierarchies.

Data Loading & Visualization in Power BI: Advanced Visualizations

Power BI's advanced charting features, including gauges, funnels, radar charts, calendars, and Sankey diagrams, elevate data visualization by presenting insights in innovative formats. These specialized visuals in Power BI empower users to convey intricate information effectively, enhancing their ability to derive valuable insights from diverse datasets. You will start this course by creating gauge charts and funnel charts. Next you will visualize data using Sankey diagrams and learn how to work with Gantt charts to map project schedules. Finally, you will explore how to use radar charts to compare multiple variables across data points and implement heatmaps to highlight patterns and variations. You will also work with calendar layouts, which are similar to heatmaps but showcase values within a calendar framework.

Final Exam: From Data Loading to Stunning Visualization

Final Exam: From Data Loading to Stunning Visualization will test your knowledge and application of the topics presented throughout the From Data Loading to Stunning Visualization track.

Implement a Data Model by using DirectQuery [Guided]

In this Challenge Lab, you will implement a data model by using DirectQuery. First, you will create an Azure SQL database, and then you will create a data model. Next, you will create a chart-based report. Finally, you will publish the report, and then you will update the data to show the DirectQuery direct connection. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or exit and then return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Implement a Data Model by using Power Query [Guided]

In this Challenge Lab, you will implement a data model by using Power Query. First, you will create a data model, and then you will transform data by using Power Query. Finally, you will create a report, and then you will publish the report. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or exit and then return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Create Model Calculations by Using Advanced DAX [Guided]

In this Challenge Lab, you will create model calculations by using advanced DAX. First, you will create a data model, and then you will create advanced DAX calculations. Finally, you will create a report, and then you will publish the report. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or exit and then return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Getting Started with Power Query in Power BI

Power Query is a powerful data transformation and preparation tool, seamlessly integrated into Microsoft Power BI and other Microsoft products such as Excel. It enables users to effortlessly extract, transform, and load data from various sources, ensuring data consistency and quality. Begin this course by exploring how to transform and clean data using Power Query. You will learn to delete, rename, and move columns, remove duplicates, and perform a host of other data cleaning and processing operations. Next, you will discover how to create query duplicates and references and how to perform basic and advanced filtering on your data. Then you will find out how to add columns with calculated and conditional values and how you can use merge queries to create a new column in your data. Finally, you will perform grouping and aggregation operations, create parameterized queries, and combine query data using the append operation. This course will provide you with a solid understanding of how Power Query can be used for data transformation.

Performing Joins Using Merge Queries in Power BI

In Power BI, you can establish data relationships and use Power Query to perform joins to merge multiple data tables into a cohesive dataset. By defining these relationships and using functions like merge queries, you can seamlessly combine data from different sources based on common keys, enhancing data integration and enabling in-depth analysis. In this course, you will discover how to create relationships between tables that will allow you to perform more complex inter-table operations. Next, you will learn how to perform SQL-style joins on two tables. Power BI offers numerous types of joins, including inner, outer, left, right, left anti, and right anti joins. You will implement all of these join techniques to define the differences between them and describe their use cases. You will also learn how to pivot and aggregate data in Power Query. Finally, you will explore fuzzy merging to perform joins for inexact matches. This course will provide you with a foundation for how to perform exact and fuzzy joins in Power BI.

Create a Multi-page Slicer Report by Using Microsoft Power BI [Guided]

In this Challenge Lab, you will create a multi-page slicer report by using Microsoft Power BI. First, you will prepare data, and then you will get data from data sources. Finally, you will create a multi-page slicer report, and then you will publish the report. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or exit and then return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Getting Started with the Power BI Service

Power BI service is a Microsoft cloud-based platform designed for sharing, collaborating, and publishing Power BI reports and dashboards. Begin this course by exploring dataflows and datasets in order to create, use, and refresh dataflows and datasets in the Power BI service. Next, you will create and use auto-generated reports and manually create reports and dashboards in the Power BI service. You will also learn how to use the dashboard Q&A feature to ask natural language questions to Power BI. Then you will examine a variety of features of reports and dashboards and find out how to connect to a dataflow from Power BI Desktop to create a report using that data. Finally, you will focus on publishing reports from the desktop to the Power BI service, creating a dashboard with charts from multiple reports, using slicers to filter the data in your visuals, and exporting and embedding Power BI reports in SharePoint sites. Upon course completion, you will be able to confidently use Power BI service to create and collaborate on reports and dashboards.

Setting up the Power BI service environment [Guided]

In this Challenge Lab, you will set up the Power BI service environment. First, you will deploy a Microsoft 365 tenant, and then you will create a Power BI service account. Next, you will create a Power BI workspace, and then you will create a Power BI dataset. Finally, you will create Power BI reports. This lab is a prerequisite for all related Power BI Challenge Labs. You must complete this lab, and then save the trial account credentials before beginning any related Power BI Challenge Labs. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Working with Scorecards, Dashboards, & Paginated Reports in Power BI

In Power BI, a scorecard is a useful visual tool for presenting and tracking essential key performance indicators (KPIs), offering a quick and concise overview of critical data points. On the other hand, paginated reports are structured documents designed for generating formal, print-ready reports. Power BI's deployment pipelines play a pivotal role in streamlining the development and deployment of BI solutions and automating processes. In this course, you will discover how to use scorecards and metrics to track KPIs. Then you will learn how to pin visuals as live tiles and update them by refreshing data. Next, you will find out how to add slicers to filter visualizations and explore how to create and embed paginated reports in your dashboard. Finally, you will examine Power BI applications and deployment pipelines, create Power BI apps to package your reports and dashboards, and use deployment pipelines to manage the life cycle of your content in the Power BI workspace. Upon course completion, you will be able to effectively work with scorecards, dashboards, and other important features of Power BI.

Create a Report by Using a Custom Theme [Guided]

In this Challenge Lab, you will create a report by using a custom theme. First, you will prepare data, and then you will create a custom theme. Finally, you will create a report, and then you will publish the report. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or exit and then return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Using the Power BI Mobile App

Power BI Mobile is a dedicated app that allows users to access their Power BI reports and dashboards from smartphones and tablets. It offers a responsive and user-friendly interface, enabling mobile data exploration, sharing, and collaboration. Begin this course with an exploration of the Power BI Mobile application on an Android device, learning how to create a mobile layout for a report and add visual-level and report-level data. Next, you will examine the features of the Power BI Mobile application to see what functionality is available to you on the go. Then you will learn how to configure a shortcut to open a report from your phone's home screen and how to create and use QR codes to easily share a report. Finally, you will discover how to share dashboards with other team members and how to use annotations to mark important visuals in a dashboard. After completing this course, you will be able to confidently use the Power BI Mobile application to view and analyze reports and dashboards on your mobile device.

Create an Alert for a Report by Using Microsoft Power BI Data Analyst [Guided]

In this Challenge Lab, you will create an alert for a report by using Microsoft Power BI. First, you will prepare data, and then you will get data from a data source. Next, you will create a report, and then you will publish the report. Finally, you will create an alert for a dashboard tile. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or exit and then return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Create an Incremental Refresh Policy by Using Microsoft Power BI Data Analyst [Guided]

In this Challenge Lab, you will create an incremental refresh policy by Using Microsoft Power BI. First, you will create an Azure SQL database, and then you will create a data model. Next, you will create a report. Finally, you will publish the report, and then you will update the data to verify the incremental refresh policy. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or exit and then return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Final Exam: Mastering Power BI Service and Power Query

Final Exam: Mastering Power BI Service and Power Query will test your knowledge and application of the topics presented throughout the Mastering Power BI Service and Power Query track.

Getting Started with Power BI Administration

The Power BI Fabric administrator is a role dedicated to managing the Power BI service for an organization. Fabric admins have the authority to control workspace settings, access permissions, and data policies, ensuring secure and efficient data governance within the Power BI environment. In this course, you will learn about the administrative roles in Power BI. You'll see that the Fabric administrator role is the main administrative role and has full access to management tasks, usage auditing, and performance monitoring. You will work in the Admin Portal, which is the primary workplace of Fabric administrators, where all administration settings, audit logs, and performance metrics are visible. Next, you will learn how to use Power BI as a Fabric administrator. You discover how to allow or block specific operations for all users in an organization or for specific security groups. Finally, you will explore a number of administrative settings and how you can configure them.

Working with Real-time Streaming in Power BI

Power BI's real-time streaming capabilities enable users to visualize and analyze data as it's generated or updated. By connecting to various streaming data sources, such as Internet of Things (IoT) devices or social media feeds, Power BI allows for immediate insights and dynamic dashboard updates, enhancing situational awareness and enabling proactive decision-making based on the most current information. In this course, you will learn how to connect to on-premises data sources using a data gateway. You will explore the two types of data gateways: standard mode and personal mode. Next, you will learn about the three main types of Power BI datasets: streaming, PubNub, and push datasets. You will discover how to create and use streaming dashboards, create dashboards with streaming tiles and different visuals, and configure live dashboard tiles. Finally, you will explore how to create hybrid datasets, which are both streaming and push, and how to create reports using this data. You will also learn about other advanced features useful for data streaming, such as dashboard alerts, scheduled refresh of data, and query caching.

Final Exam: Advanced Strategies for Administration, Security, and Performance

Final Exam: Advanced Strategies for Administration, Security, and Performance will test your knowledge and application of the topics presented throughout the Advanced Strategies for Administration, Security, and Performance track.

Implement Row Level Security by Using Microsoft Power BI Data Analyst [Guided]

In this Challenge Lab, you will implement row level security by using Microsoft Power BI. First, you will create a test user, and then you will prepare the data. Next, you will create a role, and then you will create a report. Finally, you will publish a report. Note: Once you begin the Challenge Lab, you will not be able to pause, save, or exit and then return to your Challenge Lab. Please ensure that you have set aside enough time to complete the Challenge Lab before you start.

Leveraging AI Insights & Text Analytics in Power BI

Power BI's artificial intelligence (AI) capabilities offer a remarkable blend of data analytics and artificial intelligence. Power BI empowers users to unlock hidden patterns, generate predictive forecasts, and gain a deeper understanding of their data without requiring extensive data science expertise. You will start this course by generating insights on data and reports. You will explore how to generate these insights on datasets, reports, and even dashboard tiles. You'll also learn how to harness AI to explain fluctuations in your data. Next, you will learn how to perform text analytics in Power BI. You will explore how to use the Text APIs for language recognition, key phrase extraction, and sentiment analysis. Finally, you will use image analytics in Power BI by loading a dataset of images and generating tags for each set.

Training Machine Learning Models in Power BI

Machine learning (ML) in Power BI provides a dynamic and transformative dimension to data analysis. This feature enables users to create predictive models, discover patterns, and make data-driven decisions while requiring no programming or machine learning expertise. You will start this course by creating a binary classification model that will be used to predict categorical variables. You will load in data and perform exploratory data analysis, including visualizing the data and extracting insights. Then, you will create and train a binary classification model and use it for predictions. After training the model, you will view the training report that will allow you to evaluate your model's performance. Next, you will build a regression model to predict the value of a continuous variable. You will load in the data and perform preprocessing steps to clean your data. You will also perform exploratory data analysis and visualize your data to extract insights about patterns and trends in your data. Then, you will create and train your regression model and learn how to interpret the training report generated by Power BI. Finally, you will perform multi-class classification.

AI-powered Visuals in Power BI

Power BI includes power features that offer valuable insights into your data. The Key Influencer visual helps identify the factors or attributes that have the most significant impact on a chosen outcome. On the other hand, the Decomposition Tree provides an intuitive way to break down complex data into understandable components, allowing users to explore data hierarchies and identify key contributors to a specific metric. You will start this course by learning how Power BI will leverage artificial intelligence (AI) for detecting anomalies in time series data. Next, you will use decomposition tree visualizations to drill-down into measures. You will also make use of AI splits, which are AI-generated drill-downs into high value and low value categories. Finally, you will use Key Influencer visualizations to help you identify factors in your data that drive specific outcomes.

Smart Narratives, Q&A Visuals, & Copilot in Power BI

Smart narratives and the Q&A feature in Power BI enhance data storytelling and interactivity for reports and dashboards. Smart narratives automate the creation of textual descriptions and insights from data. The Q&A feature, on the other hand, allows users to ask natural language questions about their data and receive immediate responses and insights. You will start this course by using smart narratives in Power BI to generate natural language summaries of visualizations, dashboards, and reports. You will configure dynamic variables in your narratives that update with your data. Next, you will use the Q&A feature to ask natural language questions about visualizations that will be answered with numbers, charts, or tables. You will also learn to use the Teach Q&A feature to teach the Q&A widget to work with organization-specific terminology. Finally, you will learn how to use Power BI Copilot. You will explore how to calculate measures using natural language queries to generate DAX commands and add those measures to your reports.

Final Exam: Unleashing AI in Power BI

Final Exam: Unleashing AI in Power BI will test your knowledge and application of the topics presented throughout the Unleashing AI in Power BI track.

Kenmerken

Docent inbegrepen
Bereidt voor op officieel examen
Engels (US)
49 uur
Microsoft
180 dagen online toegang
HBO

Meer informatie

Doelgroep Data-analist
Voorkennis

Geen formele voorkennis vereist.

Resultaat

Na het afronden van deze training ben jij bekend met de verscheidene mogelijkheden van Power BI voor inzichtelijke gegevensanalyse, datavisualisatie en de Power BI Service. Daarnaast heb je kennis vergaard over het gebruik van kunstmatige intelligentie en Power BI.

Positieve reacties van cursisten

Training: Leidinggeven aan de AI transformatie

Nuttige training. Het bestelproces verliep vlot, ik kon direct beginnen.

- Mike van Manen

Onbeperkt Leren Abonnement

Onbeperkt Leren aangeschaft omdat je veel waar voor je geld krijgt. Ik gebruik het nog maar kort, maar eerste indruk is goed.

- Floor van Dijk

Training: Leidinggeven aan de AI transformatie

Al jaren is icttrainingen.nl onze trouwe partner op het gebied van kennisontwikkeling voor onze IT-ers. Wij zijn blij dat wij door het platform van icttrainingen.nl maatwerk en een groot aanbod aan opleidingen kunnen bieden aan ons personeel.

- Loranne, Teamlead bij Inwork

Hoe gaat het te werk?

1

Training bestellen

Nadat je de training hebt besteld krijg je bevestiging per e-mail.

2

Toegang leerplatform

In de e-mail staat een link waarmee je toegang krijgt tot ons leerplatform.

3

Direct beginnen

Je kunt direct van start. Studeer vanaf nu waar en wanneer jij wilt.

4

Training afronden

Rond de training succesvol af en ontvang van ons een certificaat!

Veelgestelde vragen

Veelgestelde vragen

Op welke manieren kan ik betalen?

Je kunt bij ons betalen met iDEAL, PayPal, Creditcard, Bancontact en op factuur. Betaal je op factuur, dan kun je met de training starten zodra de betaling binnen is.

Hoe lang heb ik toegang tot de training?

Dit verschilt per training, maar meestal 180 dagen. Je kunt dit vinden onder het kopje ‘Kenmerken’.

Waar kan ik terecht als ik vragen heb?

Je kunt onze Learning & Development collega’s tijdens kantoortijden altijd bereiken via support@icttrainingen.nl of telefonisch via 026-8402941.

Background Frame
Background Frame

Onbeperkt leren

Met ons Unlimited concept kun je onbeperkt gebruikmaken van de trainingen op de website voor een vast bedrag per maand.

Bekijk de voordelen

Heb je nog twijfels?

Of gewoon een vraag over de training? Blijf er vooral niet mee zitten. We helpen je graag verder. Daar zijn we voor!

Contactopties