20. février 2018 - 9:00
Partager sur:

DATA Analytics 3.0: Big Data, Data Value Chain and Tableau | Astoria Plaza | mardi, 20. février 2018

Data Rock Stars Dan Meyer (DMAIPH) and Dominic Ligot (Cirrolytix) have joined forces to offer a unique training focusing on both the Analysis and the Management of Big Data.

Attendees will learn how to identify the right data, how data can be efficiently stored, then transformed into a friendly form for analysis, and finally how data analysis can yield insights.

This training will also lightly touch on each aspect of data identification, collection, storage, transformation, and analysis and involve hands-on use of common data management and analysis tools such as Excel, SQL and in depth learning of the tool "Tableau", this is also designed for those with little to no prior experience with these tools.


Section One – Big Data—It’s Not Just Size That Matters
-Understand the 3 T’s of Analytics: Talent, Technique and Technology.
-Describe the importance of effectively, analyzing big data in Business today.
-Develop a Data Map to analyze the Big Data in your Business.
-Recognize when to employ Descriptive, Predictive or Prescriptive Analytics.
-Establish clear objectives when analyzing Big Data.

Section Two – Assess Your Current Analytics Culture
-Define What Is an Analytics Centric Culture.
-Describe the issues and trends in today’s analytics field.
-Discover how to find the most important KPIs.
-Learn how to build better management reports.
-Optimize your use of MS Excel for Big Data Analytics

Section Three – Using Business Intelligence Tools
-An overview of BI Tools.
-Tableau Public Demonstration.
-Discuss the Concept of Data Visualization.
-Build A Business Dashboard Prototype.
-Apply the key elements of Data Storytelling

Section Four – Interpreting your Data and Analysis
-Articulate the importance of accurately interpreting Data.
-Determine how to validate your data analysis.
-Mitigate and analyze Risk, Uncertainty, And Probability.
-Spot patterns and trends through Statistical Analysis.
-Use findings from Big Data to Drive Decisions within your Organization.


Section Five – Presenting the Data Value Chain and Databases
-Discuss the components of The Data Value Chain and the various users and roles involved in transforming data to value: Database and ETL engineers, Data analysts, Business users.
-Learn about basic data architecture and the role of databases in processing data.
-Understand the basics of databases, tables and views.
-Learn about the Structured Query Language (SQL) and SELECT statements.

Section Six – Data Processing with SQL
-Discuss the additional value that can be derived from using SQL for Data Processing.
-Go into detail on various ways of processing and preparing data using SQL.
-Learn about aggregates, conditions, how to join tables, and run queries within queries.

Section Seven – Accessing SQL Tables with Excel
-Learn about Open Database Connectivity (ODBC) and how Excel uses ODBC to connect to external data sources.
-Discover how SQL tables and views can be read by Excel into instant Pivot Tables and Pivot Graphs.
-Understand how changes in database table or view via SQL Inserts, Deletes, and Updates are reflected on Excel.

Section Eight – Performing Analysis of SQL- based data using Excel
-Learn about how SQL data can be dissected using the Data Analysis functions in Excel.
-Talk about form tools and macros that can automate manual reporting.
-Discuss tips for reporting and sharing the results of your analysis.
-Understand how data can be prepared for exceptional storytelling.

At the end of this tableau course, you will be able to:
• Connect to your data.
• Edit and save a data source.
• Understand Tableau terminology.
• Use the Tableau interface / paradigm to effectively create powerful visualizations.
• Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations.
• Represent your data using the following visualization types:
-Cross tabs
-Geographic maps
-Heat maps
-Tree maps
-Pie charts and bar charts
-Dual axis and combined charts with different mark types
-Highlight Tables
-Scatter Plots
-Build dashboards to share visualizations.

Laptop with Intel Core i3 and 4GB RAM.
Windows OS with Excel 2007 or greater.
ODBC and database connections will be provided during class.

EARLY BIRD RATE (Pay on or before Jan 20):

REGULAR RATE (Starting Jan 21):
P21,900 + VAT

All fee includes: Training module, copy of the presentations, AM & PM Snacks, Buffet Lunch and Certificate of Completion.

For Inquiry and Registration, email us at: info@sonicanalytics.com or call at (02) 959-8017 or 0917-799-2827.