
Closed
Posted
Paid on delivery
I want to turn the raw data already sitting in our Microsoft Dynamics AX 2012 environment into a set of interactive financial dashboards. The core view I am after must let me track revenue, expenses, cash-flow movements and overall profit-and-loss at a glance, with the ability to drill down to the underlying AX transactions whenever needed. All data lives in AX today, so the job centres on connecting to those existing tables (or cubes if you prefer) and surfacing the numbers in an intuitive layout. Whether you choose SSRS, Power BI, or another front-end commonly paired with AX 2012 is up to you, as long as the result refreshes automatically and loads quickly for everyday use. Acceptance criteria • Dashboards render cleanly in a browser and on a 1080p monitor without additional licensing hurdles. • Figures reconcile 100 % with the balances in AX (I will provide test scripts). • Setup steps are documented well enough for my internal IT team to replicate in staging and production. If you have previous AX 2012 dashboard builds in your portfolio, especially around financial modules, that will move this along faster. Let me know which toolset you plan to use and how you would approach the data connection, and we can get started right away.
Project ID: 40755949
110 proposals
Remote project
Active 2 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
110 freelancers are bidding on average $168 USD for this job

Hello, I am Dr. Rajesh Rolen, PhD in Computer Science & Engineering, with experience of over 20+ years in SQL, Power BI, Data Visualization As a preferred freelancer in the top 1%, I have done 400+ projects here on freelancer.com, I have 4.9 ratings out of 5 on average, which showcases my quality of work and timely delivery. Key Highlights: - Free Hosting Support on the Cloud or any desired platform. - Free 3 months of post-delivery support to ensure that our client doesn’t face any challenges after the launch of the project. - Free Dedicated tester on projects to ensure quality delivery, so clients don’t need to act as a tester. - 10+ Years experience UI/UX team to ensure intuitive UI. Portfolio: https://www.freelancer.com/u/Microlent Please open the chat and send me a message, so we can have a more detailed discussion about the project to give you the project timeline and cost. Thank you for considering my services. I look forward to engaging in a productive conversation and understanding how I can be of assistance in bringing your project to life. Regards Rajesh Rolen
$140 USD in 10 days
7.7
7.7

Drawing from years of experience as a data analyst, I bring a host of skills that are an ideal fit for your project. I am quite familiar with Microsoft Dynamics AX 2012 and have proven expertise in data integration, analytics, visualization, database management and of course, SQL. These skills will allow me to nimbly connect to your existing tables and create the intricate financial dashboards you require. I can leverage various front-end tools such as SSRS and Power BI to make this process seamless. A critical aspect of my services is ensuring that all figures reconcile 100% with the balances in AX. This entails an acute level of attention to detail which I pride myself on. You can rely on my meticulous approach to guarantee the accuracy of your financial dashboards. Moreover, I understand the importance of documentation both during and after a project. You can be assured that I will provide comprehensive steps for your IT team to replicate my work impeccably. Although I don't have any specific AX 2012 dashboard builds in my portfolio, I assure you that my broad grasp of data analysis and visualization is more than sufficient for this project. My past clients rave about my ability to deliver robust solutions quickly and effectively which aligns perfectly with your requirements. Let's get started on creating intuitive dashboards that add real value to your business operations!
$250 USD in 2 days
7.4
7.4

Hi there, I went through your project description and understand you need interactive financial dashboards built directly from your existing Microsoft Dynamics AX 2012 data, with reliable reconciliation and drill-down to underlying transactions. I will use Power BI as the primary reporting layer, with the AX database or appropriate analytical layer as the source depending on your environment. I will design a clean financial model covering revenue, expenses, cash-flow movements, and profit and loss, with interactive filters, KPIs, trends, and drill-through views. I will establish scheduled refresh and optimize the data model so dashboards remain responsive for everyday browser and 1080p use. Power BI can support financial-dimension analysis and transaction-level navigation when the AX data model is structured appropriately. I will validate the dashboard figures against your AX test scripts, investigate any discrepancies, and document the complete connection, refresh, deployment, and staging-to-production process for your IT team. After award, I will share a project blueprint within 24–48 hours. To scope your project clearly, I would like to ask whether your AX 2012 environment is on-premises and whether you already have an AX data warehouse or SSAS cube available? Kind Regards, Imran Ali
$70 USD in 1 day
5.9
5.9

I’d start by mapping AX 2012 financial tables, dimensions and posting logic, then build a validated SQL reporting layer rather than querying production tables directly. For the front end, I’d use SSRS or Power BI Report Server depending your existing licensing, avoiding unnecessary cloud licensing. Revenue, expenses, cash flow and P&L would reconcile back to AX with drill-through to source transactions, scheduled refresh, and documented staging/production deployment steps.
$30 USD in 7 days
5.8
5.8

Hi, SolutionzHere can turn your AX 2012 financial data into a governed Power BI solution rather than querying transactional tables blindly. We have delivered ERP analytics for revenue, expenses, cash flow, P&L, and operational drill through, helping finance teams replace spreadsheet consolidation with faster, reconciled decision making. We recommend reusing AX SSAS financial cubes where available, then building a Power BI semantic model with controlled measures, transaction drill through, and scheduled refresh through the gateway. AX 2012 provides financial cubes including General Ledger, Accounts Payable, Accounts Receivable, and Sales. Fixed estimate: $2,400 over 4–6 weeks, including reconciliation, dashboard, documentation, and staging deployment. The posted budget is too low for 100% validation and production readiness. Question: Do you already have deployed AX SSAS cubes, or should we build the model from SQL views?
$2,400 USD in 28 days
5.9
5.9

Hi, I am a BI developer with 8 years of rich experience in software development, with a background in ERP reporting and financial dashboards. I am familiar with Dynamics AX 2012, SQL Server, SSRS, Power BI, T-SQL and data visualization. I'd use SSRS since it already runs alongside AX 2012, so your team can open the dashboards in any browser with no extra licenses, and I'd connect through read-only SQL views on GeneralJournalAccountEntry, MainAccount and the dimension tables for fast loads. Revenue, expenses, cash flow and P&L get their own views with drill-through to each voucher, everything refreshes on a schedule, and I'll reconcile against your test scripts and document the setup for staging and production within a few days. 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 USD in 7 days
5.6
5.6

I’d start by mapping AX 2012’s General Ledger, customer/vendor transactions and cash accounts so revenue, expenses, cash-flow movements and P&L totals are sourced from the same balances you validate in AX. I would use SSRS with SQL-based reporting views (or existing AX cubes where appropriate), providing browser dashboards, filters, drill-through to underlying transactions, and layouts optimized for a 1080p monitor without adding Power BI licensing requirements. Within 5 days, I’ll deliver the financial dashboard set, automated refresh configuration, AX transaction drill-downs, reconciliation adjustments against your test scripts, and clear staging/production setup documentation for your IT team. Do you already have an SSRS instance connected to AX 2012, or should I include that setup? Muhammad Saad
$250 USD in 5 days
4.4
4.4

⚠️ If you're not happy, you don’t pay. ⚠️ Hi Client, thank you for checking my proposal and sharing the detailed project brief. I can build your interactive financial dashboards using Power BI with a clean, intuitive design. I will deliver: • Seamless connection to Microsoft Dynamics AX 2012 tables for real-time data access • Interactive visualizations for tracking revenue, expenses, cash flow, and profit-and-loss • Drill-down capability to view underlying AX transactions • Automatic refresh and quick load times for daily use • Comprehensive documentation for your IT team to replicate setup in staging and production You will also receive: • A training session for your team on dashboard usage and maintenance I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag Pipal
$150 USD in 14 days
4.2
4.2

Hi, I'd use SSRS, because it already comes with the SQL Server license your AX 2012 runs on. Power BI looks nicer, but sharing it in a browser needs Pro licenses for every viewer, or Report Server, which needs SQL Server Enterprise. SSRS avoids both and still gives you drill-down from each total to the actual AX transactions. For the data connection, I'd build read-only SQL views over the general ledger tables, mainly GeneralJournalEntry and GeneralJournalAccountEntry, filtered by company and partition. I'd skip the AX cubes. They're fine for trends, but they refresh on a schedule and can drift from the live balances, which makes a 100% reconciliation hard. Before building any visuals, I'll match my views against the AX trial balance using your test scripts, so the numbers are right from the start. The dashboards cover revenue, expenses, cash flow and P&L, with filters by period and company, and they load fast on a 1080p screen. Report caching keeps them quick for daily use. Your IT team gets step-by-step setup docs for staging and production. I can deliver it in about 4 days once I have read access. I've built financial dashboards on AX 2012 data similar to this, and I'm happy to walk you through them if you contact me. I can start work right away. Contact me to discuss more details. Thanks. Smit
$140 USD in 7 days
4.1
4.1

Hello, I can turn your existing Microsoft Dynamics AX 2012 financial data into clean, interactive dashboards covering revenue, expenses, cash flow, and P&L, with drill-down access to the underlying transactions. I would use Power BI with a suitable AX SQL/table or cube connection, depending on your current environment and performance requirements. I’ll first map the required financial entities and relationships, build reliable measures and reconciliation logic, then create an intuitive dashboard optimized for browser use and 1080p displays. Refreshing will be configured for practical daily use, while AX balances will be validated against your test scripts to ensure figures reconcile correctly. I’ll also document the data connection, dashboard configuration, refresh setup, and staging/production deployment steps so your internal IT team can reproduce the solution. Looking forward to work with you. Thanks
$100 USD in 2 days
4.3
4.3

Perfect Match "AX 2012 FINANCIAL DASHBOARDS" — you need revenue, expenses, cash flow, and P&L that reconcile exactly with AX while still allowing transaction-level drill-down. I’d use Power BI with a controlled AX 2012 data layer, keeping financial calculations separate from the report visuals so the numbers can be tested against your AX balances. I’d also use incremental refresh where practical and keep the transaction drill-through focused so the dashboards stay fast on 1080p screens. Can you provide the AX 2012 database structure and confirm whether direct SQL access is available? Looking forward to work with you
$140 USD in 7 days
4.0
4.0

Hi, I'd build this as a thin SQL layer first and the dashboards second: views over the AX general ledger tables (GeneralJournalEntry and GeneralJournalAccountEntry, with the main account and dimension combinations) for revenue, expenses and P&L, plus bank and customer/vendor settlement data for the cash-flow movements. Power BI then reads only those views, and every figure drills down to the voucher it came from. Before any chart exists I'd reconcile each total with your AX balances using your test scripts, per period and per main account, and ship the reconciliation sheet with the dashboards so your IT team can repeat the same check in staging and production. Do you have a read-only SQL Server login for reporting, and is the P&L layout the standard AX financial statement or a custom one?
$141 USD in 7 days
4.2
4.2

Hi there, I see you're looking to create interactive financial dashboards from your Microsoft Dynamics AX 2012 data. Using Power BI would be an excellent choice to provide the visual insights you need. I propose to establish a direct connection to the AX tables, ensuring seamless data retrieval to track key metrics like revenue, expenses, and cash flow, maintaining precision to guarantee figures reconcile perfectly with AX balances. Additionally, I'll ensure that the dashboards are optimized for display on a 1080p monitor, focusing on a user-friendly layout that allows easy drilling into AX transactions. Documentation will also be a priority to facilitate replication for your internal IT team. I can start this project right away. Regards, Ali
$90 USD in 1 day
3.7
3.7

With a robust skillset that traverses Python, C#.Net, VB.Net, WPF, Web Api Core, Blazor, Asp.net Razor Core and many more, I'm well-equipped for your AX 2012 project. While I haven't directly worked on AX 2012 dashboards before, my experience in business intelligence techniques such as SSIS, SSRS will be invaluable in extracting and transforming the core financial data you need from the existing tables or cubes in your AX environment. This expertise enables me to work with the front-end of your choice whether it's SSRS or Power BI or any other tools commonly paired with AX 2012, while ensuring smooth integration and real-time data updates.
$140 USD in 7 days
3.8
3.8

Hi, Dejan here, from Croatia. I have experience building financial dashboards from ERP/database systems where the main requirement is accurate reconciliation back to source transactions. For AX 2012, I would use Power BI with SQL views or AX cubes depending on your current setup. The focus would be fast refresh, clean financial reporting, and drill-down from summary KPIs to underlying transactions. My plan: 1) Map AX tables/cubes for revenue, expenses, cash flow, and P&L. 2) Build validated SQL views/model relationships. 3) Create interactive dashboards with drill-down and filters. 4) Reconcile all figures against AX balances and your test scripts. 5) Document setup, refresh, and deployment for staging/production. I can start right away and first review your AX schema/reporting setup before finalizing the data model. Looking forward to hearing from you, Dejan
$150 USD in 5 days
3.4
3.4

Your requirement is to transform existing AX 2012 financial data into fast, interactive dashboards that provide an at-a-glance view of Revenue, Expenses, Cash Flow, and P&L, while allowing for drill-downs to the underlying AX transactions when needed. Approach: After auditing the AX 2012 tables/cubes, I will prioritize Power BI as the primary tool, utilizing SQL/SSRS as necessary. I will design the data model, measures, and reconciliation logic to ensure figures match AX balances 100%. I will provide a solution featuring automatic refresh, responsive browser/1080p layouts, performance optimization, and transaction-level drill-down capabilities, along with full staging-to-production documentation. 1. Which version of SQL Server does the AX 2012 database use? 2. Is the Power BI environment/licensing already in place? 3. When will your test scripts and reconciliation rules be available? I will successfully deliver a production-ready financial dashboard solution focused on accuracy, performance, and maintainability.
$98 USD in 5 days
3.6
3.6

As an experienced professional with a diverse skillset, I believe I would be an excellent fit for your project to build AX 2012 dashboards. Not only am I adept at working with data and creating visualizations as evidenced by my skills in Data Analytics and Data Visualization, but I also have a deep understanding of AX2012. This includes data integration and analysis using SQL and other relevant tools. In short, I know the terrain we’re operating in, which would save both time and effort during the project. Beyond just executing the project excellently, I recognize the importance of clear documentation to enable smooth management and long-term support. With my background in project coordination and workflow documentation, you can be assured that the setup steps will be well-articulated, enabling successful replication on your staging and production environment. Finally, it’s important for me to mention my commitment to effective communication. This is essential not only throughout the course of the project but importantly in relation to training your internal IT team to fully utilize and replicate what we'll build together. By choosing me, you're making a choice towards a strong collaboration between complementary skillsets; I'm confident we'll make a great team on this project. Let's get started right away!
$140 USD in 2 days
3.4
3.4

Hi There! We specialize in turning AX 2012 financial data into fast, interactive dashboards where revenue, expenses, cash flow and P&L can be monitored and traced back to source transactions. Our team of 62 professionals with 9+ years of experience and 465+ completed projects can build this in Power BI, using AX tables or cubes with optimized SQL queries, reconciliation checks, automated refresh and drill-through reporting. We’ll document the complete connection, refresh and deployment process so your IT team can replicate it across staging and production. Would you prefer connecting directly to the AX SQL database or using your existing cubes?
$140 USD in 7 days
3.0
3.0

Hi i am an experienced Excel data analyst and insighter with PhD in data analysis .I can help you attractive dashboards, visualization, automation,optimization, numerical analysis،simulation and stock data prediction .
$120 USD in 3 days
3.2
3.2

Hi - Adelman here from Texas AX 2012 FINANCIAL DASHBOARDS - you need financial numbers that reconcile exactly with AX and still let users drill into the transactions behind them. I would use Power BI with a controlled AX data layer, keeping revenue, expenses, cash flow, and P&L measures tied directly to the AX source data. I would validate each dashboard against your test scripts before optimizing refresh and browser performance. Do you already have an AX SQL database or existing AX cubes available for the dashboard connection? Looking forward to work with you.
$100 USD in 1 day
3.0
3.0

Jeddah, Saudi Arabia
Payment method verified
Member since Jun 14, 2021
$30-250 USD
$30-250 USD
$30-250 USD
$25-50 USD
$30-250 USD
£50000-100000 GBP
₹600-1500 INR
$250-750 USD
£250-750 GBP
₹750-1250 INR / hour
€250-750 EUR
$30-250 USD
₹750-1250 INR / hour
$8-15 USD / hour
₹37500-75000 INR
$15-25 CAD / hour
$30-250 USD
$25-50 USD / hour
$250-750 USD
$5000-10000 USD
₹1500-12500 INR
$30-250 CAD
₹37500-75000 INR
₹12500-37500 INR
$250-750 USD