Wilson Mar bio photo

Wilson Mar

Hello!

Email me Calendar Skype call

LinkedIn Twitter Gitter Instagram Youtube

Github Stackoverflow Pinterest

Study to pass Microsoft’s DA-100 Query Editor, DAX, and Models

US (English)   Español (Spanish)   Français (French)   Deutsch (German)   Italiano   Português   Cyrillic Russian   中文 (简体) 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.

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</a> VIDEO: Northwind database</a>

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

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

    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, 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.

    PROTIP: So that you can make use of Microsoft’s labs, this tutorial references raw files in Microsoft’s class GitHub directly instead of on D:\ drive.

  5. Open and configure Power BI Desktop.

Desktop App

PROTIP: 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, and 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


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.


DA-100 certification

Pay $165 to pass exam DA-100 “Analyzing Data with Microsoft Power BI” to make you a “Microsoft Certified: Data Analyst Associate”. Threshold for passing:
A minimum score of 70 percent on the overall exam.
A minimum score of 35 percent on each exam domain:

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

Microsoft FREE & Class Labs

PROTIP: I attended Microsoft’s 4-day live DA-100T00 class by Linda Larkin, but I highly recommend everyone to walk through their (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. Getting 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 LinkedIn Learning has several video courses on Power BI but not specifically on DA-100: * 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 DP-100 video class 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. Download the zip file and expand (for folders A4, Data, Letter, Reports). The Reports folder contains Solution pbix files. If you're in the US, delete the A4 folder containing pdf files. 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

NOTE: 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
   
BlueGranite.com recorded how to do each in a YouTube videos, listed by date here: * Intro * Lab Prerequisites [2020] * Accessing Data [2020 Lab 1 Part 1]
pbi-diad-an-1206x663.png

* Preparing Data [2020 Lab 1 Part 2] * Data Modeling [2020 Lab 2 Part 1] * Data Exploration [2020 Lab 2 Part 2] * DIAD [Dec 2020] * 02 Accessing Data [Feb 2020] * 03 Data Prep [Feb 2020] * 04 Data Modeling & Exploration Part A [Feb 2020] * 05 Data Modeling & Exploration Part B [Feb 2020] * 06 Data Modeling & Exploration Part C [Feb 2020] * 07 Data Visualization Part A [Feb 2020] * DIAD [Mar 2021] * DIAD [Apr 2021] * DIAD [Jun 2021]

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](https://user-images.githubusercontent.com/300046/124383916-3359fe00-dc8c-11eb-990b-705b9fd080d0.png) 1. Click a data source among the icons or
click "Get Data" drop down. * Excel * Power BI datasets (.pbix file extension) * Power BI dataflows * Microsoft SQL Server (relational): AdventureWorksDW2020 or TailspinToys2020-US * Analysis Services * Text/CSV * Web * OData feed * Black query More: Azure: * Azure Cosmos DB (NoSQL database) * Finance Azure Analysis Server Cubes (Azure Analysis Services) * (online services) 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 1. Switch to Power BI Desktop. 1. In Home, click "Get Data", "Text/CSV", "Web", yellow "Connect". 1. With "Basic" selected, click in the URL field to paste into. 1. 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 1. With "Basic" selected, click in the URL field to paste: 1. In "Access Web Content", pull down "Select which level to apply these settings to" and select the lowest item. 1. 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 1. OData feed 1. In URL: https://services.odata.org/Northwind/Northwind.svc 1. OK for Navigator. 1. Select tables. ## Power Query Power Query is the query engine used by Power BI and Excel. 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 ## 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/) 1. Select My flows in the left pane, and then select New flow > Instant cloud flow. 1. Name your flow, select Manually trigger a flow under Choose how to trigger this flow, and then select Create. 1. Expand Manually trigger a flow, and then select +Add an input > Text as the input type. 1. Replace Input with My Text (also known as the title). 1. Select + New step > AI Builder. 1. Select Translate text into another language in the list of actions. 1. Select My Text from the Dynamic content list. 1. Select the target language in the Translate to input. 1. 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. 1. 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. 1. Run in Azure DevOps pipeline: https://community.powerbi.com/t5/Community-Blog/PowerBI-CICD-using-Azure-DevOps/ba-p/769244 ## DAX (Data Analysis eXpressions) VIDEO: 3 hour Beginning DAX Concepts with Power BI 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
## 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.
## 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. 1. 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. 1. Click "File" on the top menu. pbi-desktop-file-menu 1. Click "Options and Settings", "Options". 1. Under menu category CURRENT FILE:, Data Load: ![pbi-config-361x445](https://user-images.githubusercontent.com/300046/124380220-cdb04680-dc78-11eb-8edc-ce5c6b93ebd2.png) ### 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](https://user-images.githubusercontent.com/300046/124412740-6d6ae480-dd0c-11eb-8d82-d1f0453d333a.png) 1. 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. 1. Under MORE OPTIONS, expand Workloads. 1. Enable one or more workloads and set a value for Max Memory and other settings. 1. 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: * Monthly Digests YouTubes from Pragmatic Works Training * Kevin Stratvert
## Social Media around Power BI * Microsoft's YouTube channel is where @JustynaLucznik (Principal Program Manger) show videos. * powerbi.microsoft.com/en-us/blog by Microsoft Program Managers * community.powerbi.com forums managed by Microsoft
### DA-100 Practice exams * By ACloudGuru * By CloudAcademy * Whizlabs ??? ## References ## More on DevOps # This is one of a series on DevOps: 0. [DevOps_2.0](/devops_2.0/) 0. [ci-cd (Continuous Integration and Continuous Delivery)](/ci-cd/) 0. [User Stories for DevOps](/user-stories-for-devops/) 0. [Enterprise Software)](/enterprise-software/) 0. [Git and GitHub vs File Archival](/git-and-github-vs-file-archival/) 0. [Git Commands and Statuses](/git-commands-and-statuses/) 0. [Git Commit, Tag, Push](/git-commits/) 0. [Git Utilities](/git-utilities/) 0. [Data Security GitHub](/data-security-github/) 0. [GitHub API](/github-api/) 0. [TFS vs. GitHub](/tfs-vs-github/) 0. [Choices for DevOps Technologies](/devops-choices/) 0. [Pulumi Infrastructure as Code (IaC)](/pulumi/) 0. [Java DevOps Workflow](/java-devops-workflow/) 0. [Okta for SSO & MFA](/okta/) 0. [AWS DevOps (CodeCommit, CodePipeline, CodeDeploy)](/aws-devops/) 0. [AWS server deployment options](/aws-server-deploy-options/) 0. [AWS Load Balancers](/loadbal/) 0. [Cloud services comparisons (across vendors)](/cloud-services-comparisons/) 0. [Cloud regions (across vendors)](/cloud-regions/) 0. [AWS Virtual Private Cloud](/aws-vpc/) 0. [Azure Cloud Onramp (Subscriptions, Portal GUI, CLI)](/azure-cloud-onramp/) 0. [Azure Certifications](/azure-certifications/) 0. [Azure Cloud](/azure-cloud/) 0. [Azure Cloud Powershell](/azure-cloud-powershell/) 0. [Bash Windows using Microsoft's WSL (Windows Subsystem for Linux)](/bash-windows/) 0. [Azure KSQL (Kusto Query Language) for Azure Monitor, etc.](/kql/) 0. [Azure Networking](/azure-networking/) 0. [Azure Storage](/azure-storage/) 0. [Azure Compute](/azure-compute/) 0. [Azure Monitoring](/azure-monitoring/) 0. [Digital Ocean](/digital-ocean/) 0. [Cloud Foundry](/cloud-foundry/) 0. [Packer](/packer/) automation to build Vagrant images 0. [Terraform](/terraform/) multi-cloud provisioning automation 0. [Hashicorp Vault and Consul](/hashicorp-vault/) to generate and hold secrets 0. [Powershell Ecosystem](/powershell-ecosystem/) 0. [Powershell on MacOS](/powershell-on-mac/) 0. [Powershell Desired System Configuration](/powershell-dsc/) 0. [Jenkins Server Setup](/jenkins-setup/) 0. [Jenkins Plug-ins](/jenkins-plugins/) 0. [Jenkins Freestyle jobs](/jenkins-freestyle/) 0. [Jenkins2 Pipeline jobs using Groovy code in Jenkinsfile](/jenkins2-pipeline/) 0. [Docker (Glossary, Ecosystem, Certification)](/docker/) 0. [Make Makefile for Docker](/make-makefile/) 0. [Docker Setup and run Bash shell script](/bash-scripts/) 0. [Bash coding](/bash-coding/) 0. [Docker Setup](/docker-setup/) 0. [Dockerize apps](/dockerize/) 0. [Docker Registry](/docker-registry/) 0. [Maven on MacOSX](/maven-on-macos/) 0. [Ansible](/ansible/) 0. [MySQL Setup](/mysel-setup/) 0. [SonarQube & SonarSource static code scan](/sonarqube/) 0. [API Management Microsoft](/api-management-microsoft/) 0. [API Management Amazon](/api-management-amazon/) 0. [Scenarios for load](/scenarios-for-load/) 0. [Chaos Engineering](/chaos-engineering/) ## More about Azure # This is one of a series about Azure cloud: * [Cloud services comparisons](/cloud-services-comparisons/) * [Azure cloud introduction](/azure-cloud/) * [Azure Cloud Onramp (Subscriptions, Portal GUI, CLI)](/azure-cloud-onramp/) * [Azure cloud certifications](/azure-certifications/) * [RDP client to access servers](/rdp/) * [Bash Windows using Microsoft's WSL (Windows Subsystem for Linux)](/bash-windows/) * [Microsoft PowerShell ecosystem](/powershell-ecosystem/) * [Azure Cloud Powershell](/azure-cloud-powershell/) * [PowerShell DSC (Desired State Configuration)](/powershell-dsc/) * [PowerShell Modules](/powershell-modules/) * [PowerShell GitHub API programming](/powershell-github/) * [Azure Networking](/azure-networking/) * [Azure Storage](/azure-storage/) * [Azure Compute](/azure-compute/) * [Serverless software app development](/serverless/) * [Azure cloud DevOps](/azure-devops/) * [Dockerize apps](/dockerize/) * [Kubernetes container engine](/kubernetes/) * [Hashicorp Vault and Consul for keeping secrets](/hashicorp-vault/) * [Hashicorp Terraform](/terraform/) * [Ansible](/ansible/) * [Hashicorp Packer to create Vagrant VM images](/packer/) * [Microsoft AI in Azure cloud](/microsoft-ai/) * [Azure IoT](/azure-iot/) * [Azure Monitoring](/azure-monitoring/) * [Azure KSQL (Kusto Query Language) for Azure Monitor, etc.](/kql/) * [Dynatrace cloud monitoring](/dynatrace/) * [AppDynamics cloud monitoring](/appdynamics/) * [Cloud Performance testing/engineering](/cloud-perftest/) * [Cloud JMeter](/cloud-jmeter/)