Generated by All in One SEO v5.0.0.1, this is an llms.txt file, used by LLMs to index the site. # Automation and Insight Your Strategic Partner for Healthcare Analytics ## Sitemaps - [XML Sitemap](https://www.automationandinsight.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Case Study: Healthcare – Carevoyance](https://www.automationandinsight.com/index.php/2021/04/21/2826/) - Case Study: Healthcare - Carevoyance Power BI for Medical Device Sales Patient Demographics and Market Analysis over billions of medicare claims. Get Insight! The Challenge Our client created an algorithm that identifies with a high level of accuracy what patients who had spine surgery will deal with disc reherniation. The client needed a custom data-based - [The Story of Jim](https://www.automationandinsight.com/index.php/2020/08/20/the-story-of-jim/) - Jim was the busy COO of a software firm in Manhattan. His morning usually started around 7AM with a request from the CEO for updated profitability and utilization numbers ASAP. While brushing his teeth, he sent an email to the controller who informed him that finance is behind on last month’s financial statements and cannot - [Power BI Export Limitations - Part 3/4](https://www.automationandinsight.com/index.php/2020/05/04/power-bi-export-limitations-part-3/) - "It's time to find out if we can 'jailbreak' Power BI" In part 1 and part 2 of this series I discussed how Power BI does not meet my clients stated requirements, of being able to download all of the underlying data, with totals regardless of size limits. In this final part I am going - [Power BI Export Limitations - Part 4/4](https://www.automationandinsight.com/index.php/2020/07/13/power-bi-export-limitations-part-4-4/) - "I fought Power BI and Power BI won." In parts 1-3 of this series I reviewed the great lengths I went through to try to make Power BI do something that a user would expect in 2020 as an out of the box feature, namely export a meaningful amount of data from a visualization, into - [Power BI Export Limitations - Part 2/4](https://www.automationandinsight.com/index.php/2020/04/24/power-bi-export-limitations-part-2/) - "Surely the API supports unlimited exports and totals. We'll just write a helper service leveraging the API" Nope. The Power BI REST API is not designed to allow you to get at your data directly. The API is really designed to help automate Power BI dev-ops functions, not for access to data. "No problem," I - [Power BI Export Limitations - Part 1/4](https://www.automationandinsight.com/index.php/2020/04/07/power-bi-export-woes/) - "We want to be able to export an unlimited number of rows from PowerBI from any filtered report, retaining aggregations and totals without the need for a developer to assist." My heart sank a bit as I heard the request from my new client, a New York City municipal service. I was hoping to leverage ## Pages - [Home](https://www.automationandinsight.com/) - [Privacy Policy](https://www.automationandinsight.com/index.php/privacy-policy/) - PRIVACY NOTICELast updated September 03, 2020Thank you for choosing to be part of our community at Automation and Insight LLC (“Company”, “we”, “us”, or “our”). We are committed to protecting your personal information and your right to privacy. If you have any questions or concerns about this privacy notice, or our practices with regards to - [About](https://www.automationandinsight.com/index.php/about/) - View my LinkedIn profile. Automation and Insight (A&I) was founded in 2020 by James Raddock who was a partner at DOOR3. James founded A&I in response to the rising need for cutting-edge analytics on top of low-code solutions. A&I is dedicated to providing top-notch healthcare analytics for our customers. We have customers on both coasts - [Real World Data Analysis](https://www.automationandinsight.com/index.php/real-world-data-analysis/) - Billions of Claims - One Truth We have the experience to boil that Ocean We speak healthcare. Whether its a simple demographic study or a complex windowed analysis across billions of claims, we have you covered! Get Insight! In the dynamic landscape of healthcare, understanding data is paramount. Our Real World Data Analysis Service offers - [Custom Open Dental Development](https://www.automationandinsight.com/index.php/custom-opendental-development/) - Unleash your PMS data Open Dental Development for DSOs+ We consolidate data across offices and give you true picture of your business. Get Insight! Leverage our years of experience in custom Open Dental development that transforms your dental software into a powerful tool tailored specifically for your practice needs. Whether you're managing a multi-office DSO - [Our Services](https://www.automationandinsight.com/index.php/services/) - Open Dental Development Custom data warehousing, mobile and desktop Power Apps and Power BI reporting for multi-practice OpenDental groups. Real World Data Analysis Bring your own data source or work with our partners. We do full longitudinal data studies of billions of rows of medical and pharma claims data. Technical Services Attribution is tricky, even - [Contact](https://www.automationandinsight.com/index.php/contact/) - Get in Touch We'd love to hear more about how we can help out with your data needs. Please book a meeting with us below and let's chat. - [Reporting Services (SSRS) - Finance Attribution](https://www.automationandinsight.com/index.php/reporting-services-ssrs-finance-attribution/) - Unlock the Potential of your data. Reporting Services for Finance Attribution Are you stuck with a mess of spreadsheets, databases and reporting solutions that don't work well together? GET INSIGHT! Step 1 - Free Consultation After your initial call to us, we will set up a follow up to review the current state of your - [Power BI - Finance Attribution](https://www.automationandinsight.com/index.php/power-bi-finance-attribution/) - Unlock the Potential of your data. Power BI for Finance Attribution Are you stuck with a mess of spreadsheets, databases and reporting solutions that don't work well together? Get Insight! Step 1 - Free Consultation After your initial call to us, we will set up a follow up to review the current state of your - [ETL & ELT Services](https://www.automationandinsight.com/index.php/etl-elt-services/) - Transform Your Data Pipe your data from the source to your warehouse Produce reliable data pipelines for your users with our ETL and ELT solutions. AUTOMATE Step 1 - Free Consultation After your initial call to us, we will set up a follow up to review the current state of your data. During this call - [Convert - SSRS to Power BI](https://www.automationandinsight.com/index.php/convert-ssrs-to-power-bi/) - Unlock the Potential of your data. SSRS for Finance Attribution Are you stuck with a mess of spreadsheets, databases and reporting solutions that don't work well together? Get Insight! Step 1 - Free Consultation After your initial call to us, we will set up a follow up to review the current state of your data. - [Slide Anything Popup Preview](https://www.automationandinsight.com/index.php/slide-anything-popup-preview/) - [Blog](https://www.automationandinsight.com/index.php/blog/) - [Form submission thank you](https://www.automationandinsight.com/index.php/form-submission-thank-you/) - Thank you for submitting our contact form. We will be in touch with you shortly. ## Categories - [Power BI](https://www.automationandinsight.com/index.php/category/power-bi/) - [General](https://www.automationandinsight.com/index.php/category/general/) - [Case Study](https://www.automationandinsight.com/index.php/category/case-study/) - [Vertical](https://www.automationandinsight.com/index.php/category/vertical/) - [Real World Data Analysis](https://www.automationandinsight.com/index.php/category/vertical/rwd/)