Hackers and Slackers
Hackers and Slackers

Hackers and Slackers

  • About
  • Series
  • Join
  • Donate
  • Log in
  • Subscribe
  • Python
  • Software
  • DevOps
  • Architecture
  • Data Engineering
  • Pandas
  • Data Analysis
  • SQL
  • Data Science
  • REST APIs
  • JavaScript
  • Flask
  • AWS
  • NodeJS
  • Google Cloud
  • Apache
  • Frontend
  • MySQL
  • Data Vis
  • NoSQL
Max Mileaf

Max Mileaf

Down the block from a literal battleship
Former shrink who pulled the biggest career 180 in recent history. Built and run a team specializing in hacking together digital fires in caves, with a bunch of scrap
Microsoft Office 64-Bit

The Level-Up: What I've Learned in the Four Years Since My Last Post

A journey through Power BI, PowerPivot, PowerQuery, XLOOKUP, and all the goodies of 64-bit Microsoft Office.
Max Mileaf
Max Mileaf
Jan 30, 2023 • 10 mins
Excel
PowerPivot 3: Managing the Data Model

PowerPivot 3: Managing the Data Model

Analyzing ginormous files with Microsoft PowerPivot.
Max Mileaf
Max Mileaf
Jun 6, 2019 • 5 mins
Powerpivot
PowerPivot 2: What's the Deal with Delimiters?

PowerPivot 2: What's the Deal with Delimiters?

Working with large flat files in PowerPivot.
Max Mileaf
Max Mileaf
Jun 2, 2019 • 6 mins
Powerpivot
Power to the Pivot Redux: Enter PowerPivot

Power to the Pivot Redux: Enter PowerPivot

Dipping into Microsoft's PowerPivot add-on for Excel.
Max Mileaf
Max Mileaf
May 25, 2019 • 4 mins
Powerpivot
Create an Iterative List in Excel Without Any Real Coding

Create an Iterative List in Excel Without Any Real Coding

Roll On Through: This isn't standard programming... THIS IS EXCEL! We get creative in Excel by making FOR loops without using VBA.
Max Mileaf
Max Mileaf
Sep 13, 2018 • 3 mins
Excel
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamically load data in smart pivot tables.
Max Mileaf
Max Mileaf
Aug 31, 2018 • 7 mins
Excel
Hacker using a Laptop

I Owe My Job to Mr. Robot

A personal origin story about entering the Dataverse inspired by a television series.
Max Mileaf
Max Mileaf
Aug 14, 2018 • 8 mins
Excel
Active-X Gonna Give it to Ya

Active-X Gonna Give it to Ya

Excel offers the ability to name a particular range (or collection of cells). Learn Named Ranges and the Active Xs who Love Them.
Max Mileaf
Max Mileaf
Aug 10, 2018 • 6 mins
Excel
Your Invitation to the Excel Pivot Party

Your Invitation to the Excel Pivot Party

Becoming well-versed in pivot tables to the point where it’s a problem.
Max Mileaf
Max Mileaf
Jul 21, 2018 • 4 mins
Excel
Knife slicing through data

Slicing Excel: The Way of The Knife

Slicing your Excel data to be presentable for the less tech-savvy.
Max Mileaf
Max Mileaf
Jul 5, 2018 • 5 mins
Excel
Page 1 of 3

Tags

Python Software DevOps Data Engineering Architecture Pandas Excel Data Analysis SQL Data Science REST APIs JavaScript Flask Code Snippet Corner AWS NodeJS Google Cloud Frontend MySQL Apache Data Vis BI NoSQL GraphQL Spark PostgreSQL ExpressJS ETL Pipelines Tableau PowerBI SQLAlchemy GatsbyJS Powerpivot Machine Learning Automation Big Data Atlassian Mapbox Golang Scraping JAMStack Data Warehouses Plotly Docker Concurrency Hashicorp Django ReactJS SaaS Products Frameworks Java FastAPI Terraform Microsoft

Newsletter

Create an account to receive occasional updates and interact with the community.

Series'

Data Analysis with Pandas 11
Build Flask Apps 11
Learning Apache Spark 6
Google Cloud Architecture 6
Mastering SQLAlchemy 4
GraphQL Tutorials 4
Welcome to SQL 4
Working with MySQL 4
Mapping Data with Mapbox 3
Web Scraping With Python 2
Python Concurrency with Asyncio 2
Getting Started with Django 2
Hackers and Slackers

Community of hackers obsessed with data science, data engineering, and analysis. Openly pushing a pro-robot agenda.

Navigation

    • About
    • Series
    • Join
    • Donate

Series'

  • Data Analysis with Pandas
  • Build Flask Apps
  • Learning Apache Spark
  • Google Cloud Architecture
  • Mastering SQLAlchemy
  • GraphQL Tutorials
  • Welcome to SQL
  • Working with MySQL
  • Mapping Data with Mapbox
  • Web Scraping With Python
  • Python Concurrency with Asyncio
  • Getting Started with Django

Authors

  • Todd Birchard
  • Matthew Alhonte
  • Max Mileaf
  • Ryan Rosado
  • Graham Beckley
  • David Aquino
  • Paul Armstrong
  • Dylan Castillo
©2023 Hackers and Slackers, All Rights Reserved.