
Closed
Posted
Paid on delivery
Hi, I'm building a finance semantic model in SQL Server Analysis Services (Tabular) using Visual Studio, with data coming from SAP (journal entries, GL accounts, cost centers, etc.). I'm looking for an experienced freelancer to guide and support me while I build it myself. Important: I am not looking for someone to build the model for me. I want to do the work hands-on and learn along the way, with you reviewing, explaining, and helping me when I get stuck. What I need help with: - Setting up calculation groups for the first time (compatibility level, model settings) - Scenario: Actual, Budget, Projection, Last Year - Currency: Transaction, Local, and Group currency (already converted in SAP, stored as separate columns) - Time Intelligence: Period, YTD, Full Year - Variance: Actual vs. Budget / Projection / Last Year, Projection vs. Budget, FY variance (absolute and %) - Precedence, format string expressions, and testing the results - Reviewing my DAX and model design and suggesting best practices How I'd like to work: - Remote screen-sharing sessions (Teams or Zoom), roughly 1-2 hours at a time - Q&A support between sessions via chat or email - Estimated effort: [5hours/ weeks] What I'm looking for: - Proven experience with SSAS Tabular / Azure Analysis Services and advanced DAX - Hands-on experience with calculation groups (Visual Studio and/or Tabular Editor) - Finance / SAP reporting background is a strong plus - Patient and clear at explanation Thank you!
Project ID: 40731201
10 proposals
Remote project
Active 6 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
10 freelancers are bidding on average ₹7,697 INR for this job

Hello Sir, I have already worked on similar types of website and software development projects and I am confident that I can successfully handle your project. I am a full-time freelancer with **17+ years of experience** in web development, software development, automation, and API integrations. My expertise includes: * ASP.NET C# web and software development * Android app development * Python automation and web scraping (Amazon, Instagram, Facebook, Google Maps, LinkedIn, Telegram, and other custom scraping solutions) * JavaScript, jQuery, AJAX, Bootstrap, HTML5 * Microsoft SQL Server database development * Payment gateway integration * SMS, Email, Banking, Financial, and Insurance API integration * Custom automation bots and workflow automation software I focus on delivering **high-quality, scalable, and reliable solutions** with clean code and long-term support. Please contact me in private chat so we can discuss your requirements in detail. I can also show you a **demo of similar projects** I have completed. Looking forward to working with you. Thanks & Regards
₹12,500 INR in 8 days
5.6
5.6

Guiding you through your SSAS Tabular finance model while you build the DAX and structure calculation groups yourself is a solid approach to mastering the architecture. ✅ Hands-on screen-sharing sessions covering calculation group configuration, evaluation precedence, dynamic format strings, and multi-scenario time-intelligence DAX (Actual vs Budget vs Projection, YTD, FY) ✅ Review of your SAP GL and cost center schema, currency handling, and relationship cardinality to prevent filter context pitfalls and optimize engine performance ✅ Model backup workflows and Tabular Editor metadata script exports prior to committing compatibility level or calculation item changes ✅ 10+ years production experience | 400+ completed projects | 320+ five-star reviews ✅ Microsoft® Certified: MCSA | MCSE | MCT & cPanel Certified (CWSA-2) Are you targeting SSAS on-premises (compatibility level 1500+) or Azure AS / Fabric, and do you already have Tabular Editor integrated into your Visual Studio environment? I can deliver this in 1 day for 8900 INR and can jump on it right now.
₹8,900 INR in 1 day
3.8
3.8

As a well-versed Chartered Accountant with a decade's worth of experience in finance and accounting, I am incredibly familiar with the intricacies of SQL Server Analysis Services (Tabular), especially in terms of designing finance semantic models. I can bring this expertise to guide you through the setup of calculation groups, time intelligence, scenario variances, precedent considerations and more that your project demands. My extensive hands-on experience in Azure Analysis Services and advanced DAX combined with my keen knowledge of accounting platforms like QuickBooks Online and Xero put me in an optimal position to assist you with your specific finance project. Being patient and clear is my forte, which means our remote screen-sharing sessions will be efficient and effective, bringing you closer to mastering SSAS Tabular and DAX calculations. Additionally, I have substantial experience working with clients using SAP reporting across different regions such as the US, UK, Australia, UAE, and India. This familiarity with SAP will provide valuable insights into your project that may otherwise go unnoticed, setting me apart from others. My approach is centered around empowering clients as opposed to solely completing tasks—this aligns perfectly with your vision for wanting hands-on guidance without sacrificing learning. Choose me for an engaged walkthrough ensuring not only a successful outcome but also improved skills for future projects.
₹12,000 INR in 3 days
0.0
0.0

Hi, I’m Mikhail. I’m an experienced digital professional with a strong background in web development, AI solutions, automation, digital marketing, and creative production. I’ve reviewed your project, and I understand that you want guidance while you build a finance semantic model in SQL Server Analysis Services. I appreciate your hands-on approach and aim to ensure you learn effectively throughout the process. My experience with SSAS Tabular and advanced DAX, along with a solid finance background, positions me well to support you. I can assist with setting up calculation groups, handling currency conversions, and implementing time intelligence measures. I’m patient and committed to explaining concepts clearly, ensuring you feel confident in your understanding. I’m comfortable with remote screen-sharing sessions and can provide Q&A support between our meetings. Let’s discuss your requirements further and get started on building your model together.
₹6,250 INR in 7 days
0.0
0.0

⚡ MOST FREELANCERS WILL TELL YOU WHAT THEY CAN DO. I’LL SHOW YOU WHAT I’VE ALREADY DONE In a recent project, I guided a client through building a finance model in SSAS Tabular, focusing on DAX calculations for budget variance analysis. This hands-on approach resulted in a model that improved reporting efficiency by 30%, while my client felt empowered and confident in using the tools. I have over five years of experience with SSAS Tabular and DAX, as well as a strong finance background. My expertise includes setting up calculation groups and implementing best practices, ensuring that you not only learn but also build a robust model. I understand your goal is to develop your skills while creating a functional finance model. I will support you through screen-sharing sessions, providing clear explanations and timely feedback on your DAX and model design. I am committed to helping you achieve your objectives with effective communication and a focus on your long-term success. Let’s turn your vision into reality together. The difference between an average result and an exceptional one is usually decided before the work even begins. Regards, luan
₹6,250 INR in 7 days
0.0
0.0

Hi, I understand you're looking to build a finance semantic model in SQL Server Analysis Services while gaining hands-on experience. It’s great that you want to take an active role in this process. I have extensive experience with SSAS Tabular and advanced DAX, particularly in setting up calculation groups and handling complex scenarios like budgeting and time intelligence. I can guide you through each step, ensuring you understand the concepts, especially around variance calculations and best practices for DAX. Let’s connect and discuss how I can support you effectively. The worst that could happen is you get a free consultation from me about your project. Regards, Maanie
₹5,650 INR in 7 days
0.0
0.0

Two things bite almost everyone the first time they build calculation groups, and both are worth knowing before session one. Precedence. Once you have more than one calculation group, scenario and time intelligence in your case, the higher precedence one applies first. Get it the wrong way round and YTD of Budget quietly returns Actual YTD, or a variance reads as the plain measure. Nothing errors. The numbers just look plausible and are wrong, which is the worst failure mode there is in a finance model. Format strings. A variance percentage inside a calculation group inherits the base measure's currency format unless you write a format string expression on that calculation item, so you end up with something like 0.07 in rupees where you wanted 7%. The order I'd suggest for your model: scenario first, then currency as its own group over your three stored columns, then time intelligence, then variances last, testing each item against a month you have worked out by hand before moving on. Since you want to build it yourself, I'd keep the sessions to screen-share reviews and answer questions between them. Which version of Analysis Services are you on, and are you using Tabular Editor alongside Visual Studio? Ronak
₹6,500 INR in 14 days
0.0
0.0

Bengaluru, India
Member since Sep 24, 2026
₹12500-37500 INR
£10-20 GBP
₹1500-12500 INR
₹1500-12500 INR
₹600-1500 INR
₹1500-12500 INR
$30-250 SGD
₹600-1500 INR
₹12500-37500 INR
$250-750 USD
₹400-750 INR / hour
₹12500-37500 INR
$30-250 USD