<div>
I had gone through your other thread as well. Somehow, I am just not been able to understand the requirement here. &nbsp;Could you please try to explain this in bit more depth? <br />
<br />
You have one db. Db has several tables. Tables have several columns. Now...?<br />
<br />
Please show some short example with data may be, which would cover scenarios.<br />
<br />
You open for solution outside SQL Server? May be a C# console / windows forms application?
</div>


I had gone through your other thread as well. Somehow, I am just not been able to understand the requirement here.  Could you please try to explain this in bit more depth?

You have one db. Db has several tables. Tables have several columns. Now...?

Please show some short example with data may be, which would cover scenarios.

You open for solution outside SQL Server? May be a C# console / windows forms application?

<div>
<div class="content wysiwyg-content">
Hi, <br />
I need to analyse database and know how many records by fields and percentage of it or percentage of records vs blank. <br />
Important thinhs, this db has one table with 250 fields.<br />
<br />
I started with PowerPivot, I then jumped on PowerBi and I just heard that tableau was easier and more accessible for business at the end.<br />
Im a bit lost. What would you reckon ? <br />
Thanks a lotfor your help
</div>
</div>


Hi, 
I need to analyse database and know how many records by fields and percentage of it or percentage of records vs blank. 
Important thinhs, this db has one table with 250 fields.

I started with PowerPivot, I then jumped on PowerBi and I just heard that tableau was easier and more accessible for business at the end.
Im a bit lost. What would you reckon ? 
Thanks a lotfor your help

Analyse on dbsqlserver having 250 fields (arcGis) on fields used and percentage of values

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Analytics is the discovery and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Specifically, areas within analytics include predictive analytics, prescriptive analytics, enterprise decision management, retail analytics, store assortment and stock-keeping unit optimization, marketing optimization and marketing mix modeling, web analytics, sales force sizing and optimization, price and promotion modeling, predictive science, credit risk analysis, and fraud analytics.