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 31 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 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
AMA Deep Dive on Data Solutions & VBA Programming preview
October 24th, 2022 ·14 min read
AMA Deep Dive on Data Solutions & VBA Programming

Is VBA programming difficult to learn? Which is better for data analysts: Python or VBA with Excel? Travis Cuzick answers these questions & more in this developer AMA.

Travis CuzickTravis Cuzick
AMA's
Data Analytics
AMA Deep Dive On Data Analytics + Business Intelligence preview
August 5th, 2022 ·12 min read
AMA Deep Dive On Data Analytics + Business Intelligence

Is Data Analytics difficult to learn? How does it help a business? How much does it pay? Diogo Resende answers these questions & more in this developer AMA.

Diogo ResendeDiogo Resende
AMA's
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.