EXCEL
SYLLABUS
Excel introduction Merging Data
Formulas Adding New Columns
Tables Loading Power Query Data to Excel
Charts Report creation
Essential features Pivot Table options and formatting
Cleaning bad data Power Pivot and DAX
Combining data with Data modeling
VLOOKUP, INDEX MATCH, XLOOKUP Conditional formatting
Basic Maths and Statistics Basics of VBA
Commonly Used Business Metrics ETL (Extract, Transform & Load Data)
(P & L)
Functional Knowledge: Sales
Mean, Median, Mode
User Empathetic Report Design
Variance, Standard Deviation
Sales Analytics
Correlation
POWER BI
SYLLABUS
What is Power BI 2.0 Toggle Button, Tooltip
Basics of Power Query Data Modelling: Star and
Snowflake Schema
Simplified: Profit and Loss Statement
Report Optimization using DAX Studio
Data Warehouse, OLTP vs OLAP,
Data Catalog Build Finance View
Data Exploration Build Sales, Marketing & Supply
Chain View
Fact vs Dimension Tables
Build Key Measures,Calculated Columns
Review Finance View Mockups
15 Design Rules for an Effective Dashboard
Transform Data in Power Query Editor
User Acceptance Test Report
Create Calculated Columns in
Power Query Editor Power BI Service Overview, Report Sharing,
and Apps
Power Query Best Practices
Set Up Automatic Data Refresh
Basics to Advanced DAX
Project Portfolio for Your Resume
M language
Resume Writing Tips
Data Visualisation -
Job Application Tips
Basic to Advanced Charts
Interview Tips
Filter, Slicer, Bookmarks
Interview Preparation Checklist
BUSINESS PROJECT
BUSINESS INSIGHTS 360 Power BI
As part of this complex Power BI project, you will immerse yourself in a project
environment setup. Taking on the role of "Peter Pandey," you will actively learn
and navigate through the project flow, gaining valuable insights and practical
experience in Power BI.
By completing this project, you will:
Expand your knowledge and understanding of the e-commerce industry,
including brick-and-mortar and online retail, as well as key functional areas
like finance, sales, marketing, and supply chain management.
Gain valuable technical skills in setting up project environments using
MURAL, building Power BI dashboards, and utilizing Power BI for data analysis
to drive effective decision-making within a company.
Acquire real-world experience in using Power BI for data analysis and
making informed decisions, which is highly relevant in today's business
world where data-driven decision-making is crucial.
Develop essential soft skills such as stakeholder management and effective
communication, which are vital for success in any business setting.
SQL
SYLLABUS
Install MySQL: Windows Primary Key
Install MySQL: Linux, Mac Foreign Key
Retrieve Data Using Text Query Entity Relationship Diagram - ERD
(SELECT, WHERE, DISTINCT, LIKE) INSERT, UPDATE, DELETE Statement
Retrieve Data Using Numeric Query ETL, Data Warehouse
(BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
OLAP vs OLTP, Data Catalog
Summary Analytics
Fact vs Dimension Table
(MIN, MAX, AVG, GROUP BY)
Star vs Snowflake Schema
HAVING Clause
Data Import
Calculated Columns
Simplified: What is Kanban?
(IF, CASE, YEAR, CURYEAR)
User-Defined Functions
Joins
(INNER, LEFT, RIGHT, FULL,CROSS) Stored Procedures
Join More Than Two Tables Database Views
Subqueries Window Functions OVER
Clause,ROW_NUMBER, RANK,
ANY, ALL Operators DENSE_RANK
Correlated Subquery Database Triggers
Common Table Expression (CTE) Database Events
CTE Benefits & Other Applications User Accounts and Privileges
Entity Relationship Diagram (ERD) Database Indexes
Database Normalization and
Data Integrity
Data Types: Numeric
(INT, DECIMAL, FLOAT, DOUBLE)
Data Types: String
(VARCHAR, CHAR, ENUM)
Data Types: Date, Time
(DATETIME, DATE, TIME, YEAR, TIMESTAMP)
Data Types: JSON, Spatial
(JSON, GEOMETRY)
PYTHON
SYLLABUS
Python Installation - Windows Classes and Objects
Python Installation - Linux Inheritance
Python Installation - Mac Exception Handling
Variables Pandas Introduction and Installation
Numbers Dataframe Basics
Strings Read, Write Excel and CSV Files
Lists Handle NA values
If Condition Group by
For Loop Concat and Merge
Functions Data Exploration
Dictionary and Tuples Data Cleaning
Modules and Pip Data Transformation
File Handling Insights Generation
BUSINESS PROJECTS
TELECOM PROJECT
By completing this project, you will:
Acquire domain knowledge in the telecom industry and provide a
comparison report of KPIs between pre and post-periods of the 5G launch
for an imaginary company "Wavecon".
Understand the significance of data analytics in telecommunications
sector with a specific focus on crucial metrics such as ARPU (Average
Revenue Per User), TAU (Total Active Users), and TUsU (Total Unsubscribed
Users).
Improve your presentation skills through a mandatory presentation, in
which you need to communicate insights to stakeholders and post it on
LinkedIn.