Data Analyst Diploma: Data Analysis with Python, Microsoft Excel, SQL, Power BI, ML
Ziarat, Pakistan
Course Description
Data Analyst Diploma: Data Analysis with Python, Microsoft Excel, SQL, Power BI, ML
Description
Begin your journey with Apex Learning right away!
The bundle incorporates basic to advanced-level skills to shed some light on your way and boost your career. Hence, you can strengthen your Data Analyst (Data Analytics) expertise and essential knowledge, which will assist you in reaching your goal.
★★★ Course Curriculum of Data Analyst Bundle ★★★
➽ Course 01: Diploma in Data Analysis in Excel at QLS Level 5
Module 01: Modifying a Worksheet
Module 02: Working with Lists
Module 03: Analyzing Data
Module 04: Visualizing Data with Charts
Module 05: Using PivotTables and PivotCharts
Module 06: Working with Multiple Worksheets and Workbooks
Module 07: Using Lookup Functions and Formula Auditing
Module 08: Automating Workbook Functionality
Module 09: Creating Sparklines and Mapping Data
Module 10: Forecasting Data
➽ Course 02: Python for Data Visualization: The Complete Masterclass
Module 01: Setup & Installation
Module 02: Plotting Line Plots with matplotlib
Module 03: Plotting Histograms & Bar Charts with matplotlib
Module 04: Plotting Stack Plots & Stem Plots
Module 05: Plotting Scatter Plots with matplotlib
Module 06: Time Series Data Visualization with matplotlib
Module 07: Creating multiple subplots
Module 08: Plotting charts using seaborn
Module 09: Plotly and Cufflinks
➽ Course 03: Data Manipulation in Python: Master Python, Numpy & Pandas
Module 01: Python Quick Refresher (Optional)
Module 02: Essential Python Libraries for Data Science
Module 03: Fundamental NumPy Properties
Module 04: Mathematics for Data Science
Module 05: Python Pandas DataFrames & Series
Module 06: Data Cleaning
Module 07: Data Visualization using Python
Module 08: Exploratory Data Analysis
Module 09: Time Series in Python
➽ Course 04: Data Analytics with Tableau at QLS Level 6
Module 01: Introduction to the Course
Module 02: Project 1: Discount Mart (Sales and Profit Analytics)
Module 03: Project 2: Green Destinations (HR Analytics)
Module 04: Project 3: Superstore (Sales Agent Tracker)
Module 05: Northwind Trade (Shipping Analytics)
Module 06: Project 5: Tesla (Stock Price Analytics)
Module 07: Bonus: Introduction to Database Concepts
Module 08: Tableau Stories
➽ Course 05: SQL Programming Masterclass
Unit 01: Introduction
Unit 02: Setting up Course Tools
Unit 03: Browsing & Filtering Data
Unit 04: Filter Data with AND, OR, NOT Operators
Unit 05: Math Operations
Unit 06: String Concatenation
Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records
Unit 08: NULL, DISTINCT & CASE Statements
Unit 09: Functions in SQL: Multiple-Row Functions
Unit 10: Functions in SQL: Single-Row Functions
Unit 11: Nested Queries
Unit 12: Casting & Data Conversion
Unit 13: Combination Relationships
Unit 14: Joins in SQL
Unit 15: Data Manipulation (DML)
Unit 16: SQL Data Definition Language (DDL)
➽ Course 06: SQL NoSQL Big Data and Hadoop
Module 01: Introduction
Module 02: Relational Database Systems
Module 03: Database Classification
Module 04: Key-Value Store
Module 05: Document-Oriented Databases
Module 06: Search Engines
Module 07: Wide Column Store
Module 08: Time Series Databases
Module 09: Graph Databases
Module 10: Hadoop Platform
Module 11: Big Data SQL Engines
Module 12: Distributed Commit Log
Module 13: Summary
➽ Course 07: Complete Microsoft Power BI
Module 01: Introduction
Module 02: Preparing our Project
Module 03: Data Transformation - The Query Editor
Module 04: Data Transformation - Advanced
Module 05: Creating a Data Model
Module 06: Data Visualization
Module 07: Power BI & Python
Module 08: Storytelling with Data
Module 09: DAX - The Essentials
Module 10: DAX - The CALCULATE function
Module 11: Power BI Service - Power BI Cloud
Module 12: Row-Level Security
Module 13: More data sources
Module 14: Next steps to improve & stay up to date
➽ Course 08: Master Microsoft Power BI in 90 Minutes!
Module 01: Power BI - Introduction
Module 02: Your First Power BI Dashboard
Module 03: Your Advanced Power BI Dashboard With Real Live Data
➽ Course 09: Google Data Studio at QLS Level 3
Section 01: Introduction
Section 02: Google Sheets
Section 03: Google Data Studio
➽ Course 10: Interactive Dashboards with Data Studio
Module 01: Introduction to GDS
Module 02: Data Visualization
Module 03: Geo-visualization
Module 04: A Socio-Economic Case Study
---------------------- And 6 Additional Courses ----------------------
How will I get my Data Analyst (Data Analytics) Bundle Certificate?
After successfully completing the Data Analyst (Data Analytics) course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
PDF Certificate: Free (Previously, it was £9.99*16 = £159)
Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99)
Sign up for this Data Analyst (Data Analytics) Bundle course today and start your journey with Apex Learning.
Career path
This Data Analyst (Data Analytics) Bundle is ideal for those who want to take their development to the next level and fast-track their career in any of the following roles:
Junior data analyst
Data analyst
Senior data analyst
Data analytics manager
Financial analyst
Marketing analyst
Systems analyst
Data scientist
Machine learning engineer
Data analytics consultant
*************************************************For Registration & Information***************************************
Whatsapp: +923O3553O865, 03035530865, +92 3219606785, 3035530865,+92 3315145601
Please Call: +923315145601, 03495021336
Website: www.ipatsedu.com || http://courses.ipatsedu.com || http://diplomas.ipatsedu.com
Email: ipatsedu@gmail.com
IPATS UK CANADA USA & Government recognized Education Institue Rawalpindi, Islamabad
Institute of Professional and Technical Studies (IPATS )
Head Office: 2nd Floor, Yasir Plaza, Near Chatri Chowk, Khanna Pull, Qadeer Road, Rawalpindi, Islamabad
Contact Office: +923O3553O865,03219606785, 03035530865, 0331-5145601, 0349-5021336
Email: ipatsedu@gmail.com || Website: www.ipatsedu.com || http://courses.ipatsedu.com || http://diplomas.ipatsedu.com || http://courses.ipatsedu.com || http://diplomas.ipatsedu.com
