Published inBetter Programming·PinnedHow to Read from and Write to Amazon S3 in PolarsHow do you work with Amazon S3 in Polars? Amazon S3 bucket is one of the most common object stores for data projects. Polars is a fairly new technology. There are only a few resources that explain how to work with S3. In this article, I’ll walk you through reading…Data Science3 min readData Science3 min read
Oct 24A Complete Guide to Git Integration in Power BIA step-by-step tutorial to get started with Git integration in Power BI A game changing feature came out this year. It’s the native Git integration in Power BI. It’s the feature that so many Power BI professionals have been waiting for. Previously, we still had a solution for implementing version…Power Bi9 min readPower Bi9 min read
Sep 8How to Convert String to Date or Datetime in PolarsIntroducing some ways to convert string to date/datatime We’ve all been there. You get your data and start analyzing it then you realize a date column is actually set to string data type. Whether that’s because the issue in the data source or your program didn’t read it right, it’s…Python5 min readPython5 min read
Jun 30Aggregations Over Multiple Columns in PolarsAggregations such as sum and mean are frequently used in data science and analysis. There are cases where you might want to aggregate values over columns instead of rows. Meaning that if you have two columns A and B, you want to aggregate values on horizontally (columns), not vertically (rows). …Data Science7 min readData Science7 min read
Jun 16Handling Missing Values in PolarsChecking and filling missing values is an important piece in data science and analytics projects. A popular dataframe library, pandas, provides a method like fillna(), for example. Polars has built-in methods and expressions to work with missing values as well. …Data Science5 min readData Science5 min read
Jun 7LazyFrame vs DataFrame in Polars — Performance ComparisonOne of the features in Polars is LazyFrame. Polars is fast as is, and LazyFrame gives you even more optimizations. But you may wonder, “How is it different from the typical DataFrame or EagerFrame?” or “What is LazyFrame in the first place”? What is LazyFrame in Polars In order to understand LazyFrame, it’s good to…Polars5 min readPolars5 min read
Jan 25Best Data Visualization Books You Should ReadBooks that get your data viz skill to the next level — There are many books on data visualizations. But here is a list of books that I read or are sitting on my book shelf. Honestly speaking, every single data visualization book I read was worth reading. And these books are not randomly selected. …Data Visualization5 min readData Visualization5 min read
Jan 19What is Self-Service Analytics?What is self-service analytics? Self-service analytics a new way of doing analytics where business users are enabled to access data to generate insights on their own. In a traditional analytics process, requests are handled by a centralized data/BI team. With self-service analytics, the IT or centralized data team works on more complex tasks because…Analytics3 min readAnalytics3 min read
Jan 15Refresh Tables and Partitions in Power BI Using SSMSIt’s usually the case that you refresh Power BI datasets/semantic models in the Power BI service. But there are cases when you want to refresh a table or partition individually. You can do that with XMLA endpoint and SSMS. What is the XMLA endpoint? To put it simply, it’s a connection endpoint through which you…Power Bi5 min readPower Bi5 min read
Nov 22, 2022How to Work with Semi-Additive Measures in DAX — Power BIWhat does it mean by “Semi-Additive”? In order to understand the concept of semi-additive measures, you need to understand what fully-additive measures are. A good example of a fully-additive measure is “Sales” in a sales table. It can be summed or aggregated across any dimension/field such as “Date”, “Product”, or “Store”. …Power Bi5 min readPower Bi5 min read
