Data Analysis

Data analysis is part of Microsoft's Power Platform products, which allow users to analyze their data and gain foresight that can help them make sound, well-informed decisions for their organization. This usually involves software that specializes in the analysis of historical and current data and making possible forecasts.

Objectives:

Getting insights from your internal data that gets compared with industry data or competitor's data can provide much more powerful data analysis, which can help validate assumptions or opportunities that the current business environment provides.

Prerequisites:

Data analysis requires that the student have a strong background in Excel functions, formulas, filters, and pivot tables. Having used the Power Query Add-On for Excel would also be beneficial but not required. Having problem-solving skills and the ability to do complex calculations will be required, as this course requires being able to analyze large amounts of data.

This course requires that the student have the latest version of Power BI installed on their system.

Outline

• Data Analysis with Power BI

  • Defining BI, Data Analysis, and Visualization

  • Power Bi Desktop</li>

  • Excel vs Power BI

  • Power-Bi Interface

• Connecting to Your Data

  • Navigator Window

  • Importing vs Live Connection

  • Relationship Types

  • Cross Filter Direction

• Transforming Your Data

  • Data View to Transform

  • Power Query Editor

  • Close and Apply vs Saving

  • Advanced Editor and M Language

• Data Modeling with DAX

  • What is DAX?

  • Formula Bar

  • DAX Error Checking

  • Calculated Columns vs Measures

  • Table Unions

• Visualizations for Your Reports

  • Visualizations, Filters and Fields Pane

  • Types of Visuals

  • Microsoft Marketplace

  • Enhancing Your Reports and Dashboards

• Interactive Visualizations

  • Hierarchies

  • Filters and Slicers

  • Drill Through Filters

• Publishing to the Power BI Web App

  • Using Workspaces

  • Power BI Mobile App