Other · Data Analytics

Data Analytics Fundamentals Notes – Excel, SQL, Statistics and Dashboards for Beginners

• PDF · 135 KB
• 2 downloads
• English

Data Analytics fundamentals notes for students and graduates preparing for data analyst certifications, internships and entry-level jobs. Covers the analytics process, data types and cleaning, Excel essentials including formulas, lookups, pivot tables and charts, SQL querying with filtering, aggregation, joins and window functions, descriptive statistics, correlation and basic hypothesis testing, data visualisation and dashboard design principles, and a portfolio project plan, with examples that can be practised on any free dataset.