Boost Collaboration in Power BI Desktop Using GitHub Integration
Boost Collaboration in Power BI Desktop Using GitHub Integration Source Control + Versioning + Team Collaboration = Better BI Development Introduction In the evolving world of data analytics, collaboration and version control have become essential. Power BI has long been a go-to tool for building ...
This is part 1 in my series on writing modern idiomatic pandas.
Modern Pandas
Method Chaining
Indexes
Fast Pandas
Tidy Data
Visualization
Time Series
Scaling
Effective Pandas
Introduction
This series is about how to make effective use of pandas, a data analysis library for the Python programming language.
It’s targeted at an intermediate level: people who have some experience with pandas, but are looking to improve.
Prior Art
There are many great resources for learning pandas; this is not one of them.
For beginners, I typically recommend Greg Reda’s 3-part introduction, especially if they’re familiar with SQL. Of course, there’s the pandas documentation itself. I gave a talk at PyData Seattle targeted as an introduction if you prefer video form. Wes McKinney’s Python for Data Analysis is still the goto book (and is also a really good introduction to NumPy as well). Jake VanderPlas’s Python Data Science Handbook, in early release, is great too.
Kevin Markham has a video series for beginners learning pandas.
Python Pandas DataFrame: load, edit, view data | Shane Lynn
It's difficult starting out with Pandas DataFrames. Learn how to load, preview, select, rename, edit, and plot data using Python Data Frames in this post.
History of artificial intelligence | Dates, Advances, Alan Turing, ELIZA, & Facts | Britannica
This article covers the history of artificial intelligence from its beginnings with the work of Alan Turing to advancements at the turn of the 21st century.
This article is about the state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or Fabri
A few thoughts about newsletter #300 and AI - SQLBI
Newsletter #300 is a significant milestone for SQLBI: it marks nearly 12 years of sending our updates every two weeks. I thought this was a good time to cla
Using Joins and Group Bys the right way for data warehousing
Joins represent the denormalization of data to create dimensions and add dimension attributes to fact tables for reporting. Group bys enable the creation of metrics that determine how your data is used to make decisions.
If you have wondered
Why do your joins often end up in a dense block that's hard to pick apart.
Why are people running nearly identical queries with only different join combinations.
How to avoid losing data when performing joins
How group bys have been used to mask underlying data modeling issues
Why a group by all is considered a red flag
Then this post is for you. In this post, we will cover how to use joins and group bys, as well as what to look out for when using them.
By the end of this post, you will know what to watch out for when you perform joins or group bys.
Electric Vehicle Population Data - Comma Separated Values File - Catalog
This dataset shows the Battery Electric Vehicles (BEVs) and Plug-in Hybrid Electric Vehicles (PHEVs) that are currently registered through Washington State Department of Licensing (DOL).
SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you
The context transition in DAX is the transformation of row contexts into an equivalent filter context performed by CALCULATE and CALCULATETABLE. Managing th
6 Easy And Actionable Steps On How To Design A Database
Whether it's for your workplace or home project, learning how to design a database is a valuable skill. Let's take a look at six easy steps on how to design a …