Analysing data empowers you to make better decisions. Data analysis is the term given to the process of evaluating data and translating it into information. It consists of data mining, statistical analysis, business analytics, descriptive and predictive analysis, and big data analytics.
It involves several stages including determining a data set, organising the data for handling, applying evaluation models, deriving key findings and generating reports from the processed data. The main objective of data analysis is to discover understandings that can be used in more effective decision making.
Course Objectives
Upon completing this Data Analysis Training Certification course successfully, participants will be able to:
- Learn about data model creation
- Explore, analyse, and visualise data
- Sift data using slicers in multiple pivot tables
- Produce aggregate reports using formula-based techniques
- Collect and transform data from multiple sources
- Understand and combine data in mashups
- Generate flexible data aggregations using pivot tables
- Exemplify data visually using pivot charts
- Evaluate margins and other popular ratios using calculation on the pivot table
Course Outline
Business Statistics
Introduction to Statistical Analysis
Counting, Probability, and Probability Distributions
Sampling Distributions
Estimation and Hypothesis Testing
Scatter Diagram
Anova and Chisquare
Imputation Techniques
Data Cleaning
Correlation and Regression
Introduction to Data Analytics
Data Analytics Overview
Importance of Data Analytics
Types of Data Analytics
Descriptive Analytics
Diagnostic Analytics
Predictive Analytics
Prescriptive Analytics
Benefits of Data Analytics
Data Visualization for Decision Making
Data Types, Measure Of central tendency, Measures of Dispersion
Graphical Techniques, Skewness & Kurtosis, Box Plot
Descriptive Stats
Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
Excel: Basics to Advanced
Excel tutorial
Text to Columns
Concatenate
The Concatenate Function
The Right Function with Concatenation
Absolute Cell References
Data Validation
Time and Date Calculations
Conditional Formatting
Exploring Styles and Clearing Formatting
Using Conditional Formatting to Hide Cells
Using the IF Function
Changing the “Value if false” Condition to Text
Pivot Tables
Creating a Pivot Table
Specifying PivotTable Data
Changing a PivotTables Calculation
Filtering and Sorting a PivotTable
Creating a PivotChart
Grouping Items
Updating a PivotTable
Formatting a PivotTable
Using Slicers
Charts
Creating a Simple Chart
Charting Non-Adjacent Cells
Creating a Chart Using the Chart Wizard
Modifying Charts
Moving an Embedded Chart
Sizing an Embedded Chart
Changing the Chart Type
Chart Types
Changing the Way Data is Displayed
Moving the Legend
SQL
Introduction to Oracle Database
Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Invoke Conversion Functions and Conditional Expressions
Aggregate Data Using the Group Functions
Display Data from Multiple Tables Using Joins
Use Sub-Queries to Solve Queries
The SET Operators
Data Manipulation Statements
Use of DDL Statements to Create and Manage Tables
Other Schema Objects
Control User Access
Management of Schema Objects
Manage Objects with Data Dictionary Views
Manipulate Large Data Sets
Data Management in Different Time Zones
Retrieve Data Using Sub-queries
Regular Expression Support
Tableau
Module 1: Tableau Course Material
Start Page
Show Me
Connecting to Excel Files
Connecting to Text Files
Connect to Microsoft SQL Server
Connecting to Microsoft Analysis Services
Creating and Removing Hierarchies
Bins
Joining Tables
Data Blending
Module 2: Learn Tableau Basic Reports
Parameters
Grouping Example 1
Grouping Example 2
Edit Groups
Set
Combined Sets
Creating a First Report
Data Labels
Create Folders
Sorting Data
Add Totals, Sub Totals and Grand Totals to Report
Module 3: Learn Tableau Charts
Area Chart
Bar Chart
Box Plot
Bubble Chart
Bump Chart
Bullet Graph
Circle Views
Dual Combination Chart
Dual Lines Chart
Funnel Chart
Traditional Funnel Charts
Gantt Chart
Grouped Bar or Side by Side Bars Chart
Heatmap
Highlight Table
Histogram
Cumulative Histogram
Line Chart
Lollipop Chart
Pareto Chart
Pie Chart
Scatter Plot
Stacked Bar Chart
Text Label
Tree Map
Word Cloud
Waterfall Chart
Module 4: Learn Tableau Advanced Reports
Dual Axis Reports
Blended Axis
Individual Axis
Add Reference Lines
Power BI
Module 1: Introduction to Power BI
Get Started with Power BI
Overview: Power BI concepts
Sign up for Power BI
Overview: Power BI data sources
Connect to a SaaS solution
Upload a local CSV file
Connect to Excel data that can be refreshed
Connect to a sample
Create a Report with Visualizations
Explore the Power BI portal
Module 2: Viz and Tiles
Overview: Visualizations
Using visualizations
Create a new report
Create and arrange visualizations
Format a visualization
Create chart visualizations
Use text, map, and gauge visualizations and save a report
Use a slicer to filter visualizations
Sort, copy, and paste visualizations
Download and use a custom visual from the gallery
Module 3: Reports and Dashboards
Modify and Print a Report
Rename and delete report pages
Add a filter to a page or report