Create CSV file
For tab delimited… For tab delimited and exact position…
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
BI Scorecards
Whereas a dashboard informs users what they are doing, a scorecard tells them how well they are doing. In other words, a dashboard records performance while a scorecard charts progress. In short, a dashboard is a performance monitoring system, whereas a scorecard is a performance management system. Scorecards offer organizations a snapshot of their current performance when compared to their goals. They are useful tools... » read more
BI Dashboards
A dashboard is a visual display of the most important information needed to achieve one or more objectives that has been consolidated on a single computer screen so it can be monitored at a glance. Dashboards often provide at-a-glance views of key performance indicators relevant to a particular objective or business process. A dashboard’s objective... » read more
Tableau Products
Tableau Desktop Stand-alone. Called “the gold standard” in visual analytics, Tableau Desktop upended the business intelligence industry and ushered in a new paradigm of self-service insight. Tableau Prep Builder: Prepare your data for analysis Confidently combine, shape, and clean your data with Tableau Prep Builder. Tableau Prep empowers more people to get to analysis faster by... » read more