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
Tip the Site
Support this siteYour recognition and a small knowledge-service contribution help keep this technical work open source.Scan the WeChat Pay or Alipay code below. Logged-in and guest visitors can both tip.
WeChat Pay
Alipay
Open WeChat or Alipay and scan. No login required.
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...
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...
er window you can do various transformations for your data. Power Query is the Microsoft data connectivity, and data preparation technology that allows busin...
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...
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...
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...
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...
Support this siteYour recognition and a small knowledge-service contribution help keep this technical work open source.
Scan the WeChat Pay or Alipay code below. Logged-in and guest visitors can both tip.
WeChat PayAlipay
Open WeChat or Alipay and scan. No login required.
Add Tag
Enter tag name (max 50 characters)
Share E-Book
Power BI Data Modeling Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models (Nisal Mihiranga)(Z-Library)
Scan QR code with your phone to access
Copy the link or scan the QR code to access this e-book on your phone
Share E-Book via Email
Please enter email address
Donation Statistics
¥.00
Total Donations
0
Donation Count
Power BI Data Modeling Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models (Nisal Mihiranga)(Z-Library)
Find Your Favorite Books
Only registered users can comment after logging in. Comments need to be reviewed by administrators before being displayed
Loading comments...
Reply to Comment
Edit Comment