MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on October 30th, Tuesday at 6:30 PM at the Microsoft office in Alpharetta. Neal Waterstreet will tackle the important and pervasive issue of bad data quality. ZAP BI will sponsor the event. And your humble correspondent will introduce you to Power BI Home and data profiling. For more details, visit our…
Read article
Want to know what Power BI features are in the works and when they will be released? My "Power BI Features Report" showed you how to find what features were released over time so it's retrospective. On the other hand, Business Applications Release Notes are forward looking. For example, the October release notes for BI go all the way to March 2019. The release notes…
Read article
What's the first thing that comes to mind when you hear "linked server"? Performance issues or a snail image, right? Many developers don't like linked servers because they are "slow" although they rarely bother to investigate the underling issue, much less to fix it. Linked servers are a very useful and commonly used feature of SQL Server. They allow SQL Server to query external data…
Read article
You know it and I know it. Data quality is a BIG problem that reduces the business value of BI. ETL practitioners will probably recall that SSIS includes a comprehensive Data Profiling Task but it is somewhat difficult to set up, especially if you wanted to profile multiple tables. It saves the results in an xml file and then you could use the Data Profile…
Read article
What tool do you use for Analysis Services Tabular development? SSDT right, what else? Here is a little secret. I almost don't use SSDT anymore, except for limited tasks, such as importing new tables and visualizing relationships. I switched to a great community tool – Tabular Editor and you should too if you're frustrated with the SSDT Tabular Designer. Back in 2012 Microsoft ported the…
Read article
Microsoft introduced Azure Data Factory (ADF) in 2015 to handle a specific scenario: tumbling window loads for Hadoop and other big data systems for internal MS usage. Then a need arose for a PaaS public-facing data integration platform which led to an interesting dilemma: SSIS or something else? Since SSIS wasn't designed to scale out in the cloud, ADF rose to the challenge. I could…
Read article
