COURSE DESCRIPTION
Data Analysis in Excel
Data Fundamentals (Definition & types of data)
Formulas & Cell-Based Calculations
Logical & Lookup Formulas
Pivot Tables
Intro to ETL & Data Modeling
Power Query Data Transformations
Data Visualization in Power BI
Introduction to Data visualization in Power BI
Data Sources & Queries
Data Visualization Basics
Data Visualization Advanced
Dashboard Design & Interactivity
Data Visualization in Tableau
Introduction to Tableau
Data & Data preparation
Charts & Visual Perceptions and Design
Mapping Data
COURSE DESCRIPTION
Data Visualization in Excel
Data Visualization in Power BI
Data Visualization in Tableau
This course provides comprehensive training in charts, dashboards and KPI's in the Excel, Power BI, and Tableau
COMING SOON
COURSE DESCRIPTION
Data Analysis in Excel
Formulas & Cell-Based Calculations
Logical & Lookup Formulas
Text Analysis
Date Manipulation
Pivot Tables
Intro to ETL & Data Modeling
Power Query Data Transformations
Applied Statistics in Excel
What is Statistics & Types of Statistical Analysis
Describing data (Frequency tables, distribution, graphic representation)
Descriptive statistics using data analysis tool pack
Probability concepts (Discrete & continuous probability)
Sampling & Hypothesis tests (One and Two sample test)
Linear & Multiple Regression | Correlation Analysis | ANOVA
Time Series & Forecasting
Data Analysis in Power BI
Power BI Fundamentals
Data Modelling & DAX
Formulas & Calculated Fields
Building Interactive Dashboards
SQL & Databases
Database Fundamentals
Selecting, Manipulating, Filtering Data
Aggregate Calculations
Table Manipulation (Joining and Union)
Advanced Queries / Nested Subqueries
Case Study Project
COMING SOON
COURSE DESCRIPTION
Overview of Power BI and PL 300 Exam
Connecting to Data sources and Profiling Data
Cleansing, Transforming, and Shaping Data
Designing a Data Model
Creating Measures using DAX
Optimizing Model Performance
Creating Dashboards and Reports
Exposing Insights from Data
Performing Advanced Analysis
Cap stone Project
COMING SOON
COURSE DESCRIPTION
Connecting to & Preparing Data
Exploring & Analyzing Data
Sharing Insights
Understanding Tableau Concepts
Capstone Project
Copyright © 2024 Karisofttech - All Rights Reserved.