Home > Uncategorized > daily 05/18/2015

daily 05/18/2015

    • They head there, and Don peels off to visit Stephanie. She is the niece of Anna Draper, who is the wife of the man Don stole his identity from while they were fighting in the Korean War. Stephanie isn’t in good shape. She has been forced to give up her son and can’t find solace, even at Esalen, where she takes Don.
    • n this section, you use the Microsoft Office Power Pivot in Excel 2013 add-in to extend the model. Using Diagram View in Microsoft SQL Server Power Pivot for Excel makes creating relationships easy. First, you need to make sure you have the Power Pivot add-in enabled.
    • Notice that the Power Pivot window shows all the tables in the model, including Hosts. Click through a couple of tables. In Power Pivot you can view all of the data that your model contains, even if they aren’t displayed in any worksheets in Excel, such as the Disciplines, Events, and Medals data below, as well as S_Teams,W_Teams, and Sports.
    • It’s nice when the data in your Data Model has all the fields necessary to create relationships, and mash up data to visualize in Power View or PivotTables. But tables aren’t always so cooperative, so the next section describes how to create a new column, using DAX, that can be used to create a relationship between tables.

       

         

       

    • Since the Hosts table doesn’t have such a field, you need to create it. To preserve the integrity of the Data Model, you can’t use Power Pivot to edit or delete existing data. You can, however, create new columns by using calculated fields based on the existing data.

       

    • In Hosts, we can create a unique calculated column by combining the Edition field (the year of the Olympics event) and the Season field (Summer or Winter). In the Medals table there is also an Edition field and a Season field, so if we create a calculated column in each of those tables that combines the Edition and Season fields, we can establish a relationship between Hosts and Medals. The following screen shows the Hosts table, with its Edition and Season fields selected

       

    • Create a hierarchy

       

      Most Data Models include data that is inherently hierarchical. Common examples include calendar data, geographical data, and product categories. Creating hierarchies within Power Pivot is useful because you can drag one item to a report – the hierarchy – instead of having to assemble and order the same fields over and over.

       

      The Olympics data is also hierarchical. It’s helpful to understand the Olympics hierarchy, in terms of sports, disciplines, and events. For each sport, there is one or more associated disciplines (sometimes there are many). And for each discipline, there is one or more events (again, sometimes there are many events in each discipline). The following image illustrates the hierarchy.

    • In this section you create two hierarchies within the Olympic data you’ve been using in this tutorial. You then use these hierarchies to see how hierarchies make organizing data easy in PivotTables and, in a subsequent tutorial, in Power View.
    • Use hierarchies in PivotTables

       

      Now that we have a Sports hierarchy and Locations hierarchy, we can add them to PivotTables or Power View, and quickly get results that include useful groupings of data. Prior to creating hierarchies, you had to add individual fields to the PivotTable, and arrange those fields how you wanted them to be viewed.

    • Future of baseball coach Augie Garrido: The Horns finished the regular season 26-25 and head into the Big 12 Baseball Tournament this week as the #5 seed. Patterson seemed to indicate that a change may not be forthcoming. “We’ve spoken some. … Reality is a lot of key injuries that’s hurt the team.”

       

      Patterson also mentioned that a new basketball arena was “at least 6 to 8 years away.”

    • There is no question that UT athletics can be a unifying experience for alumni. But I’m skeptical that taking UT football to Mexico or overseas will do much to establish the University of Texas beyond selling T-shirts. Maybe they can recruit some students… fine.
    • And Littlefinger offers to go up with the Knights of the Vale, and kill the survivor of that battle — either Stannis or Roose. In return, Littlefinger gets a decree from King Tommen naming him Warden of the North in Roose’s place. But Littlefinger has to know there’s no way he can convince the Knights of the Vale to attack Winterfell — not without explaining how Sansa got there, when she left the Vale under Littlefinger’s protection.
    • In any case, this is one of the areas where the cracks are starting to appear in the show. Sansa’s decision to agree to marry Ramsay, in the name of getting revenge for her murdered family, happened awfully quickly in retrospect — the lack of time spent convincing her to go through with a frankly insane idea only fully bothers me, now that I’m witnessing the terrible result:
    • This would be easier to stomach if we’d seen Sansa struggle with the decision to agree to marry Ramsay, and finally agree to do it. But the show rushed through that plot point a few episodes ago, and this storyline is harder to watch as a result.
    • This episode is just full of sequences where people try to be sneaky and it doesn’t go well — in one of these, Tyrion and Jorah try to sneak past a slaver ship, only to get caught by the crew who have come ashore looking for water
    • Then Tyrion reveals to Jorah that his father, Jeor Mormont, is dead — Jeor was the Lord Commander of the Night’s Watch who got killed in Craster’s Keep by his own men. Tyrion mentions that Jeor really cared about his men, knowing all of their stories in depth — but that those men turned around and murdered him on an expedition. In other words, benevolence towards his men didn’t save him in the end, and you can see Jorah’s face when he realizes just how unjust his father’s death really was.
    • This is another instance where the cracks seem to be appearing in this show a little bit — first, because the Sand Snakes making their move at the exact same time as Jaime seems like the kind of bizarre coincidence the show has leaned on a lot lately. And second, because we’ve barely gotten to know the television version of the Sand Snakes, so it’s more like “Hey, some random women, one armed only with a whip, are getting in the way.”
    • One of the Sand Snakes makes off with Myrcella, but the others are captured, along with Jaime and Bronn. Also captured? Oberyn’s lover Ellaria Sand, who put the Sand Snakes up to this.
    • The titles of Martin’s other books have indicated a concern with the danger of multiple sovereigns, the cost of war, and how the aftermath of war can be as bad as war itself. But the show, to some extent, has remained focused on game-playing and has pushed forward some of the more machiavellian characters — like Lady Olenna Tyrell.
    • So it seems as though Olenna, like Littlefinger, has miscalculated. But she’s only just getting started, and she’s been doing this for a long time. To bring it back to Sansa and Arya, Olenna has long ago learned the lessons that both Stark girls are just now encountering — that “winning” in the context of Westerosi politics involves putting yourself through a lot of misery. Especially if you’re a woman.
    • *Since the Martells are known for using poison, and the camera really focused on the fact that one of the Sand Snakes cut Bronn—to the point of showing Bronn wince and stare at the wound—I won’t be surprised if Bronn is poisoned.
    • I only have one thought on Sansa’s rape scene: I really, really hope the showrunners aren’t going to try to make Ramsay raping Sansa a plot device to jumpstart some kind of redemption arc for Theon. Because that’s what it looks like they were hinting at near the end of the scene when Theon’s face was clearly shifting into an expression of rage.

Posted from Diigo. The rest of my favorite links are here.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: