ZTM Blog Library

Welcome to our complete library of 100s of free in-depth guides, step-by-step tutorials, and more to help you learn in-demand skills, get hired, and advance your career.

P.S. Don't forget to subscribe to get the latest posts (and exclusive offers)!

Don't miss our free monthly newsletter to receive new posts, resources, exclusive offers and more 👇
Thanks for signing up. If you don't receive an email shortly, double check your spam box 🙂!

Join 300,000+ tech professionals. Unsubscribe anytime.

Data Analytics

Showing 30 results RESET

Explore:

Show all posts
By Topic
Web Development
Machine Learning & AI
Data Analytics
Cyber Security
DevOps
Design
Career Advice
By Format
Must Read
AMA's
Beginner? Start Here
Advance Your Career
Success Stories
Tutorials
How To Use ‘What-If’ Parameters In Power BI preview
January 29th, 2024 ·15 min read
How To Use ‘What-If’ Parameters In Power BI

Will a discount increase sales or lower them? Find out answers to these questions (and more), before you implement them by using what-if parameters in Power BI.

Travis CuzickTravis Cuzick
Data Analytics
Tutorials
LinkedIn Greykite: What It Is, How It Works, And How To Use It preview
December 20th, 2023 ·20 min read
LinkedIn Greykite: What It Is, How It Works, And How To Use It

Learn how to use LinkedIn Greykite for time-series forecasting, with seasonality, autoregression, change points, growth terms, and more (with code examples)!

Diogo ResendeDiogo Resende
Data Analytics
Tutorials
ARIMA, SARIMA, and SARIMAX Explained preview
December 15th, 2023 ·17 min read
ARIMA, SARIMA, and SARIMAX Explained

Interested in time-series forecasting but confused over ARIMA, SARIMA, and SARIMAX? Learn the difference between each and how to use them (with code examples)!

Diogo ResendeDiogo Resende
Data Analytics
Tutorials
How To Use Power Query: A Beginners Guide preview
December 6th, 2023 ·17 min read
How To Use Power Query: A Beginners Guide

Do you want to transform your raw data into actionable insights? Learn the basics of how to use Power Query, in this step-by-step guide (with examples!).

Travis CuzickTravis Cuzick
Data Analytics
Tutorials
How to use DATEADD for Period-Over-Period Analysis in Excel preview
November 29th, 2023 ·15 min read
How to use DATEADD for Period-Over-Period Analysis in Excel

DATEADD is great for period-over-period analysis (right inside Pivot Tables). And it's easier to use than you think... here's how (with setup, code, examples)!

Travis CuzickTravis Cuzick
Data Analytics
Tutorials
8 Excel Project Ideas To Improve Your Skills + Build Your Portfolio preview
November 22nd, 2023 ·14 min read
8 Excel Project Ideas To Improve Your Skills + Build Your Portfolio

Want to get better at Excel? Then you need to build real-world projects. These 8 project ideas will push your limits! If you can build these, you're a pro.

Travis CuzickTravis Cuzick
Data Analytics
Career Advice
Power BI: Best Practices For New + Experienced Users preview
November 17th, 2023 ·16 min read
Power BI: Best Practices For New + Experienced Users

From my 10+ years of architecting and coding data solutions, these are my recommended best practices for your Dashboard, Data Model, and Workspace in Power BI.

Travis CuzickTravis Cuzick
Data Analytics
How To Use Measures In Excel (With Examples!) preview
October 11th, 2023 ·13 min read
How To Use Measures In Excel (With Examples!)

Why use measures? How about portable, reusable functions, that auto-update in each pivot table, when you update the single source? Learn how in this guide!

Travis CuzickTravis Cuzick
Tutorials
Data Analytics
How To Create User-Defined Functions In VBA (With Examples) preview
August 2nd, 2023 ·17 min read
How To Create User-Defined Functions In VBA (With Examples)

Want to create custom functions (UDFs) in VBA that you can also export as Add-ins for anyone to use? Well, let me walk you through exactly how (with examples).

Travis CuzickTravis Cuzick
Tutorials
Data Analytics

Best Articles. Best Resources. Only for ZTM subscribers.

If you want to be the first to get the next issue of our Monthly Updates and receive other exclusive ZTM content once in a while, subscribe here.

Join 300,000+ tech professionals. Unsubscribe anytime.