Market Share Tableau vs Microsoft Power BI vs Qlik - 2024

 As of 2024, Power BI, Tableau, and Qlik remain the dominant players in the business intelligence (BI) and data visualization market, each excelling in different areas.

Market Share and Popularity:

• Power BI by Microsoft continues to lead the market, largely due to its integration with the Microsoft ecosystem and its cost-effectiveness, especially with pricing as low as $10 per user per month for its Pro version. Power BI has a strong community, thanks to Microsoft’s vast developer network and support​(
  Learn R, Python & Data Science Online
  )​(
  DataScientest
  ).
• Tableau, acquired by Salesforce, is a significant player, particularly known for its advanced visualizations and geospatial capabilities. However, it tends to be more expensive, with costs around $70 per user per month. Tableau is favored in environments requiring sophisticated visual storytelling​(
  Learn R, Python & Data Science Online
  )​(
  SelectHub
  ).
• Qlik Sense offers strong data preparation and direct query capabilities, making it competitive in advanced analytics and enterprise-level deployments. While not as dominant in market share as Power BI or Tableau, Qlik stands out for flexibility, particularly in cloud and hybrid environments​(
  SelectHub
  )​(
  DataScientest
  ).

Strengths:

• Power BI: Cost-effective, seamless integration with Microsoft products, strong AI/ML features, and excellent for small to medium-sized enterprises.
• Tableau: Best-in-class for geospatial visualizations and detailed storytelling through data.
• Qlik: Strong in enterprise applications, data preparation, and hybrid cloud environments.

In summary, Power BI leads in market share, followed closely by Tableau, with Qlik making inroads in specific enterprise scenarios.

Azure devops security across different projects

Yes, you can restrict access to Azure DevOps items (work items, code, builds, etc.) between project sites in Azure DevOps. Each project in Azure DevOps has its own set of permissions, security groups, and access controls, and by default, users don't have cross-project permissions unless explicitly granted. Here’s how you can manage and restrict access between projects:

### 1. **Use Different Security Groups Per Project**

  - Each project in Azure DevOps has **security groups** such as *Project Administrators*, *Contributors*, *Readers*, etc.

  - If users belong to different projects, you can control their permissions using these groups. Users who should not have access to another project can simply not be added to that project’s security groups.

### 2. **Set Specific Permissions at the Project Level**

  - Go to **Project Settings** > **Permissions**.

  - Select the security group (e.g., Contributors or Readers) that applies to users of that project.

  - Ensure the users or groups only have the necessary permissions for their own project and deny or restrict permissions that would allow them to view or modify items from other projects.

  - For example, under **Repos** or **Boards**, ensure permissions are denied for unwanted access across projects.

### 3. **Restrict Permissions to Specific Areas/Iterations**

  - In Azure DevOps, you can also configure access control at the **Area Path** level. 

  - If a project is divided into multiple teams, ensure that the **Area Paths** and **Iterations** are set up properly. You can limit users or groups to access specific areas (such as work items or iterations) based on their roles within that area.

  Steps:

  - Navigate to **Project Settings** > **Work** > **Areas**.

  - Set **permissions** for each area to control access to specific work items or iterations.

### 4. **Repository-Specific Permissions**

  If you want to restrict access to code repositories across projects:

  - Go to **Project Settings** > **Repositories**.

  - Select the specific repository you want to restrict.

  - Adjust the repository permissions, denying access to users from other projects.

### 5. **Use Access Control Lists (ACLs) for Pipelines and Releases**

  If you want to control access to pipelines or release definitions across projects:

  - Go to **Project Settings** > **Pipelines** > **Permissions**.

  - For each pipeline or release, specify which users or groups have access to it.

### 6. **Shared Services**

  If you have shared resources (like service connections or libraries) that span multiple projects, ensure that these shared services have restricted access as well.

  - Go to **Project Settings** > **Service Connections**.

  - Set permissions to deny access to unauthorized users or groups from other projects.

### Key Points:

  - Users added to a specific project do not automatically have access to other projects unless explicitly granted.

  - Permissions can be defined at the project, team, area, or repository levels.

  - Ensure users are part of appropriate security groups to enforce restrictions.

This setup allows you to ensure that items within one project are not accessible to users who should only be working on a separate project. Let me know if you need more detailed steps on any of these options!

From Blogger iPhone client

AEGEAN Airline aircraft engine

Aegean Airlines primarily operates a fleet of Airbus and ATR aircraft, which are powered by engines from leading manufacturers:

1. **Airbus A320 Family (A319, A320, A321)** – These aircraft typically use engines from two major manufacturers:

  - **CFM International CFM56**: A popular engine choice for many A320 family aircraft.

  - **Pratt & Whitney PW1100G-JM**: Found on newer Airbus A320neo models, known for greater fuel efficiency.

2. **ATR 72-600** – Aegean operates this turboprop aircraft, which is powered by:

  - **Pratt & Whitney Canada PW127M** engines.

These engine types are recognized for their reliability and efficiency, making them ideal for both short-haul and medium-haul flights.

From Blogger iPhone client

KPI for data pipeline schedules

Key Performance Indicators (KPIs) for data pipeline schedules are essential to monitor the health, efficiency, and reliability of data pipelines. They help ensure that the pipelines are delivering data on time, efficiently, and without errors. Below are some common KPIs for data pipeline schedules:

### 1. **Data Throughput (Processing Volume)**

  - **Definition**: Measures the amount of data processed within a given time period (e.g., MB/s, GB/hour).

  - **Purpose**: Ensures the pipeline can handle the expected data volume within the defined schedule.

### 2. **Pipeline Latency (Time to Completion)**

  - **Definition**: The total time taken for the data to move through the entire pipeline, from extraction to loading.

  - **Purpose**: Tracks how long it takes for data to be processed from the source to its destination. Lower latency indicates faster pipelines.

  - **Threshold**: Compare actual latency to the expected or SLA (Service-Level Agreement) latency.

### 3. **Data Freshness**

  - **Definition**: Measures how current the data in the pipeline is compared to the source data.

  - **Purpose**: Ensures data is being processed and delivered in near real-time, or within acceptable timeframes for decision-making. This is crucial in near-real-time or streaming data pipelines.

### 4. **On-Time Delivery (Schedule Adherence)**

  - **Definition**: The percentage of pipeline runs completed within the scheduled time window.

  - **Purpose**: Tracks how often the pipeline delivers data on time according to its schedule. Delays may affect downstream processes or reporting.

  - **Formula**: (Number of On-Time Runs / Total Pipeline Runs) * 100%

### 5. **Success Rate**

  - **Definition**: The percentage of successful pipeline executions compared to the total scheduled executions.

  - **Purpose**: Measures the reliability of the data pipeline. A high success rate indicates that the pipeline is running smoothly without failures.

  - **Formula**: (Number of Successful Runs / Total Runs) * 100%

### 6. **Failure Rate**

  - **Definition**: The percentage of failed pipeline runs over a specific period.

  - **Purpose**: Identifies how often pipeline failures occur. Lower failure rates indicate higher stability.

  - **Formula**: (Number of Failed Runs / Total Runs) * 100%

### 7. **Error Rates**

  - **Definition**: Measures the number of data or system errors encountered during pipeline execution.

  - **Purpose**: Helps monitor pipeline health by identifying the number and type of errors (e.g., transformation errors, connection errors) that could impact data quality or the pipeline's ability to complete on time.

  - **Formula**: (Number of Errors / Total Records Processed) * 100%

### 8. **Data Quality Metrics**

  - **Definition**: Monitors the quality of the data passing through the pipeline, focusing on completeness, consistency, and accuracy.

  - **Purpose**: Ensures that the data processed through the pipeline meets expected quality standards. Poor quality data can affect downstream systems and analytics.

  - **Examples**:

   - **Null Values**: % of fields with null or missing values.

   - **Accuracy**: % of data matching expected values or patterns.

   - **Duplication Rate**: % of duplicate records processed.

### 9. **Time to Recovery (MTTR)**

  - **Definition**: Measures the average time taken to detect, diagnose, and recover from pipeline failures.

  - **Purpose**: Tracks how quickly the pipeline can recover after a failure or an issue, minimizing downtime and disruption to business processes.

### 10. **Scalability (Elasticity)**

  - **Definition**: Measures the ability of the data pipeline to scale in response to increased data volume or demand.

  - **Purpose**: Ensures that the pipeline can maintain performance and schedule adherence under varying load conditions without significant slowdowns.

### 11. **Resource Utilization**

  - **Definition**: Tracks CPU, memory, and disk usage of the systems supporting the pipeline.

  - **Purpose**: Ensures the pipeline is efficiently using computational resources, avoiding bottlenecks that could delay execution.

### 12. **Failed Data Processing Count**

  - **Definition**: The number of records or batches that failed to process due to errors in data quality or transformation steps.

  - **Purpose**: Tracks how many records are being skipped or dropped due to data issues, which can impact the final results.

### 13. **Backlog Size**

  - **Definition**: The amount of unprocessed data that remains in the pipeline at any given time.

  - **Purpose**: Helps measure how well the pipeline keeps up with incoming data and detects potential slowdowns or blockages.

### 14. **End-to-End Pipeline Availability (Uptime)**

  - **Definition**: Measures the total time the pipeline was available and operational, divided by the total scheduled operational time.

  - **Purpose**: Ensures that the pipeline is available and functioning as expected when scheduled. A lower uptime indicates potential infrastructure or operational issues.

  - **Formula**: (Total Pipeline Operational Time / Total Scheduled Time) * 100%

### 15. **Cost per Pipeline Run**

  - **Definition**: Tracks the cost of running the pipeline, including compute, storage, and infrastructure costs.

  - **Purpose**: Helps monitor the financial efficiency of the pipeline. Higher costs may indicate inefficient resource usage.

### 16. **Pipeline Scheduling Flexibility**

  - **Definition**: Measures how quickly and easily a pipeline can be rescheduled or adjusted to meet changing data processing demands.

  - **Purpose**: Ensures that the pipeline can be adapted in real-time to accommodate changes in business needs or operational circumstances.

### Conclusion:

These KPIs provide a comprehensive overview of the performance of data pipelines, helping teams monitor efficiency, data quality, reliability, and cost-effectiveness. Monitoring these metrics regularly ensures that pipelines deliver data accurately, on time, and in line with business needs.

From Blogger iPhone client

Race to be first in Electric airplanes

Several companies are currently in the race to develop the world’s first fully electric commercial airplane. Here are some of the key players leading the charge:

### 1. **Eviation Aircraft**

  - **Alice**: Eviation, an Israeli-based company, is developing an electric aircraft called **Alice**, which is designed for short-haul regional flights. Alice aims to carry 9 passengers with a range of about 500 miles on a single charge. Alice completed its maiden test flight in 2022 and is expected to be one of the first all-electric planes to enter commercial service by the mid-2020s.

### 2. **Rolls-Royce**

  - **ACCEL Project**: Rolls-Royce, a major player in the aerospace industry, is developing electric propulsion systems and has been working on the **ACCEL (Accelerating the Electrification of Flight)** project. Their aircraft, **Spirit of Innovation**, set speed records for electric aircraft in 2021 and is part of their broader effort to develop electric aviation technology for commercial use.

### 3. **Airbus**

  - **ZEROe Project**: While not purely electric, Airbus is working on **ZEROe**, a series of hybrid-hydrogen aircraft that could be a step toward electric propulsion. Airbus has committed to developing fully carbon-neutral aircraft by 2035 and is exploring various electric and hydrogen-powered designs to achieve this.

### 4. **Vertical Aerospace**

  - **VA-X4**: Vertical Aerospace, a UK-based company, is developing electric vertical takeoff and landing (eVTOL) aircraft, which are designed for urban air mobility. Their **VA-X4** is a fully electric aircraft capable of carrying four passengers. Though it is aimed more at urban transport, it's part of the broader push toward electric aviation.

### 5. **MagniX**

  - **Partnerships with multiple aircraft manufacturers**: MagniX, a leading provider of electric motors for aircraft, has partnered with various companies to retrofit existing planes with electric engines. For example, they’ve worked with Harbour Air, a Canadian seaplane operator, to convert seaplanes into all-electric aircraft. MagniX is a key player in the development of electric propulsion systems for commercial aviation.

### 6. **Heart Aerospace**

  - **ES-30**: Heart Aerospace, a Swedish company, is developing the **ES-30**, a 30-seat electric regional aircraft with an estimated range of 250 miles. The company has received orders from major airlines like United Airlines and Mesa Airlines and aims to have the aircraft ready for commercial service by the late 2020s.

### 7. **Lilium**

  - **Lilium Jet**: Lilium is a German company developing an electric vertical takeoff and landing (eVTOL) jet for regional transportation. Though it’s aimed at urban mobility and short-distance regional flights, it is fully electric and part of the broader push toward electric aviation.

### 8. **Joby Aviation**

  - **Joby eVTOL**: Another player in the eVTOL space, Joby Aviation is developing electric aircraft for air taxi services. While their focus is on urban air mobility, the technology could pave the way for future electric planes used for longer distances.

### 9. **Bye Aerospace**

  - **eFlyer**: Bye Aerospace is developing a series of fully electric aircraft called **eFlyer** for the general aviation market, including a 2-seat **eFlyer 2** and a larger **eFlyer 4**. These planes are designed for training, personal, and regional air transport and are expected to be among the first electric planes to enter service.

### Conclusion:

Eviation's **Alice**, Bye Aerospace's **eFlyer**, and Heart Aerospace’s **ES-30** are among the most advanced projects and could be some of the first fully electric airplanes to enter commercial service. Additionally, companies like Airbus, Rolls-Royce, and MagniX are making significant advancements in electric propulsion systems that could power future generations of electric aircraft. 

The first electric airplanes will likely be used for **short-haul regional flights** and urban air mobility before the technology matures for longer-range commercial flights.

From Blogger iPhone client

Open source flight data pipeline

If you're looking for **free and open-source** methods to extract flight data without requiring a credit card, there are a few options. Some APIs and datasets provide limited free access, but most premium services (like FlightAware, FlightRadar24, etc.) do require paid subscriptions. However, there are still a few alternatives:

### 1. **OpenSky Network API**

  - **OpenSky Network** is an open-source, community-based platform for live air traffic data. It's one of the best free options for accessing live flight data.

  - The **OpenSky API** allows you to access real-time flight data, historical data, and more without needing to sign up with a credit card.

  

  **Website**: [OpenSky Network](https://opensky-network.org/)

  #### Example API Call for Real-Time Flights:

  ```python

  import requests

  import json

  # OpenSky Network API URL

  url = "https://opensky-network.org/api/states/all"

  # Make a GET request to the API

  response = requests.get(url)

  # Parse the JSON response

  if response.status_code == 200:

    flight_data = response.json()

    print(json.dumps(flight_data, indent=4))

  else:

    print(f"Error: {response.status_code}")

  ```

  #### Features:

  - Real-time flight data

  - Historical data access (limited)

  - No credit card required for access

  - Data from contributors worldwide

### 2. **AviationStack API**

  - **AviationStack** provides a freemium model for flight data. While its free tier has some limitations, you can get access to real-time flight status and aviation data without requiring a credit card.

  - The free tier allows you to make up to 500 requests per month.

  **Website**: [AviationStack API](https://aviationstack.com/)

  #### Example API Call:

  ```python

  import requests

  # Get your free API key from aviationstack (no credit card required)

  api_key = 'your_api_key_here'

  url = f"http://api.aviationstack.com/v1/flights?access_key={api_key}"

  response = requests.get(url)

  if response.status_code == 200:

    flight_data = response.json()

    print(flight_data)

  else:

    print(f"Error: {response.status_code}")

  ```

  #### Features:

  - Real-time flight data

  - Airline routes and schedules

  - Limited to 500 requests/month in the free tier

### 3. **ADS-B Exchange**

  - **ADS-B Exchange** provides a completely free, community-driven dataset of live flight information gathered from ADS-B signals.

  - You can access real-time data, historical data, and aircraft tracking information without signing up or paying.

  **Website**: [ADS-B Exchange API](https://www.adsbexchange.com/data/)

  #### Example: Accessing Real-Time Data

  ```python

  import requests

  # API endpoint for real-time flight data from ADS-B Exchange

  url = "https://adsbexchange-com1.p.rapidapi.com/v2/aircraft/lat/{lat}/lon/{lon}/dist/{dist}/"

  headers = {

    "X-RapidAPI-Key": "your-rapidapi-key",

    "X-RapidAPI-Host": "adsbexchange-com1.p.rapidapi.com"

  }

  response = requests.get(url, headers=headers)

  if response.status_code == 200:

    data = response.json()

    print(data)

  else:

    print(f"Error: {response.status_code}")

  ```

  #### Features:

  - Real-time aircraft positions

  - Historical flight data

  - No paywalls or subscriptions required

### 4. **OpenFlights Dataset**

  - **OpenFlights** is an open-source database of airline routes and airport information. While it doesn't offer real-time flight tracking, you can use it to get data on routes, airlines, and airports globally.

  

  **Website**: [OpenFlights](https://openflights.org/data.html)

  

  #### Example Usage:

  You can download the dataset as a CSV file and use it directly in Python using `pandas`.

  ```python

  import pandas as pd

  # Load the OpenFlights dataset

  url = 'https://openflights.org/data/routes.dat'

  columns = ['airline', 'airline_id', 'source_airport', 'source_airport_id', 

       'destination_airport', 'destination_airport_id', 'codeshare', 

       'stops', 'equipment']

  flight_data = pd.read_csv(url, names=columns)

  print(flight_data.head())

  ```

  #### Features:

  - Access to airline routes and airports worldwide

  - No real-time data, but useful for research and static data needs

---

### Which Option is Right for You?

- **OpenSky Network** is the best option if you want real-time data without a credit card.

- **ADS-B Exchange** is a great choice if you want real-time tracking without restrictions.

- **AviationStack** is useful if you're okay with a freemium model and limited requests per month.

- **OpenFlights Dataset** is useful for research and non-real-time data.

If you need help setting up any of these APIs or working with the data, let me know!

From Blogger iPhone client

Extraction pipeline from flight radar web site

If you're looking to use Python with Selenium to scrape flight data from a website that displays live flight information (such as FlightRadar24), here's a general approach. Keep in mind that you should always check a website's terms of service and robots.txt to ensure that you're allowed to scrape data.

### Requirements:

- Install Selenium using pip:

 ```bash

 pip install selenium

 ```

- Download a WebDriver (e.g., ChromeDriver) and place it in your PATH or provide its location in the code.

- If scraping frequently or on a large scale, consider using an official API if available.

### Example: Scraping Flight Data from a Public Website Using Selenium

```python

from selenium import webdriver

from selenium.webdriver.common.by import By

import time

# Set up the WebDriver (adjust the path if needed)

driver = webdriver.Chrome(executable_path="/path/to/chromedriver")

# Open the flight radar website

url = "https://www.flightradar24.com/"

driver.get(url)

# Let the page load (you might need to adjust the time)

time.sleep(10)

# Extract flight information from the page

# This example assumes there's a table of flights with unique identifiers, modify selectors as needed

flights = driver.find_elements(By.CSS_SELECTOR, '.list-row') # Modify to fit the website's structure

flight_data = []

for flight in flights:

  flight_info = {}

   

  try:

    # Modify selectors according to the site's structure

    flight_info['flight_number'] = flight.find_element(By.CSS_SELECTOR, '.flight-number').text

    flight_info['departure'] = flight.find_element(By.CSS_SELECTOR, '.departure').text

    flight_info['arrival'] = flight.find_element(By.CSS_SELECTOR, '.arrival').text

    flight_info['status'] = flight.find_element(By.CSS_SELECTOR, '.status').text

    flight_data.append(flight_info)

  except Exception as e:

    print(f"Error extracting data for a flight: {e}")

# Print the extracted flight data

for flight in flight_data:

  print(flight)

# Close the driver

driver.quit()

```

### Key Points:

- **Selectors**: Use browser developer tools to inspect the webpage and identify the correct CSS selectors for the flight data you want to scrape.

- **Delay/Timeout**: Some websites may use dynamic content loading, so adding `time.sleep()` or WebDriver waits for elements to load can help ensure accurate data scraping.

  

### Example Output:

```python

{

  "flight_number": "AA123",

  "departure": "JFK",

  "arrival": "LAX",

  "status": "On Time"

}

```

If you have a specific site or need further customization, let me know!

From Blogger iPhone client

Open source CRM systems

Here are some **open-source CRM solutions** that provide features similar to Zoho, allowing businesses to manage customer relationships, sales pipelines, and marketing automation, often with the option of customization:

### 1. **Odoo CRM**

  - **Overview**: Odoo is a modular, open-source platform that offers a wide range of business apps, including CRM, ERP, and e-commerce.

  - **Features**:

   - Lead management and sales tracking.

   - Integrated with other Odoo modules (accounting, marketing, inventory, etc.).

   - Can be hosted on-premise or in the cloud.

   - Highly customizable via its open-source codebase.

  - **Why it’s like Zoho**: Odoo, like Zoho, is an all-in-one solution covering multiple business functions beyond CRM.

  - **Website**: [Odoo](https://www.odoo.com/)

### 2. **SuiteCRM**

  - **Overview**: A fork of the popular SugarCRM CE, SuiteCRM is a fully open-source solution focused on CRM functionality.

  - **Features**:

   - Sales pipeline management, workflow automation, and marketing tools.

   - Customer support features like ticketing and case management.

   - Offers custom modules for added functionality.

   - Free to use, with paid support options available.

  - **Why it’s like Zoho**: SuiteCRM offers robust CRM functionality similar to Zoho CRM, and its flexibility makes it suitable for businesses of all sizes.

  - **Website**: [SuiteCRM](https://suitecrm.com/)

### 3. **EspoCRM**

  - **Overview**: EspoCRM is an open-source CRM that focuses on simplicity and flexibility, catering to small and medium-sized businesses.

  - **Features**:

   - Lead and opportunity tracking, sales automation, and calendar management.

   - Customer relationship and project management capabilities.

   - Integrates with other business applications.

   - Customizable with a REST API for integrations and custom developments.

  - **Why it’s like Zoho**: It offers similar CRM functionality with lead management and business process automation, and it’s lightweight with strong customization options.

  - **Website**: [EspoCRM](https://www.espocrm.com/)

### 4. **Vtiger CRM**

  - **Overview**: Vtiger CRM started as an open-source version of SugarCRM and has since developed into a robust CRM solution with both open-source and cloud versions.

  - **Features**:

   - Sales automation, helpdesk, marketing automation, and project management.

   - Integrates well with other business applications.

   - Offers a free open-source edition with the option to upgrade to a cloud version.

  - **Why it’s like Zoho**: Like Zoho, Vtiger offers an all-in-one business solution with CRM, sales, and project management tools.

  - **Website**: [Vtiger](https://www.vtiger.com/open-source/)

### 5. **CiviCRM**

  - **Overview**: CiviCRM is an open-source CRM designed primarily for nonprofits, NGOs, and advocacy groups.

  - **Features**:

   - Contact management, event management, fundraising, and case management.

   - Integration with content management systems like WordPress, Drupal, and Joomla.

   - Extensive customization options through its open-source nature.

  - **Why it’s like Zoho**: CiviCRM provides many of the same contact and relationship management tools, though it’s more focused on the nonprofit sector.

  - **Website**: [CiviCRM](https://civicrm.org/)

### 6. **X2CRM**

  - **Overview**: X2CRM is an open-source CRM and marketing automation platform designed for small businesses.

  - **Features**:

   - Lead management, sales tracking, and marketing automation.

   - Integration with email, social media, and web-based campaigns.

   - Real-time analytics and workflow automation.

  - **Why it’s like Zoho**: X2CRM offers similar automation and customer relationship management tools, with an emphasis on sales and marketing automation.

  - **Website**: [X2CRM](https://www.x2crm.com/)

### 7. **Crust CRM (Corteza)**

  - **Overview**: Crust CRM, part of the Corteza platform, is an open-source alternative to proprietary CRM systems, built with enterprise-grade capabilities.

  - **Features**:

   - Customer and sales management, workflow automation, and communication tools.

   - Built on a flexible low-code platform, allowing for deep customization.

   - Can integrate with the wider Corteza platform for additional business applications.

  - **Why it’s like Zoho**: Crust offers a similar full-stack business solution, with CRM as a key component, providing flexibility and scalability.

  - **Website**: [Crust CRM](https://www.crust.tech/)

### Summary of Key Benefits:

- **Odoo**: Best for businesses needing an all-in-one modular system, similar to Zoho’s broad suite.

- **SuiteCRM**: Focused on CRM functionality with deep customization options.

- **EspoCRM**: Lightweight, flexible CRM for small businesses with easy customization.

- **Vtiger CRM**: Ideal for businesses needing a CRM with helpdesk and project management features.

- **CiviCRM**: Tailored for nonprofits with contact management and event planning.

- **X2CRM**: Designed for small businesses with a focus on marketing automation.

- **Crust CRM**: A more enterprise-grade, low-code solution for businesses needing flexibility.

All these solutions provide strong open-source alternatives to Zoho, with varying degrees of customization, scalability, and target audiences.

From Blogger iPhone client

Maps Cannot be Displayed in Tableau!! How do I Fix This?

 There are several reasons why your Tableau map is not displaying – probably;

• You’ve assigned the wrong geographical role or

• Used the wrong location

The two, would likely be the most common reasons your map is not displaying. How do you recognize and fix it?

How do we plot maps?

We plot maps using geographic fields. A field is recognized as a geographic field in Tableau by assigning it a geographic role. These geographic fields can instantly be spotted using the globe icon right before the field name.

(Examples of geographic fields)

We plot maps by dragging the geographic fields to the detail shelf. In this case, have dragged the field State to the detail shelf – to plot State map.

Note: Because of one of the two reasons above – am getting a blank view with 49 unknowns on the bottom right.

How do you fix this?

To fix this – check your map location first.

1. Editing Location

To edit your map location – go to Map menu >> Edit Locations …

On the dialogue box – ensure that the correct location is chosen. In this case, have changed my Country/Region to United States – simply because the data I need to plot is based on that geographic area.

(Note: This does not give the solutions am looking for. This is because Tableau is still unable to match the locations in my data. Hence returning the fields as ‘Unrecognized’ - therefore I need to troubleshoot further)

2. Assign the correct geographic role

To view the currently assigned geographic role – click on the globe icon (or right click on the field) >> Geographic Role >> see what is assigned.

In this case, am able to spot the problem with my map – that is the field State has been assigned geographic role of Zip Code/Postcode instead of State/Province.

Assigning the correct geographic role, I have.

This can be used to perform spatial analysis by adding different measures.

(In this case, have added Profit to the color shelf)
https://www.rigordatasolutions.com/post/maps-cannot-be-displayed-in-tableau-how-do-i-fix-this