Data Analytics Specialist

Excel 365 contains several features to aid in data formatting and manipulation. In this course, you will explore various ways to format your data by type, which serves as a way of classifying the data. Learn how to create drop-down menus, fill cells using the Flash Fill feature, and how to create an automatic data series. Next, you will discover how to create an automatic data series using the advanced Fill Series options and how to format data, including options to configure its size or apply font effects such as bold, italic, and underline. Then you'll also see how to apply cell styles; how to format cells with the Format Painter tool; how to create customized number formats; how to apply custom cell formats; and how to clear all formatting from cells. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

In this 11-video course, learners will explore Tableau Desktop, which is data visualization software that allows users to see and understand data at a deeper level. Begin by locating and opening Tableau Desktop in a Windows 10 work environment, and once done, explore the Tableau Desktop interface. This leads into examining the Tableau Data Source Page, which is one of the most fundamental and important parts of Tableau. Discover how to connect to a desktop source and use single and multiple tables to extract data into Tableau Data Engine; how to connect to a Microsoft SQL Server database, select tables, and directly connect to the data to enable working with live data; and how to configure and use Extract Mode with a Microsoft SQL Server database connection. Next, examine how to extract data with a custom SQL query; use Google Analytics and Tableau to analyze your web data; work with OData source to consume data in Tableau; and demonstrate and implement inner, left, and right joins with Tableau. Conclude the course by observing how to use cross-database and more advanced joins.

Discover how to prepare, control, and clean up data before you start working with it to ensure that you get the most out of your analyses in Tableau Desktop in this 10-video course. Learners begin by observing how to manage data types for columns in Data Source page, then take a look at unioning data, and using unions to combine data from different locations and appending values in a single table. Tableau works best with clean data, so next you will explore how to work with data interpreter to identify data anomalies and clean up data. Learn how to split data fields using the split and custom split in the Tableau Data Source Page; use the pivot tool to prepare data for extraction into the Tableau Data Engine, and filter data at the data source level. Delve into managing data sources in a Tableau workbook; replace data sources from the Data Source Page and worksheet view in Tableau Desktop, and refresh live data sources. The course concludes by helping learners discover how to append data to extracts.

Once you have defined the data set that you want to use in your Tableau Desktop workbook, you can move on to building your visualizations [vizzes]. In this 11-video course, you will learn how to navigate within the Tableau workspace and use shelves, pages, and cards. Begin by discovering how the Tableau worksheets workspace is organized; then explore the purpose of shelves, cards, and marks when building vizzes in Tableau Desktop. Learn how to connect to multiple data sources and use the relationship tool to demonstrate automatic blending in Tableau, and how to implement manual blending, by manually editing and troubleshooting field relationship settings when blending data in Tableau Desktop. This leads into learning how to blend and work with geocoded data in Tableau, and create and manage worksheets in Tableau. Delve into saving data connections and sources in TDS format; work with packaged workbooks and sources; and work with Tableau bookmarks. The course concludes by demonstrating how to import worksheets, dashboards, and workbook contents into a file in Tableau Desktop.

Data are essential to what you want to build in Tableau Desktop, so this 11-video course will help you get the most out of it by using the Data pane and everything that it offers. Begin by finding and managing fields, and then sorting and grouping fields in the Data pane. This leads learners into learning how to work with dimensions and measures, and discrete and continuous data; how to use marks and controlling how dimensions and measures are used in a view; and how to set up default aggregation for a measure and default number format for data and number fields. Examine how to create, edit, and remove dynamic and fixed sets; configure, manipulate; and combine sets in a view, and create and use bins, all in Tableau Desktop. Delve into creating hierarchies from fields to enable quick drill-down between levels, and assigning geographic roles to fields in order to use the roles to create a map view. To conclude the course, discover how to create fields and use them in Tableau view.

Visualizations [vizzes] are a fundamental tool in analyzing the data that you have imported and prepared in your workbooks. In this 10-video course, explore Tableau Desktop's graphic and chart styles, build views, create charts, and use tools such as dynamic filters, groups, and reference lines. Begin by creating a basic view to explore data in Tableau Desktop, then create vertical and horizontal bar charts to compare data across identified categories. This leads into creating box plots to depict the distribution of values and configuring whiskers to display all points at the maximum extent of data. Also, observe how to create and configure maps that show quantitative values for individual locations, and create a scatter plot and trend lines to visualize and compare relationships between numerical variables. Create dual-axis charts by using both number and date fields; create a histogram to show data distribution, and create and use groups from fields in the Data pane. You will complete the course by using dynamic filters, and working with advanced analytic tools.

Generally speaking, the ultimate goal of analyzing data is to be able to communicate any interesting relationships that you have found. In this 10-video course, learners will discover how Tableau's analysis tools can further data analysis and communicate those relationships. Share your findings by observing how to create dashboards with interactive tools and exploring data. Begin by using Explain data to inspect, uncover, and evaluate marks in a visualization [viz] while building, exploring, and analyzing data. Next, examine how to display multiple diversified measures on multiple rows by using Tableau Desktop; create Tableau dashboards to bring visualizations together and create interactive applications; and configure dashboard layouts to support different types of devices. This leads into creating parameters and applying filtering in Tableau; performing total calculations to summarize data for analytics; embedding visualizations within tooltips, and adding dashboard extensions and using them in dashboard layouts. Conclude the course by learning how to export Tableau data to a CSV [comma separated values] or database file, and how to highlight data to provide descriptions for dashboard elements.

Performing calculations is one of the most essential parts of analysis in Tableau. Calculations allow you to manipulate your data in ways that standard tools cannot. In this 10-video course, learners will explore ways to manipulate various data types with a number of different functions and calculations to solve a wide range of problems. Begin by working with the string functions and using the Calculated Field window, and then work with the date functions by using the Calculated Field window. Use quick table calculations to quickly apply common table calculations to visualizations; create simple LOD [level of detail] expressions and use them in visualizations; and observe the use of EXCLUDE and FIXED LOD expressions in calculations. Discover how to perform ad-hoc calculations; configure aggregate and disaggregate options, and perform logical calculations. The course concludes by focusing on the use of arithmetic and aggregate calculations, and using join calculations to work with data where common fields are missing in the two sources.

Tableau Desktop's geographic data tools allow you to perform robust analysis on your map views. In this 10-video course, learn how to work with geographic data in which Tableau recognizes location names or create maps from spatial files. Also, observe how to use a variety of tools to configure maps to suit your data. Begin by learning how to use the selection tools with map visualizations; create choropleth maps to depict ratio or aggregated data in Tableau Desktop; and examine the steps involved in creating maps by using spatial files and geodatabases. Discover how to create maps from shapefiles; create density heat maps; and work with background maps and setting default background maps in Tableau Desktop. Learn how to group existing locations together to create custom territories or regions; use Google Maps to quickly generate directions to the points identified in a map, and explore how to create map views by using Mapbox maps. Conclude the course by exploring the steps involved in blending two data sources and creating primary groups.

The most effective data visualizations are the ones that clearly communicate their findings. A key part of this communication is formatting. In this 10-video course, learners discover how Tableau Desktop provides a wide range of formatting tools that can be used to change a view's style, and ultimately increase its interpretability. Begin by learning how to use the formatting tools in Tableau Desktop to control formatting at a workbook level, and then use them to customize formatting options in worksheets, dashboards, stories, and individual objects. You can also use the tools to customize the appearance of tables and graphic lines. Discover how to add reference bands to continuous axes in a view; create distribution bands to add reference distributions with two or more values; and examine how to create bullet graphs. You will then learn how to add box plots to continuous axes in a view; use nested table calculations in a view, and explore the process of creating clusters with sample data. Finally, take a look at working with forecasts and prediction intervals.

Once you have finished analyzing your data in Tableau Desktop, it is time to present your results and share your insights with the world. In this 11-video course, learners will discover how Tableau has a number of ways with which one can share findings; compiling sheets into dashboards or stories, and then implementing actions to better communicate one's information. To begin, explore how to add and remove objects from dashboards, and also how to use multiple views to filter other views in order to implement multi-master dashboards. Learn how to use URL actions to create links in vizzes [visualizations]; use e-mail actions to start new e-mail conversations from a viz, and create set actions in Tableau Desktop to make them available in Tableau Online and Tableau Server. Discover how to define advanced highlight actions; create stories and add story points in Tableau Desktop, and adjust the controls and layout in stories in Tableau Desktop. Explore how to use presentation mode; control your workbook performance, and finally, print and export vizzes.

To become a data science expert, you must master the art of data visualization. This 12-video course explores how to create and use real time dashboards with Tableau. Begin with an introduction to real-time dashboards and differences between real time and streaming data. Next, take a look at different cloud data sources. Learn how to build a dashboard in Tableau and update it in real time. Discover how to organize your dashboard by adding objects and adjusting the layout. Then customize and format different aspects of dashboards in Tableau and add interactivity using actions like filtering. Look at creating a dashboard starter, a prebuilt dashboard that can be used with Tableau Online to connect to cloud data sources. Add extensions to your dashboard such as the Tableau Extensions API (application program interface). Explore how to put together a simple dashboard story, which consists of sheets-each sheet in sequence is called a story point-and how to share a dashboard in Tableau. In the concluding exercise, learners create a dashboard starter.