question

Subhankar1000 avatar image
Subhankar1000 asked

What are the usage of SQL in construction companies?

I need ideas to build a project in a construction company based around Microsoft's Business Intelligence technology.
sqlmsbiproject
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

And in gatering ideas, do you already have _any_ idea what the project goals might be?
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
SQL Server is used the same way in a construction company as it is in an insurance company, a manufacturing company, a bank, book store, church, or any other location. SQL Server itself is a relational storage engine for keeping and retrieving data that is stored in a normalized set of relationships. Secondary tooling includes the ability to store and retrieve data in Cubes, SQL Server Analysis Services (SSAS), build fancy reports for displaying data, SQL Server Reporting Services (SSRS), and an extract/transform/load (ETL) engine called SQL Server Integration Services (SSIS). These tools are fundamental building blocks for businesses to manage data. There's nothing in or about the tool itself that would be different from one organization to the next. Instead, it's the things stored inside of it that are different. That's where you need to focus. Based on what you've asked, I can't make a single suggestion.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wicksroofing avatar image
wicksroofing answered

Grant, Sounds like you know a bit about creating and managing databases. Im a medium business doing many processes redundantly. Estimating through excel, proposals and templates through word, Job numbers and info through excel, scheduling through excel, call logs excel. I need to simply the process. Right now the info is in files on sharedrive. Info is entered multiple times and sometimes difficult to find. Lots of coordination needed in upper level management to keep everything straight. Thinking a Relational Database and management system is what we need...but something that we can keep as excel?

Highjacking the thread but havent found much info on the topic. Thanks in advance

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hello,

So you have two options to clean up this sort of situation. One, you build something for your organization. This solution means you can get exactly what you want, tailored to your org, However, it can be time consuming and expensive, especially if you don't have programming skills in-house and need to either hire them, or find a good consulting company. The second option would be to go do a service like SalesForce. Here you get a software that's already configured and under active development, so the costs are quite a bit less. However, you don't get as much in the way of customization. For most organizations that don't already have IT infrastructure in place to support active development, I suggest going with the service approach (Salesforce or equivalent). You won't get everything exactly the way you want, but the costs and ramp up time will be less. I hope this helps a little.

1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.