Organize Your DAX Measures in Power BI
Oct 12,
2021
Like many others, I wrote my first DAX measures in Excel Power Pivot. It seemed so natural to add measures in the editing area associated with the fact table I never considered any other way. But while measures specify one or more tables in their code definition, there is really no restriction on “where” they […]
Curing Python Envy with ML.Net
,
2021
Curing Python Envy with ML.Net In early May 2019, Microsoft released ML.Net 1.0, marking the graduation of ML.Net from research project to Release Candidate. In contrast with many machine learning platforms, which usually provide a Python API, ML.Net, as its name suggests, provides a direct interface for code targeting .Net core, whether written in C#, […]
Is IPv6 Less Secure Without NAT?
,
2021
NAT (Network Address Translation) is an IPv4 tool that is not used in most IPv6 deployments. This has caused some users to ask whether IPv6 is as secure as IPv4. What is NAT? NAT is a tool that allows multiple computers behind an Internet connection to share the single address of that connection. Thus, if […]
Pasting Datetime Data into Excel Workbooks
,
2021
During a coffee break at a recent Learning Tree course, Excel Data Analysis Training, June C. commented that when she pasted results from the SQL Server Management Studio into Excel “weird things happened.” Well, June, it's actually not weird, but I definitely know what you are talking about. Microsoft Excel and Microsoft SQL Server have […]
Using a Pandas Andrews Curve Plot for Multidimensional Data
,
2021
Who doesn’t love a scatterplot? Clear and informative, the scatterplot is often one of the very first plots used when starting an exploratory data analysis. Unfortunately, scatterplots are limited to two dimensions, three if you’re using a package that supports 3D plots. This means we can look at the relationships between different columns of data […]