Microsoft Power BI cookbook : creating business intelligence solutions of analytical data models, reports, and dashboards /
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, UK :
Packt Publishing,
2017.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
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