CERT VISUAL ANALYTICS

VISUAL ANALYTICS INTRODUCTION

WHAT IS VISUAL ANALYTICS?

BI VS VISUAL ANALYTICS

VISUAL ANALYTICS EVOLUTION

VISUAL ANALYTICS VS BUSINESS ANALYTICS

DATA-DRIVEN DECISIONS WITH BI TOOLS

The CRISP-DM METHODOLOGY

SELF SERVICE BUSINESS INTELLIGENCE

BI WITH TABLEAU: INTRODUCTION

THE TABLEAU INTERFACE

TABLEAU WORKBOOK, SHEETS AND DASHBOARDS

FILTER SHELF, ROWS AND COLUMNS

DIMENSIONS AND MEASURES

DISTRIBUTING AND PUBLISHING

CONNECTING TO DATA SOURCE

CONNECTING TO DATA FILE, DATABASE SERVERS

MANAGING FIELDS

MANAGING EXTRACTS

SAVING AND PUBLISHING DATA SOURCES

DATA PREP WITH TEXT AND EXCEL FILES

JOIN TYPES WITH UNION

CROSS-DATABASE JOINS

DATA BLENDING

CONNECTING TO PDFS

BUSINESS INSIGHTS WITH VISUAL ANALYTICS

GETTING STARTED WITH VISUAL ANALYTICS

DRILL DOWN AND HIERARCHIES

SORTING & GROUPING

CREATING AND WORKING SETS

USING THE FILTER SHELF

INTERACTIVE FILTERS

PARAMETERS

THE FORMATTING PANE

TREND LINES & REFERENCE LINES

FORECASTING

CLUSTERING

DASHBOARDS, STORIES AND PAGES

DASHBOARDS AND STORIES INTRODUCTION

BUILDING A DASHBOARD

DASHBOARD OBJECTS

DASHBOARD FORMATTING

DASHBOARD INTERACTIVITY USING ACTIONS

STORY POINTS

ANIMATION WITH PAGES

MAPPING

GETTING STARTED WITH MAPPING

MAPS IN TABLEAU

EDITING UNRECOGNIZED LOCATIONS

SPATIAL FILES

EXPANDING TABLEAU'S MAPPING CAPABILITIES

CUSTOM GEOCODING

TABLEAU CALCULATION AND SCRIPTING

CALCULATION SYNTAX

INTRODUCTION TO LOD EXPRESSIONS

MODIFYING TABLE CALCULATIONS

AGGREGATE CALCULATIONS

LOGIC CALCULATIONS

STRING CALCULATIONS

NUMBER CALCULATIONS

TYPE CALCULATIONS

CONCEPTUAL TOPICS WITH LOD EXPRESSIONS

DATE CALCULATIONS

ADVANCED CHARTS

BUMP CHARTS

CONTROL CHARTS

FUNNEL CHARTS

PARETO CHARTS

WATERFALL CHARTS

WEB ANALYTICS WITH TABLEAU

CONNNECTING TO GOOGLE ANALYTICS

CALCULATING BOUNCE RATE

REGIONAL VISITORS TRAFFIC ANALYSIS

ANALYSIS AND FORECASTING BUSINESS

POWERBI INTRODUCTION

WHAT IS POWER BI

WHY POWER BI?

KEY BENEFITS OF POWER BI

FLOW OF POWER BI

COMPONENTS OF POWER BI

ARCHITECTURE OF POWER BI

BUILDING BLOCKS OF POWER BI

POWERBI DATA TRANFORMATION

OVERVIEW OF POWER BI DESKTOP

DATA SOURCES IN POWER BI DESKTOP

CONNECTING TO A DATA SOURCES

QUERY EDITOR IN POWER BI

QUERY RIBBON

CLEAN AND TRANSFORM YOUR DATA WITH QUERY EDITOR

COMBINING DATA – MERGING AND APPENDING

CLEANING IRREGULARLY FORMATTED DATA

VIEWS IN POWER BI DESKTOP

MODELLING DATA

MANAGE DATA RELATIONSHIP

AUTOMATIC RELATIONSHIP UPDATES

TEMPLATE APPS

CROSS FILTER DIRECTION

CREATE CALCULATED TABLES AND MEASURES

OPTIMIZING DATA MODELS

DATA VISUALIZATION WITH POWERBI

CHARTS IN POWER BI

MATRIXES AND TABLES

SLICERS

MAP VISUALIZATIONS

GAUGES AND SINGLE NUMBER CARDS

CREATE SCATTER, WATERFALL, AND FUNNEL CHARTS

MODIFYING COLORS IN CHARTS AND VISUALS

SHAPES, TEXT BOXES, AND IMAGES

WHAT ARE CUSTOM VISUALS?

PAGE LAYOUT AND FORMATTING

KPI VISUALS

Z-ORDER

EXPLORE TIME-BASED DATA

APPSOURCE

REPORT SERVERS

REPORT SERVER BASICS

WEB PORTAL

PAGINATED REPORTS

ROW LEVEL SECURITY

DATA GATEWAYS

SCHEDULED REFRESH

CONFIGURE SCHEDULED REFRESH

CREATE A PUBLISH-TO-WEB EMBED CODE

CUSTOMIZE THE SAMPLE POWER BI FILE

ADVANCED ANALYTICS WITH POWERBI

USING PARAMETERS

CREATE A DATA FLOW

INTRODUCTION TO ANOMALY DETECTION

INTRODUCTION TO SMART NARRATIVE

INTRODUCTION TO SENSITIVITY LABELS IN POWER BI

DEPLOYMENT PIPELINE

BI PROJECT

PROJECT USECASE

STATING CLEARING PROJECT OBJECTIVES

CREATING TABLEAU/POWERBI DASHBOARDS

PROJECT SIGN-OFF