Course: Master Power BI
duration: 49 hours |
Language: English (US) |
access duration: 180 days |
Details
In this comprehensive course, you will delve into the world of Power BI. The course is divided into four chapters and you will start with ‘’Data Loading to Stunning Visualizations’’. This part will teach you basic report creation, advanced data modelling, diverse data source integration, and advanced visualization techniques like Sankey diagrams and Gantt charts. Move on to ‘’Power BI Service and Power Query’’, which covers Power BI service features like sharing, collaboration, and cloud deployment. In addition, you will learn to create dynamic dashboards, use Power Query for data transformation, and optimize reports for mobile devices.
In the ‘’Advanced Topics in Power BI’’ chapter you will learn about Power BI administration, security, performance optimization, access management, data gateways, and protection. You will also explore real-time data connections and performance enhancement techniques like caching. The final chapter ‘’Power BI Artificial Intelligence’’ covers AI's diverse aspects in Power BI, from auto-generating insights to machine learning model creation and integration. You will also learn specialized AI charts and natural language interaction for data exploration.
Result
After completing this course, you will have a well-rounded proficiency in harnessing Power BI's capabilities for insightful data representation, collaborative workspaces, advanced administration, and the integration of artificial intelligence for data-driven decision-making.
Prerequisites
No formal prerequisites.
Target audience
Data analist
Content
Master Power BI
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.
Course options
We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.
Optional practice exam (trial exam)
To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.
Optional practice lab
To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
WHY_ICTTRAININGEN
Via ons opleidingsconcept bespaar je tot 80% op trainingen
Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo
Spar met medecursisten en profileer je als autoriteit in je vakgebied.
Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl
Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers
Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten
Orderproces
Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.
read more about the order process
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
What is included?
Certificate of participation | Yes |
Monitor Progress | Yes |
Award Winning E-learning | Yes |
Mobile ready | Yes |
Sharing knowledge | Unlimited access to our IT professionals community |
Study advice | Our consultants are here for you to advice about your study career and options |
Study materials | Certified teachers with in depth knowledge about the subject. |
Service | World's best service |
Platform
Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.
FAQ
Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.