sql - Historical solution for a point in time database - Possible data warehouse solution -


my company membership based organization , in dire need record granular membership data @ end of every month. our membership base continually changing , historical information not kept. hope reference , compare our membership base on month month basis. issue is, no have solution so.

we're looking push maximum of 10gb per month onto cloud.

i'm considering services such domo (that leverages aws) aggregate 700k rows of data on monthly basis.

our database mssql database , sure incur discounts azure.

cost factor on this.

what options in term of solutions?

you need datawarehouse (dwh) there isn't way around that.

it important separate transaction (membership) system historic data repository (dwh) perform reporting , analytics. companies try , save money doing long term reporting on transaction system, instead of building purpose built dwh.

i disagree @destination-data powerbi. powerbi visualisation tool , not dwh.

read dimensional modelling idea of grain, dimensions, facts, etc.

thinking solution, suggest should go daily loaded dwh tracks new records , changes membership base, along attendance, usage, transactions, etc. important start small since dwh projects fail quite because aim large , technology/methodology isn't understood. buy copy of kimballs' dwh toolkit, excellent!

this allow report on daily event , produce like reporting, month date reporting, management kpis, etc.

as far cost goes, going cost money, can't around that. suggest solution ms azure / dwh built on sql server standard virtual machine / ssrs reporting / powerbi dashboards / excel analytics. can sliced many ways, when looked @ price of aws compared azure there wasn't in price point of view... cost £100-300/month relatively small data volumes talking about.

some of tricky bits come in when want make secure , add in firewalls / webservers / backups / redundancy etc.


Comments

Post a Comment

Popular posts from this blog

inversion of control - Autofac named registration constructor injection -

does autofac support specifying registration name in components' constructors? example: ninject's namedattribute . you need use autofac.extras.attributed package on top achieve this so let's have 1 interface , 2 classes: public interface ihello { string sayhello(); } public class englishhello : ihello { public string sayhello() { return "hello"; } } public class frenchhello : ihello { public string sayhello() { return "bonjour"; } } then have consumer class, in want select instance injected: public class helloconsumer { private readonly ihello helloservice; public helloconsumer([withkey("en")] ihello helloservice) { if (helloservice == null) { throw new argumentnullexception("helloservice"); } this.helloservice = helloservice; } public string sayhello() { return this.helloservice.sayhello()...
Read more

verilog - Systemverilog dynamic casting issues -

i've code snippet following in testbench function void write_to_port( my_data_type_base data ); my_data_type_extended data_ext; if(!$cast(data_ext, data)); `uvm_error(get_type_name(), "failed cast"); `uvm_info(get_name(), $psprintf("data_ext :\n%s", data_ext.sprint()), uvm_medium) // write data_ext out port.... endfunction when run it, i'm getting uvm_error "failed cast." i'm not quire sure why $cast not returning 1. can see, i'm printing out extended class data item after casting uvm_info. can see it's being cast properly. if don't use $cast if condition, don't runtime error. isn't coding practice use if dynamic cast check if $cast returning 1 ? what might reason behind cast not returning 1 in above case? i think semicolon on line 'if' not belong? i think consumes if statement, , uvm_error executes regardless of how if evaluates: if(!$cast(data_ext, data)); <- no semico...
Read more

ios - Change Storyboard View using Seague -

i have following code checks connection server, , depending on want change views if no connection found. nsstring *connect = [nsstring stringwithcontentsofurl:[nsurl urlwithstring:@"http://myserver.com"] encoding:nsutf8stringencoding error:nil]; if (connect == null) { [self performseguewithidentifier:@"network_failure" sender:self]; } else { // other code here } my problem not change views. have added storyboard segue between 2 views identifier of network_failure . not have navigation controller or that, problem? thanks help! no not problem. first of all, in objectivec exists nil object oriented null . must use that. so: if(connect == nil) or better: if(!connect) so due fact nil not same of null , probably code does't enter in if scope . you have been able discover breakpoint. anyway: be sure set trigger segue (line) 2 view controller , , name network_failure (that not best name. should instead view1toview2 ) as, m...
Read more