In This session Brett McLaughlin, Chief Data Strategist at Akamai discussed his journey to creating a forecasting solutions. He sheds light on some limitation, some innovative thinking and some hacks that one could use to structure a good forecasting model.
Here's Brett's post session note:
Hey Vishal!
In our conversation I mentioned that my friend Vinod and I were tackling brain teasers from Shakuntala Devi, using only SQL. This week, we attempted this problem: Identify the largest and smallest nine-digit number that contains one of each digit 1-9 and has an integer square root.
Below is the SQL to do just that!
Brett
drop table tmp_Delme
create table tmp_delme as
select comb_num
from (
select i.row_val || ii.row_val || iii.row_val || iv.row_val || v.row_val || vi.row_val || vii.row_val || viii.row_val || ix.row_val as comb_num
from
(select rownum as row_val from dual connect by level i.row_val)
inner join (select rownum as row_val from dual connect by level ii.row_val and iii.row_val i.row_val)
inner join (select rownum as row_val from dual connect by level iii.row_val and iv.row_val ii.row_val and iv.row_val i.row_val)
inner join (select rownum as row_val from dual connect by level iv.row_val and v.row_Val iii.row_val and v.row_val ii.row_val and v.row_val i.row_val)
inner join (select rownum as row_val from dual connect by level v.row_val and vi.row_val iv.row_val and vi.row_Val iii.row_val and vi.row_val ii.row_val and vi.row_val i.row_val)
inner join (select rownum as row_val from dual connect by level vi.row_val and vii.row_val v.row_val and vii.row_val iv.row_val and vii.row_Val iii.row_val and vii.row_val ii.row_val and vii.row_val i.row_val)
inner join (select rownum as row_val from dual connect by level vii.row_val and viii.row_val vi.row_val and viii.row_val v.row_val and viii.row_val iv.row_val and viii.row_Val iii.row_val and viii.row_val ii.row_val and viii.row_val i.row_val)
inner join (select rownum as row_val from dual connect by level viii.row_Val and ix.row_val vii.row_val and ix.row_val vi.row_val and ix.row_val v.row_val and ix.row_val iv.row_val and ix.row_Val iii.row_val and ix.row_val ii.row_val and ix.row_val i.row_val)
) x
select min(comb_num), max(comb_num)
from tmp_Delme
where round(power(comb_num,.5),6) = round(power(comb_num,.5))
Here's Brett's Bio:
Twenty-one years of experience transforming business operations through a more intelligent use of data. Expertise in leading organizations in data transformation, predictive analytics (e.g., forecasting, linear programming, operational simulations, etc), world-class visualizations and interfaces, and tight integration into existing operations.
About #Podcast:
#FutureOfData podcast is a conversation starter to bring leaders, influencers and lead practitioners to come on show and discuss their journey in creating the data driven future.
Wanna Join?
If you or any you know wants to join in,
Register your interest @ http://play.analyticsweek.com/guest/
Want to sponsor?
Email us @ info@analyticsweek.com
Keywords:
FutureOfData
Data
Analytics
Leadership Podcast
Big Data
Strategy
view more