In this post, I’ll explain how to add the current date and time to an existing PySpark DataFrame in a Fabric Notebook. This is particularly helpful when inserting data into a Fabric Lakehouse table, as it allows you to track when each record was added. I’ll walk through an example using a DataFrame to first load some sample data and show how to append a new column with the current timestamp to capture the insertion time.
Continue reading
If you’ve read my previous tutorial on creating Likert Scale and NPS scores in Tableau, you might have found yourself wondering: how can I achieve the same in Power BI? The good news is, Power BI offers a straightforward way to replicate this process while leveraging its powerful visualization and data modeling features.
Continue reading
Be sure to check out my previous article on creating a Likert scale, as we’ll be using the same restaurant survey dataset. However, we won’t be using any of the calculated fields from the Likert scale, so feel free to skip it if you’d like. That said, the final dashboard will feature both the Likert and NPS charts side by side—they always pair well together, don’t you think?
Continue reading
Surveys are powerful tools for gathering feedback and insights, with Likert scales and Net Promoter Score (NPS) being two popular methods for measuring attitudes, opinions, and customer satisfaction. Likert scales assess the level of agreement or disagreement on a statement, while NPS measures customer loyalty by asking how likely respondents are to recommend a product or service.
Continue reading
In the world of databases, SQL is a foundational language that serves as the backbone for interacting with relational databases. However, when delving deeper into SQL, you will come across terms like ANSI SQL and T-SQL, which may seem confusing at first. In this article, we’ll explore what SQL, ANSI SQL, and T-SQL are, how they differ, and their specific use cases.
Continue reading
Power Query is a powerful tool used in Power BI, Excel, and other Microsoft products to clean, transform, and load data. While it simplifies data preparation, users often encounter various errors that can disrupt workflows and hinder progress. Understanding these errors and knowing how to resolve them is crucial for any data professional. In this blog post, we will explore some common Power Query errors, their causes, and practical solutions to fix them.
Continue reading
Ensuring data security and privacy is paramount when dealing with business intelligence and analytics. Tableau, a leading data visualization tool, offers robust features to manage data security effectively. One such feature is Row-Level Security (RLS), which restricts data access for different users based on their roles or attributes. This blog post will guide you through setting up Row-Level Security in Tableau using dynamic user filters.
Continue reading
Data warehousing and business intelligence are crucial for modern enterprises, enabling them to make informed decisions based on historical data. One key aspect of data warehousing is handling changing data over time, especially when tracking historical changes in dimensions. This is where Slowly Changing Dimensions (SCD) come into play. In this blog post, we’ll delve into what SCDs are, the different types of SCDs, and how to implement them effectively.
Continue reading
In today’s fast-paced business environment, efficiency and productivity are paramount. Microsoft Fabric, a robust and versatile platform, has introduced a new feature aimed at enhancing workflow management: Task Flow. This feature promises to streamline processes, reduce manual intervention, and ultimately, boost productivity. In this comprehensive guide, we will explore the ins and outs of Task Flow, its benefits, and how you can leverage it to optimize your operations.
Continue reading
Creating a visually appealing and efficient Tableau report is crucial for making data-driven decisions. However, as your data grows, your reports might start to lag, leading to frustration and inefficiency. In this blog post, we will explore how to optimize your Tableau reports from three key perspectives: data sources, individual visualizations, and dashboards. By following these tips, you can ensure your reports run smoothly and deliver insights effectively.
Continue reading