Microsoft Power BI Cookbook. (2017)

• Record Type: Book
• Other Names: Powell, Brett
• Contents: 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
• Publisher Details: Birmingham, UNKNOWN : Packt Publishing
• Publication Date: 2017
• Extent: 1 online resource (786)
• Subjects: 641.5; COMPUTERS -- Data Visualization; Business intelligence -- Computer programs; Information visualization -- Computer programs; Business -- Data processing; Visual analytics; COMPUTERS -- Enterprise Applications -- Business Intelligence Tools; COMPUTERS -- Enterprise Applications -- General; Electronic books
• Languages: English
• ISBNs: 1788293789; 9781788293785
• Related ISBNs: 1788290143
• Notes: Note: Description based on print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.