Data & Tableau - Virtual Workshop

At OneNumber, we are focused on educating the next great wave of Tableau experts! We're here to provide classes, consulting and content to help you take your skills to the next level. As a Tableau partner, we've served thousands of Tableau users and we hope to play a role in your Tableau journey too!

OneNumber

<H2>Day One (Mon, Jan 7th)</H2>
<P>8:30 AM - 12:00 PM (PDT)</P>
<H2>Day Two (Tues, Jan. 8th)</H2>
<P>8:30 AM - 12:00 PM (PDT)</P>
<H2>Day Three (Weds, Jan 9th)</H2>
<P>8:30 AM - 12:00 PM (PDT)</P>
<H2>Day Four (Thurs, Jan 10th)</H2>
<P>8:30 AM - 12:00 PM (PDT)</P>
<P><BR></P>
<P>Preparing data for Tableau takes 80% of the time in any information communication effort.<STRONG> </STRONG><STRONG>This workshop will save hundreds of hours</STRONG> spent on manual data preparation and looking online for answers.</P>
<P>Tableau is a powerful tool. Becoming proficient at building insightful dashboards might only take a couple of weeks. While there are good resources demonstrating how to use Tableau to build dashboards, there are not good resources about how to prepare data for analysis in Tableau. When we first started using the product, it took many months of effort and meetings with specialized consultants to learn the rules associated with preparing data for Tableau. We don’t want others to go through those same difficulties. <STRONG>We’ve taken years of learning and condensed it into a 2 day workshop to save you the time and frustration.</STRONG></P>
<P><BR></P>
<H2><A HREF="https://vimeo.com/241597983" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Video Overview of the Class</A></H2>
<P><BR></P>
<H2><A HREF="https://vimeo.com/241716571" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Video Excerpt from Chapter 4</A></H2>
<P><BR></P>
<H2><A HREF="https://static1.squarespace.com/static/57bfa51129687fe4f8df9bbe/t/5a00f34053450aa14e679bfa/1510011715869/Data+Workshop+-+Sample.pdf" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Manual Excerpt from Chapter 4</A></H2>
<P><BR></P>
<P>Topics we will explore include: </P>
<UL>
<LI>
<H3>Understand the Product</H3>
</LI>
<LI>Tableau File Types</LI>
<LI>Shortcuts to Know</LI>
<LI>Order of Operations</LI>
</UL>
<P><BR></P>
<UL>
<LI>
<H3>Data Preparation Background</H3>
</LI>
<LI>Facts and Dimension Tables</LI>
<LI>Data Language: Normalized and Denormalized</LI>
<LI>Date Language: Structured vs. Unstructured</LI>
<LI>Editing the Metadata</LI>
</UL>
<P><BR></P>
<UL>
<LI>
<H3>Multiple Table Scenarios</H3>
</LI>
<LI>Joins</LI>
<LI>Cross-Database Joins</LI>
<LI>Blending</LI>
<LI>Unions</LI>
</UL>
<P><BR></P>
<UL>
<LI>
<H3>Common Issues</H3>
</LI>
<LI>Messy Crosstab Data</LI>
<LI>Duplicating Data with Joins</LI>
<LI>Blending Black Box</LI>
<LI>Unexpected Null Data</LI>
<LI>How do Nulls Affect Averages?</LI>
<LI>Why Won’t My Data Source Refresh?</LI>
</UL>
<P><BR></P>
<UL>
<LI>
<H3>Making Data Efficient</H3>
</LI>
<LI>Practical Thoughts: Reducing Columns and Rows</LI>
<LI>Pre-Aggregate Data with SQL</LI>
<LI>Pre-Aggregate Data with Excel</LI>
<LI>Pre-Aggregate Data with Tableau Prep</LI>
<LI>Transfer Calculations to Data Source</LI>
<LI>Extracts, Your Best Friend</LI>
<LI>Tableau Server Extract Refreshes</LI>
<LI>Filtering for Speed</LI>
<LI>Custom SQL Parameters</LI>
</UL>
<P><BR></P>
<UL>
<LI>
<H3>Data Management</H3>
</LI>
<LI>How to Manage .tds files</LI>
<LI>Do Not Select "Published separately"</LI>
<LI>Deleting Unused Data Sources</LI>
<LI>Setting Up Data on Server</LI>
<LI>Tableau Server Permissions</LI>
<LI>Row-Level Security</LI>
</UL>
<P><BR></P>
<UL>
<LI>
<H3>When Do You Need More Than Tableau?</H3>
</LI>
<LI>Unioning Tables from Different Data Sources</LI>
<LI>Complex Combinations of Filters, Pivots, Joins and Unions</LI>
<LI>Fuzzy Matching</LI>
<LI>Forecasting</LI>
<LI>Alternative ETL Tools</LI>
</UL>
<P><BR></P>
<H2>Requirements:</H2>
<UL>
<LI>
<P>A Computer</P>
</LI>
<LI>
<P>A Reliable Internet Connection</P>
</LI>
<LI>
<P>Tableau Desktop Professional 10.5 or Later</P>
</LI>
<LI>
<P>Tableau Prep 2018.1 or Later</P>
</LI>
<LI>
<P><SPAN>An External Monitor (strongly recommended for optimal experience)</SPAN></P>
</LI>
</UL>
<P><BR></P>
<H2>Prerequisites:</H2>
<P>Basic understanding of Tableau. You should be able to do the following:</P>
<UL>
<LI>
<P>Connect to a data source.</P>
</LI>
<LI>
<P>Understand the difference between measures and dimensions.</P>
</LI>
<LI>
<P>Build a basic dashboard.</P>
</LI>
</UL>
<P><BR></P>
<H2>What will you get?</H2>
<P>In addition to four half-days of virtual instruction, <SPAN>attendees will walk away with a 165+ page digital manual and data files to revisit the concepts on their own later.</SPAN></P>
<P><BR></P>
<H2>Where will this be hosted?</H2>
<P>This training will be hosted virtually.</P>
<P><BR></P>
<H2>What people are saying about OneNumber and trainer Eric Parker:</H2>
<P>"After spending a couple days working with OneNumber, we are months, no, lightyears ahead of where we would be otherwise." - A OneNumber client to their CEO.</P>
<P> "Eric is one of the best instructors that I have ever had. Everything was paced very well and the content was extremely valuable. Personable, helpful and patient. Willing to explore with us students and excited about using Tableau, like we are!" -A Former Student</P>
<P>eric.parker@onenumber.biz</P>
<P><A HREF="http://onenumber.biz" TARGET="_blank" TITLE="OneNumber" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">onenumber.biz</A></P>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Data & Tableau - Virtual Workshop

More events from OneNumber

Discover more events from OneNumber, from Business to other experiences you might love.

Still looking for the right event?

Data & Tableau - Virtual Workshop

More events from OneNumber

Discover more events from OneNumber, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?