Автор: Hutchinson Jeff Название: Microsoft Power BI Desktop - Creating Visual Reports ISBN: 108158890X ISBN-13(EAN): 9781081588908 Издательство: Неизвестно Цена: 11440.00 T Наличие на складе: Невозможна поставка. Описание: In this workbook/guide, we will cover in detail the Power BI Desktop features (installed on your local computer) that can be used to create a Dashboard of different Visual Reports describing related tables. We will take students through a step-by-step process, concerning the capabilities including the following:
Power BI Tools - The workbook will cover the related tools and downloads including Power BI Desktop, Power BI Web Service, Power BI for Mobile, Power BI Publisher For Excel, Power BI Gateway, and Power BI Report Server.
Process Overview - Here, we will take you through the process from Getting Data, Query Editor, Data View, Relationships, Visual Reports, Formatting, Filtering, Publishing on the Web to creating a Dashboard.
Get Data - This will extract the data source from a database such as Excel, Access, etc.
Query Editor - This will allow you to review data extracted and filter or remove specific records prior to saving it to the Power BI file.
Data View - This will allow you to review structure of the data extracted and add additional fields as needed.
Relationships - This will allow multiple tables to be added and related to a data source in order to obtain an accurate result when different fields are used.
Visual Reports - This will generate different reports describing the data from different tables. These reports include Charts, Tables, Summary Information, Maps, etc.
Filter Report - Once you create a report, it can be filtered to display the desired information.
Format Report - Once you create a report, it can be formatted with any options available.
Publish Report - Once reports are complete, they can be Published to a web browser version of Power BI and shared with others on the internet.
Create A Dashboard - Once reports are Published, they can be organized into a Dashboard layout for others to preview.
************************************************************************************************************************** This workbook supports the September 2019 Update What's is in the workbook?
Video Clips - The Kindle version includes video clips for each practice exercise. You can request the Videos with your paperback book Amazon receipt.
Take A Class - When you take a class using the workbook, you will be able to ask questions and gain a deeper understanding of many important concepts. http: //www.elearnlogic.com/courseware.html
Highly Requested Topics - The following are topics covered in the workbook: Automatically Find Clusters, Edit Interactions, Drill Down for more detail, New Hierarchy, Drill Through, Conditional Formatting, New Group, Visual Report Tab Order, New Filter Experience, New Modeling View, Query Editor, New Measure, Data Source Relationships, and the Publishing process.
Автор: Hutchinson Jeff L. Название: Microsoft Power BI Web And DAX Programming ISBN: 1728873835 ISBN-13(EAN): 9781728873831 Издательство: Неизвестно Цена: 11440.00 T Наличие на складе: Невозможна поставка. Описание: This workbook will cover the features of Power BI Web Service (Power BI Pro) which is a web-based tool that provides cloud services over the Internet to post and view Reports and Dashboards. Individual Visual Reports (Charts) are created using the Power BI Desktop tool which is installed on your local computer. Once you develop Visual Reports in Power BI Desktop, then you can publish these Visual Reports to build Dashboards in the Power BI Web Service. These tools work together to describe your data sources. The DAX program language is built into Power BI to customize information and create a unique result. DAX is similar to Excel formulas, but also has some SQL database elements. The following topics will be covered:
Overview - First, an overview of the interface and the menu system will be provided. This will enable users to switch between the different modules (described below) in order to develop a Dashboard. You can create an App which is a custom interface that contains a specific set of charts and graphs to communicate your message.
Dataset - This is used to store the uploaded database to the Power BI Web Service and we will demonstrate how to create new Visual Reports (Charts) from the Dataset. The Dataset can be automatically refreshed on a scheduled basis which will also update your Visual Reports and Dashboards.
Report Workspace - This will display the Visual Reports created in Power BI Desktop as well as those created from the Dataset in the Power BI Web Service tool. These include Clustered Column Charts, Pie Charts, Cards to display total values, Tables of Summarized data, Matrix reports, Maps, etc.
Dashboard - This is the layout of different types of Visual Reports arranged together to provide a message for readers. When you click on a Dashboard, it is linked to the Reports Workspace.
Edit Report - Additional elements can be added to Visual Reports such as Titles, Navigation Buttons, Shapes, and Filters.
Workbooks - This will allow you to upload an Excel Workbook into Power BI Web Service.
Settings - There are adjustments that can be made to the interface in order to provide additional functionality. You will be able to set Alerts when the data changes, Subscriptions will email screenshots of your Report or Dashboard page whenever the data changes, and an Automatic Refresh schedule can be set up 8 times a day.
DAX Formula Overview - This will explain the terms, basic structure, and common development techniques of DAX. Also included in the overview, is how to create New Columns in a table, custom calculations known as Measures, as well as New Tables.
DAX Reference - We will discuss in detail the unique characteristics of DAX that allows custom filtering as well as the ability to ignore applied filters. We will also cover different formula categories such as Math, Statistical, Filter, Date, Time, and Logical capabilities.
************************************************************************************************************************ What's is in the workbook
Video Clips - This Kindle version includes video clips for each practice exercise. You can request the Videos with your paperback book Amazon receipt.
Take a class - When you take a class using the workbook, you will be able to ask questions and gain a deeper understanding of many important concepts. http: //www.elearnlogic.com/courseware.html
Highly Requested Topics - The following are topics covered in the workbook: create a Dashboard, automatic Refresh, Alerts, Subscriptions, Filtering Reports, Sharing, creating a web link, exporting to Powerpoint and PDF.
