Aspire Journeys
Mastering Power BI
- 20 Courses | 24h 53m 30s
Embark on a transformative journey through the world of Power BI with our comprehensive training program. Over four tracks, participants will master the essentials of data loading, visualization, and report creation in Power BI Desktop, before delving into the collaborative Power BI Service and the robust capabilities of Power Query. The exploration extends into advanced topics, covering administration, security, real-time data, and performance optimization. Finally, participants will immerse themselves in the cutting-edge realm of Power BI Artificial Intelligence, gaining expertise in generating data insights, building machine learning models, and utilizing specialized AI charts. This holistic journey ensures 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.
Track 1: From Data Loading to Stunning Visualizations
Embark on a comprehensive journey through the core fundamentals of Power BI with the "Data Loading and Visualization" track. This track begins with an exploration of the Power BI Desktop, covering installation procedures and providing an overview of its functionalities. Participants will delve into creating impactful reports within Power BI Desktop, mastering basic visualizations such as tables, charts, and maps. As the journey progresses, the focus shifts to advanced aspects of data modeling, introducing calculated columns, measures, relationships, and hierarchies for a nuanced understanding of data manipulation. The track navigates through diverse data sources, including Excel, SQL Server, and web-based and cloud-based data, equipping participants with versatile skills. Elevating the visualization game, participants will explore advanced techniques such as Sankey diagrams, Gantt charts, custom visualizations, and the incorporation of images and shapes, ensuring a well-rounded expertise in leveraging Power BI for insightful data representation.
- 6 Courses | 7h 18m 11s
Track 2: Mastering Power BI Service and Power Query
Delve into the collaborative and transformative capabilities of Power BI with the "Power BI Service and Power Query" track. This journey begins with a comprehensive overview of the Power BI service, emphasizing sharing, collaboration, and the deployment of reports to the cloud. Participants will explore the intricacies of creating dynamic dashboards within the Power BI service, mastering the art of building dashboards, adding tiles, and incorporating drill-throughs and drill-downs. The track then shifts focus to Power Query, empowering participants with the skills to transform and clean data efficiently, merge and combine datasets seamlessly, and pivot and unpivot data for enhanced analytics. As the journey unfolds, participants will gain insights into creating dashboards and reports tailored for mobile devices, optimizing the Power BI experience on the go. Throughout the track, an emphasis on sharing workspaces, monitoring usage metrics, and managing mobile content ensures a comprehensive understanding of the collaborative and mobile facets of Power BI.
- 6 Courses | 8h 15m 30s
Track 3: Advanced Strategies for Administration, Security, and Performance
Embark on an intensive exploration of advanced Power BI functionalities with the "Advanced Topics in Power BI" track. This track begins by unraveling the intricacies of administration and security, covering roles, access management, data gateways, data protection, and data loss prevention. Participants will gain mastery over implementing row-level and object-level security, ensuring a robust and controlled data environment. The journey then shifts gears into the realm of real-time data and performance optimization, guiding participants on connecting to streaming data sources and leveraging automatic refresh and alerting mechanisms. The track delves deep into the art of optimizing report and dashboard performance through techniques such as caching and minimizing data transfers, equipping participants with the skills to ensure a seamless and responsive Power BI experience. Throughout this advanced track, a focus on cutting-edge topics elevates participants' proficiency, making them adept in handling the complexities of Power BI administration, security, and performance optimization.
- 3 Courses | 2h 39m 7s
Track 4: Empowering Your Data Insights: Unleashing AI in Power BI
Embark on an immersive journey into the realm of artificial intelligence within Power BI with the "Power BI Artificial Intelligence" track. This exploration encompasses various facets of AI, starting with the ability to automatically generate data insights on datasets and visualize them on dashboards. Participants will learn to interpret fluctuations in visuals and discover distribution variations using AI insights. The track then transitions into the realm of machine learning, guiding participants through the process of creating and training machine learning models, assessing model performance, and integrating Azure Machine Learning models seamlessly into Power BI. Specialized charts designed for AI tasks, including anomaly detection, sentiment analysis, decomposition tree visuals, key influencers visualizations, and smart narrative summaries, offer participants a comprehensive toolkit. The journey concludes with a focus on natural language interaction, empowering participants to explore data seamlessly using Power BI Q&A and creating Q&A visuals within reports. This track ensures participants are well-versed in leveraging artificial intelligence to extract meaningful insights and drive informed decision-making within Power BI.
- 5 Courses | 6h 40m 42s
COURSES INCLUDED
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.
9 videos |
1h 4m
Assessment
Badge
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.
11 videos |
1h 12m
Assessment
Badge
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.
12 videos |
1h 28m
Assessment
Badge
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.
18 videos |
2h 1m
Assessment
Badge
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.
11 videos |
1h 30m
Assessment
Badge
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.
1 video |
32s
Assessment
Badge
COURSES INCLUDED
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.
14 videos |
1h 56m
Assessment
Badge
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.
14 videos |
1h 24m
Assessment
Badge
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.
18 videos |
2h
Assessment
Badge
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.
15 videos |
1h 59m
Assessment
Badge
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.
7 videos |
53m
Assessment
Badge
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.
1 video |
32s
Assessment
Badge
COURSES INCLUDED
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.
7 videos |
44m
Assessment
Badge
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.
15 videos |
1h 54m
Assessment
Badge
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.
1 video |
32s
Assessment
Badge
COURSES INCLUDED
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.
15 videos |
2h 14m
Assessment
Badge
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.
12 videos |
1h 43m
Assessment
Badge
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.
11 videos |
1h 24m
Assessment
Badge
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.
10 videos |
1h 18m
Assessment
Badge
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.
1 video |
32s
Assessment
Badge
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE TRACKS
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
