Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863
This Data Analysis using Power BI Desktop course lays the foundation for Power BI Report Builders. Report Builders will learn everything they need to create highly effective stand-alone and multi-page narrative reports using data sources that are created using Power BI Desktop. This course covers the use of both the Power BI Desktop application as well as the Power BI Service.
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.
Power BI consists of:
Power BI Desktop is a complete data analysis and report creation tool that you install for free application on your local computer. It includes the Query Editor, in which you can connect to many different sources of data, and combine them (often called modeling) into a data model. Then you design a report based on that data model.
What Is Power BI for the Cloud Power BI Key Features Self-Service BI Model Power BI Components
What is a Power BI Report? Defining a Report Data-Driven Storytelling
Understanding the Design Interface Creating Reports Report Visualizations Formatting Visualizations Report Final Touches
Highlighting, Drill-down & Data Actions Visual Interactions Visual Sorting and Slicers Visual, Report, & Page Filters
Understanding Data Terminology Understanding Tables Understanding Relationships Diagnosing Data Models Data Model Schemas
Data Queries vs Data Models Viewing & Refreshing a Data Source Modifying Report Data
Creating Calculated Columns What is DAX? Basic DAX Functions Date Hierarchies
Power BI Service Interface Connecting to Data Sources Uploading & Updating PBIX Reports Refreshing Power BI Data Power BI Service Report Interface Components
Dashboard Interface Components Building Dashboards Organizing Dashboard Elements
Understanding Q & A Modifying Q & A Results Pinning Q & A results to a Dashboard
Sharing Content Managing Power BI Content Using App Workspaces Content Packs and Apps
Power BI Roles
General understanding of reporting requirements and a basic understanding of data base concepts is useful, but not required
The Data Analysis using Power BI Desktop Level 1 are for Business Analysis/User - responsible for creating Reports using Power BI Desktop.
2 Days Course