
In Progress
Posted
Paid on delivery
Power BI freelancer needed to build an ISMS dashboard (ISO 27001). Create a clean, executive-level dashboard with Red/Yellow/Green status based on ratings. Data includes Controls, Risks, and Tasks. Risk status uses Residual_Risk_Rating, Task status uses Status_Rating, and Control status must roll up using worst-case logic. Requirements: * Overview page with KPIs (overall status, counts) * Control matrix/heatmap with colour coding * Drilldown from control → risks & tasks * Tables showing details and reasons for status * Filters and intuitive navigation Deliverables: * .pbix file with data model * DAX measures for roll-up logic * Basic documentation Skills: * Strong Power BI & DAX * Data modelling (star schema) * Dashboard UX design Nice to have: ISO 27001 or risk/compliance experience. I will provide two SQL server 2 tables to use as the data source.
Project ID: 40406834
59 proposals
Remote project
Active 17 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi there, I’ve carefully reviewed your requirement and understand you need a clean, executive-level Power BI dashboard for ISMS (ISO 27001) that clearly presents Controls, Risks, and Tasks with accurate Red/Yellow/Green roll-ups and intuitive drilldowns. I’m confident I can deliver a structured, decision-ready dashboard with strong data modeling and DAX logic. My approach is to first design a proper star schema from your SQL Server tables, separating fact and dimension layers for performance and scalability. I will then build DAX measures to calculate status ratings, including worst-case roll-up logic for Controls based on underlying Risks and Tasks, ensuring consistency across all views. The dashboard will include an overview page with key KPIs such as overall status and counts, followed by a control matrix or heatmap with clear color coding. I will implement drilldowns from control to risks and tasks, along with detailed tables showing status drivers and reasoning. Filters and navigation will be designed for quick executive insights without clutter. Could you confirm how Residual_Risk_Rating and Status_Rating are currently defined (numeric scale or categorical)? I’m ready to start immediately. Warm Regards, Aneesa.
$250 AUD in 1 day
5.6
5.6
59 freelancers are bidding on average $187 AUD for this job

Hello=====>>>>I can build a clean, executive-level Power BI dashboard tailored for your ISO 27001 ISMS requirements, including RYG status logic and intuitive KPI views. I’ll implement robust DAX measures for worst-case roll-ups across controls, risks, and tasks, along with drilldowns and interactive visuals. The solution will include a well-structured data model, user-friendly navigation, and complete .pbix delivery with documentation.
$301 AUD in 4 days
5.1
5.1

Hi, To build an ISMS dashboard for ISO 27001, I'll create a clean, executive-level dashboard that effectively visualizes the required data. This will include: - Overview page with KPIs and overall status - Control matrix/heatmap with color coding - Drilldown functionality from controls to risks and tasks - Tables displaying details and reasons for status I'll utilize Power BI and DAX to ensure a robust data model and intuitive navigation. Ready to start once you provide the SQL server tables and any additional details. Thanks!
$210 AUD in 5 days
4.7
4.7

Hi, I understand you need an executive-level Power BI ISMS dashboard aligned with ISO 27001, with clear Red/Yellow/Green status and accurate roll-up logic across Controls, Risks, and Tasks. I will design a clean, intuitive dashboard using a proper data model and ensure the worst-case logic is correctly applied for control status, while keeping navigation simple for decision-makers. I will connect your SQL tables, build a star schema, and create DAX measures for Residual_Risk_Rating, Status_Rating, and control roll-ups. The solution will include an overview KPI page, control heatmap, drilldowns, detailed tables, and filters for smooth interaction. You will receive a fully functional .pbix file with a structured data model, reusable DAX logic, and clear documentation for maintenance and future updates. Ready to start right away. Usman Bashir
$175 AUD in 3 days
4.7
4.7

Hi there, I am a Data Scientist,I specialize in advanced data visualization and reporting using Power BI, DAX formulas, Tableau, and Looker Studio to transform raw data into meaningful insights. My expertise includes creating custom dashboards, KPI tracking, interactive reports, and automated data models that help businesses make data-driven decisions with clarity. With strong command over DAX calculations, drill-through reports, and cross-platform integration, I ensure accuracy and actionable outcomes. I focus on delivering clean, visually appealing, and performance-optimized dashboards tailored to your business goals. My commitment is to provide scalable, insightful, and user-friendly solutions that empower stakeholders and enhance decision-making. Let's discuss this further via chat, and I'll start your project right now. Thank you. Gdev
$140 AUD in 7 days
4.9
4.9

Hi, I am a Power BI developer with 8 years of rich experience with a background in compliance dashboards. I am familiar with Power BI, DAX, SQL Server, Data Modeling, Data Visualization. For this project, the most important part is building correct roll-up logic for control status using worst-case ratings. I will create a clean executive dashboard with RYG KPIs, control heatmap, drilldowns from controls to risks and tasks, and clear detail tables. I will also structure the SQL data model properly and provide the .pbix file with basic documentation. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
$250 AUD in 7 days
4.7
4.7

Hello, I understand you need an executive-level ISMS dashboard in Power BI aligned with ISO 27001, using SQL Server data for Controls, Risks, and Tasks with proper risk aggregation logic and clear RAG (Red/Yellow/Green) visualisation. I have strong experience in Power BI, DAX modelling, and building compliance and risk dashboards with star schema design. I will design a clean data model that normalizes your two SQL tables into a structured star schema, ensuring correct relationships between Controls, Risks, and Tasks. I will implement DAX measures for Residual Risk Rating, Task Status Rating, and worst-case roll-up logic so Control status accurately reflects the highest risk level across linked entities. The dashboard will include an executive overview page with KPIs, a control heatmap matrix with conditional formatting, and drill-through pages from Control → Risks → Tasks. I will also add intuitive filters, structured navigation, and detail tables showing underlying reasons for each status to ensure full auditability. You will receive a fully functional .pbix file, documented DAX measures, and a simple guide explaining the data model and refresh setup. Thanks, Asif.
$250 AUD in 3 days
4.5
4.5

Hello, With over 7 years of experience in Data Visualization and Data Modeling, I have carefully reviewed your requirement for developing an ISMS dashboard in Power BI for ISO 27001 compliance. To accomplish this project, I will start by creating an overview page with key performance indicators, followed by a control matrix with color-coded status indicators. I will ensure drill-down functionality from controls to risks and tasks, along with detailed tables showcasing status reasons. The dashboard will feature filters for easy navigation and a seamless user experience. The deliverables will include the .pbix file with a robust data model, DAX measures for roll-up logic, and basic documentation for reference. My expertise in Power BI, DAX, data modeling, and dashboard UX design makes me well-equipped to handle this project efficiently. I would love to discuss this project further with you. Please connect with me for a detailed conversation. You can visit my Profile here: https://www.freelancer.com/u/HiraMahmood4072 Thank you.
$100 AUD in 2 days
4.3
4.3

Hi there, I understand you need an executive-level Power BI ISMS dashboard for ISO 27001, with strong data modelling, DAX-driven roll-up logic, and intuitive visual storytelling across Controls, Risks, and Tasks. The key requirement is not just building visuals, but creating a robust dashboard where Control status rolls up using worst-case logic, supported by drilldowns and clean RAG-based reporting for management decisions. My approach will begin with structuring the SQL data into a clean star schema model, then building DAX measures for Residual Risk, Task Status, and Control roll-up logic using worst-case aggregation principles. I will design an overview dashboard with KPI indicators, control heatmaps, drill-through from controls to underlying risks and tasks, and detailed supporting views that show both status and root reasons, while keeping navigation intuitive and executive-friendly. Deliverable: A complete .pbix file with data model, DAX measures for roll-up logic, executive dashboard pages with drilldowns and visual reporting, plus concise documentation covering model structure and calculations. QUESTION: Is your control framework mapped to standard ISO 27001 Annex controls (or a custom control set), and do you already have risk/control relationships defined in the SQL tables? Let’s get started and build a clean, decision-ready ISMS dashboard. Regards, Shehwani.
$150 AUD in 1 day
4.1
4.1

Hello, We’re a small team of data scientists and Power BI specialists with strong experience in DAX, data modelling, and executive dashboard design. We’ve built risk and compliance dashboards before, including KPI-driven reporting with clear Red/Yellow/Green logic. For your ISMS (ISO 27001) dashboard, we will: Design a clean, executive-level overview with key KPIs (overall status, counts) Implement robust DAX measures, including worst-case roll-up logic for Controls Build an intuitive control matrix/heatmap with dynamic colour coding Enable drilldowns from Controls → Risks → Tasks Create detailed tables with status explanations Structure a scalable star schema from your SQL Server data Deliverables will include a well-structured .pbix file, reusable DAX measures, and clear documentation for maintenance and future scaling. We focus on clarity, performance, and usability—ensuring your dashboard is decision-ready for leadership. Happy to review your data and suggest improvements before starting. Best regards,
$250 AUD in 4 days
4.6
4.6

Hey! I have gone through your description. I have done MPhil in statistics. I have strong expertise in Power BI, DAX, data modeling, and dashboard design. I also have solid experience working with SQL Server data sources and building structured star-schema models for performance and scalability. I can also show you samples if you message me. I can provide you with quality work that meets all your requirements. I can build a clean, executive-level ISMS dashboard aligned with ISO 27001 requirements, including Red/Yellow/Green status indicators based on your Risk, Control, and Task ratings. I will implement proper DAX measures for roll-up logic (including worst-case control evaluation), design an overview page with KPIs, create a control heatmap with conditional formatting, and enable drill-down from controls to risks and tasks. The report will be fully interactive with filters, clear navigation, and a professional UX structure. I can do this job with full accuracy and on time, and ensure the model is optimized for refresh and future scalability. Looking forward to see your interest. Thank-you!
$30 AUD in 2 days
4.2
4.2

⭐⭐⭐⭐⭐ Build an ISMS Dashboard with Power BI for ISO 27001 Compliance ❇️ Hi My Friend, I hope you are doing well. I reviewed your project needs and see you are looking for a Power BI freelancer to create an ISMS dashboard. Look no further; Zohaib is here to help you! My team has completed over 50 similar projects for Power BI dashboards. I will create a clean, executive-level dashboard featuring Red/Yellow/Green status indicators based on your data. I will ensure intuitive navigation and clear visualizations. ➡️ Why Me? I can easily create your ISMS dashboard with my 5 years of experience in Power BI and DAX. My skills include data modeling, dashboard design, and KPI visualization. I also have a strong grip on SQL and data analysis, ensuring your project is efficient and effective. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing this with you in chat. ➡️ Skills & Experience: ✅ Power BI ✅ DAX ✅ Data Modeling ✅ Dashboard Design ✅ KPI Visualization ✅ SQL ✅ Data Analysis ✅ Heatmap Creation ✅ User Experience (UX) ✅ Reporting ✅ Data Visualization ✅ ISO 27001 Knowledge Waiting for your response! Best Regards, Zohaib
$150 AUD in 2 days
4.2
4.2

Hi there, I am A.R.M. MASUD with a strong background in data science. I am pleased to present this proposal for data visualization and dashboard development services. I specialize in transforming raw data into meaningful, interactive visual representations that provide actionable insights. I leverage cutting-edge tools such as Power BI, Tableau, Looker Studio, and other visualization platforms to create custom dashboards and data visualizations tailored to your unique business needs. I aim to empower your organization with intuitive, user-friendly, and insightful data analytics solutions. I design and develop dynamic dashboards featuring interactive charts, graphs, and reports. I create tailored reports that reflect key performance indicators (KPIs), trends, and metrics based on business objectives. I integrate data from multiple sources, including Excel files and APIs. I build fully functional interactive dashboards with real-time or scheduled data updates and custom visualizations, charts, graphs, and KPIs tailored to your business requirements. https://www.freelancer.com/u/MZITSERVICES Thank you for considering your dashboard development project. I am confident that our expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M. MASUD
$140 AUD in 7 days
4.2
4.2

Hello, I can build your ISO 27001 ISMS Power BI dashboard with clear executive level visuals and accurate roll up logic. I will design a clean overview page with KPIs showing overall status and key counts using Red Yellow Green indicators. Control status will be calculated using worst case logic with robust DAX measures. I will create a control matrix or heatmap with intuitive colour coding for quick insights. Drilldown from controls to risks and tasks will be fully interactive and smooth. Detailed tables will show records and reasons behind each status clearly. I will structure the data model using a proper star schema connected to your SQL Server tables. Filters and navigation will be simple and user friendly for non technical users. You will receive a complete pbix file with DAX measures and basic documentation. I have strong Power BI and data modelling experience and can start immediately.
$200 AUD in 7 days
3.8
3.8

Hello, As a result of a detailed review of your project requirements, I fully understand the need to build a clean, executive-level Power BI dashboard for ISO 27001 with clear R/Y/G status and proper roll-up logic across controls, risks, and tasks. I have experience handling similar data modelling and reporting projects and I'm available to start your project right now. I bring deep expertise in Power BI, DAX, SQL, Data Modeling, and Data Visualization with over 10 years of experience. I would design a star schema from your SQL tables, implement DAX measures for worst-case roll-up logic (controls based on underlying risks/tasks), and build an overview dashboard with KPIs, heatmap matrix, drilldowns, and detailed tables with filters and intuitive navigation. One key part is ensuring accurate aggregation logic so executive summaries always reflect real risk exposure. I have a couple of quick questions. • How are Residual_Risk_Rating and Status_Rating currently structured (numeric or categorical)? • Do you have predefined thresholds for R/Y/G mapping or should I define them? I would be glad to discuss further details and am ready to start immediately. Looking forward to hearing from you. Best regards, Carlos
$30 AUD in 2 days
3.5
3.5

As an accomplished data analyst, I bring extensive experience in Power BI and deep understanding of DAX measures essential for your ISMS dashboard development. My adeptness with data modelling using a star schema and understanding of dashboard UX design will guarantee an executive-level, user-friendly ISMS dashboard for your ISO 27001 needs. Given that your data comes from SQL servers, my skillset adequatley includes proficiency in SQL. While I don't have explicit ISO 27001 risk/compliance experience, my extensive background in data analysis and application of logical rules, will certainly enable me to handle tasks like rolling up controls using worst-case logic in an astute manner. This approach is crucial for assessing risks and task statuses effectively on your dashboard. I can assure you meticulous attention to detail in order to provide strong DAX measures for roll-up logic. In conclusion, choosing me as your go-to freelance Power BI expert guarantees a high-quality deliverable ranging from a fully functional .pbix file with an effectively built star schema data model to basic documentation outlining every aspect of the project. With my comprehensive portfolio in handling diverse datasets, I am more than capable of creating clean visuals showcasing your controls, risks, and tasks ensuring easy navigation and detailed insights. Together, we can build an ISMS dashboard that drives informed decision making!
$399 AUD in 3 days
3.7
3.7

⚠️ If you're not happy, you don’t pay. ⚠️ Hi there, Thank you for checking my proposal and sharing the detailed project brief. I can build your executive-level ISMS dashboard (ISO 27001) using Power BI with a sleek, user-friendly design. I will deliver: • Overview page with KPIs • Control matrix with color coding • Drilldown feature for risks & tasks • Detailed tables with status reasons • Interactive filters and intuitive navigation You will also receive: • .pbix file with a robust data model • DAX measures for roll-up logic • Basic documentation I am confident I can execute your vision professionally and efficiently. Looking forward to discussing the timeline and next steps. Best regards, Chirag.
$200 AUD in 7 days
3.4
3.4

⭐⭐⭐⭐⭐ Proposal for ISMS Dashboard Development in Power BI With a strong background in Power BI and DAX, I am ideally suited to develop your ISMS dashboard. My experience includes crafting executive-level dashboards with complex data models, ensuring intuitive navigation and clear visual hierarchies. I have effectively utilized star schema for data modeling and have a keen eye for UX design in dashboard development. Additionally, my familiarity with ISO 27001 and compliance frameworks will be beneficial in aligning the dashboard with industry standards. I am prepared to deliver a .pbix file with robust data models, custom DAX measures for accurate roll-up logic, and comprehensive documentation. Lets enhance your ISMS visibility together.
$187 AUD in 6 days
3.8
3.8

Hi, I have 15+ years of experience working in business intelligence and expertise in data processsing ETL, data modelling, data analysis and building interactive dashbaords in power BI. I’d be glad to help build a clean, executive-level **Power BI ISMS dashboard for ISO 27001**, designed for clear risk visibility and leadership reporting. I have strong experience in **Power BI, advanced DAX, star-schema data modelling, and dashboard UX**, and can build the full solution from your SQL Server tables, including: * Executive overview page with KPI cards and overall R/Y/G status * Control matrix / heatmap with intuitive colour coding * Worst-case roll-up logic for Control status using DAX * Drill-through from **Control → Risks → Tasks** * Detailed status tables with reason / commentary fields * User-friendly filters and navigation experience * Well-structured **.pbix file + documentation** I can also ensure the data model is built for scalability and future audit / compliance reporting needs. Having worked extensively on reporting dashboards and risk-based logic models, I can deliver a polished, decision-ready dashboard with reliable DAX measures and clean visual storytelling. Available to start immediately.
$80 AUD in 7 days
3.3
3.3

Dear Client, I am ready to build a professional ISMS (ISO 27001) Executive Dashboard in Power BI exactly as specified. What I will deliver: Clean star schema data model using your two SQL Server tables RYG (Red/Yellow/Green) status logic based on Residual_Risk_Rating and Status_Rating Control matrix / heatmap with colour coding Executive overview page with key KPIs and overall status Drill-down from Control → associated Risks & Tasks Detailed tables showing status reasons Intuitive navigation, filters and professional UX Key features: Advanced DAX measures for worst-case roll-up logic Fully responsive and executive-friendly design Complete .pbix file + documentation of all measures I specialize in Power BI dashboards with complex DAX and risk/compliance reporting. I will deliver a polished, production-ready solution that clearly shows the current state of your ISMS controls. I can start immediately upon award and deliver quickly. Looking forward to working with you!
$140 AUD in 5 days
3.4
3.4

As an experienced full stack developer with 12+ years of experience, I am more than capable of effectively tackling your project's Power BI needs. I have a knack for swiftly understanding client requirements - hence, the timely delivery which I am confident will meet your expectations. My specialties in web development (React, Node.js), databases (SQL, MongoDB) and the cloud (AWS) align well with the dashboard development requirements at hand; enabling me to provide a clean, responsive executive-level dashboard. Furthermore, my command over DAX measures and data modelling strategies will ensure we achieve efficient roll-up logic for Risk and Task statuses. Additionally, my strong background in UX design is vital for creating intuitive navigation paths within the dashboard. Given that your project is related to ISO 27001 compliance, it is pertinent to mention that I possess considerable experience working with risk and compliance measures - something that might prove useful while building the Residual_Risk_Rating component of your dashboard.
$80 AUD in 7 days
3.5
3.5

Melbourne, Australia
Payment method verified
Member since Jul 23, 2021
$50-100 AUD
$1500-3000 AUD
$30-250 AUD
$20-50 AUD
$30-250 AUD
₹12500-37500 INR
₹12500-37500 INR
$10-30 USD
$30-250 SGD
$250-750 USD
$30-250 USD
$8-15 USD / hour
₹1500-12500 INR
₹12500-37500 INR
₹12500-37500 INR
£20-30 GBP
$30-250 USD
₹12500-37500 INR
₹12500-37500 INR
₹1500-12500 INR
$250-750 USD
$250-750 CAD
₹1500-12500 INR
₹1500-12500 INR
₹600-1500 INR