💰Cost analysis

Money savings

Company A and Company B have different approaches to creating and distributing reports for their consumers. Company A has chosen to use PowerBI, a cloud-based business intelligence and data visualization platform, while Company B has chosen to use SSRS (SQL Server Reporting Services) and TheRDL, a tool within the SQLKiss suite. PowerBI Premium price per user per month is USD 9.99 or 50*$9.99*12(m) = $5994 USD per year SSRS is an add-on to SQL Server Standard = $1418 USD per year Which means Company B saves 76% on licensing plus they have better scalability with SSRS+TheRDL with number of report consumers. It appears that Company B may be able to save up to 76% on licensing costs by using SSRS and TheRDL instead of PowerBI. This is because PowerBI has a per-user monthly fee, while SSRS is typically included with a SQL Server license and can be administered as a component of the server. Additionally, it seems that Company B may be able to save up to 100% on the cost of setting up a reporting server by using TheRDL, as it can be installed as an add-on to an existing SQL Server.

It's worth noting that while cost is an important factor to consider when choosing a reporting solution, there are other factors that may also be important, such as the features and capabilities of the platform, the level of support and resources available, and the needs and preferences of the report consumers. It's important for both companies to carefully evaluate their options and choose a solution that meets their specific needs and budget.

Developers time (which is also money) savings

John is a SQL developer who has been asked to create a new report that follows the company's layout standards and includes a new set of data. Without TheRDL, John estimates that it would take him 2 hours to develop and test the SQL query that retrieves the data and 8 hours to develop and test the RDL (SQL Server Reporting Services layout) for the report.

With TheRDL, John may be able to save 80% of his time and eliminate the stress of aligning the layout, as TheRDL provides a pre-designed layout that follows the company's standards. This would allow John to focus on the SQL side of the report development and testing, which would likely be more efficient and streamline the overall process.

TheRDL could be a valuable tool for John and other SQL developers who need to create reports using SSRS and want to save time and simplify the layout process.

Company also benefits

It's true that the SQL community is quite large and there are many highly skilled developers with SQL knowledge. This can be beneficial for companies that are looking to hire developers, as it gives them a wide pool of candidates to choose from and the ability to find developers with the specific skills and experience they need. It can also be helpful for developers who are looking for job opportunities, as there are many companies that use SQL and may be looking for professionals with SQL skills.

Additionally, the fact that there are many developers with SQL knowledge can make it easier for companies to upskill their existing workforce, as there are likely to be many resources and training materials available to help employees learn and develop their SQL skills. This can be a more cost-effective and time-efficient way to improve the technical capabilities of the workforce, rather than having to hire new employees with the desired skills. No need to up-skill your existing workforce, they're already ready.