Microsoft Power BI vs Tableau

Power BI Tableau Cost Power BI Pro: $9.99/monthPower BI Premium: $4,995/month Tableau Creator: $70/month Desktop Yes, Free Yes, Free for Students Cloud Yes, Power BI Pro Yes, Tableau Online On-Premises Yes, Power BI Premium Yes, Tableau Server Embedded Yes, Power BI Embedded Yes, Tableau Embedded Analytics

Installing FTP on Windows Desktop

On Windows Desktop (Windows 10, Windows 8, Windows 7 and Windows Vista) Go to Control Panel > Programs > Program and Features > Turn Windows features on or off. On a Windows Features window: Expand Internet Information Services > FTP Server and check FTP Service. Expand Internet Information Services > Web Management Tools and check IIS Management Console, if it is not checked yet.... » read more

BI – Business Intelligence

Business intelligence, or BI, is a decision support system. Its aim is to help make business decisions, strategic as well as operational/tactical. Business intelligence is viewed differently by the two groups that use it—business and IT. While IT usually views it as a tool, business views it as information. Concepts and methods to improve business... » read more

SQL Profiler

File Folder Location: PROFILER.EXE C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\ Running under a different domain… If you create a cmd file, you might need to copy over the cmd file to the profiler directory and run it from there. To filter to only Stored Procedures… Events -> Check... » read more

Run SSMS Under A Different Domain

SQL Server Management Studio interface will prevent you from using domain other than the one you are currently login as. To use another domain, use a .bat file runas. SSMS 17 SSMS 18 Profiler

Good BI Dashboard Design

1. The 5 Second Rule Your dashboard should provide the relevant information in about 5 seconds. Your dashboard should be able to answer your most frequently asked business questions at a glance. This means that if you’re scanning for the information for minutes, this could indicate a problem with your dashboard’s visual layout. When designing... » read more