Analyzing Data with Power BI

MS SQL Server

Hands On Technology Transfer, Inc.
This course gives students a solid understanding of data analysis with Power BI. Topics include creating visualizations; connecting to Excel files; creating a Power BI dashboard; developing reports using the Power BI desktop App; using DAX syntax; accessing data in Azure SQL Data Warehouses; using the Power BI Mobile App and the Developer API.
This is primarily ilt training
book
workshop / seminarThis is a workshop seminar
computer labComputer Lab Work
group study and discussionThis class may involve group study
coursewareCourseware may be available for purchase
instructor led trainingThis class may be available at a classroom in Chelmsford, MA, or at one of these training facilities: Chelmsford, MA, Irving, TX, San Jose, CA, Schaumburg, IL, Altamonte Springs, FL, Houston, TX, Santa Ana, CA,
Course Level:basic
Duration:3 days
Training Presented in:English
Training Provided by Hands On Technology Transfer, Inc.
Analyzing Data with Power BI
Introduction to Self-Service BI Solutions
  • Introduction to Business Intelligence, Data Analysis and Data Visualization
  • Overview of Self-Service BI
  • Considerations for Self-Service BI
  • Microsoft Tools for Self-Service BI
  • Viewing Reports
  • Creating a Power BI Report
  • Creating a Power BI Dashboard
Introducing Power BI
  • Overview of Power BI
  • Components of the Power BI Service Including Licensing and Tenant Management
  • The Power BI Service
  • Connecting to Power BI Data
  • Creating a Power BI Dashboard
  • Developing Reports Using the Power BI Desktop App
Power BI
  • The Data Model and Optimizing Data Within the Model
  • Connecting to Excel Files and Importing Data
  • Viewing Reports from Excel Files
  • Using On-Premises and Cloud Microsoft SQL Server Databases as a Data Source
Shaping and Combining Data with Power BI
  • Performing a Range of Query Editing Skills in Power BI
  • Shaping Data, Using Formatting and Transformations
  • Combining Data Together from Tables in a Dataset
Modeling Data
  • Describing Relationships Between Data Tables
  • Understanding the DAX Syntax and Using DAX Functions to Enhance a Dataset
  • Creating Calculated Columns, Calculated Tables and Measures
Interactive Data Visualizations
  • Building Power BI Reports
  • Managing a Power BI Solution
  • Connecting to Power BI Data
  • Creating a Power BI Dashboard
  • Using Power BI Desktop to Create Interactive Data Visualizations
Direct Connectivity
  • Using Power BI Direct Connectivity to Access Data in Azure SQL Data Warehouses
  • Using Power BI Direct Connectivity to Access Data in Big Data Sources Such as Hadoop
  • Using Power BI with SQL Server Analysis Services Data
Developer API
  • Overview of the Developer API
  • Using Custom Visuals
Power BI Mobile App
  • Overview the Power BI Mobile App
  • Downloading and Using the Power BI Mobile App
  • Using Power BI Embedded
 
About The Training Provider: Hands On Technology Transfer, Inc.
Hands On Technology Transfer, Inc. - Hands On Technology Transfer, Inc. (HOTT) offers competency-based IT training programs in more than 75 cities across the United States, Canada and the United Kingdom, covering over 60 IT subject areas. These programs are designed with one main goal - making sure you and your staff will be competent and productive. Topics include .NET, SQL, Java, Mobile Programming, UNIX/ Linux, HTML5,...
Want to Sell More data warehouses training?
Custom Search
tcw11-v473M-12/11/17-18:41:04-()[B]-[B]-[B] -10:15:47