Data Analysis, Dashboards and Visualization - How to create powerful visualizations like a Zen Master
In today’s data economy and disruptive business environment, data is the new oil and data analysis with data visualization is vital for professionals and companies to stay competitive. Data Analysis and developing useful and interactive visualizations which provide insights may seem complex for a non -data professional. That should not be the case, thanks to various BI & data visualization tools. Tableau is one of the most popular one and widely used in various industries by individual users to enterprise roll out.
In this complete hands-on training session (slides, workbooks and data-sets will be distributed in advance), you will learn to turn your data into interactive dashboards, how to create stories with data and share these dashboards with your audience. We will begin with a quick refresher of basics about design and information literacy and discussions about practices for creating charts and storytelling utilizing best visual practices. Whether your goal is to explain an insight or let your audience explore data insights, using Tableau’s simple drag-and-drop user interface makes the task easy and enjoyable.
You will learn to use functionalities like Table Calculations, Sets, Filters, Level of Detail expressions, Animations, predictive analytics using forecast functions and understanding Clustering. You will learn to integrate R and Tableau and how to use R within Tableau. Learn advance charts such as Waterfall charts, Pareto charts, Gantt Charts, Control Charts and Box and Whisker’s plot. You will also learn mapping, using parameters and other visual functionalities.
You will learn about data preparation – joins, blending, union and shaping data using Tableau Prep. We also cover combining data data to create a single stream data source for analysis.
Tableau support multiple data sources and we'll be covering flat files, relational and no sql databases along with SAAS sources like Salesforce, Azure SQL Server and Salesforce
Lastly, enterprise data Visualization workflows, alternative toolsets, deployments, use-case, examples and best practices using zen master techniques.
Outline/Structure of the Workshop
In this workshop, we’ll cover intermediate and advanced tableau functionality:
- Data connectivity -- databases(SQL and NoSQL), flat files and cloud/SAAS sources
- Blending and joins using multiple data sources, web connectors and plugins, Tableau Prep
- Perform data analyses and create graphs from a real-world dataset, using Tableau Public (free to use)
- Deeper Analysis – Trends, Clustering, Distributions, and Forecasting
- Table Calculations, Sets, Filters, Level of Detail expressions, Parameters
- Spatial analytics - Using Maps and Geocoding
- Right and Wrong way to build Dashboards and Best Practices
- Design for Mobile consideration
- Which Tableau product is best for you
- Online, Server, Desktop, Public and Prep
- how to publish workbooks and stories from tableau to online and server
- Tableau for enterprises – how to roll it within your enterprise
- common workflows
- use-cases and references
- Examples of Tableau Stories and Dashboards best practices + Tips
- Dashboard Objects
- Choose Five or Fewer Colors for Your Dashboards
- Common Charts to use
- Include Comparisons for data – time series (annual, quarterly, etc)
- Use Segmentation for visuals
- Design Tips for Enhancing Your Visualizations
- Creating Efficient Workbooks
- Make Beautiful Charts in and Advanced ones - Waterfall, Pareto, etc
- Tableau and R Integration
- Prediction with R and Tableau Using Regression
- Decision trees in Tableau using R
- Tableau and Python
After this training session, you will gain skills to confidently analyze and visualize complex data sets with ease and minimum programming. In short, you will be guided using data sets to build a compelling and convincing story. You will build those stories during the session with best visual practices. This session is for anyone who works with data and is interested in building dashboards and communicate insights about data with stories.
- Create the most important visuals used in business analysis and transform data
- Design business dashboards
- Tell stories with data
- Deliver compelling business analysis
- Share data across groups
- Be fully prepared to examine, and present data for any purpose - scientific data or forecasts about profits/sales,hr,finance
Data Analysts, Business Analysts, Data Scientists, Intermediate to Advanced Users of Data, Professional from any background looking to analyze their own data and create meaningful insights and to communicate to their stakeholders
Prerequisites for Attendees
Software you will need on your laptop for the workshop:
1) Tableau Public: It's free to install, Go to this link and install Tableau Public
2) Tableau Reader: It's free too and can be used to open Tableau worksheets created by others.
3) Install a demo version of Tableau and Tableau Prep, few days before the workshop since it's a 14 day free trial.
4) R and R Studio
schedule Submitted 4 months ago
People who liked this proposal, also liked:
jyotsna mehta - Creating alerts for asthma patients using a machine learning modeljyotsna mehtaFounderKeva Health
schedule 1 month agoSold Out!
Digital health platforms help to create personalized care experiences for patients with chronic diseases. Patient apps can be created as a customizable mobile application with an AI enabled user interface that keeps patients engaged. It provides an intelligent decision support engine that helps patients follow physician recommended guidelines. The platform provides cloud based data driven machine learning models, powerful data analytics, real time insights via dashboards to optimize remote patient monitoring.
Use cases and examples will be shown to the audience for chronic diseases such as asthma. First, dummy data for Asthma app mobile users will be shown. Next, use of external data from other sources will be explained and described. Finally, use of Machine learning approaches will be explained in Predicting risk of asthma attack.
Each example will highlite different datasets and variables used, analytic approaches considered and its pros and cons, and how machine learning can predict and help in reducing visits to the emergency room or hospital for severe asthma patients.
Data includes patients peakflow, zones for asthma (yellow, green or red), symptoms, medications, symptom severity and answers to a 6 question survey (including number of hospital visits, medication change reason etc) all entered by the patient. External data includes air quality data , geographical location and pollen data.
Machine learning methods work by uncovering hidden relationships between the target and features that classify or predict a particular outcome. In the context of telemonitoring via an app, supervised classification algorithms can be used to yield a classifier that distinguishes between a stable disease state and disease trajectory that it is indicative of incipient exacerbation on the basis of patient characteristics collected during a predefined time frame.
Thus, from a machine learning prospective, telemonitoring data collected on a daily basis may be considered as features and each corresponding day's disposition with regard to exacerbation status (yes or no) can be considered as an outcome for predictive modeling. Within this framework, an initial predictive model can be continuously improved with increased numbers of cases.
Examples of classification algorithms for building classification models include: adaptive Bayesian network, naive Bayesian classifier, and support vector machines. The naive Bayesian classifier looks at historical data and calculates conditional probabilities for the class values by observing the frequency of attribute values and of combinations of attribute values. The second algorithm used, adaptive Bayesian network, was based on Bayesian networks, which use a directed acyclic graph consisting of nodes, where each node represents an attribute. Corresponding to each node are instances with conditional probabilities. The conditional probability of an instance is calculated by the relative frequencies of the associated attributes in the training data. The third algorithm we used is a support vector machine algorithm which uses a subset of training data as support vectors. The support vectors are the closest instances to the maximum margin hyperplane, which provides the greatest separation between the classes. The support vectors are determined by constrained quadratic optimization.
A receiver operating characteristic (ROC) will be shown to characterize comparative performance of classifying algorithms for asthma exacerbation prediction resulting from different training data sets . Our study demonstrates significant potential of machine learning approaches using telemonitoring data for early prediction of acute exacerbations of chronic health conditions.