Data Analytics 3.0: Big data, Data Value Chain, Tableau
ENDED
Training by
DMAI
Inquire Now
On-Site
/ Training
PHP 21,900.00
Details
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.
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.
Outline
DAY ONE LECTURER: MR. DAN MEYER
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.
DAY TWO LECTURER: MR. DOMINIC LIGOT
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.
DAY THREE: TABLEAU
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.
MINUMUM HARDWARE AND SOFTWARE REQUIREMENTS:
Laptop with Intel Core i3 and 4GB RAM.
Windows OS with Excel 2007 or greater.
ODBC and database connections will be provided during class.
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.
DAY TWO LECTURER: MR. DOMINIC LIGOT
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.
DAY THREE: TABLEAU
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.
MINUMUM HARDWARE AND SOFTWARE REQUIREMENTS:
Laptop with Intel Core i3 and 4GB RAM.
Windows OS with Excel 2007 or greater.
ODBC and database connections will be provided during class.
Special Offer
EARLY BIRD RATE (Pay on or before Jan 20):
P18,000+VAT
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: [email protected] or call at (02) 959-8017 or 0917-799-2827.
P18,000+VAT
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: [email protected] or call at (02) 959-8017 or 0917-799-2827.
Reviews
Be the first to write a review about this course.
Write a Review
DMAIPH is a global Business Consulting, Outsourcing and Analytics Training Company based in Pasig City, Philippines. DMAIPH aids both medium and small companies in the US and the Philippines by offering assistance on sourcing initiatives.
We also provide innovative analytics solutions to help business gain more profit and to run at an optimal level. Through our practical experience based training program, we empower top of the line analytical talent.
DMAI specialized in bringing analytics and data-driven decision making to its client’s businesses.
