Entries by sciencegeek_admin

How to Overclock Any Raspberry Pi

There’s free, extra performance buried inside your Raspberry Pi. Just as you can overclock a PC, increasing its CPU speed above stock, you can overclock any model of Raspberry Pi .  In fact, on newer models, you can not only turn up the Raspberry PI’s CPU speed, but also its GPU speed. https://www.tomshardware.com/how-to/overclock-any-raspberry-pi

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

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/