Analytics
Reporting, Power BI, SSRS and other analytics
-
Slicers in Power BI
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers more
-
Power BI - Passing Slicer Selections into a SQL Query
https://www.youtube.com/watch?v=3QiTBXfxzHA more
-
Power BI Dynamic Calculations
https://spr.com/powerbi-dynamic-calculations/ more
-
PowerBI Show/Hide Column Based on Slicer Value
https://stackoverflow.com/questions/52839914/powerbi-show-hide-column-based-on-slicer-value more
-
Power BI: Filters Not Yet Implemented and Slicers
https://community.powerbi.com/t5/Desktop/How-to-add-a-filter-on-report/td-p/110904
-
Power BI Performance Best Practices
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance#deep-dive-into-query-performance-with-sql-profiler-and-power-bi-desktop more
-
How to learn DAX
https://www.sqlbi.com/guides/dax/
https://support.office.com/en-us/article/quickstart-learn-dax-basics-in-30-minutes-51744643-c2a5-436a-bdf6-c895762bec1a
https://docs.microsoft.com/en-us/power-bi/ … more
-
Basics of M: Power Query Formula Language
http://radacad.com/basics-of-m-power-query-formula-language
https://www.mssqltips.com/sqlservertip/4043/introduction-to-the-power-bi-desktop-and-the-m-language/
https://docs.microsoft.com/en-us/ … more
-
Power BI Tutorial Sample Files
https://github.com/Microsoft/powerbi-desktop-samples/tree/master/2018 more
-
Install Corrplot Package for R Studio
Install Microsoft R Open from https://mran.revolutionanalytics.com/download
then from the console type:
install.packages("corrplot")
Also see this for further info: https://docs.microsoft.com/en- … more