Month: July 2020

  • Automatically create measures in Power BI using VS Code

    My last blog introduced the idea of using Microsoft Visual Studio Code to work with Power BI Models. For this article, I build on that idea by showing how you can use a TOM based script to automatically generate measures in your model Power BI (or Azure Analysis Services) model. https://dax.tips/2020/07/30/automatically-create-measures-in-power-bi-using-vs-code/

  • Easy Headless Raspberry Pi Setup

    As outlined in this Raspberry Pi Connect post, it’s very possible to connect to your Raspberry Pi over a local network, and accomplish a wide range of tasks. In fact, as I’ve become more comfortable with the system, this is by far my preferred control method. https://www.embedded-computing.com/home-page/easy-headless-raspberry-pi-setup

  • How to rewrite your SQL queries in Python with Pandas

    Some of us are familiar with data manipulation in SQL but not in Python, we tend to switch frequently between SQL and Python in a project, result in reducing our efficiency and productivity. In fact, we can achieve a similar result of SQL in Python using Pandas. https://towardsdatascience.com/how-to-rewrite-your-sql-queries-in-python-with-pandas-8d5b01ab8e31

  • TinyPilot: Build a KVM Over IP for Under $100

    TinyPilot is my inexpensive, open-source device for controlling computers remotely. It works even before the operating system boots, so I use TinyPilot to install new OSes and debug boot failures on my bare metal homelab servers. https://mtlynch.io/tinypilot/

  • How to Build a Personal Dev Server on a $5 Raspberry Pi

    In this article, you’ll learn how to build a personal dev server by installing Git, Node.js, Rust, and Docker on a Raspberry Pi. The cheapest option costs just $5. Learn how you can get a starter kit ($25) for free here. The Raspberry Pi is a very powerful computer in a tiny package. https://www.freecodecamp.org/news/build-a-personal-dev-server-on-a-5-dollar-raspberry-pi/

  • Setting up a WireGuard VPN on the Raspberry Pi #piday #raspberrypi @Raspberry_Pi

    WireGuard is a new VPN protocol that has recently been going a lot of popularity. There are a couple of advantages to using the WireGuard VPN on your Raspberry Pi over OpenVPN. https://blog.adafruit.com/2020/07/17/setting-up-a-wireguard-vpn-on-the-raspberry-pi-piday-raspberrypi-raspberry_pi/

  • Remote humidity detector

    You need to keep an eye on the humidity level in your crawl space, as it can seriously affect the whole house’s overall health. It’s ideal to be able to do this remotely (given the creepy, sweaty atmosphere of the space), and a Raspberry Pi allows this. https://www.raspberrypi.org/blog/remote-humidity-detector/

  • Get started with Power BI Desktop

    Welcome to the getting started guide for Power BI Desktop. This tour shows you how Power BI Desktop works, what it can do, and how to build robust data models and amazing reports to amplify your business intelligence. https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started

  • Raspberry Pi Gives the Original Xbox a Second Life

    The original Xbox came to North America in 2001, so it’s not surprising that someone who still has the console would have some issues. From aging controllers to broken hard drives, 19 years can be hard on a gaming console. https://www.tomshardware.com/news/raspberry-pi-gives-the-original-xbox-a-second-life

  • Autoviz: Automatically Visualize any Dataset

    Visualization is a technique that is used to visualize the data using different graphs and plots. In data science, we generally use data visualization techniques to understand the dataset and find the relation between the data. https://towardsdatascience.com/autoviz-automatically-visualize-any-dataset-ba2691a8b55a