
Closed
Posted
I have a SQL Server view that already aggregates every validation script we run on raw_valid and model_valid. What I now need is the front-end: an interactive Power BI dashboard built in a tabbed interface that surfaces those scripts, lets users explore them, and provides both basic text search and advanced filtering. Connection & data model • Connect directly to the existing view (read-only). • Expose the script name, object type, target table, last run date, status, and the full script body or a hyperlink to it. • Optimise the model so the dashboard opens quickly even when the view grows. Visual & navigation requirements • Two main tabs—one for raw_valid scripts, one for model_valid—each mirroring the same layout for consistency. • Search bar on each tab for quick keyword lookup plus slicers/filters (status, target table, date range, author, etc.) for advanced narrowing. • Click-through action: selecting any row or card should reveal the full SQL text or redirect to its stored location. Publishing & hand-off Please deliver the PBIX file, separate theme file (if used), and a short README explaining data source parameters so I can swap in a different server if needed. If possible, include a brief note on incremental refresh or other performance tweaks you applied. Acceptance criteria 1. Dashboard loads without credential prompts once my gateway is configured. 2. Tabs, search, and filters all return results in under three seconds on my test set. 3. Click-through reliably displays or links to the exact script selected. If you have questions about the view structure, let me know and I’ll share a sample dataset.
Project ID: 40369669
21 proposals
Remote project
Active 2 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
21 freelancers are bidding on average $29 CAD/hour for this job

I am an experienced BI Developer with extensive skills in creating dynamic Power BI dashboards and a strong understanding of SQL Server databases. With years of experience in connecting to and optimizing views for fast, reliable data delivery, I can deliver the interactive Power BI dashboard you need for your SQL validation scripts. My expertise includes developing dashboards with advanced search capabilities and interactive navigation features, ensuring that dashboards remain responsive and user-friendly. I have successfully created solutions that connect directly to SQL Server views, enabling efficient data exploration and quick loading times, even as datasets grow. I am well-versed in implementing click-through actions that provide detailed SQL text access. I am interested in discussing this project further to ensure the dashboard meets your specific requirements, particularly regarding the performance optimizations and incremental refresh features you mentioned. Please let me know if you can share a sample of your SQL Server view structure for a head start.
$25 CAD in 40 days
7.9
7.9

Being a part of SoftwareLinkers, a trusted name in creating secure, scalable digital systems for various sectors, I can confidently claim that I am the perfect fit for delivering your SQL Validation Power BI Dashboard project. With a strong background in Microsoft SQL Server and MySQL (skills), I have hands-on experience in building data-driven web applications, RESTful APIs and optimizing the database models for larger views. Understanding the criticality of your project for efficient script validation, I am committed to connecting directly to your existing SQL Server view – ensuring speedy access to script names, object types, target tables, last run date, their status and full script details (connection). My aim has always been to make complex information easily consumable, and that's why I intend to build the Power BI dashboard with a tabbed interface – one dedicated to raw_valid scripts and the other for model_valid scripts; consistency being the key. Navigating and exploring scripts should be hassle-free without compromising on performance – this is yet another area where my expertise comes handy (visual & navigation requirements).
$20 CAD in 40 days
6.2
6.2

Hi, I can build a clean, fast, and user-friendly Power BI dashboard on top of your existing SQL views for both raw_valid and model_valid scripts. I have strong experience designing interactive BI reports with search, filtering, and optimized data models. I will connect directly to your two views (read-only), structure a lightweight model for performance, and create a two-tab layout with consistent design. Each tab will include search, slicers (status, table, date, etc.), and click-through functionality to display or link the full SQL script. The final deliverable will include a fully optimized PBIX file, optional theme file, and a short README explaining parameters and refresh setup. I’ll also apply performance best practices (model optimization, optional incremental refresh) to ensure fast load times and smooth interaction.
$20 CAD in 40 days
6.0
6.0

Hi, This is strongly aligned with my background. I have solid experience with SQL Server + Power BI, including building reporting models over existing SQL objects, optimizing performance, and delivering clean handoff documentation for maintainability. I can help you build this as a fast, practical validation dashboard with: direct connection to the existing SQL Server view a clean two-tab layout for raw_valid and model_valid keyword search plus slicers/filters for navigation click-through behavior to reveal the full SQL text or open its stored location performance-minded modeling so the report stays responsive as the view grows final delivery with PBIX + README, including notes for data source parameter changes and relevant refresh/performance considerations What I like about this project is that the goal is very clear: turn an existing SQL validation layer into a usable, searchable interface for investigation and monitoring. That fits well with the kind of SQL/reporting/Power BI work I’ve done. If helpful, I’d be glad to review the view structure and sample data first, then confirm the cleanest implementation approach. Best regards, Sergio
$25 CAD in 40 days
5.9
5.9

As a data-driven AI and workflow consultant, I have extensive experience in harnessing the power of Microsoft Power BI and SQL Server for comprehensive data analysis and visualization tasks. Your project, building a Power BI dashboard to interactively expose your validation scripts in SQL Server view, aligns perfectly with my expertise. At Systemapic, our forte is optimizing data models and designing high-performing dashboards that deliver speed even with growing volumes. We understand the importance of a user-friendly interface and feature-rich filtering options that allow quick and easy exploration of the scripts. Our skills ensure an end-product that not only meets your requirement of displaying SQL scripts but also integrates advanced search functionalities to rapidly search and filter these scripts based on various attributes. You can count on me to deliver a fully functional PBIX file along with a comprehensive README detailing data source parameters for ease of future use. I am committed to meeting your acceptance criteria: ensuring no credential prompts upon gateway configuration, delivering search results under three seconds, and flawless click-through experience for viewing or linking the exact script selected. Let Systemapic bring the power of insightful data representation to your fingertips!
$25 CAD in 40 days
5.5
5.5

Hello dear,, I am a professional Excel power BI dashboard expert and can do your task perfectly because I have done lots of similar tasks and also I am in top 1% here so just text me so I can help you out with your task Kind regards
$20 CAD in 40 days
5.1
5.1

I am a Power BI Developer and Data Analyst with strong experience in building high-performance dashboards on top of SQL Server sources. I have worked on interactive reporting systems that require fast search, advanced filtering, and clean navigation over large datasets. For your requirement, I would: ✅ Connect directly to your SQL Server view in read-only mode and design an optimized data model for fast load times ✅ Build a clean tabbed interface with two consistent views for raw_valid and model_valid ✅ Implement search functionality (using DAX-based search patterns) along with advanced slicers for status, table, date, and other attributes ✅ Create click-through or drill-through interactions to display full SQL scripts or redirect to stored locations ✅ Apply performance optimizations like query folding, proper indexing usage, and incremental refresh (if applicable) You will receive: ✅ Fully functional PBIX file ✅ Optional custom theme file for consistent UI ✅ Clear README with data source parameters so you can switch servers ✅ Notes on performance improvements and refresh strategy My focus will be on speed, usability, and scalability so the dashboard remains responsive even as your validation scripts grow. Estimated timeline is around 3 days for complete implementation Happy to review your sample dataset and start right away.
$25 CAD in 40 days
4.4
4.4

Hi, With over a decade of experience, I've mastered the art of creating high-functional, intuitive dashboards using powerful data visualization tools such as Power BI. My expertise in SQL and data modeling are invaluable when connecting to existing views and optimizing models for quick usage, even as your dataset grows. In your case, my ability to minimize latency and maximize performance will ensure that your dashboard loads seamlessly, reflecting your entire dataset without sacrificing efficiency. The search and filter features you discussed will be designed with a focus on returning results swiftly, providing a stress-free user-experience. As an AI/ML expert, I bring the unique perspective of an algorithmic thinker which is crucial for working with complex datasets like yours. My proficiency extends to not just BI but also fields like blockchain and cybersecurity. Choose me for a powerful combination of technical fluency, creative problem-solving skills and deep domain knowledge that will ensure this project is not just delivered but exceeding your expectations.
$20 CAD in 40 days
4.0
4.0

As an experienced data analyst, I'm confident in my ability to tackle your SQL validation Power BI dashboard project head-on. Over my 3+ year career, I've focused on using tools like Power BI and SQL to create sophisticated and efficient reporting systems for businesses. In addition, I've got a solid background in Excel, VBA and Tableau, which will greatly enhance the quality of the solution I deliver for you. Drawing from my experience working with big datasets for complex businesses, I'll ensure a considerate design of the data model that optimizes on responsiveness even as the view's size increases. Plus, getting the balance right and delivering exactly what you need matters a great deal to me too. Thus, I'll carefully tailor the visual and navigation aspects of your dashboard - with tabs mirroring each aggregation (raw_valid & model_valid), a powerful search bar, and dynamic filters - all aimed to transform possible data complexities into user-friendly data exploration, empowering your team with better insights in no time. Trust that I'll deliver not just as per your task specifications but go further to make useful inputs like incremental refresh or other performance tweaks that holistically polish the end solution making it more robust and efficient for adaptable future use as well. Looking forward to discussing more about your project soon!
$20 CAD in 40 days
3.2
3.2

As a seasoned Bootcamp Trainer with a specialization in Data Analysis and extensive experience with Microsoft Power BI, I possess the unique blend of skills that make me an ideal choice for your SQL Validation Power BI Dashboard project. One of my key strengths is transforming complex technical subjects into understandable, actionable insights. I have honed this skill through my practical projects and through guiding students to solve real-world problems while breaking down complex concepts. Having delivered several immersive data analytics training sessions, I am adept at simplifying intricate problems like those in your project description. I can create those tabbed interfaces mirroring raw_valid and model_valid scripts that you need, applying the themes you prefer for aesthetic consistency. With my strong grasp of Power BI and its functionalities, I will optimize the model so the dashboard opens quickly no matter how large it grows while ensuring tabs, search, and filters return results within three seconds as you specified. Lastly, given my background in providing structured learning paths aligned with business needs to produce job-ready professionals, you can rely on me to deliver precisely as you envision. My focus on detail and quality will ensure that your acceptance criteria are met - from connecting directly to the existing view to handing over the PBIX file with a README explaining data source parameters.
$20 CAD in 40 days
1.7
1.7

As a seasoned and highly-skilled PhD Researcher and Machine Learning Engineer, I possess the technical prowess needed to produce for you an intuitive, efficient, and powerful Power BI dashboard. Throughout my 10+ years in the industry, I have consistently leveraged my expertise in Data Visualization, Power BI, and SQL to perfect methodologies like the one you're looking for - from connection and data model optimization to visual design and navigation construction. My extensive experience in designing and deploying Machine Learning models would especially come in handy when working on the tabbed interface aspect of the project. You can trust me to deliver a dashboard with two tabs-one each for raw_valid scripts and model_valid scripts- that mirrors a consistent layout. Additionally, my training as a PhD holder makes me meticulous about your acceptance criteria with specifics on quick results delivery (under three seconds) even as we maintain high-quality output. In producing success projects for major organizations such as Unilever Pakistan and State Bank of Pakistan, I have developed strong problem-solving, analytical thinking, and programming skills that would ensure any challenges that arise during your project are swiftly resolved. Ultimately, whether its creating an interactive Power BI Dashboard or deploying ML-driven systems for state institutions; my aim is always to deliver high quality results that meet client's goals effectively. Let’s get started!
$20 CAD in 40 days
4.5
4.5

India
Payment method verified
Member since Mar 21, 2010
₹12500-37500 INR
₹1500-12500 INR
$1500-3000 USD
₹12500-37500 INR
₹600-1500 INR
₹600-1500 INR
€8-30 EUR
$10-30 USD
$3000-5000 USD
€250-750 EUR
₹75000-150000 INR
₹1500-12500 INR
$500-5000 USD
₹1500-12500 INR
€750-1500 EUR
£750-1500 GBP
₹100-400 INR / hour
$10-60 USD
₹1500-12500 INR
$30-250 USD