Microsoft Power BI - Data Analysis
Power BI is part of Microsoft's Power Platform products, that 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 make possible forecasts.
Duration: 1 Day
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 opportunites that the current business environment provides.
Prerequisites:
Power Bi requires that the student have a strong background in Excel functions, formulas, filters, and Pivot Tables. Having used teh Power Query Add-On for Excel would also be beneficial but not required. Having problem soolving 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/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/Dashboards
- Interactive Visualizations
- Hierarchies
- Filters and Slicers
- Drill Through Filters
- Publishing to the Power BI Web App
- Using Workspaces
- Power BI Mobile App