Wilson Mar bio photo

Wilson Mar

Hello!

Email me Calendar Skype call

LinkedIn Twitter Gitter Instagram Youtube

Github Stackoverflow Pinterest

PowerBI

Make better decisions using data. Pass Microsoft’s PL-100 Query Editor, DAX, and Models

US (English)   Español (Spanish)   Français (French)   Deutsch (German)   Italiano   Português   Estonian   اَلْعَرَبِيَّةُ (Egypt Arabic)   中文 (简体) Chinese (Simplified)   日本語 Japanese   한국어 Korean

Overview

The contribution of this article is a deep yet succinct hands-on step-by-step tutorial which is logically sequenced, with “PROTIP” marking hard-won, little-know but significant facts available no where else on the internet.

NOTE: Content here are my personal opinions, and not intended to represent any employer (past or present). “PROTIP:” here highlight information I haven’t seen elsewhere on the internet because it is hard-won, little-know but significant facts based on my personal research and experience.

Competitors

Competitors in the data visualization market:

  • Wikipedia says Power BI was first released on July 24, 2015
  • Tableau> launched in 2003 (purchased by Salesforce June 10, 2019) $2000/user/year
  • Qlik
  • Knowi supports native connectivity with NoSQL databases, do analytics directly on unstructured data NLP. search-based analytics in Slack.

In Gartner’s “Magic Quadrant” for Data Visualization products, Microsoft has been at the top-right for over a decade: pbi-gartner-202102-1118x1114

Gartner’s analysis RPA vendors in 2021 has Microsoft leading all others in “strategy” but not in “execution”: az-iot-gartner2021-607x607

Showcase

VIDEO: World Population Health Analysis shows “Key Contributors” analysis

https://www.youtube.com/watch?v=l6NspVReKz0

VIDEO: Beautiful Dashboard from the VIDEO: Northwind database

Tailwind Traders is a more recent sample database.

Products

  1. Microsoft’s Power BI product marketing home page:

    powerbi.microsoft.com/en-us

    “PowerBI” refers to a set of products and services:

pbi-features-across-1024x732.jpg*

Install

To view all options for installation, see:
powerbi.microsoft.com/en-us/downloads

LinkedIn Learning: Apps using Power BI can be launched from the Office 365 portal.

”>

Mobile app

  1. On your mobile’s Store, search for “Power BI”.

  2. On your iPhone App Store app, click “Get” at

    https://apps.apple.com/us/app/microsoft-power-bi/id929738808

    On Android, click “Install” at

    https://play.google.com/store/apps/details?id=com.microsoft.powerbim

  3. Click “Get”

    powerbi-mobile-750x1163.png

    Logo branding

    That yellow “staircase” logo is the Power BI logo on all platforms.

    “Power” means Power BI is part of Microsoft’s Power Platform”. See docs.microsoft.com.

    • Power Automation
    • Power Apps
    • Power SharePoint
    • Power Financials

Free Desktop app in LEARN free

PROTIP: You don’t need to setup an account or install an app while learning because Microsoft provides a virtual Power BI Desktop environment with LEARN labs.

  1. Click a FREE LAB link (below)

  2. Click “Launch Lab”, then “Start lab” to pop up a window (with no menu controls).

  3. Optionally, to cast the screen to a TV, right-click anywhere on the screen and select “Cast…” and select a device.

  4. Click the blue “Download Lab Files to D:\ Drive”.

    REMEMBER: After 4 hours you start over with a blank instance.

    github.com/MicrosoftLearning/PL-300-Microsoft-Power-BI-Data-Analyst contains labs used during Microsoft’s 3-day class to prepare students for the $165 PL-300 exam:

    • Prepare the data
    • Model the data
    • Visualize and analyze the data
    • Deploy and maintain assets

    PL-300 takes the place of DA-100 class files.

    BOOK: DA-100 Exam Ref by Danììl Maslyuk

  5. Open and configure Power BI Desktop.

Desktop App

CAUTION: Microsoft has NOT created a PowerBI Desktop app for Apple MacOS. However, you can still run PowerBI for Windows on MacOS by using one of these options:

  • Install Windows on MacOS using Boot Camp
  • Dual boot
  • https://app.turbo.net/run/powerbi/powerbi
  • Install and run Power BI on a Virtual Machine (on AWS), then remote in to that Virtual Machine.
  • Install and run Power BI on a PC, then use a remote viewer to control that PC.

  1. Microsoft’s marketing web page:

    powerbi.microsoft.com/en-us/desktop

  2. Testers usually prefer to download an .msi file to install so they can control when to manually update it periodically.

    https://go.microsoft.com/fwlink/?LinkID=521662

    Alternately, end-users typically prefer for the program to automatically update itself by installing from the Windows Store:

    https://aka.ms/pbidesktopstore

  3. Dismiss the yellow “Getting started” pop-up of Social links (below).

  4. The menu at left:

    pbi-saas-menu-444x1070

    QUESTION: What are goals?

app.powerbi.com SaaS account

  1. Use Microsoft’s Edge browser here because that was used to test functionality for PowerBI. (Use another browser for documentation).

  2. PROTIP: Click the avatar on your browser to select the profile associated with the email account you want to use.

  3. Get a PowerBI SaaS account associated with your work account at:

    app.powerbi.com

    PROTIP: PowerBI.com does not accept personal (gmail) accounts.

  4. PROTIP: Add this to your bookmarks.

  5. Sign in to the Power BI service on Azure

    docs.microsoft.com/en-us/power-bi/consumer/end-user-sign-in

Pricing

DOCS: Levels of pricing (See comparison table):

  1. Power BI Pro is included in Microsoft 365 E5, or $9.99/month by itself for up to 1 GB/model

  2. Power BI Premium per user (PPU) $20/month/user of up to 100 GB/model

  3. Power BI Premium $4,995/Per capacity/month for autoscale of up to 400 GB/model, on-prem. Power BI Report Server. That’s a yearly commitment billed monthly.

PROTIP: It may seem counter-intuitive, but self-service BI users are given “Pro” licenses and “occasional users” are assigned Premium licenses for viewing BI content.

Total users # Pro Self-service # Premium Viewers
200 50 150
700 100 600
5,000 4,000 1,000

Premium means:*

  • Refresh of 48/day (vs. 8/day)
  • Max. 100 TB (vs. 10 GB/user)

  • unlimited data streaming (no 10K rows/hour limit)

  • Workspaces (assigned to a Premium Capacity)

  • Deploy PowerBI content to multiple regions
  • Gateway to On-prem. Power BI Report Server
  • Store Power BI data to Azure Data Lake Storage Gens
  • XMLA endpoint read/write connectivity

  • Dataflows (Direct Query, linked and computed entities, enhanced compute engine)

  • Paginated (RDL) reports
  • Advanced AI (text analytics, image detection, automated machine learning) - AutoML & Azure ML
  • Row-level security
  • Content Pack

What is a Premium “capacity” unit?

This is so complicated that it takes installing Microsoft’s PowerBI-Tools-For-Capacities app from GitHub.

With Gen 2, refreshes get spread out over a 24 hour period and don’t impact other queries from users. Gen2 adds autoscaling which instead of throttling, deals with spikes by calling on other vCores. References:

  • https://debbiesmspowerbiazureblog.home.blog/2021/01/21/power-bi-premium-generation-2-first-look/

References:

  • https://www.eyecademy.com/ultimate-power-bi-licensing-3/
  • https://www.epcgroup.net/power-bi-cost/
  • https://whitepages.unlimitedviz.com/2017/09/understanding-the-power-bi-capacity-based-skus/
  • https://dynamics.folio3.com/blog/difference-between-power-bi-pro-vs-free-vs-premium/

PROTIP: To save money, consider PowerBI Robots which automatically takes screenshots of Microsoft Power BI dashboards and reports and sends them anywhere, to an unlimited number of recipients.

Typical workflow

Author -> Publish -> Consume

Microsoft defines two types of users: Business users who interact with content created, then shared by designers.

The most common flow of activity:

  1. Bring data into Power BI Desktop and create a report (based on template?).
  2. Publish to the Power BI service, where you can create new visualizations or build dashboards.
  3. Share dashboards with others, especially people who are on the go.
  4. View and interact with shared dashboards and reports in Power BI Mobile apps.

pbi-product-flow-1200x800

In Preview 2021 is Deployment Pipelines using GitHub and Azure DevOps for PowerBI.

REMEMBER: Land Use Planning on PowerBI desktop which is limited to 1280 pixels wide and 720 pixels high. Be proactive at dividing that real estate.

PL-300 certification

Pay $165 to pass exam PL-300 “Microsoft Power BI Data Analyst” to become a “Microsoft Certified: Power BI Data Analyst Associate”. Threshold for passing:
A minimum score of 700 (70 percent) on the overall exam.

PL-300 replaces the exam DA-100 “Analyzing Data with Microsoft Power BI” to become a “Microsoft Certified: Data Analyst Associate”.

  • LEARN: Prepare data [for analysis] (20-25%)
  • LEARN: Model the data (25-30%)
  • LEARN:Visualize the data (20-25%)
  • LEARN: Analyze the data (10-15%)

LEARN: Manage workspaces: Deploy and maintain deliverables (10-15%)

“LEARN” (above) contain labs which provide free time on a Power BI Desktop.

Microsoft FREE & Class Labs

https://github.com/MicrosoftLearning/PL-300-Microsoft-Power-BI-Data-Analyst/tree/Main/Allfiles/Labs contains hands-on lab exercises used during the 3-day Course PL-300T00: Microsoft Power BI Data Analyst

  1. 01-prepare-data-with-power-query-in-power-bi-desktop/Solution

    Using “Sales Analysis.pbix”:

    Configure many-to-many relationships (so a salesperson’s sales, based on their assigned territories, are analyzed and compared with sales targets, using the SalespersonRegion bridging table with Cross Filter Both Direction.) To avoid the ambiguity of two possible filter propagation paths between the Salesperson and Sales tables being internally resolved based on a “least number of tables” assessment by Editing the Relationship to not active.

    1. Open Power BI Desktop
    2. Set Power BI Desktop options
    3. Connect to source data
    4. Preview source data
    5. Use data preview techniques to better understand the data (exploring and profiling the data in the Power Query Editor window) The Queries pane contains one query for each table checked. View Column Quality, Column distribution, Column profile.

    pbi-col-quality-161x142

  2. 02-load-data-with-power-query-in-power-bi-desktop

    • Apply various transformations

    • Apply queries to load them to the data model

    • Create model relationships
    • Configure table and column properties
    • Create hierarchies
    • Create quick measures

  3. 03-configure-data-model-in-power-bi-desktop

  4. 04-create-dax-calculations-in-power-bi-desktop

    Used in Power BI, Power Pivot, and SSAS Tabular for creating:

    • Calculated Tables (new table derived from another table, such as a calendar) Recalculated when table pulled from is updated/refreshed. Unlike Power Query-sourced tables, calculated tables can’t be used to load data from external data sources. They can only transform data based on what has already been loaded into the data model.
    • Calculated Columns (connecting disparate data sources with multiple key columns)
    • Calculated Measures (Ratios/Percentages, needs a Dynamic Aggregator to work) Cannot be naked. Not calculated immediately.

  5. 05-create-dax-calculations-in-power-bi-desktop-advanced

    • Use the CALCULATE() function to manipulate filter context
    • Use Time Intelligence functions

  6. 06-design-report-in-power-bi-desktop

  7. 07-design-report-in-power-bi-desktop-enhanced

  8. 08-create-power-bi-dashboard

  9. 09-perform-data-analysis-in-power-bi-desktop/Solution

  10. 10-row-level-security

I attended Microsoft’s 4-day live DA-100T00 class by Linda Larkin, but I highly recommend everyone to walk through the (free) lab instructions in English (and other languages) by Shannon Lindsay. The class Modules and labs aka.ms/da100labs

PROTIP: The numbering of Skillpipe modules and labs may not be exactly the same. So below I’ve combined links from the book, direct links to labs, and Microsoft’s 76 free “LEARNing paths”. “FREE LAB” (below) contain labs which provide free time on a virtual Power BI Desktop.

PROTIP: Many find that they need to go through each lab 2-3 times to gain “muscle memory” to know where to click in the GUI.

Module 1. Get Started with Microsoft Data Analytics

Module 2. Get Data in Power BI = Prepare Data in Power BI

Module 3. Clean, Transform, and Load Data in Power BI

Module 4. Design a Data Model in Power BI

  • FREE LAB: Model Data in Power BI Desktop, Part 2 = LAB 04-configure-data-model-in-power-bi-desktop-advanced.md Using “Sales Analysis.pbix”:
    • Configure many-to-many relationships (so a salesperson’s sales, based on their assigned territories, are analyzed and compared with sales targets, using the SalespersonRegion bridging table with Cross Filter Both Direction.) To avoid the ambiguity of two possible filter propagation paths between the Salesperson and Sales tables being internally resolved based on a “least number of tables” assessment by Editing the Relationship to not active.

Module 5 Create Model Calculations using DAX in Power BI

Module 6 Optimize Model Performance

  • No lab

Module 7 Create Reports

Module 8 Create Dashboards

Module 9 Create Paginated Reports in Power BI

Module 10 Perform Advanced Analytics

Module 11 Create and Manage Workspaces

Module 12 Manage Datasets in Power BI

Module 13 Row-level Security

Snippets from GitHub

# Sales All Region measure definition
Sales All Region =
CALCULATE(SUM(Sales[Sales]), REMOVEFILTERS(Region))

# Sales % All Region measure definition (replace Sales All Region measure)
Sales % All Region =
DIVIDE(
   SUM(Sales[Sales]),
   CALCULATE(
      SUM(Sales[Sales]),
      REMOVEFILTERS(Region)
   )
)

# Sales % Country measure definition
Sales % Country =
DIVIDE(
   SUM(Sales[Sales]),
   CALCULATE(
      SUM(Sales[Sales]),
      REMOVEFILTERS(Region[Region])
   )
)

# Sales % Country measure definition (2)
Sales % Country =
IF(
   ISINSCOPE(Region[Region]),
   DIVIDE(
      SUM(Sales[Sales]),
      CALCULATE(
         SUM(Sales[Sales]),
         REMOVEFILTERS(Region[Region])
      )
   )
)

# Sales % Group measure definition
Sales % Group =
DIVIDE(
   SUM(Sales[Sales]),
   CALCULATE(
      SUM(Sales[Sales]),
      REMOVEFILTERS(
         Region[Region],
         Region[Country]
      )
   )
)

# Sales % Group measure definition (2)
Sales % Group =
IF(
   ISINSCOPE(Region[Region])
      || ISINSCOPE(Region[Country]),
   DIVIDE(
      SUM(Sales[Sales]),
      CALCULATE(
         SUM(Sales[Sales]),
         REMOVEFILTERS(
            Region[Region],
            Region[Country]
         )
      )
   )
)

# Sales table: Sales YTD measure definition
Sales YTD =
TOTALYTD(SUM(Sales[Sales]), 'Date'[Date], "6-30")

# Sales table: Sales YoY Growth
Sales YoY Growth =
VAR SalesPriorYear =
   CALCULATE(
      SUM(Sales[Sales]),
      PARALLELPERIOD(
         'Date'[Date],
         -12,
         MONTH
      )
   )
RETURN
   SalesPriorYear

# Sales table: Sales YoY Growth (2)
Sales YoY Growth =
VAR SalesPriorYear =
   CALCULATE(
      SUM(Sales[Sales]),
      PARALLELPERIOD(
         'Date'[Date],
         -12,
         MONTH
      )
   )
RETURN
   DIVIDE(
      (SUM(Sales[Sales]) - SalesPriorYear),
      SalesPriorYear
   )

Other DA-100 Video Tutorials

Helen Wall has several courses on LinkedIn Learning:

  • https://www.linkedin.com/learning/power-bi-essential-training-3/create-rich-interactive-reports-with-power-bi
  • https://www.linkedin.com/learning/advanced-microsoft-power-bi/reducing-data-headaches

Pluralsight’s courses on PowerBI features Stacia Misner Varga and others.

CloudAcademy.com

Dashboard In a Day (DIAD)

Microsoft’s “Dashboard In a Day” (DIAD) are one-day, hands-on virtual workshops to expose business analysts to Power BI.

  1. Download the zip file

    DashboardinaDayAssets.zip

  2. Unzip it (to 454.6 MB). CAUTION: I tried to put the zip into a github repo, but got blocked by this error:

    remote: error: GH001: Large files detected. You may want to try Git Large File Storage - https://git-lfs.github.com. remote: error: See http://git.io/iEPt8g for more information.
 
remote: error: File Data/USSales/sales.csv is 141.49 MB; this exceeds GitHub's file size limit of 100.00 MB
To github.com:wilsonmar/powerbi-diad.git
  3. In Finder, expand (for folders A4, Data, Letter, Reports).

  4. If you’re in the US, delete the A4 folder containing pdf files formatted for European printers. If you’re in Europe, delete the “Letter” folder. They both contain:

    • Lab 0 - Prerequisites and Document Structure.pdf
    • Lab 1 - Accessing and Preparing Data.pdf
    • Lab 2 - Data Modeling and Exploration.pdf
    • Lab 3 - Data Visualization.pdf
    • Lab 4 - Publishing and Accessing Reports.pdf
    • Lab 5 - Collaboration.pdf

    The Reports folder contains Solution pbix files.

BlueGranite.com recorded (in 2020)how to do each in a YouTube videos, listed by date here:

VIDEO: Exercise from 2018

VIDEO: AltisConsulting (UK) on Oct 1, 2020 promote their DIAD delivery.

Data source settings

  1. In the Home ribbon:

    pbi-home-get-data-429x133

  2. Click a data source among the icons or
    click “Get Data” drop down.

    PROTIP: For security reasons, imports of local copies of data into reports are not allowed. So use DirectQuery storage mode.

    Data locations:

    • Local
    • OneDrive cloud - Business
    • OneDrive cloud - Personal
    • SharePoint Team Sites cloud

Load CSV from GitHub

PROTIP: This is a good demo of using Text Paste

  1. To load a file from GitHub, click Raw, then highlight and copy the URL, such as:

    https://raw.githubusercontent.com/MicrosoftLearning/DA-100-Analyzing-Data-with-Power-BI/master/Allfiles/DA-100-Allfiles/Resources/ColorFormats.csv

  2. Switch to Power BI Desktop.

  3. In Home, click “Get Data”, “Text/CSV”, “Web”, yellow “Connect”.

  4. With “Basic” selected, click in the URL field to paste into.

  5. If you’re within a LEARN window, click the blue lightning bolt at the upper-left corner to select “Type Text”, “Type Clipboard Text”, and paste this and click OK:

    mslearn-TypeText-256x229.png

  6. With “Basic” selected, click in the URL field to paste:

  7. In “Access Web Content”, pull down “Select which level to apply these settings to” and select the lowest item.

  8. Click yellow Connect.

    STATUS: I’m getting an error here. Working on it.

    The default import hard-codes column names. VIDEO:

    ColorFormats.csv

Load OData Northwind

VIDEO:

  1. Get Data
  2. OData feed
  3. In URL: https://services.odata.org/Northwind/Northwind.svc
  4. OK for Navigator.
  5. Select tables.

Power Query

Power Query is the query engine used by Power BI and Excel.

The “Power Query M formula language is optimized for building highly flexible data mashup queries. It’s a functional, case sensitive language similar to F#” – powerquery.io.

  1. Click the “Transform” button to open the Query Editor.

https://docs.microsoft.com/en-us/learn/modules/clean-data-power-bi/

Modeling

pbi-modeling-menu-20210705-1429x276

Manage Relationships

Report Builder App

This is done on Windows machines (not macOS).

AI Builder in PowerBI

https://docs.microsoft.com/en-us/ai-builder/flow-text-translation

  1. Sign in to Power Automate (https://us.flow.microsoft.com/en-us/)

  2. Select My flows in the left pane, and then select New flow > Instant cloud flow.

  3. Name your flow, select Manually trigger a flow under Choose how to trigger this flow, and then select Create.

  4. Expand Manually trigger a flow, and then select +Add an input > Text as the input type.

  5. Replace Input with My Text (also known as the title).

  6. Select + New step > AI Builder.

  7. Select Translate text into another language in the list of actions.

  8. Select My Text from the Dynamic content list.

  9. Select the target language in the Translate to input.

  10. The model will automatically detect the source language for you. But optionally, you can select a source language in the Translate from input to specify the language of the text in My Text input.

  11. In successive actions, you can use any columns extracted by the AI Builder model, such as “Send me an email” notification of the translated text with property Text from the text translation model.

  12. Run in Azure DevOps pipeline:

    https://community.powerbi.com/t5/Community-Blog/PowerBI-CICD-using-Azure-DevOps/ba-p/769244

DAX (Data Analysis eXpressions)

DAX = Data Analysis eXpressions (formula-based language) is like Excel functions (such as AVERAGE), operators, and constants used in formulas to calculate or return one or more values.

DOCS: DAX Queries are used in Power BI analysis services and DAX Studio.
DAX Formulas are used in Power BI and Power Pivot.

VIDEO: VIDEO: DAX Formular sample syntax with “=” operator:

    measure=FUNCTION(table[column])

DAX Functions

DAX functions Glossary

Each function references a complete column or table.

A function can return a table.

Data Analytics

Core components of analytics are divided into the following categories:

  • Descriptive - what has happened based on historical data. Key Performance Indicators (KPIs) such as return on investment (ROI) track performance toward key objectives.

  • Diagnostic - answers why events happened. discover the cause of these events. why these events improved or became worse. Identify anomalies

  • Predictive - answers questions about what will happen in the future. identify trends

  • Prescriptive - answer questions about which actions should be taken to achieve a goal or target. patterns in large datasets.

  • Cognitive help you learn what might happen if circumstances change, to determine how to handle these situations.

Roles and tasks:

  • Business analyst
  • Data analyst - Tasks: Prepare, Analyze, Model, Manage, Visualize
  • Data engineer
  • Data scientist
  • Database administrator

Dashboards

Workspaces

Workspaces are used to share content:

  • a different workspace for different audiences (Sales, HR, etc.)
  • different environments (DEV, TEST, PROD)
  • to split the load: hosted in a separate workspace a report with a very high consumption rate kept separate from other reports with low rate of consumption.

References: https://radacad.com/how-to-organize-workspaces-in-a-power-bi-environment

Open & Configure

Mobile config

  1. Open the app. Sign in via Authenticator. Choose a certificate if prompted.

Desktop config

  1. To open Power BI Desktop,
    click the yellow Power BI icon at the bottom of the screen.

  2. To dismiss the yellow “Getting Started” pop-up,
    click the upper-right corner of the pop-up.

    NOTE: You can get that pop-up again by clicking “Getting started” in the File menu.

  3. Click “File” on the top menu.

    pbi-desktop-file-menu

  4. Click “Options and Settings”, “Options”.

  5. Under menu category CURRENT FILE:, Data Load:

    pbi-config-361x445

Capacity config

To use Power BI Premium Capacity, assign a workspace to a capacity.

To configure workloads:

  1. in the Power BI admin portal

    pbi-admin-caps-518x334

  2. In Capacity settings > PREMIUM CAPACITIES, select a capacity.

    DOCS: Each capacity size selected specifies a static mix of v-cores, memory, and limits on render rate. Excess cores or memory or render quota you don’t use, you lose.

    Size v-cores GB Mem Peak renders / hour Cost / Hour Cost / Month
    A1 1 3 300 ~$1 $720
    A2 2 5 600 ~$2 $1,440
    A3 4 10 1,200 ~$4 $2,880
    A4 8 25 2,400 ~$8 $5,760
    A5 16 50 4,800 ~$16 $11,520
    A6 32 100 9,600 ~$32 $22,040
    EM1 1 3 1-300 - $625
    EM2 2 5 301-600 - $1,245
    EM3 4 10 601-1,200 - $2,495
    P1 8 25 2,400 - $4,995
    P2 16 50 4,800 - $9,995
    P3 32 100 9,600 - $19,995

    “A” (Azure) SKU is “for testing and other scenarios” - a Platform-as-a-Service and set of APIs for those ISVs who are using Power BI as the data visualization layer of an application they develop. Power BI Embedded capacity is billed hourly, can be purchased hourly, and can be paused – meaning no long-term commitments to a specific capacity. This pausing capability is critical for small ISVs that don’t yet have the revenue stream to support monthly commitments.

    While the capacity of the Power BI Embedded A1 SKU is equivalent to the Power BI Premium EM SKU, ISVs pay a slightly higher effective monthly price for the flexibility mentioned above.

    “EM” SKUs (EM1-EM3) for content “EMbedding” of PBI Reports. Currently, this can be accomplished through the use of the SharePoint Power BI web part for modern pages, or through tabs in Microsoft Teams. Available only through volume licensing plans purchased through Microsoft Azure.. You can’t purchase them directly.

    “P” (Premium) SKUs (P1-P3) vCores - embedding and enterprise features: Share Power Reports, dashboards and datasets through Power BI Apps (Workspaces), Ad hoc dashboard sharing from personal workspaces. Includes a license to install Power BI Report Server on-premises. But you’re getting a business application vs. a set of APIs.

  3. Under MORE OPTIONS, expand Workloads.
  4. Enable one or more workloads and set a value for Max Memory and other settings.
  5. Select Apply.

Capacity Monitoring

PROTIP: New Relic has dedicated capacities monitoring integration” which makes capacity management easier:

Metric Unit Description
queryDurationMilliseconds Milliseconds DAX Query duration in last interval
queryPoolJobQueueLength Count Number of jobs in the queue of the query thread pool
qpuHighUtilizationMetric Count QPU High Utilization In Last Minute, 1 For High QPU Utilization, Otherwise 0
memoryMetricBytes Bytes Memory. Range 0-3 GB for A1, 0-5 GB for A2, 0-10 GB for A3, 0-25 GB for A4, 0-50 GB for A5 and 0-100 GB for A6
memoryThrashingMetricPercent Percent Average memory thrashing

The number of vCores for each SKU is split between backend and front-end processing.

Building blocks

The basic building blocks in Power BI:

  • Visualizations – Visual representations of data, sometimes just called visuals
  • Datasets – Collections of data that Power BI uses to create visualizations
  • Reports – Collections of visuals from a dataset, spanning one or more pages
  • Dashboards – Single-page collections of visuals built from reports
  • Each app from the AppSource is a collection of ready-made visuals, pre-arranged in dashboards and reports.
  • The canvas is the area in the center of the Power BI service.
  • Tiles within Dashboard

Common data sources like Microsoft Excel files, databases, or Microsoft Azure data, real-time Azure Synapse Analytics tables that combine with other databases and real-time sources to build a moment-by-moment dataset.

Power BI can software services (aka SaaS providers or cloud services): Salesforce, Facebook, Google Analytics, and more.

Other video tutorials on DA-100:

Social Media around Power BI

DA-100 Practice exams

References

More on DevOps

This is one of a series on DevOps:

  1. DevOps_2.0
  2. ci-cd (Continuous Integration and Continuous Delivery)
  3. User Stories for DevOps

  4. Enterprise Software)

  5. Git and GitHub vs File Archival
  6. Git Commands and Statuses
  7. Git Commit, Tag, Push
  8. Git Utilities
  9. Data Security GitHub
  10. GitHub API

  11. TFS vs. GitHub

  12. Choices for DevOps Technologies
  13. Pulumi Infrastructure as Code (IaC)
  14. Java DevOps Workflow

  15. Okta for SSO & MFA

  16. AWS DevOps (CodeCommit, CodePipeline, CodeDeploy)
  17. AWS server deployment options

  18. AWS Load Balancers

  19. Cloud services comparisons (across vendors)
  20. Cloud regions (across vendors)

  21. AWS Virtual Private Cloud

  22. Azure Cloud Onramp (Subscriptions, Portal GUI, CLI)
  23. Azure Certifications

  24. Azure Cloud

  25. Azure Cloud Powershell
  26. Bash Windows using Microsoft’s WSL (Windows Subsystem for Linux)

  27. Azure KSQL (Kusto Query Language) for Azure Monitor, etc.

  28. Azure Networking
  29. Azure Storage
  30. Azure Compute

  31. Azure Monitoring

  32. Digital Ocean

  33. Cloud Foundry

  34. Packer automation to build Vagrant images
  35. Terraform multi-cloud provisioning automation

  36. Hashicorp Vault and Consul to generate and hold secrets

  37. Powershell Ecosystem
  38. Powershell on MacOS

  39. Powershell Desired System Configuration

  40. Jenkins Server Setup
  41. Jenkins Plug-ins
  42. Jenkins Freestyle jobs

  43. Jenkins2 Pipeline jobs using Groovy code in Jenkinsfile

  44. Docker (Glossary, Ecosystem, Certification)
  45. Make Makefile for Docker
  46. Docker Setup and run Bash shell script
  47. Bash coding
  48. Docker Setup
  49. Dockerize apps

  50. Docker Registry

  51. Maven on MacOSX

  52. Ansible
  53. Kubernetes Operators

  54. OPA (Open Policy Agent) in Rego language

  55. MySQL Setup

  56. Threat Modeling

  57. SonarQube & SonarSource static code scan

  58. API Management Microsoft

  59. API Management Amazon

  60. Scenarios for load
  61. Chaos Engineering

More about Azure

This is one of a series about Azure cloud:

PowerBI was published on .