Results 1 to 3 of 3

Thread: Choosing DB solution for a Team without any IT knowledge

  1. #1
    Join Date
    Jan 2020
    Posts
    1

    Choosing DB solution for a Team without any IT knowledge

    Hi,

    I am working to create a DB solution retrieving information based on 3 criterias: Region, Product-code and application.
    The initial idea was to store the information using SQL and then create a UI frontpage, where the user should be able to "look up" information filling in 2/3 criterias or 3/3. If 2/3 criterias are selected, the the user should be presented to a list of the 3rd criteria available based on the 2/3 criterias. If 3/3 criterias are chosen then only 1 information shall be delivered.

    We have now been talking to a lot of people, who are recommending either just using Excel or PowerBI.

    We are looking to expand the data through time. At the moment we have 10.000 rows and 11 columns of information. We might end up with 100.000 rows times 11 columns.
    Initially we are only going to use it in house and are looking at multiple users at the same time. In total we might have 100-200 users.

    I hope you can advise me on whether to use PowerBI or SQL Server?

    //DKOG

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,923
    SQLExpress may be enough to manage data that size.

  3. #3
    Join Date
    Jan 2020
    Location
    Texas
    Posts
    1
    Microsoft power BI can handle that much rows, in the editor you have the to keep TOP N rows.
    Please find the image attached.Screenshot_2020-01-29 Only load 100 rows in load mode.jpg

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •