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 33 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
Tutorials
AMA's
Beginner? Start Here
Advance Your Career
Success Stories
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
Merging Datasets in Excel preview
July 21st, 2023 ·14 min read
Merging Datasets in Excel

Want to merge large datasets across multiple sheets - without using VLOOKUP or Power BI? Learn how, with Excel + Power Query in this step-by-step tutorial.

Travis CuzickTravis Cuzick
Tutorials
Data Analytics
Time-Series Forecasting With Facebook Prophet preview
May 2nd, 2023 ·17 min read
Time-Series Forecasting With Facebook Prophet

Business is all about numbers, but a lot of people make decisions with their gut. Remove the guesswork and predict the future with Facebook Prophet instead!

Diogo ResendeDiogo Resende
Tutorials
Machine Learning & AI
Data Analytics
The Excel Data Model: What Is It & How To Use It preview
April 14th, 2023 ·14 min read
The Excel Data Model: What Is It & How To Use It

With the ability to process millions of rows of data, the Excel Data Model is one of the most powerful tools in the beginner BI toolbox. Here's how to use it.

Travis CuzickTravis Cuzick
Data Analytics
Top 5 Reasons To Become A Business Intelligence Analyst preview
April 3rd, 2023 ·12 min read
Top 5 Reasons To Become A Business Intelligence Analyst

If you enjoy numbers, problem-solving, and finding out WHY things happen, then becoming a Business Intelligence Analyst might be the perfect new role for you!

Travis CuzickTravis Cuzick
Data Analytics
Machine Learning & AI
Data Engineer vs Data Analyst vs Data Scientist - Which Is Best for Me? preview
March 10th, 2023 ·15 min read
Data Engineer vs Data Analyst vs Data Scientist - Which Is Best for Me?

Data is HOT right now. Great salaries, 1,000s of job opportunities, exciting + high-impact work. But what are the differences and which role is best for you?

Diogo ResendeDiogo Resende
Data Analytics
Machine Learning & AI
Top 7 SQL Project Ideas (+ Code) To Level-Up Your Skills This Year preview
December 6th, 2022 ·7 min read
Top 7 SQL Project Ideas (+ Code) To Level-Up Your Skills This Year

Quality over quantity... we give you the only 7 SQL projects (+ our top 3) that you need to boost your SQL skills, confidence, and portfolio!

Mo BinniMo Binni
Data Analytics
Career Advice

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.