Kirix Strata Blog

Watching Reruns: Strata Tutorial Videos from the Archives

Movie IconIt’s been almost one year since we released the beta version of Kirix Strata to the public.  During that beta cycle, we provided several videos and screencasts via our blog to emphasize different things the software could do.

Thankfully, even though the videos show the beta version in action, almost all of the content is extremely relevant for the final version of Strata as well.  The only variance really has to do with the user interface; we ended up moving around icons and toolbars and menu items quite a bit until we got something that seemed to work best.  Oh, and you may see the original Strata logo that we threw together for the beta.

So, maybe you can consider this blog post your Tivo or on-demand video page for “Season 1″ of Kirix Strata.  Here are the five links, with details and highlights of each one below:

Access and Manipulate Data from the Web

Play Video

(And here’s an embeddable YouTube version…)


  • (0:00) Using Web Tables:  Calculate gross proceeds of every Harry Potter movie.  Pop open an HTML table of movie proceeds from Swivel, change the field names, resize columns, create a calculation that sums up the amounts from different columns.
  • (2:46) Using RSS Feeds:  Determine popularity of Harry Potter articles on Digg.  Use Quick Find to search manually, pop open an RSS feed into a table view, create a calculated field to identify fields containing “Harry” (demonstrates the UPPER() and CONTAINS() functions), adjust column width and sort records.
  • (4:35) Using CSV Files from the Web:  Compare stock price movements between Time Warner and the Dow Jones Average using historical information from Yahoo Finance.  Pop open hyperlinks to CSV files instead of downloading, tile view vertically and horizontally, calculate stock price increase and decrease, link together the two tables using a relationship based on the date, filter the child table to see only related records, add a related field to the parent table, calculate price movement (using the IIF() function), mark specific records in yellow, filter on these records.

Identify Embedded Search Terms within Apache Web Logs

Play Video

(And here’s an embeddable YouTube version…)


  • When people enter a term in the search box on our online forum, it gets recorded in the web logs.  This video shows how to extract those search terms and add them up to see what your users are searching for.
  • Open an Apache web log with around 765,000 records, use a calculated field to pull out the specific term; build up logic piece by piece (using the STRPART(), SUBSTR(), CONTAINS() and IIF() functions), group together and count the search terms, sort on the count to identify the most popular search term.

Manipulate Call Center Data and Create a Mapping Visualization

Play Video

(And here’s an embeddable YouTube version…)


  • Take a local set of data, in this case call volume from a call center, isolate the area codes, relate together with a data set from the web to identify the related US State for each area code, export a csv file and post it to a mapping visualization website to see a heat map of call volume by state.
  • For a full overview of what is happening here, see this blog post.
  • Isolate area codes from call data via a calculated field (use IIF() and SUBSTR() functions), import data from an HTML table on the web, create a relationship and insert state abbreviations into the original call center data, group data together by state code, save as a CSV file, upload to mapping website, review visualization.

Features Overview:  Data Bookmarks, Quick Find & Quick Filter and Report Writer

Play Video

(And here’s an embeddable YouTube version…)


  • This video shows off some of the new features we released for Strata, beta 7 and briefly shows how to use each one.
  • Refreshable Data Bookmarks:  This feature lets you bookmark a data set from the web (CSV file, RSS feed) and, when you come back to it at a later time and open it, the data set will automatically refresh.  Open up a CSV stock quote via a Yahoo Finance API, create a calculation to show price change, mark records in yellow based on a formula, refresh data, save as a bookmark, close and reopen to refresh.
  • Quick Find and Quick Filter:  Instead of using formulas to filter or find, simply enter the criteria in the box to quickly filter a table.  Use quick find to search for individual records, click quick filter to toggle to a filtered view.
  • Report Writer:  Add a source table to the report, add fields and field names, switch to the layout view and adjust columns, add a group to the report, adjust report formatting and get ready to print. [NOTE:  this video contains outdated information related to the report writer.  Report source and the grouping/sorting controls are located by clicking the Report Settings icon; also, all formatting can be done via the embedded formatting toolbar instead of a formatting panel).

Combine Table from MySQL Database and HTML Table from the Web, then Create a Report

Play Video

(And here’s an embeddable YouTube version…)


  • This is the demonstration overview video we used when we officially released Strata, which takes a table from mysql databse, combines it with data from the web, adds in a few data gymnastics and creates a report to share.
  • (0:00) Overview: Quickly access a CSV table from your PC and then from Google Finance, manipulate the data and then create a report on it.
  • (0:54) Connect to MySQL:  Access data tables in MySQL database, open it, move columns, save a copy locally to the project.
  • (1:29) Manipulate Data:  Check the data structure, filter, quick find, sort, group together, calculated average call time, sort and copy specific records to a new table based on a formula.
  • (2:30) Combine Table with Web Data:  Identify which part of the country calls came from.  Open web page and import HTML table, create calculation to parse area codes (using SUBSTR(), LEFT() and IIF() functions), relate the two data tables together, filter on the related records, move region field to the main table.
  • (4:30) Create a Report:  Select appropriate fields and create a quick report, create a group based on the state, toggle between design and layout view, change formatting and print or distribute as a PDF.

41 Responses to “Watching Reruns: Strata Tutorial Videos from the Archives”

  1. best electronic cigarettes reviews says:

    Yet another fantastic article.

  2. Branda Namisnak says:

    Most of these “best” lists are a joke. They just pick people who are either very popular, or who generate a lot of hits (positive or negative).

  3. Angila Shimaoka says:

    As a non smoker, don’t mind these types of products at all. The pen style is perfect. It is discreet and can be smoked in an office without anyone knowing practically. can be smoked anywhere, it just looks like your putting your pen to your mouth…nothing more. i know non smokers also that would be annoyed to see a cig pack on a desk. But seeing a pen style cig would not annoy anyone i think.

  4. wedding cassie wright photography uga says:

    Very well written information. It will be helpful to anybody who employess it,
    as well as yours truly :). Keep doing what you are doing - looking
    forward to more posts.

  5. pizza franchises says:

    The Franchising strategy has been applied
    to all kinds of businesses from food, retail, internet, beauty salons to distribution
    services. These training programs can also be availed on a regular basis.
    When you decide to franchise, you are essentially following in the footsteps
    people who have created an established, proven, working business model.

  6. game deals online says:

    These are really wonderful ideas in regarding blogging.
    You have touched some fastidious things here. Any way keep up wrinting.

  7. organic seo Marketing fresh seocompany says:

    Excellent website you have here but I was curious about if you knew of any user discussion forums that cover the same topics discussed in this article?
    I’d really like to be a part of online community where I
    can get responses from other knowledgeable people that share the same interest.
    If you have any suggestions, please let me know. Thank you!

  8. says:

    I have learn some excellent stuff here. Definitely value bookmarking for revisiting.

    I surprise how so much attempt you put to create this type
    of excellent informative web site.

  9. free games says:

    It’s appropriate time to make some plans for the future
    and it’s time to be happy. I’ve learn this submit and if I may just I desire to counsel you some fascinating issues or advice.
    Maybe you can write subsequent articles referring to this article.
    I wish to read even more things about it!

  10. Curs BNR says:

    Un Curs Valutar de Watching Reruns: Strata Tutorial Videos from the Archives conversie valutara nu
    este o greutate usoara de a a fauri de zi cu zi cu modificarea ratelor Curs Valutar straine .
    Fiind o piesa straina , slova la care moneda locala se
    va a calcula pentru Curs BNR puterea de luare in jerpelitura instraina se muta
    in fitece minut uro .

  11. Virgil says:

    I used to be recommended this blog by means of my cousin.
    I’m no longer positive whether or not ths submit is written by him as no one elpse recogise such particular about my difficulty.
    You are wonderful! Thank you!

  12. ropa de bebe online says:

    I don’t know if it’s just me or if perhaps everyone else experiencing problems with your website.
    It seems like some of the text on your content are running off the
    screen. Can somebody else please comment and
    let me know if this is happening to them too? This might be a issue with my web browser because
    I’ve had this happen before. Thank you


    I am really impressed with your writing skills
    and also with the layout on your weblog. Is this a paid theme
    or did you customize it yourself? Anyway keep up the nice quality writing, it’s rare
    to see a nice blog like this one today.

  14. polo ralph lauren femme discount says:

    Mesnil, après y avoir habité polo ralph lauren femme des incompétents en 2009 !

  15. SEOVEINTE argentina says:

    Magnificent beat ! I wish to apprentice at the same time as you amend your site, how can i subscribe
    for a weblog site? The account helped me a acceptable deal.
    I had been a little bit familiar of this your broadcast provided
    vibrant clear concept

  16. The Palace Side Hotel 是一間位於京都(京都中央) 適合一家大小的酒店,鄰近京都御所、京都御苑及京都國際漫畫博物館。二條城及平安神宮也近在咫尺。 says:

    Simply wish to say your article is as surprising. The clarity on your post is just great and i could think you are knowledgeable on this subject. Well along with your permission allow me to snatch your feed to keep updated with imminent post. Thank you one million and please keep up the gratifying work.

  17. lunette de soleil oakley juliet says:

    les principaux de collège, les proviseurs acheter lunette oakley s infiltrer des voyous pourtant virés sans contr?le d

  18. european dating sites says:

    Io sono curioso in direzione of come across fuori cosa blog site sistema by yourself incorporate stato performing con? Io sto consuming alcuni tiny stability challenges con mio most current web page e vorrei which includes towards identify anything much more probability-absolutely. your self include qualsiasi companies?

  19. buy twitter followers review says:

    I like the valuable information you provide in your articles. I will bookmark your weblog and take a look at again here regularly. I’m quite sure I will be told a lot of new stuff right here! Best of luck for the next!

  20. Ursula says:

    Hi, I do believe this is an excellent web site. I stumbledupon it ;) I will come back
    once again since i have bookmarked it. Money and freedom
    is the best way to change, may you be rich and continue to help others.

  21. Full Article says:

    valium tension purchase valium unita kingdom droga di valium low-cost customers

  22. conoscere donne russe says:

    Guten Tag! Ich may Contain ich schwören wurde in Richtung Of dieses Web just Before nonetheless immediately After examining During einigen posting I figured Out es ist fresh neue Towards me. Auf der anderen hand, ich bin completely pleased ich found, es und ich werden Guide-Markierung und Monitoring again constantly!

  23. donne che vogliono scopare says:

    Ich können ‘ T danken Yourself more als genug für report short-Article.Exceptionally on der Suche in Advance in die Richtung Of browse excess. müssenWird need much More.

  24. Clicking Here says:

    WOW basically cosa ero hunting per. Arrivato in questo articolo through hunting per starting off
    on business office

  25. Web site says:

    Ein strong Percentage, ich simply nur presented hier an carrying Out war ein Kollege ein tiny Research bei dies. Und er inside Truth ordered mir Frühstück infolgedessen end Result i Discovered es für ihn… Lächeln. Thus allow für mich umformulieren, dass: Thnx für address! Bedauerlich ja Thnkx für shelling Out Season in die Richtung Of focus auf sprechen dies, ich genuinely truly Feel stark above es und get Freude From looking At even More bei dieses Subject. Wenn Potential, als on eigene switch heraus in Richtung Of practical Experience, würde by Yourself head Aktualisierung Ihrer web-Site mit More Information? Es ist Quite Informative für mich. Groß Daumen für diese web Site article!

  26. free sex dating websites says:


  27. cerco ragazza disponibile says:

    Transmitir a calendario treinta días, once me detuve en su blog site accomplished que una inexactitud inside el camarero mysql intellect with saludos to yours.* ~,? *

  28. best free dating website says:

    Es unbelievably fascinating, En tu propio son un Really trained blogger. Me incorporate connected tu feed y seem a be ahead in dirección of trying further de tu spectacular posting. Como well, compartí tu web inside mis redes sociales!

  29. seznameni libimseti cz says:

    Ein particular Factor ich habe found ist often Lot gibt der fehlgeleiteten ideale with sieht To die Absichten der Finanzen Betriebe whilst Speaking with sieht To dwelling Zwangsvollstreckungen. 1 Fee Geschichte in nur exclusive ist reality, lender demands Ihr Ort. Monetary Einrichtung demands der Challenging gained money, nicht Ihre individual residence. Sie require revenue gaben oneself mit notice. Zwischendeck Distinct finanzielle Institution ist merely shifting Towards anziehen einigen variety ausgeschlossenes Abschluss. Aufgrund für Ihr Create-,.

  30. click for source says:

    genuinely enjoy que esta article. Me incorporate estado wanting todos above para esto! Gracias a Dios me identified que a Bing. Tu self incorporate manufactured mi jornada! Gracias your self yet again! “Lo que no get deshacerse de nos will make more robust nos.” as significa un resultado de Friedrich Nietzsche.

  31. riconquistare la ex fidanzata says:

    Esistono un variety di cattura exciting season constraints within just questo articolo di article on le altre hand io non recognize se io perspective tutti loro middle in la direzione of middle. Esiste qualche validità consuming stated che sono heading in la direzione of get continue per mantenere feeling right fino until io keep out in even further. Wonderful article, because of as un result noi need a lotto more! Incorporated within just FeedBurner come effectively

  32. Discover More Here says:

    È extremely un great e profitable facts. Io sono happy che yourself merely basically condiviso questo practical content e information con noi. Ricordi to maintain noi conscious together con questo. Grazie on il tuo per la condivisione.

  33. bakeca annunci says:

    web Page war… wie Yourself sagen es? Appropriate!! Bei einigen point I consist Of found, some Thing, served me. zu erhaltenFreude in!

  34. lacoste pas cher says:

    Et dire que ce sont les m锚mes qui donnent polo ralph lauren,polo ralph lauren homme,polo ralph lauren femme,chemise ralph lauren leur a propos茅e de les reconduire 脿

  35. cheap mac cosmetics says:

    MAC Cosmetics Wholesale specializes in discount, discount mac cosmetics, wholesale and below wholesale pricing. Cheap mac cosmetics online.

  36. wholesale mac makeup says:

    Mac makeup outlet store provides mac makeup wholesale and cheap mac makeup. The wholesale mac cosmetics are low price with high quality. Over 150USD is free shipping.

  37. sous vetement lacoste pas cher says:

    ainsi rendu dans la ville dimanche site de survetement lacoste pas cher de disposer des fonds de la Fema (l’Agence

  38. robe polo lacoste pas cher says:

    temp茅rament. Il ne fait aucun doute qu’elle sac a dos lacoste pas cher la tornade dont les vents ont souffl茅

  39. China and Hong Kong information on Wikipedia says:

    Hmmm it looks llike your blog ate my first comment (it was
    extremely long) so I guess I’lljust sum it up what I submmitted
    and say, I’m thoroughly enjoying your blog. I as well aam an aspiring blog blogger but I’m still neww tto
    the whole thing. Do you have any tips and hints for rookie blog writers?
    I’d definitely appreciate it.

  40. Kristine says:

    During a kitchen remodel, one of the most important things to discuss with
    your contractor is creating adequate storage space. It’s great to finish a
    project all on your own, but only if you really understand how
    many hours you are going to be working at it. Kitchen remodeling books,
    also commonly referred to as kitchen remodeling how-to guides, are books that are
    designed to help readers know as much as they can about
    remodeling their kitchens.

  41. html5 slider css says:

    Hello There. I found your blog using msn. This is a very well written article.
    I’ll make sure to bookmark it and return to read more of your useful
    information. Thanks for the post. I will definitely comeback.

Leave a Reply