Share E-Book
Scan to open this page

Scan with your phone to open this page

Author: Nisal Mihiranga

Creating data models has never been straightforward. This book demonstrates how to formulate a complete business analytics model that combines several data sources, executes numerous computations, and scales across hundreds of BI users. To begin, you'll learn about the Microsoft Power BI ecosystem by downloading the Power BI desktop and exploring all of its features and capabilities. Through examples, you'll learn how to connect to databases of Excel; and SQL Server, shaping the data with Power Query, and then transforming the data into actionable information. You will gain knowledge of the DAX language by exploring it, writing DAX functions, and creating hierarchies. You will be trained to develop effective business intelligence models by studying numerous data modeling topics. You get to put professionals' best practices to the test when handling large data scenarios and executing analytics on top of them. Additionally, the book discusses how to scale Power BI while considering its storage, memory, and security requirements. You'll see that several new topics have been included, including performance tuning, DAX Studio, sharing Power BI reports, and publishing reports to Sharepoint online.

AI Reading Assistant

Whole-book reading guide from stratified index samples; jump to passages in the text

Brief outline
【One-Line Pitch】 Creating data models has never been straightforward. This book demonstrates how to formulate a complete business anal… 【Book Arc】 - **Opening (~0%–12%)**: Through examples, you'll learn how to connect to databases of Excel;; icles, sign up for a range of free newsletters, and receive exclusive discounts and offers on BPB books and eBooks. - **Early (~12%–35%)**: igh-level understanding of the features.; ance Analyzer: This is a new feature added to the Microsoft Power BI with May 2019 Update. - **Middle (~35%–65%)**: So, let us rename it as UK Sales.; g concepts, which is key to the self-service BI. - **Late (~65%–88%)**: When the growth of the complexity of the data models and the calculations, maintainability is something we need to worry about.; Also, we discussed how to use Tabular Editor, which is a free tool to make our development work easier. - **Ending (~88%–100%)**: which will be useful to join with the ProductCategory table.; Sometimes, we just need a subset of data rather entire data set from the source. 【Key Takeaways】 - **Through examples** (Opening): Through examples, you'll learn how to connect to databases of Excel; - **icles, sign up for a r…** (Opening): icles, sign up for a range of free newsletters, and receive exclusive discounts and offers on BPB books and eBooks. - **Microsoft has integrat…** (Opening): Microsoft has integrated many machine learning components with Power BI. - **igh-level understandin…** (Early): igh-level understanding of the features. - **ance Analyzer** (Early): ance Analyzer: This is a new feature added to the Microsoft Power BI with May 2019 Update. - **Now it is time to get…** (Early): Now it is time to get your hands dirty. 【Reading Tips】 - Use Passage locations below to jump into the text and set reading anchors - If this is a brief outline, click Regenerate (top right) for a synthesized guide 【Coverage Limits】 Compressed outline without the model (~26 index chunks). Full structured guide needs AI available.
Excerpt 1
icles, sign up for a range of free newsletters, and receive exclusive discounts and offers on BPB books and eBooks. Structure Objective Calculation groups re...
View in text
Excerpt 2
ance Analyzer: This is a new feature added to the Microsoft Power BI with May 2019 Update. This enables you to trace time information for DAX queries and vis...
View in text
Excerpt 3
er window you can do various transformations for your data. Power Query is the Microsoft data connectivity, and data preparation technology that allows busin...
View in text
Excerpt 4
eries, to enable profiling to your customer query: Figure 7.3: Transform data using Power Query and data profiling Just like in Excel, the bottom status bar...
View in text
Excerpt 5
nged to a hierarchy symbol: Figure 9.15: Calendar hierarchy Following the same pattern, you can add a month and date and create the hierarchy. In the end, yo...
View in text
Excerpt 6
Edit queries, you can find the Run R script and Run Python script option in the Transform tab (figure 13.24): makes sense anyway with the limitations of a fr...
View in text
Excerpt 7
which will be useful to join with the ProductCategory table. Please refer to figure 16.11: Figure 16.11: Expand the columns In the same way, you can join the...
View in text
Excerpt 8
75 business key 76 dimension attributes 76 surrogate key 75 DirectQuery connection type 35-39 workspace creating 267-269 roles 270
View in text
Tags
AI categories
SQL
ISBN: 9389328837
Publisher: BPB Publications
Publish Year: 2022
Language: English
Pages: 354
File Format: PDF
File Size: 18.2 MB
Text Preview (First 20 pages)
Registered users can read the full content for free

Register as a Gaohf Library member to read the complete e-book online for free and enjoy a better reading experience.

Generating text preview…