AI | Data Analytics | Data Engineering | Data Science | DEVOPS | Cyber Security
Microsoft Certified: Fabric Analytics Engineer Associate
As a Fabric analytics engineer associate, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.
Tableau Certified Data Analyst
A Tableau Data Analyst enables stakeholders to make business decisions by understanding the business problem, identifying data to explore for analysis, and delivering actionable insights. Be sure to review the full details of the Tableau Certified Data Analyst Exam Prep Guide before registering. There are no required prerequisites for this exam.
Microsoft Certified: Azure Enterprise Data Analyst Associate
Microsoft Certified: Azure Enterprise Data Analyst Associate
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Tech. Stack Covered
HANDS-ON PROJECTS COVERED
Employee Performance Metrics
Healthcare Claims Fraud Detection
Inventory Management Analytics
Objective
This project focuses on developing a system that evaluates and predicts employee performance using historical performance data, incorporating employee metrics through data analytics techniques.
Dataset Overview and Data Preprocessing
The dataset consists of employee performance data, including work output, attendance, engagement levels, feedback, and managerial assessments. Preprocessing involves:
- Detecting patterns and outliers in employee performance data.
- Incorporating managerial views, including performance reviews and rating.
- Labeling employees as high performers, average performers, or underperformers based on both quantitative metrics and managerial feedback.
Inventory Management Analytics
Healthcare Claims Fraud Detection
Inventory Management Analytics
Objective
The objective is to create an interactive dashboard that comprehensively views inventory levels, turnover rates, and reordering triggers, and reordering triggers using Power BI practice projects
Dataset Overview and Data Preprocessing
- The dataset includes inventory data with product details, stock quantities, reorder thresholds, and sales history.
- Columns may include Product ID, Current Stock, Reorder Level, and Sales Quantity.
- Preprocessing involves calculating stock turnover rates and creating calculated columns for reorder suggestions.
Healthcare Claims Fraud Detection
Healthcare Claims Fraud Detection
Healthcare Claims Fraud Detection
Objective
The goal of this project is to develop a system that identifies fraudulent healthcare claims by analyzing historical claims data using data analytics techniques.
Dataset Overview and Data Preprocessing
The dataset consists of healthcare claims data containing information about medical procedures, diagnoses, and billing amounts. The preprocessing steps include:
- Detecting anomalies within the data.
- Generating features to capture claim patterns.
- Labeling claims as either legitimate or suspicious.
COURSE CURRICULUM
- Basic SQL Concepts
- Data Querying, Modifying Data
- Constraints and Indexing, Aggregate Functions
- Joins, SET Operations
- Subqueries, CTEs and Pivoting Data
- Views, Stored Procedures and Functions
- Triggers
- Optimization Techniques
- Transactions and Concurrency Control
- Indexes and Performance Tuning
- Interview Preparation (50 most frequently asked Questions)
- Basic Python Syntax and Programming Concepts
- Data Collection and Cleaning
- Data Manipulation with Pandas
- Numerical Computations with NumPy
- Data Visualization Libraries and Advanced Visualization Techniques
- Plotly for Interactive Visualizations
- Fetching Data from Different Sources
- Interview Preparation (50 most frequently asked Questions)
- Introduction to Power BI, Getting Data into Power BI
- Power Query Editor
- Transforming and Cleaning Data (Power Query)
- Tables and Relationships
- Star and Snowflake Schemas
- Calculated Columns vs. Measures
- Drill-through and Drill-down
- Bookmarks and Tooltips
- Data Modeling in Power BI
- Advance DAX (Data Analysis Expressions)
- Visualizations in Power BI
- Row Level Security
- Incremental Refresh
- Dataflow, Datasets and Datamart.
Doubts ? Chat with the domain experts right now