89 Data Warehouse jobs in South Africa

Introduction

Metropolitan is one of the oldest financial services brands in South Africa. With a 125-year legacy of serving the communities in which it operates, Metropolitan represents true empowerment in serving Africa's people through affordable financial solutions that create financial growth and security. Metropolitan operates in South Africa, but the brand is also present in 7 African countries including, Namibia, Botswana, Kenya, Ghana and Lesotho. Metropolitan provides financial wellness solutions that meet the needs of low-income clients, including funeral insurance, health, savings, hospital cash-back cover, retirement solutions and life insurance.

Disclaimer

As an applicant, please verify the legitimacy of this job advert on our company career page.

Role Purpose

Are you passionate about data architecture and analytics? We are seeking a Data Warehouse Developer to design and develop dimensional data models, data marts, and enterprise data models using MS SQL. You will play a key role in shaping our data infrastructure, ensuring efficient data storage, retrieval, and processing across different analytical data using a variety of tools.

Applicants might be invited to perform a technical skills assessment in person at the Parc du Cap offices in Bellville as part of the interview process.

Requirements

• Matric

• Degree in Information Technology/ Data Science/ Computer Science and or relevant equivalent qualification

• 5+ years of experience in Business Intelligence development, specifically with data warehouse environments (essential)

• Proven experience in sourcing from multiple database technologies and building data marts in MS-SQL (essential)

Knowledge:

• Understanding of SQL and Database technologies (MS SQL Server, DB2, Postgres, Mongo).

• Experience with dimensional modelling and Kimball methodology.

• Strong proficiency with BI tools such as SSRS, Microsoft Power BI, or similar platforms.

• Expertise in SQL, ETL development, data pipelines, and data integration.

• Experience with cloud-based data platforms (AWS, Azure, or Google Cloud) is a plus.

• Excellent problem-solving and troubleshooting skills.

• Strong communication skills, with the ability to work with both technical and business stakeholders.

Duties & Responsibilities

INTERNAL PROCESS

• Design, develop, and maintain efficient dimensional data models and data marts.

• Architect enterprise data models to support analytical and business intelligence needs.

• Implement and maintain ETL processes for seamless data integration.

• Collaborate with cross-functional teams to gather data requirements and ensure high-quality data solutions.

• Optimize query performance, ensuring high availability and responsiveness of the data warehouse platform.

• Ensure data integrity, security, and consistency across all systems and solutions.

• Provide mentorship and guidance to junior developers, ensuring best practices are followed.

• Continuously improve data warehouse architecture to support evolving business needs and emerging technologies.

CLIENT

• Provide authoritative expertise and advice to clients and stakeholders.

• Build and maintain relationships with clients, internal and external stakeholders.

• Deliver on service level agreements made with internal and external stakeholders and clients.

• Make recommendations to improve client service within area of responsibility.

• Participate and contribute to a culture which build rewarding relationships, facilitates feedback and provides exceptional client service.

PEOPLE

• Develop and maintain productive and collaborative working relationships with peers and stakeholders.

• Positively influence and participate in change initiatives within the team and across the business.

• Continuously develop own expertise in terms of professional, industry and legislation knowledge.

• Contribute to continuous innovation through the development, sharing and implementation of new ideas.

• Take ownership for driving career development through available channels.

FINANCE

• Identify opportunities to enhance cost effectiveness and increase operational efficiency.

• Provide input into the risk identification processes and communicate recommendations in the appropriate forum.

Competencies

• Examining Information

• Interpreting Data

• Developing Expertise

• Providing Insights

• Articulating Information

• Meeting Timescales

• Attention to detail

• Producing Output

Our new
Data Warehouse Developer
will be responsible for designing, developing, and maintaining enterprise data warehouse to meet the group's needs.

You would be part of the Mr Price Advance team which looks after data analytics, reporting, data science and RPA across the group

Why you should join this team?

You'll be involved in projects involving BI and Analytics across multiple data disciplines: SQL and Big Data.

We're also in the process of migrating the current data warehouses and reporting from on premise solutions to the cloud which means the opportunities for technical growth are endless

What we're looking for?

• Relevant IT Degree or Diploma
• 3+ years' experience in:
• Data warehouse design and implementation, infrastructure components and analytical tools.
• Data warehouse modelling
• Structured Query Language (SQL)
• Experience in Snowflake data warehousing
• Troubleshooting

A day in your life?

• Building large scale databases
• Data modelling (Data Vault 2.0 and Star Schema), data management, and data transformation
• Perform ongoing monitoring, automation and refinement of implemented solutions.
• Provide analysis and issue resolution on business reported concerns.
• Participate in design to influence delivery of various business intelligence solutions.
• Contributes to the designs and plans for the integration for all data warehouse technical components.
• Contributes to the design, automation, and acquisition, transformation and data loading processes in a high volume, high availability data warehouse environment
• Contributes to the design of the data warehouse architecture
• Provides production support to solve immediate problems and keeps databases in production
• Analyses information requirements of customers and supports teams and contributes to the design of the best technical solutions
• Technical implementation of the data warehouse
• Participates in testing of the data design, tool design, data extracts
• Optimisation, support and maintenance of the data warehouse environment
• Participates in testing and validation of the data model throughout the various stages of the development process.

Mr Price Group Limited is an equal opportunity employer and is committed to Employment Equity.

Job Description

The core role of a Data Warehouse Engineer is to design, build, and maintain the infrastructure necessary for data storage, processing, and analysis. This involves working with various data technologies, programming languages, and data modeling techniques to ensure data is accurate, reliable, and easily accessible to other teams within the Nando's SA region. Additionally, the application of the Ralph Kimball methodology is an integral part of this responsibility.

Minimum Requirements:

Bachelor's Degree or equivalent NQF level 6+ qualification (Computer Science or Information Systems or related)

Data Warehouse or Business Intelligence Certification (preferable but not essential)

4 – 6 years' experience as a Data Warehouse Engineer or BI Developer

Solid understanding of the Ralph Kimbal Methodology (Ideal – please list any other methodologies that you have experience of)

Experience with designing and developing data solutions using MS SQL Server

Experience with OLAP/ Cube Development in Tabular

Experience with SQL Server Integration Services (SSIS)

Experience designing and developing data integration solutions.

Experience in documenting business processes for data solutions

Experience with BI and Data warehouse security

Experience with various BI tools such as Power BI

Data Warehouse Development and Management

Lead the design, development, and optimisation for all data applications, including extracting, transforming, and integrating data from multiple sources with final approval from the manager.

Work with all external vendors in the provision of database integration, build, and maintenance services

Lead the development and maintenance of the database architecture for specific projects, as required.

Work with DBA to maintain and configure SQL database servers and services with final approval from the manager.

Regularly review database architectures and designs to ensure compliance with business objectives as well as requirements for data integrity, quality, performance, management, scalability, reliability, and security and report back to the manager.

Transform data into actionable insights using the appropriate BI tools and systems with oversight from the manager.

Adhere to core data governance disciplines when performing BI activities, including data quality management, information lifecycle management, and information security and privacy.

Data Integration

Engage with relevant stakeholders to identify business intelligence requirements and document these according to prescribed standards and methods.

Assist in conducting a gap and impact analysis on identified requirements to formulate clear data structures and ensure appropriate delivery to stakeholders.

Translate business and technical requirements into efficient and sustainable data solutions.

Design and implement effective cross-functional data solutions and processes.

Validating and testing data solution outputs for accuracy, user experience, and performance, ensuring that all errors and inefficiencies are corrected.

Collaborate with team members, end users, and other relevant stakeholders to provide input into strategies for integrating disparate systems.

Provide users with post-implementation support, including managing incidents and resolving problems using analysis, troubleshooting, and validation.

Stakeholder Management

Consult with users to determine service delivery requirements and improvement opportunities.

Establish and maintain effective working relationships with all internal and external stakeholders.

Business Support and Enablement

Contribute towards the planning, maintenance, and improvement of databases, including incorporating new releases and upgrades to ensure optimal performance.

Assist the manager in evaluating the effectiveness of existing internal processes and applications and propose solutions and opportunities for automation and audit controls.

Identify inefficiencies in system processes, recommending and implementing changes.

Gauge the effectiveness and efficiency of existing systems, developing, and executing strategies for improving or further leveraging these systems in consultation with the manager.

Research, evaluate, and recommend new tools and applications for use in assigned responsibilities.

User Support and Training

Provide 2nd level support for end users.

Escalate urgent and unresolved tickets to the relevant parties.

Participate in creating and improving the procedures for desktop support.

Prepare or assist in the preparation of data training content in the quest to make Nando's a data-driven organisation.

Compliance and Governance

Comply with all electronic and physical security procedures and standards.

Follow standard service desk procedures, including the logging of issues.

Adherence to Nando's technology standards, policies, and procedures

Records Management and Reporting

Maintain all IT records and tracking for their area of responsibility and provide managers and users with regular updates as well as any relevant status and progress information.

Maintain a record of all inquiries from the initial call to incident resolution and provide the necessary information and documentation for issues that require escalation.

Through our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations.

We help people grow their savings, protect what matters to them and invest for the future. We help companies and organisations care for and reward their employees and members. Through our own network of advisers or via independent brokers and utilising new platforms Momentum Metropolitan provides practical financial solutions for people, communities and businesses. Visit us at

Disclaimer As an applicant, please verify the legitimacy of this job advert on our company career page.

Role Purpose
The Data Warehouse Analyst plays a crucial role in translating business needs into actionable insights. This role involves gathering, analyzing, and interpreting data to provide recommendations that drive strategic decision-making. The Data Warehouse Analyst possesses a strong understanding of data warehousing, ETL processes, data visualization, and reporting techniques. They are comfortable working with various data sources and BI tools and can effectively communicate complex information to both technical and non-technical audiences.

Requirements

• Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.
• 5-8 years of experience in Data Warehouse analysis.
• 5 years' experience in data modelling in a Data Warehouse.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Proficiency in SQL and experience working with relational databases.
• Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.
• Ability to work independently and as part of a team.
• Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.
• Experience with scripting languages (e.g., Python, R) is a plus.
• Knowledge of statistical methods and techniques is a plus.

Duties & Responsibilities

• Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
• Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.
• Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
• ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
• Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
• Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
• Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement.
• Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
• Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
• Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques.
• Mentorship: Mentor junior analysts and provide guidance on best practices.

Competencies

• Data Analysis
• Data Warehousing
• ETL
• SQL
• Data Visualization
• Reporting
• Business Acumen
• Communication (Written & Verbal)
• Problem-Solving
• Critical Thinking
• Collaboration

About The Job Senior Data Warehouse Engineer
Duration:
12-month contract with possibility to convert to perm

Location:
Pretoria

Are you the
go-to expert
when it comes to
stabilising, optimising, and governing busy data warehouse environments
?

Do you thrive under pressure in
high-volume, highly regulated industries
and know how to keep things running smoothly while driving improvements?

We're looking for a
Senior Data Warehouse Engineer
to take charge of a
mission-critical environment
on a 12-month contract, based full-time onsite in Pretoria. This is a role where
your expertise will directly impact stability, efficiency, and compliance
and where you'll be seen as the
Subject Matter Expert
.

Role Responsibilities

• Architect & Optimise: Design, build, and maintain scalable, stable warehouse environments that support business growth.
• ETL Leadership: Develop and optimise SSIS pipelines with robust controls for accuracy, reliability, and automation.
• Full Data Lifecycle: Manage ingestion, transformation, storage, archival, and retrieval processes end-to-end.
• Governance & Compliance: Establish strong data governance practices, ensuring segregation, cataloguing, and audit readiness.
• Continuous Improvement: Simplify, centralise, and streamline operations to ensure stability and scalability.
• Audit Champion: Partner with auditors and consultants to ensure smooth reviews and compliance checks.

Role Requirements

• Proven experience in complex, high-volume warehouse environments.
• Background in banking or financial services (preferred), with exposure to regulatory and audit-heavy environments.
• Strong expertise in data governance, frameworks, and control processes.

• Technical strength in:

• MS SQL (on-prem, heterogeneous environment: Mongo, Postgres, Open Query)

• ETL using SSIS, automated control environments, and SQLM Control integrated with SSMS.

• Demonstrated ability to stabilise and scale existing data ecosystems.

• Comfortable engaging with auditors, consultants, and both technical and business stakeholders.

Why This Role?

• Impact: Your work will directly stabilise and improve a warehouse that underpins critical operations.
• Challenge: An opportunity to tackle high-volume, high-stakes data environments.
• Recognition: Be the trusted SME in a role where your skills are highly visible and valued.
• Contract with Purpose: A 12-month engagement that could open doors to further opportunities.

If you're a
seasoned Data Warehouse Engineer
ready to bring
stability, governance, and efficiency
to a busy environment, we'd love to hear from you.

Apply now and put your expertise where it really matters.

Contract

5 to 25 years

Negotiable

08 October 2025

PBT Group is seeking an experienced Senior Data Warehouse Developer to join our team. This role plays a key part in designing, developing, and maintaining enterprise-level data warehouse solutions — ensuring data integrity, accessibility, and performance across large-scale financial systems.

The ideal candidate will have a strong technical foundation in SQL, ETL/ELT development, and data modeling, with proven experience delivering reliable and scalable data warehouse solutions. The role also involves translating complex datasets into actionable insights through effective visualization and reporting tools such as Power BI.

Key Responsibilities

Data Warehouse Development

• Design, develop, and maintain robust data warehouse solutions.
• Develop and optimize ETL/ELT processes to ensure efficient data extraction, transformation, and loading.
• Configure real-time data replication from source systems using tools such as Stelo SQDR or Qlik Replicate.
• Perform data quality checks, validations, and reconciliation to maintain accuracy and integrity.
• Convert legacy Excel reports into Power BI dashboards and reports.
• Implement data governance, security, and compliance best practices.
• Develop and document technical solutions that are scalable, maintainable, and reusable.

Reporting and Analytics

• Build interactive Power BI dashboards and reports aligned with business requirements.
• Translate technical data into clear, actionable insights for both technical and non-technical stakeholders.
• Ensure accurate data attribution and validation for reporting and cost analysis.
• Perform data analysis and visualization to support business decision-making.

Collaboration and Support

• Engage with business analysts, data scientists, and technical stakeholders to clarify data needs and design solutions.
• Participate in operational support and troubleshooting of existing data warehouse components.
• Provide mentorship and technical guidance to junior developers.
• Collaborate across teams to drive data-driven initiatives and process improvements.

Skills and Competencies

Technical Expertise

• Strong proficiency in MS SQL Server and T-SQL.
• Experience with ETL tools (SSIS, Azure Data Factory, Informatica, Talend).
• Solid understanding of data warehouse methodologies (Kimball, Inmon).
• Intermediate to advanced experience with Power BI for data visualization.
• Exposure to data replication tools (e.g., Stelo SQDR, Qlik Replicate).
• Data transformation, modeling, and integration experience.
• Knowledge of cloud data platforms (Azure Synapse, AWS Redshift, BigQuery) advantageous.

Soft Skills

• Excellent analytical thinking and problem-solving abilities.
• Strong communication skills, both written and verbal.
• High attention to detail with a commitment to quality and accuracy.
• Effective time management and prioritization under tight deadlines.

• Collaborative team player with a proactive, solutions-driven mindset.

• In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent

• If you have not received any feedback after 2 weeks, please consider you application as unsuccessful.

Qualifications and Experience

• Bachelor's degree in Computer Science, Information Systems, Mathematics, Economics, or related field.
• 5+ years' experience as a Data Warehouse Developer or similar role.
• Proven experience in data modeling (star/snowflake schemas).
• Experience with data visualization tools (Power BI, Tableau, QlikView).
• Familiarity with version control systems (Git).
• Cloud certification (Azure, AWS, GCP) is advantageous.
• Experience with Python or PowerShell scripting beneficial.
• Exposure to big data technologies (Spark, Hadoop) advantageous.

Behavioural Competencies

• Examining and interpreting information critically
• Generating insights and innovative ideas
• Producing high-quality, accurate deliverables
• Articulating complex data clearly
• Collaborative and adaptive team approach
• Strong accountability and ownership mindset

Data WarehousingSQLSSISPower BIExtract Transform Load (ETL)Data Modeling

InsuranceFinancial Services

Momentum Group Limited (Momentum Group) is a significant player in South Africa's life insurance and integrated financial services sectors. We are a proud Level 1 B-BBEE South African-based group dedicated to building and protecting our clients' financial dreams. Our client-facing retail and specialist brands, including renowned names such as Momentum, Metropolitan, Guardrisk, and Eris Properties, play a pivotal role in fulfilling this purpose.

Our federated model emphasises empowerment, accountability, and continuous engagement with all our stakeholders. Designed in close consultation with leaders across the group, this operating model aims to unleash each business unit's inherent energy and commercial drive through our collaborative federated approach. Visit us at

Disclaimer As an applicant, please verify the legitimacy of this job advert on our company career page.

Role Purpose
Gather, analyse and interpret data from various sources, extract insights in a clear, precise and actionable manner, using easily understandable representations of data for both technical and non-technical audiences.

Requirements
Experience and Qualifications

• 3-year degree in Mathematics, Economics, Computer Science, Information Management or Statistics
• Introductory Cloud Certification - Desirable
• 1-3 years' experience as a Junior Data Warehouse/MIS Developer or related field (essential)
• Experience in ETL and visualisation tools (e.g. SQL, Informatica, QlikView, PowerBI etc.)

Duties & Responsibilities
Internal Process

• Develop Power BI solutions, working from high level technical requirements in line with business requirements.
• Quality assurance checks on all new Power BI project functionality and business requirements.
• Produce documentation for code written.
• Configure realtime replication of data from source system to the Data Warehouse, using tools like Stelo SQDR
• Partake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting
• Basic interaction and collaboration with technical stakeholders to identify data sources, find data definitions for master and meta data as well as formulate and implement solutions.
• Promote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant compliance and adherence to data governance principles.
• Promote reusability, maintainability, reliability, and scalability in design and development of data solutions.
• Process live and confidential data according to specified guidelines.
• Convert Legacy Excel reports to PowerBI
• Development and design of professional reports and dashboards to support various stakeholders within the company.
• Testing, debugging and reconciliation of data to source data to ensure data integrity.
• Ensure accuracy and integrity of data and its attribution to costs incurred by business.
• Communicate progress, including easily understandable representation of the data.
• Pro-active in suggesting for opportunities as well as making analytical observations on any aspect that would be beneficial to business.

Client

• Provide authoritative expertise and advice to clients and stakeholders.
• Continuous interaction with clients and internal stakeholders.
• Deliver on service level agreements made with clients and internal and external stakeholders in order to ensure that client expectations are managed
• Participate and contribute to a culture which builds rewarding relationships, facilitates feedback and provides exceptional client service.

People

• Develop and maintain productive and collaborative working relationships with peers and stakeholders.
• Continuously develop own expertise in terms of professional, industry and legislation knowledge.
• Contribute to continuous innovation through the development, sharing and implementation of new ideas.
• Take ownership for driving career development.

Competencies
Behavioural competencies required:

• Examining Information
• Generating Ideas
• Interpreting Data
• Articulating Information
• Producing Quality Output
• Providing Insights
• Team working
• Work output according to agreed standards

Skills required:

• Verbal and written communication
• Interpersonal skills
• Analytical skills
• Report writing
• Problem solving
• Attention to detail
• Teamwork
• Time Management
• Critical Thinking

Knowledge required:

• Business acumen
• Database development
• Software Development Lifecycle
• Intermediate SQL
• Intermediate Excel
• Intermediate Data visualisation
• Intermediate Data analysis
• Intermediate Data extraction
• Data reconciliation techniques
• Intermediate PowerBI
• Entry level Data Replication experience, e.g. Stelo SQDR, Qlik Replicate, etc.
• Intermediate SQL Server 2022
• Intermediate SSIS
• Intermediate SQL Developer/ Data Warehouse skills with MS T-SQL

Introduction

Guardrisk is the undisputed market leader in cell captive insurance and risk solutions. We are renowned for our innovative approach to cell captive structures and other alternative risk transfer solutions for our clients. Guardrisk offers clients custom designed cover and is registered in South Africa as an insurer for all statutory classes of non-life and life insurance business.

Disclaimer

As an applicant, please verify the legitimacy of this job advert on our company career page.

Role Purpose

You will be responsible for designing and developing ETL, data integration, data warehouse, performance tuning, Data Modelling and business intelligence reporting modules to deliver quality Business Intelligence solutions to the business while ensuring that quality and standards are realised and met by junior team members.

Requirements

Qualifications

3/4 year IT qualification in Software Development

Relevant Microsoft certification in the Data Space

Experience

Exposure to the full BI development life cycle.

6+ years experience in the IT Field with 4+ core experience in Data Analytics/Business Intelligence or related.

Experience managing Data Projects.

Azure Data Factory/Synapse Pipelines experience essential.

The successful candidate should have experience with SSIS and SSAS, SQL Server

Power BI required.

Duties & Responsibilities

Participate in the analysis, design, development, troubleshooting and support of the enterprise reporting and analytics platform.

Design, construct, test and implement reporting, visualization, and dashboard processes that present reporting at summary level with functionality to drill down into detail.

Develop BI solutions using SQL, ETL scripting using ADF/Synapse Pipelines, business intelligence tools, database programming and reporting tools on the Microsoft BI Stack.

Integrate with diverse source systems (including but not limited to: In-House, Vendor-based, On-prem and Cloud-based, and Office 365).

Work with DevOps team and participate in testing of all database-related changes and application updates.

Responsible for the day to day database development/administrative tasks which include the development of queries, views, and other database schema objects.

Maintain data model schema, hierarchy within data warehouse, and reporting systems.

Applying database tuning techniques to improve the performance of current solutions.

Assist lead developer in Coordinate team efforts to achieve business objectives (Strategic and operational).

Ensure business continuity documentation through Azure DevOps.

Enforce database security standards and ensure adherence by junior team.

Review code implementations by the Data team.

Oversee quality of BI solutions by junior team members.

Mentor Junior and Intermediate team members.

Drive implementation of innovative and latest technology implementations relating to the Data space through the Lead Developer and Enterprise Architecture team.

Utilize junior members in achieving large scale project developments and implementations in consultation with the lead developer.

Competencies

Must have prior experience developing business intelligence solutions in large or midsize companies.

Must be able to manage multiple tasks simultaneously and react to problems quickly.

Must be able to translate concepts and directions into practical solutions.

Must have experience in reporting and business intelligence solutions.

Must have development experience with relational database structures, multi-dimensional database, and data warehouse design architecture.

Experience with mobile deployment of business intelligence desired.

Must have experience with SQL.

Must be able to develop, maintain, review and explain data models.

Must have excellent verbal and written communication skills.

Must be a team player.

Understanding of the financial services industry desired, especially Insurance.

Development experience with Microsoft BI stack (Incl SSIS, SSRS, SSAS, Data Management).

Experience with dashboard design and delivery.

Must be able to work independently.

Experience using Power BI to analyze data and report conclusions.