Happy Holidays! I hope you're enjoying this special time of the year. A few months ago, I did an assessment for a large company that was advised by an undisclosed source that they should use their Dynamics Financials and Operations (F&O) system as a data warehouse. Recently, I came across a similar wish but this time to use SAP as EDW. Can we do this?…
Read article
Bring your data to life today and learn how Power BI changes the way everyone gains insights from data. Publication date: 1/1/2020 Size: 528 pages, 7.5" x 9.25" Price: $49.99 ISBN 10: 1-7330461-1-9 ISBN 13: 978-1-7330461-1-4 Introduces information workers, data analysts, IT pros, and developers to Microsoft Power BI — a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone, making it free…
Read article
Organized by Microsoft and Dynamic Communities, the Power Platform World Tour will take a place in Atlanta from 2/10-2/12, 2020. I'm teaching Power BI Dashboard in a Day (DIAD) on Feb 10 for a full day. Although this is a paid event ($599), you should get a great business value as the audience will probably be smaller and I'll be able to provide more personal…
Read article
Power BI incremental refresh (a Power BI Premium feature) refreshes a subset of a table with imported data. The main goal is to reduce the refresh time so that new data becomes available online faster. Patrick LeBlanc has a great video about how to make the incremental refresh even more incremental by using the "Detect data changes" feature and he explains in detail how it…
Read article
A few months ago, I did an assessment for a large company that was advised by an undisclosed source that they should use their Dynamics Financials and Operations (F&O) system as a data warehouse. Recently, I came across a similar wish to use SAP as a data warehouse. I understand that people want to do more with less and shortcuts are tempting. But ERP systems…
Read article
Load testing and troubleshooting Analysis Services often requires capturing a query trace. The lightweight option to do so is to create an Extended Events (xEvents) session. Let's say you want to capture all query traffic for 24 hours. You might opt to use the SQL Server Profiler, but it's implemented as a desktop app (there must be an active Windows session but what happens if…
Read article
