Azure Data Fundamentals: Analytical Workloads

Azure 2024    |    Beginner
  • 9 videos | 47m 14s
  • Earns a Badge
Tools like Power BI, SQL Server Analysis Services (SAAS), and Azure Stream Analytics can significantly enhance decision-making through their robust data visualization capabilities, scalability, and the capacity to handle large datasets. In this course, learn how to connect Power BI Desktop to data sources for interactive analytics, how columnstore indexes in SQL Server improves query performance, and how SAAS can be used to build and deploy OLAP and data mining models. Next, explore the SAAS installation process and the different types of data analytics workloads for business intelligence. Finally, explore Azure Stream Analytics and how to create and configure Stream Analytics jobs for processing live data streams. This course is one of a collection that prepares learners for the DP-900: Microsoft Azure Data Fundamentals exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Outline how to connect power bi desktop to various data sources for interactive analytics
    Recognize how columnstore indexes in sql server work to improve query performance on large datasets
    Describe how sql server analysis services (saas) can be used to build and deploy online analytical processing (olap) and data mining models
    Outline the process of installing sql server analysis services (saas) to enable advanced data analytics capabilities
  • Recognize different types of data analytics workloads and their applications in business intelligence
    Describe azure stream analytics and its use in real-time data stream processing
    Create and configure stream analytics jobs for processing live data streams
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 30s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 6m 33s
    After completing this video, you will be able to outline how to connect Power BI Desktop to various data sources for interactive analytics. FREE ACCESS
  • Locked
    3.  SQL Server with Columnstore Indexes
    5m 47s
    Through this video, you will be able to recognize how columnstore indexes in SQL Server work to improve query performance on large datasets. FREE ACCESS
  • Locked
    4.  SQL Server Analysis Services (SAAS)
    5m
    Upon completion of this video, you will be able to describe how SQL Server Analysis Services (SAAS) can be used to build and deploy online analytical processing (OLAP) and data mining models. FREE ACCESS
  • Locked
    5.  SQL Server Analysis Services (SAAS) Installation
    6m 26s
    In this video, we will outline the process of installing SQL Server Analysis Services (SAAS) to enable advanced data analytics capabilities. FREE ACCESS
  • Locked
    6.  Data Analytics Workloads
    9m 46s
    Through this video, you will be able to recognize different types of data analytics workloads and their applications in business intelligence. FREE ACCESS
  • Locked
    7.  Azure Stream Analytics
    6m 3s
    After completing this video, you will be able to describe Azure Stream Analytics and its use in real-time data stream processing. FREE ACCESS
  • Locked
    8.  Creating Stream Analytics Jobs
    5m 5s
    Discover how to create and configure Stream Analytics jobs for processing live data streams. FREE ACCESS
  • Locked
    9.  Course Summary
    1m 5s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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.

YOU MIGHT ALSO LIKE

Rating 4.6 of 645 users Rating 4.6 of 645 users (645)
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)