Analytics
Reporting, Power BI, SSRS and other analytics
-
12 Ways To Rewrite SQL Queries for Better Performance
https://www.sqlservercentral.com/blogs/12-ways-to-rewrite-sql-queries-for-better-performance more
-
Connect Python to SQL
https://datascienceplus.com/connect-python-to-sql/ more
-
Power BI Sample Client Angular Embedded on Github
http://azure-samples.github.io/powerbi-angular-client/#/scenario1
-
Power BI Custom Function
https://radacad.com/custom-functions-made-easy-in-power-bi-desktop more
-
Displaying percentage of total for multiple legend
https://community.powerbi.com/t5/Desktop/Displaying-percentage-of-total-for-multiple-legends-in-a/td-p/155165 more
-
Advanced DAX - Show Percentage Sales Per Custom Group Each Year In Power BI
https://www.youtube.com/watch?v=knF3VbCkRig
-
Power BI Dynamic Date Range from Slicer
https://radacad.com/dynamic-date-range-from-slicer
-
Power BI: DAX IF and FILTER Statements
https://radacad.com/if-and-filter-are-different-be-careful-dax more
-
Power BI: DAX Error Messages
https://www.sqlbi.com/articles/dax-error-messages-in-power-bi/ more
-
Power BI Row Level Security (RLS)
https://docs.microsoft.com/en-us/power-bi/service-admin-rls more