phData

OCTOBER 30, 2023

In this blog, we will delve into real-world applications of Measure as Flag , exploring various types of measures. Additionally, we will provide a distinction between measures and calculated columns in data modeling and visualization. The measure name must be unique throughout the entire model. Calculated Column 1.

Power BI 78

Power BI Data Modeling Data Models Analytics 78

phData

OCTOBER 9, 2023

In this blog, I will walk you through what Field Parameters are and why they are important, and finally, I’ll show you how to use them with an example. By the end of this blog, you should have a decent working knowledge of how Field Parameters can make your life as a Power BI developer much easier.

Power BI 59

Power BI Tableau Data Modeling Data Models 59

phData

AUGUST 29, 2023

This blog was written by Spencer Baucke and updated for 2023 by Gavin Pedersen. Letting your Power BI data model get disorganized is a feeling every Power BI developer knows all too well, and it’s something that can occur very quickly when developing. What’s a Measures Table From Power BI?

Power BI 52

Power BI Data Models Data Modeling 52

phData

DECEMBER 2, 2024

We at phData have written extensively about creating centralized data products in Power BI. However, we have not yet touched on dataflows and the importance of this unique type of data product. Most Power BI developers are familiar with Power Query , Which is the data transformation layer of Power BI.

Power BI 52

Power BI Data Modeling Data Models Data Visualization 52

phData

NOVEMBER 26, 2024

As Power BI developers, we should be familiar with functionalities within Power BI that allow for the implementation of various levels of data security; the most common example may be Row-Level Security (RLS). Perhaps this is because it is not a native feature readily available within Power BI.

Power BI 52

Power BI Data Models Data Modeling 52

Pickl AI

SEPTEMBER 2, 2024

Summary: Counting rows is a fundamental task in Power BI that requires careful consideration. This blog explores how to get total number of rows in power query. Understanding Power BI and Its Importance Power BI is a suite of business analytics tools that allows users to analyze data and share insights.

Power BI 52

Power BI Data Analysis Data Analysis Data Modeling 52

Pickl AI

AUGUST 28, 2023

Power BI Heatmap: Heatmap in Power BI refers to the type of custom visualisation that businesses analysts utilise for showcasing the relationship between two variables on a map in different colour patches. It offers a wide range of features that make it a popular choice for data professionals, analysts, and organizations.

Power BI 52

Power BI Data Analysis Data Analysis Data Visualization 52

phData

OCTOBER 30, 2023

Using pre-production data during the development process of building a Power BI dashboard is considered a best practice. Doing so avoids straining your production data environment and reserves those resources for dashboards that are actually being used by end-users. What can a Parameter for your Data Source Accomplish?

Power BI 45

Power BI Database Data Modeling Data Models 45

phData

JULY 11, 2023

Power BI Datamarts is one of the most exciting features that Microsoft has released for the Power Platform in recent years. If you need high-level information on what a Power BI Datamart is and some example use cases, check out our other blog, What Are Power BI Datamarts?

Power BI 40

Power BI SQL Azure ETL 40

phData

JULY 14, 2023

Power BI is a versatile and scalable platform that combines self-service and enterprise business intelligence (BI) capabilities. It serves as a comprehensive solution for connecting to diverse data sources and creating compelling visualizations. What is the SWITCH Function?

Power BI 52

Power BI Data Analyst SQL Business Intelligence 52

DrivenData Labs

MARCH 26, 2024

To get participants started, we published a blog post outlining some commonly used open Earth observation datasets. QGIS, Microsoft's Power BI, Tableau, and Jupyter notebooks also facilitated many interesting visualizations, particularly for solvers with less programming experience.

Power BI 264

Power BI Data Scientist Python Machine Learning 264

phData

APRIL 15, 2024

When connecting to data in Power BI, you need to choose whether you want to use Import or Direct Query mode to connect to your data. Using the Import method, Power BI captures and caches a snapshot of your data in Power BI. What is Power BI Direct Query?

Power BI 52

Power BI Database Data Modeling Data Models 52

IBM Journey to AI blog

SEPTEMBER 19, 2023

To pursue a data science career, you need a deep understanding and expansive knowledge of machine learning and AI. js and Tableau Data science, data analytics and IBM Practicing data science isn’t without its challenges.

Data Science 94

Data Science Analytics Analytics Data Scientist 94

Pickl AI

MARCH 3, 2025

Business Intelligence Analysts are the skilled artisans who transform this raw data into valuable insights, empowering organizations to make strategic decisions and stay ahead of the curve. Key Takeaways BI Analysts convert data into actionable insights for strategic business decisions.

Business Intelligence 52

Business Intelligence Business Intelligence Data Analyst Data Visualization 52

Pickl AI

JANUARY 15, 2025

According to a report by Gartner, organizations that utilize BI tools can improve their operational efficiency and gain competitive advantages over rivals. Furthermore, a study indicated that 71% of organisations consider Data Analytics a critical factor for enhancing their business performance.

Business Intelligence 52

Business Intelligence Business Intelligence Power BI Data Visualization 52

Pickl AI

JANUARY 9, 2025

With organisations prioritising efficiency, sustainability, and data-backed decision-making, Operations Analysts now play a pivotal role in streamlining processes and optimising performance. They bridge the gap between data insights and actionable strategies, ensuring businesses stay competitive.

Power BI 52

Power BI Machine Learning Machine Learning Tableau 52

Pickl AI

JULY 3, 2023

It is the process of converting raw data into relevant and practical knowledge to help evaluate the performance of businesses, discover trends, and make well-informed choices. Data gathering, data integration, data modelling, analysis of information, and data visualization are all part of intelligence for businesses.

Business Intelligence 52

Business Intelligence Business Intelligence SQL Data Visualization 52

Pickl AI

AUGUST 9, 2024

Summary: This blog delves into hierarchies in dimensional modelling, highlighting their significance in data organisation and analysis. Real-world examples illustrate their application, while tools and technologies facilitate effective hierarchical data management in various industries.

Data Warehouse 52

Data Warehouse Data Quality ETL Business Intelligence 52

Pickl AI

JUNE 12, 2023

Tableau can help Data Scientists generate graphs, charts, maps and data-driven stories, etc for purpose of visualisation and analysing data. But What is Tableau for Data Science and what are its advantages and disadvantages? Let’s read the blog to find out!

Tableau 52

Tableau Data Science Data Scientist Data Analysis 52

Pickl AI

JANUARY 28, 2025

Introduction Business Intelligence (BI) architecture is a crucial framework that organizations use to collect, integrate, analyze, and present business data. This architecture serves as a blueprint for BI initiatives, ensuring that data-driven decision-making is efficient and effective. time, product) and facts (e.g.,

Business Intelligence 52

Business Intelligence Business Intelligence ETL Data Lakes 52

Pickl AI

JULY 25, 2023

Data Engineering: Laying the Foundation for Data Success While Data Science deals with data analysis and insights, Data Engineering focuses on the design, construction, and maintenance of robust data pipelines and infrastructure. Data Warehousing: Amazon Redshift, Google BigQuery, etc.

Data Engineering 52

Data Engineering Data Engineering Data Engineer Data Engineering 52

Pickl AI

AUGUST 11, 2024

Summary: This blog discusses best practices for designing effective fact tables in dimensional models. Additionally, it addresses common challenges and offers practical solutions to ensure that fact tables are structured for optimal data quality and analytical performance.

Data Quality 52

Data Quality Data Warehouse Data Governance Analytics 52

Pickl AI

JULY 18, 2024

Read Blogs: Crucial Statistics Interview Questions for Data Science Success. MongoDB is a NoSQL database that handles large-scale data and modern application requirements. MongoDB is a NoSQL database that uses a document-oriented data model. 2024’s top Power BI interview questions simplified.

Database 52

Database SQL Data Analyst Database Administration 52

Data Science Blog

JULY 23, 2023

Data Mesh on Azure Cloud with Databricks and Delta Lake for Applications of Business Intelligence, Data Science and Process Mining. With the concept of Data Mesh you will be able to access all your organizational internal and external data sources once and provides the data as several data models for all your analytical applications.

Data Science 246

Data Science Azure Power BI Business Intelligence 246

Pickl AI

JUNE 18, 2024

Summary: This blog dives into the most promising Power BI projects, exploring advanced data visualization, AI integration, IoT & blockchain analytics, and emerging technologies. Discover best practices for successful implementation and propel your organization towards data-driven success.

Power BI 52

Power BI Data Analysis Data Analysis Data Visualization 52

phData

JANUARY 17, 2025

Among the various Power BI tools available in the digital market to enable data-driven decision-making capabilities, Power BI has emerged as a market leader. In this blog, we will focus on Power BI DAX Copilot , a feature exclusively available on Power BI Desktop.

Power BI 52

Power BI Data Analysis Data Analysis Data Modeling 52

phData

OCTOBER 29, 2024

We all know how easy it is to refresh a single table in Power BI Desktop by right-clicking the table and selecting Refresh Data. However, in Power BI Service, we can only refresh the entire semantic model, as there is no out-of-the-box solution for refreshing a single table.

Power BI 52

Power BI SQL Database Azure 52

Pickl AI

MARCH 19, 2025

Data engineering is all about collecting, organising, and moving data so businesses can make better decisions. Handling massive amounts of data would be a nightmare without the right tools. In this blog, well explore the best data engineering tools that make data work easier, faster, and more reliable.

Data Engineering 52

Data Engineering Data Engineering Data Engineer Data Engineering 52