- Use data to make decisions
- Demonstrate validity and value of business idea
more important than tests/design pattern used??!!!
Annual sales
Categories
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
- Excel
Excel
how to get the data in.
CSV 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..
writing reports.
no foreign key in
Historical va Transactional Data
OrderItems….called Fact.
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
Costs
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
mobile
tablet
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.
Report Viewing
Use an Area can view html
Or export to csv
Infrastrucutre/CSVResult
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
reporting/annual/sales
grouping, subtotal
whats selling the most?
what giving the most value?
what is net income for each sale? price-bandwidth
profit margin
Pivot table
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.
Review
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.