Connect with us

The Story feature in Tableau can be a useful data visualization tool when you are drilling down on a dataset from general to specific. This tutorial shows you the basics.

Image: chendongshan, Getty Images/iStockphoto

As modern businesses generate more and more data, it has become increasingly more difficult to draw useful information out of the raw stream. Finding and communicating actionable information requires an effective set of tools designed specifically for that purpose.

Highly educated data scientists with training and experience in data visualization techniques are becoming more common in large enterprises, but small businesses do not have the resources to hire such experts. Inexpensive and accessible data visualization tools provided by vendors like Tableau Software are designed to help tell the story of your data without requiring you to have an advanced degree.

This how-to tutorial shows you how to create a simple story using basic tools found in Tableau.

SEE: Report: SMB’s unprepared to tackle data privacy (TechRepublic Premium)

Create your first data story in Tableau

As we did in the previously published article on data visualizations, we will be using free sample data provided by the resources page of the Tableau Public website. Specifically, the Cat vs. Dog Popularity in the US dataset. You can download the dataset, in the form of an Excel worksheet, to any folder on your computer.

SEE: How to create your first Tableau Software data visualization chart (TechRepublic)

For our example, we will separate four data points into their own sheets and then use them to create a story that explains the data’s importance. Figure A shows what we are working with before we start our new Story.

Figure A

a-create-story-tableau.jpg

Click the Story tab on the menu and select New Story from the submenu. As you can see in Figure B, our new story is blank but our four separate sheets highlighting our data points are listed in the left-hand list.

Figure B

b-create-story-tableau.jpg

The Story feature in Tableau can be a useful communication tool when you are drilling down on a dataset from general to specific or when going the other way, drilling up from specific to general. This movement through the data helps your audience visualize relationships between and among data points.

SEE: 4 tips for using data visualization in a board presentation (TechRepublic)

We start off with one blank storyboard, but we know we need three more, so click the Blank button to add them. Drag the first sheet representing an important data point in the story of our data to the first storyboard as shown in Figure C. Of course, we will want to give it a descriptive name.

Figure C

c-create-story-tableau.jpg

We will follow up with the three remaining data points. To make our data’s story a bit more compelling, let’s emphasize that California has the most households with both cats and dogs. We do this by adding a blank sheet in the middle of our story, and then adding a data point and a description box, as shown in Figure D, to highlight this fact.

Figure D

d-create-story-tableau.jpg

The next chapter in our data story reveals the significance of percentages in our dataset. When considering the percentage of households owning either a cat or dog in a particular state, the data shows Vermont (Cats) and Arkansas (Dogs) lead the way, as you see in Figure E.

Figure E

e-create-story-tableau.jpg

To see what your story looks like when complete, press F7 (function key 7) to change into presentation mode, as shown in Figure F. Readers and presenters can move back and forth through the data by clicking on one of the title cards.

Figure F

f-create-story-tableau.jpg

Obviously, this is a simplified example, but you can see the potential of telling your data’s story, whatever it may be, using visualization tools. The ability to glean vital, actionable information from the raw data generated by your business could be the key to gaining a competitive advantage. Tableau and other data visualization tools bring these capabilities to small businesses.

Also see

Source link

0
Continue Reading

Technology

Twist on CRISPR Gene Editing Treats Adult-Onset Muscular Dystrophy in Mice

2020 09 14 DM1 longitudnal muscle

Myotonic dystrophy type I is the most common type of adult-onset muscular dystrophy. People with the condition inherit repeated DNA segments that lead to the toxic buildup of repetitive RNA, the messenger that carries a gene’s recipe to the cell’s protein-making machinery. As a result, people born with myotonic dystrophy experience progressive muscle wasting and weakness and a wide variety of other debilitating symptoms.

CRISPR-Cas9 is a technique increasingly used in efforts to correct the genetic (DNA) defects that cause a variety of diseases. A few years ago, University of California San Diego School of Medicine researchers redirected the technique to instead modify RNA in a method they call RNA-targeting Cas9 (RCas9).

Twist on CRISPR Gene Editing Treats Adult Onset Muscular Dystrophy in

Green muscle fibers with RCas9 (the therapeutic candidate for myotonic dystrophy) have eliminated their toxic RNA (red), whereas fibers lacking RCas9 (dark) have persisting toxic RNA (red). Credit: UC San Diego

In a new study published in Nature Biomedical Engineering, the team demonstrates that one dose of RCas9 gene therapy can chew up toxic RNA and almost completely reverse symptoms in a mouse model of myotonic dystrophy.

“Many other severe neuromuscular diseases, such as Huntington’s and ALS, are also caused by similar RNA buildup,” said senior author Gene Yeo, PhD, professor of cellular and molecular medicine at UC San Diego School of Medicine. “There are no cures for these diseases.” Yeo led the study with collaborators at Locanabio, Inc. and the University of Florida.

Normally, CRISPR-Cas9 works by directing an enzyme called Cas9 to cut a specific target gene (DNA), thereby allowing researchers to inactivate or replace the gene. RCas9 works similarly, but Cas9 is guided to an RNA molecule instead of DNA.

In a 2016 study, Yeo’s team demonstrated that RCas9 worked by using it to track RNA in live cells. In a 2017 study in lab models and patient-derived cells, the researchers used RCas9 to eliminate 95 percent of the aberrant RNA linked to myotonic dystrophy type 1 and type 2, one type of ALS and Huntington’s disease.

The current study advances RCas9 therapy further, reversing myotonic dystrophy type 1 in a living organism: a mouse model of the disease.

The approach is a type of gene therapy. The team packaged RCas9 in a non-infectious virus, which is needed to deliver the RNA-chewing enzyme inside cells. They gave the mice a single dose of the therapy or a mock treatment.

RCas9 reduced aberrant RNA repeats by more than 50 percent, varying a bit depending on the tissue, and the treated myotonic dystrophy mice became essentially indistinguishable from healthy mice.

Initially, the team was worried that the RCas9 proteins, which are derived from bacteria, might cause an immune reaction in the mice and be rapidly cleared away. So they tried suppressing the mice’s immune systems briefly during treatment. As a result, they were surprised and pleased to discover that they prevented immune reaction and clearance, leaving the viral vehicle and its RCas9 cargo to persist, and get the job done. What’s more, they did not see signs of muscle damage. In contrast, they saw an increase in the activity of genes involved in new muscle formation.

“This opens up the floodgates to start testing RNA-targeting CRISPR-Cas9 as a potential approach to treat other human genetic diseases — there are at least 20 caused by buildup of repetitive RNAs,” Yeo said.

It remains to be seen if RCas9-based therapies will work in humans, or if they might cause deleterious side effects, such as eliciting an undesired immune reaction. Preclinical studies such as this one will help the team work out potential toxicities and evaluate long-term exposure.

In 2017, Yeo co-founded a company called Locanabio to accelerate the development of RNA-targeting CRISPR-Cas9 through preclinical testing and into clinical trials for the treatment of myotonic dystrophy and potentially other diseases.

Source: UC San Diego




Source link

0
Continue Reading

Technology

Microsoft Buys Bethesda-Owner ZeniMax for $7.5 Billion

Microsoft said on Monday it would acquire ZeniMax Media for $7.5 billion (Rs. 55,223 crores) in cash, strengthening its Xbox video game offering with the studio behind titles such as Fallout and the Doom reboot.

ZeniMax is the parent company of Bethesda Softworks, which has also developed hits including The Elder Scrolls, Wolfenstein, and Dishonored.

The deal comes more than a week after Microsoft’s failed bid for short video app TikTok’s US assets. TikTok has currently structured the deal as a partnership with Oracle and Walmart rather than an outright sale.

Microsoft said it plans to bring Bethesda’s future games into its monthly Xbox Game Pass subscription service when they launch on Xbox or PC. The game pass now has more than 15 million subscribers, Microsoft added.

Bethesda’s structure and leadership will remain in place, Microsoft said.

Gaming is on a tear due to demand from stuck-at-home users during the COVID-19 pandemic and Microsoft has put its faith in offering users many ways to play via its cloud service and consoles at different price points.

Microsoft said the ZeniMax deal will close in the second half of fiscal year 2021, and have minimal impact on adjusted operating income in fiscal years 2021 and 2022.

© Thomson Reuters 2020

Source link

0
Continue Reading

Technology

Open source: Why governments need to go further

dc

Commentary: Yes, governments should open source their custom code. But more than that is needed.

Image: lucky-photographer, Getty Images/iStockphoto

For Drupal (and Acquia) founder Dries Buytaert, “the default [in government] should be ‘developed with public money, make it public code.'” That is, if a government is paying for software to be created, that software should be available under an open source license. While he acknowledged there might be exceptions (e.g., for military applications, as I’ve called out), his suggestion makes sense.

Years ago I argued that government mandates of open source made no sense. I still feel that way. Governments (and enterprises) should use whatever software best enables them to get work done. Increasingly, that software will be open source. But when good open source alternatives don’t yet exist, it makes no sense to mandate the use of suboptimal software. 

But software that governments create? There’s no compelling citizen-focused reason for closing it off. Instead, there are many reasons to open it up.

SEE: How to build a successful developer career (free PDF) (TechRepublic)

Of the people, by the people, for the people

This topic of why countries should embrace open source is an easy argument to make. As Buytaert pointed out, if public money pays for the code to be developed, why wouldn’t that code be available to the public (except, as mentioned, in the case of sensitive military software)? 

Some countries have already gone this route. As I detailed in 2016, Bulgaria is one of them. A few years later, Bulgaria has been preparing its own national source code repository, based on Git (as required by law: “administrative authorities shall use public storage and control systems for the source code and technical documentation for development, upgrading or deployment of information systems or electronic services”). 

This is a significant step toward greater transparency. However, it’s not enough.

SEE: Open source can thrive in a recession says Drupal creator Dries Buytaert (TechRepublic)

Collaborating on common government issues

As much as I understand Bulgaria’s desire to build its own source code repository, there’s even greater need for governments to collaborate on code beyond their borders. Think about it: Governments tend to do the same things, like collecting taxes, issuing parking tickets, etc. Currently, each government builds (or buys) software to tackle these tasks. Obscene quantities of custom code are created each year by government organizations operating in silos.

Why isn’t the city of Bogota sharing software with London, which shares software with Lagos, which shares software with Pocatello (that’s in Idaho, by the way)? 

As IBM president (and former Red Hat CEO) Jim Whitehurst said way back in 2009, “The waste in IT software development is extraordinary….Ultimately, for open source to provide value to all of our customers worldwide, we need to get our customers not only as users of open source products but truly engaged in open source and taking part in the development community.” This is particularly true in government, where there isn’t even the competitive pressure (e.g., Bogota doesn’t compete with Pocatello) that might prevent large financial institutions from collaborating (though even they partner on open source).

So, yes, we need governments to open source the software they pay to have built, to Buytaert’s point. But we also need those same governments to share that code beyond their borders, thereby driving greater innovation at lower cost for their citizens. 

Disclosure: I work for AWS but the views expressed herein are mine, not those of my employer.

Also see

Source link

0
Continue Reading

Trending