Search

Categories

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Send mail to the author(s) E-mail

# Sunday, 02 October 2011
( Excel | Reporting | VidPub )

 

  • 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.

image

Console app in Tasks to pump in test data.

1000 users, sales etc..

image

writing reports.

image

 

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.

image

group by vendor.

put into a StoredProcedure

image

hmm lets make the price per gig rate historical..and put in somewhere.

Report Viewing

image

Use an Area can view html

Or export to csv

Infrastrucutre/CSVResult

can send back a file result in MVC3.. cool.

image

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

image

Add Pivot chart so can see which authors are most profitable.

image

so annual subscription is doing better…

Channel eg Linux, MS, RoR

image

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.

| | #