Course Content

Introduction to data and Information
a. What is Data and analytics b. Information analysis with data c. Gearing Up for data analysis

Organize and Analyze Data to drive decision making
a. Sorting and filtering data b. Cell referencing methodology and using define name c. Data Validation and formatting data d. Using logical functions (IF, SUMIF, COUNTIF, IF, COUNTIF) e. Putting It All Together

Summarizing data using micro-Analysis
a. Data summary using VLOOKUP, Hookup b. What if analysis c. Index match d. Introducing Chart features (data item and values)

Analyzing and interpreting Data using pivot data and charts
a. Creating and managing pivot table reports b. Customizing pivot table reports c. Data filtering in Pivot tables d. Creating and disconnecting slicers e. Building responsive Dashboards

Introduction To Inferential Statistic
a. Understanding the need for statistics in data analytics b. Distinctions of Data c. Descriptive statistics(roles) d. Data types in inferential statistics e. Identify and describe the scales of measurement f. Working with standard statistical measures g. Test Your Knowledge so far

Data Visualization and interpretation
a. Identify data representation b. Data representation using categorical and numeric data c. Data presentation using charts d. Test Your Knowledge so far

Regression analysis (prediction & forecast)
a. Understanding the concept of Regression b. Methods of regression c. Relevance of R square in regression d. Working with single and multivariate regression e. Concept of prediction and forecast f. Test Your Knowledge so far

Causality and Correlation
a. Understanding causality and correlation b. How to measure correlation and causality c. Managing incorrect correlation d. Principles of recommender’s engines e. Test Your Knowledge so far

Statistical analysis using Parametric and Non-Parametric Tests
a. Identify and describe the types of errors b. Power of statistical testing c. Hypothesis Testing d. Hypothesis Testing methodology e. Test Your Knowledge so far

Data, Databases, schemas and database management system
a. What are databases? b. Relational database management system (RDBMS) c. How create, select, backup and delete a database d. Saving queries in SQL server

Managing database and tables
a. Data types in SQL b. SQL operators c. Introduction to tables and records d. SQL constraint e. Data definition language (DDL) f. Data Query language (DQL) g. Data manipulation language (DML) h. SQL VIEWS i. SQL injection

Retrieving data in SQL server
a. Where clause b. SQL like c. Data retrieval using IN, Between, SQL All, Any, Having, Exist, and SQL AND, OR, NOT d. SQL joins e. SQL union f. Stored procedures g. Transactions h. Batches and triggers

Sorting records
a. Order by b. Distinct keyword c. Top keyword d. Offset and fetch e. % wildcard f. Underscore wildcard

Functions
a. String functions b. Aggregate Functions c. Scalar functions d. Date and time functions e. Conditional functions f. Conversion function

Subqueries
a. Subquery with select statement b. Subquery with insert statement c. Subquery with update and delete statement

Creating and formatting a table visualization with PowerBI
a. Visualizations b. Viewing data c. Focus mode and Different visualization d. Saving visualization to the Desktop and to the Power Bl service e. Customize visualization i. Formatting font and font size ii. Formatting colors iii. Stylistic options iv. Position visuals v. Align visuals vi. Format Painter vii. Configuring summarization, both default and in a specific visualization viii. Changing number and date formatting ix. Custom number and date formatting

Creating different visualizations: Matrices and bar charts
a. Data Matrix b. Drill down data, see data and records, and export data c. Stacked bar charts and switch for reports i. Bar Chart formatting ii. Clustered and 100% Stacked bar charts d. Line and area charts e. Combo charts (Line and column charts)

Adding more control to your visualizations
a. Adding Text boxes, Images and Shapes b. Visual level, page level and report level filters - basic filters c. Advanced Filtering d. Slicer e. Sort visuals f. Configure small multiples g. Group and layer visuals by using the Selection pane h. Buttons and Actions i. Natural Language Queries and Page Formatting

Getting Data
a. Sort and Filter b. Split Column c. Merge Queries and Expand Table d. Merge Queries with Group By, and different types of Joins e. Appending two queries together f. Appending three or more queries together + resolving a problem with data types

Creating a Data Model
a. Modeling and DAX functions b. Get multiple data sets, and connecting them together c. The problems with direction of relationships between data sets

Introduction to DAX functions, including Logical functions
a. DAX functions - A useful Resource b. Calculated columns - an introduction c. Basic operators d. IF, BLANK and ISBLANK e. AND, OR and NOT

Dashboards
a. Differences between dashboards and reports b. Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options c. Dashboards: Options d. Configure Subscriptions e. Pin a Live Report Page to a Dashboard f. Use the Q&A Feature g. Add a Dashboard Theme h. Apply or Change Sensitivity Labels i. Configure Data Alerts

Student Ratings & Reviews

No Review Yet

Data Analysis

What Will You Learn?

Course Content

Introduction to data and Information
a. What is Data and analytics b. Information analysis with data c. Gearing Up for data analysis

Organize and Analyze Data to drive decision making
a. Sorting and filtering data b. Cell referencing methodology and using define name c. Data Validation and formatting data d. Using logical functions (IF, SUMIF, COUNTIF, IF, COUNTIF) e. Putting It All Together

Summarizing data using micro-Analysis
a. Data summary using VLOOKUP, Hookup b. What if analysis c. Index match d. Introducing Chart features (data item and values)

Analyzing and interpreting Data using pivot data and charts
a. Creating and managing pivot table reports b. Customizing pivot table reports c. Data filtering in Pivot tables d. Creating and disconnecting slicers e. Building responsive Dashboards

Data Visualization and interpretation
a. Identify data representation b. Data representation using categorical and numeric data c. Data presentation using charts d. Test Your Knowledge so far

Regression analysis (prediction & forecast)
a. Understanding the concept of Regression b. Methods of regression c. Relevance of R square in regression d. Working with single and multivariate regression e. Concept of prediction and forecast f. Test Your Knowledge so far

Causality and Correlation
a. Understanding causality and correlation b. How to measure correlation and causality c. Managing incorrect correlation d. Principles of recommender’s engines e. Test Your Knowledge so far

Statistical analysis using Parametric and Non-Parametric Tests
a. Identify and describe the types of errors b. Power of statistical testing c. Hypothesis Testing d. Hypothesis Testing methodology e. Test Your Knowledge so far

Data, Databases, schemas and database management system
a. What are databases? b. Relational database management system (RDBMS) c. How create, select, backup and delete a database d. Saving queries in SQL server

Managing database and tables
a. Data types in SQL b. SQL operators c. Introduction to tables and records d. SQL constraint e. Data definition language (DDL) f. Data Query language (DQL) g. Data manipulation language (DML) h. SQL VIEWS i. SQL injection

Retrieving data in SQL server
a. Where clause b. SQL like c. Data retrieval using IN, Between, SQL All, Any, Having, Exist, and SQL AND, OR, NOT d. SQL joins e. SQL union f. Stored procedures g. Transactions h. Batches and triggers

Sorting records
a. Order by b. Distinct keyword c. Top keyword d. Offset and fetch e. % wildcard f. Underscore wildcard

Functions
a. String functions b. Aggregate Functions c. Scalar functions d. Date and time functions e. Conditional functions f. Conversion function

Subqueries
a. Subquery with select statement b. Subquery with insert statement c. Subquery with update and delete statement

Getting Data
a. Sort and Filter b. Split Column c. Merge Queries and Expand Table d. Merge Queries with Group By, and different types of Joins e. Appending two queries together f. Appending three or more queries together + resolving a problem with data types

Creating a Data Model
a. Modeling and DAX functions b. Get multiple data sets, and connecting them together c. The problems with direction of relationships between data sets

Introduction to DAX functions, including Logical functions
a. DAX functions - A useful Resource b. Calculated columns - an introduction c. Basic operators d. IF, BLANK and ISBLANK e. AND, OR and NOT

Connect With Us

What Will You Learn?

Course Content

Introduction to data and Information a. What is Data and analytics b. Information analysis with data c. Gearing Up for data analysis

Organize and Analyze Data to drive decision making a. Sorting and filtering data b. Cell referencing methodology and using define name c. Data Validation and formatting data d. Using logical functions (IF, SUMIF, COUNTIF, IF, COUNTIF) e. Putting It All Together

Summarizing data using micro-Analysis a. Data summary using VLOOKUP, Hookup b. What if analysis c. Index match d. Introducing Chart features (data item and values)

Analyzing and interpreting Data using pivot data and charts a. Creating and managing pivot table reports b. Customizing pivot table reports c. Data filtering in Pivot tables d. Creating and disconnecting slicers e. Building responsive Dashboards

Data Visualization and interpretation a. Identify data representation b. Data representation using categorical and numeric data c. Data presentation using charts d. Test Your Knowledge so far

Regression analysis (prediction & forecast) a. Understanding the concept of Regression b. Methods of regression c. Relevance of R square in regression d. Working with single and multivariate regression e. Concept of prediction and forecast f. Test Your Knowledge so far

Causality and Correlation a. Understanding causality and correlation b. How to measure correlation and causality c. Managing incorrect correlation d. Principles of recommender’s engines e. Test Your Knowledge so far

Statistical analysis using Parametric and Non-Parametric Tests a. Identify and describe the types of errors b. Power of statistical testing c. Hypothesis Testing d. Hypothesis Testing methodology e. Test Your Knowledge so far

Data, Databases, schemas and database management system a. What are databases? b. Relational database management system (RDBMS) c. How create, select, backup and delete a database d. Saving queries in SQL server

Managing database and tables a. Data types in SQL b. SQL operators c. Introduction to tables and records d. SQL constraint e. Data definition language (DDL) f. Data Query language (DQL) g. Data manipulation language (DML) h. SQL VIEWS i. SQL injection

Retrieving data in SQL server a. Where clause b. SQL like c. Data retrieval using IN, Between, SQL All, Any, Having, Exist, and SQL AND, OR, NOT d. SQL joins e. SQL union f. Stored procedures g. Transactions h. Batches and triggers

Sorting records a. Order by b. Distinct keyword c. Top keyword d. Offset and fetch e. % wildcard f. Underscore wildcard

Functions a. String functions b. Aggregate Functions c. Scalar functions d. Date and time functions e. Conditional functions f. Conversion function

Subqueries a. Subquery with select statement b. Subquery with insert statement c. Subquery with update and delete statement

Getting Data a. Sort and Filter b. Split Column c. Merge Queries and Expand Table d. Merge Queries with Group By, and different types of Joins e. Appending two queries together f. Appending three or more queries together + resolving a problem with data types

Creating a Data Model a. Modeling and DAX functions b. Get multiple data sets, and connecting them together c. The problems with direction of relationships between data sets

Introduction to DAX functions, including Logical functions a. DAX functions - A useful Resource b. Calculated columns - an introduction c. Basic operators d. IF, BLANK and ISBLANK e. AND, OR and NOT

Student Ratings & Reviews

Connect With Us

Introduction to data and Information
a. What is Data and analytics b. Information analysis with data c. Gearing Up for data analysis

Organize and Analyze Data to drive decision making
a. Sorting and filtering data b. Cell referencing methodology and using define name c. Data Validation and formatting data d. Using logical functions (IF, SUMIF, COUNTIF, IF, COUNTIF) e. Putting It All Together

Summarizing data using micro-Analysis
a. Data summary using VLOOKUP, Hookup b. What if analysis c. Index match d. Introducing Chart features (data item and values)

Analyzing and interpreting Data using pivot data and charts
a. Creating and managing pivot table reports b. Customizing pivot table reports c. Data filtering in Pivot tables d. Creating and disconnecting slicers e. Building responsive Dashboards

Data Visualization and interpretation
a. Identify data representation b. Data representation using categorical and numeric data c. Data presentation using charts d. Test Your Knowledge so far

Regression analysis (prediction & forecast)
a. Understanding the concept of Regression b. Methods of regression c. Relevance of R square in regression d. Working with single and multivariate regression e. Concept of prediction and forecast f. Test Your Knowledge so far

Causality and Correlation
a. Understanding causality and correlation b. How to measure correlation and causality c. Managing incorrect correlation d. Principles of recommender’s engines e. Test Your Knowledge so far

Statistical analysis using Parametric and Non-Parametric Tests
a. Identify and describe the types of errors b. Power of statistical testing c. Hypothesis Testing d. Hypothesis Testing methodology e. Test Your Knowledge so far

Data, Databases, schemas and database management system
a. What are databases? b. Relational database management system (RDBMS) c. How create, select, backup and delete a database d. Saving queries in SQL server

Managing database and tables
a. Data types in SQL b. SQL operators c. Introduction to tables and records d. SQL constraint e. Data definition language (DDL) f. Data Query language (DQL) g. Data manipulation language (DML) h. SQL VIEWS i. SQL injection

Retrieving data in SQL server
a. Where clause b. SQL like c. Data retrieval using IN, Between, SQL All, Any, Having, Exist, and SQL AND, OR, NOT d. SQL joins e. SQL union f. Stored procedures g. Transactions h. Batches and triggers

Sorting records
a. Order by b. Distinct keyword c. Top keyword d. Offset and fetch e. % wildcard f. Underscore wildcard

Functions
a. String functions b. Aggregate Functions c. Scalar functions d. Date and time functions e. Conditional functions f. Conversion function

Subqueries
a. Subquery with select statement b. Subquery with insert statement c. Subquery with update and delete statement

Getting Data
a. Sort and Filter b. Split Column c. Merge Queries and Expand Table d. Merge Queries with Group By, and different types of Joins e. Appending two queries together f. Appending three or more queries together + resolving a problem with data types

Creating a Data Model
a. Modeling and DAX functions b. Get multiple data sets, and connecting them together c. The problems with direction of relationships between data sets

Introduction to DAX functions, including Logical functions
a. DAX functions - A useful Resource b. Calculated columns - an introduction c. Basic operators d. IF, BLANK and ISBLANK e. AND, OR and NOT