- Use data to make decisions
- Demonstrate validity and value of business idea
more important than tests/design pattern used??!!!
Tracking sales as well as costs
Good solid reporting makes a business.
Maintaining reporting is hard…. it will get dropped… and others will just login to database and run their own.
- DevExpress, Dundas, Infragistics, Reporting Services etc…
- Analysis Services, Cognos.. BI Tools.. Suites
how to get the data in.
Pump some test data into system. Skew sales 2:1 for Microsoft videos.
Console app in Tasks to pump in test data.
1000 users, sales etc..
no foreign key in
Historical va Transactional Data
sum, average or count
ETL into DataWarehouse.
Star Schema around fact table
OLAP – Online Analytical Processor
Can run predictive algorithm
OrderItems table..taking ProductID out of OrderItems (historical data)
have tags in there.. but flat.. yuk.. could be subscritpion and yearly
lets have orderType nvarchar(50) – susbscirption or single
can take a while
cost of selling individual items, and delivery.
eg how big a file is, and how much Amazon charges. 12cents per Gig.
add to episodes table filesize.
high dev mp4
streaming (FLV.. not h264 html5)
so have good test data with monthly, yearly and single subsciption… data transfer rates.
Run a tranform on date – quarter and year is fine.
group by vendor.
put into a StoredProcedure
hmm lets make the price per gig rate historical..and put in somewhere.
Use an Area can view html
Or export to csv
can send back a file result in MVC3.. cool.
excel is really good at working with data..
Hmmm better way is live data
Excel Web Query
Data, From Web
whats selling the most?
what giving the most value?
what is net income for each sale? price-bandwidth
Roll ups by Author
Add Pivot chart so can see which authors are most profitable.
so annual subscription is doing better…
Channel eg Linux, MS, RoR
which channel is giving most profit.. so can plan what to do next.
Excel with Web Query
now – yes is good
1 year – yes
3 years – probably not. SQL Analysis services..
Getting the correct data in the reporting db is most important bit.