Excel for Data Analytics 3

What's inside

Excel for Data Analytics 3: 11 courses, 220 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 11 complete courses, 220 lessons, 222 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Data Modeling Basics: Fact Tables, Dimensions, Keys & Star Schemas
• Competitor Price Monitoring: Price Index, Changes & Promotion Detection
• Forecast Accuracy & Forecast Value Added: MAPE, WAPE, Bias & FVA
• IoT Sensor Data Analysis: Resampling, Thresholds, Drift & Uptime
• Energy Bill & Load Profile Analytics: kWh, Peak Demand & Tariffs
• Education Analytics: Attendance, Grades, Pass Rates & Cohort Progress
• Fraud Detection Rules: Velocity Checks, Rule Scoring & Alert Tuning
• Index Numbers: Laspeyres, Paasche, Fisher & Building a Price Index
• Sample Size & Power Analysis: How Many Observations Do You Need?
• Principal Component Analysis in Excel: Standardise, Covariance, Eigenvectors & Scores
• Data Quality Metrics: Completeness, Validity, Uniqueness, Timeliness & DQ Scorecards

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	592
Series	The Tabellab Workbook, volume 3
Author	Babala Özdemir
Delivery	Instant download after payment