Working with Excel files in Databricks
Working in Databricks, you can read and write Excel files, but you need to pay attention to some pitfalls.
top of page
Chen Hirsh
- Sep 1
- 1 min
A simple code source control for SQL Server
A simple source control for SQL server code objects like views and stored procedures.
Alon Ohayon
- Aug 28
- 3 min
How to display missing months in Power BI charts without showing future dates
When you’re using Power BI, you probably create line charts that show data by month pretty often. It usually works great, but what...
Chen Hirsh
- Aug 25
- 1 min
The mystery of the vanishing variable
A Python variable has vanished! Can you help the confused Data Engineer find out why?
Chen Hirsh
- Aug 18
- 1 min
Ingest Google Analytics data into Databricks
Use Databricks notebook to read and ingest data from Google Analytics.
Chen Hirsh
- Aug 11
- 1 min
How to plan a successful Data Architecture
How to design a data platform for your project? What question should you ask?
Guy Glantser
- Aug 7
- 3 min
Navigating Database Choices for Startups: Relational or NoSQL?
When founding a startup, one of the critical technical decisions you'll face is selecting the right database. This choice can...
Rita Fainshtein
- Jul 20
- 2 min
A Post About Love for Tea, Pies, and Waffles from the Matrix
Let's start with a little riddle. Let's see how much the Brits love their tea What do you think is the percentage of Brits who drink tea...
Rita Fainshtein
- Jul 15
- 2 min
מיונים וסיבוכים ב Power BI
ישנם מקרים בהם יש לנו צורך עסקי – לוגי למיין את הויזואליזציה לפי קטגוריה שלא מופיעה בה. במקרים אלו אנחנו משתמשים בפונקציונליות sort by...
Geri Reshef
- May 29
- 5 min
מה זה Collation וכיצד לעבוד איתו
ה-Collation הוא מאפיין המגדיר אילו תווים נתמכים על ידי עמודות Char או Varchar לסוגיהם, וכיצד מתבצעות ההשוואות בין עמודות טקסטואליות. ...
bottom of page