Data Analytics Essentials Using Python x Power BI @ Manila, Philippines

Name: Data Analytics Essentials Using Python x Power BI @ Manila, Philippines
Start: 2024-07-03T09:30:00+08:00
End: 2024-07-05T17:30:00+08:00
Location: CASUGOL

Schedule

Wed Jul 03 2024 at 09:30 am to Fri Jul 05 2024 at 05:30 pm

UTC+08:00

Location

CASUGOL | Singapore, SG

Learn the core components of Data Analytics, Data Preprocessing, Data Mining, Data Warehousing, and Visualization using Power BI and Python
About this Event

For more information: https://casugol.com/course/dpbi

International Acclaimed Certification. 5-Star Reviews

Suitable for everyone. Learn in an Interactive, Supportive, and Encouraging Environment.

Duration: 3 Days / 24 Hours
Certification: Participants will receive a Certificate of Competency upon successfully completing the course and passing the examination

Course Objective

Acquire the essential knowledge and technical skills on how data analytics can be used by organizations to enhance decision-making and uncover hidden data insights.
Learn the core components of Data Analytics, Data Preprocessing and Cleaning, Data Mining, Data Warehousing, and Visualization using Power BI, and Python Programming

Examination

Participants are required to attempt an examination upon completion of course. This exam tests a candidate’s knowledge and skills related to Data Analytics, Python, and Power BI based on the syllabus covered

Participants are expected to score a minimum of 70% to pass the examination

MODULE 1 - INTRODUCTION TO DATA ANALYTICS

Data Analytics Overview
Concepts of Data Analytics
Importance and Advantages of Data Analytics
Developing / Application of Data Analytics Strategies
Data Analytics Maturity Model
Understanding Descriptive, Predictive and Prescriptive Analytics

MODULE 2 - DIFFERENT TYPES OF ANALYTICS AND APPLICATION

Different Application of Analytics Method
Concepts of Text Analytics and Web Analytics
Data / information architecture
ETL Architecture
What is Data Warehouse?
Business intelligence vs Data Analytics
Application of Analytics in an Organisation

MODULE 3 - DEEP DIVE INTO PYTHON PROGRAMMING FOR DATA ANALYTICS

Introduction to Python Programming
Setting up Python IDE and Programming Environment
Understanding Structure of Python Programming
Python Variables: Integer, Floats, Strings
Using of List vs. Dictionary
Operators and Loops: If-Else, For, While, Break, Continue
Understanding Modules in Python
Popular Python Libraries for Data Analytics (NumPy, Pandas, MatPlotLib, Seaborn)
Data Pre-processing, Data Cleaning, and Data Engineering
Data Visualization using Python Programming

MODULE 4 - DATA MINING PROCESSES FOR DATA ANALYTICS

Fundamentals of Data Mining
Objectives of Data Mining
Key aspects of Data Mining
Concepts of Knowledge Discovery in Databases (KDD)
Models in Data Mining
Data Mining Model vs Statistical Model
Data Mining Processes

MODULE 5 - DATA MINING TECHNIQUES

Different Data Mining Techniques
Data Classification
Clustering Analysis
Regression Analysis
Association Rules
Outliers Analysis
Sequential Patterns
Predictive Analytics

MODULE 6 - DEEP DIVE INTO VISUALIZATION WITH PYTHON

Data Visualization and Data Exploration
Comparison Plots (Line Chart, Bar Chart, Radar Chart)
Relation Plots (Scatter Plot, Bubble Plot, Correlogram, Heatmap)
Composition Plots (Pie Chart, Stacked Bar Chart, Stacked Area Chart)
Distribution Plots (Histogram, Density Plot, Box Plot, Violin Plot)
Geo Plots (Dot Map, Choropleth Map, Connection Map)
Enhancement of Visualization

MODULE 7 - MATPLOTLIB AND SEABORN LIBRARIES IN PYTHON FOR VISUALIZATION

Deep Dive into Matplotlib in Python
Essential Matplotlib Components for Plotting
Basic Plots, Layouts, Images, and Mathematical Expressions using Matplotlib
Introduction to Seaborn in Python
Kernel Density Estimation, Bivariate Distribution, Pairwise Relationships
Multi-plots, Regression Plots, Squarify, and Geospatial Plotting using Seaborn

MODULE 8 - ENABLING PYTHON IN POWER BI

Setup Python integration within Power BI Desktop
Using Python Scripts within Power Query for Data Transformation
Integrating Python Visualizations into Power BI reports
Python-based Machine Learning Models e.g. scikit-learn or TensorFlow, Power BI
Passing parameters from Power BI to Python scripts
Power BI Slicers and Filters with Python
Performance Optimization of Power BI Report
Real-time Data Analysis

Data Analytics using Python x Power BI (DPBI) involves immersive hands-on experiences, thorough utilization of real-world case studies, practical exercises, and collaborative group discussions.

Be Recognized as a CASUGOL Certified Professional

Add Value to your already prolific portfolio with a Certificate of Competency from CASUGOL.

Awarded upon completing and meeting all requirements of the course.