Forum Discussion
SSIS/ SSRS/SSAS confusions
Hi capricon ,
I'am sorry, each tool can be adapted to different situations, depending on the type of report the user wants to create, etc.
To SSIS: SSIS you need to use other tools to use, for example: SSMS.
To SSRS: SSRS allows the creation of paged reports (traditional tabular reports) and Power BI reports (interactive visualizations). If you want to analyze data , you can choose to download power bi desktop(RS).
To SSAS: Power BI Desktop can connect to SSAS models.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi capricon ,
MS Report Builder:
MS Report Builder is a powerful tool for creating paged reports, also known as SQL Server Reporting Services (SSRS) reports. It allows you to design and publish reports that can be accessed through a web portal or exported to various formats (PDF, Excel, etc.).
MS SQL Server Mobile Report Publisher:
- SQL Server Mobile Report Publisher is used to create mobile reports specifically designed for viewing on smaller screens (e.g., mobile devices).
- You can connect to various data sources and create mobile reports with adjustable grid rows, columns, and flexible elements.
- However, this tool is also deprecated starting in SQL Server 2022 and Power BI Report Server
- If you’re interested in mobile reports, consider exploring other options like Power BI mobile reports.
If you want to practice SSRS,SSIS and SSAS alongside Power BI , Power BI desktop is your go-to tool.
Start with Power BI Desktop since it covers a wide range of scenarios, including interactive visualizations, data modeling, and connecting to various data sources.
For paginated reports, use Power BI Report Builder (for Power BI service) or explore other modern alternatives.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous thanks for reply
so u mean for SSIS/ SSRS/ SSAS i can use power bi desktop version ? and sql server database ? right ?
Hi capricon ,
I'am sorry, each tool can be adapted to different situations, depending on the type of report the user wants to create, etc.
To SSIS: SSIS you need to use other tools to use, for example: SSMS.
To SSRS: SSRS allows the creation of paged reports (traditional tabular reports) and Power BI reports (interactive visualizations). If you want to analyze data , you can choose to download power bi desktop(RS).
To SSAS: Power BI Desktop can connect to SSAS models.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.