Microsoft Books & Video Guides

The Complete Guide to Power BI
for Data Analysts | LinkedIn Learning

In this course, learn ways to import data from various sources, as well as how to transform and cleanse data prior to loading it to a report-ready, self-service-enabled data model. Create visualizations in the Power BI Desktop and then secure, share, and collaborate using various features in the Power BI service. Build good habits and develop in your career as a business analyst or data-driven business user. Microsoft Certified Trainer Chris Sorensen explains the core concepts of Power BI to expose you to the most widely used features and functions in Power BI. 

Whether you are new to analytics or have been preparing and delivering data using legacy BI tools, this course shows you how to use Microsoft Power BI with confidence.

This course was created by Microsoft Press. 

Exam PL-300 Microsoft Power BI
Data Analyst

Prepare for Microsoft Exam PL-300 and demonstrate your mastery of Power BI data analysis.

This Exam PL-300 Microsoft Power BI Data Analyst video is designed for data analysts responsible for designing scalable data models, cleaning and transforming data, and presenting analytic insights through data visualizations using Power BI. This video focuses on the skills measured by the exam objectives, as updated by Microsoft on February 28, 2022:

  • Prepare the data
  • Model the data
  • Visualize and analyze the data
  • Deploy and maintain assets

Exam DP-900 Microsoft Azure Data Fundamentals

Prepare for Microsoft Exam DP-900 and demonstrate your knowledge of fundamental data concepts and Microsoft Azure data services.

Description

This Exam DP-900: Microsoft Azure Data Fundamentals video is designed to help you begin to work with data in the cloud. This video focuses on the skills measured by the exam objectives, as updated by Microsoft in April 2021.

  • Describe core data concepts
  • Describe how to work with relational data on Azure
  • Describe how to work with non-relational data on Azure
  • Describe an analytics workload on Azure

Introduction to Microsoft Power BI

Discover how Power BI will help your organization to become more data-driven. 

Learn ways to import data, transform, and cleanse data before loading it to a report-ready, self-service-enabled data model. Create visualizations in the Power BI Desktop and then secure, share, and collaborate using Power BI Service.

Using his years of experience teaching Power BI, Microsoft Certified Trainer Chris Sorensen explains the core concepts of Power BI to expose you to the features and functions in the tool. He carefully explains the why not just the how using real-world scenarios. Chris gives you the confidence to navigate and build Power BI solutions quickly and effectively. Build good habits and develop in your career as a business analyst or data-driven business user.

Data Analysis Fundamentals with Excel

This video course takes you the business user, business analyst, or data analyst through an end-to-end solution for collecting, cleaning, importing, managing, and sharing data for operational and reporting purposes using Excel.

A story-based approach is used to teach you the data and analytics lifecycle. Learn the how and why behind the options available to you in Excel. These best practices go beyond just tips and tricks; learn pros and cons of the techniques to make you a more proficient analyst.

Instructors Chris Sorensen and Ammul Shergill have decades of experience helping companies and business professionals get the most out of their data. Together, Chris and Ammul will be your guides as you learn the fundamentals of data analysis with Excel and gain skills to design, build, and share Excel solutions.

Analyzing and Visualizing Data with Microsoft Excel

Prepare for Microsoft Exam 70-779–and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.

 Focus on the expertise measured by these objectives: 

  • Consume and transform data by using Microsoft Excel.
  • Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies.
  • Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI.

Let's get started with a consultation

get started with training