Blog

  • Pride & Prejudice by Jane Austen Chapter One

    Pride & Prejudice by Jane Austen Chapter One

    Pride & Prejudice by Jane Austen Chapter One

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • Al-Riyadh Newspaper, June 6, 2025: Eid-Al-Adha, Logistical Challenges, AI, Surveillance Technologies, Hajj Sermon

    Al-Riyadh Newspaper, June 6, 2025: Eid-Al-Adha, Logistical Challenges, AI, Surveillance Technologies, Hajj Sermon

    These texts center on the Hajj pilgrimage in Saudi Arabia, emphasizing the immense efforts undertaken by the Saudi government to ensure the comfort and safety of the pilgrims. Several articles highlight the logistical challenges of managing the millions of attendees and the innovative solutions being employed, particularly the integration of artificial intelligence (AI) and advanced surveillance technologies to monitor crowd movement, prevent bottlenecks, and improve overall efficiency. Additionally, one text features a sermon delivered during the Hajj stressing the spiritual significance of the event and the importance of adhering to religious and regulatory guidelines for a successful pilgrimage.

    Description
    Rechargeable Portable Desktop Mini Fans for Outdoor Travel Camping Small Silent Table USB Fans for Home Office,White

    Modern Management of the Hajj Pilgrimage

    Based on the sources provided, Hajj management involves extensive efforts and various aspects overseen by the Kingdom of Saudi Arabia, with a focus on ensuring the safety, security, and comfort of the pilgrims.

    Key aspects of Hajj management mentioned in the sources include:

    • Overall Efforts and Commitment: The Kingdom of Saudi Arabia undertakes immense efforts and provides extensive services for the pilgrims, referred to as “guests of the الرحمن” (Rahman – The Most Gracious). This service is considered a duty that the Kingdom takes pride in performing. The leadership is keen on providing the highest level of services to the pilgrims, recognizing the significant importance of the Hajj season. These efforts are described as exemplary.
    • Logistical and Infrastructure Management: Managing millions of pilgrims from over 171 countries moving simultaneously within a geographically limited space is a complex task requiring vast resources and accumulated experience, supported by the latest technologies.
    • Security and Safety: Ensuring the security and safety of pilgrims at all stages of Hajj is a primary focus. This involves integrated efforts between security, military, and service agencies. Security forces play a crucial role in organizing pilgrim movement and managing crowds, particularly around the Jamarat facility. Strict compliance with regulations and instructions from relevant authorities is emphasized as a religious and ethical duty to achieve the objectives of Sharia and ensure smooth performance of rituals.
    • Transportation Management: Managing transportation is critical for smooth movement between the holy sites (Arafat, Muzdalifah, and Mina). The Holy Sites Train plays a vital role, with its readiness overseen by the Minister of Interior. The train operates with five flexible operational movements and has a transport capacity of up to 72,000 passengers per hour. Authorities monitor the train’s operations and stations to ensure smooth movement and safety, especially during the Jamarat stoning ritual.
    • Service Provision: A wide range of services, including medical, ambulance, and logistical services, are provided across the holy sites. These services are made available free of charge and are supported by the latest technologies and experienced personnel.
    • Medical Management: The Ministry of Health deploys innovative solutions, such as using drones and helicopters for medical supply delivery, significantly reducing delivery time. This is a pioneering initiative globally for managing medical supplies during large gatherings. There is also a focus on monitoring and addressing heat stress among pilgrims, advising them to use umbrellas, drink plenty of water, and adhere to regulated movement plans. Integrated health services are provided through call centers like 937, offering consultations and support in multiple languages.
    • Crowd Management and Flow: Security and military sectors, in coordination with other entities, supervise pilgrim movement and flow according to detailed plans. AI-powered systems using high-resolution cameras are employed to analyze crowd density, detect unusual behavior, and predict potential congestion or bottlenecks, allowing for rapid intervention and redirection of pilgrims.
    • Technological Integration: Technology, particularly Artificial Intelligence, is highlighted as a strategic tool for Hajj management in 1446 AH. AI assists in analyzing data, making rapid decisions, predicting crowd movements, optimizing resource allocation, and improving the quality of services. Applications like “Tawakkalna” provide services such as weather forecasts for the holy sites, helping pilgrims plan their movements.
    • Specific Ritual Management: The process for performing rituals like the Jamarat stoning is carefully managed. The facility includes multiple levels, electric escalators, and moving walkways to facilitate pilgrim movement. Preparations are made to reduce the impact of heat stress in areas like the eastern courtyard of the Jamarat facility.
    • Food Security and Waste Reduction: The General Authority for Food Security launched a campaign to reduce food loss and waste during Hajj, promoting responsible consumption and food sustainability in line with Islamic teachings.
    • Regulatory Compliance: Authorities strongly emphasize obtaining and complying with Hajj permits. Performing Hajj without a permit is considered a serious Sharia violation due to its disregard for regulations and harm to public interest. Security forces are actively monitoring and apprehending those attempting to perform Hajj without permits. Penalties, including fines and deportation, are in place for individuals facilitating or attempting to perform Hajj without the required permits.

    Overall, Hajj management is portrayed as a massive, well-coordinated operation involving numerous governmental and private entities, leveraging technology and extensive human resources to facilitate the spiritual journey of millions of pilgrims safely and smoothly. The focus is not just on logistics but also on enhancing the pilgrims’ experience through advanced services and innovative solutions.

    Description
    7.5″ Waterproof Phone Pouch Case with Reinforced Edges Universal Dry Bag with Lanyard for Beach Outdoor Travel (Blue)

    Hajj Pilgrim Safety and Security Management

    Based on the provided sources, the management of pilgrims’ safety during Hajj is a paramount concern for the Kingdom of Saudi Arabia, involving extensive efforts and sophisticated strategies. Ensuring the security and safety of the pilgrims, who are referred to as “guests of the Rahman,” is considered a duty and a source of pride for the Kingdom’s leadership. This focus on safety is evident throughout all stages of the Hajj pilgrimage.

    Key aspects of pilgrim safety management highlighted in the sources include:

    • Overall Commitment and Scale: The Kingdom invests immense efforts and provides extensive services to ensure the safety and security of pilgrims. Managing millions of pilgrims from over 171 countries moving simultaneously in a limited geographic space is a complex undertaking that requires vast resources, accumulated experience, and the latest technologies. The Kingdom is described as having excelled globally in managing these large human crowds.
    • Integrated Security Operations: Security and safety are primary focuses, involving integrated efforts among security, military, and service agencies. Security forces play a crucial role in organizing the movement of pilgrims and managing crowds. Officials, including the Minister of Interior and the Director of Public Security, oversee and review security plans and their implementation to ensure safety and tranquility. These forces work together as one team.
    • Crowd Management and Flow: Managing crowd density and movement between the holy sites (Arafat, Muzdalifah, Mina) is critical for safety. The Jamarat facility, where the stoning ritual takes place, is designed with multiple levels, escalators, and moving walkways to facilitate pilgrim movement safely. Special Emergency Forces are specifically tasked with crowd management and maintaining order during the stoning ritual.
    • Transportation Safety: Transportation management, particularly the Holy Sites Train, is vital for smooth and safe movement. The readiness and operation of the train are overseen by authorities to ensure smooth movement and safety, especially during peak times. Security forces are stationed at train stations to organize pedestrian flow.
    • Health and Medical Safety: The Ministry of Health deploys comprehensive medical services across the holy sites. Addressing heat stress is a significant focus for pilgrim safety. Pilgrims are advised to use umbrellas, drink plenty of water, and adhere to regulated movement plans to mitigate the effects of high temperatures. Innovative solutions, such as using drones and helicopters for rapid medical supply delivery, are employed to enhance emergency response and pilgrim safety. Integrated health services, including consultations and support in multiple languages, are available through call centers like 937.
    • Technological Integration: Technology, especially Artificial Intelligence (AI) and high-resolution cameras, is a strategic tool for enhancing safety and security. AI-powered systems are used to analyze crowd density, detect unusual behavior, predict potential congestion or bottlenecks, and enable rapid intervention and redirection of pilgrims. This enables proactive planning and rapid decision-making. Mobile applications, like “Tawakkalna,” provide pilgrims with essential information, such as weather forecasts for the holy sites, to help them plan their movements safely. AI can even potentially assist in detecting early health indicators like heat stress by analyzing movement patterns.
    • Regulatory Compliance and Unauthorized Hajj: Adherence to regulations and instructions from relevant authorities, particularly obtaining and complying with Hajj permits, is strongly emphasized as crucial for public interest, safety, and smooth performance of rituals. Performing Hajj without a permit is considered a serious Sharia violation due to its disregard for regulations and potential harm to public safety and order. Security forces actively monitor and apprehend those attempting to perform Hajj without permits, and penalties (fines, deportation) are enforced against both individuals attempting unauthorized Hajj and those who facilitate it. The Ministry of Hajj and Umrah warns against fraudulent Hajj campaigns lacking permits, emphasizing the importance of official permits for safety and tranquility.

    In essence, pilgrim safety during Hajj is managed through a multi-layered approach involving extensive logistical planning, robust security presence, advanced technological systems for monitoring and crowd control, comprehensive medical services, and strict enforcement of regulations to ensure order and prevent overcrowding and associated risks. The entire operation is geared towards enabling millions of pilgrims to perform their rituals in an environment of security, safety, and tranquility.

    Description
    Compatible for iPhone 15 Case, Black and Stormy Sky Design, Anti-Scratch Phone Cover(Single Pack)

    AI’s Role in Hajj Management 1446 AH

    Based on the provided sources, Artificial Intelligence (AI) technology is a strategic and central element in the management of Hajj for the year 1446 AH, transforming the approach from traditional methods to a more intelligent, safe, and comfortable system. This integration is seen as a qualitative leap and a “technological revolution”, showcasing the Kingdom’s commitment to adopting the latest innovations to serve the “guests of the Rahman”.

    AI applications are utilized across various sectors, particularly in security and health, to manage the large human gatherings and enhance the pilgrim experience. Key applications highlighted in the sources include:

    • Crowd Management and Flow Analysis: AI-powered systems, supported by a vast network of high-resolution cameras, are used as advanced analytical tools. These systems employ algorithms and deep learning to analyze millions of human behavior data points per second. They can identify crowd flows, monitor excessive densities in specific areas, detect unusual behavioral patterns, and predict potential congestion or bottlenecks. This allows for rapid intervention and proactively anticipating human bottlenecks before they escalate. For example, the system can predict dangerous congestion minutes ahead in a specific route based on current flow, enabling field teams to redirect pilgrims or adjust movement proactively.
    • Real-time Monitoring and Safety Mapping: The network of smart cameras and AI provides real-time monitoring, helping to map out safety conditions. This involves analyzing camera data continuously to determine crowd density and movement dynamics.
    • Predictive Planning and Strategic Simulation: AI goes beyond real-time response by anticipating future needs and simulating complex scenarios. It can predict human flow accurately at each stage of Hajj (Mina, Mas’a, Mataf, Muzdalifah, Arafat) based on historical data, pilgrim numbers, and detailed schedules. This allows for the management of human and logistical resources and the optimization of resource allocation, such as distributing meals and water proactively. AI can also simulate the impact of unexpected factors like weather changes or sudden increases in pilgrim numbers, and suggest optimal responses, enhancing readiness for potential challenges.
    • Optimizing Resource Allocation and Service Quality: By accurately predicting future needs, AI plays a decisive role in allocating resources more efficiently. This includes guiding the distribution of ambulances, assigning guidance teams, and optimizing the supply of water and beverages. AI helps ensure necessary resources reach the right place at the optimal time, reducing waste and improving the quality of services for pilgrims.
    • Facilitating Immediate Decision-Making: Speed in decision-making is crucial, and AI acts as a core component by providing officials in control rooms with interactive smart dashboards displaying real-time data on crowd status. It can issue proactive alerts and specific, immediate recommendations to relevant authorities, significantly reducing response time from minutes to seconds. AI can even automatically direct field teams to areas needing urgent intervention based on its analysis.
    • Coordination Platform: AI can function as a unified platform for collecting and exchanging real-time information between different entities involved in Hajj management, such as security forces, health services, and logistics. This helps coordinate responses seamlessly and ensures all parties work together in harmony.
    • Health and Safety Monitoring: AI and high-resolution cameras can go beyond simple monitoring to potentially detect early health indicators among pilgrims. This includes analyzing irregular walking patterns, repeated stopping, or detecting signs of fatigue or heat stress based on physical condition analysis, allowing for early medical intervention.
    • Personalized Pilgrim Guidance: AI-supported applications, such as Tawakkalna, can provide pilgrims with personalized and immediate guidance based on their real geographic location and the surrounding crowd status. This includes suggesting the best times to perform rituals to avoid severe congestion, indicating less crowded and safer routes, or even offering personalized health tips based on their condition and forecasts.
    • Improving Facility Dynamics: AI can contribute to improving the dynamics of transportation (like the Holy Sites Train and buses) and essential facilities by predicting congestion and suggesting alternatives.
    • Enhancing Guidance Strategies: AI can analyze crowd behavior in different locations to provide valuable insights for organizing entities. This helps in understanding common behaviors, identifying areas where pilgrims tend to stop and impede flow, and developing more effective cultural awareness and behavioral guidance campaigns.

    AI technologies, along with systems like “ميدان”, “بسري”, “سوهر”, “المدن الذكية”, and “روؤى”, are leveraged for data analysis and supporting decision-makers to enhance the quality of security and organizational performance in Hajj management. This integrated approach aims to ensure the safety, tranquility, and ease of the pilgrimage for millions of guests.

    Description
    Women’s High Waisted Biker Shorts Buttery Soft Yoga Shorts with Pockets 6″ Inseam Workout & Yoga Tights

    Securing the Hajj Pilgrimage

    Based on the provided sources and our previous discussion, security efforts during Hajj are incredibly comprehensive and are considered a primary focus for the Kingdom of Saudi Arabia. These efforts are vital for ensuring the safety, security, and tranquility of millions of pilgrims performing rituals simultaneously in a confined geographic area.

    Here’s a breakdown of the security efforts:

    • Overall Commitment and Priority: Ensuring the security and safety of the pilgrims is a fundamental commitment and a source of pride for the Kingdom’s leadership. It is considered a complex undertaking requiring immense resources, accumulated experience, and the latest technologies. The Kingdom has excelled globally in managing these large crowds with high professionalism.
    • Integrated Operations: Security and safety are managed through integrated efforts involving various security, military, and service agencies. These forces work together as one team under the oversight of officials like the Minister of Interior and the Director of Public Security. The Minister of Interior emphasizes the importance of integration between these entities, which has contributed to achieving positive results during the pilgrims’ arrival and movement through the holy sites. They review and implement security plans to ensure the tranquility and safety of pilgrims.
    • Leadership Oversight: High-ranking officials, including the Minister of Interior (who also heads the Supreme Hajj Committee) and the Director of Public Security (head of the Security Committee for Hajj), are directly involved in overseeing and reviewing security readiness and the implementation of plans. They hold meetings with security and military leaders participating in the Hajj mission.
    • Operational Security & Crowd Management:Security forces are strategically positioned throughout the holy sites and on routes to organize the movement of pilgrims and manage crowds. This includes surrounding vehicle roads and pedestrian paths.
    • Specific forces, such as the Special Emergency Forces and Facilities Security Forces, are tasked with crucial roles like organizing pedestrian flow, crowd management, and maintaining order, especially around critical areas like the Jamarat facility and train stations. The Minister of Interior specifically inspected the readiness of these forces.
    • Managing the density and movement of pilgrims between Arafat, Muzdalifah, and Mina, particularly during the stoning ritual at Jamarat, is a key security task. Improvements at the Jamarat facility, including multi-level access, escalators, and moving walkways, are designed to facilitate safe movement, supported by security oversight.
    • Technology Integration for Security:AI technology and high-resolution cameras are strategic tools explicitly mentioned for enhancing security and organizational performance during Hajj.
    • A vast network of high-resolution cameras, functioning as “vigilant eyes,” is used for real-time monitoring across the holy sites.
    • AI-powered analytical systems analyze crowd data, identify flows, monitor excessive densities, detect unusual behavior patterns, and predict potential congestion or bottlenecks. This enables rapid intervention and proactive management of human bottlenecks.
    • These systems help map out safety conditions by continuously analyzing crowd density and movement dynamics.
    • AI contributes to planning and simulation, accurately predicting human flow at each stage of Hajj (Mina, Mas’a, Mataf, Muzdalifah, Arafat) to optimize the allocation of human and logistical resources, including security personnel.
    • Control rooms equipped with AI-powered smart dashboards provide real-time data to officials, enabling immediate decision-making and issuing proactive alerts and recommendations to relevant authorities, reducing response time significantly. AI can even automatically direct field teams to areas needing urgent intervention.
    • AI can function as a unified platform for collecting and exchanging real-time information between different entities, including security forces, to coordinate responses seamlessly.
    • Combating Unauthorized Hajj:A major security effort is focused on preventing and addressing Hajj without permits. Adherence to regulations and obtaining Hajj permits is strongly emphasized as crucial for public interest, safety, and the smooth performance of rituals.
    • Performing Hajj without a permit is explicitly described as a serious Sharia violation due to its disregard for regulations and potential harm to public safety and order. It is considered a transgression against public interest and the instructions of the ruler.
    • Security forces actively monitor and apprehend individuals attempting unauthorized Hajj. They are described as being “in the lookout” for violators.
    • Strict penalties are enforced against those who attempt unauthorized Hajj and those who facilitate it, including fines (up to 20,000 SAR for individuals, up to 100,000 SAR per facilitator per violator), deportation, and entry bans into the Kingdom for specific periods (e.g., 10 years for those attempting unauthorized Hajj).
    • There are warnings against fraudulent Hajj campaigns and emphasis on using official channels and permits for safety and tranquility. Security efforts include identifying and addressing fake campaigns.

    In summary, security efforts during Hajj are multi-faceted, involving high-level commitment, integrated operations across various agencies, hands-on crowd management, strategic deployment of advanced technology (especially AI and cameras), and strict enforcement of regulations, particularly against unauthorized Hajj, all aimed at ensuring the safety and well-being of the pilgrims.

    Description
    Crossbody Bags for Women – Mini Phone Purses with Crossbody Strap and Wallet – Nylon Arm Bag for Women and Men

    Hajj Infrastructure and Services: Scale, Innovation, and Management

    Based on the provided sources and our conversation, the discussion on infrastructure and services during Hajj highlights the immense scale, strategic importance, and advanced implementation of the systems in place to ensure the safety, comfort, and spiritual journey of millions of pilgrims. These efforts are a source of pride for the Kingdom and are described as requiring gigantic efforts, huge capabilities, accumulated experience, and the latest technologies.

    Here’s a breakdown of the key aspects related to infrastructure and services:

    1. Overall Commitment and Scale:
    • The Kingdom’s leadership is committed to providing the highest level of services to the guests of the Rahman, making the Hajj journey purely spiritual.
    • Managing millions of pilgrims moving simultaneously in a limited geographic space is not an easy task and requires vast material and trained human capabilities. The Kingdom has excelled globally in managing these large crowds with high professionalism.
    • All services are available and facilitated at all stages of Hajj.
    1. Integrated Management and Oversight:
    • Service provision is managed through integrated efforts involving various security, military, and service agencies. This integration has contributed to positive results in pilgrim arrival and movement.
    • High-level officials oversee and review readiness and implementation of plans, emphasizing the importance of coordination between entities.
    1. Key Physical Infrastructure and Facilities:
    • The Holy Sites themselves (Mina, Arafat, Muzdalifah, Mas’a, Mataf) serve as the core geographical infrastructure.
    • Roads and pedestrian paths are part of the infrastructure, with security monitoring to organize movement and ensure safety.
    • Camps and accommodations are prepared to receive pilgrims in Arafat and Mina.
    • The Jamarat facility is a crucial piece of infrastructure for the stoning ritual, featuring multi-level access, escalators, and moving walkways designed to facilitate safe crowd movement. Security forces, like the Facilities Security Forces and Special Emergency Forces, are specifically tasked with organizing pedestrian flow and crowd management around it and train stations.
    • Transportation infrastructure includes the Holy Sites Train and buses. The train is highlighted as being ready for transporting pilgrims, with specific operational plans and delegation mechanisms to ensure smooth operation and safety. It consists of 17 carriages with a capacity of 3,000 passengers per train, achieving a collective capacity of 72,000 passengers per hour, operating with flexible movements at speeds up to 80 km/h.
    • Development projects are undertaken in the holy sites, such as the Jabal Al-Rahma shading project. This project involves innovative umbrellas and materials (reflecting over 47% of sunlight) to mitigate heat stress, enhance pilgrim comfort and health, and is part of efforts to enrich the pilgrim experience and enable rituals with ease.
    • In the context of readiness for the Eid period which overlaps with Hajj, sources also mention municipal efforts related to public interest markets, slaughterhouses, parks, gardens, and streets, including cleaning, monitoring, and beautification.
    1. Essential Services Provided:
    • Medical, ambulance, and supply services are provided in Arafat and throughout the holy sites with high readiness and integrated work plans.
    • The Ministry of Health’s 937 Call Center offers integrated health services 24/7 via a unified number. It is staffed by specialists speaking 7 languages (Arabic, English, French, Urdu, Indonesian, Turkish, Farsi) to facilitate communication with pilgrims of various nationalities. Services include medical consultations by doctors, receiving urgent reports, coordinating with health facilities, handling complaints, and assisting in finding missing or hospitalized pilgrims.
    • Innovative Medical Supply Chain: For Hajj 1446 AH, the Ministry of Health has activated drones and helicopters within the medical supply system in cooperation with NUPCO. Drones transport urgent medical items, reducing delivery time to certain facilities from an hour to about 5 minutes. Helicopters supply facilities in high-density areas to bypass traffic. These are considered pioneering initiatives in smart medical supply management for large crowds.
    • Food Services & Waste Reduction: The General Food Security Authority launched the “Hajj Without Waste” campaign to raise awareness about responsible consumption and reduce food loss and waste, contributing to food sustainability and reducing environmental/economic impacts.
    • Water and beverage distribution is mentioned, with AI helping optimize its allocation.
    • Guidance services are provided by teams and increasingly supported by technology.
    1. Technology Integration (AI, Cameras, Platforms):
    • AI technology and a vast network of high-resolution cameras are central to enhancing organizational performance and managing services.
    • These systems act as advanced analytical tools, analyzing human behavior data for crowd management, identifying flows, excessive densities, and predicting congestion to enable rapid intervention and proactive adjustment of movement.
    • AI contributes to planning and strategic simulation, predicting human flow at each stage to optimize the allocation of human and logistical resources, including distributing meals and water proactively.
    • It aids in optimizing resource allocation for services like ambulances, guidance teams, and water supplies, ensuring resources reach the right place at the optimal time.
    • AI provides real-time data via smart dashboards in control rooms, facilitating immediate decision-making and issuing proactive alerts and recommendations to relevant authorities. It can even automatically direct field teams to areas needing urgent intervention.
    • AI can serve as a unified platform for collecting and exchanging real-time information among different service entities (health, logistics) for seamless coordination.
    • AI-supported applications, like “Tawakkalna”, offer personalized guidance to pilgrims based on their location and crowd status, suggesting optimal times/routes to avoid congestion or providing personalized health tips. Tawakkalna specifically provides daily weather forecasts to help pilgrims plan their movements and rituals.
    • AI helps improve the dynamics of transportation (train, buses) and essential facilities by predicting congestion and suggesting alternatives.
    • Specific platforms mentioned in the Hajj Operations Center supporting data analysis and decision-makers for organizational performance include “Midan”, “Basri”, “Sohar”, “Smart Cities”, and “Ru’a”.
    1. Regulations and Compliance:
    • Adherence to regulations, instructions, and guidelines for Hajj organization is emphasized as crucial for public interest, safety, and the smooth performance of rituals. This adherence is seen as a religious and ethical duty.
    • Official platforms like “Nusuk” and “Tasreeh” are used for issuing Hajj permits, and Hajj companies are expected to cooperate to ensure pilgrims perform rituals safely and easily using official channels.
    • Municipalities intensify monitoring of facilities like markets and slaughterhouses to ensure they meet health and technical requirements before and during the Hajj/Eid period.

    In essence, the infrastructure and services for Hajj are not static but are being actively developed and enhanced, particularly through the strategic integration of technology like AI and drones, to manage the complexities of hosting millions while prioritizing pilgrim safety, health, and ease in line with the goals of the Guests of Rahman Program and Vision 2030.

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • Power BI Data Analysis and Visualization

    Power BI Data Analysis and Visualization

    This recording details a Power BI training session, progressing through four phases: data discovery and acquisition, data cleaning using Power Query, data modeling and the creation of measures using DAX, and finally, data visualization and report publishing to the Power BI service. The session uses an educational dataset and features multiple instructors guiding participants through each stage. Specific techniques covered include data cleansing, creating and modifying measures (both implicit and explicit), using hierarchies to improve data organization, applying themes for consistent report design, employing custom visuals and the Q&A feature, and leveraging co-pilot for report generation suggestions. The final segment focuses on sharing and collaboration within the Power BI service, including scheduling data refreshes.

    Power BI Beginner to Pro Study Guide

    Quiz

    Instructions: Answer the following questions in 2-3 sentences each.

    1. Why is the Power BI Beginner to Pro session re-recorded regularly?
    2. What is the primary reason organizations choose to use a tool like Power BI?
    3. What specific data is used in this year’s Power BI Beginner to Pro session?
    4. What is the Power Query Editor, and why is it important in Power BI?
    5. What is the difference between “null” and “blank” values in data, and why is it important in Power BI?
    6. What does DAX stand for and what is its function within Power BI?
    7. What is the report view in Power BI and what is it used for?
    8. What is a one-to-many relationship in Power BI data modeling, and how is it represented?
    9. What are implicit and explicit measures in Power BI, and what is the difference between them?
    10. What are some of the benefits of using hierarchies in Power BI data modeling?

    Quiz Answer Key

    1. The Power BI Beginner to Pro session is re-recorded regularly due to the frequent updates and changes that occur within the Power BI platform. These changes necessitate the re-recording of the sessions to provide the most up-to-date and accurate instruction to users.
    2. Organizations choose tools like Power BI primarily to make better data-driven decisions, ensuring that significant company choices are based on collected and analyzed data, allowing for better strategic planning.
    3. This year’s Power BI Beginner to Pro session uses education data focused on math and reading test scores, and the program simulates a national tutoring program to determine effectiveness. This data is not real and is for demo purposes.
    4. The Power Query Editor is a separate window within Power BI that is used for data cleaning, data preparation, and data transformations. It allows users to shape and modify data before loading it into the data model.
    5. A “null” value represents the absence of a value, while a “blank” value is an empty space, not the absence of data. Converting blanks to nulls is sometimes necessary for using Power BI transformations to properly replicate or filter data.
    6. DAX stands for Data Analysis Expressions and is the formula or coding language built into Power BI. It is used to create custom calculations, analyze data, and derive new insights from your data.
    7. The report view in Power BI is the primary interface where users create data visualizations. It contains the visualization pane with various chart options, and is where you build out a report made of one or more pages.
    8. A one-to-many relationship is a type of connection between two tables where one record in the first table can be related to multiple records in the second table. It is represented by a “1” on one table and an asterisk or star on the “many” side.
    9. Implicit measures are automatic aggregations that Power BI applies to numeric columns, like sum or average. Explicit measures are custom calculations created by the user with DAX, that provide more flexibility.
    10. Hierarchies in Power BI data modeling allow users to drill down from higher levels to lower levels of granularity for a more in-depth analysis. They enhance user experience and improve data exploration.

    Essay Questions

    Instructions: Write a short essay on one of the following topics.

    1. Discuss the different phases of the Power BI lifecycle, detailing the processes involved in each phase and their importance in the development of effective Power BI solutions.
    2. Explain the role of data preparation and cleaning within Power BI, including the use of the Power Query Editor, and analyze why it’s important for effective data analysis and visualization.
    3. Analyze the use of DAX in Power BI and how it allows users to create new calculated columns and measures. Describe how this improves analytical capabilities beyond standard visualizations.
    4. Explore the importance of data visualization in Power BI, providing several examples of good and poor visualization choices and their impact on the usability and understandability of a Power BI report.
    5. Explain the differences between reports and dashboards within Power BI, and discuss the advantages of publishing data to the Power BI service.

    Glossary

    • Data-Driven Decisions: Decisions based on data analysis, not personal feelings or guesses.
    • Power BI Desktop: A free, Windows-based application for building Power BI reports.
    • Power BI Service: The cloud-based version of Power BI where you publish reports and data.
    • Data Model: The structure of data in Power BI, including tables, relationships, and measures.
    • Power Query Editor: A data transformation tool within Power BI used to clean and shape data.
    • Null Value: The absence of a value in a data record.
    • Blank Value: An empty cell in a data record.
    • DAX (Data Analysis Expressions): The formula language used for creating calculated columns and measures.
    • Report View: The interface in Power BI Desktop for building data visualizations.
    • One-to-Many Relationship: A connection between tables where one record in a table may relate to many records in another.
    • Implicit Measure: A built in, automatic summarization or aggregation of data, by Power BI, based on the type of column used.
    • Explicit Measure: A custom calculated field created with DAX to derive new insights.
    • Visualizations: Graphical representations of data, such as charts and graphs.
    • Hierarchy: A way to organize related data that allows users to drill down from higher levels of summarization to greater levels of detail.
    • Theme: A predefined set of colors, fonts, and styles that you can apply to a Power BI report.
    • Conditional Formatting: Formatting data cells based on specific conditions, often using color scales to highlight significant data.
    • Custom Visual: Visualizations that have been created by Microsoft or community members that can be added to Power BI.
    • Tool Tip: A small box of information that pops up when you hover over a data point in a visual.
    • Semantic Model: A cloud-based database that represents a specific area of knowledge in a way that users can query it directly using natural language.
    • Workspace: A container in the Power BI service that holds reports, data, and other content.
    • My Workspace: Personal workspace for individuals to publish reports and data for personal use only.
    • Fabric: A Microsoft platform encompassing services like Power BI and Azure.
    • Co-Pilot: An AI assistant that helps users build reports, write DAX, or refine data.

    Power BI Training: Beginner to Pro

    Okay, here’s a detailed briefing document summarizing the key themes and ideas from the provided source, which is a transcript of a Power BI training session.

    Briefing Document: Power BI Beginner to Pro Training

    1. Introduction and Course Overview

    • Dynamic Nature of Power BI: The training emphasizes that Power BI is constantly evolving, requiring regular updates to training materials.
    • “powerbi changes on a very regular basis so because of those changes we have to re-record this session on a regular basis as well”
    • New Data Set and Multiple Trainers: This year’s session features a new educational data set and multiple trainers, offering diverse perspectives on the Power BI lifecycle.
    • “we’re bringing a new data set to the table through this session… we’re also going to have different teachers different trainers joining us”
    • Purpose of Power BI: The primary reason to use Power BI is to enable better data-driven decisions within an organization.
    • “the big reason why you’re going to choose a tool like powerbi is to help you and to help your organization make better datadriven decisions”
    • The Power BI Lifecycle: The course will walk users through the complete data cycle: collecting, organizing, presenting, and ultimately making decisions based on data.

    2. Core Components of Power BI

    • Power BI Desktop (Free): The primary tool for building reports, downloadable for free on Windows devices (with some caveats for Mac users).
    • “this is a free download which is amazing… you have to have a device that’s running Windows”
    • Data Collection: Data will be pulled from GitHub, a common repository platform.
    • “we have these conveniently stored over on GitHub… we are able to point to data on the web”
    • Power Query Editor: A separate window where data cleaning, preparation, and transformation occur.
    • “select transform data… that’s going to launch the power query editor for us”
    • “power query editor will only bring in a sample of your data about a thousand rows”
    • Data Modeling: Involves building relationships between multiple datasets using DAX calculations.
    • “in data modeling right that is where you are going to bring your nice cleaned up data from powerquery and then if you have multiple data sets you need to build a relationship”
    • “Dax is the language essentially your formula your coding language that is built into powerbi”
    • Report View (Data Visualization): This is where users create visuals (charts, tables, etc.) to represent the data.
    • “this is called your report View and here in your report view that is where you’re going to see your visualization pain”
    • Publishing and Sharing: The final phase where reports are made accessible to others.

    3. Data Cleansing and Preparation

    • Data Imperfections: The training emphasizes that real-world data is often messy and needs cleaning.
    • “data rarely comes to us in the format we need in for reporting… there are errors and consistencies”
    • Null vs. Blank Values: A distinction is made between “null” (absence of a value) and “blank” (an empty value). Null values are needed for certain transformations.
    • “nulls when you see null in your data that is the the absence of a value… when you see blank it’s like an imaginary space”
    • Replacing Blank Values with Null: Blank values are replaced with null to enable fill-down operations which allows for the replication of values in ragged reports.
    • “take those blank values and replace them with null… having it as a null value will help us”
    • Fill Down Transformation: A technique to replicate values down columns (used for District, City, State).
    • “we need to use that fill down option”
    • Creating Combined Columns: Using “Column from Examples” to combine city and state into a single, unique column (for map visualizations).
    • “column from examples… allows you to create a new column based on a sample value that you provide”

    4. Data Modeling and Relationships

    • Table Relationships: Building connections between tables (e.g., student data and test scores) to enable meaningful analysis.
    • “if I have a relationship between my tables there should be a line connecting”
    • One-to-Many Relationships: The concept of a relationship where one record in one table can relate to multiple records in another table (e.g. one student may have multiple test scores).
    • “A one to mini relationship just depends on the amount of the values that are in each of the columns”
    • Hiding Key Columns: Hiding ID or other identifying columns in the model as they may be confusing for report viewers.
    • “I typically like to hide my key columns because you’re not actually going to use them very often in your visuals”
    • Summarization Issues: By default, Power BI will automatically sum numeric values. It’s necessary to switch many of these to average, none, or other aggregations.
    • “by default powerbi is going to apply summarization… we can change that summarization”

    5. DAX Calculations and Measures

    • Implicit vs. Explicit Measures: Implicit measures (automatic calculations by Power BI) are contrasted with explicit measures (calculations written by the user).
    • “powerbi has created an implicit measure… we can also make explicit measures”
    • Basic DAX Formulas: How to write formulas using functions like AVERAGE, referencing tables and columns.
    • “I’m finding the average of my MTH score in my test T my test scores table”
    • Quick Measures: A feature that generates more complex DAX code for common calculations.
    • “quick measures are just an easier way to write decks… if you know what you’re looking for you can try quick measures”
    • Modifying Quick Measures: The ability to adjust and customize DAX code generated by quick measures to better fit reporting needs.
    • “you can alter these it’s not like a oneandone like you put it in there and that’s all there is to it”

    6. Hierarchies and Data Organization

    • Hierarchies: Creating drill-down paths for data exploration (e.g., state to district) to aid user interaction.
    • “you need to think about that very end user the last person who’s going to consume your data do you want them to have that capability to dive deep”
    • Folders: Organizing fields in the data pane for easier access and a cleaner workspace.
    • “I like to create folders for my specific different columns… it just makes it easier to create what I want to”

    7. Data Visualization Best Practices

    • Data Storytelling: Framing reports to convey a specific message through a series of impactful visuals.
    • “data storytelling comes into play here… framing your report to convey a certain message”
    • Focusing on Key Questions: The need to focus on 3-4 key questions a report should answer.
    • Appropriate Visual Selection: Discussing the types of visuals to be used for different purposes.
    • Visual Formatting: Utilizing themes, borders, radius, colors to make visuals more impactful.
    • “a border will literally draw a line around your report visuals… radius is actually going to take your visualization… and round the corners”
    • Custom Backgrounds: Using a background image to guide report design and visualization placement.
    • “bring in your own custom backgrounds… it’s already designed to help us visualize where things go”
    • Data Labels and Details: Adding labels, details, and tooltips to make visuals more informative.
    • “this is actually going to Auto but if I had Millions I could change it to millions billions trillions of dollars thousands… I can see that it’s letting me know the exact value”
    • Conditional Formatting: Applying formatting based on data values to highlight important information (gradients).
    • “conditionally format this background color easiest way to go about this is a gradient”

    8. Power BI Service and Sharing

    • Power BI Service: The web version of Power BI, for publishing and sharing reports.
    • “powerbi service is really just the web version of powerbi… it’s safe secure”
    • Workspaces: Organizing reports and data within the service.
    • “a workspace this is where you are able to publish all of your reports”
    • License Levels: The differences between Power BI Pro and Premium licensing.
    • “there are two main license levels to have which are powerbi pro… and then there is powerbi premium”
    • Sharing Reports: Various options for sharing a report to different groups or individuals.
    • “with sharing I have the ability to give access to this report to really anyone I want”
    • Dashboards vs Reports: The distinction between dashboards and reports, with dashboards being a curated view of multiple reports.

    9. Advanced Features and Tools

    • Custom Visuals: Exploring third party visuals for advanced visualization needs.
    • “we have a wide range of custom visuals that can be found under this option right here it’s called get more visuals”
    • Q&A Functionality: Using natural language queries to generate visuals and explore data.
    • “with Q&A I also have the ability to tell it what visual I want”
    • Tooltips: Custom tooltips to show more detailed information on hover.
    • “a tool tip is a reflection of that X and Y AIS… you can customize it”
    • Co-Pilot Integration: Using AI for report design.
    • “using AI to give you the ability to create a report using co-pilot functionality”
    • Content Suggestion Using AI to provide recommendations for future development.
    • “we’re going to get some ideas of maybe what direction we could potentially go”
    • Accessibility: Prioritizing accessibility during report development.
    • “make a much better report if you design with everybody in mind regardless of their accessibility needs”

    10. Key Questions to be Answered in the Course:

    • Which school districts are doing best?
    • What state has the best reading scores?
    • Is tutoring having a positive impact?
    • What is the impact of extracurriculars?

    Overall Theme

    This training session is a practical guide to using Power BI for data analysis and visualization. It emphasizes a structured approach, from data cleaning to creating actionable insights. It balances fundamental concepts with more advanced techniques, like DAX and custom visuals. The introduction of AI tools for report generation suggests a future direction for Power BI and data analysis.

    Let me know if you have any other questions or would like any part expanded!

    Power BI: Beginner to Pro Guide

    FAQ: Power BI Beginner to Pro

    • Why should I choose Power BI as a data analysis tool? Power BI helps you and your organization make better data-driven decisions. It allows you to collect, organize, and present data to inform significant decisions within the company. This is crucial for solving business problems effectively and making strategic choices backed by evidence.
    • What is the Power BI lifecycle, and what are the different phases involved? The Power BI lifecycle consists of four main phases. First, Data Acquisition, where you connect to various data sources. Second, Data Modeling, where you clean and prepare your data using Power Query, build relationships between tables, and perform calculations with DAX. Third, Data Visualization, where you build reports using visuals. And finally, the Publishing phase, where you share reports for others to use and make decisions.
    • What is Power BI Desktop and how do I get it? Power BI Desktop is a free Windows application that allows you to build Power BI reports. You can download it directly from the Microsoft Store or the provided link. If you are using a Mac you would need to use another program that allows you to run Windows. The Microsoft Store version is recommended since it stays up to date with monthly updates, but there are also other ways your organization may provide it for you.
    • What is Power Query, and why is it important? Power Query is a data transformation tool within Power BI. It allows you to clean, shape, and prepare your data by correcting errors, inconsistencies and applying transformations. It is important because data rarely comes in the exact format needed for reporting, so you will always need to modify it and get it report-ready within Power Query.
    • What is DAX, and how is it used? DAX, or Data Analysis Expressions, is the formula language within Power BI used to perform calculations and create custom measures. DAX is very similar to Excel formulas. You can use DAX for everything from complex statistical analysis, to creating a new column, to defining how something sums. It is a powerful language for enhancing your data models.
    • What’s the difference between a null value and a blank value? A null value represents the absence of a value in a field. A blank value is like an empty space. When Power Query encounters blanks it will not allow you to use certain transforms to help fill in missing values. You typically need to convert blanks to nulls to use specific Power Query transforms such as fill down.
    • What are hierarchies in Power BI, and how are they useful? Hierarchies in Power BI allow you to group data into levels for drilling down. For example, a calendar hierarchy would consist of Year > Quarter > Month > Day. Similarly, you could have a geography hierarchy such as State > District. This grouping enables end users to navigate data from broad categories to more detailed ones very easily and intuitively.
    • How do you share Power BI reports with others, and what are workspaces? To share a Power BI report you need to publish your work into a workspace in powerbi.com. Workspaces are like folders in the cloud for publishing reports. There are a couple of licenses available (Power BI Pro and Power BI Premium), each offering different capabilities. Inside workspaces you are able to share your work, manage access, and organize reports. Every user has an individual workspace called “My Workspace” where they can develop reports that are for their own use.

    Learn with the Nerds: Power BI Beginner to Pro

    The provided sources discuss a Power BI training session, “Learn with the Nerds Power BI Beginner to Pro,” which covers various aspects of using Power BI, from planning a project to sharing the results [1, 2]. Here’s a breakdown of the training:

    • Course Overview: The training is designed to guide users from a beginner level to a more proficient level in Power BI. It uses a new educational data set and features multiple trainers [1]. The course aims to help individuals and organizations make better data-driven decisions [1].
    • Training Agenda: The session is divided into several key areas [2]:
    • Planning and Design: This initial phase focuses on the importance of planning a Power BI project before beginning any work in the tool. It emphasizes defining the end goal and understanding what data is needed to achieve that goal [2, 3].
    • Data Cleansing and Shaping: This section covers how to connect to data sources and ensure the data is accurate, using the Power Query Editor [2, 4].
    • Data Modeling: The training covers how to organize data, create relationships between different data sources, and use DAX (Data Analysis Expressions) [2].
    • Data Visualization: This is the part of the training that focuses on how to build engaging reports, use storytelling capabilities, and use the co-pilot feature [2].
    • Data Sharing: The final section shows how to share results, schedule data refreshes, and set security measures [2].
    • Key Concepts and Tools Covered:
    • Power BI Desktop: The training focuses on using the Power BI Desktop application, which is a free download for Windows users [5, 6].
    • Power Query Editor: This tool is used for data cleansing and shaping [4]. It is a separate window that opens within Power BI [7].
    • Data Modeling: Involves creating relationships between tables and building a strong data model for data accuracy and consistency [2, 8, 9].
    • DAX: A formula language used for calculations in Power BI [2, 10, 11].
    • Power BI Service: The web version of Power BI (powerbi.com), where reports are published for sharing and collaboration [12, 13].
    • Workspaces: Used to organize reports and data in the Power BI service. Each user has a personal workspace called “My workspace” [14, 15]
    • Hands-On Activities: The training involves practical steps such as connecting to data sources, using the Power Query editor, building visualizations, and sharing reports [7, 16-20].
    • Importance of Data Cleansing: The training emphasizes the importance of cleaning and preparing data before creating visualizations to avoid errors in reporting [4, 7].
    • Importance of Planning: The training emphasizes that beginning a project with a plan, including knowing the end goal and what you are trying to achieve, is essential to avoid wasting time [3].
    • Data Storytelling: The training also emphasizes framing the report to convey a message and focusing on key questions that the data can answer [21].
    • On-Demand Learning: The training session is part of a larger on-demand learning platform, offering various courses on Power BI including advanced data shaping, data modeling, and DAX [8, 22-27]. The source mentions that the on-demand platform has free courses, as well as paid classes that can be accessed for free for a limited time [28].
    • Preview Features: The training uses the “on-object interaction” preview feature in Power BI, to enhance the interface of the tool [16, 29, 30].
    • Custom Visuals: The training shows how to add custom visuals from the marketplace for a unique look and functionality [31].
    • Q&A Feature: The Q&A feature is highlighted as a way to interact with data by asking questions in plain language [32, 33].
    • Tooltips: The use of custom tooltips in Power BI is shown as a way to display additional information when hovering over a visual [34].
    • Co-pilot: The training shows how co-pilot can build a whole page for a report based on a request, but this feature requires a special license [26, 35].
    • Licensing: The training mentions different licensing levels such as Power BI Pro and Power BI Premium, with premium recently being renamed Fabric [14, 15].
    • Accessibility: The training highlights the importance of accessibility and offers information about color blind themes [25].

    Power BI Data Visualization Training

    The sources provide extensive information on data visualization within the context of Power BI training [1, 2]. Here’s a detailed discussion of data visualization based on the sources:

    • Importance of Data Visualization: The training emphasizes that while Power BI is a data visualization tool, there’s much more to it than just building visuals [1]. Effective data visualization is crucial for engagement and for making informed, data-driven decisions [1, 3]. Poorly visualized data can lead to low report usage and a failure to convey important insights [3].
    • Data Storytelling: The training promotes the concept of data storytelling, which involves framing a report to convey a specific message and focusing on key questions the data can answer [4]. Instead of just randomly creating visuals, it is important to plan a report to answer specific questions [4, 5]. The training suggests focusing on 3 to 4 key questions per report to avoid overwhelming the audience [4, 5].
    • Best Practices for Visual Creation:
    • Plan Beforehand: It is essential to have a plan before creating visuals, including wireframing the layout [4-6]. This involves considering the placement of different types of visuals [6].
    • Start with Key Questions: When building visualizations, focus on the key questions that need to be answered by the data [4, 5]. For example, in the context of the educational dataset used in the training, questions might include: What school district is performing best? What state has the best scores? Does tutoring have a positive impact? How do extracurriculars affect test scores [4]?
    • Limit Visuals per Screen: It’s recommended to have around 3 to 4 main visuals per report page, along with slicers and other smaller elements [5]. Too many visuals can overwhelm users and make it difficult to extract meaningful insights [5, 7].
    • Use Data Labels: Adding data labels to visuals is an easy way to add more information to your report [8]. Details can be added to labels to show other data like tutoring hours [9].
    • Formatting: Power BI provides a variety of formatting options that include the ability to make changes to the background, font, and colors [8, 10, 11]. Using a border with a radius of 25 pixels is suggested to give a smooth look to visuals [11].
    • Themes: Themes allow you to quickly apply a set of formatting options to an entire report, which provides consistency throughout a report [10, 11].
    • Types of Visuals:
    • Standard Visuals: Power BI provides a variety of built in visuals such as bar charts, line charts, pie charts, tables, and matrices [12-14].
    • Custom Visuals: In addition to the standard visuals, users can add custom visuals from the marketplace, including a text filter that allows a user to search for data by text [6, 15].
    • Q&A Visual: The Q&A feature is an AI-driven tool that can create visuals based on questions asked in plain language [16]. Users can type questions to get data displayed as a visual [16, 17]. This feature can be used to quickly build visuals or to get ideas when you are unsure what you want in your report [16, 17].
    • Tooltips: Custom tooltips can be created to provide additional information when hovering over a visual [18]. Tooltips can be used to filter visuals on a page [18, 19].
    • Data Modeling and Visuals: The training emphasizes the need to have a strong data model before beginning to build visualizations [20, 21]. Testing the data model by creating visuals and making adjustments where necessary is emphasized [22]. Measures and calculations performed in data modeling are crucial for accurate visualizations [23-25].
    • Summarization: By default Power BI will summarize data, but sometimes, especially with scores, an average is more appropriate than a sum [23].
    • Hierarchies: Hierarchies allow the user to drill down into the data and see more granular information such as states and districts [26, 27]. Hierarchies can also be used to organize fields [14, 28].
    • Measures: The training highlights the use of both implicit and explicit measures. Power BI will automatically create implicit measures, but you can also create explicit measures by using DAX to perform calculations on your data [23, 24].
    • Co-pilot: Power BI’s co-pilot feature can be used to create visuals. Co-pilot can also suggest content and create a whole report page based on a data model and a user prompt [19, 29, 30]. Co-pilot, while a useful tool for creating visualizations, should always be reviewed by the user to ensure that it is accurate and meets user requirements [30].
    • Interaction Between Visuals: By default, visuals interact with each other in a Power BI report, so when you select a data point in one visual, other visuals will be filtered to reflect that selection [17].

    In summary, the training highlights the importance of thinking strategically about data visualization and how it can be used to effectively communicate the meaning behind data. Effective data visualization involves planning, asking key questions, leveraging available tools, and understanding how a strong data model leads to accurate and useful reports.

    Power BI Data Modeling

    The sources provide detailed information on data modeling within the context of Power BI training. Here’s a comprehensive discussion of data modeling based on the sources and our conversation history:

    • Importance of Data Modeling: The training emphasizes that building a strong data model is crucial for an effective Power BI report [1]. A well-structured data model ensures performance optimization, data accuracy, consistency, scalability, easier maintenance, and enhanced usability [1]. The training also highlights the fact that data modeling is not a one-time activity, but an ongoing process as you continue to build a report [1].
    • Data Schemas: The training mentions two main types of data schemas:
    • Star schema: This basic blueprint consists of a central fact table with dimension tables branching off it [1].
    • Snowflake schema: This is an extension of the star schema where dimension tables branch off of other dimension tables, creating a snowflake effect [1].
    • Key Components of Data Modeling:
    • Tables: Data models usually consist of multiple tables [2]. The training uses two tables, one with test scores and one with student information, as an example [2, 3].
    • Relationships: Building relationships between tables is essential to connect data and allow for proper filtering and analysis [4, 5]. Relationships are created based on columns that are common to both tables, like student ID in one table and student number in another [5]. The columns used to create a relationship must have the same data type [5].
    • Cardinality: The relationship type, such as one-to-many, depends on the values in the columns [6]. In a one-to-many relationship, one table has unique values, while the related table can have multiple instances of the same value [6].
    • Cross-filter direction: This describes the direction that filters will flow from one table to another [6].
    • Data Types: The training highlights the importance of setting the correct data types for columns, such as text, whole number, decimal number, date, etc [7, 8]. Data types can be modified in the Power Query editor [8].
    • Data Preparation:
    • Power Query Editor: This tool is used for cleaning and transforming data [9, 10]. It allows users to modify data types, rename columns, remove errors, and fill in blanks [8, 9]. The Power Query editor is a separate window that opens within Power BI [10, 11].
    • Column from examples: This Power Query feature can be used to create a new column based on a sample value you provide [12, 13].
    • Data Profiling: The Power Query editor has options to view column quality, distribution, and profiles [7, 11]. The data profiling should be set to “entire dataset” when you are doing your data prep, but set back to “top 1,000 rows” when you are done [7].
    • Data Organization:
    • Hierarchies: Hierarchies allow you to group fields of information for drill-down interaction in visualizations [14, 15]. A hierarchy can be created to allow for the user to see information at a high level and then drill down to more granular detail [14]. For example, a geographical hierarchy can be created that goes from state to district [15].
    • Folders: Folders are used to organize fields within a data pane, grouping similar fields such as math scores and reading scores, into separate folders [16]. Sub-folders can be created by using a backslash in the folder name [16].
    • Measures and DAX:
    • Implicit Measures: Power BI automatically creates implicit measures, usually sums or averages [17].
    • Explicit Measures: Explicit measures are created using DAX (Data Analysis Expressions), which is the formula language for Power BI [17, 18]. DAX can be used to create custom calculations that are more efficient and quicker than implicit measures [17]. DAX can be written in the formula bar [17].
    • Quick Measures: Power BI has quick measures that allow you to do simple calculations by selecting a measure and a category [19].
    • Modifying DAX: The DAX from a quick measure can be modified to better suit the user’s needs [19].
    • Testing the Data Model: The training emphasizes that it is important to test the data model by creating visuals and checking the results, making changes as needed [4]. Building visuals as you create the data model allows you to see any issues in the way your tables are connected and formatted [19].
    • Data Modeling and Visualizations: Changes made in the data model will affect how visuals appear [6, 20]. For example, changing a summarization of reading scores to the average reading score will affect the display of the data [20]. It is also important to make sure you have relationships built between your tables so that the correct data is being displayed in visuals [4].
    • Best Practices:
    • Use proper capitalization, spelling, punctuation, and spacing when building your data model [21].
    • Be consistent when pluralizing table names [21].
    • It is best practice to rename a column in the Power Query editor rather than after you have loaded the data [22].
    • When adding or changing something on the data model, test it out with a visual [4].

    In summary, the training highlights the importance of a well-structured data model as the foundation for effective Power BI reports. It also emphasizes the need for continuous testing and refinement of the data model through data visualization as well as making effective use of Power Query editor, relationships, measures, and DAX calculations to create a reliable and accurate data model.

    Power BI Data Cleansing Techniques

    The sources provide extensive information on data cleansing within the context of Power BI training. Here’s a detailed discussion of data cleansing based on the sources:

    • Importance of Data Cleansing: The training emphasizes that data cleansing is a critical, but often overlooked, part of the report development life cycle. It is essential to ensure the data is accurate and in the optimal format for reporting. Neglecting this step can lead to inaccurate reports and a lack of trust in the data, as even a single incorrect data point can undermine the credibility of an entire report [1].
    • Power Query Editor: The primary tool for data cleansing in Power BI is the Power Query Editor, which opens as a separate window [2]. It allows users to connect to various data sources and then clean and shape that data [1].
    • The Power Query editor shows a preview of the data (approximately the top 1,000 rows) and allows the user to apply transformations to this sample. This is beneficial for performance when working with large datasets [3, 4].
    • The Applied Steps pane in the Power Query Editor is a crucial feature that tracks each transformation step. It allows you to delete or modify any step. Power Query does not have an undo button, so it is important to use this pane to make changes [4].
    • The formula bar shows the M code for each transformation step. Although users do not need to know M code to clean data, they can use the formula bar to become familiar with it [4, 5].
    • The query settings pane can be turned on or off in the view menu, as can the formula bar [5].
    • Data Source Connection: The process begins by connecting to a data source using the “Get Data” button. Power BI offers a variety of connectors, including web, Excel, SQL server, and more [2].
    • When connecting to a web source, you might need to provide credentials, but in some cases, an anonymous connection is sufficient [6].
    • After connecting to a data source, users have the option to “Load” the data directly into Power BI or “Transform Data” which opens the Power Query Editor [6]. The “Transform Data” option is the correct choice when data cleansing is needed [3, 6].
    • Common Data Cleansing Tasks:Renaming Queries: It’s a best practice to rename queries to make them more descriptive. Queries can be renamed in the query settings pane or by double clicking in the queries pane [7].
    • Data Type Modifications: Columns have data types (e.g., text, number, date). The training emphasizes the need to verify and change the data types when necessary using the column header or the ribbon [7].
    • Handling Null and Blank Values: Null values represent the absence of a value, while blank values are essentially empty spaces [8]. It is important to replace blank values with null values, because it can cause problems with filtering and slicing data in reports [9].
    • Filling Down Values: The “Fill Down” function is used to propagate non-blank values down through a column, but it requires that blanks first be replaced by nulls. Sorting is important when using fill down to make sure values are replicated correctly. This can be helpful when working with ragged hierarchical data [9, 10].
    • Merging Columns: The training shows how to merge data from multiple columns into a single column using the “column from examples” function [11].
    • Removing Unnecessary Data: Unnecessary data should be removed to make the model more efficient and accurate [12].
    • Applying Changes:Once data cleansing is complete, the user can “Close & Apply” to load the cleaned data into the Power BI data model [11, 12]. This action applies all the transformation steps to the entire dataset, not just the sample that is shown in Power Query [12].
    • The data will then show in the data pane on the right of the screen where you can begin to build your visuals. Data cleansing can also be done after data has been loaded [12].
    • Column order in Power Query does not affect column order in the Power BI data model [11, 12].

    In summary, the training emphasizes that data cleansing is a vital first step when building Power BI reports. It involves using the Power Query Editor to connect to data sources, clean and shape the data, and load it into Power BI’s data model to ensure reliable data that is ready for analysis and reporting.

    Power BI Data Sharing and Collaboration

    The sources provide detailed information about data sharing within the context of Power BI training. Here’s a comprehensive discussion of data sharing based on the sources:

    • Importance of Data Sharing: The training emphasizes that the full potential of Power BI is realized when reports are shared and collaborated on with others using the Power BI service (powerbi.com) [1]. The Power BI service is a web version of Power BI and is the place where you can share, collaborate, set security, and schedule data refreshes [1, 2].
    • Publishing to the Power BI Service:The process of data sharing begins by publishing a completed Power BI report from the desktop application to the Power BI service by using the “Publish” button [1, 3]. When a report is published, both the report and its underlying data (semantic model) are uploaded to the cloud service [2].
    • Workspaces are used to organize reports and datasets in the Power BI service [2]. Workspaces help to keep items contained together and make them easier to find [4]. There are two main types of workspaces [2]:
    • My workspace: This is a personal space for individual users to practice and track reports. Sharing is not possible from “My Workspace” [4, 5].
    • Standard workspaces: These are designed for sharing and collaboration [4, 5].
    • During publishing, the user is prompted to save the report. The page that is active when the save button is clicked will be the first page of the report in the Power BI service [3].
    • After publishing, the Power BI service offers a link directly to the published report and an option to view quick insights [6].
    • Quick insights are automatically generated visualizations that may be useful to include in reports or dashboards [6]. These insights can be pinned to a dashboard [6, 7].
    • If a user wants to use a quick insight in a report, they will need to recreate the visual within Power BI desktop and publish the report with that visual [6].
    • Licensing: There are two main license levels that determine features in the Power BI service [2].
    • Power BI Pro is a lower-level license [2].
    • Power BI Premium is a higher-level license with more features [2].
    • Fabric is the new name for the premium license [4].
    • Sharing Reports:Reports can be shared with individuals, groups, or an entire organization [5, 8].
    • When sharing, you can allow users to share the report and build new content [5].
    • Reports can be shared through direct access, a copied link, or through Microsoft Teams [5].
    • Sharing with groups can simplify the process of giving access to many people [5]. Groups are based on Azure Active Directory (now called Entra ID) [5].
    • Data Refresh:Data refresh ensures that reports reflect the latest data by updating the data sources [1, 9].
    • Data refresh is set up at the semantic model level, which means that data is updated for all reports built off the same model [9].
    • The user can set up a refresh schedule on a daily or weekly basis [10].
    • The frequency of the refresh can be determined by how often the data source is updated [10].
    • If data is coming from the web, the refresh process is simple, if data is coming from the desktop, a gateway is required [10, 11].
    • The number of refreshes per day depends on the type of license. Pro licenses are limited to eight refreshes per day while higher-level licenses allow 48 refreshes per day [10].
    • When a data refresh breaks, the user will get a notification by email so that they can fix the issue [11].
    • Dashboards: Dashboards are different than reports [7].
    • Dashboards allow users to combine data from multiple reports into a single view [7].
    • Dashboards are a higher level view than a report, and can be useful for executives who want a quick overview of important data from different sources [7].
    • Other Sharing Options: There are other ways to share, such as sharing with Power BI apps and sharing at the workspace level [9].
    • Editing in the Power BI Service:Users can make quick edits directly in the Power BI service, though it is generally preferred to do complex editing in Power BI Desktop [8, 12].
    • When a report is edited in the service and then the user wants to go back into the desktop to work with the data model, the PBX file must be downloaded from the Power BI Service [8].
    • Export Options: In addition to sharing, users can export data to Excel, or export to PowerPoint for presentations [8].
    • Collaboration: The Power BI service is designed for collaborative work [1, 5].

    In summary, the training emphasizes that sharing and collaboration are crucial for leveraging Power BI’s capabilities. This is facilitated by publishing to the Power BI service, managing workspaces, setting up data refreshes, and sharing reports with others. Understanding these processes ensures that data insights are accessible and up to date.

    ULTIMATE Power BI Tutorial Beginner to Pro Course (2024)

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • چنے کی دال اور بیف گوشت پکانے کی مکمل ترکیب اور کیسے پکانا ہے

    چنے کی دال اور بیف گوشت پکانے کی مکمل ترکیب اور کیسے پکانا ہے

    چنے کی دال اور بیف گوشت ایک نہایت مزیدار اور مقوی سالن ہے جو عام طور پر پاکستانی اور شمالی بھارتی کھانوں میں شوق سے کھایا جاتا ہے۔ نیچے مکمل ترکیب، اجزاء اور پکانے کا طریقہ تفصیل سے بیان کیا گیا ہے۔

    🌟 چنے کی دال اور بیف گوشت پکانے کی مکمل ترکیب

    📝 اجزاء:

    گوشت کے لیے:

    • بیف گوشت (بون لیس یا ہڈی والا): ½ کلو (500 گرام)
    • ادرک لہسن پیسٹ: 1 کھانے کا چمچ
    • نمک: حسبِ ذائقہ
    • ہلدی پاؤڈر: ½ چائے کا چمچ
    • لال مرچ پاؤڈر: 1 چائے کا چمچ (یا ذائقہ کے مطابق)
    • دھنیا پاؤڈر: 1 چائے کا چمچ
    • زیرہ پاؤڈر: ½ چائے کا چمچ
    • ٹماٹر: 2 درمیانے، باریک کٹے ہوئے
    • پیاز: 1 بڑی، باریک کٹی ہوئی
    • ہری مرچ: 2-3 عدد، باریک کٹی ہوئی
    • دہی: 3 کھانے کے چمچ (اختیاری، گوشت گلانے کے لیے)
    • تیل یا گھی: ½ کپ

    دال کے لیے:

    • چنے کی دال: 1 کپ (200 گرام)
    • نمک: حسبِ ذائقہ
    • ہلدی: ¼ چائے کا چمچ
    • پانی: دال اُبالنے کے لیے

    گارنش کے لیے:

    • ہرا دھنیا: باریک کٹا ہوا
    • ہری مرچ: 2 عدد
    • لیموں کے ٹکڑے: حسبِ ضرورت

    🍳 پکانے کا طریقہ:

    مرحلہ 1: چنے کی دال ابالنا

    1. چنے کی دال کو 2 سے 3 گھنٹے کے لیے بھگو دیں۔
    2. دال کو پانی میں ڈال کر ہلدی اور تھوڑا سا نمک ڈال کر اُبال لیں جب تک وہ گل جائے لیکن بالکل نرم نہ ہو، کیونکہ بعد میں سالن میں مزید پکے گی۔
    3. اُبلی ہوئی دال کو چھان کر رکھ لیں۔

    مرحلہ 2: گوشت بنانا

    1. ایک دیگچی میں تیل گرم کریں۔
    2. اس میں پیاز ڈالیں اور ہلکا سنہری ہونے تک بھونیں۔
    3. اب ادرک لہسن پیسٹ ڈال کر ایک منٹ تک بھونیں تاکہ کچا پن ختم ہو جائے۔
    4. پھر گوشت ڈالیں اور اچھی طرح بھونیں (تقریباً 8–10 منٹ) جب تک گوشت کا رنگ تبدیل ہو جائے۔
    5. اب تمام مصالحے (نمک، ہلدی، لال مرچ، دھنیا، زیرہ) ڈالیں اور اچھی طرح مکس کریں۔
    6. ٹماٹر اور دہی شامل کریں اور ڈھک کر ہلکی آنچ پر پکنے دیں تاکہ ٹماٹر گل جائیں اور تیل مصالحے سے الگ ہو جائے (تقریباً 10 منٹ)۔
    7. اگر گوشت سخت ہے تو تھوڑا سا پانی ڈال کر پریشر ککر میں 15 منٹ یا ہلکی آنچ پر 30–40 منٹ گلنے تک پکائیں۔

    مرحلہ 3: دال شامل کرنا

    1. جب گوشت گل جائے اور مصالحہ تیار ہو جائے تو اس میں ابلی ہوئی چنے کی دال شامل کریں۔
    2. 1 کپ پانی شامل کریں (یا جتنا گاڑھا یا پتلا سالن پسند ہو) اور درمیانی آنچ پر 10–15 منٹ پکائیں تاکہ دال گوشت کے ساتھ اچھی طرح مکس ہو جائے۔
    3. آخر میں ہری مرچ اور ہرا دھنیا شامل کر کے دم پر رکھ دیں (5 منٹ)۔

    🥘 پیشکش:

    • گرما گرم چنے کی دال گوشت کو نان، تندوری روٹی یا چاول کے ساتھ پیش کریں۔
    • اوپر سے لیموں نچوڑ لیں اور کچومر یا رائتہ ساتھ رکھیں تو ذائقہ دوبالا ہو جاتا ہے۔
    Dal Gosht Recipe | Beef Dal Gosht Secret restaurant recipe | بیف دال گوشت | By BaBa Food Chef Rizwan

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • Signs Your Ex Has An Avoidant Attachment Style, Signs They’re The Anxious Type

    Signs Your Ex Has An Avoidant Attachment Style, Signs They’re The Anxious Type

    They vanished just when things were going well—or maybe they clung too tightly from the very beginning. Relationships often leave us with more questions than answers, especially when they end in confusion or emotional chaos. If you’ve ever wondered why your ex behaved in ways that seemed contradictory, emotionally distant, or overwhelmingly intense, you may have been dealing with someone exhibiting either avoidant or anxious attachment styles.

    Attachment theory, first conceptualized by psychologist John Bowlby, has become a cornerstone in understanding adult relationships. Avoidant and anxious attachments are two distinct yet frequently encountered styles that heavily influence how individuals give and receive love. These patterns, often formed in childhood, shape our romantic experiences and can dictate the success—or failure—of our partnerships. Understanding these styles isn’t just a way to make sense of the past; it’s a crucial step toward healthier relationships in the future.

    In this post, we’ll explore 20 tell-tale signs that your ex may have exhibited an avoidant or anxious attachment style. Whether you’re reflecting on a past breakup or seeking insight into attachment theory, these signs will offer clarity. By identifying these behaviors, you’ll not only find emotional validation but also equip yourself with the psychological literacy needed to navigate future relationships with wisdom and awareness.


    1- Emotionally Withdrawn After Intimacy

    One of the most unmistakable signs of an avoidant attachment style is emotional withdrawal after periods of closeness. If your ex seemed available and loving during moments of intimacy but quickly became distant or aloof afterward, it’s likely they were experiencing emotional discomfort rooted in fear of engulfment. Avoidants crave connection but fear dependence, which often leads to them pulling away just as vulnerability starts to deepen.

    This pattern can be disorienting for partners, who may interpret the retreat as disinterest or rejection. As attachment theorist Amir Levine explains in Attached: The New Science of Adult Attachment, avoidants “equate intimacy with a loss of independence.” Understanding this behavior through the lens of attachment science helps us avoid personalizing actions that are, in fact, deeply ingrained defense mechanisms.


    2- Hyper-Focused on Your Reactions

    On the flip side, an anxious ex may have appeared excessively tuned into your moods and reactions, often overanalyzing your every word or gesture. This hyper-vigilance stems from a deep-seated fear of abandonment. They might have constantly sought reassurance or interpreted neutral behavior as signs of disinterest, leading to frequent emotional turbulence in the relationship.

    Dr. Sue Johnson, a pioneer in emotionally focused therapy, notes that anxious partners often experience a “constant state of alarm,” fearing relational instability. This hypersensitivity can create cycles of neediness and reassurance-seeking that ultimately strain both partners. Their actions, while rooted in a desire for connection, often drive the very disconnection they fear.


    3- Difficulty Expressing Feelings

    Avoidant individuals frequently struggle to articulate their emotions, often appearing stoic or detached. This isn’t due to a lack of feeling, but rather an ingrained discomfort with emotional expression. If your ex shut down during important conversations or deflected emotional topics, they may have been employing distancing strategies to maintain control and self-protection.

    As Dr. Stan Tatkin notes in Wired for Love, avoidants are typically “more comfortable with logic than emotion.” Their reluctance to engage emotionally can leave their partners feeling isolated and unseen. Recognizing this communication barrier is key to understanding the emotional disconnection in your relationship.


    4- Over-Communicating and Over-Sharing

    An anxious ex might have overwhelmed you with constant communication—texts, calls, or deep emotional disclosures early in the relationship. This behavior often stems from a desire to quickly secure attachment and prevent perceived threats of abandonment. While it may initially feel flattering, it can quickly become intense and unsustainable.

    Psychologist Margaret Mahler described this behavior as “emotional enmeshment,” where personal boundaries blur due to fear of separation. This can lead to a suffocating dynamic where the anxious partner’s need for closeness inadvertently drives the avoidant partner away, reinforcing both of their insecurities.


    5- Fear of Commitment

    A classic hallmark of avoidant attachment is fear of long-term commitment. Your ex may have expressed love and affection but hesitated when discussions turned to the future. They might have resisted labels, cohabitation, or plans that implied long-term involvement.

    This resistance is often less about the partner and more about the ex’s internal belief system. According to The Attachment Theory Workbook by Annie Chen, avoidants often associate commitment with loss of freedom or autonomy. Understanding this can provide peace of mind when interpreting seemingly inconsistent behavior.


    6- Clinginess and Jealousy

    In contrast, an anxious partner might have exhibited intense jealousy or clung tightly to the relationship, fearing its potential loss. This often manifested in checking your whereabouts, questioning your intentions, or needing constant reassurance about your feelings for them.

    Jealousy in this context is more about insecurity than possessiveness. It reveals a deep yearning for safety and validation. As attachment expert Dr. Philip Shaver has noted, anxious individuals “worry about their partner’s availability and responsiveness,” which makes them more prone to emotional volatility and suspicion.


    7- Idealizing Independence

    Avoidant individuals often glorify self-reliance and downplay the importance of emotional support. If your ex frequently emphasized being “a lone wolf” or dismissed the need for emotional closeness, they were likely distancing themselves from the vulnerability of connection.

    In Attached, Amir Levine explains that avoidants often create narratives that rationalize emotional distance. These narratives protect their sense of autonomy but sabotage deeper emotional bonds. Recognizing these self-protective strategies can help you understand why your emotional needs went unmet.


    8- Fear of Being Alone

    Anxious exes, despite often appearing dependent, may also display an intense fear of solitude. Their fear isn’t just of physical aloneness but emotional abandonment. They may have jumped into new relationships quickly or reached out post-breakup to reestablish connection.

    This behavior is underpinned by what Bowlby called “attachment panic”—a psychological response to perceived threats of disconnection. Their actions may seem impulsive, but they are driven by a desperate need to soothe attachment anxiety.


    9- Minimizing Conflict

    Avoidants often go to great lengths to avoid emotional conflict. If your ex preferred to “let things go” rather than discuss issues, this may indicate discomfort with emotional confrontation. Rather than resolve problems, they may have used silence, avoidance, or rationalization to sidestep deeper engagement.

    Dr. Harriet Lerner, in The Dance of Connection, notes that conflict avoidance often signals emotional distance rather than peacekeeping. This behavior can leave their partners feeling ignored and emotionally unheard, ultimately undermining the relationship’s foundation.


    10- Frequent Relationship Drama

    An anxious attachment style often results in frequent emotional highs and lows. If your ex often oscillated between intense affection and dramatic fights, it may have stemmed from a deep fear of abandonment and a desire to test the strength of your bond.

    This cyclical turmoil is described by Dr. Johnson as “protest behavior”—actions meant to draw attention to unmet emotional needs. While these behaviors stem from a desire for closeness, they can create a chaotic dynamic that destabilizes the relationship.


    11- Emphasizing Logic Over Emotion

    Avoidants often pride themselves on being rational and may look down on emotional expression. If your ex frequently dismissed your feelings as illogical or overblown, they may have been protecting themselves from emotional vulnerability.

    This cognitive detachment, though seemingly mature, is a defense mechanism. As Dr. Tatkin highlights, avoidants “tend to intellectualize emotional experiences to maintain distance.” Understanding this helps demystify their emotional unavailability.


    12- Fear of Rejection

    Anxious partners often operate from a fear of being unwanted. If your ex hesitated to express their needs or frequently sought your approval, they may have been driven by a fear of rejection.

    This can result in a people-pleasing dynamic where their authentic needs are buried under attempts to be “perfect.” As psychologist Kelly Brennan describes, anxious individuals “constantly scan for signs of disinterest,” which can erode their self-esteem and relationship stability.


    13- Sabotaging the Relationship

    Avoidants often subconsciously sabotage intimacy to protect themselves. If your ex initiated conflicts during moments of closeness or found fault during peaceful times, it might have been a strategy to maintain emotional distance.

    This behavior, while frustrating, isn’t always intentional. As described in Hold Me Tight by Sue Johnson, these patterns emerge when vulnerability is perceived as a threat. Recognizing sabotage as self-protection can foster empathy for both parties involved.


    14- Constant Fear of Losing You

    An anxious ex may have appeared paranoid about losing your affection—even when your commitment was unwavering. This fear can drive controlling behaviors, ultimatums, or emotional breakdowns during minor conflicts.

    Such fears are not about logic but about deep-seated attachment wounds. As Bowlby argued, the fear of abandonment often triggers behaviors that paradoxically increase the likelihood of relational breakdown.


    15- Avoiding Labels

    Avoidants often resist defining the relationship. If your ex avoided discussions about being “official” or cringed at terms like “partner,” it likely reflected a fear of being emotionally bound.

    Their reluctance is rooted in a need to maintain a sense of independence. As Tatkin notes, avoidants often see commitment as a trap rather than a bond, making them reluctant to move the relationship forward.


    16- Needing Constant Reassurance

    An anxious ex may have asked incessantly, “Do you still love me?” or “Are we okay?” This constant need for affirmation often stems from a lack of internal security.

    This behavior, while exhausting for both partners, is a reflection of a fragile self-concept. According to The Attachment Theory Workbook, providing consistent reassurance can help soothe this anxiety—but without growth, it becomes a repetitive cycle.


    17- Secretive Behavior

    Avoidants often maintain a high degree of privacy, even in intimate relationships. If your ex was evasive about their past, feelings, or social life, it could signal an avoidant need for autonomy.

    This secrecy isn’t necessarily deceptive, but it reflects discomfort with vulnerability. As Sue Johnson writes, “Connection requires openness,” and for avoidants, openness can feel threatening.


    18- Overanalyzing Small Interactions

    Anxious partners often magnify small moments—an unreturned text, a delayed response—into relationship catastrophes. This hyper-sensitivity is driven by fear, not reality.

    Their minds are constantly on alert for signs of disconnection. Psychologist Leslie Greenberg points out that “emotions are information,” and for anxious individuals, even minor cues are processed as threats.


    19- Keeping You at Arm’s Length

    Avoidants tend to maintain emotional and sometimes physical distance. If your ex often seemed “close but not too close,” they were likely regulating their own vulnerability.

    This push-pull dynamic is exhausting for partners and often feels like emotional whiplash. According to Wired for Love, avoidants “require safety in solitude,” which often makes true intimacy feel like a threat.


    20- Trouble Letting Go After the Breakup

    Interestingly, both anxious and avoidant individuals may struggle post-breakup—but for different reasons. Anxious types may obsessively check in or stalk social media, while avoidants may suddenly reappear after disappearing, struggling with the absence of emotional regulation their partner once provided.

    This speaks to the core wound in both styles: a dysregulated sense of self in relationships. As Bowlby emphasized, “Attachment is a lasting psychological connectedness.” Even after the breakup, this connectedness can continue to influence behavior.


    21- Decoding Your Ex

    Understanding your ex’s behaviors through the lens of attachment theory is a transformative step toward closure and personal growth. It removes the self-blame and confusion that often cloud the post-breakup healing process. Rather than viewing their actions as personal attacks or flaws, recognizing them as manifestations of an avoidant or anxious attachment style enables emotional clarity.

    Dr. Mary Ainsworth, a pioneer in attachment theory, emphasized the “secure base” as crucial for healthy relationships. If your ex was unable to provide that emotional safety, it’s likely due to their own internal struggles, not your worth. Decoding these behavioral patterns is not about dwelling on the past but learning from it to build healthier, more informed future connections.


    22- They Struggle With Emotional Intimacy

    Exes with avoidant attachment often hit an invisible wall when it comes to deep emotional bonding. They might have changed the subject when you expressed vulnerability or minimized your feelings during heartfelt conversations. This struggle reflects a deep-rooted discomfort with closeness, stemming from early relational patterns where vulnerability may not have been safe.

    Renowned psychotherapist Dr. Ellyn Bader explains that avoidants often equate emotional intimacy with a loss of control. Their reluctance is a protective mechanism, not a reflection of your relational compatibility. Understanding this dynamic allows for compassion, but it also signals a misalignment in emotional availability.


    23- They Frequently Downplay Emotions

    An avoidant ex may have labeled emotional conversations as “overreactions” or claimed that feelings complicate matters unnecessarily. This tendency to downplay emotions isn’t indifference—it’s a defense mechanism meant to create psychological distance and preserve autonomy.

    In The Emotionally Absent Mother, Jasmin Lee Cori explores how people raised in emotionally neglectful environments often develop a discomfort with emotional intensity. Recognizing this in your ex explains why your emotional needs may have gone consistently unmet despite your efforts.


    24- They Show Little Interest In Your Needs

    Partners with avoidant attachment often show indifference toward emotional or even practical needs. If your ex rarely asked how you were feeling or dismissed your concerns, it was likely a symptom of emotional distancing, not malice.

    This self-centeredness is often a way to reduce relational dependency. According to The Attachment Theory Workbook, avoidants focus heavily on self-sufficiency, which can result in emotional neglect within relationships. Their avoidance of your needs protected their emotional boundaries at the cost of connection.


    25- They Withdraw When You Try To Get Closer

    If every time you tried to deepen the relationship your ex responded by retreating, this is classic avoidant behavior. This withdrawal may have included going silent, creating physical distance, or becoming overly busy.

    Psychologist Dr. Lindsay Gibson refers to this as “emotional unavailability.” In her book Adult Children of Emotionally Immature Parents, she explains how people with underdeveloped emotional coping skills retreat as a form of self-regulation. Your pursuit of closeness may have unintentionally activated their fear of dependence.


    26- They Avoid Conflict Or Difficult Conversations

    Avoidants commonly sidestep conflict, often under the guise of “not wanting to argue.” They may shut down, change the topic, or even physically leave during intense discussions. While this seems like peacekeeping, it often leaves emotional issues unresolved.

    Dr. Harriet Lerner, in The Dance of Anger, points out that conflict avoidance is a way of protecting the self, not the relationship. Conflict, when handled healthily, is essential for growth. An avoidant partner’s inability to engage meaningfully in difficult discussions prevents resolution and emotional bonding.


    27- They Resist Asking For Help

    Avoidants often see asking for help as a weakness. If your ex refused support during stress or insisted on solving everything alone, it likely stemmed from a belief that dependence compromises strength.

    In Radical Acceptance, Tara Brach explains that avoidant individuals have often internalized the belief that vulnerability is dangerous. Their need for control masks underlying insecurities, making interdependence feel threatening rather than supportive.


    28- They Show Disinterest In Long-Term Commitment

    Avoidants often express ambivalence toward future planning. If your ex seemed uninterested or even annoyed by discussions about the future, this likely signaled a fear of enmeshment and emotional exposure.

    This doesn’t mean they didn’t care—it means commitment felt like a trap. Dr. Stan Tatkin suggests that avoidants often operate from a “solo orientation,” making it difficult to emotionally invest in shared futures. This mindset blocks the development of secure, stable partnerships.


    29- They Have A Tendency To Push People Away

    Avoidants often maintain an emotional firewall between themselves and others. If your ex created drama, picked fights, or questioned your compatibility during times of closeness, it may have been their way of re-establishing space.

    Psychotherapist Lindsay C. Gibson notes that emotionally immature individuals tend to “protect their independence at all costs.” This leads to pushing away those who offer closeness, which ironically reinforces their loneliness and emotional disconnection.


    30- They Appear Emotionally Detached

    Emotional detachment can feel like rejection, but in avoidants, it’s often a self-protective coping mechanism. Your ex may have seemed unbothered by arguments, indifferent during vulnerable moments, or unemotional during the breakup.

    This detachment is sometimes mistaken for emotional maturity. However, as described in The Body Keeps the Score by Bessel van der Kolk, emotional suppression often stems from unresolved trauma or attachment wounds rather than strength.


    31- They Prioritize Independence Over Relationships

    Avoidants often equate emotional closeness with a loss of autonomy. If your ex seemed to value personal freedom more than partnership, their internal compass was likely skewed toward self-preservation rather than connection.

    Independence is healthy, but when it becomes a barrier to intimacy, the relationship suffers. As Tatkin notes, avoidants “mistake aloneness for strength,” leaving partners feeling secondary to their solitude.


    32- They Seek Constant Reassurance

    This trait is more common in anxious exes, who often need repeated confirmation of love, loyalty, and commitment. You may have felt emotionally drained by the frequency and intensity of their reassurance-seeking.

    Their internal dialogue is often filled with doubt and fear. According to Dr. Sue Johnson, this behavior is a survival response to relational unpredictability. While their intentions may be rooted in love, the execution often leads to relational fatigue.


    33- They Are Overly Sensitive To Small Issues

    Anxious individuals often blow minor issues out of proportion. If your ex fixated on small slights or miscommunications, it likely stemmed from a hypersensitive fear of rejection or abandonment.

    In Emotionally Focused Couple Therapy, Dr. Johnson notes that these “emotional alarms” are the brain’s way of protecting against relational threats. The result is emotional turbulence that can destabilize otherwise healthy interactions.


    34- They Idealize You

    Anxious partners may put you on a pedestal, especially early in the relationship. This idealization isn’t necessarily flattering—it often reflects a deep longing for security rather than genuine understanding of who you are.

    Psychologist David Richo, in How to Be an Adult in Relationships, explains that idealization can be a form of emotional projection. The danger lies in the inevitable disillusionment when reality fails to meet the fantasy, leading to disappointment and conflict.


    35- They Get Distraught Over Periods Of Silence

    Silent moments or delayed replies may have triggered anxiety attacks in your ex. This distress stems from an underlying fear that love and connection are conditional and can be revoked without warning.

    Bowlby’s concept of “separation anxiety” in adult relationships explains this phenomenon. The absence of reassurance, even momentarily, is perceived as emotional abandonment, setting off disproportionate emotional responses.


    36- They May Overanalyze Every Conversation

    An anxious ex might replay conversations in their head, searching for hidden meanings or perceived slights. This analytical loop is often rooted in insecurity rather than rational interpretation.

    Dr. Kristin Neff, a leading researcher on self-compassion, notes that anxious individuals struggle to extend themselves the same empathy they offer others. Their internal criticism creates a feedback loop of worry and emotional instability.


    37- They Express Fear Of Abandonment

    Constantly worrying that you might leave—even when reassured—signals an anxious attachment style. Your ex may have verbalized this fear directly or indirectly through clingy or controlling behavior.

    As Sue Johnson articulates, “We are wired for connection,” and the fear of losing it can dominate an anxious person’s emotional world. This fear often becomes a self-fulfilling prophecy if not managed with awareness and therapy.


    38- They Have A Strong Desire For Closer Connection

    Anxious individuals crave deep connection and intimacy. If your ex constantly sought to “talk things out,” spend more time together, or deepen the bond quickly, it was likely driven by their attachment needs.

    This desire, while genuine, can sometimes feel overwhelming. In Hold Me Tight, Dr. Johnson explains that anxious partners are “preoccupied with closeness” and often miss cues that their intensity is emotionally taxing for their partner.


    39- They May Become Overly Possessive

    Possessiveness often emerges when an anxious individual feels insecure. Your ex may have tried to monitor your behavior, limit your social interactions, or display jealousy as a way to secure the relationship.

    Such behaviors, while toxic if unchecked, are often driven by fear rather than control. The antidote lies in developing self-worth and secure attachment, as outlined in Attached, which emphasizes mutual trust and autonomy in healthy bonds.


    40- They Misinterpret Their Partner’s Actions

    Anxious partners frequently misread benign behavior as signs of rejection. A late reply might signal disinterest, or a quiet moment might feel like detachment. These interpretations are rarely based on facts and are often fear-driven.

    Psychologist Aaron Beck, the father of cognitive therapy, highlighted how distorted thinking patterns can lead to relational distress. These misinterpretations create unnecessary tension and require mindful awareness to correct.


    Conclusion

    Unraveling your ex’s attachment style can be one of the most empowering steps in your emotional journey. Whether avoidant or anxious, these patterns are rooted in psychological defense systems that develop long before adult relationships begin. Understanding these behaviors helps dissolve resentment and fosters insight, allowing you to make conscious, informed choices moving forward.

    To deepen your knowledge, consider exploring Attached by Amir Levine, Hold Me Tight by Sue Johnson, Wired for Love by Stan Tatkin, and The Dance of Connection by Harriet Lerner. These resources offer valuable tools for recognizing and reshaping attachment patterns—for yourself and your future relationships.

    Understanding the attachment style of your ex-partner can provide profound insights into not only their behavior but your emotional experience as well. Whether avoidant or anxious, these styles are not moral failings but psychological frameworks developed through past experiences. As you move forward, becoming literate in attachment theory can empower you to choose partners and build relationships that foster security, intimacy, and mutual growth.

    For further reading, consider Attached by Amir Levine and Rachel Heller, Hold Me Tight by Dr. Sue Johnson, and Wired for Love by Dr. Stan Tatkin. These works provide rich, research-based insights into the intricate dance of adult attachment.

    Bibliography

    1. Bowlby, John. Attachment and Loss: Vol. 1. Attachment. Basic Books, 1969.
    2. Ainsworth, Mary D.S., et al. Patterns of Attachment: A Psychological Study of the Strange Situation. Lawrence Erlbaum Associates, 1978.
    3. Levine, Amir, and Rachel Heller. Attached: The New Science of Adult Attachment and How It Can Help You Find – and Keep – Love. TarcherPerigee, 2010.
    4. Johnson, Sue. Hold Me Tight: Seven Conversations for a Lifetime of Love. Little, Brown Spark, 2008.
    5. Tatkin, Stan. Wired for Love: How Understanding Your Partner’s Brain and Attachment Style Can Help You Defuse Conflict and Build a Secure Relationship. New Harbinger Publications, 2012.
    6. Gibson, Lindsay C. Adult Children of Emotionally Immature Parents: How to Heal from Distant, Rejecting, or Self-Involved Parents. New Harbinger Publications, 2015.
    7. Cori, Jasmin Lee. The Emotionally Absent Mother: A Guide to Self-Healing and Getting the Love You Missed. The Experiment, 2010.
    8. Lerner, Harriet. The Dance of Anger: A Woman’s Guide to Changing the Patterns of Intimate Relationships. Harper Perennial, 2005.
    9. Neff, Kristin. Self-Compassion: The Proven Power of Being Kind to Yourself. William Morrow, 2011.
    10. Richo, David. How to Be an Adult in Relationships: The Five Keys to Mindful Loving. Shambhala Publications, 2002.
    11. Brach, Tara. Radical Acceptance: Embracing Your Life With the Heart of a Buddha. Bantam, 2004.
    12. van der Kolk, Bessel. The Body Keeps the Score: Brain, Mind, and Body in the Healing of Trauma. Viking, 2014.
    13. Beck, Aaron T. Cognitive Therapy and the Emotional Disorders. Penguin Books, 1979.
    14. Tatkin, Stan. We Do: Saying Yes to a Relationship of Depth, True Connection, and Enduring Love. Sounds True, 2018.
    15. Johnson, Sue. Love Sense: The Revolutionary New Science of Romantic Relationships. Little, Brown Spark, 2013.

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • Reasons Why Women Over 50 No Longer Want to Date

    Reasons Why Women Over 50 No Longer Want to Date

    For many women over 50, the idea of dating no longer holds the same allure it once did—and this isn’t due to bitterness or disillusionment alone. It’s part of a broader shift in priorities, values, and self-perception that often accompanies age, wisdom, and life experience. The dating landscape, once defined by possibility and excitement, is now more frequently seen as fraught with compromise, emotional labor, and unmet expectations.

    As women mature, they often gain a clearer sense of their worth and are less willing to settle for relationships that do not honor their needs or values. According to Dr. Helen Fisher, a biological anthropologist at the Kinsey Institute, “Postmenopausal women often experience a spike in autonomy and self-direction, which directly affects their romantic choices.” With careers, families, and social lives already well-established, many women find the pursuit of romantic partnerships to be unnecessary or even draining.

    Additionally, cultural narratives around aging have shifted. Books like Women Rowing North by Mary Pipher emphasize that the second half of life can be rich with growth, independence, and purpose—often without the need for a partner. For educated, critical-thinking women, the question is no longer “Why can’t I find a man?” but rather, “Why should I want to?” The reasons are as complex as the women themselves.


    1- Emotional Exhaustion from Past Relationships

    After decades of investing emotionally in romantic relationships, many women over 50 are simply worn out. Emotional labor—the often invisible effort involved in maintaining harmony, managing communication, and caretaking a partner’s needs—can be deeply draining. This is especially true for women who have been in long-term marriages or have experienced the turmoil of divorce. Having carried the weight of emotional balance for years, the idea of re-entering such a dynamic can feel more like a burden than a benefit.

    Furthermore, repeated disappointments in love can lead to what psychologists term “relationship fatigue.” As Dr. Susan Whitbourne, professor of psychological and brain sciences, notes, “The risk-reward ratio in later-life dating often tilts unfavorably.” Rather than risking heartache again, many women choose to protect their emotional peace and invest in more fulfilling solo endeavors.


    2- A Newfound Sense of Freedom

    With children grown and careers stabilized or winding down, women over 50 often find themselves with a freedom they haven’t known in decades. This freedom—from expectations, responsibilities, and societal pressures—can be intoxicating. There’s a joy in reclaiming one’s schedule, making spontaneous decisions, and prioritizing personal growth over relational compromise.

    Philosopher Simone de Beauvoir famously said, “Change your life today. Don’t gamble on the future, act now, without delay.” For many older women, this mindset becomes a personal mantra. Having finally stepped out of traditional roles, they are reluctant to re-enter dynamics that might require them to shrink themselves or compromise their independence.


    3- Limited Availability of Compatible Partners

    The dating pool shrinks significantly after 50, and the quality of available partners can be inconsistent. Many women report difficulty finding men who are emotionally mature, intellectually stimulating, and open to egalitarian relationships. Stereotypes about older men preferring younger women only add to the disillusionment.

    Moreover, the emotional and physical health of potential partners becomes more significant with age. Women tend to live longer and maintain better health than their male counterparts, making the likelihood of becoming a caregiver in later-life relationships a serious concern. As psychotherapist Esther Perel notes, “Desire and care don’t always go hand-in-hand.” For many women, the risk of becoming a nurse rather than a lover is a deterrent.


    4- Focus on Personal Growth and Self-Actualization

    After years of focusing on others, many women reach a stage where self-actualization becomes the ultimate goal. This is the phase Abraham Maslow described as the pinnacle of human motivation. For many women over 50, this includes learning new skills, traveling, engaging in activism, or even launching new careers.

    Books like The Second Half of Life by Angeles Arrien emphasize the spiritual and intellectual expansion that can happen during this stage. For these women, dating may feel like a detour rather than a destination—something that distracts from their deeper journey of self-discovery and personal growth.


    5- Disinterest in Playing Dating “Games”

    The modern dating scene, particularly online, often requires navigating superficiality, ghosting, and a lack of genuine communication. Women over 50, with their wealth of life experience, often find these dynamics immature and exhausting. They are less interested in appearances and more interested in authenticity—something the current dating culture doesn’t always prioritize.

    The expectation to engage in flirtatious banter, cultivate a certain “look,” or feign casual interest contradicts the emotional depth and sincerity many mature women seek. As one might say, “Ain’t nobody got time for that.” The desire to avoid such emotionally hollow exchanges is a common thread among women who have opted out of dating entirely.


    6- Financial Independence

    Unlike previous generations, many women over 50 today are financially independent. They have worked hard, saved well, and often own property or manage investments. The idea of partnering with someone who may complicate their financial stability—or expect to benefit from it—can be profoundly unappealing.

    Renowned sociologist Arlie Hochschild writes in The Second Shift about the double burden of work and home that many women carry. With that load finally lightened, few are eager to invite potential economic entanglements into their lives again. Financial autonomy gives women the power to make relationship choices based on desire, not necessity.


    7- Health Concerns and Energy Levels

    The physical and emotional energy required to maintain a relationship is not insignificant. For some women over 50, especially those managing health conditions or dealing with menopause-related changes, the idea of allocating limited energy to dating feels unrealistic.

    Prioritizing health—both physical and mental—often means creating space for rest, routine, and self-care. This focus stands in sharp contrast to the emotional upheaval and demands that often come with romantic relationships. For many women, peace and predictability now outweigh passion and pursuit.


    8- Different Life Goals

    By the time they reach 50, many women have clear life goals that no longer align with traditional relationship structures. Whether it’s moving to a new country, writing a book, or pursuing artistic interests, their paths often require solitude, flexibility, or freedom from emotional entanglement.

    Compatibility isn’t just about shared hobbies or attraction—it’s about aligned visions for the future. As author Elizabeth Gilbert states in Big Magic, “You can measure your worth by your dedication to your path, not by your successes or failures.” For many women, staying true to their personal path takes precedence over finding a romantic partner.


    9- Past Trauma and Fear of Repetition

    Women who have experienced emotional or physical trauma in relationships may carry those scars well into midlife. The fear of reliving toxic patterns or re-entering unsafe dynamics can make dating feel more threatening than thrilling.

    Therapist Beverly Engel, in her book The Emotionally Abused Woman, explains how healing requires boundaries and space—conditions not always compatible with new romantic involvement. For many women, the emotional safety of solitude is far more valuable than the uncertainty of dating again.


    10- Social Stigma and Judgment

    While society is becoming more accepting of diverse life choices, stigma still exists around single, older women—often unfairly labeled as “lonely” or “bitter.” Ironically, it’s this very stigma that leads many women to reject dating altogether, in favor of redefining what happiness and fulfillment look like on their own terms.

    Feminist scholar bell hooks once said, “Love is an action, never simply a feeling.” For many older women, love is now expressed through friendships, family, and self-compassion rather than romantic attachment. Rejecting dating is not a resignation—it’s a redefinition.


    11- Greater Enjoyment of Platonic Relationships

    As romantic relationships lose their luster, many women find greater joy in platonic connections. Deep friendships, community involvement, and intergenerational mentorship provide emotional fulfillment without the complexities of romance.

    Sociologist Robert Putnam, in Bowling Alone, emphasizes the importance of social capital in well-being. Women over 50 often prioritize these more sustainable and mutually supportive relationships over dating, which can feel ephemeral and fraught.


    12- Changing Views on Love and Companionship

    Mature women often have more nuanced perspectives on love. The fairy-tale narratives they grew up with have given way to realistic, sometimes skeptical views on partnership. They understand that love isn’t always enough to sustain a healthy relationship—and that compatibility, respect, and autonomy often matter more.

    In her book Committed, Elizabeth Gilbert explores how modern women are rethinking marriage and long-term commitment. Many now seek companionship without the entanglements of traditional romantic roles, often redefining love in broader, more inclusive terms.


    13- Avoidance of Caretaking Roles

    Statistically, women are more likely to become caregivers in relationships, especially as both partners age. This potential role reversal—where they become more nurse than partner—is a major deterrent for many women who have already spent decades caregiving for children, spouses, or parents.

    Dr. Carol Gilligan, a renowned feminist psychologist, notes, “There comes a point when a woman asks not what others need from her, but what she needs for herself.” For women over 50, that question often leads away from caregiving-heavy relationships and toward self-prioritization.


    14- Digital Dating Disillusionment

    Online dating can be particularly disheartening for older women. From ageism to scams to superficial profiles, the digital realm often feels inhospitable. Algorithms rarely capture the depth of personality or values that matter to mature daters.

    Digital anthropologist Dr. Jennifer Golbeck has studied how algorithms shape interactions and warns that “technology is often designed for engagement, not for connection.” Many women over 50, therefore, opt out of digital dating altogether, preferring organic and authentic social interactions.


    15- Enjoyment of Solitude

    Solitude is no longer synonymous with loneliness. For many older women, it’s a source of strength and creativity. Time alone allows for introspection, creative expression, and peace of mind—qualities that can be hard to maintain in a romantic relationship.

    As Virginia Woolf wrote in A Room of One’s Own, “A woman must have money and a room of her own if she is to write fiction.” The sentiment holds true even outside of writing—solitude can be essential to a woman’s self-expression and autonomy.


    16- Fear of Losing Personal Space

    Having cultivated a lifestyle that reflects their preferences and routines, many women are reluctant to compromise their personal space. Sharing a home or even a schedule with another person can feel intrusive rather than comforting.

    Boundaries, once considered selfish, are now seen as essential. Maintaining these boundaries often means declining romantic entanglements that threaten the hard-won equilibrium of solo living.


    17- Prioritizing Mental Health

    The stress and emotional unpredictability of dating can have adverse effects on mental health. Many women over 50 prioritize peace of mind over romantic excitement. This choice is not made out of fear, but from a mature understanding of what sustains well-being.

    According to The Body Keeps the Score by Dr. Bessel van der Kolk, emotional balance is critical to physical health. For many women, avoiding dating drama is a form of self-care that protects their mental and emotional equilibrium.


    18- Cultural Shifts in Relationship Norms

    Cultural expectations around relationships are evolving. Where once a woman’s value was linked to her marital status, today it’s more often tied to her independence and contributions to society. This cultural evolution supports and affirms the choices of women who opt out of dating.

    Books like All the Single Ladies by Rebecca Traister explore how single women are shaping politics, culture, and economy. Rather than being outliers, women who eschew dating are increasingly at the forefront of cultural change.


    19- Alternative Sources of Intimacy

    Romantic love is not the only form of intimacy. Pet companionship, spiritual practices, deep friendships, and community involvement offer forms of closeness and connection that do not rely on romantic or sexual involvement.

    In many spiritual traditions, intimacy with the self is considered the highest form of union. As the poet Rumi wrote, “The soul has been given its own ears to hear things the mind does not understand.” Many older women lean into this kind of internal, soulful connection.


    20- Rejection of Social Pressure

    Finally, many women over 50 actively resist societal pressure to pair up. They no longer need external validation and refuse to let outdated norms dictate their happiness. This rebellion isn’t angry—it’s liberating.

    The late philosopher and gender theorist Judith Butler once argued that “resisting the norms that harm us is an act of survival.” For many women, saying no to dating is not just a personal choice—it’s a political act of self-determination.


    21- Peace Outweighs Drama

    At this stage in life, peace is not just a preference—it is a necessity. Women over 50 have endured their fair share of emotional storms, and many now crave serenity above all. Romantic relationships, while potentially rewarding, often come with complications, emotional highs and lows, and interpersonal drama. These are luxuries that mature women no longer wish to indulge in.

    Dr. Judith Sills, author of Excess Baggage, emphasizes that “emotional peace is the most valuable currency after midlife.” For many women, maintaining inner calm and emotional stability takes precedence over chasing the fleeting thrill of romantic involvement. They’ve worked hard for this peace—and they intend to protect it fiercely.


    22- Freedom Becomes Non-Negotiable

    The kind of freedom experienced in one’s 50s and beyond is often unprecedented. No longer tethered to the demands of children, careers, or societal expectations, many women find that autonomy becomes their most cherished asset. The idea of compromising that freedom for the sake of a relationship feels like taking a step backward.

    The psychologist Carl Jung once observed that “freedom stretches only as far as the consciousness allows.” For women who have become conscious of their desires, needs, and non-negotiables, freedom isn’t a perk—it’s a pillar of their identity. Relationships that jeopardize that independence are simply not worth the cost.


    23- Standards Have Skyrocketed

    By the time a woman reaches her 50s, she knows exactly what she wants—and what she won’t tolerate. Standards are no longer shaped by fairy tales or social expectations; they’re forged through lived experience. From communication to emotional availability, many women demand a higher quality of connection than ever before.

    This isn’t entitlement—it’s evolution. As Dr. Brené Brown writes in Daring Greatly, “When we own our stories, we avoid becoming trapped in them.” Women over 50 are no longer interested in partners who require excessive emotional labor, lack integrity, or fall short of meaningful reciprocity.


    24- Self-Growth Takes Priority

    Rather than seeking fulfillment through romantic relationships, many mature women turn inward, investing time and energy into personal development. Whether it’s returning to school, starting a business, or diving into spirituality, self-growth becomes a central theme. The emotional energy once reserved for a partner is now channeled into cultivating a richer, more expansive life.

    This inward focus is not selfish—it’s self-actualization. In The Road Less Traveled, M. Scott Peck asserts that “life is a series of problems to be solved.” Many women in this stage are eager to solve the inner puzzles of identity, purpose, and legacy, and see dating as an unnecessary distraction from that pursuit.


    25- Caregiver Fatigue Is Real

    Many women over 50 have spent decades in caregiving roles—raising children, supporting aging parents, or even caring for ill partners. By midlife, caregiver burnout is a tangible, often debilitating reality. The idea of entering a new relationship that may eventually require more caregiving is emotionally and physically exhausting.

    Dr. Pauline Boss, in Loving Someone Who Has Dementia, discusses the silent toll of ongoing caregiving. For many women, the fear of returning to a similar dynamic—this time with a new partner—is enough to swear off romantic involvement entirely. Preservation of energy and well-being becomes the top priority.


    26- Dating Apps Feel Demoralizing

    Dating apps, with their gamified swiping and superficial profiles, can be particularly disheartening for older women. Many encounter ageism, dishonesty, or outright scams, making the entire process feel like an exercise in futility. Rather than facilitating meaningful connection, these platforms often reinforce feelings of alienation.

    Cyberpsychologist Dr. Mary Aiken notes in The Cyber Effect that “technology often enhances the shallow at the expense of the meaningful.” For many women, digital dating is not just ineffective—it’s dehumanizing. They opt instead to cultivate connections in real life, through shared interests and authentic interaction.


    27- No More Fixer-Upper Projects

    Gone are the days when women felt compelled to “fix” or “rescue” emotionally unavailable or unmotivated partners. The romanticized idea of transforming a flawed man into a suitable companion has lost its appeal. Women over 50 recognize that emotional labor doesn’t equal love—it often leads to resentment.

    In her book Attached, Dr. Amir Levine emphasizes that secure attachments are built, not fixed. Women in this stage of life are not looking to mold someone into a partner. Instead, they seek individuals who already embody emotional maturity, stability, and self-awareness.


    28- Self-Worth Comes From Within

    For many women over 50, self-worth is no longer dependent on external validation, especially from romantic partners. Years of life experience have taught them that true value comes from self-acceptance and internal growth. They no longer need someone else to reflect back their worth.

    Psychologist Dr. Kristin Neff, in Self-Compassion, argues that treating oneself with kindness and respect builds a more stable sense of self-worth than chasing approval. Women who embrace this mindset often find that dating—once a source of validation—now feels redundant.


    29- Rich Social Connections Already Exist

    From long-standing friendships to close-knit communities, many women already enjoy rich social lives that fulfill their emotional and intellectual needs. These networks provide support, laughter, and shared experience without the complexity of romantic relationships.

    Sociologist Sherry Turkle, in Reclaiming Conversation, argues that “meaningful conversation is the cornerstone of connection.” For many mature women, these platonic relationships provide a depth of connection that surpasses what they’ve experienced in past romantic partnerships.


    30- Red Flag Recognition Skills

    With age comes discernment. Women over 50 are exceptionally skilled at spotting red flags early—emotional unavailability, controlling behavior, or inconsistency. These warning signs, once overlooked or rationalized in youth, are now immediate deal-breakers.

    This sharpened intuition is a form of self-protection. Dr. Harriet Lerner, in The Dance of Intimacy, writes that “clarity comes not from knowing the other, but from knowing oneself.” Women who know themselves well no longer entertain dynamics that jeopardize their peace or dignity.


    31- Financial Independence Feels Precarious

    Even for financially stable women, the prospect of entangling finances with a new partner can feel risky. They’ve worked hard for their independence, and any perceived threat to their economic security is taken seriously. From hidden debts to differing financial values, the stakes are too high.

    As financial expert Suze Orman advises, “Never do for love what you wouldn’t do for yourself financially.” Women over 50 are acutely aware of the financial vulnerability that can accompany romantic entanglement and often choose to protect their assets—and their peace of mind.


    32- Social Obligations Lose Their Appeal

    Romantic relationships often come with a host of social obligations—meeting extended family, attending events, or managing a partner’s social life. For many women over 50, these duties feel burdensome rather than enriching. They prefer to invest time and energy into relationships that are freely chosen, not socially mandated.

    This distaste for performative socializing reflects a broader desire for authenticity. As Susan Cain notes in Quiet, “Solitude matters, and for some people it is the air they breathe.” Many mature women value quiet connection and personal space over the performance of social conformity.


    33- Past Loves Provide Fulfillment

    For some, the memory of past loves continues to offer a sense of emotional richness. These relationships—whether enduring or fleeting—contribute to a tapestry of meaningful experience that doesn’t need to be repeated or replaced.

    In The Art of Loving, Erich Fromm suggests that love is not just an emotion but a practice—a way of being in the world. Women over 50 may feel they’ve already experienced love in its many forms, and rather than seeking a new chapter, they choose to cherish those already written.


    34- Dating Games Become Intolerable

    The mind games and emotional manipulation that sometimes come with dating—delayed replies, mixed signals, strategic disinterest—are deeply unappealing to mature women. Their tolerance for emotional immaturity has worn thin.

    As relationship coach Matthew Hussey states, “Games are for people who don’t know what they want.” Women over 50 often have a profound sense of clarity and are uninterested in wasting time on people who can’t match their emotional transparency.


    35- Solitude Becomes Deeply Satisfying

    Solitude is not merely tolerated—it is embraced. Time alone becomes a space of reflection, creativity, and personal renewal. The quiet of an undisturbed morning or an uninterrupted evening is a kind of luxury that many women are unwilling to trade.

    In Solitude: A Return to the Self, psychiatrist Anthony Storr argues that “the capacity to be alone is a valuable resource.” For women who have cultivated that capacity, solitude becomes a sanctuary, not a sentence. Romantic relationships, no matter how promising, must offer something truly extraordinary to be worth the exchange.


    Conclusion

    The decision of many women over 50 to opt out of dating is not rooted in bitterness, but in clarity, empowerment, and deep self-respect. Their lives are full—rich with meaning, connection, and personal fulfillment. Far from being resigned, they are reclaiming their narratives, redefining intimacy, and celebrating autonomy. In doing so, they offer a powerful counter-narrative to ageist myths and cultural expectations, reminding us all that a woman’s value does not diminish with age—it deepens.

    In a world that often undervalues aging women, choosing not to date after 50 is a deeply empowering act. It’s not about bitterness, failure, or fear—it’s about clarity, autonomy, and self-respect. These women are not giving up on love; they are expanding its definition and reclaiming it on their own terms. As cultural narratives continue to evolve, their choices illuminate new pathways to fulfillment, happiness, and dignity.

    Bibliography

    1-Sills, Judith. Excess Baggage: Getting Out of Your Own Way. Viking, 2003.

    2. Peck, M. Scott. The Road Less Traveled: A New Psychology of Love, Traditional Values, and Spiritual Growth. Simon & Schuster, 1978.

    3. Brown, Brené. Daring Greatly: How the Courage to Be Vulnerable Transforms the Way We Live, Love, Parent, and Lead. Gotham Books, 2012.

    4. Boss, Pauline. Loving Someone Who Has Dementia: How to Find Hope While Coping with Stress and Grief. Jossey-Bass, 2011.

    5. Aiken, Mary. The Cyber Effect: A Pioneering Cyberpsychologist Explains How Human Behavior Changes Online. Spiegel & Grau, 2016.

    6. Levine, Amir, and Heller, Rachel. Attached: The New Science of Adult Attachment and How It Can Help You Find – and Keep – Love. TarcherPerigee, 2010.

    7. Neff, Kristin. Self-Compassion: The Proven Power of Being Kind to Yourself. William Morrow, 2011.

    8. Turkle, Sherry. Reclaiming Conversation: The Power of Talk in a Digital Age. Penguin Press, 2015.

    9. Lerner, Harriet. The Dance of Intimacy: A Woman’s Guide to Courageous Acts of Change in Key Relationships. Harper & Row, 1989.

    10. Orman, Suze. Women & Money (Revised and Updated): Be Strong, Be Smart, Be Secure. Spiegel & Grau, 2018.

    11. Cain, Susan. Quiet: The Power of Introverts in a World That Can’t Stop Talking. Crown Publishing, 2012.

    12. Fromm, Erich. The Art of Loving. Harper Perennial, 1956.

    13. Hussey, Matthew. Get the Guy: Learn Secrets of the Male Mind to Find the Man You Want and the Love You Deserve. HarperWave, 2013.

    14. Storr, Anthony. Solitude: A Return to the Self. Free Press, 1988.

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • Ballerina Review: A Thrilling Action Movie That Relies Too Much On John Wick

    Ballerina Review: A Thrilling Action Movie That Relies Too Much On John Wick

    When a ballet dancer trades pirouettes for pistols, the stage is set for a cinematic spectacle that blurs the lines between grace and grit. In “Ballerina,” Ana de Armas steps into the spotlight as Eve Macarro, a character who seamlessly melds the elegance of dance with the lethality of an assassin. Set within the intricate tapestry of the John Wick universe, this spin-off endeavors to carve its own niche while paying homage to its origins.fandango.com+14as.com+14vulture.com+14en.wikipedia.org+5vanityfair.com+5polygon.com+5

    Directed by Len Wiseman, with contributions from franchise stalwart Chad Stahelski, “Ballerina” navigates the treacherous waters of expanding a beloved cinematic world. The film’s choreography, both in dance and combat, reflects a meticulous attention to detail, aiming to captivate audiences with its visual flair. However, the narrative’s reliance on familiar tropes raises questions about its originality and the challenges of crafting a standalone identity within an established franchise.johnwick.fandom.com+3houstonchronicle.com+3en.wikipedia.org+3

    As Eve embarks on her quest for vengeance, the film delves into themes of identity, loyalty, and the cost of retribution. While “Ballerina” offers moments of exhilarating action and poignant introspection, it occasionally stumbles under the weight of its own ambitions. This review seeks to dissect the film’s strengths and shortcomings, providing a nuanced perspective for discerning viewers.


    1- Character Development: Eve Macarro’s Journey

    Eve Macarro’s transformation from a grieving daughter to a formidable assassin is central to “Ballerina’s” narrative arc. Her character embodies the dichotomy of vulnerability and strength, navigating a world where trust is scarce and betrayal lurks in every shadow. Ana de Armas delivers a performance that captures Eve’s internal conflict, portraying a woman torn between her past and the path she’s chosen. The film explores Eve’s psychological evolution, highlighting her resilience and adaptability in the face of adversity.theguardian.com+12vulture.com+12johnwick.fandom.com+12houstonchronicle.com

    However, the depth of Eve’s character development is sometimes overshadowed by the film’s emphasis on action sequences. While her motivations are clear, the narrative occasionally glosses over opportunities to delve deeper into her psyche. This oversight limits the audience’s ability to fully connect with her journey on an emotional level. A more nuanced exploration of Eve’s internal struggles could have elevated the film’s impact, offering a richer, more compelling protagonist.


    2- Action Choreography: Dance Meets Combat

    The fusion of ballet and combat in “Ballerina” presents a unique visual spectacle. The film’s action sequences are meticulously choreographed, drawing parallels between the precision of dance and the brutality of battle. This artistic approach adds a layer of sophistication to the violence, transforming fight scenes into performances that are both graceful and deadly. The use of unconventional weapons, such as ice skates and flamethrowers, further enhances the film’s creative flair.as.comhoustonchronicle.com+1vulture.com+1

    Despite these innovations, some action sequences feel derivative, echoing the stylings of the original John Wick films without introducing significant novelty. While the choreography is impressive, it occasionally lacks the visceral impact that made its predecessors stand out. To truly distinguish itself, “Ballerina” could have pushed the boundaries of its action design, embracing more daring and unconventional approaches to combat.


    3- Narrative Structure: A Tale of Vengeance

    At its core, “Ballerina” is a revenge story, a narrative thread that is both timeless and well-trodden. Eve’s quest to avenge her father’s death propels the plot forward, providing a clear and compelling motivation for her actions. The film adheres to a linear structure, allowing audiences to follow Eve’s journey with clarity. This straightforward approach ensures that the story remains accessible, even as it delves into the complexities of the assassin underworld.johnwick.fandom.com+8rogerebert.com+8vanityfair.com+8

    However, the reliance on familiar revenge tropes can render the narrative predictable. While the film introduces intriguing elements, such as the assassin commune in Hallstatt, Austria, these innovations are not always fully explored. A more intricate plot, with unexpected twists and deeper character interactions, could have added layers of intrigue, elevating the film beyond a standard vengeance tale.apnews.com+1vanityfair.com+1


    4- Cinematic Aesthetics: Visual Storytelling

    “Ballerina” boasts a striking visual palette, blending the elegance of ballet with the starkness of its violent world. The cinematography captures the contrast between the refined settings of the Ruska Roma and the gritty locales of Eve’s missions. Lighting and color schemes are employed effectively to reflect the protagonist’s emotional state, transitioning from warm hues during moments of introspection to cooler tones in scenes of conflict.imdb.com+10rottentomatoes.com+10johnwick.fandom.com+10

    The film’s visual storytelling is further enhanced by its attention to detail in set design and costume. The juxtaposition of delicate ballet attire with weaponry underscores the central theme of duality. However, at times, the emphasis on style over substance can detract from the narrative’s emotional resonance. Balancing aesthetic appeal with storytelling depth is crucial to maintaining audience engagement throughout the film.


    5- Supporting Characters: Enhancing the Narrative

    The ensemble cast of “Ballerina” contributes to the richness of its world-building. Characters such as The Director (Anjelica Huston) and Winston (Ian McShane) provide continuity within the John Wick universe, grounding the spin-off in familiar territory. Their interactions with Eve offer insights into the hierarchical structures and codes that govern the assassin community.apnews.com+10washingtonpost.com+10reddit.com+10

    Despite their potential, some supporting characters are underutilized, serving more as narrative devices than fully realized individuals. Expanding their backstories and motivations could have added depth to the film, creating more dynamic relationships and conflicts. A more robust development of these characters would have enriched the narrative, offering varied perspectives within the assassin world.


    6- Thematic Exploration: Identity and Transformation

    “Ballerina” delves into themes of identity, transformation, and the quest for purpose. Eve’s journey reflects a struggle to reconcile her past with her present, navigating the tension between her upbringing and her chosen path. The film examines the sacrifices required to forge a new identity, highlighting the psychological toll of such a metamorphosis.as.com+2apnews.com+2houstonchronicle.com+2

    These themes resonate with broader philosophical discussions on selfhood and agency. Drawing from existentialist thought, the narrative suggests that individuals are defined by their actions and choices. However, a deeper exploration of these concepts within the film could have provided a more profound commentary on the human condition, elevating the story beyond its action-oriented framework.


    7- Musical Score: Setting the Tone

    The musical composition in “Ballerina” plays a pivotal role in establishing the film’s tone. The score seamlessly blends classical motifs with contemporary elements, mirroring the fusion of ballet and modern combat. This auditory backdrop enhances the emotional impact of key scenes, guiding audience responses and accentuating narrative beats.

    However, the soundtrack occasionally leans heavily on familiar cues, potentially diminishing its originality. Incorporating more innovative musical arrangements could have further distinguished the film’s identity, reinforcing its thematic ambitions and complementing its visual storytelling.


    8- Cultural Context: Ballet and Violence

    “Ballerina” juxtaposes the refined art of ballet with the brutal world of assassination, creating a compelling contrast that challenges traditional perceptions. This interplay invites discussions on the duality of human nature, the coexistence of beauty and savagery, and the societal constructs that define femininity and strength.

    By positioning a ballerina as a lethal force, the film subverts expectations and prompts reflections on gender roles and empowerment. However, a more nuanced exploration of these cultural themes could have deepened the film’s impact, offering a more critical lens through which to view its narrative choices.


    9- Franchise Integration: Expanding the Universe

    As a spin-off, “Ballerina” seeks to expand the John Wick universe, introducing new characters and settings while maintaining continuity. The film’s integration of familiar elements, such as the Continental Hotel and the High Table, provides a sense of cohesion and familiarity for fans.vanityfair.com

    However, the challenge lies in balancing homage with innovation. While “Ballerina” successfully incorporates established lore, it occasionally struggles to assert its own identity. A more distinct narrative voice could have positioned the film as a bold new chapter within the franchise, rather than a derivative extension.


    10- Audience Reception: Critical Perspectives

    Critical responses to “Ballerina” have been mixed, with praise directed at its visual style and Ana de Armas’s performance, and criticism aimed at its narrative shortcomings. Some reviewers commend the film’s action sequences and aesthetic choices, while others highlight a lack of depth in character development and storytelling.

    These varied perspectives underscore the complexities of crafting a successful spin-off. Balancing fan expectations with creative innovation is a delicate endeavor, and “Ballerina’s” reception reflects the challenges inherent in expanding a beloved cinematic universe.

    11- Gender Dynamics: Female Empowerment

    “Ballerina” boldly centers a female lead in a genre traditionally dominated by male protagonists, pushing against entrenched norms of the action-thriller archetype. Ana de Armas’s Eve Macarro redefines what it means to be a modern action heroine—not merely through physical prowess but through psychological complexity. As Susan Jeffords noted in Hard Bodies: Hollywood Masculinity in the Reagan Era, traditional action heroes reflect cultural fantasies of dominance. “Ballerina,” in contrast, situates empowerment in Eve’s capacity for emotional resilience and strategic agency.

    Nevertheless, the film occasionally flirts with the danger of aestheticizing violence against women under the guise of empowerment. While Eve’s transformation into a lethal force is framed as liberation, her journey is still orchestrated within a male-constructed universe, echoing what Laura Mulvey identified in Visual Pleasure and Narrative Cinema as the “male gaze.” For the film to truly transcend gender tropes, it would need to foreground Eve’s narrative autonomy, not just her survival skills.


    12- John Wick’s Shadow: The Cost of Legacy

    “Ballerina” exists within the shadow of the John Wick franchise, and this proximity is both its strength and its Achilles’ heel. The cinematic universe lends the film an immediate allure—world-building, established mythos, and familiar figures like Winston and Charon provide narrative scaffolding. Yet this reliance on the Wick lore curtails the film’s originality, as viewers are constantly reminded of the parent franchise’s more iconic moments.

    This overdependence raises questions of creative independence. As Harold Bloom outlines in The Anxiety of Influence, derivative works often grapple with asserting identity amidst strong precursors. “Ballerina” seems to oscillate between homage and imitation. To forge its own legacy, it needs to break free from John Wick’s stylistic and thematic blueprint and establish a signature vision that does not merely echo but innovates.


    13- Philosophical Undercurrents: The Ethics of Revenge

    The revenge motif in “Ballerina” raises philosophical concerns around morality, justice, and cyclical violence. Eve’s pursuit is emotionally understandable, but the film rarely pauses to interrogate the ethical implications of her actions. Are her targets unequivocally evil, or is the narrative simplifying complex moral terrain? Hannah Arendt’s reflections on violence in On Violence suggest that retribution rarely leads to genuine justice, a theme only lightly brushed upon in the film.

    Moreover, the film misses an opportunity to explore forgiveness, moral ambiguity, or transformation. In contrast to John Wick’s nihilistic tone, “Ballerina” could have presented a moral evolution in its protagonist, offering a redemptive path. Such complexity would not only elevate the film but anchor it more firmly in intellectual discourse on vengeance and justice.


    14- Symbolism and Metaphor: Layers Beneath the Surface

    Symbolism abounds in “Ballerina”—the act of dance as both beauty and weaponry, mirrors as motifs of identity fragmentation, and fire as purging vengeance. These elements add texture but are often underdeveloped. The film gestures toward depth, yet fails to mine its metaphors with the thoroughness seen in psychological thrillers or philosophical cinema.

    A more deliberate symbolic architecture—akin to what we see in Aronofsky’s Black Swan—would have enriched the narrative tapestry. For example, dance could serve as a metaphor for self-control or the tension between structure and chaos. As Northrop Frye argues in Anatomy of Criticism, effective symbolism should resonate on multiple levels; in “Ballerina,” it feels more decorative than substantive.


    15- Setting and Atmosphere: A Global Canvas

    The use of international settings, especially the haunting alpine village of Hallstatt, Austria, gives “Ballerina” a broad cinematic canvas. These locations are not just backdrops but atmospheric agents—Hallstatt’s Gothic stillness mirrors Eve’s internal coldness and moral isolation. The global nature of the assassin network also reflects the expanding scope of cinematic narratives in a globalized world.

    Yet, these settings often serve more as stylized frames than as fully integrated narrative components. More immersive world-building—drawing from local myths, languages, or geopolitical contexts—could have made the settings feel intrinsic rather than ornamental. Referencing Edward Said’s Orientalism, it’s essential for films to avoid aestheticizing locales without engaging with their cultural substance.


    16- Technical Mastery: Editing, Sound, and Pacing

    Technically, “Ballerina” demonstrates high production values—fluid camera work, crisp editing, and immersive sound design. Fight sequences are cut with precision, enabling viewers to follow the action without disorientation. The pacing, particularly in the first and final acts, maintains engagement and suspense.

    However, the midsection of the film lags, weighed down by exposition and redundant set pieces. Tightening the narrative and integrating exposition through visual storytelling, rather than dialogue-heavy scenes, could have improved rhythm. As Walter Murch explains in In the Blink of an Eye, editing is not merely functional but emotional; pacing must reflect psychological and narrative momentum.


    17- Mythology and Lore: Expanding the Assassin World

    The film attempts to deepen the lore of the John Wick universe by expanding the mythology of the Ruska Roma and introducing new rituals, rules, and hierarchies. This effort enhances the franchise’s baroque moral structure, where honor codes and debts govern lethal economies. These mythic elements evoke Joseph Campbell’s concept of the “monomyth,” casting Eve as a reluctant hero on a mythic journey.

    Still, the film could have been bolder in developing this mythology. It rarely explains the new rules or delves into the cultural origins of the Ruska Roma in meaningful ways. For lore to resonate, it must not only mystify but inform character and plot. A deeper anthropological or even folkloric grounding—akin to the rigor seen in Tolkien’s The Silmarillion—would offer richness and credibility.


    18- Intertextuality: Cinematic and Literary Echoes

    “Ballerina” is laden with intertextual references—echoes of La Femme Nikita, Black Swan, Kill Bill, and even Macbeth. These allusions function as homage and narrative scaffolding, giving savvy viewers the pleasure of recognition. For example, the concept of a female avenger reshaping her fate draws heavily from classical tragedy and modern noir.

    Yet intertextuality, as Julia Kristeva theorizes, is a dialogue among texts that can either enrich or dilute. In “Ballerina,” references sometimes verge on pastiche. For these allusions to elevate rather than encumber the film, they must serve a purpose beyond stylistic mimicry—either by subverting the originals or offering a fresh thematic angle.


    19- Marketing and Hype: Managing Expectations

    The promotional campaign for “Ballerina” leveraged the popularity of the John Wick franchise, setting expectations sky-high. Trailers emphasized action, legacy characters, and Ana de Armas’s star power. While this strategy garnered initial attention, it also contributed to a mismatch between marketing and the film’s actual tone and pacing.

    Expectation management is critical in spin-offs. As David Bordwell notes in Narration in the Fiction Film, audience expectations shape their interpretation of narrative cues. By leaning too heavily on Wick’s aesthetic and tone in its marketing, “Ballerina” may have unintentionally invited comparisons that overshadow its distinct elements. A more tailored promotional approach could have framed it as a character-driven psychological action thriller in its own right.


    20- Future Potential: Franchise or Footnote?

    “Ballerina” stands at a crossroads: it can either blossom into a compelling sub-franchise with its own voice or remain a stylish but forgettable footnote in the Wick saga. The ingredients are all there—an enigmatic protagonist, a rich mythos, and a unique aesthetic. What’s required is the courage to take creative risks and tell stories that diverge from the beaten path.

    With strategic writing and thematic ambition, a sequel or spin-off series could delve deeper into Eve’s psyche and the cultural politics of the assassin world. Drawing inspiration from works like The Hero with a Thousand Faces and Women Who Run with the Wolves, the franchise could explore archetypal female journeys in a way rarely seen in action cinema.


    21- Masses Flock to a “John Wick” Movie

    The global success of the John Wick franchise has turned each installment into a box office magnet. Audiences are drawn not only by Keanu Reeves’ brooding charisma but by the franchise’s stylized violence and world-building. Ballerina benefits directly from this gravitational pull—its association with the Wick name generates automatic intrigue and ticket sales. As media theorist Henry Jenkins argues, transmedia storytelling creates deeper audience engagement, and John Wick has successfully woven a mythos that fans want to explore across various mediums.

    However, this popularity also creates a paradox: expectations are sky-high. Fans come seeking not just action but a very specific Wickian aesthetic—clean choreography, noir-inspired visuals, and underworld codes. Ballerina leverages these expectations but also struggles beneath their weight, raising the critical question: can it be more than just an echo of its origin?


    22- Pop Cultural Consciousness

    The John Wick universe has transcended its cinematic boundaries to become a fixture of pop culture, influencing video games, fashion, and even lexicon. Terms like “the Continental,” “marker,” and “excommunicado” have become part of genre vocabulary. Ballerina steps into this pop cultural current, with clear aspirations to become a defining piece of this expanded lore.

    Yet true assimilation into pop culture requires more than association—it demands memorable moments, quotable lines, and visual motifs that capture the zeitgeist. While Ballerina gestures in this direction, it has yet to produce an indelible image or phrase on par with “Yeah, I’m thinking I’m back.” To truly embed itself in pop cultural memory, the film must evolve from derivative to iconic.


    23- “Ballerina,” the First to Be Released of the Many Planned “John Wick” Spin-Offs

    As the inaugural spin-off, Ballerina bears the burden of proof for the viability of the John Wick expanded universe. Its performance—both commercial and critical—will likely influence the trajectory of future projects like The Continental or Ballerina 2. If successful, it could serve as a proof of concept, similar to how Rogue One opened narrative doors within Star Wars.

    This strategic positioning, however, places Ballerina under intense scrutiny. Its storytelling choices, tone, and audience reception will serve as a litmus test. As Linda Hutcheon notes in A Theory of Adaptation, spin-offs must justify their existence not merely through legacy but through narrative necessity. Whether Ballerina passes this test remains a subject for debate.


    24- From the World of John Wick: Ballerina

    By branding itself explicitly as “From the World of John Wick,” the film situates itself within a known mythos. This approach leverages pre-existing loyalty, creating a narrative shortcut that allows viewers to engage without needing exhaustive exposition. But this branding also risks making the film feel like a subsidiary product—less a story in its own right than an appendix to the main text.

    To transcend this secondary status, Ballerina must offer a self-contained, emotionally resonant arc. When spinoffs lack independence, they risk becoming footnotes. J.R.R. Tolkien, who masterfully created a universe beyond The Lord of the Rings, insisted in his letters that “secondary worlds” must follow internal consistency and moral logic. Ballerina would benefit from a similar world-building philosophy.


    25- Fierce, Balletic Gunplay and Brutal Hand-to-Hand Combat

    The film delivers on action—a core expectation of its genre. Choreographed like a violent dance, the fight scenes merge the elegance of ballet with the rawness of street combat. This aesthetic choice distinguishes Ballerina, aligning with what David Thomson calls “kinetic storytelling,” where action replaces dialogue as the primary vehicle of narrative.

    Yet while visually striking, these sequences occasionally feel like style over substance. Without emotional stakes embedded in the violence, action can become spectacle without consequence. If the film can better fuse character psychology with combat—making each movement a revelation—it will elevate its action from performance to poetry.


    26- Just Another Convenient Doppelgänger

    A recurring critique is that Ballerina feels too familiar—another lone assassin, another dead family, another quest for revenge. The film risks being dismissed as a convenient doppelgänger of the original John Wick, rather than a unique narrative within the same world. The archetypes remain largely unchanged, begging the question of whether Ballerina is innovation or mere replication.

    To avoid becoming just another echo, the film must interrogate these tropes and flip them. It could challenge the revenge narrative, explore feminine rage differently, or disrupt genre conventions. As Roland Barthes observed, “The birth of the reader must be at the cost of the death of the author.” Ballerina must stop quoting Wick and start writing its own text.


    27- Presence of Keanu Reeves’ Iconic Boogeyman

    Keanu Reeves’ John Wick makes a brief yet pivotal appearance in Ballerina, reinforcing the cinematic connection and offering fan service. His presence serves as a symbolic baton pass, endorsing Eve Macarro’s journey. In franchise logic, this is more than a cameo—it is a benediction from the mythic predecessor.

    Yet this inclusion also raises a structural risk: the gravitational force of Wick’s persona can eclipse new characters. Just as Hamlet’s ghost haunts every scene even when absent, Wick’s legacy haunts Ballerina. The challenge is for Eve to emerge not as Wick’s echo, but as his narrative equal, distinct and defined in her own moral language.


    28- “Ballerina” is an Unequivocal Success

    On commercial terms, Ballerina has exceeded expectations, achieving strong box office numbers and solid streaming performance. For a spin-off, this is no small feat. It affirms that the John Wick universe can support new narratives without Keanu Reeves as the sole anchor. This is a major milestone in franchise diversification.

    However, success should not be measured only in dollars. The real test lies in cultural resonance and narrative impact. Will audiences remember Ballerina in five years? Will it shape genre evolution? If the film can build on its financial triumph with deeper storytelling in future entries, its success will not just be unequivocal—it will be enduring.


    29- Ana de Armas Holds Her Own as Eve Macarro

    Ana de Armas delivers a nuanced performance, balancing physical intensity with emotional vulnerability. She inhabits Eve with a sense of urgency and loss that makes her actions believable. Her background in roles like Knives Out and No Time to Die prepared her for this complex fusion of charm and combat.

    Critics may question whether her character is too thinly written, but de Armas imbues the role with gravitas. As actor Stella Adler once said, “Your talent is in your choice.” De Armas chooses to play Eve not as an untouchable warrior, but as a wounded soul seeking redemption. This performance provides the film its emotional spine.


    30- Ana De Armas Is A Rising Action Star

    With Ballerina, Ana de Armas solidifies her ascent as a bankable action lead. Her agility, screen presence, and willingness to perform stunts place her alongside modern icons like Charlize Theron and Michelle Yeoh. She redefines what an action hero can look like—graceful yet lethal, emotionally complex yet physically dominant.

    This marks a significant shift in genre dynamics. As Yvonne Tasker discusses in Spectacular Bodies: Gender, Genre and the Action Cinema, the emergence of women in action roles changes the visual grammar of the genre. De Armas doesn’t mimic male action heroes—she reinvents the mold. Her career trajectory now promises even richer roles in years to come.


    31- A Woman on a Lifelong Mission of Revenge

    The revenge arc is deeply gendered in Ballerina. Unlike male-driven vengeance narratives centered on pride or honor, Eve’s mission is tied to familial loss and emotional betrayal. This changes the emotional temperature of the film—less stoic, more raw. Her revenge is not a game, it’s a reckoning.

    And yet, this theme is not deeply mined. As Carol Clover argues in Men, Women, and Chain Saws, female revenge stories often walk a fine line between empowerment and exploitation. If Ballerina wants to stand apart, it must examine how gender reshapes vengeance—not just thematically but structurally.


    32- The Labyrinthian Rules of the “John Wick” Universe

    One of the franchise’s signatures is its byzantine system of codes, coins, and contracts. Ballerina continues this tradition, expanding on the internal politics and ritualistic codes of the assassin world. This framework lends the universe its operatic gravitas.

    However, these rules can feel opaque or overly contrived. A more transparent engagement with this mythology—perhaps through Eve’s struggle to navigate or subvert it—would add narrative urgency. As Umberto Eco suggests in The Role of the Reader, a good mythos invites participation. Ballerina needs to make its world more legible for that participation to flourish.


    33- Fighting With Her Fists, Feet, and an Ornate Array of Firearms

    The fight choreography in Ballerina is both brutal and balletic, emphasizing Eve’s resourcefulness. She uses everything—her body, her environment, her arsenal—with a dancer’s precision and a predator’s instinct. The effect is visceral, almost balletic chaos.

    Yet violence alone doesn’t define action quality. The choreography must align with character. Each move should express identity. As Aristotle asserts in Poetics, action reveals character. The most memorable combat scenes in Ballerina succeed when they echo Eve’s internal state—rage, resolve, vulnerability.


    34- No Time to Die

    Ana de Armas made a striking impression in No Time to Die, despite limited screen time. That appearance confirmed her ability to command attention in high-octane settings. Ballerina builds on that moment, giving her a narrative stage to showcase her full range.

    Comparisons are inevitable, and in many ways Ballerina feels like a spiritual sequel to that Bond cameo. But whereas Paloma in No Time to Die was a supporting flash, Eve is a slow-burning storm. She’s not comic relief or exotic interlude—she’s the story.


    35- What That Means Is That All the Fight Scenes and Shoot-Outs Are Marvelous Crowd Pleasers

    Ultimately, Ballerina fulfills its core promise: to entertain. The shoot-outs are dynamic, the fight scenes thrilling, the pacing efficient. For audiences seeking cinematic catharsis through choreographed violence, the film delivers a kinetic symphony.

    Yet action is only part of cinema’s language. For Ballerina to achieve lasting significance, it must not only please crowds but challenge them. Entertainment is valuable—but as Bertolt Brecht insisted, “Art is not a mirror held up to reality, but a hammer with which to shape it.” Ballerina wields its hammer. Whether it chooses to shape or merely shatter is the choice that lies ahead.


    Conclusion

    Ballerina is more than a stylish detour in the John Wick universe—it is a litmus test for the future of female-led action films within established franchises. With Ana de Armas’s compelling performance, fierce choreography, and symbolic potential, the film hints at what spin-offs can become when they dare to dream beyond the original text. Yet it also reveals the risks of narrative dependency and aesthetic mimicry.

    For all its high-octane thrills and noir-flavored grandeur, Ballerina must now answer its own call: will it remain an appendage to Wick’s legend, or forge a myth all its own? Only time—and perhaps a sequel—will tell.

    “Ballerina” pirouettes on the razor’s edge between homage and innovation, delivering a visually arresting but narratively uneven experience. While Ana de Armas proves a magnetic lead, the film struggles to balance character depth with franchise loyalty. Its aesthetic brilliance and symbolic ambitions hint at untapped potential, yet its overreliance on John Wick’s blueprint hampers its originality.

    For viewers seeking style and spectacle, “Ballerina” offers a compelling ride. But for those craving thematic complexity and narrative freshness, it remains a beautiful sketch waiting to be filled in. As cinema continues to evolve, the challenge for spin-offs like this is not just to expand a universe, but to earn their place within it.

    Bibliography

    1. Hutcheon, Linda. A Theory of Adaptation. 2nd ed., Routledge, 2012.
      – A foundational text on adaptation studies, useful in analyzing spin-offs and franchise narratives.
    2. Jenkins, Henry. Convergence Culture: Where Old and New Media Collide. NYU Press, 2006.
      – Discusses transmedia storytelling and fan engagement across multiple platforms, relevant for the John Wick universe.
    3. Barthes, Roland. Image-Music-Text. Translated by Stephen Heath, Hill and Wang, 1977.
      – Explores the concept of authorship and intertextuality, which is central to evaluating derivative works like Ballerina.
    4. Tasker, Yvonne. Spectacular Bodies: Gender, Genre and the Action Cinema. Routledge, 1993.
      – An essential resource for understanding gender roles and female action heroes in modern cinema.
    5. Clover, Carol J. Men, Women, and Chain Saws: Gender in the Modern Horror Film. Princeton University Press, 1992.
      – Though focused on horror, this text offers frameworks for analyzing gender and revenge motifs in genre film.
    6. Eco, Umberto. The Role of the Reader: Explorations in the Semiotics of Texts. Indiana University Press, 1979.
      – Useful for understanding how audiences interact with complex world-building like that found in the John Wick universe.
    7. Thomson, David. The Big Screen: The Story of the Movies and What They Did to Us. Farrar, Straus and Giroux, 2012.
      – Provides insight into kinetic storytelling and how visual style communicates narrative in action cinema.
    8. Brecht, Bertolt. Brecht on Theatre: The Development of an Aesthetic. Edited and translated by John Willett, Hill and Wang, 1964.
      – Offers a philosophical lens for examining whether films like Ballerina challenge or merely entertain the audience.
    9. Tolkien, J.R.R. The Letters of J.R.R. Tolkien. Edited by Humphrey Carpenter, Houghton Mifflin, 1981.
      – Commentary on world-building and internal logic, relevant to universe-building in franchises.
    10. IMDb Contributors.Ballerina (2025).” IMDb, https://www.imdb.com/title/tt13007588/. Accessed June 5, 2025.
      – For factual information on cast, crew, and production details.
    11. Box Office Mojo.Ballerina (2025) – Box Office Performance.” https://www.boxofficemojo.com/. Accessed June 5, 2025.
      – Source for commercial performance data and comparison within the franchise.
    12. Rotten Tomatoes.Ballerina – Audience & Critic Reviews.” https://www.rottentomatoes.com/. Accessed June 5, 2025.
      – Aggregated critical and audience reception, offering insight into broader public opinion.

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • Al-Riyadh Newspaper, June 5, 2025: Hajj Pilgrimages, Global Economic and Political Issues, Technological Advancements

    Al-Riyadh Newspaper, June 5, 2025: Hajj Pilgrimages, Global Economic and Political Issues, Technological Advancements

    These articles from Al-Riyadh newspaper cover a range of topics on June 5, 2025. Several pieces focus on preparations and services for the Hajj pilgrimage, highlighting efforts to manage large crowds through technology and integrated systems, as well as ensuring the safety and well-being of pilgrims. Other articles address global economic and political issues, including the stability of the gold and oil markets, the impact of trade tensions, and legal proceedings related to war crimes. Finally, the sources touch upon technological advancements, specifically the increasing role of artificial intelligence and the potential for new energy sources.

    Saudi Arabia’s Hajj Management: Services and Security

    Hajj is a fundamental religious observance in Islam, holding immense religious symbolism and historical significance. It is considered a strategic priority and represents the core principles of equality and devotion before the Creator. This great religious duty involves millions of pilgrims from around the world gathering in the Holy Sites. For Hajj 2025, it was anticipated that over 2 million pilgrims from 183 countries would participate, marking a 12% increase from the 2024 season.

    Saudi Arabia, under the leadership of the Custodian of the Two Holy Mosques and the Crown Prince, regards the service of pilgrims as a significant responsibility and honor. This dedication has been a constant since the Kingdom’s establishment. It is viewed as a comprehensive national, human, and spiritual undertaking. The primary objective is to ensure a safe, convenient, and well-organized Hajj experience for all pilgrims.

    To achieve this, the Kingdom has undertaken extensive infrastructure development and implemented various services:

    • Significant projects include the development and shading of areas in Muzdalifah and Arafat, featuring structures and mist pillars to enhance the pilgrims’ experience. There are also initiatives to cool and shade pathways with mist fans to mitigate the effects of direct sunlight heat.
    • Transportation services have been enhanced, with efforts to ensure seamless entry into Mina and the absence of unauthorized buses on pilgrim routes. The Mashaaer train operates as a shuttle service during the Hajj period. The Haramain High-Speed Railway runs frequently between King Abdulaziz Airport in Jeddah and Makkah, reducing travel time significantly. Medina buses provide shuttle services specifically for Arafat Day and Eid prayer, without disrupting the regular public transport schedule.
    • Cleanliness and waste management are prioritized, with electric waste compactors and ground storage units provided. Modern technologies and a large workforce are utilized for cleaning operations in Makkah and the Holy Sites.
    • Facilities at Miqats and associated mosques, such as Al-Sail Al-Kabeer, Wadi Muhrim, Yalamlam, Qarn Al-Manazil, and Al-Juhfa, as well as Al-Tan’eem and Al-Ja’ranah mosques, have been developed and expanded. This includes widening pathways, organizing entry and exit, and increasing prayer areas.

    Sophisticated management systems and technology play a critical role in organizing Hajj:

    • An integrated operational system relies on spatial readiness, real-time analysis, and continuous improvement to manage the Hajj ecosystem.
    • The Command and Control Center in Mina functions as the central hub for security operations, enabling monitoring, crowd management, and quick decision-making. It is equipped with advanced surveillance and data analysis systems.
    • Digital transformation efforts include using digital maps and rapid translation apps to assist lost pilgrims. The 911 unified security operations center utilizes automated systems to handle emergency calls and forward them to relevant authorities. Technology, including AI and drones, is employed for crowd management and transportation planning.
    • The “Hajj without a Bag” initiative facilitates services for arriving pilgrims at Taif Airport.
    • The “Makkah Route” initiative, which began in 2018, simplifies entry procedures for pilgrims from selected countries, demonstrating high satisfaction levels among beneficiaries.
    • A new methodology, “The Hidden Pilgrim,” is being piloted to assess the quality of services provided by government entities from the perspective of a regular pilgrim.
    • Real-time indicators and data analysis support decision-making and resource allocation.

    Ensuring the safety and security of pilgrims is paramount:

    • Strict security checkpoints are established at entrances to Makkah and surrounding areas, with comprehensive surveillance rings to enforce regulations.
    • The campaign slogan, “The pilgrim is in our eyes, and whoever violates is in our grasp,” conveys the Kingdom’s welcoming approach alongside its firm stance against any breaches of security or regulations.
    • Severe penalties, including imprisonment, significant fines, and deportation, are imposed on individuals caught transporting illegal pilgrims.
    • The National Guard actively participates in securing the Hajj season.
    • The necessity of obtaining Hajj permits is stressed to ensure orderly movement and prevent dangerous overcrowding. The Council of Senior Scholars supports this requirement, stating that performing Hajj without a permit is not permissible.
    • Advanced technology like AI and drones are used by security forces for monitoring and management.

    Comprehensive health services are provided to pilgrims:

    • The Ministry of Health offers integrated health services across the Holy Sites.
    • Mobile units and field hospitals are deployed in key locations to provide immediate care.
    • Health services are aligned with the goals of Saudi Vision 2030.
    • The “Prevention Before Treatment” initiative addresses heat-related risks, using smart bracelets for vulnerable pilgrims and deploying mobile cooling units.
    • A dedicated Hajj health application allows pilgrims to book appointments at clinics.

    The human and social dimension of Hajj is also emphasized:

    • Hajj is a powerful event that fosters international acquaintance and peaceful coexistence, bringing together people of diverse backgrounds.
    • Saudis, across different age groups, actively participate as volunteers in Mina and the Holy Sites, assisting pilgrims with guidance, distribution of food and water, and other support.
    • Volunteering during Hajj provides Saudis with valuable skills and strengthens their connection to the nation and the service of guests.
    • Saudi women play a significant and active role in serving pilgrims across various sectors, including health, security, and volunteering, showcasing their professionalism and readiness.
    • The “Adahi” project facilitates the ritual sacrifice and ensures the organized distribution of meat to eligible recipients domestically and internationally. This program, overseen by the Royal Commission for Makkah City and Holy Sites, has undergone operational advancements and utilizes a digital monitoring system.
    • Pilgrims hosted under special programs, such as those from Palestine, Iraq, and Indonesia, have expressed gratitude and praised the exceptional services, hospitality, and smooth procedures they experienced. Pilgrims who are families of martyrs and injured individuals from operations like “Decisive Storm” and “Restoring Hope” were also hosted by the Ministry of Defense.

    Overall, the sources highlight that Hajj management in Saudi Arabia is a complex, multi-faceted operation that integrates advanced technology, robust security, comprehensive health services, and dedicated human efforts within a strategic framework aimed at continuously enhancing the pilgrim experience and ensuring the safety and comfort of all who undertake this significant journey.

    Global Markets and Saudi Economy Update

    Based on the sources, the discussion of Economic and Financial Markets covers several areas, including the Saudi stock market, global commodity markets like gold, oil, and gas, currency movements, broader global economic factors like trade tensions and central bank policies, and specific economic sectors in Saudi Arabia such as real estate, artificial intelligence, entertainment, and media.

    Saudi Arabian Markets:

    • The main Saudi stock market index closed higher, gaining 172.10 points to close at 11004.53. The value of traded shares reached 4.6 billion riyals. 183 million shares were traded. Shares of 191 companies increased in value, while 50 companies saw a decrease. Some companies with the largest increases included Acwa Power, Tabuk Cement, Burgerizzr, Al-Babtain, and Saudi Cement. Companies with the largest decreases included Saudi Research and Media Group, Jadwa REIT Saudi, Aldawaa, and Al Mo’ather REIT, with declines ranging between 6.33% and 7.03%.
    • The Saudi Parallel Market index (Nomu) also closed higher, gaining 257.90 points to close at 27307.74. Traded values exceeded 27 million riyals, with over 3 million shares traded.
    • Companies with the highest trading activity by quantity included Acwa Power, STC, Al-Rajhi, and Al Ahli. The most active companies by value were Acwa Power, Al-Rajhi, Al Ahli, Saudi Electricity Company, Saudi Industrial Investment Company, and Americana.
    • Regarding the Riyadh real estate market, there is anticipation for the Royal Commission for Riyadh City’s announcement about a platform for submitting residential land applications, guided by the Crown Prince to address high land and rent prices and achieve market balance. This is part of a series of measures aiming for a stable housing market by controlling supply and demand, reducing discontinuations, and limiting speculation. Follow-up showed positive engagement and market correction. Some have questioned the effectiveness of these measures. The article emphasizes that real estate balance is a national, human, and developmental vision for building a suitable nation.

    Global Commodity Markets:

    • Gold: Spot gold prices remained stable at $3,351.49 per ounce, while US gold futures were stable at $3,375. Factors supporting gold include US job data, trade uncertainty between the US and China, geopolitical tensions, and central bank caution. Gold tends to perform well during periods of economic uncertainty. Escalating military action between Russia and Ukraine, and reports of stalled Iran nuclear talks, also kept markets focused on safe havens like gold. Gold’s volatile performance was mainly due to improved risk appetite following anticipated US-China talks. The market saw renewed demand after Ukraine’s strikes against Russia.
    • Oil: Crude oil prices fell due to concerns about OPEC+ production increases and tensions over tariffs threatening global economic forecasts, although concerns about Canadian supply disruption limited the decline. Brent futures fell 17 cents to $65.46 per barrel, while WTI fell 19 cents to $63.22 per barrel. Prices had risen earlier due to Canadian wildfires and expectations of Iran rejecting a US proposal regarding the nuclear deal. Analysts noted that despite supply concerns, oil markets struggled to maintain gains, as OPEC+ increases limit upward movement. Analysts expect the current decline in the front end of the crude oil futures curve is a result of significant inventory drawdowns since the beginning of the year.
    • OPEC+ production increases limit upward movement. Eight OPEC+ countries agreed on May 31 to accelerate voluntary oil production cuts, collectively increasing output by 411,000 barrels per day in July. OPEC indicated that stable global economic forecasts and sound market fundamentals, along with declining oil inventories, were reasons for this increase.
    • India’s Minister of Petroleum expects global crude oil prices to range around $65 per barrel in the future, noting sufficient supply. Lower oil prices help India reduce its import bill and encourage refineries to diversify supply sources. India spends around $150 billion annually on oil imports, and a 20% price drop could save $30 billion. India has diversified its oil purchase sources from 27 countries previously to 39 recently, and started buying from Argentina, bringing the total to 40. India is intensifying talks with countries in South America to boost energy relations. Reforms in India’s domestic oil sector are expected to reduce reliance on imports in the future. India aims to exploit untapped oil reserves by opening new offshore areas for exploration and has increased its sedimentary basin exploration area from 6% to 10% in the last decade, targeting 15% soon.
    • Natural Gas: India is the fourth largest importer of natural gas globally. The country aims to increase the share of gas in its energy mix to 15% by 2030. India is looking to increase purchases of US LNG and is considering proposals to cancel import taxes on it. Indian companies are in talks with US firms for additional LNG sources. Shell has taken a positive final investment decision on the Aphrodite gas project offshore Trinidad and Tobago, expected to start production in 2027. This project, along with the Dragon field, aims to supply gas to the Atlantic LNG facility in Trinidad.

    Currencies and Other Financial Assets:

    • The Dollar saw some strength due to speculation about US-China trade talks and confirmation from Federal Reserve officials that interest rates would remain unchanged in the near term. The Dollar index, which measures the US currency against six major currencies, stood at 99.31.
    • The Euro remained stable against the Dollar at 1.1368.
    • Among other precious metals, silver fell, platinum rose, and palladium fell in spot trading.
    • In industrial metals, copper prices received some support from hopes of easing economic pressure on China. Futures for copper rose on the London Metal Exchange and in the United States.

    Broader Global Economic Context:

    • Global stock markets saw Asian stocks rise, driven by technology shares, while the Dollar fell. Investor focus was on the pace of trade negotiations and uncertainty about progress. European stock futures indicated a higher opening ahead of the ECB meeting.
    • South Korean stocks and currency rose following the election of the liberal candidate, boosting hopes for economic stimulus and market reforms. The KOSPI index rose over 2% to its highest level since August 2024.
    • US job opportunities increased in April, but layoffs also rose, suggesting a slowdown in the labor market amidst gloomy economic forecasts due to tariffs.
    • The OECD warned of a sharper-than-expected global economic slowdown, attributing it mainly to the repercussions of the US trade policy. The OECD forecast the global economy to slow from 3.3% last year to 2.9% in 2025 and 2026.
    • US-China trade tensions remain a key factor. The US is raising tariffs on steel and aluminum imports from 25% to 50% effective Wednesday. The US President called reaching an agreement with China’s Xi Jinping “very difficult”. The US had accused China of violating a trade agreement, which Beijing denied.
    • Central banks use interest rates to control inflation. Lower rates can stimulate economic growth and demand. A Federal Reserve official noted that inflation from US tariffs on imports might be quick, but the economic slowdown caused by tariffs will take longer.
    • The US public debt reached approximately $36.2 trillion by June 2025, equaling about 124% of US GDP. US bonds are the main borrowing tool for the US government. The US faces risks if Congress refuses to raise the debt ceiling to meet federal obligations. A Moody’s report predicted US interest costs would rise to $1.8 trillion by 2035. The agency had downgraded the US credit rating from Aaa to Aa1 in May 2025 due to concerns about debt growth, rising cost of debt, and chronic fiscal deficit.

    Economic Sectors in Saudi Arabia:

    • Artificial Intelligence (AI): Saudi Arabia leads globally in government AI strategy standards according to the Global AI Index for 2024. A Saudi AI company, Humainy, was founded in May by the Crown Prince. A strategic partnership was signed between Humainy and Nvidia (an American company considered a cornerstone of AI technology). The deal focuses on acquiring advanced GPU processors. The Saudi AI sector is expected to reach around $140 billion in the next five years.
    • Entertainment and Leisure: The Saudi Entertainment and Amusement (SEA) Expo is highlighted as a strategic platform for the sector. The seventh edition attracts decision-makers seeking growth opportunities in Saudi Arabia’s fast-growing market. The event facilitates direct deals, partnerships, and knowledge exchange. Discussions at the SEA Summit included interactive technology, AI, e-sports, and designing sustainable entertainment destinations. Partnerships were signed during the event, reflecting the sector’s adoption of specialized solutions. The expo supports Vision 2030 goals to build a competitive entertainment sector, diversify the economy, and create jobs.
    • Media and Advertising: The media sector in Saudi Arabia is undergoing strategic transformations, supporting Vision 2030 by enhancing quality of life and presenting the Kingdom’s vision. The media landscape, including television, radio, and digital platforms, has seen growth and attracted investment. Regulatory frameworks are in place to organize the media market and protect consumers. The sector’s economic contribution is noted, providing opportunities for local and international investors. The return of cinema and awards has boosted production companies.

    The sources paint a complex picture of interconnected economic and financial markets, influenced by global trade dynamics, geopolitical events, and national policies, alongside specific developments within the Saudi Arabian economy and its strategic Vision 2030 initiatives.

    Global Dynamics and Saudi Engagements

    Based on the sources provided and our conversation history, the topic of International Relations is discussed through several lenses, including global conflicts, diplomatic engagements, international economic dynamics, and multilateral cooperation efforts.

    Global Conflicts and Tensions:

    • The sources detail ongoing Israeli aggressions in the Gaza Strip, including intense shelling and raids. This has resulted in rising casualties and a severe humanitarian situation, with hospitals facing critical conditions. International pressure is mounting for an immediate ceasefire. There is a notable lack of international protection for civilians and aid facilities in Gaza. The sources mention specific developments like the Canadian police opening an investigation into potential war crimes in Gaza involving Israeli soldiers who hold Canadian citizenship, and a reported decline in public support for Israel in Europe. Aid distribution in Gaza has faced challenges, with reports of centers closing, an organization supported by the US and Israel halting distribution, and the Israeli army stating centers would be closed due to “renewal and organization” work. Concerns have been raised about the transparency and neutrality of aid organizations receiving support from the US and Israel. The sources also report on Israeli forces conducting raids and demolishing infrastructure in Palestinian territories like Tubas.
    • The war in Ukraine is highlighted with concerns about escalating risks. A US official noted that the situation is “heating up in a big way” after Ukrainian forces used cruise missiles to target Russian bombers. There are warnings about the potential for a nuclear accident in Ukraine due to continued aerial attacks, a concern reiterated by the Director General of the International Atomic Energy Agency (IAEA). IAEA experts are present at nuclear power plants in Ukraine. The UK has pledged to provide Ukraine with 100,000 drones by the end of the year as part of its military support. A Russian security official was reported to have arrived in North Korea to meet with its leader.

    International Diplomacy and Bilateral Relations:

    • The Arab League has called for an end to the war in Gaza and the implementation of UN Security Council and General Assembly decisions. They demand the end of the Israeli occupation and urge global recognition of a Palestinian state based on international legitimacy resolutions and the Arab Peace Initiative.
    • Specific bilateral engagements mentioned include congratulations from the Saudi King and Crown Prince to the newly elected President of Korea, highlighting the distinguished relations between the two countries.
    • Saudi Arabia’s consistent position in supporting the Palestinian cause, politically, economically, and religiously, is acknowledged by a Palestinian official who expressed gratitude for the Kingdom’s hospitality towards Palestinian pilgrims.
    • The sources mention a book discussing Algeria’s presence in Saudi literature, noting Saudi Arabia’s historical support for the Algerian cause since its revolution.
    • Saudi Arabia hosted families of martyrs and injured individuals from Yemeni forces participating in the “Operation Decisive Storm” and “Operation Restore Hope” campaigns. This initiative is presented as reflecting Saudi Arabia’s status as a beacon for the Muslim world and its effort to strengthen Islamic ties.

    International Economic Dynamics and Trade:

    • Trade tensions, particularly between the US and China, are a significant factor influencing markets. The US President has raised tariffs on steel and aluminum imports and described reaching an agreement with China as “very difficult”. The OECD has warned that the repercussions of US trade policy are a main cause of a sharper-than-expected global economic slowdown. While some trade talks were anticipated, uncertainty about progress remains. Other countries like the UK (initially) and Mexico have reacted to the US tariff policies.
    • Global oil and gas markets are discussed, including the impact of OPEC+ production decisions on prices. India’s role as a major oil and gas importer is detailed, along with its efforts to diversify supply sources from numerous countries. India is also exploring boosting energy relations with South American countries and is interested in increasing purchases of US LNG. US sanctions have impacted Russian oil sales.
    • Challenges within the international airline industry related to meeting emission targets and the reliance on sustainable aviation fuel are mentioned.

    International Cooperation and Saudi Arabia’s Role:

    • Saudi Arabia plays a significant role in facilitating international gatherings, particularly the Hajj pilgrimage, which involves pilgrims from numerous countries. Initiatives like the “Makkah Route” program, involving cooperation with seven countries, aim to streamline the entry and experience of pilgrims. The Kingdom has also implemented advanced technological systems for crowd and safety management during Hajj, including collaborations with experts from countries like Singapore and Japan for the “Digital Hajj” conference.
    • Beyond Hajj, Saudi Arabia is positioning itself as a global center for developing solutions to major human challenges. This includes signing a cooperation agreement with the WHO to establish a global center for disaster management training. A WHO report praised Saudi Arabia’s model of combining technological innovation and human compassion in managing large gatherings.
    • In the field of Artificial Intelligence, a strategic partnership has been formed between the newly founded Saudi AI company, Humainy, and the American company, Nvidia, focusing on acquiring advanced processors. This is highlighted as a significant step in international collaboration in AI.

    The sources collectively illustrate that international relations are currently shaped by ongoing conflicts, significant trade tensions, dynamic energy markets, and various instances of bilateral and multilateral cooperation, with Saudi Arabia actively engaging on multiple fronts, including regional conflicts, economic partnerships, and global initiatives related to humanitarian efforts and technology.

    Global Energy Markets and Supply Dynamics

    Based on the information from the sources, the discussion around Oil and Energy covers several key areas, including global market dynamics, geopolitical influences, energy security and diversification efforts, developments in specific energy projects, and initiatives towards sustainable energy and addressing risks.

    Global Oil Market and Prices:

    • Global crude oil prices are expected to be around $65 per barrel in the future perspective, according to India’s Petroleum Minister. This is a decrease compared to March ($73) and April ($68).
    • Several factors are influencing oil prices. There are voluntary production cuts by eight OPEC+ countries. However, these same countries agreed to increase their crude oil production by 411,000 barrels per day in July. This is the third consecutive monthly increase in quotas.
    • The sources indicate that global production of oil and liquids is expected to grow much faster than oil demand.
    • Stable global economic forecasts, lower oil inventories, and sound market fundamentals are cited as reasons for the quota increases.
    • Sustainable production increases are anticipated to negatively affect oil prices, especially after the summer.
    • In the short term, oil prices saw a decrease influenced by concerns over OPEC+ production increases and trade tensions. This followed gains the previous week, which were driven by concerns over Canadian supply disruptions and stalled Iran nuclear talks.
    • Analysts note that the market is finding it difficult to extend gains despite supply concerns, due to the OPEC+ increases. The forward price curve for crude oil shows a premium for prompt delivery over later months (contango), suggesting that the market anticipates future stagnation due to planned supply increases and a broader slowdown in the global economy.

    Geopolitical Influences and Supply Concerns:

    • Trade tensions, particularly between the US and China, are contributing to uncertainty and impacting economic outlooks, which in turn affects energy markets.
    • The war in Ukraine continues to pose risks related to nuclear safety due to continued aerial attacks. The Director General of the International Atomic Energy Agency (IAEA) has warned about the danger of a nuclear accident in Ukraine. IAEA experts are present at nuclear power plants in Ukraine.
    • US sanctions on Moscow have impacted Russian oil sales, leading India to become the largest buyer of seaborne Russian oil offered at a discount. An Indian oil company anticipates a likely decrease in Russian oil imports due to recent US sanctions. The sanctions are reported to have caused “colossal losses” and legal issues globally. Russia is the world’s second-largest crude producer after the United States.
    • Supply disruptions due to Canadian wildfires have provided some support to oil prices by reducing output. Estimates suggest the fires are affecting around 350,000 barrels per day or about 7% of Canada’s total crude production. Some analysts believe the reduction in Canadian supply could offset more than half of the planned OPEC+ increases next month.
    • Geopolitical factors like the Ukraine war and the stalled Iran nuclear talks add a risk premium to prices, although their immediate impact seems limited.

    India’s Energy Security and Diversification:

    • India is a major importer of oil and gas, spending around $150 billion annually on oil imports. A 20% drop in oil prices could save India $30 billion.
    • India has been actively diversifying its oil supply sources, buying from around 40 countries. It has recently started purchasing crude oil from Argentina. India is looking to boost energy relations with countries in South America.
    • The country encourages domestic exploration and production to reduce reliance on imports. India has increased its exploration area in sedimentary basins and has seen some success in recent exploration operations.
    • In the natural gas sector, India is the fourth-largest importer of LNG globally. It imported 26.58 million metric tons last year. The United States is the second-largest supplier of LNG to India.
    • India is considering removing tariffs on US LNG imports to boost purchases and reduce its trade surplus with the US. Indian companies are also negotiating with US firms for additional LNG supplies. India aims to increase the share of gas in its energy mix from the current 6.2% to 15% by 2030.

    Other Energy Developments and Projects:

    • In Trinidad and Tobago, Shell has made a final investment decision on the Aphrodite gas project. Production is expected to start in 2027 and reach a peak of 18,400 barrels of oil equivalent per day. This gas will be used by the Atlantic LNG plant in Trinidad, where Shell holds a 45% stake and which is currently facing gas shortages. The project is expected to expand Shell’s integrated gas business and leverage existing assets in a region known for abundant gas.
    • The international airline industry faces significant challenges in meeting emissions targets due to the low production and high cost of sustainable aviation fuel (SAF). Airlines aim for net-zero emissions by 2050, but SAF production is only expected to reach 2 million tons in 2025, representing just 0.7% of their fuel consumption. Airlines are calling for greater action from energy companies and partners to increase SAF volumes. Long-term purchase agreements are seen as necessary.

    Sustainable Energy Initiatives:

    • As part of the “Green Hajj” initiative, Saudi Arabia installed 50 megawatts of solar power units in Mina and Arafat, which are projected to provide 40% of the electricity needs in the holy sites. This initiative also included distributing reusable water bottles to reduce plastic waste.

    Saudi Arabia’s AI Strategy and Hajj Management

    Based on the information from the sources, Artificial Intelligence (AI) is discussed primarily in the context of Saudi Arabia’s technological advancements, economic development, and its application in managing large-scale events like Hajj. The sources also provide a brief historical overview of the field.

    Here’s a breakdown of the discussion on AI:

    1. Saudi Arabia’s Strategic Focus on AI:
    • Saudi Arabia is noted for its significant progress in AI, having topped the global AI index in 2024.
    • This strategic focus is highlighted by the establishment of a Saudi AI company named “Humania” by the Crown Prince during his visit to US President Donald Trump.
    • A strategic partnership was signed between Humania and the US company Nvidia. Nvidia is referred to as an “AI giant” and holds a significant share of the global AI processor market, estimated at 85%.
    • The partnership specifically involves access to advanced GPUs, including the GH300 processors, making Humania the first non-US company to acquire them. Other GPUs mentioned in this context are the H100 and A100.
    • The sources express hope that Humania will benefit from Nvidia’s pioneering experience to help localize the chip industry, train Saudi talent, and potentially involve the Ministries of Education and Human Resources.
    • The forecast for the value of the Saudi AI sector is estimated to reach around $140 billion in the next five years.
    1. Application of AI in Hajj Management:
    • AI techniques are being practically applied to enhance the management of Hajj.
    • In the Command and Control center in Mina, AI techniques are being used for the first time this Hajj season as part of the latest technologies for real-time monitoring and managing crowd density and light transport.
    • The successful Hajj season of 2025, which saw over 2 million pilgrims, is described as a result of a cumulative strategy utilizing “smart technologies”, which include AI techniques, thermal cameras, drones, and data analysis algorithms used to determine pilgrim paths with 98% accuracy.
    • The application of Saudi AI in crowd management was a specific topic of study at the “Digital Hajj” conference, attended by experts from Singapore and Japan.
    1. Historical Context of AI:
    • The sources briefly trace the origins of AI, noting that the fundamental question of whether machines can think was posed by the mathematician Alan Turing in the mid-1950s.
    • The term “Artificial Intelligence” was coined in 1956.
    • Early AI programs developed include Logic Theorist and ELIZA.
    • Significant developments over the years included the creation of neural networks and algorithms like backpropagation.
    • Milestones such as Deep Blue defeating a world chess champion in 1997 are mentioned, marking AI’s entry into professional competitive arenas.
    • AI has since become integrated into daily life, found in devices like smart vacuum cleaners, cooking appliances, self-driving cars, and phones.
    • The field has progressed to generative AI, with successful models like GPT emerging around 2022.
    • The need for ethical guidelines and “red lines” for generative AI is highlighted due to potential misuse and risks like academic dishonesty.
    1. AI in Other Contexts:
    • Artificial Intelligence was listed as one of the key topics discussed at the SEA Expo 2025, an exhibition focused on the entertainment and leisure sector in Saudi Arabia.

    Overall, the sources portray AI as a strategically important and rapidly developing field, particularly for Saudi Arabia, where it is being leveraged for economic growth and the technological enhancement of services, especially in managing large gatherings like the Hajj.

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • SQL Fundamentals and Practical Applications SQL Full Course 2025 Complete SQL Course For Beginners Learn SQL

    SQL Fundamentals and Practical Applications SQL Full Course 2025 Complete SQL Course For Beginners Learn SQL

    The provided text is a SQL tutorial. It covers fundamental SQL commands such as CREATE TABLEINSERTUPDATEDELETETRUNCATE, and DROP, explains data types (CHAR vs. VARCHAR), and demonstrates various query techniques, including joins, subqueries, window functions, and the use of CASE statements. The tutorial also introduces stored procedures, triggers, error handling, and pivot/unpivot operations, using practical examples and exercises to illustrate these concepts. Finally, it shows how to create and use user-defined functions.

    SQL Study Guide

    Quiz

    Instructions: Answer each question in 2-3 sentences.

    1. What is the primary role of SQL in data-related fields, and name three specific roles that require it?
    2. Beyond SQL, what other skills are essential for a data analyst, and why are they crucial for success in the job?
    3. Explain the client-server model in the context of SQL, including how requests and responses are exchanged and the role of SQL.
    4. Describe the hierarchical structure of a SQL server, from the server level down to individual data elements.
    5. What is the difference between DDL and DML? Give examples of commands for each.
    6. How do GRANT and REVOKE statements contribute to data security, and who are the typical users for each?
    7. Explain the function of ROLLBACK, COMMIT, and SAVEPOINT in transaction control, and give an example of their purpose.
    8. What is the main difference between the TRUNCATE and DELETE commands, and which is generally faster and why?
    9. Describe the difference between the data types CHAR and VARCHAR, and give examples of their use cases.
    10. What is a primary key constraint, and what two rules must be followed for a value to meet this constraint?

    Quiz Answer Key

    1. SQL is a fundamental language for interacting with databases and is essential for data engineers, data analysts, and data scientists. All three roles require a strong understanding of SQL to manage, query, and analyze data.
    2. A data analyst needs business fundamentals alongside SQL, PowerBI, and Tableau because every business operates differently, meaning understanding the industry is essential for drawing meaningful conclusions from data.
    3. In the client-server model, a client (like a management tool) sends SQL requests to a server, which then responds with the requested data. SQL is the language used for this communication between the client and the server.
    4. A SQL server is organized with a server at the top, followed by multiple databases, each containing tables, which are made up of rows and columns. Additionally, schemas define the relationships between these tables.
    5. DDL (Data Definition Language) is used to define the structure of the database, such as CREATE, ALTER, and DROP table commands. DML (Data Manipulation Language) is used to manage the actual data, including INSERT, UPDATE, and DELETE commands.
    6. GRANT and REVOKE statements manage user permissions, granting access to specific database operations while ensuring the correct level of access for different users. Typically, developers get INSERT, UPDATE, and DELETE access, while end-users might only get SELECT.
    7. ROLLBACK undoes recent changes, COMMIT finalizes them, and SAVEPOINT creates intermediate markers to return to. For example, after doing several inserts, ROLLBACK would revert the table to its state before the changes.
    8. TRUNCATE removes all records from a table and recreates it (a DDL operation) and is faster since it does not log each row removal. DELETE removes rows one by one (a DML operation) and is slower.
    9. CHAR is a fixed-size data type that allocates space, regardless of how much data is used (like gender ‘M’ or ‘F’). VARCHAR is a variable-size data type that only uses space based on the size of the stored data (like a name).
    10. A primary key constraint ensures that values are unique and not null. No duplicate values or null values are allowed within a primary key column.

    Essay Questions

    Instructions: Answer each question in an essay format.

    1. Discuss the different types of SQL commands (DDL, DML, DCL, TCL), explain their purposes, and describe how they are used in a real-world database management context.
    2. Compare and contrast the use of DELETE, TRUNCATE, and DROP commands. Explain when each command should be used and discuss their implications for data and database structure.
    3. Explain how you would use SQL functions to manipulate and extract data, providing examples of string, numerical, and date-related functions, along with real-world use cases.
    4. Describe what window functions are, explain their purpose, and describe the differences between RANK, DENSE_RANK, and ROW_NUMBER, and provide a scenario where using PARTITION BY would be beneficial.
    5. Explain what subqueries are, their purpose, and how they can be used within SQL queries, giving examples of scenarios where they might be used and when they are more useful than a JOIN operation.

    Glossary

    • SQL (Structured Query Language): A standard language for accessing and manipulating databases.
    • DBMS (Database Management System): Software that manages databases and allows for storage, retrieval, and modification of data.
    • Server: A computer program or system that provides services to other computer programs (clients).
    • Client: A computer program that requests services from a server.
    • SSMS (SQL Server Management Studio): A Microsoft tool used to manage and interact with SQL Server databases.
    • DDL (Data Definition Language): SQL commands used to define the structure of a database (e.g., CREATE, ALTER, DROP).
    • DML (Data Manipulation Language): SQL commands used to manipulate data within a database (e.g., INSERT, UPDATE, DELETE).
    • DCL (Data Control Language): SQL commands used to control access to data and database objects (e.g., GRANT, REVOKE).
    • TCL (Transaction Control Language): SQL commands used to manage transactions within a database (e.g., COMMIT, ROLLBACK, SAVEPOINT).
    • Schema: A blueprint or structure of a database, including tables, relationships, and constraints.
    • Table: A data structure used to store data in rows and columns within a database.
    • Row: A horizontal set of data in a table, also known as a record.
    • Column: A vertical set of data in a table, representing a specific attribute or type of data.
    • Primary Key: A unique identifier for each record in a table and that cannot contain null values.
    • Foreign Key: A field in a table that refers to the primary key of another table to establish relationships.
    • Constraint: A rule that enforces the integrity of data in a database (e.g., primary key, foreign key).
    • CHAR: A fixed-length string data type.
    • VARCHAR: A variable-length string data type.
    • Transaction: A sequence of operations performed as a single logical unit of work on a database.
    • Rollback: The process of undoing changes made during a transaction.
    • Commit: The process of saving changes made during a transaction.
    • Savepoint: A point within a transaction to which you can roll back changes.
    • Truncate: A command that removes all data from a table, and is faster than delete.
    • Drop: A command that removes an entire database object, such as a table.
    • Index: A data structure that improves the speed of data retrieval operations on a database table.
    • Clustered Index: A special type of index that physically sorts and stores the data rows of a table based on the indexed columns. A table can have only one clustered index.
    • Non-Clustered Index: A data structure that provides a faster access to data based on indexed columns but the data is not stored in a sorted order. A table can have many non-clustered indexes.
    • View: A virtual table based on the result-set of a SQL statement, not physically stored like a regular table.
    • Function: A block of code that performs a specific task and may return a value.
    • Stored Procedure: A set of SQL statements stored in a database for reusable operations.
    • Trigger: A SQL procedure that is automatically executed in response to certain events on a particular table.
    • Subquery: A query embedded inside another query, often in the WHERE or FROM clause.
    • CTE (Common Table Expression): A temporary named result set used within a single query, that is not stored in the database.
    • Pivot: A process of converting rows to columns to summarize data.
    • Unpivot: A process of converting columns to rows, often to normalize or standardize data.
    • Window Functions: Functions that operate on a set of rows (a window) related to the current row, which includes functions like RANK, DENSE_RANK, and ROW_NUMBER.
    • Moving Average: A calculation of the average of a certain number of data points, that is used for data smoothing.
    • Epoke Time: A system for tracking points in time as a count of seconds since 1970.

    SQL Fundamentals for Data Professionals

    Okay, here’s a detailed briefing document summarizing the main themes and important ideas from the provided sources, complete with quotes:

    Briefing Document: SQL Fundamentals, Data Roles, and Advanced SQL Concepts

    Introduction

    This document summarizes key concepts and practical applications of SQL as presented in the provided source material. The focus is on SQL as a foundational skill for various data-related roles, core SQL concepts, and advanced techniques such as window functions, subqueries, views, stored procedures, security, indexing, and data transformation (pivot/unpivot). The training materials highlight the importance of hands-on practice and deep understanding of error messages.

    I. SQL as a Core Skill for Data Professionals

    • SQL is foundational for various data roles: The source emphasizes that SQL is an essential skill for data analysts, data engineers, and data scientists.
    • “that either you be data engineer or you be a data analyst you need SQL okay”
    • Specific Tech Stack: Different roles require different tools along with SQL:
    • Data Analyst: “learn SQL along with learn powerb and Tableau”
    • Data Engineer: “learn SQL and learn Informatica learn talent talent and Learn Python”
    • Data Scientist: “learn SQL Learn Python learn machine learning”
    • Importance of Business Knowledge: SQL skills must be complemented by business acumen:
    • “data analy job is not only learning SQL what query to write what table to fetch the data from how to build a chart he can do this only if he know a business correct if you don’t know the business you can’t do it”
    • Purpose-Driven Learning: Learning SQL should be intentional, to understand why and how tools like PowerBI or Python are needed.
    • “now whenever someone teaches you powerbi you know why powerb I’m learning whenever teacher you python you’ll learn why python I’m learning you you’ll be knowing that beforehand in that case you can write ask him right questions”
    • SSMS as the primary tool: The course uses SQL Server Management Studio (SSMS) as the primary tool.

    II. Core SQL Concepts

    • SQL Server Architecture: The server has a client component (like SSMS) which makes requests, and the server sends responses. The communication is done using the SQL language.
    • “so how it works so you send a request to server and server will respond back to you as a response…when server and client is talking even they need a language and that language itself is called SQL structured query language”
    • Database Hierarchy: A SQL server contains multiple databases, each with multiple tables, and tables contain rows and columns. Related tables form a schema.
    • “a database server will have multiple components inside it see it will have multiple databases it will have multiple databases database DB1 it could be db2 it could be db3…and the set of tables which are connected to each other with relationship is called what… schema”
    • SQL Language Subsets: SQL is broken down into:
    • DDL (Data Definition Language): For defining the structure (skeleton) of the database (e.g., CREATE, ALTER, DROP, TRUNCATE)
    • “anything which deals with the skeleton of your database like create the table alter the table alter means remove a column from the table add a column from the table drop remove the table truncate the table”
    • DML (Data Manipulation Language): For working with actual data (e.g., INSERT, UPDATE, DELETE)
    • “once you have the skeleton next is what you have to populate the data right…insert means add some data delete means remove some data update means change some data”
    • DCL (Data Control Language): For managing security permissions (e.g., GRANT, REVOKE)
    • “proper accesses should be given to the right people so Grant and revoke statements will take care about it”
    • TCL (Transaction Control Language): For managing transactions (e.g., COMMIT, ROLLBACK, SAVEPOINT).
    • “then TCL is undo redo all those things har what do you mean by undo redo suppose you are executing some commands one 1 2 3 4 5 6 7 eight commands then later you realized oh something went wrong…at that time I will hit a roll back command”
    • Importance of Error Messages: Reading error messages is critical for learning.
    • “whenever you hit an error always read the error guys 99% of the new developers ignore this suggestion that’s the reason they will struggle in the initial days”
    • Data Types: Understanding INT, VARCHAR, CHAR is important:
    • CHAR is fixed-size storage, and VARCHAR is variable size, where space is only allocated when used.

    III. Practical SQL Examples and Hands-On Learning

    • Table Creation & Manipulation: The source covers how to create tables (using CREATE TABLE) with different data types and how to insert data.
    • Example: CREATE TABLE countries (countryID INT, countryCode VARCHAR(2), countryName VARCHAR(20));
    • Data Insertion: Insert data into tables using the INSERT INTO command.
    • Data Updates: Use UPDATE to change data based on conditions using a WHERE clause.
    • “update countries so which which column value you want to set country code Type country code country code you have to tell set before that you have to tell set set that’s the keyword”
    • Data Deletion: Use DELETE to remove rows based on conditions using a WHERE clause.
    • “delete from countries where this what do you expect after I execute this command only two IDs will get deleted”
    • Table Truncation & Dropping:TRUNCATE removes all data but keeps the table structure (DDL operation).
    • “truncate means yes truncate means drop the table and recreate the table two things is happening inside truncate first the table is dropped and then table is recreated”
    • DROP removes both the table structure and data (DDL operation).
    • “drop table countries what this will do what this will do now it will delete the data as well as structure both”
    • Altering Tables: Modify table structures, add or change columns, using the ALTER TABLE statement.
    • “alter table countries alter column which column I want to alter country code what should be my new data type care of three”
    • Constraints: Primary keys (PRIMARY KEY) are used to ensure uniqueness and non-null values and help prevent duplicate data.
    • “primary key what is that keyword doing that was not there earlier when I have written my first table it’s a constraint…not null plus unique”
    • Importance of Practice: Regular practice is essential for mastering SQL.
    • “writing it’s very simple but when you try to write it right that’s where you’ll feel difficulty when I’m doing it looks very easy but when you are doing on your own you you you’ll not able you’ll not be able to write even one line in order to overcome that you have to regularly practice there is no substitute for learning SQL other than practice”

    IV. Advanced SQL Topics

    • String & Number Functions: SQL offers functions for string manipulation (e.g., LEFT, RIGHT, SUBSTRING, LEN, UPPER, CONVERT) and numerical manipulations.
    • Date Functions: SQL has functions for working with dates (e.g., GETDATE, YEAR, MONTH, DAY)
    • “if I give you a date can you show me which year it is Select year of year of get date what do you think this output will give me”
    • Window Functions: Used for calculations across sets of rows within a result set (e.g., RANK, DENSE_RANK, ROW_NUMBER) with PARTITION BY.
    • “now if I execute this you’ll see numbers will continue now you’ll say people if this is descending order so can I make it as ascending order just change this to ASC ASC ascending order”
    • “what addition thing that I write along with this only this part I have written right correct only that part I have written now I’ll execute and see can you see this 1 2 3 department number 10 1 1 2 3 4 5 6 department number 20 1 1 2 2 3 4 1 and one don’t you see that ranks are repeating after every department so that’s the beauty of Partition by”
    • Subqueries: Queries nested inside another query:
    • “placing queries inside another query I can write this query like this select star from orders where s num equals select s num from sales people where s name equals MOA”
    • “in order to evaluate outer query SQL first have to evaluate inner query that that’s what people were asking”
    • Joins: Different types of joins are discussed:
    • INNER JOIN, LEFT JOIN, and RIGHT JOIN for combining data from multiple tables.
    • “irrespective of coming from which table here I will write e do department number also this is inner joint this is left join and this is right join just by changing one word just by changing one word I’m getting three different outputs”
    • Table Aliasing: Using aliases to make queries more readable and efficient.
    • “I will say Al as your table name only EMP as e left join Department as D see I have Al as the table only directly and then rather than using EMP I’ll write e rather than using Department I’ll write d”
    • Stored Procedures: A reusable block of SQL code that can simplify complex queries and logic.
    • “start procedure is nothing but just creating your query and store it and give the name so in order to do that create procedure procedure name you can give any name as I was giving you example for the tables and all those things and give you the name correct create procedure”
    • User-Defined Functions: Functions to encapsulate complex logic and create reusable code:
    • “function is a piece of code which takes some inputs and generates some output basically so that it can be used across many places not only in one single place why to repeat the code again and again”
    • Functions can be scalar functions, returning a single value, or table-valued functions, returning a table.
    • Security: Managing database access with GRANT and REVOKE permissions and user logins.
    • “Grant select on this to whom to RF user done”
    • Temporary Tables: Tables that exist only for the duration of the current session or connection (single hash) or across multiple sessions (double hash).
    • “table created with double hash is accessible in the both the sessions but why the table with the single hash is not accessible in both the sessions”
    • Views: Virtual tables that represent stored queries; they can enhance security and simplify queries.
    • “views are virtual tables these doesn’t occupy any space unlike the temporary tables…the views will not occupy any space and you will have a view now see it’s a view”
    • Indexing: Improving query performance by creating indexes on specific table columns.
    • “it just improve my performance of my query what it does how it does why should I care about it basically it creates a key value pair”Can be either CLUSTERED (physical order of data) or NON-CLUSTERED (separate lookup structure).
    • Pivot/Unpivot: Re-shaping data from long to wide format and vice-versa. * “so what name I’m giving to the column which will have numbers is sales and what is the column name that I’m giving for Jan Feb March April May what is the column name I’m giving month name and how many columns I’m taking there I’m taking all the 12”

    V. Practical Data Analysis Workflow and Business Application

    • Data Shaping: The role of the data professional is to shape data for analysis rather than worrying about the collection. Data can be shaped using views, stored procedures, functions, and triggers.
    • “my data analy job is not to worry about data collection once the data is there in the system shaping the data is in my work scope”
    • Real World Examples: The training provides practical scenarios, such as data conversion (epoch timestamp to human-readable date) or customer age categorization, to demonstrate how SQL is used in real business settings.
    • Triggers for Automation: Triggers are used to automatically update a date of first purchase in the customer table after a new order is inserted.

    VI. Other Key Takeaways:

    • Different Styles of Coding: There are various coding styles and there is no absolute right or wrong way as long as you fulfill the requirement.
    • Importance of syntax: Small things such as missing commas, parenthesis, or spaces can lead to errors.
    • CTE (Common Table Expression): A common table expression is used to make query shorter and more readable by creating a temporary result set.

    Conclusion

    The provided materials offer a comprehensive introduction to SQL, from basic syntax to advanced techniques. They underscore the importance of SQL across different data-focused roles, emphasize hands-on practice, and encourage purposeful learning. The content is structured to enable participants to not only write SQL queries but also understand the business context and design solutions to real-world data challenges.

    SQL Fundamentals and Data Roles

    Frequently Asked Questions About SQL and Data Roles

    • What is the role of SQL in data-related professions? SQL is a fundamental skill for data analysts, data engineers, and data scientists. Regardless of the specific role, proficiency in SQL is essential for retrieving, manipulating, and managing data. Data analysts use SQL along with business intelligence tools, data engineers use it alongside data integration tools, and data scientists use it with machine learning libraries. In essence, SQL serves as the common language for all roles to interact with data.
    • What are the core components of SQL Server? SQL Server has two primary components: the server and the client (or management tool). The server stores and manages databases while the client (like SQL Server Management Studio – SSMS) is a tool that allows users to interact with the server. Communication between the client and server happens using SQL, a structured query language. A database server contains multiple databases, and each database is made up of tables. These tables have rows and columns, and relationships between tables make up a schema.
    • What are the main types of SQL commands and what are their functions? SQL commands can be categorized into Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL). DDL commands (e.g., CREATE, ALTER, DROP, TRUNCATE) are used to define and modify the structure of the database, such as creating tables, adding columns, or removing tables. DML commands (e.g., INSERT, UPDATE, DELETE) are used to manage the actual data within the tables. DCL commands (e.g., GRANT, REVOKE) handle the security aspects by managing access levels for users. TCL commands (e.g., COMMIT, ROLLBACK, SAVEPOINT) control transactions, allowing for undoing or redoing changes.
    • What is the difference between DELETE, TRUNCATE, and DROP commands? While all three commands are used for removing data, they differ in how they work. The DELETE command removes records from a table row by row, optionally based on a condition, and is a DML command. The TRUNCATE command is a DDL command and removes all records from a table by dropping and recreating the table, making it faster than DELETE for deleting all records. The DROP command removes the entire table, including both the data and its structure, and is also a DDL command.
    • What are data types CHAR and VARCHAR, and how are they different? CHAR and VARCHAR are data types used for storing character strings. CHAR is a fixed-size data type, allocating a specified number of spaces regardless of how much data is stored, which can lead to wasted space. VARCHAR is a variable-size data type, allocating only the space needed for the actual data, which saves space but has a limit to how many characters it can hold. For instance, a phone number that must always be 10 digits would be CHAR(10) and a name that varies in length would be VARCHAR(20).
    • How can SQL ALTER command be used? The ALTER command is used to modify the structure of an existing table. It can change the data type of columns (e.g. changing from CHAR(2) to CHAR(3)), add new columns, or remove existing ones. It’s important to note that when altering a column to a smaller size, SQL will restrict this if the column has data that exceeds the new smaller size. ALTER operations allow changes while preserving existing data in the table, where possible.
    • What is the purpose of constraints like primary keys in SQL? Constraints define rules for the data in a table. A primary key constraint ensures two things: that all values in the primary key column are unique and not null. This allows for efficient identification of unique records and prevents duplicate or missing records. Primary keys help in making tables and schemas more reliable.
    • What are SQL Window Functions and how do they differ from other functions?
    • SQL window functions, such as RANK, DENSE_RANK, and ROW_NUMBER, are used to perform calculations across a set of table rows that are related to the current row. Unlike normal SQL functions, which operate only on a single row, window functions operate on a “window” or frame of data, comparing values from other rows. These functions allow for rank calculations, running totals, and more complex analysis. For example, RANK will assign the same rank to identical values, while DENSE_RANK won’t skip the next value if two rows have the same rank and ROW_NUMBER will simply assign an incremental row number regardless of value. PARTITION BY can be used to define a window of rows based on a given column such as a department, then apply the window function to the partitioned subset of rows.

    SQL Command Types and Functions

    SQL commands are used to interact with databases, and they can be categorized into four main types: Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL) [1, 2].

    • DDL (Data Definition Language) commands are used to define the structure or schema of a database [2]. These commands deal with the skeleton of the database, not the actual data [2].
    • CREATE is used to create database objects such as tables, views, or indexes [1, 2]. For example, CREATE TABLE countries (country_id INT, country_code VARCHAR(2), country_name VARCHAR(20)); creates a table named “countries” with three columns [3].
    • ALTER is used to modify existing database objects [2]. This can involve adding, removing, or modifying columns in a table, for instance, ALTER TABLE countries ALTER COLUMN country_code VARCHAR(3); changes the size of the country_code column [3, 4].
    • DROP is used to remove database objects [2]. For instance, DROP TABLE countries; deletes the “countries” table and its data [3, 4].
    • TRUNCATE is used to remove all data from a table while keeping the table structure [2, 3]. For example, TRUNCATE TABLE countries; deletes all rows from the “countries” table [3]. It works by dropping the table and recreating it, making it faster than deleting rows one by one [3].
    • DML (Data Manipulation Language) commands are used to manage the actual data within a database [2].
    • INSERT is used to add new data into a table [2]. For example, INSERT INTO countries (country_id, country_code, country_name) VALUES (1, ‘US’, ‘United States’); adds a new row to the “countries” table [4].
    • UPDATE is used to modify existing data in a table [2]. For instance, UPDATE countries SET country_code = ‘USA’ WHERE country_id = 1; changes the country_code for the row where country_id is 1 [4].
    • DELETE is used to remove data from a table based on a specific condition [2]. For example, DELETE FROM countries WHERE country_id = 1; deletes the row where country_id is 1 [4].
    • DCL (Data Control Language) commands are used to control access to the data [2]. They deal with security, ensuring that the right people have the right permissions to interact with the database [2].
    • GRANT is used to give specific permissions to users. For instance, GRANT SELECT ON products_new TO arif_user; allows the user “arif_user” to read data from the table “products_new” [5].
    • REVOKE is used to take away permissions from users. For example, REVOKE SELECT ON products_new FROM arif_user; removes the “select” permission from the user “arif_user” [5].
    • TCL (Transaction Control Language) commands are used to manage transactions within a database, allowing for the grouping of several operations into a single unit of work [2].
    • BEGIN TRANSACTION marks the start of a new transaction [5, 6]. This is needed before using commit or rollback [6].
    • COMMIT saves all changes made during the transaction [6].
    • ROLLBACK cancels all changes made during the transaction to return to the initial state [2, 5, 6]. If a transaction is not committed or rolled back, it will be automatically committed when the session is closed or if a DDL command is executed [6].

    These SQL commands can be combined with various clauses such as WHERE, GROUP BY, HAVING, ORDER BY to filter, group, and sort data [7, 8]. Functions can be used within SQL queries to perform different types of operations such as string and numerical manipulation and also with date and time [7].

    SQL Data Types: A Comprehensive Guide

    Data types in SQL specify the type of data that can be stored in a column of a table [1]. Choosing the correct data type is important to ensure data integrity, optimize storage, and improve performance [1].

    Here’s a breakdown of common SQL data types, drawing on the information from the sources:

    • Integer (INT): Used for storing whole numbers [1]. For instance, country_id in the countries table is defined as INT [1].
    • Character (CHAR): Used to store character strings of a fixed length [1]. For example, CHAR(2) allocates space for two characters, whether or not that space is used [1].
    • If a CHAR(2) column stores only one character, the remaining space is still allocated and remains empty [1].
    • Variable Character (VARCHAR): Used for character strings of a variable length [1].
    • For example, VARCHAR(20) can store up to 20 characters but will only use the space needed [1]. If a VARCHAR(20) column stores only four characters, only four spaces are occupied [1].
    • VARCHAR is more efficient than CHAR when the length of the strings varies because it does not allocate unnecessary space [1].
    • VARCHAR is often preferred for storing names and addresses [1].
    • Date and Time (DATE, DATETIME): Used to store date and time values [2].
    • DATE stores only the date portion, while DATETIME stores both date and time [2].
    • GETDATE() is a function that returns the current date and time [2].
    • Float: Used to store floating point numbers which are numbers that have a decimal point [3].

    Additional Considerations:

    • Case Sensitivity: Microsoft SQL Server is generally not case-sensitive, but Oracle server is case-sensitive [1, 4]. It is a good practice to consider case sensitivity to avoid issues when moving code between different database systems [4].
    • Fixed vs. Variable Size:Fixed-size data types like CHAR allocate a specific amount of memory regardless of the actual data length, which can lead to wasted space [1].
    • Variable-size data types such as VARCHAR use only the memory needed to store the actual data, which is more efficient [1].
    • Data Type Conversion:
    • The CAST function can be used to convert one data type to another [3, 5].
    • The CONVERT function can also be used to convert one data type to another [2].
    • For instance, CONVERT(DATE, GETDATE()) converts the DATETIME output of GETDATE() to just the DATE [2].
    • Choosing the Right Data Type: When defining data types, it’s important to consider the nature of the data you’re storing [1].
    • For example, a phone number, which is always ten digits, should use a fixed-size data type, such as CHAR(10) [1].
    • For gender, a CHAR(1) is sufficient since the values are usually “M” or “F” [1].

    Understanding and selecting the appropriate data types is fundamental to efficient database design and management [1].

    SQL Table Creation

    Table creation in SQL involves using Data Definition Language (DDL) commands to define the structure of a table, which includes specifying column names, data types, and constraints [1]. Here’s a breakdown of how to create tables effectively, drawing from the sources:

    Basic Table Creation:

    • The CREATE TABLE command is the foundation for building a new table [1]. The basic syntax includes specifying the table name and defining its columns within parentheses [1, 2].
    • Each column definition includes the column name, the data type, and any optional constraints [2].
    • For example, to create a table called “countries” with columns for country ID, country code, and country name, the following SQL statement is used:
    • CREATE TABLE countries (
    • country_id INT,
    • country_code VARCHAR(2),
    • country_name VARCHAR(20)
    • );
    • This command creates a table named countries with three columns: country_id of type integer (INT), country_code of type variable character string with a maximum length of 2 (VARCHAR(2)), and country_name of type variable character string with a maximum length of 20 (VARCHAR(20)) [3].

    Column Definition:

    • When defining columns, it is necessary to choose appropriate data types [2]. Common data types include INT for integers, VARCHAR for variable-length strings, and CHAR for fixed-length strings [2, 3].
    • INT is used for numerical data, such as identifiers [3].
    • VARCHAR is suitable for text that has a varying length, such as names or descriptions [3].
    • CHAR is more suitable for fixed-length data such as gender which can be represented by “M” or “F” with CHAR(1) [3].
    • Indentation is very important for readability and tracking code, which should be used when creating tables with multiple columns [3].

    Constraints:

    • Constraints are used to enforce rules on the data within a table [3]. They are important for maintaining data integrity.
    • Primary Key: The PRIMARY KEY constraint is used to ensure that the values in a column are unique and not null, and this is used to uniquely identify each row in a table [4].
    • A table can have only one primary key.
    • For example, in a Department table, department_number could be defined as the primary key, preventing duplicate or null values:
    • CREATE TABLE Department (
    • department_number INT PRIMARY KEY,
    • department_name VARCHAR(20),
    • location VARCHAR(10)
    • );
    • Not Null: The NOT NULL constraint is used to ensure that a column cannot contain null values, ensuring that there is always data present for the column [4].
    • Other constraints are not discussed in the sources.

    Executing the CREATE TABLE command

    • After writing a CREATE TABLE command, it is necessary to select the command and then click execute. The system will provide a message if the command was successful [3].
    • If the table does not show up in the tables list, then you may need to right click the tables list and click refresh [3].
    • If a table with the same name already exists, then the SQL system will throw an error [3]. This is an important error to read and understand to troubleshoot SQL [3].
    • If there is a syntax error, the system will also give a message, and these messages should be read and understood to correct the SQL code [3].

    Additional Considerations:

    • Data Types: It is important to choose appropriate data types for the columns based on the nature of the data that the column will store [3].
    • Naming conventions: When creating a column name with a space, it is recommended that you use an underscore instead [5].
    • Case Sensitivity: SQL Server is not case sensitive, but it is good practice to maintain case sensitivity in code, because other SQL servers such as Oracle server are case sensitive [3, 6].

    By understanding and using these SQL commands, data types, and constraints, it is possible to effectively create and manage tables in SQL databases [1-3].

    SQL Data Insertion Techniques

    Data insertion in SQL involves using Data Manipulation Language (DML) commands to add new rows of data into a table. The primary command for inserting data is INSERT INTO, and it can be used in several ways. Here’s a breakdown of how to insert data effectively, drawing from the sources:

    Basic Data Insertion:

    • The INSERT INTO command is used to add new records (rows) to a table.
    • The basic syntax of the INSERT INTO command is as follows:
    • INSERT INTO table_name (column1, column2, column3, …)
    • VALUES (value1, value2, value3, …);
    • table_name is the name of the table into which data needs to be inserted.
    • (column1, column2, column3, …) specifies the columns where data is being inserted, and the order of the columns is important.
    • VALUES (value1, value2, value3, …) specifies the values to be inserted into the corresponding columns.
    • For example, to insert a new country into the “countries” table, you might use:
    • INSERT INTO countries (country_id, country_code, country_name)
    • VALUES (2, ‘CA’, ‘Canada’);
    • This command will add a new row to the countries table with country_id as 2, country_code as ‘CA’, and country_name as ‘Canada’.
    • String values should be enclosed in single quotes, while numeric values do not require single quotes.

    Specifying Columns:

    • It’s good practice to explicitly specify the column names in the INSERT INTO statement. This ensures that the data is inserted into the correct columns, regardless of the order of the columns in the table definition.
    • If the column names are not specified, the values must be listed in the same order that the columns are defined in the table.
    • For example, both of the following statements are valid if the columns of the countries table are ordered as country_id, country_code, country_nameINSERT INTO countries (country_id, country_code, country_name)
    • VALUES (2, ‘CA’, ‘Canada’);
    • and
    • INSERT INTO countries
    • VALUES (2, ‘CA’, ‘Canada’);

    Inserting Data with Different Column Order:

    • It is possible to insert data in a different column order than the order that the columns appear in the table provided you specify the columns explicitly in the INSERT INTO statement.
    • For instance:
    • INSERT INTO countries (country_code, country_name, country_id)
    • VALUES (‘IN’, ‘India’, 3);
    • This will correctly insert ‘IN’ into country_code, ‘India’ into country_name, and 3 into country_id.
    • The sequence of columns in the INSERT INTO statement must match the sequence of values provided.

    Inserting Null Values:

    • If a value for a specific column is not available, you can insert NULL into the column if the column allows null values.
    • If you omit a column from the INSERT INTO statement, and the column allows null values, then the SQL server will automatically insert NULL.
    • For example, if you don’t have a country code, you can either omit the country_code column in the insert statement, or insert NULL:
    • INSERT INTO countries (country_id, country_name)
    • VALUES (4, ‘United Kingdom’);
    • or
    • INSERT INTO countries (country_id, country_code, country_name)
    • VALUES (4, NULL, ‘United Kingdom’);
    • Both statements will insert a row where the country_code is NULL.
    • If a column has a NOT NULL constraint, then you must insert a non-null value, or the insert statement will cause an error.

    Inserting Data Based on Conditions:

    • The WHERE clause can be used to insert data into a table based on certain criteria. For example, you could insert data into a new table based on certain conditions from another table using the INSERT INTO … SELECT statement.

    Executing the INSERT INTO Command:

    • After writing an INSERT INTO command, it is necessary to select the command and then click execute.
    • The system will provide a message stating the number of rows affected, which should be equal to one if only one insert statement is being executed.

    Important Considerations:

    • Data Type Compatibility: It is important to ensure that the data type of the values being inserted is compatible with the data type of the corresponding columns. Otherwise, errors may occur, and the data may not be inserted correctly.
    • Constraints: If a table has constraints such as primary keys or unique constraints, then inserting data may lead to an error if it violates those constraints.
    • For example, if you try to insert a row with a duplicate primary key value, the SQL server will throw an error.

    By understanding and using these techniques for data insertion, it is possible to populate tables with new data accurately and efficiently.

    SQL Error Handling and Exception Management

    Error handling in SQL involves managing issues that arise during the execution of SQL code, ensuring that the system responds gracefully to both system-level and business-level problems [1]. It is implemented using TRY…CATCH blocks and other techniques. Here’s a detailed look at error handling as discussed in the sources:

    Types of Errors:

    • System Errors: These are errors that arise due to violations of SQL system rules, such as trying to insert duplicate primary key values, which violate the PRIMARY KEY constraint [1].
    • Business Errors/Exceptions: These are errors that are not system errors but violate business rules, such as restricting code execution to specific times [1].
    • Both types of errors can be managed using TRY…CATCH blocks [1].

    TRY…CATCH Blocks:

    • Every SQL code block that requires exception or error handling has two main parts: a TRY block and a CATCH block [1].
    • The TRY block contains the code that might generate an error [1].
    • The SQL server will attempt to run all the code inside of the TRY block.
    • If an error occurs during the execution of the TRY block, the control is immediately transferred to the CATCH block [1].
    • Any code after the error within the TRY block will not be executed [1].
    • The CATCH block contains code to handle the error, such as logging, displaying a message, or attempting to correct the error [1].
    • For example:
    • BEGIN TRY
    • — Code that might cause an error
    • INSERT INTO employees (employee_id, name) VALUES (1, ‘John Doe’);
    • INSERT INTO employees (employee_id, name) VALUES (1, ‘Jane Doe’); — Duplicate key error
    • PRINT ‘Inside TRY block, after insert’; — This will not execute if there’s an error on the line above
    • END TRY
    • BEGIN CATCH
    • — Code to handle the error
    • PRINT ‘Inside CATCH block’;
    • PRINT ERROR_MESSAGE(); — Prints a system-generated error message
    • PRINT ERROR_NUMBER(); — Prints the error number
    • PRINT ERROR_STATE(); — Prints the error state
    • — More error-handling logic can be added here
    • END CATCH
    • In the example above, an attempt to insert a duplicate employee_id will cause the control to pass to the CATCH block, and any code after the error in the TRY block will not execute.

    Error Information in the CATCH Block:

    • Inside the CATCH block, you can access error information using the following functions:
    • ERROR_MESSAGE(): Returns the text of the error message [1].
    • ERROR_NUMBER(): Returns the error number [1].
    • ERROR_STATE(): Returns the error state [1].

    User-Defined Errors:

    • In addition to handling system errors, you can also raise your own errors to manage business-specific rules or exceptions, which are not necessarily system errors [1].
    • This is done using the RAISERROR statement, which will force the code to jump to the CATCH block, similar to a system error [1].
    • For example, you can raise an error if a procedure is run outside working hours:
    • DECLARE @currentTime TIME = CAST(GETDATE() AS TIME);
    • IF @currentTime BETWEEN ’18:00′ AND ’06:00′
    • BEGIN
    • RAISERROR(‘You cannot run this code during non-working hours.’, 16, 1);
    • END
    • The code above will force the control to jump to the CATCH block if the current time is between 6 PM and 6 AM.

    Importance of Exception Handling:

    • Robustness: Exception handling makes your code robust, meaning it can handle unexpected situations without crashing or producing incorrect output [1].
    • User Experience: It can improve the user experience by providing meaningful error messages when issues occur and allowing the code to respond gracefully to those errors [1].
    • Debugging: Using TRY…CATCH blocks and error information, it is possible to debug SQL code more efficiently by understanding the errors that occurred [1].

    Additional Considerations:

    • Logical Mistakes: Even if code runs without syntax errors, there might be logical mistakes that require error handling [2].
    • For example, code could be written to return incorrect outputs even though the syntax is correct.
    • Time Restrictions: With exception handling, SQL code can be restricted to certain times [1].
    • You can also implement business rules, such as preventing code from executing if the time is outside the desired range.

    By understanding and using TRY…CATCH blocks, the RAISERROR statement, and error functions, developers can create SQL code that is more resilient, user-friendly, and easier to debug.

    SQL Full Course 2025 | Complete SQL Course For Beginners | Learn SQL in 11 Hours | Intellipaat

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog

  • FBR : Income Tax Ordinance 2001 – Pakistan’s Income Tax Law Basics

    FBR : Income Tax Ordinance 2001 – Pakistan’s Income Tax Law Basics

    The provided text outlines comprehensive tax regulations, detailing various rates of advance tax and deductions at the source for diverse income types, such as dividends, profit on debt, and payments for goods and services. It extensively covers rules for income classification, taxable income computation, and allowable deductions like depreciation and amortization. The document also addresses international tax operations, offences and prosecutions for non-compliance, and the administrative framework for tax collection and enforcement. Furthermore, it specifies exemptions and reductions for certain entities and industries, alongside procedures for assessment, audit, and appeals.

    Podcast

    Listen or Download Podcast – Income Tax Ordinance 2001

    What is Income Tax

    Based on the sources provided, income tax is a tax imposed for each tax year on every person who has taxable income for that year [11(1)]. It is governed by the Income Tax Ordinance, 2001.

    Here’s a breakdown based on the sources:

    • Imposition: Income tax is imposed subject to the Ordinance [11(1)]. Certain classes of income or persons may be subject to separate taxation or collection/deduction of tax as a final tax [13(4)].
    • Computation: The income tax payable by a taxpayer is computed by applying the specified rates of tax (found in Division I or II of Part I of the First Schedule) to the taxpayer’s taxable income [12(2), 11(1)]. Any applicable tax credits allowed under the Ordinance are subtracted from this amount [12(2)]. Tax credits are applied in a specific order: foreign tax credit (section 103), then tax credits under Part X of Chapter III, and then credits under sections 147 and 168 [12(3)]. If income tax is to be deducted or collected at source or paid in advance, it must be done accordingly [14(6)].
    • Taxable Income: The taxable income of a person for a tax year is defined as the total income (under clause (a) of section 10) for the year, reduced (but not below zero) by the total of any deductible allowances under Part IX of Chapter III.
    • Total Income: The total income of a person for a tax year is the sum of the person’s income under all heads of income for the year. It also includes income exempt from tax under the Ordinance, for the purpose of determining total income.
    • Heads of Income: All income, for the purpose of imposing tax and computing total income, is classified under the following heads:
    • Salary [21(a), 23].
    • Income from Property [21(b)].
    • Income from Business [21(c), 29].
    • Capital Gains [21(d)].
    • Income from Other Sources [21(e), 41].
    • Income Definition: The term “income” itself includes any amount chargeable to tax under the Ordinance and any amount subject to collection or deduction of tax under certain sections, such as 148, 150, 152(1), 153, 154, 156, 156A, 233, and sub-section (5) of 234 Division III of Chapter XII. It also includes imputable income as defined in clause (28A) of section 2 [15(iii), 16(iii), 8]. “Imputable income” relates to an amount subject to final tax and is the income that would have resulted in the same tax had the amount not been subject to final tax.
    • Persons Subject to Tax: A “taxpayer” is any person who derives an amount chargeable to tax, and includes any representative, any person required to deduct or collect tax (under Part V of Chapter X and Chapter XII), or any person required to furnish a return of income or pay tax. The persons required to furnish a return of income include every company, and individuals/AOPs whose taxable income exceeds the maximum amount not chargeable to tax, or individuals whose business income exceeds a certain threshold.
    • Rates of Tax: The First Schedule specifies various rates, including progressive rates for individuals and AOPs based on taxable income, and rates for companies. It also includes rates for minimum tax.
    • Minimum Tax: Minimum tax is imposed on certain resident companies, permanent establishments of non-resident companies, and individuals/AOPs with turnover above a specified threshold. This tax is based on a percentage of the person’s turnover from all sources for the year, and is payable if it is higher than the actual tax computed under other provisions.
    • Withholding Tax/Collection at Source: The Ordinance includes provisions for collection and deduction of tax at source under Part V of Chapter X and Chapter XII. This collected or deducted tax may be an adjustable advance tax or a final tax on the income. Tax collected or deducted has priority over other claims.

    In essence, income tax under this Ordinance is a charge levied annually on the computed taxable income of persons, derived from various categorized sources, applying specific rates and taking into account credits and deductions. It operates through self-assessment (filing returns) subject to potential audits, advance payments, collection/deduction mechanisms, and defined procedures for collection, recovery, and refunds.

    What are the Penalties if Income tax is not Paid on time?

    Based on the provided sources, there are specific consequences and penalties for not paying income tax on time, primarily consisting of default surcharge and a distinct penalty for failure to deposit tax due. The sources also outline various recovery procedures.

    Here’s a breakdown:

    1. Due Date for Payment:
    • Generally, the tax payable on taxable income for a tax year (including minimum tax) is due on the due date for furnishing the taxpayer’s return of income for that year [61(1)].
    • Where tax is payable under an assessment order, amended assessment order, or any other order issued by the Commissioner, a notice specifying the amount is served, and the tax must be paid within thirty days from the date of service of the notice [61(2)].
    • The Commissioner may grant an extension of time for payment or allow payment in instalments upon written application showing good cause [62(4)]. However, granting such extension or permission to pay by instalments does not preclude liability for default surcharge arising from the original due date [62(6)]. If a taxpayer defaults on an instalment, the whole balance becomes immediately payable [62(5)].
    1. Default Surcharge:
    • Any person who fails to pay any tax, penalty, or certain other amounts (referred to in sections 140 or 141) on or before the due date is liable for default surcharge [136(1)].
    • Failure to pay advance tax as required under section 147 also results in liability for default surcharge [137(1A)]. If the tax paid under section 147 is less than ninety percent of the tax chargeable, default surcharge is imposed on the shortfall [138(1B)].
    • A person who fails to collect or deduct tax as required, or fails to pay collected or deducted tax to the Commissioner by the due date, is also liable for default surcharge on the unpaid amount [139(3)].
    • The rate of default surcharge is twelve percent or KIBOR plus three percent per annum, whichever is higher, computed for the period commencing on the date the amount was due and ending on the date on which it was paid [136(1), 137(1A), 139(3)].
    1. Penalty for Failure to Deposit Tax Due:
    • Under Section 182, there is a specific penalty for “Any person who fails to deposit the amount of tax due or any part thereof in the time or manner laid down under this Ordinance or rules made thereunder”.
    • For the first default, the penalty is five per cent of the amount of the tax in default.
    • For the second default, an additional penalty of 25% of the amount of tax in default is imposed.
    • For the third and subsequent defaults, an additional penalty of 50% of the amount of tax in default is imposed.
    • There is a provision for a 50% reduction in this penalty if the person opts to pay the tax due based on a Commissioner (Appeals) order on or before the due date given in the notice under section 137 and does not file a further appeal under section 131.
    1. Recovery of Unpaid Tax:
    • For the purpose of recovering any tax due, the Commissioner may serve a notice requiring payment [63(1)].
    • If the amount is not paid within the specified time, the Commissioner can proceed to recover it out of the taxpayer’s property or through the arrest of the taxpayer [63(1)].
    • The Commissioner can also require persons owing money to the taxpayer or holding money on their behalf to pay that money directly to the Commissioner. However, the Commissioner cannot issue such a notice for recovery if the taxpayer has filed an appeal under section 127 regarding the order under which the tax is payable and the appeal is not decided, provided ten percent of the tax due has been paid by the taxpayer.
    • Specific procedures exist for recovery from private companies and associations of persons, estates in bankruptcy, non-resident members of associations, non-resident ship or aircraft owners/charterers, and persons assessed in Azad Jammu and Kashmir.
    • Recovery proceedings can also be initiated to recover liabilities outstanding under other laws if they are treated as income tax arrears.

    It’s important to note that failing to file a tax return by the due date is a separate offence with its own penalties, although late filing can also impact a person’s status on the active taxpayers’ list and may require paying a surcharge for inclusion. The penalties specifically linked to not paying the tax itself when due are the default surcharge and the penalty under Section 182, Entry 5 [136(1), 101, 102]. The old Section 183, which also dealt with penalties for non-payment, has been omitted.

    What happens if we do not file income tax return on time?

    Based on the sources provided, failing to file an income tax return on time can result in several penalties and consequences:

    1. Monetary Penalties:
    • Any person who fails to furnish a return of income as required under section 114 within the due date is liable for a penalty.
    • The penalty is equal to the higher of:
    • 0.1% of the tax payable in respect of that tax year for each day of default.
    • Rupees one thousand for each day of default.
    • There are minimum penalty amounts:
    • Rupees ten thousand in case of an individual having seventy-five percent or more income from salary.
    • Rupees fifty thousand in all other cases.
    • The maximum penalty shall not exceed two hundred percent of tax payable by the person in a tax year.
    • However, the amount of penalty is reduced if the return is filed within a certain period after the due date or extended due date:
    • Reduced by 75% if filed within one month.
    • Reduced by 50% if filed within two months.
    • Reduced by 25% if filed within three months.
    • “Tax payable” for this penalty refers to the tax chargeable on taxable income based on assessments made or treated as made under sections 120, 121, 122, or 122D.
    • Separate penalties exist for failure to furnish a wealth statement (Section 182, Entry 1AA), a foreign assets and income statement (Section 182, Entry 1AAA), or a return required by a specific notice under section 117(3) (Section 182, Entry 1B).
    1. Exclusion from Active Taxpayers’ List (ATL) and Related Consequences:
    • Notwithstanding other provisions, if a person fails to file a return of income under section 114 by the due date (or extended date), such person shall not be included in the active taxpayers’ list for the year for which the return was not filed on time.
    • Being excluded from the ATL has further consequences:
    • The person shall not be allowed, for that tax year, to carry forward any loss under Part VIII of Chapter IV.
    • The person shall not be issued refund during the period they are not included in the active taxpayers’ list.
    • A person can be included in the active taxpayers’ list after filing a late return if they pay a surcharge. The surcharge amounts are:
    • Rupees twenty thousand in case of a company.
    • Rupees ten thousand in case of an association of persons.
    • Rupees one thousand in case of an individual.
    1. Commissioner’s Power to Require a Return and Make Assessment:
    • If, in the Commissioner’s opinion, a person was required to file a return under section 114 but failed to do so, the Commissioner may, by notice, require that person to furnish a return within thirty days (or longer/shorter). This notice can be issued for the last five completed tax years, or the last ten if the person hasn’t filed for the last five.
    • If a person fails to furnish a return of income for a tax year when required by a notice (e.g., under section 114(4)), the Commissioner may, based on available information and best judgment, make an assessment of the person’s taxable income and the tax due thereon. This assessment order will state the taxable income, tax due, tax paid, and appeal process. Such an order can generally be issued within six years after the end of the relevant tax year.
    1. Provisional Assessment for Non-Filers with Withholding Tax:
    • Where a person’s tax has been collected or deducted at a potentially higher rate (as per Rule 1 of the Tenth Schedule for persons not on ATL or late filers) and the person fails to file a return by the due date or extended date, the Commissioner shall make a provisional assessment of the taxable income and tax due within sixty days of the due date.
    • In this provisional assessment, the Commissioner shall impute taxable income based on the amount of tax deducted or collected, treating the imputed income as concealed income for the purposes of Section 111.
    • This provisional assessment becomes a final assessment order after forty-five days from its service unless the person files their return and wealth statement within that period.
    • If the provisional assessment becomes final, the Commissioner may initiate proceedings for the imposition of penalties under section 182 on account of non-furnishing and concealment of income.
    1. Prosecution:
    • Any person who, without reasonable excuse, fails to comply with a notice to furnish a return under section 114(3) or (4) commits an offence. This offence is punishable on conviction with a fine or imprisonment for up to one year, or both.
    • If convicted for this offence and the person still fails to furnish the return within the court-specified period, they commit a further offence punishable with a fine (up to fifty thousand rupees) or imprisonment for up to two years, or both.
    1. Other Measures for Non-ATL Persons:
    • The Board has powers to issue general orders regarding persons not on the active taxpayers’ list but liable to file. Such orders may entail consequences such as:
    • Disabling of mobile phones or mobile phone SIMs.
    • Discontinuance of electricity connection.
    • Discontinuance of gas connection.
    • Restriction on foreign travel for citizens of Pakistan (with some exceptions).

    In summary, failing to file your income tax return on time can lead to significant monetary penalties, exclusion from the active taxpayers’ list (which prevents loss carry-forward and refunds unless a surcharge is paid), potential best-judgment assessment or provisional assessment with imputed income, and even prosecution.

    What is WHT With Holding Tax and is it adjustable in filing of return?

    Based on the sources, “Withholding Tax” (WHT) is a common term for amounts of tax that are collected or deducted at source by one person from a payment made to another person. This mechanism involves the payer or a designated collection agent deducting the tax at the time of payment or collection and forwarding it to the tax authorities.

    The sources refer to this process using terms such as:

    • “advance tax and deduction of tax at source”
    • “advance tax paid to a collection agent” (under Division II of Part V of Chapter X)
    • “deduction of tax at source” (under Division III of Part V of Chapter X)
    • Specific “advance tax” provisions under Chapter XII.

    Common examples of payments or transactions subject to this collection/deduction mentioned in the sources include:

    • Imports of goods
    • Dividends paid
    • Profit on debt
    • Payments for goods, services, or contracts
    • Cash withdrawals from banks
    • Electricity connections (over a certain threshold)
    • Sale or transfer of immovable property
    • Purchase of immovable property
    • Banking transactions other than through cash for persons not on the active taxpayers’ list
    • Bonus shares issued by companies

    Is Withholding Tax Adjustable in Filing of Return?

    Generally, yes, tax collected or deducted at source is adjustable in the filing of the income tax return.

    Here’s how the sources describe this:

    1. General Rule of Adjustment: Any amount of tax collected under Division II of Part V (like imports) or deducted under Division III of Part V (like dividends, profit on debt, payments for goods/services) or Chapter XII is treated as tax paid by the person from whom it was collected or deducted. This person is then allowed a tax credit for that amount when computing the tax due on their taxable income for the tax year in which the tax was collected or deducted. Advance tax paid under Section 147 and advance tax paid by provincial sales tax registered persons under Section 147A are also taken into account while working out advance tax payable under Section 147.
    2. When WHT is a “Final Tax”: However, there are specific instances where tax collected or deducted is considered a “final tax” on the income from which it was collected or deducted. When an amount is subject to final tax:
    • That income amount is not chargeable to tax under any other head of income in computing the person’s taxable income.
    • No deductions are allowed for expenditures incurred in deriving that income.
    • The amount is not reduced by any deductible allowance or set-off of any loss.
    • Tax credits allowed under the Ordinance generally do not reduce the final tax payable.
    • This means that tax treated as a final tax is not adjustable against the overall tax liability calculated on other sources of taxable income.
    • Sections specifically mentioned where the tax can be final include Section 148(7), Section 152(1E), Section 154A(2), Section 156(3), Section 156A(2), and Section 236Z(7). Tax under Section 7E (tax on deemed income) is also final. Tax collected on certain imported goods under Section 148(7A) is minimum tax on that income, which functions like final tax. Tax on gains from constructed property with a holding period exceeding four years is zero, and specific rules apply for shorter periods.
    1. Exception for Non-Filer Higher Rates: Even when the tax is a final tax, if separate rates are prescribed for filers and non-filers and a higher rate is collected/deducted from a non-filer, the excess tax collected or deducted on account of the higher non-filer rate shall be adjustable in the return filed for the relevant tax year.
    2. Specific Cases of Adjustable Tax: Several specific provisions in Chapter XII explicitly state the tax collected is adjustable, such as:
    • Advance adjustable tax on cash withdrawals under Section 231AB.
    • Adjustable tax collected on monthly electricity bills exceeding a certain amount.
    • Advance tax collected on the sale or transfer of immovable property under Section 236C (except tax liability under Section 7E which must be discharged).
    • Advance tax collected on the purchase of immovable property under Section 236K (with an exception for certain non-resident buyers where it is final).
    • Advance adjustable tax on banking transactions (non-cash) for non-ATL persons under Section 236P.
    1. Specific Case Where WHT is Not Adjustable: Traders qualifying under certain rules in the Ninth Schedule (Special Procedure for Small Traders and Shopkeepers) are not entitled to claim any adjustment of withholding tax collected or deducted under the Ordinance against the tax payable on their trading activity profits and gains. They are also not entitled to adjust any refund due.
    2. Provisional Assessment for Non-Filers (Tenth Schedule): For persons whose tax is collected or deducted at a potentially higher rate for not being on the active taxpayers’ list (as per the Tenth Schedule Rule 1), if they fail to file a return, the Commissioner can make a provisional assessment. However, if the person files their return within a specified period (45 days from provisional assessment service), the tax deducted or collected shall be adjustable against the tax payable in the return filed. If they don’t file and the provisional assessment becomes final, the tax collected/deducted based on imputed income may be treated as final tax, and penalties may be imposed.

    In summary, WHT is tax collected/deducted at source. It is generally adjustable against your final tax liability by claiming a tax credit, unless the specific provision under which it is collected or deducted designates it as a final tax on that income source. Even in final tax cases, the excess tax paid due to higher rates for non-filers is typically adjustable.

    Pakistan Property Tax Guide 2024

    The sources provide detailed information on various aspects of property tax in Pakistan, primarily under the Income Tax Ordinance, 2001, which was amended up to June 30, 2024.

    Here are the key details regarding property tax:

    1. Classification of Income from Property

    • “Income from Property” is one of the five heads under which income is classified for the imposition of tax and the computation of total income. The other heads are Salary, Income from Business, Capital Gains, and Income from Other Sources.
    • The income of a person under this head for a tax year is the total amounts derived that are chargeable to tax, reduced by any allowed deductions.
    • If total deductions exceed chargeable amounts, the person is treated as sustaining a loss under that head.
    • For resident persons, both Pakistan-source and foreign-source income are considered. For non-resident persons, only Pakistan-source income is considered.

    2. Computation of Income from Property (Section 15 & 15A)

    • Specific deductions are allowed when computing income chargeable under the head “Income from Property” [2, 15A]. These include:
    • The amount of profit or interest paid on a mortgage or other capital charge if the property is subject to it.
    • Any expenditure, not exceeding 4% of the rent chargeable to tax, paid or payable for the purpose of deriving rent, including administration and collection charges.

    3. Non-Adjustable Amounts Received (Section 16)

    • If an owner receives an amount from a tenant that is not adjustable against rent, this amount is treated as rent chargeable to tax.
    • It is allocated equally over the tax year in which it was received and the subsequent nine tax years.
    • If the tenancy terminates before ten years and the amount is refunded, no portion is allocated to the refund year or subsequent years.
    • However, if the property is re-let to a “succeeding tenant” who also pays a non-adjustable amount, that “succeeding amount” (reduced by any portion of the “earlier amount” already charged to tax) will be treated as rent as specified above.

    4. Tax Rates on Income from Property (Division VIA, First Schedule)

    • For individuals and associations of persons, the tax rates on gross rent are as follows:
    • Where gross rent does not exceed Rs. 200,000: Nil.
    • Where gross rent exceeds Rs. 200,000 but does not exceed Rs. 600,000: 5% of the gross amount exceeding Rs. 200,000.
    • Where gross rent exceeds Rs. 600,000 but does not exceed Rs. 1,000,000: Rs. 20,000 plus 10% of the gross amount exceeding Rs. 600,000.

    5. Withholding Tax on Rent of Immovable Property (Section 155)

    • Every prescribed person making a payment (in full or part, including advance) for rent of immovable property (which also includes rent for furniture, fixtures, and services related to the property) must deduct tax from the gross amount of rent paid.
    • The “gross amount of rent” includes any non-adjustable amounts referred to in Section 16(1) or (3).
    • This withholding tax applies regardless of the head of income under which the rent might be classified.

    6. Capital Gains on Immovable Property (Section 37)

    • Any gain arising from the disposal of immovable property situated in Pakistan is chargeable to tax under the head “Capital Gains”.
    • The rates are specified in Division VIII of Part I of the First Schedule.
    • Rates for properties acquired on or before June 30, 2024:
    • Holding period ≤ 1 year:
    • Open Plots: 15%
    • Constructed Property: 15%
    • Flats: 15%
    • Holding period > 1 year but ≤ 2 years:
    • Open Plots: 12.5%
    • Constructed Property: 10%
    • Flats: 7.5%
    • Holding period > 2 years but ≤ 3 years:
    • Open Plots: 10%
    • Constructed Property: 7.5%
    • Flats: 0%
    • Holding period > 3 years but ≤ 4 years:
    • Open Plots: 7.5%
    • Constructed Property: 5%
    • Flats: 0%
    • Holding period > 4 years: 0% for all
    • Rates for properties acquired on or after July 1, 2024:
    • Holding period ≤ 1 year: 15% for persons appearing on the Active Taxpayers’ List on the date of disposal. For individuals and associations of persons, the rates specified in Division I apply, and for companies, Division II applies.

    7. Tax on Deemed Income (Section 7E)

    • For tax year 2022 and onwards, a tax is imposed on “deemed income” at rates specified in Division VIIIC of Part-I of the First Schedule. The sources indicate this often relates to immovable property, as property transfer registration requires discharge of this tax.

    8. Tax on Builders and Developers (Section 7F)

    • A tax is imposed on the profits and gains of persons deriving income from the business of construction and sale of residential/commercial/other buildings, or development and sale of residential/commercial/other plots, or both activities.
    • This tax is charged at the rates specified in Division I or II of Part-I of the First Schedule on the taxable profit.

    9. Advance Tax on Sale or Transfer of Immovable Property (Section 236C)

    • Any person responsible for registering, recording, or attesting the transfer of immovable property must collect advance tax from the seller or transferor. This includes local authorities, housing societies, etc..
    • The tax collected is generally adjustable.
    • Exception: If the immovable property is acquired and disposed of within the same tax year, the tax collected under this section becomes minimum tax.
    • Exemptions: This section does not apply to a seller who is a dependent of a Shaheed, war-wounded person, disabled person, or a deceased employee of the armed forces, federal, or provincial government, or to transfers to legal heirs of such persons.
    • Final Tax Discharge: If the seller/transferor is a non-resident individual holding a Pakistan Origin Card (POC), National ID Card for Overseas Pakistanis (NICOP), or Computerized National ID Card (CNIC) who acquired the property through a Foreign Currency Value Account (FCVA) or NRP Rupee Value Account (NRVA), the tax collected under this section is a final discharge of tax liability for capital gains.
    • Requirement for Section 7E compliance: Registration/recording/attestation of property transfer will not occur unless the seller/transferor has discharged their tax liability under Section 7E and provided evidence.
    • Rates for Non-Active Taxpayers (Rule 1 of Tenth Schedule): For sellers/transferors not appearing on the active taxpayers’ list, the tax rate for Section 236C is increased:
    • Gross amount of consideration received does not exceed Rs. 50 million: 6%.
    • Gross amount of consideration received exceeds Rs. 50 million but does not exceed Rs. 100 million: 7%.
    • Gross amount of consideration received exceeds Rs. 100 million: 8%.

    10. Advance Tax on Purchase or Transfer of Immovable Property (Section 236K)

    • Any person responsible for registering, recording, or attesting the transfer of immovable property must collect advance tax from the purchaser or transferee.
    • This advance tax is adjustable.
    • Final Tax Discharge: If the buyer/transferee is a non-resident individual holding a POC, NICOP, or CNIC who acquired the property through an FCVA or NRVA, the tax collected under this section is a final discharge of tax liability for such buyer/transferee.
    • Installment Payments: If payments for purchase or allotment of immovable property are collected in installments, advance tax must be collected from the allottee/transferee with each installment. If the accumulated tax collected through installments equals the total tax payable, no further tax is collected at the time of property transfer.
    • Rates (Division XVIII, Part IV of First Schedule – as per Finance Act 2024):
    • Where value of immovable property is up to Rs. 4 million: 0%.
    • Where the value of immovable property is more than Rs. 4 million:
    • Filer: 2%.
    • Non-Filer: 4% (previously 1% until a date notified by the Board).
    • Rates for Non-Active Taxpayers (Rule 1 of Tenth Schedule): For purchasers/transferees not appearing on the active taxpayers’ list, the tax rate for Section 236K is increased:
    • Fair Market Value of Immovable Property does not exceed Rs. 50 million: 12%.
    • Fair Market Value of Immovable Property exceeds Rs. 50 million but does not exceed Rs. 100 million: 14%.
    • Fair Market Value of Immovable Property exceeds Rs. 100 million: 16%.

    11. Wealth Statement and Registration Requirements

    • The Commissioner may require any individual to furnish a wealth statement detailing their total assets and liabilities (including foreign assets and liabilities) as well as those of their spouse, minor children, and other dependents. This statement must also include assets transferred and consideration for transfer, and details of expenditures. A reconciliation statement of wealth is also required.
    • Every resident individual taxpayer filing a return of income must furnish a wealth statement and wealth reconciliation statement.
    • Even if a person is not obliged to furnish a return (because all income is subject to final taxation, e.g., under sections 5, 6, 7, 148, 151, 152, 153(3), 154, 156, 156A, 233(3), 234A), they must still furnish a statement to the Commissioner showing particulars of their income.
    • Persons with a taxable income of Rs. 500,000 or more, or those under the final tax regime who paid Rs. 20,000 or more tax, must file a wealth statement along with its reconciliation.
    • Any person (other than a company) who owns immovable property with a land area of 500 square yards or more or owns any flat located in municipal limits, cantonment, Islamabad Capital Territory, or a rating area, is required to furnish a return of income.

    12. Directorate-General of Immovable Property (Section 230F)

    • This directorate is established to perform functions assigned by the Board, including the determination of fair market value of immovable property and identifying instances where the consideration for property transfer has been understated to avoid or reduce withholding tax, conceal unexplained amounts (under Section 111), or avoid/reduce capital gains tax.
    • The Directorate-General can appoint valuers or experts for property valuation.

    13. Exemptions Related to Immovable Property

    • Profits and gains accruing to a person on the sale of immovable property or shares of a Special Purpose Vehicle to any type of REIT scheme were exempt from tax up to June 30, 2023.

    14. Joint Ownership of Property (Section 66)

    • If immovable property is owned by two or more persons and their respective shares are definite and ascertainable, they are not assessed as an association of persons in respect of that property. Instead, each person’s share in the income from the property is taken into account in computing their individual taxable income.

    Pakistan Import Tax Explained

    Property tax in the context of imports primarily refers to the advance tax collected by the Collector of Customs on imported goods under Section 148 of the Income Tax Ordinance, 2001. This is a crucial aspect of the tax regime for businesses and individuals engaged in import activities.

    Here are the detailed provisions regarding taxation on imports:

    1. Nature and Collection of Tax on Imports

    • Advance Tax Collection: The Collector of Customs is responsible for collecting advance tax from every importer of goods. This tax is collected at the time customs duty would be payable, or if the goods are exempt from customs duty, at the time customs duty would have been payable had the goods been dutiable.
    • Applicability: This advance tax applies to goods classified in Parts I to III of the Twelfth Schedule. The Board has the authority to add, omit, or amend entries in the Twelfth Schedule and to specify conditions for treating goods as raw material under Part II even if classified under Part III.
    • Legal Framework: The provisions of the Customs Act, 1969, apply to the collection of tax under this section, where relevant. The Board can also determine the minimum value of goods for the purpose of collection.
    • Treatment of Income: Any amount subject to collection of tax under Division II of Part V of Chapter X (which includes Section 148) is considered “income” for tax purposes. Generally, where income tax is to be collected in advance, it shall be so collected.

    2. Status of Tax Collected (Adjustable vs. Minimum Tax)

    The tax collected under Section 148 is generally minimum tax on the income of the importer arising from the imports. This means that the collected tax is considered the final tax liability for the income generated from those specific imports.

    However, there are important exceptions:

    • Adjustable Tax for Industrial Undertakings: The tax collected under Section 148 is not minimum tax (implying it is adjustable) when the import is of goods by an industrial undertaking for its own use.
    • Minimum Tax for Specific Goods: Regardless of the general rule, the tax collected under Section 148 shall be minimum tax on the income of every person arising from imports of:
    • Edible oil.
    • Packaging material.
    • Paper and paper board.
    • Plastics.

    3. Calculation of “Value of Goods” for Tax

    The “value of goods” for the purpose of collecting advance tax under Section 148 is determined as follows:

    • Goods Chargeable at Retail Price: For goods chargeable to tax at retail price under the Third Schedule of the Sales Tax Act, 1990, the value is the retail price of such goods increased by sales tax payable in respect of the import and taxable supply of the goods.
    • Other Goods: For goods other than those specified above or those with a minimum value notified by the Board, the value is determined under the Customs Act, 1969, as if the goods were subject to ad valorem duty, increased by the customs-duty, federal excise duty, and sales tax, if any, payable on the import of the goods.
    • Minimum Value as Notified by Board: The Board may also notify a “minimum value” which, if applicable, is used to calculate the tax, increased by the customs-duty, federal excise duty, and sales tax payable.

    4. Tax Rates on Imports

    The rates of advance tax to be collected by the Collector of Customs under Section 148 are specified in Part II of the First Schedule. These rates vary depending on the type of goods and the importer.

    Some examples of rates include:

    • 1% of import value (increased by customs-duty, sales tax, federal excise duty) for:
    • Industrial undertakings importing remeltable steel (PCT Heading 72.04) and directly reduced iron for their own use.
    • Persons importing potassic fertilizers or urea.
    • Manufacturers importing items covered under S.R.O. 1125(I)/2011.
    • Persons importing Gold, Cotton, or LNG.
    • Goods classified in Part I of the Twelfth Schedule.
    • 2% of import value (increased by customs-duty, sales tax, federal excise duty) for:
    • Goods classified in Part II of the Twelfth Schedule.
    • Persons importing pulses.
    • 3% of import value for commercial importers covered under S.R.O. 1125(I)/2011.
    • 4% of import value for persons importing coal.
    • 4.5% of import value for ship breakers on import of ships.
    • 5.5% of import value for industrial undertakings not covered under S.Nos. 1 to 4 and companies not covered under S.Nos. 1 to 5.
    • 6% of import value for persons not covered under S.Nos. 1 to 6.
    • Special Rates for Plastic Raw Material:
    • Industrial undertakings importing plastic raw material (PCT Heading 39.01 to 39.12) for their own use: 1.75%.
    • Commercial importers importing plastic raw material (PCT Heading 39.01 to 39.12): 4.5%.
    • Specific Rates for Mobile Phones: A table specifies tax rates based on the C&F value of the mobile phone in US Dollars (e.g., Rs. 70 for up to $30, Rs. 100 for exceeding $30 and up to $100).

    5. Exemptions and Tax Concessions

    The Second Schedule of the Income Tax Ordinance specifies various exemptions and tax concessions that may apply to imports.

    Exemptions from collection under Section 148 include:

    • Goods specified under Heading 9929, Sub-Chapter VIII of Chapter 99 of the First Schedule to the Customs Act, 1969 [126(v)].
    • Liquefied Petroleum Gas (LPG) [126(vi)].
    • Liquefied Natural Gas (LNG) [126(vii)].
    • Note: While LNG is listed as exempt from collection here, it is also listed with a 1% rate in another part of the source [99, 126(vii)]. You may want to verify the current applicability of this specific exemption.
    • Agricultural tractors imported in CBU condition [126(viii)].
    • An indirect exporter as defined in the Duty and Tax Remission for Export Rules, 2001 [126(ix)].
    • Radio Navigational Aid Apparatus imported for an airport on or after January 1, 2006 [126(x)].
    • Import of specific food items including onions, potatoes, tomatoes, garlic, halal meat (goat, sheep, beef), and live animals (bovine, buffalos, cows, sheep, goats, camels) [127(xii)].
    • Goods donated for the relief of earthquake victims or flood victims of 2007, provided they are exempt from customs duties and sales tax [127(xiv), 130(xxvi)].
    • Tents, tarpaulin, and blankets [127(xv)].
    • Import of ships and floating crafts including tugs, dredgers, and survey vessels [127(xvii)].
    • One-time import of 32 buses by Daewoo Express Bus Service Ltd [128(xix)].
    • Goods temporarily imported into Pakistan for subsequent exportation that are exempt from customs duty and sales tax [128(xx)].
    • Capital goods imported by a manufacturer whose sales are 100% exports, provided they have a certificate from the Commissioner of Income Tax stating the goods will be installed in their own industrial undertaking and exclusively used for export production [128(xxi)].
    • Capital goods and raw material imported by a manufacturer exporter registered with the Sales Tax Department [129(xxii)].
    • Petroleum (E&P) companies covered under SRO. 678(I)/2004, with the exception of motor vehicles imported by such companies [129(xxiii), 132(xii)].
    • Companies importing high speed diesel oil, light diesel oil, high octane blending component or motor spirit, furnace oil, JP-1, MTBE, kerosene oil, crude oil for refining, and chemicals for refining, in respect of such goods [129(xxiv), 132(xi)].
    • Re-importation of re-usable containers for re-export that qualify for customs-duty and sales tax exemption on temporary import [130(xxv)].
    • Plant, machinery, equipment, and specific items used in the production of bio-diesel that are exempt from customs-duty and sales tax [130(xxvii)].
    • The Federal Government, a Provincial Government, or a Local Government [131(vi), (vii), (viii)].
    • Mineral oil imported by a manufacturer or formulator of pesticides, if exempt from customs-duties [131(v)].
    • Goods produced or manufactured and exported from Pakistan that are subsequently imported within one year of their exportation, provided conditions of Section 22 of the Customs Act, 1969, are complied with [132(xiii)].

    Tax concessions (reduced rates) for imports include:

    • White Sugar: For specific periods, tax under Section 148 was collected at 0.25% for import of white sugar, commercial import of white sugar, and import of raw sugar by sugar mills (subject to quota).
    • Border Sustenance Markets: For goods supplied within the limits of Border Sustenance Markets established with Iran and Afghanistan, there is an exemption. However, if these goods are brought outside the market limits, income tax is charged on the import value as per Section 148 provisions. Customs authorities may require a bank guarantee equal to the income tax involved, which is released upon presentation of a consumption certificate [125(iii)].

    6. Relation to Other Tax Provisions

    • Exemption from Withholding Tax on Resale: If an importer has paid tax under Section 148 in respect of goods and subsequently sells those goods in the same condition as they were when imported, that sale is exempt from tax deduction under Section 153(1) (payments for goods or services). This prevents double taxation on the same transaction.
    • Motor Vehicle Sales: While not a direct import tax, Section 231B mandates advance tax collection at the time of sale of motor vehicles by the manufacturer. If the vehicle is imported, and tax under Section 148 was already collected from the same person for that vehicle, Section 231B does not apply [78(4)]. The value for these vehicles can be the import value assessed by Customs authorities plus duties and taxes.
    • Certificate of Collection: Every person collecting tax under Division II of Part V (which includes Section 148) must furnish a certificate of collection or deduction of tax to the person from whom the tax has been collected.

    Taxation of Exports: Advance, Minimum, and Final Regimes

    Taxation on exports involves the collection or deduction of advance tax at various stages of the export process, primarily from foreign exchange proceeds or the value of exported goods. The nature of this tax (whether adjustable, minimum, or final) and the applicable rates can vary depending on the type of export and the exporter.

    Here are the details regarding taxation on exports, based on the provided sources:

    1. Advance Tax on Export Proceeds (Section 154)

    • Collection by Authorized Dealers: Every authorized dealer in foreign exchange is required to deduct tax from the foreign exchange proceeds on account of the export of goods by an exporter, at the time of realization of these proceeds [68(1)]. This deduction also includes advance tax [68(1)].
    • Collection by Banking Companies: Every banking company must deduct tax from the proceeds on account of a sale of goods to an exporter under an inland back-to-back letter of credit or any other arrangement prescribed by the Board, at the time of realization of these proceeds [70(3)].
    • Collection by Export Processing Zone Authority: The Export Processing Zone Authority collects tax at the time of export of goods by an industrial undertaking located in a Zone [70(3A)].
    • Deduction by Direct Exporters/Export Houses: Direct exporters and export houses registered under the Duty and Tax Remission for Exports Rules, 2001, and Export Facilitation Scheme, 2021, must deduct tax when making a payment for a firm contract to an indirect exporter as defined under those rules [71(3B)].
    • Collection by Collector of Customs: The Collector of Customs collects tax from the gross value of goods exported at the time of clearing the goods [71(3C)].
    • Tax Rates: The tax rates for these collections/deductions are specified in Division IV of Part III of the First Schedule [68(1), 70(3), 70(3A), 71(3B), 71(3C)]. Specifically, the rate of tax to be deducted under sub-sections (1), (3), (3A), or (3B) of section 154 is 1% of the proceeds of the export.
    • Nature of Tax: The tax deductible under Section 154 (excluding sub-section (1), which is adjustable) on the income of a resident person is minimum tax [67(3), 72]. However, the tax deductible under sub-section (1) of section 154 is adjustable [69(2)].

    2. Advance Tax on Export of Services (Section 154A)

    • Collection by Authorized Dealers: Every authorized dealer in foreign exchange must deduct tax from the realization of foreign exchange proceeds on account of various services, including:
    • Computer software, IT services, or IT Enabled services [72(1)].
    • Construction contracts executed outside Pakistan [73(1)(d)].
    • Foreign commission due to an indenting commission agent [73(1)(da)].
    • Other services rendered outside Pakistan as notified by the Board [73(1)(e)].
    • Tax Rates: The rates for these deductions are specified in Division IVA of Part III of the First Schedule [72(1)].
    • For export proceeds of Computer software or IT services or IT Enabled services, the rate is 0.25% of proceeds for tax years 2023.
    • Nature of Tax (Final Tax Regime): The tax deductible under Section 154A is generally a final tax on the income arising from these transactions, provided certain conditions are met [73(2)]. These conditions include:
    • Return has been filed [73(2)(a)].
    • Withholding tax statements for the relevant tax year have been filed [73(2)(b)].
    • No credit for foreign taxes paid shall be allowed [74(2)(d)].
    • Option to Opt Out: The final tax provisions of sub-section (2) of Section 154A will not apply to a person who does not fulfill the specified conditions or who opts not to be subject to final taxation [74(3)].

    3. Exemptions and Concessions Related to Exports

    • Indirect Exporter (Section 148 exemption): The provisions of Section 148 (advance tax on imports) shall not apply to an indirect exporter as defined in the Duty and Tax Remission for Export Rules, 2001 [125(ix)].
    • Capital Goods and Raw Material for Export Production: Section 148 (advance tax on imports) shall not apply to the import of capital goods by a manufacturer whose sales are 100% exports, provided they have a certificate from the Commissioner stating the goods will be installed in their own industrial undertaking and exclusively used for production of goods to be exported [127(xxi)].
    • Capital Goods and Raw Material by Manufacturer Exporter: Section 148 also does not apply to capital goods and raw material imported by a manufacturer exporter registered with the Sales Tax Department [127(xxii)]. This is consistent with a previous clause that also exempted capital goods and raw material imported exclusively for own use by a manufacturer registered with Sales Tax Department from Section 148.
    • Exemption from Section 153(1) for Imported Goods Sold: A sale of goods is exempt from tax deduction under Section 153(1) (payments for goods or services) if:
    • The sale is made by the importer of the goods [66(a)(i)].
    • The importer has paid tax under Section 148 in respect of the goods [66(a)(ii)].
    • The goods are sold in the same condition they were in when imported [66(a)(iii)].
    • Reduced Rates for Specific Export Services: For certain periods, income from services rendered outside Pakistan and construction contracts executed outside Pakistan were charged at 50% of the rates specified in Division III of Part III of the First Schedule, provided receipts from services and income from contracts were brought into Pakistan in foreign exchange through normal banking channels.
    • Exclusion from Minimum Tax on Turnover for SMEs: The provisions of Section 113 (minimum tax on turnover) do not apply to SMEs [135(7)]. Their export proceeds are subject to tax as per the rates prescribed for the final tax regime [135(6)].
    • Adjustable Tax on Supply of Goods by SMEs: The tax deductible under clause (a) of sub-section (1) of section 153 shall not be minimum tax where payments are received on sale or supply of goods by SMEs [135(8)].
    • General Exemption for Foreign-Source Salary of Residents: Any foreign-source salary received by a resident individual is exempt from tax if the individual has paid foreign income tax in respect of the salary [39(1)]. This includes situations where tax has been withheld by the employer and paid to the foreign revenue authority [39(2)].

    4. Other Relevant Provisions

    • Income from Business of Shipping (Resident Person): A resident person engaged in the business of shipping is charged a presumptive income tax based on tonnage [13(3), 14, 15, 16]. This can be a final tax [124(xi)].
    • Ships and floating crafts purchased or bare-boat chartered and flying the Pakistan flag pay one US $ per gross registered tonnage per annum [14(a)].
    • Ships, vessels, and floating crafts not registered in Pakistan and hired under any charter other than bare-boat charter pay fifteen US cents per ton of gross registered tonnage per chartered voyage, not exceeding one US $ per ton of gross registered tonnage per annum [14(b), 15].
    • A Pakistan resident ship-owning company registered with SECP after November 15, 2019, having its own sea-worthy vessel registered under Pakistan Flag, pays seventy-five US Cents per ton of gross registered tonnage per annum [16(c)].
    • Foreign Tax Credit (for Residents): Where a resident taxpayer derives foreign source income chargeable to tax in Pakistan and has paid foreign income tax on it, a tax credit is allowed. The credit amount is the lesser of the foreign income tax paid or the Pakistan tax payable on that income [39(1)].

    It is important to note that tax collected or deducted under Section 154 and Section 154A is generally considered a final tax on the income arising from export transactions, provided certain conditions are met, such as filing returns and withholding tax statements, and not claiming foreign tax credits [73(2), 74(2)(d), 79(1)]. Where income tax is to be collected or paid in advance, it shall be so collected or paid [8(6)].

    Understanding Income Tax Surcharges and Penalties

    Based on the provided sources, there are two primary types of surcharges mentioned: a surcharge on high-earning persons and a default surcharge.

    Here are the details for each:

    1. Surcharge on High-Earning Persons

    This type of surcharge is a direct tax on income above a certain threshold.

    • Imposition: A surcharge is imposed on every individual and association of persons.
    • Applicability: It applies where the taxable income exceeds rupees ten million.
    • Rate: The rate is ten percent of the income tax imposed under Division I of Part I of the First Schedule.
    • Historical Note (Omitted Section 4A): Previously, a surcharge was payable by every taxpayer at the rate of fifteen percent of the income tax payable for a specific period ending on June 30, 2011. This surcharge was to be paid, collected, deducted, and deposited in the same manner as other taxes. However, this provision (Section 4A) was omitted by the Finance Act, 2014.

    2. Default Surcharge (Section 205)

    The default surcharge is a penalty-like charge imposed for the late payment of taxes or other amounts, or for the failure to collect or deduct taxes. This is detailed under “PART XII DEFAULT SURCHARGE” in the sources.

    • General Application (Section 205(1)):
    • Liability: A person is liable for default surcharge if they fail to pay any tax (excluding advance tax under section 147 and default surcharge itself), any penalty, or any amount referred to in section 140 or 141, on or before the due date for payment.
    • Rate: The rate is twelve percent or KIBOR plus three percent per annum, whichever is higher, on the unpaid amount.
    • Computation Period: This surcharge is computed for the period commencing on the date the amount was due and ending on the date it was paid.
    • Waiver for Appeals: If a person opts to pay the tax due based on an order under section 129 on or before the due date in a notice under section 137(2) issued as a consequence of that order, and does not file an appeal under section 131, they shall not be liable to pay default surcharge for the period beginning from the due date of payment in consequence of the appealed order to the date of payment in consequence of the subsequent notice.
    • On Advance Tax (Section 205(1A) & (1B)):
    • Failure to Pay Advance Tax: A person who fails to pay advance tax under section 147 is liable for default surcharge at the rate of twelve percent or KIBOR plus three percent per annum, whichever is higher. The surcharge is computed on the unpaid tax from the due date to the payment date or the due date of the income return, whichever is earlier.
    • Insufficient Advance Tax Payment: If, for any tax year, a taxpayer fails to pay tax under section 147(4A) or (6), or if the tax paid is less than ninety percent of the tax chargeable for the relevant tax year, default surcharge applies. The rate is the same (twelve percent or KIBOR plus three percent per annum, whichever is higher) on the amount by which the tax paid falls short of ninety percent, or on the tax so chargeable.
    • Calculation Period for Insufficient Advance Tax: This surcharge is calculated from the first day of April in that tax year to the date the assessment is made or June 30 of the next financial year, whichever is earlier. For a special tax year, the default surcharge is calculated from the first day of the fourth quarter of that special tax year until the assessment date or the last day of the special tax year, whichever is earlier.
    • For Failure to Collect or Deduct Tax (Section 205(3)):
    • Liability: A person who fails to collect tax (as required under Division II of Part V of Chapter X or Chapter XII) or deduct tax (as required under Division III of Part V of Chapter X or Chapter XII), or fails to pay an amount of tax collected or deducted by the due date as required under section 160, is liable for default surcharge.
    • Rate: The rate is twelve percent or KIBOR plus three percent per annum, whichever is higher, on the unpaid amount.
    • Computation Period: This is computed for the period commencing on the date the amount was required to be collected or deducted and ending on the date it was paid to the Commissioner.
    • Assessment and Refund:
    • The Commissioner assesses any default surcharge imposed as if it were tax, and the provisions for tax assessment apply.
    • The Commissioner may, at discretion, assess default surcharge for the full period of default or part thereof, even if the tax due has not actually been paid.
    • Any default surcharge paid by a person shall be refunded to the extent that the tax, penalty, or other related amount is later held not to be payable.
    • If the amount of tax or penalty for which default surcharge is chargeable is reduced by an order, the default surcharge levied shall be reduced accordingly.
    • Effect of Extensions on Due Date:
    • An extension of time granted for payment of tax due or permission to pay in instalments shall not change the due date for the purpose of charging default surcharge under section 205(1). Liability for default surcharge still arises from the original due date of the tax.
    • Waiver and Exemption:
    • The Board may make schemes for the waiver of default surcharge in respect of the recovery of tax arrears or withholding taxes.
    • The Federal Government or the Board can, by notification in the official Gazette or by an order, exempt any person or class of persons from payment of the whole or part of the penalty and default surcharge payable, subject to specified conditions and limitations.

    Company Taxation in Pakistan (2024)

    The taxation of companies in Pakistan is governed by a comprehensive set of rules within the Income Tax Ordinance, 2001, as amended up to June 30, 2024. These provisions cover general tax rates, specific industry rules, special charges, various tax credits and exemptions, and procedural aspects.

    Here are the details regarding company taxation:

    1. General Tax Rates for Companies

    The standard rates of tax imposed on the taxable income of companies are as follows:

    • Small company: 20%
    • Banking company: 39%
    • Any other company: 29%

    It is important to note that these rates were substituted by the Finance Act, 2022. Previously, rates varied, for instance, a banking company was taxed at 50%, a public company (other than banking) at 35%, and a private company (other than banking) at 45%. Historically, for companies other than banking companies, the rate gradually reduced from 35% in tax year 2007 to 29% for tax year 2019 and onwards, with specific rates for interim years. Small companies were previously taxed at 25%.

    2. Specific Provisions for Certain Companies and Industries

    • Banking Companies:
    • Their income, profits, and gains, and the tax payable thereon, are computed according to the rules in the Seventh Schedule, applicable from tax year 2009 onwards.
    • They are not subject to withholding tax provisions as a recipient of an amount on which tax is deductible.
    • Income computed under the Seventh Schedule is charged under the “Income from Business” head at the rates specified in Division II of Part I of the First Schedule.
    • Advance tax for banking companies is payable in twelve monthly installments by the 15th of every month.
    • Minimum tax provisions (Section 113) apply to banking companies just as they do to any other resident company.
    • From tax year 2015 onwards, dividend income and capital gains of banking companies are taxed at the rate specified in Division II of Part I of the First Schedule.
    • For tax years 2020 and 2021, an enhanced rate of 37.5% applies to taxable income from additional investment in Federal Government securities, instead of the standard Division II rate. This requires a certificate from an external auditor.
    • A reduced tax rate of 20% applies to taxable income from additional advances for low-cost housing for tax years 2020 to 2023, with a further reduction to 10% for advances to Naya Pakistan Housing and Development Authority schemes. An external auditor’s certificate is required.
    • Similarly, a reduced tax rate of 20% applies to taxable income from additional advances for Farm Credit in Pakistan for tax years 2020 to 2023. An external auditor’s certificate is also required, and the Commissioner may request further details.
    • Group relief (Section 59B) and group taxation (Section 59AA) are available to banking companies, provided the holding and subsidiary companies are banking companies, their accounts are audited by a State Bank of Pakistan (SBP) panel firm, and subject to SBP approval.
    • Adjustments related to ‘Shariah Compliant Banking’ approved by the SBP will not reduce or add to income and tax liability, and a statement certified by auditors comparing Islamic and normal accounting principles must be attached to the return. Adjustments from applicable accounting standards, policies, or SBP instructions are generally excluded from taxable income computation, and notional gains/losses are not recognized until fully realized.
    • Insurance Companies:
    • Profits and gains from insurance business are computed according to the rules in the Fourth Schedule.
    • They are explicitly excluded from the special provisions regarding capital gain tax on the disposal of listed securities (Section 37A and Section 100B).
    • Oil, Natural Gas, and Other Mineral Deposits:
    • Special provisions apply to their production, exploration, and extraction.
    • Profits and gains from the exploration and extraction of wasting mineral deposits (excluding petroleum or natural gas), as specified by the Board with the Minister-in-charge’s approval, are computed according to Part II of the Fifth Schedule.
    • Resident companies engaged in the exploration and extraction of specific mineral deposits, with undertakings set up between July 1, 1981, and June 30, 1998, benefit from a 50% reduction in tax rates for a five-year period immediately following their initial five years of commercial production.
    • Small and Medium Enterprises (SMEs):
    • A special procedure is provided for SMEs.
    • Category-1 (annual business turnover up to Rs. 100 million): Taxed at 7.5% of taxable income. They may opt for a Final Tax Regime at 0.25% of gross turnover.
    • Category-2 (annual business turnover exceeding Rs. 100 million but not exceeding Rs. 250 million): Taxed at 15% of taxable income. They may opt for a Final Tax Regime at 0.5% of gross turnover.
    • The option for the Final Tax Regime is irrevocable for three tax years once exercised.
    • Public vs. Private Companies:
    • The Ordinance lays out principles for their taxation.
    • There are specific provisions for the disposal of business by individuals or associations of persons to wholly-owned companies, and the disposal of assets between wholly-owned companies.
    • In case a private company’s tax cannot be recovered, its directors (excluding employed directors) and shareholders (owning at least 10% of paid-up capital) are jointly and severally liable for the outstanding tax. These individuals can then seek recovery from the company or other liable parties. This liability is treated as tax due under an assessment order.
    • If a private company defers salary payments to an employee for an earlier tax year, the Commissioner may include that amount in the employee’s income for the earlier year if there are reasonable grounds to believe the deferral occurred.
    • Companies Not Appearing in Active Taxpayers’ List:
    • Special rules in the Tenth Schedule govern the collection/deduction of advance income tax and the computation of income and tax payable for such persons (including companies) or those who have not filed their returns by the due date. These rules override other conflicting provisions in the Ordinance.
    • However, these provisions do not apply to non-resident individuals holding Pakistan Origin Card (POC), National ID Card for Overseas Pakistanis (NICOP), or Computerized National ID Card (CNIC) who maintain a Foreign Currency Value Account (FCVA) or Non-resident Pakistani Rupee Value Account (NRVA) with authorized banks in Pakistan.
    • Companies in Shipping Business (Resident):
    • Are subject to a presumptive income tax. (Note: Historical provisions for tonnage tax based on gross registered tonnage have been omitted).
    • Companies for Power Generation:
    • Dividend income declared or distributed on shares of a company set up for power generation benefits from a reduced tax rate of 7.5%.
    • Companies for Film-making:
    • Historical tax reductions (50% for foreign film-makers, 70% for resident companies on film-making income) have been omitted by the Finance Act, 2021.

    3. Special Taxes and Charges Applicable to Companies

    • Surcharge on High-Earning Persons:
    • Previously, a surcharge of 10% of the income tax was imposed on individuals and associations of persons with taxable income exceeding Rs. 10 million [previous version information].
    • However, Section 4A, which contained this provision, was OMITTED by the Finance Act, 2014. Therefore, this surcharge is no longer in effect.
    • Default Surcharge (Section 205):
    • Companies are liable for default surcharge if they fail to pay any tax (excluding advance tax and default surcharge), penalty, or other specified amounts by the due date [previous response].
    • The rate is 12% or KIBOR plus 3% per annum, whichever is higher, computed on the unpaid amount from the due date to the payment date [previous response].
    • It also applies to failure to pay advance tax or insufficient advance tax payment (less than 90% of the tax chargeable) [previous response].
    • Furthermore, it applies if a company fails to collect or deduct tax (e.g., withholding tax) or fails to deposit collected/deducted tax by the due date [previous response].
    • The Commissioner assesses it as if it were tax, and it is refunded if the related tax is later found not payable [previous response].
    • Crucially, an extension of time for payment does not alter the original due date for default surcharge calculation [previous response].
    • For minimum tax calculation purposes, “Corporate Tax” excludes default surcharge and penalties.
    • Tax on Undistributed Profits (Section 5A):
    • For tax years 2017 to 2019, a tax of 5% of accounting profit before tax was imposed on public companies (excluding scheduled banks or modarabas) that failed to distribute at least 20% of their after-tax profits as cash dividends within six months of the tax year end.
    • This provision does not apply if a company is restricted from distributing dividends due to an agreement with the Government of Pakistan.
    • Minimum Tax (Section 113):
    • Applies to resident companies, permanent establishments of non-resident companies, and certain individuals/AOPs with high turnover.
    • It comes into play when the calculated tax payable for the year is below a certain threshold (e.g., due to losses).
    • Specific minimum tax rates (as a percentage of turnover) apply to certain industries, including oil marketing companies, oil refineries, gas companies (with turnover over Rs. 1 billion), Pakistani airlines, poultry industry, fertilizer dealers/distributors, and online marketplaces.
    • Historically, the purchase price of electricity for corporatized entities of WAPDA (DISCOs) and NTDC was excluded from turnover liable to minimum tax up to tax year 2013, but this clause has been omitted.
    • Super Tax (Section 4C):
    • This tax is specifically mentioned in relation to capital gains on the disposal of listed securities. The National Clearing Company of Pakistan Limited (NCCPL) computes and collects this tax at rates specified in Division IIB of Part I of the First Schedule on capital gains.
    • Additional Tax (Section 99D):
    • The Ordinance provides for an “Additional tax on certain income, profits and gains”, implying it can apply to companies, though specific details of its application are not provided in the sources.

    4. Tax Credits and Exemptions for Companies

    • Tax Credit for Investment (Section 65B):
    • A company investing in plant and machinery for extension, expansion, balancing, modernization, or replacement in its industrial undertaking in Pakistan is allowed a credit equal to 10% of the invested amount against its tax payable (including minimum and final taxes). For tax year 2019, this rate was 5%. This credit can be carried forward to subsequent tax years.
    • If the investment is solely in new plant and machinery (not for BMR), a credit of 20% of the invested amount is allowed against tax payable, in the year the machinery is installed.
    • Tax Credit for Specified Industrial Undertakings (Section 65G):
    • Eligible companies making specified capital investments receive a 25% investment tax credit against tax payable (including minimum and final taxes). Any unadjusted credit can be carried forward for up to two subsequent tax years.
    • Exemptions under International Agreements (Section 44):
    • Any Pakistan-source income that Pakistan is prevented from taxing under a tax treaty is exempt from tax under the Ordinance.
    • Foreign Tax Credit (Section 103):
    • A resident company can claim a tax credit for foreign income tax paid on foreign-source income taxable in Pakistan.
    • The credit is limited to the lesser of the foreign income tax paid or the Pakistan tax payable on that income.
    • It applies separately to each head of income.
    • Any unutilized credit cannot be refunded, carried back, or carried forward.
    • The foreign income tax must be paid within two years after the end of the tax year in which the foreign income was derived.
    • Inter-Corporate Dividend within Group Companies:
    • Income from inter-corporate dividends within group companies (entitled to group taxation under Section 59AA) is exempt, provided the group’s return has been filed for the tax year.
    • Dividend Income and Long-Term Capital Gains of Venture Capital Funds:
    • These are exempt from tax if derived from investments in zone enterprises (as defined in the Special Technology Zones Authority Act, 2021) for a period of ten years from the issuance of the license by the Authority to the zone enterprise.
    • Non-Residents with Special Convertible Rupee Accounts (SCRA):
    • Non-resident entities (excluding local branches/subsidiaries/offices of foreign banks/companies operating in Pakistan) are exempt from minimum tax (Section 113) and tax on profit on debt (Section 151) for receipts from Pak Rupee denominated Government and corporate securities and redeemable capital listed on a registered stock exchange, provided the investments were made exclusively from foreign exchange remitted via an SCRA.
    • Capital gains arising to a non-resident company (without a permanent establishment in Pakistan) from investments in debt instruments and Government securities (including treasury bills and Pakistan investment bonds) through an SCRA are also exempt from certain advance tax provisions (Section 147(5B)).
    • Tax deducted on profit on debt from specified debt instruments and government securities through an SCRA is considered final tax for non-resident persons without a permanent establishment in Pakistan.
    • Sukuk-Related Exemptions:
    • Specific Sukuk, like those issued by “The Second Pakistan International Sukuk Company Limited” and “Third Pakistan International Sukuk Company Limited,” are exempt from certain provisions related to currency conversion gains/losses (clause (d) of section 46). Other entities like “WAPDA First Sukuk Company Limited” and “Pakistan International Sukuk Company Limited” are also mentioned, implying potential exemptions.
    • LNG Terminal Operators and Owners:
    • These entities are listed, potentially indicating specific exemptions or special tax treatments.
    • Income from Services and Construction Contracts Outside Pakistan:
    • Income derived from services rendered outside Pakistan and construction contracts executed outside Pakistan is subject to 50% of the normal rates, provided the receipts are brought into Pakistan in foreign exchange through normal banking channels.
    • Furthermore, income from technical services rendered outside Pakistan to a foreign enterprise is exempt if received in Pakistan in foreign exchange.

    5. Provisions Related to Company Structure and Transactions

    • Amalgamation/Merger:
    • “Amalgamation” is defined to include mergers of banking companies, financial institutions, insurance companies, industrial undertakings, or service providers (non-trading), where at least one is a public company.
    • Expenditure incurred by an amalgamated company on legal, financial advisory, and administrative costs related to the amalgamation process is deductible.
    • If conditions of the amalgamation scheme (set by SBP/SECP/court) are not met, previously allowed loss set-offs or depreciation allowances become deemed income for the year the default is discovered.
    • Generally, no gain or loss arises on the issue, cancellation, exchange, or receipt of shares due to a Scheme of Arrangement and Reconstruction under the Companies Act, 2017.
    • Group Taxation (Section 59AA):
    • 100% owned holding and subsidiary companies can irrevocably opt to be taxed as one fiscal unit.
    • This is limited to companies locally incorporated under the Companies Act, 2017.
    • Losses incurred prior to group formation are not eligible for this relief.
    • The option is contingent on compliance with corporate governance and group designation rules specified by the Securities and Exchange Commission of Pakistan (SECP).
    • The Board may establish rules for group taxation.
    • As noted above, inter-corporate dividends within such groups are exempt.
    • Group Relief (Section 59B):
    • A subsidiary or holding company can surrender its assessed loss (excluding capital or brought-forward losses) to its holding company, subsidiary, or another subsidiary of the holding company.
    • If surrendered losses are not adjusted, the surrendering subsidiary can carry them forward.
    • Specific rules apply if the holding company’s ownership falls below certain thresholds within five years, requiring the company to offer previously untaxed profits.
    • Cash transfers between companies for loss adjustments are not taxable events.
    • Share transfers for group formation (with SECP/SBP approval) are also not taxable events, but third-party sales are.
    • Controlled Foreign Company (CFC) Provisions (Section 109A):
    • A non-resident company is considered a CFC if a resident person controls it, the tax paid by the CFC outside Pakistan is less than 60% of the tax payable in Pakistan, it does not derive active business income, and its shares are not traded on a recognized stock exchange.
    • The income of a CFC is treated as taxable income of a resident taxpayer and is taxed at the rate specified in Division III of Part I of the First Schedule.
    • The attributable income is calculated by a specific formula.
    • Income below Rs. 10 million is considered small.
    • CFC income is determined in its local currency and converted to Rupees at the State Bank of Pakistan rate on the last day of the tax year.
    • Importantly, income taxed in Pakistan under CFC rules is not taxed again when received by the resident taxpayer in Pakistan.

    6. Taxable Income Computation for Companies

    • Heads of Income:
    • Companies derive income under various heads, including “Income from Business,” “Income from Property,” “Capital Gains,” and “Income from Other Sources”.
    • For resident companies, both Pakistan-source and foreign-source income are considered; for non-resident companies, only Pakistan-source income is relevant.
    • Deductions:
    • Generally, no deduction is allowed for any cess, rate, or tax paid or payable in Pakistan.
    • Expenditure by a company exceeding Rs. 250,000 for a single account head, if not paid digitally from a notified business bank account, is not allowed as a deduction, with an exception for payments of taxes, duties, fees, fines, or other statutory obligations.
    • Banking companies, Development Finance Institutions (DFIs), Non-Banking Finance Companies (NBFCs), or Modarabas are allowed a deduction for profit accruing on non-performing debts credited to a suspense account in accordance with Prudential Regulations.
    • Capital Gains:
    • Gains from the disposal of capital assets are chargeable to tax.
    • Specifically, gains from the disposal of immovable property in Pakistan are chargeable at rates in Division VIII of Part I of the First Schedule.
    • Capital gains from the disposal of securities (after July 1, 2010) are chargeable at rates in Division VII of Part I of the First Schedule. This does not apply to banking and insurance companies.
    • Gains on the disposal of assets located in Pakistan by a non-resident company (even if alienation occurs outside Pakistan) are considered Pakistan-source income and are taxable. The person acquiring such an asset from a non-resident must deduct tax at 10% of the fair market value. If the non-resident company holds assets indirectly through a resident company, the resident company is responsible for collecting advance tax from the non-resident company.
    • Profit on Debt:
    • If a company’s business is to derive profit on debt, it is chargeable under “Income from Business,” not “Income from Other Sources”.
    • Tax is deducted at source from profit on debt at rates specified in Division IA/IB of Part III of the First Schedule.
    • Specific rates apply to non-resident sukuk holders and non-resident companies with SCRA accounts (as detailed in exemptions above).
    • A zero percent tax rate applies to profit on debt covered under specific exemptions for non-resident individuals with POC/NICOP/CNIC from rupee accounts funded by foreign exchange.
    • Unexplained Income or Assets:
    • Any unexplained income or assets discovered by the Commissioner are included in the company’s income and taxed accordingly.

    7. Collection and Recovery of Tax from Companies

    • Advance Tax (Section 147):
    • For companies, advance tax for a quarter is computed using a specific formula based on the company’s turnover. If the quarterly turnover is unknown, it’s assumed to be one-fourth of 120% of the turnover of the latest tax year for which a return has been filed.
    • Failure to pay or insufficient payment of advance tax may result in default surcharge [previous response].
    • Withholding Tax:
    • Companies act as withholding agents for various payments, including profit on debt, fees for offshore digital services, capital gains, and brokerage/commission.
    • Tax deducted on sale/supply of goods (under Section 153(1)(a)) is not a minimum tax if the recipient is a manufacturing company or a public company listed on a registered stock exchange.
    • Tax deducted on execution of contracts (under Section 153(1)(c)) is adjustable if received by a public company listed on a registered stock exchange.
    • Payments for advertisement services (to newspaper/magazine owners) and for sale of goods/execution of contracts by a public company listed on a registered stock exchange are exempt from minimum tax under Section 153(1)(b) (rendering of services).
    • A company receiving tax collected or deducted from an association of persons is allowed a tax credit.
    • Due Date for Payment:
    • Section 137 addresses the due date for tax payments. (Specific dates are not detailed in the provided sources, but the section exists).
    • Recovery of Tax:
    • The Commissioner has powers to recover tax from a company’s property or through the arrest of the taxpayer.
    • Tax can also be recovered by the District Officer (Revenue), from liquidators, or from persons holding money on behalf of a taxpayer.
    • As mentioned, directors and major shareholders of private companies can be held jointly and severally liable for unrecovered tax.
    • If a company’s tax liability arises in bankruptcy, it is considered a current expenditure and is paid before other creditors’ claims.

    8. Administration and General Provisions

    • Resident Company Definition:A company is a resident company if it is incorporated or formed under any law in Pakistan, or if the control and management of its affairs are situated wholly in Pakistan at any time during the year, or if it is a Provincial Government or Local Government in Pakistan.
    • Income Tax Authorities:The administration involves various authorities such as the Board, Chief Commissioner Inland Revenue, Commissioner Inland Revenue, and Commissioner Inland Revenue (Appeals).
    • Power to Amend Schedules/Exemptions:The Federal Government or the Board, by notification in the official Gazette, can amend the Second Schedule to grant exemptions or reductions in tax rates.

    This comprehensive overview covers the primary aspects of company taxation as described in the provided sources.

    Principles of Tax Exemption and Final Tax Regimes

    Tax exemptions in the provided sources refer to specific incomes, classes of income, persons, or classes of persons that are not subject to income tax under certain conditions. The framework for these exemptions is primarily outlined in Part VII of Chapter III and extensively detailed in The Second Schedule.

    Here’s a detailed breakdown of tax exemptions:

    General Framework of Exemptions

    • Inclusion in Total Income, but not Taxable Income: While a person’s “total income” includes income exempt from tax under the Ordinance, “taxable income” is derived by reducing total income by deductible allowances, meaning exempt income is not part of the amount subject to tax rates.
    • Primary Source of Exemptions: The Second Schedule is the main repository for specifying incomes, classes of income, persons, or classes of persons that are:
    • Exempt from tax under the Ordinance, subject to specified conditions and extent. This is covered in Part I of the Second Schedule.
    • Subject to reduced tax rates (less than those in the First Schedule). This is covered in Part II of the Second Schedule.
    • Allowed a reduction in tax liability. This is covered in Part III of the Second Schedule.
    • Exempt from the operation of specific provisions of the Ordinance. This is covered in Part IV of the Second Schedule.
    • Government Authority to Grant Exemptions: The Federal Government may, by notification in the official Gazette, amend the Second Schedule to grant exemptions, reduce tax rates, reduce tax liability, or exempt from the operation of any provision. However, such amendments only have legal effect if also provided for in the Ordinance.
    • Information Collection: The Board has the authority to authorize government departments or agencies to collect and compile data regarding incomes from industrial and commercial undertakings that are exempt from tax.
    • Exemption Certificates: The Commissioner can issue an exemption or lower rate certificate if an amount is exempt from tax under the Ordinance, is subject to a lower tax rate, or is subject to a one hundred percent tax credit. Persons required to collect or deduct tax must comply with such certificates.

    Specific Exemptions from Total Income (as per sources)

    • Agricultural Income: Any rent or revenue derived from land situated in Pakistan and used for agricultural purposes, and any income from land situated in Pakistan derived from agricultural operations, is exempt from tax.
    • Diplomatic and United Nations Exemptions:Income of individuals entitled to privileges under the Diplomatic and Consular Privileges Act, 1972, and the United Nations (Privileges and Immunities) Act, 1948, to the extent provided in those respective Acts.
    • Any pension received by a citizen of Pakistan from former employment in the United Nations or its specialized agencies (including the International Court of Justice), provided the salary from such employment was exempt under the Ordinance.
    • Foreign Government Officials: Salary received by an employee of a foreign government as remuneration for services rendered to such government is exempt, provided the employee is a citizen of the foreign country (not Pakistan), the services are similar to those performed by Federal Government employees in foreign countries, and the foreign government grants a similar exemption to Federal Government employees performing similar services in that country.
    • Exemptions under International Agreements:Any Pakistan-source income that Pakistan is not permitted to tax under a tax treaty.
    • Any salary received by an individual (not being a citizen of Pakistan) to the extent provided for in an Aid Agreement between the Federal Government and a foreign government or public international organization.
    • Exemption under Foreign Investment (Promotion and Protection) Act, 2022: Investment or investors may be exempt or subject to tax at specific rates and in the manner specified under this Act.
    • President’s Honours: Mentioned as an exemption, but specific details are not provided in the excerpts.
    • Profit on Debt: Mentioned as an exemption, but specific details are not provided in the excerpts.
    • Scholarships: Any scholarship granted to a person to meet the cost of their education is exempt from tax, unless the scholarship is paid directly or indirectly by an associate.
    • Support Payments: Any income received by a spouse as support payment under an agreement to live apart is exempt from tax.
    • Government Income: The income of the Federal Government, Provincial Governments, and Local Governments is exempt from tax.
    • Foreign-Source Income: Exemptions exist for foreign-source income of short-term resident individuals and returning expatriates, though specific details are not provided in these excerpts.
    • Association of Persons (AOP) Income: If the income of an association of persons is exempt and no tax is payable due to this exemption, the share received by a member out of the AOP’s income remains exempt.
    • Tax Credit for Certain Organizations (Section 100C): Certain incomes of a trust, welfare institution, or non-profit organization are eligible for a tax credit (effectively making them exempt from tax), including:
    • Donations, voluntary contributions, subscriptions.
    • Income from house property.
    • Investments in Federal Government securities.
    • So much of the income chargeable under the head “income from business” as is expended in Pakistan for welfare activities, provided the exemption for business income is proportional to its contribution to the aggregate income from all eligible sources.
    • Unexplained Foreign Exchange Remittances (Section 111): Any amount of foreign exchange remitted from outside Pakistan through normal banking channels not exceeding five million rupees in a tax year, encashed into rupees by a scheduled bank with a certificate from that bank, is not treated as unexplained income or assets.
    • Omitted Exemptions (Illustrative): The sources mention several omitted clauses from the Second Schedule, indicating past exemptions such as amounts received as monthly installments from certain pension plans (if invested for 10 years), and specific interest income on foreign currency bearer certificates.

    Limitations on Exemptions

    • Original Recipient Rule (Section 55): Where any income is exempt from tax, the exemption is generally limited to the original recipient of that income and does not extend to any person receiving any payment wholly or in part out of that income, unless a specific provision to the contrary is stated in the Ordinance.
    • Losses from Exempt Business Income (Omitted Provision): Historically, if a person’s business income was exempt due to a tax concession, any loss sustained during the exemption period could not be set off against the person’s taxable income after the exemption expired. While omitted, this highlights the principle of not benefiting from losses generated during exempt periods.
    • Banking Companies (Fourth Schedule): Generally, exemptions and tax concessions available under the Second Schedule do not apply to the income of a banking company when computed under the Fourth Schedule, with some exceptions for accumulated business loss set-off.

    Exemptions from Specific Tax Provisions (Part IV of Second Schedule)

    • Minimum Tax (Section 113):The provisions of Section 113 regarding minimum tax do not apply to:
    • National Investment (Unit) Trust.
    • Collective investment schemes authorized or registered under the Non-banking Finance Companies (Establishment and Regulation) Rules, 2003.
    • Real estate investment trusts approved and authorized under the Real Estate Investment Trust Regulations, 2015.
    • Pension funds registered under the Voluntary Pension System Rules, 2005.
    • Any other company in respect of turnover representing transactions in shares or securities listed on a registered stock exchange.
    • Past Omissions: Several exemptions from minimum tax were previously provided but later omitted, such as for Provincial Governments, local authorities, and certain businesses.
    • Alternative Corporate Tax (Section 113C): Exempt income is specifically excluded from accounting income for the purpose of computing Alternative Corporate Tax.
    • Advance Tax Collection (General – Section 236O): Advance tax under certain chapters shall not be collected or deducted from:
    • The Federal Government or a Provincial Government.
    • A foreign diplomat or a diplomatic mission in Pakistan.
    • A person who produces a certificate from the Commissioner that their income during the tax year is exempt.
    • Advance Tax on Educational Institutions (Section 236A): Advance tax is not collected if the annual fee does not exceed two hundred thousand rupees, or on amounts paid by way of scholarship. It is also not collected from non-resident persons.
    • Payments to Non-residents (Section 152): The provisions of Section 152 for payments to non-residents do not apply in the case of a Hajj Group Operator in respect of Hajj operations.
    • Foreign Experts’ Income Tax: Income tax payable by a foreign expert may be exempted if such expert is acquired with the prior approval of the Ministry of Textile Industry.
    • Depreciation (Section 22): The provisions of Section 22(8) regarding depreciation do not apply to the Civil Aviation Authority (CAA) in respect of assets transferred for the purpose of an ijara agreement.
    • Opt-out from Final Tax Regimes: For certain types of income where tax is typically collected or deducted as a “final tax” (e.g., petroleum products, services, contracts, commissions), a person may opt out of the final tax regime and choose to file a return of total income under the normal tax regime. This is subject to conditions, such as ensuring that the minimum tax liability under the normal tax regime is not less than a specified percentage (e.g., 10% of commission or discount for petroleum products/commission income).

    Income Subject to “Final Tax” (Effective Exemption from Normal Computation)

    • When tax is collected or deducted as a final tax under Section 169 (or other provisions), the income is treated differently:
    • It shall not be chargeable to tax under any head of income in computing the person’s taxable income.
    • No deductions are allowed for expenditures incurred in deriving this income.
    • The amount of the income is not reduced by any deductible allowances or the set-off of any loss.
    • The tax deducted shall not be reduced by any tax credit allowed.
    • Generally, there shall be no refund of the tax collected or deducted, unless the tax so collected or deducted is in excess of the amount for which the taxpayer is chargeable.
    • For the purpose of minimum tax computation, “tax payable or paid” does not include tax already paid or payable in respect of deemed income which is assessed as a final discharge of tax liability under Section 169 or any other provision. This highlights that final tax regimes operate outside the regular taxable income calculation.

    Income Tax Offenses and Penalties

    The Income Tax Ordinance, 2001, provides a comprehensive framework for various offenses and their corresponding penalties, including monetary penalties and provisions for prosecution leading to fines or imprisonment. These details are primarily outlined in Chapter X, Part X (Penalty) and Part XI (Offences and Prosecutions) of the Ordinance.

    Here are the details regarding penalties as per the provided sources:

    I. General Penalties (Section 182 – Offences and Penalties Table)

    The Ordinance specifies various offenses and their associated penalties:

    • Failure to furnish a return of income as required under section 114 within the due date:
    • Penalty is the higher of 0.1% of the tax payable in respect of that tax year for each day of default, or Rupees one thousand for each day of default.
    • Minimum penalty is Rupees ten thousand for individuals with 75% or more income from salary, and Rupees fifty thousand in all other cases.
    • Maximum penalty shall not exceed two hundred percent of tax payable by the person in a tax year.
    • The amount of penalty is reduced by 75%, 50%, and 25% if the return is filed within one, two, and three months respectively after the due date or extended due date.
    • “Tax payable” means tax chargeable on the taxable income based on assessment made or treated to have been made under sections 120, 121, 122, or 122D.
    • Failure to furnish any statement required under section 165:
    • Penalty of Rupees two thousand.
    • Additional penalty of Rupees two hundred for each day of default after the imposition of the initial penalty.
    • If no tax was required to be collected or deducted during the relevant period, the minimum penalty is ten thousand Rupees.
    • Failure to furnish wealth statement or wealth reconciliation statement:
    • Penalty of 0.1% of the taxable income per week or Rs. 100,000, whichever is higher.
    • Failure to furnish a foreign assets and income statement within the due date (Section 116A):
    • Penalty of 2 percent of the foreign income or value of the foreign assets for each year of default.
    • Failure to furnish a return of income as required under sub-section (3) of section 117 within the time specified in the notice:
    • Penalty is the higher of 0.1% of the tax payable for each day of default, or Rs. 1,000 per day of default.
    • Minimum penalty is Rs. 10,000 for an individual and Rs. 50,000 in all other cases.
    • Failure to issue cash memo or invoice or receipt when required:
    • Penalty of five thousand rupees or three percent of the amount of the tax involved, whichever is higher.
    • Failure to apply for registration:
    • Penalty of ten thousand rupees.
    • Failure of a trader or a shopkeeper required to apply for registration under this Ordinance to register or pay advance tax as specified in a special procedure scheme under section 99B:
    • The shop of such person shall be sealed for seven days for the first default and for twenty-one days for each subsequent default.
    • Failure to notify the changes of material nature in the particulars of registration:
    • Penalty of five thousand rupees.
    • Failure to deposit the amount of tax due or any part thereof in the time or manner laid down:
    • Penalty of five percent of the amount of the tax in default for the first default.
    • For the second default, an additional penalty of 25% of the amount of tax in default.
    • For the third and subsequent defaults, an additional penalty of 50% of the amount of tax in default.
    • If the person opts to pay the tax due on or before the due date in consequence of an order under section 129 and does not file an appeal under section 131, the penalty payable shall be reduced by 50%.
    • Repeating erroneous calculation in the return for more than one year whereby amount of tax paid is less than the actual tax payable:
    • Penalty of thirty thousand rupees or three percent of the amount of the tax involved, whichever is higher.
    • No penalty shall be imposed to the extent of the tax shortfall occurring as a result of the taxpayer taking a reasonably arguable position.
    • Failure to maintain records required:
    • Penalty of ten thousand rupees or five percent of the amount of tax on income, whichever is higher.
    • Failure to produce the record or documents on receipt of notice under section 177:
    • On first notice: Penalty of twenty-five thousand rupees.
    • On second notice: Penalty of fifty thousand rupees.
    • On third notice: Penalty of one hundred thousand rupees.
    • Failure to furnish the information required or to comply with any other term of the notice served under section 176 or 108:
    • Penalty of twenty-five thousand rupees for the first default and fifty thousand rupees for each subsequent default.
    • Making a false or misleading statement to an Inland Revenue Authority:
    • Penalty of twenty-five thousand rupees or 50% of the amount of tax shortfall, whichever is higher.
    • No penalty for tax shortfall in deemed assessments under section 120 if a reasonably arguable position is taken.
    • Failure to comply with income tax general order issued by the Board (Section 114B):
    • Penalty of fifty million rupees for the first default and one hundred million for each subsequent default. The effective date is notified by the Board.
    • Denying or obstructing the access of the Commissioner or any authorized officer to premises, place, accounts, documents, computers or stocks:
    • Penalty of fifty thousand rupees or fifty percent of the amount of tax involved, whichever is higher.
    • Concealment of income or furnishing inaccurate particulars of such income:
    • Penalty of one hundred thousand rupees or an amount equal to the tax which the person sought to evade, whichever is higher.
    • No penalty for mere disallowance of a claim of exemption or deduction unless proved the claim was knowingly wrong.
    • Failure to pay tax at the time of making payment as consideration of shares or at the time of registration of shares by the Securities and Exchange Commission of Pakistan or the State Bank of Pakistan, whichever is earlier (Section 37(6)):
    • Penalty equal to fifty percent of the amount of tax involved.
    • Obstructing any Income Tax Authority in the performance of official duties:
    • Penalty of twenty-five thousand rupees.
    • Contravention of any provision for which no penalty has been specifically provided:
    • Penalty of five thousand rupees or three percent of the amount of tax involved, whichever is higher.
    • Failure to collect or deduct tax as required or failure to pay the tax collected or deducted as required under section 160:
    • Penalty of forty thousand rupees or 10% of the amount of tax, whichever is higher.
    • If no tax was required to be deducted or collected, the minimum penalty is ten thousand Rupees.
    • Failure to display NTN or business licence at the place of business (Sections 181C, 181D):
    • Penalty of five thousand rupees.
    • Reporting financial institution or reporting entity failing to furnish information or country-by-country report to the Board as required under section 107, 108 or 165B:
    • Penalty of two thousand rupees for each day of default, subject to a minimum of twenty-five thousand rupees.
    • Failure to keep and maintain document and information required under section 108 or Income Tax Rules, 2002:
    • Penalty of ten thousand rupees for the first default, twenty-five thousand rupees for the second, and fifty thousand rupees for the third.
    • Offshore tax evader involved in offshore tax evasion:
    • Penalty of one hundred thousand rupees or an amount equal to two hundred percent of the tax which the person sought to evade, whichever is higher.
    • Enabler enabling, guiding, advising or managing any person to design, arrange or manage a transaction or declaration which has resulted or may result in offshore tax evasion:
    • Penalty of three hundred thousand rupees or an amount equal to two hundred percent of the tax which was sought to be evaded, whichever is higher.
    • Person involved in asset move as defined in clause (5C) of section 2 from specified territory to an un-specified territory:
    • Penalty of one hundred thousand rupees or an amount equal to one hundred percent of the tax, whichever is higher.
    • Reporting Financial Institution failing to comply with any provisions of section 165B or Common Reporting Standard Rules:
    • Penalty of Rs. 10,000 for each default and an additional Rs. 10,000 each month until the default is redressed.
    • Reporting Financial Institution filing an incomplete or inaccurate report under section 165B or Common Reporting Standard Rules:
    • Penalty of Rs. 10,000 for each default and an additional Rs. 10,000 each month until the default is redressed.
    • Reporting Financial Institution failing to obtain valid self-certification for new accounts or furnishes false self-certification:
    • Penalty of Rs. 10,000 for each default and an additional Rs. 10,000 each month until the default is redressed.
    • Reportable Jurisdiction Person failing to furnish valid self-certification or furnishes false self-certification:
    • Penalty of Rs. 5,000 for each default and an additional Rs. 5,000 each month until the default is redressed.
    • Company or Association of Persons contravening the provisions of Section 181E:
    • Penalty of Rs. 1,000,000 for each default.
    • Failure to integrate or perform roles and functions as specified, after being duly notified by the Board as SWAPS Agent (Section 237A):
    • Penalty of five hundred thousand rupees or two hundred percent of the amount of tax involved, whichever is higher.
    • Failure to integrate business for monitoring, tracking, reporting or recording of sales, services and similar business transactions with the Board or its computerized system (Section 237A):
    • Penalty up to one million rupees, and if the offense continues after two months of penalty imposition, business premises shall be sealed until integration.
    • Company and an association of persons failing to fully state all relevant particulars/information in the return, or furnishing blank/incomplete annexures/statements/documents:
    • Penalty of Rs. 500,000 or 10% of the tax chargeable on the taxable income, whichever is higher.

    II. General Provisions for Penalties

    • Penalties specified in the table for Section 182 are applied consistently and no penalty is payable unless an order in writing is passed by the Commissioner, Commissioner (Appeals), or the Appellate Tribunal after providing an opportunity of being heard.
    • If the taxpayer admits their default, they may voluntarily pay the amount of penalty due.
    • It is clarified that establishing mens rea (guilty mind) is not necessary for levying of penalty under this section.
    • If the amount of tax in respect of which any penalty is payable is reduced in consequence of any order under the Ordinance, the amount of penalty shall be reduced accordingly.

    III. Penalty for Return Not Filed Within Due Date (Section 182A)

    • Notwithstanding other provisions, if a person fails to file a return of income under section 114 by the due date or by the extended date, the Commissioner may impose a penalty. (Specific penalty amounts are detailed above under “Failure to furnish a return of income”).

    IV. Exemption from Penalty and Default Surcharge (Section 183)

    • The Federal Government (by notification) or the Board (by order, with recorded reasons) may exempt any person or class of persons from payment of the whole or part of the penalty and default surcharge payable under the Ordinance, subject to specified conditions and limitations.

    V. Recovery of Tax Collected or Deducted (Section 161)

    • Where a person fails to collect tax or deduct tax from a payment as required, or fails to pay tax collected or deducted, the Commissioner may recover the amount from that person as if it were tax due from them.
    • The person held personally liable for an amount of tax due to failing to collect or deduct it is entitled to recover that tax from the person from whom it should have been collected or deducted.
    • The Commissioner may amend a recovery order if deemed erroneous and prejudicial to revenue, after providing an opportunity of being heard.

    VI. Offences and Prosecutions (Resulting in Fines and/or Imprisonment)

    The Ordinance also outlines various offenses that, upon conviction, can lead to fines, imprisonment, or both, which are distinct from administrative monetary penalties but are categorized under “Offences and Penalties” in the Ordinance structure:

    • Prosecution for non-compliance with certain statutory obligations (Section 191): Failing to comply with notices (e.g., related to returns, wealth statements, advance tax, information, or tax collection/deduction). Punishable with fine or imprisonment for a term not exceeding one year, or both. Continued failure to furnish returns/wealth statements can lead to a further offence punishable with a fine not exceeding fifty thousand rupees or imprisonment for a term not exceeding two years, or both.
    • Prosecution for failure to furnish information in return of income (Section 191A): Companies or associations of persons failing to fully state particulars, furnishing blank/incomplete particulars or annexures in their return. Punishable with fine or imprisonment for a term not exceeding one year or both.
    • Prosecution for non-registration (Section 191B): Any person required to apply for registration who fails to do so. Punishable with imprisonment for a term not exceeding six months or fine or both.
    • Prosecution for false statement in verification (Section 192): Making a false statement in verification in any return or document, knowing or believing it to be false. Punishable with fine up to hundred thousand rupees or imprisonment for a term not exceeding three years, or both.
    • Prosecution for concealment of income (Section 192A): Concealment or furnishing inaccurate particulars of income with a revenue impact of Rs. 500,000 or more. Punishable with imprisonment up to two years or with fine or both.
    • Prosecution for concealment of an offshore asset (Section 192B): Failure to declare or furnishing inaccurate particulars of an offshore asset with a revenue impact of Rs. 10 million or more. Punishable with imprisonment up to three years or with a fine up to five hundred thousand Rupees or both.
    • Prosecution for failure to maintain records (Section 193):
    • Where the failure was deliberate: fine not exceeding fifty thousand rupees or imprisonment for a term not exceeding two years, or both.
    • In any other case: fine not exceeding fifty thousand rupees.
    • Prosecution for improper use of National Tax Number Certificate (Section 194): Knowingly or recklessly using a false NTN Certificate, including another person’s. Punishable with a fine not exceeding fifty thousand rupees or imprisonment for a term not exceeding two years, or both.
    • Prosecution for making false or misleading statements (Section 195): Making a false/misleading statement or omitting material information to an income tax authority.
    • If made knowingly or recklessly: fine or imprisonment for a term not exceeding two years, or both.
    • In any other case: fine.
    • Prosecution for non-compliance with notice under section 116A (Section 195A): Failure to comply with a notice under sub-section (2) of section 116A. Punishable with imprisonment up to one year or with a fine up to fifty thousand Rupees or both.
    • Prosecution for enabling offshore tax evasion (Section 195B): An enabler guiding, advising, or managing a transaction/declaration resulting in offshore tax evasion. Punishable with imprisonment for a term not exceeding seven years or with a fine up to five million Rupees or both.
    • Prosecution for obstructing an income tax authority (Section 196): Obstructing an income tax authority in discharge of functions. Punishable with fine or imprisonment for a term not exceeding one year, or both.
    • Prosecution for disposal of property to prevent attachment (Section 197): Disposing of property after receiving notice from Commissioner to prevent attachment. Punishable with fine up to hundred thousand rupees or imprisonment for a term not exceeding three years, or both.
    • Prosecution for unauthorised disclosure of information by a public servant (Section 198): Disclosing particulars in contravention of the Ordinance. Punishable with a fine of not less than five hundred thousand rupees or imprisonment for a term not exceeding one year, or both.
    • Prosecution for abetment (Section 199): Knowingly and willfully aiding, abetting, assisting, inciting, or inducing another person to commit an offence. Punishable with fine or imprisonment for a term not exceeding three years, or both.
    • Offences by companies and associations of persons (Section 200): If a company commits an offence, every person responsible for its conduct at the time is also deemed guilty.

    Pakistan Income Tax Regimes and Regulations

    Based on the sources, here are the details regarding different tax regimes under the Income Tax Ordinance, 2001:

    The Income Tax Ordinance, 2001, is a comprehensive law that consolidates and amends income tax regulations in Pakistan, effective as of June 30, 2024. It imposes income tax for each tax year on every person who has taxable income.

    Income is generally categorized under various Heads of Income for taxation purposes, including:

    • Salary
    • Income from Property
    • Income from Business
    • Capital Gains
    • Income from Other Sources

    Income of a resident person considers both Pakistan-source and foreign-source income, while for non-residents, only Pakistan-source income is considered.

    Here are the details on various tax regimes:

    1. Normal Tax Regime

    This is the standard method of computing tax on a person’s taxable income.

    • Imposition: Income tax is imposed at the rate or rates specified in Division I or II of Part I of the First Schedule on every person with taxable income for the year.
    • Computation of Taxable Income:
    • A person’s income chargeable to tax is computed based on their regularly employed method of accounting.
    • Companies are required to account for income chargeable under “Income from Business” on an accrual basis, while other persons may use either cash or accrual basis.
    • The Board may prescribe the accounting method for any class of persons.
    • Adjustments are made when the accounting method changes to ensure no item is omitted or double-counted.
    • Income is derived when received (cash basis) or due (accrual basis), and expenditure is incurred when paid (cash basis) or payable (accrual basis).
    • Rates of Tax for Individuals and Association of Persons (Division I of Part I of the First Schedule):
    • The rates are set out in a table with different slabs based on taxable income.
    • For taxable income up to Rs. 600,000, the rate is 0%.
    • Rates progressively increase with income, up to 35% for taxable income exceeding Rs. 4,000,000.
    • For professionals (e.g., doctors, lawyers, etc., appearing on the Active Taxpayers’ List) with income exceeding Rs. 50 million, and who are members of a recognized professional body, the maximum rate is 40% instead of 45%. (Note: The 45% rate is not explicitly detailed in the provided table for individuals, but the 40% reduction implies its existence).
    • Rates of Tax for Companies (Division II of Part I of the First Schedule): These rates exist, but the specific percentage breakdown for companies is not provided in the excerpts.

    2. Final Tax Regime (FTR)

    Under this regime, the tax collected or deducted at source is considered the final tax liability for the income, meaning no further tax is due on that income, and it is generally not adjustable or refundable.

    • General Application: This section applies where the tax required to be deducted is a final tax under specific provisions of the Ordinance.
    • Incomes/Payments Subject to FTR (or treated as such):
    • Return on Investments in Sukuks (Section 5AA): Tax is imposed on persons receiving returns on Sukuks from a special purpose vehicle or a company. The tax is computed by applying the relevant rate to the gross amount of the return.
    • Rates (Division IIIB of Part I of the First Schedule):
    • 25% if the Sukuk-holder is a company.
    • 12.5% if the Sukuk-holder is an individual or association of persons and the return is more than one million.
    • 10% if the Sukuk-holder is an individual or association of persons and the return is less than one million.
    • Income from Sukuks taxed under Section 5AA is not chargeable to tax under “Income from Business”.
    • Certain Payments to Non-residents (Section 6): Tax is imposed on non-resident persons receiving Pakistan-source royalty, fee for offshore digital services, fee for money transfer operations, card network services, payment gateway services, interbank financial telecommunication services, or fee for technical services. The tax is computed by applying the relevant rate to the gross amount of receipts.
    • Rates (Division IV of Part I of the First Schedule):
    • 15% of the gross amount of royalty or fee for technical services.
    • 10% in any other case.
    • This section does not apply if the income is effectively connected with a permanent establishment in Pakistan, in which case it is treated as income from business.
    • These incomes are not chargeable to tax under “Income from Business”.
    • Shipping and Air Transport Income of a Non-resident Person (Section 7): Tax is imposed on non-resident persons operating ships or aircrafts for carriage of passengers, livestock, mail, or goods embarked in Pakistan or received in Pakistan for goods embarked outside Pakistan. The tax is computed by applying the relevant rate to the gross amount.
    • Rates (Division V of Part I of the First Schedule):
    • 8% for shipping income.
    • The rate for air transport income is implied by Division V, but not specifically given a percentage in the excerpt.
    • These incomes are not chargeable to tax under “Income from Business”.
    • Tax on Builders and Developers (Sections 7C, 7D, 7F):
    • Section 7C (Builders): Tax is imposed on the construction and sale of residential, commercial, or other buildings, computed by applying the relevant rate to the area of the building.
    • Section 7D (Developers): Tax is imposed on the development and sale of residential, commercial, or other plots, computed by applying the relevant rate to the area of the plots.
    • Section 7F: Income, profits, and gains of a builder or developer from a project are exempt from sections 113 and 113C (Minimum Tax on Turnover). Any tax paid under this section is not refundable or adjustable against any other tax liability. This indicates a final tax regime.
    • The Eleventh Schedule provides specific rules for computation of profits and gains of builders and developers and the tax payable thereon.
    • Payments for Goods or Services (Section 153(6)): The tax deducted under this section is generally a final tax on the income of a resident person arising from the specified transactions.
    • Toll Collection (Section 235(3)): Tax collected on a lease of the right to collect tolls is a final tax.
    • Small and Medium Enterprises (SMEs) (Fourteenth Schedule): SMEs have the option to be taxed under a final tax regime.
    • Rates (of gross turnover):
    • Category-1 (annual business turnover not exceeding Rs. 100 million): 0.25%.
    • Category-2 (annual business turnover exceeding Rs. 100 million but not exceeding Rs. 250 million): 0.5%.
    • This option, once exercised, is irrevocable for three tax years.
    • Traders (Section 99A and Ninth Schedule): Traders can opt to be assessed under this Schedule instead of the general Ordinance provisions. If they opt for this, the Commissioner is deemed to have made an assessment of income and tax due as computed under specific rules in the Schedule. This often involves a presumptive or final tax based on working capital or total turnover for specific tax years.

    3. Minimum Tax Regime (MTR)

    This regime ensures that certain taxpayers pay a minimum amount of tax, even if their computed tax liability under the normal regime is low or they have a loss.

    • Section 113 (Minimum Tax on the Income of Certain Persons):
    • Applicability: Applies to resident companies, permanent establishments of non-resident companies, individuals with a turnover of Rs. 100 million or more (from tax year 2017 onwards), and associations of persons with a turnover of Rs. 100 million or more (from tax year 2017 onwards).
    • Trigger: It applies if, for any reason (including a loss), the tax payable or paid is less than a specified percentage of the person’s turnover from all sources for that year. The specific percentage rate is not provided in the excerpt.
    • Exclusions from “tax payable or paid” for MTR calculation: This does not include tax already paid or payable in respect of deemed income that is assessed as a final discharge of tax liability (e.g., under Section 169). It also excludes Super Tax paid under Section 4B or 4C.
    • Banking Companies: The provisions of Section 113 apply to banking companies as they do to any other resident company.
    • Profit on Debt (Section 151): Tax deductible under this section is a minimum tax on the profit on debt, unless the taxpayer is a company or the profit on debt is taxable under Section 7B. This implies it’s a minimum tax for individuals/AOPs unless specifically covered otherwise.
    • Rent of Machinery (Section 236S): The tax deductible under this section is a minimum tax on the income of the resident person.

    4. Presumptive Tax Regime (PTR)

    This involves taxation based on certain presumptions, often gross receipts or other metrics, rather than detailed income and expenditure computations. Some FTR provisions can also be considered presumptive in nature.

    • Tax on Shipping of a Resident Person (Section 7A): A presumptive income tax is charged on any resident person engaged in the business of shipping. The excerpt does not provide the specific rates or computation method for this presumptive tax.

    5. Super Tax

    This is an additional tax levied on certain categories of persons.

    • Super Tax for Rehabilitation of Temporarily Displaced Persons (Section 4B): Imposed for tax years 2015 onwards, at rates specified in Division IIA of Part I of the First Schedule, on income of specified persons. This tax is paid, collected, and deposited according to Section 137.
    • Super Tax on High Earning Persons (Section 4C): Imposed at rates specified in Division IIB of Part I of the First Schedule. This is a separate levy on high-earning individuals/AOPs.

    6. Impact of Active Taxpayers’ List (ATL)

    The Active Taxpayers’ List (ATL) influences the rates of tax for certain transactions.

    • General Rule for Non-ATL Persons (Section 100BA, Tenth Schedule):
    • For persons not appearing on the active taxpayers’ list (or those appearing but have not filed their return by the due date), the rate of tax required to be deducted or collected under any provision of the Ordinance is increased by one hundred percent of the specified rate.
    • This rule does not apply to the advance tax collected under Section 231B (advance tax on motor vehicles).
    • There are also specific property tax rates in the Tenth Schedule for non-ATL persons, based on fair market value (6% to 8% for properties over Rs. 50 million). These higher rates for non-ATL persons do not apply if the person has filed returns for all of the last three preceding tax years.

    7. Tax Treaties and Double Taxation Avoidance

    • The Federal Government may enter into tax treaties, tax information exchange agreements, or multilateral conventions for the avoidance of double taxation, prevention of fiscal evasion, or assistance in the recovery of taxes. These agreements can provide relief from tax payable under the Ordinance.

    Download PDF Book

    Read or Download PDF Book – Income Tax Ordinance 2001

    By Amjad Izhar
    Contact: amjad.izhar@gmail.com
    https://amjadizhar.blog