Resources
Welcome to the Resources page, your gateway to mastering data engineering and business intelligence. Here, you’ll find a curated list of Pluralsight courses designed by our experts to help you build skills in tools like SQL Server, Power BI, and more. Whether you’re a beginner looking to learn the basics or an experienced professional seeking advanced techniques, these courses provide comprehensive guidance to help you succeed in the ever-evolving world of data. Dive in and start your learning journey today!
Data Import and Wrangling with R
Working with messy, scattered data can feel overwhelming and frustrating, especially when you’re trying to uncover meaningful insights. Without the right skills to organize and clean data, even simple tasks can become time-consuming and complicated. In this course, Data Import and Wrangling with R, you’ll gain the ability to import, clean, and combine datasets to prepare them for insightful analysis. First, you’ll explore how to import data from various sources, including local files, web URLs, and databases, while resolving common issues like missing values and inconsistent formats. Next, you’ll discover how to transform and tidy messy data using R packages like tidyr and dplyr. Finally, you’ll learn how to merge and combine datasets effectively, addressing challenges like duplicate entries and mismatched keys to create unified datasets for analysis. When you’re finished with this course, you’ll have the skills and knowledge of data import and wrangling in R needed to handle real-world data challenges and prepare datasets for meaningful analysis.
Deploy Power BI Reports On-premises with Power BI Report Server
Deploying Power BI reports on-premises can be challenging for organizations that need to maintain data control and comply with strict regulations. In this course, Deploy Power BI Reports On-premises with Power BI Report Server, you’ll learn how to set up, publish, and manage Power BI reports using Power BI Report Server, ensuring your data remains secure within your infrastructure. First, you’ll learn the use cases for Power BI Report Server. Next, you’ll see how to create reports in Power BI Desktop. Finally, you’ll be guided through the publishing process. When you’re finished with this course, you’ll have a better understanding of how to deploy, manage, and secure Power BI reports in an on-premises environment using Power BI Report Server.
Build Power BI Reports
In today’s data-driven world, the ability to create clear and insightful reports is crucial for effective decision-making. Many data analysts struggle with transforming raw data into meaningful visuals that drive business outcomes. In this course, Build Power BI Reports, you’ll gain the ability to create professional and interactive Power BI reports that effectively communicate your data insights. First, you’ll explore how to navigate the Power BI report interface, add and organize visuals on the report canvas, and use the Fields pane to incorporate data into your visuals. Next, you’ll discover how to create and customize report visuals, including configuring bar charts, line charts, and pie charts, as well as customizing visual properties such as colors, labels, and titles. Finally, you’ll learn how to apply filters and slicers to your reports, add and format KPIs and cards for key metrics, and incorporate additional elements like text boxes, images, and buttons for enhanced navigation and actions. You will also cover how to publish and share reports using Power BI Service, manage permissions, and schedule data refreshes. When you’re finished with this course, you’ll have the skills and knowledge of Power BI needed to build compelling and actionable reports that can be shared with stakeholders, improving your data analysis and presentation capabilities.
Identifying Opportunities for Generative AI in Your Organization
In today’s rapidly evolving technological landscape, generative AI offers transformative potential for businesses. This course will solve the problem of identifying and effectively implementing generative AI opportunities in a company, helping businesses leverage AI to enhance efficiency, and achieve strategic objectives. In this course, Identifying Opportunities for Generative AI in Your Organization, you’ll learn to strategically identify, evaluate, and implement generative AI opportunities within a business First, you’ll conduct a needs assessment to determine areas for AI. Next, you’ll evaluate current processes and workflows that can benefit from AI within an organization. Finally, you’ll learn how to evaluate the feasibility and impact of AI projects. When you’re finished with this course, you’ll have the skills and knowledge of creating a detailed plan needed to implement generative AI opportunities in your company.
Applying SQL Server 2016 Features to Real-world Data Problems
Along with the release of SQL Server 2016 comes some amazing new functionality that will help enhance the performance of your solution, improve security, integrate and analyze data from all types of sources, and scale your solution to the cloud. In this course, Applying SQL Server 2016 Features to Real-world Data Problems, you’ll be able to apply these functionalities to any real-world data problem you may have. First, you’ll learn about improving the performance database solution by using in-memory OLTP enhancements, query data store, temporal database, and JSON support. Next, you’ll learn how to enhance security at a database level using AlwaysEncrypted, dynamic data masking, and row level security. Finally you’ll learn how to head towards the cloud and how HappyScoopers can easily adapt their existent solution to use the powers of the cloud. By the end of this course, you’ll have a strong foundational understanding on how to apply the amazing new features of SQL Server 2016 to solve your own real world problems.
Mastering ETL: Data Cleansing with SQL Server Integration Services
Data cleansing is a major part of every project that uses data to create information. In this course, Mastering ETL: Data Cleansing Techniques for SQL Server Databases, you’ll gain the ability to create SQL Server Integration Services (SSIS) packages specifically tailored for data cleansing tasks. First, you’ll explore how to integrate data coming from different sources and identify possible data cleansing tasks, like handling duplicate data, dealing with missing values (delete, ignore, or fill-in data), fixing up formats, and correcting errors. Next, you’ll discover several ways in which SSIS packages can help you clean your data, using derived columns, fuzzy grouping / fuzzy lookup, and data conversions. Finally, you’ll learn techniques to maintain and verify data integrity after the cleansing process in SSIS. When you’re finished with this course, you’ll have the skills and knowledge of various data cleansing techniques, performed in SSIS, needed to ensure the integrity of your data.
Designing a Data Warehouse on the Microsoft SQL Server Platform
Data is driving everything and the need to gain insight from data continues to become more abundant. In this course, Designing a Data Warehouse on the Microsoft SQL Server Platform, you’ll gain the ability to design and implement a data warehouse solution with the components provided by SQL Server. First, you’ll discover some of the characteristics of a data warehouse project and how such a project can help your customers to have a better understanding of their business progression. Next, you’ll explore the dimensional modeling design and will learn about each step in this system in more detail. Then, you’ll delve into creating a data warehouse database and building an SSIS project to load the data warehouse with information essential for data analysis. Finally, you’ll learn how to create meaningful reports on top of the solution previously created. When you’re finished with this course, you’ll have the skills and knowledge of designing a robust data warehouse on the SQL Server platform needed to create an effective solution that helps your customers by gaining insights from the data accumulated.
Work with Dynamic Data Patterns in SQL Server
A useful functionality in SQL Server is the ability to perform calculations on a subset of table rows related to the current row. In this course, Work with Dynamic Data Patterns in SQL Server, you’ll gain the ability to partition your data in order to gain valuable insights without writing difficult queries. First, you’ll discover what window functions are. Next, you’ll explore some real-life scenarios where using window functions in your queries comes in handy. Finally, you’ll learn how to use different window functions in several scenarios, like calculating running totals and rolling averages, as well as examining benchmarks for comparison. When you’re finished with this course, you’ll have the skills and knowledge of window functions needed to enhance your SQL queries’ efficiency.
Create and Monitor Data Pipelines for a Stream Processing Solution
Azure gives you all of the resources you need to create and monitor data pipelines and find the data processing solutions you need. In this course, Create and Monitor Data Pipelines for a Stream Processing Solution, you’ll learn how to work with stream processing pipelines in Azure in order to create, configure, monitor, and troubleshoot Azure Stream Analytics jobs. First, you’ll discover the components of a stream analytics job and why each of them are important. Next, you’ll explore how to handle the data coming from the pipeline (insert and update), how to visualize the data in different time windows, and how to troubleshoot such a job. Finally, you’ll learn how to improve the performance of your job, by choosing the number of streaming units, parallelizing the query, and using repartitioning to scale your query. By the end of this course, you’ll have a better understanding of what it means to create and monitor real-time data processing solutions in Azure.