<div>
<blockquote>my client has an SSPS database</blockquote>Assuming that you perform work on behalf of your client I believe that your client should provide you the details about that "SSPS database" and how to connect to it. As far as its name I believe there is no "SSPS database" engine other than maybe the "Shared Socioeconomic Pathways (<em>SSPs</em>) Literature <em>Database</em> " as noted here <a href="https://data.nasa.gov/dataset/Shared-Socioeconomic-Pathways-SSPs-Literature-Data/ynqs-7qms" rel="ugc">https://data.nasa.gov/dataset/Shared-Socioeconomic-Pathways-SSPs-Literature-Data/ynqs-7qms</a>.<br>If this was rather a typo and in fact it that database would be rather a "SSAS database" then indeed Power BI is the Microsoft tool that can be used to access the cubes from the SSAS database as described here: <a href="https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data" rel="ugc">https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data</a>
</div>


> my client has an SSPS database

Assuming that you perform work on behalf of your client I believe that your client should provide you the details about that "SSPS database" and how to connect to it. As far as its name I believe there is no "SSPS database" engine other than maybe the "Shared Socioeconomic Pathways (SSPs) Literature Database " as noted here https://data.nasa.gov/dataset/Shared-Socioeconomic-Pathways-SSPs-Literature-Data/ynqs-7qms [https://data.nasa.gov/dataset/Shared-Socioeconomic-Pathways-SSPs-Literature-Data/ynqs-7qms].
If this was rather a typo and in fact it that database would be rather a "SSAS database" then indeed Power BI is the Microsoft tool that can be used to access the cubes from the SSAS database as described here: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data [https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data]

al4629740

<div>
<div class="content wysiwyg-content fr-view">
Apparantly my client has an SSPS database which I am unfamiliar with. &nbsp;I'm used to SQL and Access. &nbsp;The problem is that we can't get any meaningful stats from the database and the boss recommended that we use Power BI to access the SSPS database to read it better. &nbsp;Can anyone provide any background on SSPS and what kind of database this is and what would be the best way to run stats or queries on such a database?<br><br><br>
</div>
</div>



Apparantly my client has an SSPS database which I am unfamiliar with.  I'm used to SQL and Access.  The problem is that we can't get any meaningful stats from the database and the boss recommended that we use Power BI to access the SSPS database to read it better.  Can anyone provide any background on SSPS and what kind of database this is and what would be the best way to run stats or queries on such a database?

Database analytics question SSPS

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.