Cargando…
Microsoft Power BI Cookbook.
Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all Over 90 hands-on, technical recipes, tips, and use cases from...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UNKNOWN :
Packt Publishing,
2017.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Title Page; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Customer Feedback; Table of Contents; Preface; Chapter 1: Configuring Power BI Development Tools; Introduction; Configuring Power BI Desktop options and settings; Getting ready; How to do it ... ; Installing and running Power BI Desktop; Configuring Power BI Desktop options; How it works ... ; There's more ... ; See also; Power BI's advantages over Excel; Power BI Security and Data Source Privacy; Installing the On-Premises Data Gateway; Getting ready; Hardware and network configuration.
- How to do it ... Installation of on-premises gateway; How it works ... ; Gateway recovery key; There's more ... ; See also ... ; Installing Power BI Publisher for Excel; How to do it ... ; Installation of Power BI Publisher for Excel; There's more ... ; Installing and Configuring DAX Studio; How to do it ... ; Installation of DAX Studio; Configuration of DAX Studio; How it works ... ; There's more ... ; Guy in a Cube video channel; Chapter 2: Accessing and Retrieving Data; Introduction; Viewing and analyzing M functions; Getting ready; How to do it ... ; Formula Bar; Advanced Editor window; How it works ...
- Query foldingM query structure; Lazy evaluation; There's more ... ; Partial query folding; Limitations of query folding; See also ... ; M language references; Establishing and managing connections to data sources; Getting ready; How to do it ... ; Isolate data sources from individual queries; Query groups; Manage source credentials and privacy levels; How it works ... ; Data Source settings; Data source privacy settings; There's more ... ; See also; Building source queries for DirectQuery models; Getting ready; How to do it ... ; Applying M transformations with DirectQuery models; How it works ...
- There's more ... DirectQuery project candidates; DirectQuery performance; See also; Importing data to Power BI Desktop models; How to do it ... ; Denormalize a dimension; Provide automatic sorting; How it works ... ; There's more ... ; One GB dataset limit and Power BI Premium; See also; Applying multiple filtering conditions; Getting ready; How to do it ... ; Query filter example steps; How it works ... ; There's more ... ; Filtering via the Query Editor interface; See also; Choosing columns and column names; How to do it ... ; Identify expensive columns; Select columns; Rename columns; How it works ...
- Column memory usageThere's more ... ; Fact table column eliminations; Column orders; See also; Transforming and cleansing source data; Getting ready; How to do it ... ; Remove duplicates; Update a column through a join; There's more ... ; See also; Creating custom and conditional columns; How to do it ... ; Create a dynamic banding attribute; Create a formatted name column; Comparing the current and previous rows; How it works ... ; Conditional expression syntax; Case sensitivity; Conditional expression evaluation; Query folding of custom columns; There's more ... ; Add column from example.