sql help-setup

[keepngoal]

Good Morning,

I am in need of some help in setting up a db where we can import data (4 times year), and then run reports from. Excel is too small with the type of lookup and output needed.

I can write up a 'spec' sheet and share the current spreadsheet. any takers, pm me please.

-keep

 

[NWICY]

@cowgirl836, this is your bat signal girl.

 

[cycloneG]

Power BI is fairly easy to transition to from using Excel.

Tutorial: From Excel workbook to stunning report in Power BI Desktop - Power BI

This tutorial shows how you can quickly create a stunning report from an Excel workbook.

docs.microsoft.com

 

[cowgirl836]

@cowgirl836, this is your bat signal girl.

Probably a little out of my wheelhouse but agree that Power BI is a good option.

 

[Ames]

Azure SQL is easy to setup and maintain if you really want MS SQL. Also you can setup a pretty cheap DB paying by the DTU and scale it up as needed.

 

[TitanClone]

Checkout https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html

If you just want to host on a local machine you could probably find a CS, SE or CE student to do it cheap. The subreddit r/iastate is pretty active.

 

[CascadeClone]

Any SQL programmers out there looking for a small side gig? My business needs some reports pulled from our ERP tables. We've used Excel with SQL to pull the data into reports. I'm sure it is super easy stuff, but we are not big enough to have a full time IT person.

My back up plan is to self-teach - can't be too much different from Fortran, right??

 

[simply1]

Power BI is fairly easy to transition to from using Excel.

Tutorial: From Excel workbook to stunning report in Power BI Desktop - Power BI

This tutorial shows how you can quickly create a stunning report from an Excel workbook.

docs.microsoft.com

I’ve not used it, is there a useful free version? Given the limited use it seems like there’d be cheaper options.

 

[cycloneG]

I’ve not used it, is there a useful free version? Given the limited use it seems like there’d be cheaper options.

It's free to use. You have to pay if you want to use the online sharing features.

 

[Cloneon]

Good Morning,

I am in need of some help in setting up a db where we can import data (4 times year), and then run reports from. Excel is too small with the type of lookup and output needed.

I can write up a 'spec' sheet and share the current spreadsheet. any takers, pm me please.

-keep

Since you didn't specify Windows or being on the same computer, it's a no brainer to use a Linux box for all DB related stuff. Keeping it separate allows multiple services to run not impeding your box. MariaDB is the recommendation for DB with PhpMyAdmin as your administrative web interface and Excel on your PC as your best option for analysis. Of course the Linux stuff is all free and don't worry about reliability. As a small business consultant for nearly 40 years now, the best decision I ever made for my clients was to migrate server stuff onto Linux away from Microsoft.