skip to content
Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence. Preview this item
ClosePreview this item
Checking...

Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence.

Author: Brett Powell
Publisher: Birmingham : Packt Publishing, 2018.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
This book will show you how to use Power BI effectively to create a variety of visualizations and BI dashboards. Right from gathering data through various data sources, you will learn to perform effective visual analytics. By the end of this book, you will be able to gain unique, hidden insights into your data using Microsoft Power BI.
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Powell, Brett.
Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence.
Birmingham : Packt Publishing, ©2018
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Brett Powell
ISBN: 9781788292283 1788292286 1788297237 9781788297233
OCLC Number: 1030820144
Notes: DAX variables.
Description: 1 online resource (632 pages)
Contents: Cover; Title Page; Copyright and Credits; Dedication; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: Planning Power BI Projects; Power BI deployment modes; Corporate BI; Self-Service Visualization; Self-Service BI; Choosing a deployment mode; Project discovery and ingestion; Sample Power BI project template ; Sample template --
Adventure Works BI; Power BI project roles; Dataset designer; Report authors; Power BI admin; Project role collaboration; Power BI licenses; Power BI license scenarios; Power BI Premium features; Data warehouse bus matrix; Dataset design process. Selecting the business processDeclaring the grain; Identifying the dimensions; Defining the facts; Data profiling; Dataset planning; Data transformations; Import versus DirectQuery; Import mode ; DirectQuery mode; Sample project analysis; Summary; Chapter 2: Connecting to Sources and Transforming Data with M; Query design per dataset mode; Import mode dataset queries; DirectQuery dataset queries; Data sources; Authentication; Data source settings; Privacy levels; Power BI as a data source; Power BI Desktop options; Global options; CURRENT FILE options; SQL views; SQL views versus M queries. SQL view examplesDate dimension view; Mark As Date Table; Product Dimension view; Slowly-changing dimensions; M queries; Data Source Parameters; Staging Queries; DirectQuery staging; Fact and dimension queries; Source Reference Only; M query summary; Excel workbook --
Annual Sales Plan; Data types; Item access in M; DirectQuery report execution; Bridge Tables Queries; Parameter Tables; Security Tables; Query folding; Partial query folding; M Query examples; Trailing three years filter; Customer history column; Derived column data types; Product dimension integration; R script transformation. M editing toolsAdvanced Editor; Visual Studio Code; Visual Studio; Summary; Chapter 3: Designing Import and DirectQuery Data Models; Dataset layers; Dataset objectives; Competing objectives; External factors; The Data Model ; The Relationships View; The Data View; The Report View; Fact tables; Fact table columns; Fact column data types; Fact-to-dimension relationships; Dimension tables; Hierarchies; Custom sort; Bridge tables; Parameter tables; Measure groups; Last refreshed date; Measure support logic; Relationships; Uniqueness ; Ambiguity; Single-direction relationships; Direct flights only. Bidirectional relationshipsShared dimensions; Date dimensions ; The CROSSFILTER function; Model metadata; Visibility; Column metadata; Default Summarization; Data format; Data category; Field descriptions; Optimizing performance; Import; Columnar compression; Memory analysis via DMVs; DirectQuery ; Optimized DAX functions; Columnstore and HTAP; Summary; Chapter 4: Developing DAX Measures and Security Roles; DAX measures; Filter context; SQL equivalent; Measure evaluation process; Row context; Scalar and table functions; The CALCULATE() function; Related tables; The FILTER() function.

Abstract:

This book will show you how to use Power BI effectively to create a variety of visualizations and BI dashboards. Right from gathering data through various data sources, you will learn to perform  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/1030820144> # Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence.
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
    library:oclcnum "1030820144" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/4498738317#Place/birmingham> ; # Birmingham
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'https://img1.od-cdn.com/ImageType-100/6135-1/{763A5FB9-1C68-44DF-B01D-20778635E574}Img100.jpg'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/4498738317#Topic/reference_questions_&_answers> ; # REFERENCE--Questions & Answers
    schema:about <http://experiment.worldcat.org/entity/work/data/4498738317#Topic/computers_enterprise_applications_business_intelligence_tools> ; # Computers--Enterprise Applications--Business Intelligence Tools
    schema:about <http://experiment.worldcat.org/entity/work/data/4498738317#Topic/operational_research> ; # Operational research
    schema:about <http://experiment.worldcat.org/entity/work/data/4498738317#Topic/computers_enterprise_applications_general> ; # Computers--Enterprise Applications--General
    schema:about <http://experiment.worldcat.org/entity/work/data/4498738317#Topic/enterprise_software> ; # Enterprise software
    schema:about <http://dewey.info/class/001.4226/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/4498738317#Topic/information_visualization> ; # Information visualization
    schema:bookFormat schema:EBook ;
    schema:creator <http://experiment.worldcat.org/entity/work/data/4498738317#Person/powell_brett> ; # Brett Powell
    schema:datePublished "2018" ;
    schema:description "Cover; Title Page; Copyright and Credits; Dedication; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: Planning Power BI Projects; Power BI deployment modes; Corporate BI; Self-Service Visualization; Self-Service BI; Choosing a deployment mode; Project discovery and ingestion; Sample Power BI project template ; Sample template -- Adventure Works BI; Power BI project roles; Dataset designer; Report authors; Power BI admin; Project role collaboration; Power BI licenses; Power BI license scenarios; Power BI Premium features; Data warehouse bus matrix; Dataset design process."@en ;
    schema:description "This book will show you how to use Power BI effectively to create a variety of visualizations and BI dashboards. Right from gathering data through various data sources, you will learn to perform effective visual analytics. By the end of this book, you will be able to gain unique, hidden insights into your data using Microsoft Power BI."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/4498738317> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/4498738317#CreativeWork/mastering_microsoft_power_bi_expert_techniques_for_effective_data_analytics_and_business_intelligence> ;
    schema:name "Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence."@en ;
    schema:productID "1030820144" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/1030820144#PublicationEvent/birmingham_packt_publishing_2018> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/4498738317#Agent/packt_publishing> ; # Packt Publishing
    schema:url <https://samples.overdrive.com/?crid=763a5fb9-1c68-44df-b01d-20778635e574&.epub-sample.overdrive.com> ;
    schema:url <https://ebookcentral.proquest.com/lib/liverpool/detail.action?docID=5332131> ;
    schema:url "https://img1.od-cdn.com/ImageType-100/6135-1/{763A5FB9-1C68-44DF-B01D-20778635E574}Img100.jpg" ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=5332131> ;
    schema:url <https://proquest.safaribooksonline.com/9781788297233> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=1775076> ;
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=5332131> ;
    schema:url <http://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781788292283> ;
    schema:url <https://www.overdrive.com/search?q=763A5FB9-1C68-44DF-B01D-20778635E574> ;
    schema:url <http://ra.ocls.ca/ra/login.aspx?inst=conestoga&url=http://proquest.safaribooksonline.com/9781788297233> ;
    schema:workExample <http://worldcat.org/isbn/9781788297233> ;
    schema:workExample <http://worldcat.org/isbn/9781788292283> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/1030820144> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/4498738317#Agent/packt_publishing> # Packt Publishing
    a bgn:Agent ;
    schema:name "Packt Publishing" ;
    .

<http://experiment.worldcat.org/entity/work/data/4498738317#Person/powell_brett> # Brett Powell
    a schema:Person ;
    schema:familyName "Powell" ;
    schema:givenName "Brett" ;
    schema:name "Brett Powell" ;
    .

<http://experiment.worldcat.org/entity/work/data/4498738317#Topic/computers_enterprise_applications_business_intelligence_tools> # Computers--Enterprise Applications--Business Intelligence Tools
    a schema:Intangible ;
    schema:name "Computers--Enterprise Applications--Business Intelligence Tools"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/4498738317#Topic/computers_enterprise_applications_general> # Computers--Enterprise Applications--General
    a schema:Intangible ;
    schema:name "Computers--Enterprise Applications--General"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/4498738317#Topic/enterprise_software> # Enterprise software
    a schema:Intangible ;
    schema:name "Enterprise software"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/4498738317#Topic/information_visualization> # Information visualization
    a schema:Intangible ;
    schema:name "Information visualization"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/4498738317#Topic/operational_research> # Operational research
    a schema:Intangible ;
    schema:name "Operational research"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/4498738317#Topic/reference_questions_&_answers> # REFERENCE--Questions & Answers
    a schema:Intangible ;
    schema:name "REFERENCE--Questions & Answers"@en ;
    .

<http://ra.ocls.ca/ra/login.aspx?inst=conestoga&url=http://proquest.safaribooksonline.com/9781788297233>
    rdfs:comment "5 simultaneous users allowed through Safari Technical Books" ;
    .

<http://worldcat.org/entity/work/data/4498738317#CreativeWork/mastering_microsoft_power_bi_expert_techniques_for_effective_data_analytics_and_business_intelligence>
    a schema:CreativeWork ;
    rdfs:label "Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/1030820144> ; # Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence.
    .

<http://worldcat.org/isbn/9781788292283>
    a schema:ProductModel ;
    schema:isbn "1788292286" ;
    schema:isbn "9781788292283" ;
    .

<http://worldcat.org/isbn/9781788297233>
    a schema:ProductModel ;
    schema:isbn "1788297237" ;
    schema:isbn "9781788297233" ;
    .

<http://www.worldcat.org/title/-/oclc/1030820144>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/1030820144> ; # Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence.
    schema:dateModified "2019-05-11" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.