Data Science Blog

MAY 20, 2024

It offers full BI-Stack Automation, from source to data warehouse through to frontend. It supports a holistic data model, allowing for rapid prototyping of various models. It also supports a wide range of data warehouses, analytical databases, data lakes, frontends, and pipelines/ETL.

Data Pipeline 262

Data Pipeline Data Warehouse Azure Data Lakes 262

phData

SEPTEMBER 28, 2023

Power BI Desktop enables the connection and retrieval of data from various sources, followed by data transformation using Power Query. To address this challenge, Microsoft introduced Dataflows within the Power BI service. What are Dataflows in Power BI?

Power BI 78

Power BI Data Preparation Machine Learning Machine Learning 78

Pickl AI

FEBRUARY 18, 2025

Summary: Power BI is a business analytics tool transforming data into actionable insights. Key features include AI-powered analytics, extensive data connectivity, customisation options, and robust data modelling. Customisable dashboards and reports enhance data presentation. Why Power BI?

Power BI 52

Power BI Azure SQL Business Intelligence 52

phData

OCTOBER 30, 2023

Additionally, we will provide a distinction between measures and calculated columns in data modeling and visualization. In Power BI , the measure is used to calculate aggregations and percentages or when you require a single value for a group of rows. The measure name must be unique throughout the entire model.

Power BI 78

Power BI Data Models Data Modeling Analytics 78

ODSC - Open Data Science

JUNE 12, 2023

The Datamarts capability opens endless possibilities for organizations to achieve their data analytics goals on the Power BI platform. Before we look into the Power BI Datamarts, let us take a step back and understand the meaning of a Datamart. What is Power BI Datamarts? What is a Datamart?

Power BI 52

Power BI Data Warehouse ETL Data Preparation 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 Modeling Data Models 52

Pickl AI

MARCH 4, 2024

Summary: Power BI is a leading data analytics platform offering advanced features like real-time analytics and collaborative capabilities. Understanding its significance is vital for aspiring Power BI developers. Mastering Power BI can significantly enhance career prospects, given its prevalence in the industry.

Power BI 52

Power BI Data Analysis Data Analysis Data Modeling 52

phData

DECEMBER 2, 2024

We at phData have written extensively about creating centralized data products in Power BI. Most Power BI developers are familiar with Power Query , Which is the data transformation layer of Power BI. This step can be performed as many times as needed across as many data models.

Power BI 52

Power BI Data Modeling Data Models Data Visualization 52

phData

OCTOBER 9, 2023

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. Field Parameters are a feature that equips users with the ability to toggle between multiple dimensions or values in a data model , thereby changing what is displayed on a visualization.

Power BI 59

Power BI Tableau Data Modeling Data Models 59

phData

AUGUST 29, 2023

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. One of the most common ways to organize the data model is to create a separate table exclusively for your measures.

Power BI 52

Power BI Data Modeling Data Models 52

Data Science Blog

NOVEMBER 15, 2023

New big data architectures and, above all, data sharing concepts such as Data Mesh are ideal for creating a common database for many data products and applications. The Event Log Data Model for Process Mining Process Mining as an analytical system can very well be imagined as an iceberg.

Data Modeling 245

Data Modeling Data Models Business Intelligence Business Intelligence 245

Data Science Dojo

JULY 21, 2023

Data Analysis Expressions (DAX) is a language used in Analysis Services, Power BI, and Power Pivot in Excel. FILTER : This function allows you to filter data based on a condition. By understanding the basics of DAX, you can create dynamic and informative reports that can help you make better decisions.

Data Analysis 195

Data Analysis Data Analysis Power BI Data Modeling 195

Data Science Dojo

JULY 21, 2023

Data Analysis Expressions (DAX) is a language used in Analysis Services, Power BI, and Power Pivot in Excel. FILTER : This function allows you to filter data based on a condition. By understanding the basics of DAX, you can create dynamic and informative reports that can help you make better decisions.

Data Analysis 195

Data Analysis Data Analysis Power BI Data Modeling 195

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 Models 52

Pickl AI

NOVEMBER 18, 2024

Summary: Power BI alternatives like Tableau, Qlik Sense, and Zoho Analytics provide businesses with tailored Data Analysis and Visualisation solutions. Selecting the right alternative ensures efficient data-driven decision-making and aligns with your organisation’s goals and budget. What is Power BI?

Power BI 52

Power BI Tableau Data Analysis Data Analysis 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

Data Science Dojo

OCTOBER 31, 2024

Key Skills Proficiency in SQL is essential, along with experience in data visualization tools such as Tableau or Power BI. Strong analytical skills and the ability to work with large datasets are critical, as is familiarity with data modeling and ETL processes.

Data Science 195

Data Science Data Scientist Machine Learning Machine Learning 195

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

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

Pickl AI

NOVEMBER 22, 2024

Tableau is particularly strong in industries like finance, healthcare, and retail where data-driven decisions are crucial. Real-Time Data Monitoring : Allows users to track metrics in real-time. Google Charts Google Charts is a free tool that provides a simple way to visualise data on the web.

Data Visualization 52

Data Visualization Big Data Big Data Power BI 52

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

Data Science Dojo

FEBRUARY 23, 2024

It aims to provide a clear and concise representation of data. Power BI Wizard It is a popular business intelligence tool that empowers you to explore data. The data exploration allows you to create reports, use DAX formulas for data manipulation, and suggest best practices for data modeling.

Data Science 256

Data Science Data Analysis Data Analysis Machine Learning 256

Hacker News

NOVEMBER 14, 2023

Looks like the only automation platforms which can connect to all the data sources we need is VBA and Powershell. Power BI Desktop has been introduced in our business but doesn’t hit all the platforms which VBA does, and even if it did Power BI cannot be used for process automation where-as VBA can, so what’s the point making the switch?

Power BI 128

Power BI Database Algorithm Azure 128

Smart Data Collective

NOVEMBER 24, 2020

And that is why: with BI you rely on a broader range of data, get deeper insights into the market, have a better vision of your companies strengths and weaknesses, receive trustworthy forecasts on business trends and get data-backed actionable tips on developing your business. SAP Lumira.

Business Intelligence 134

Business Intelligence Business Intelligence Power BI Augmented Analytics 134

ODSC - Open Data Science

OCTOBER 30, 2023

Effective Techniques for Data Visualization Let’s dive into the world of Power BI to explore its features and learn some useful data visualization tips and tricks for data visualization. One of the most potent features of Power BI is Quick Insights.

Data Visualization 52

Data Visualization Power BI Business Intelligence Business Intelligence 52

Data Science Dojo

FEBRUARY 23, 2024

It aims to provide a clear and concise representation of data. Power BI Wizard It is a popular business intelligence tool that empowers you to explore data. The data exploration allows you to create reports, use DAX formulas for data manipulation, and suggest best practices for data modeling.

Data Science 195

Data Science Data Analysis Data Analysis Data Analyst 195

Data Science Dojo

FEBRUARY 23, 2024

It aims to provide a clear and concise representation of data. Power BI Wizard It is a popular business intelligence tool that empowers you to explore data. The data exploration allows you to create reports, use DAX formulas for data manipulation, and suggest best practices for data modeling.

Data Science 195

Data Science Data Analysis Data Analysis Machine Learning 195

Pickl AI

MARCH 3, 2025

Ensuring data accuracy and consistency through cleansing and validation processes. Data Analysis and Modelling Applying statistical techniques and analytical tools to identify trends, patterns, and anomalies. Developing data models to support analysis and reporting.

Business Intelligence 52

Business Intelligence Business Intelligence Data Analyst Data Visualization 52

Pickl AI

JANUARY 9, 2025

Key Takeaways Operations Analysts optimise efficiency through data-driven decision-making. Expertise in tools like Power BI, SQL, and Python is crucial. Expertise in programs like Microsoft Excel, SQL , and business intelligence (BI) tools like Power BI or Tableau allows analysts to process and visualise data efficiently.

Power BI 52

Power BI Machine Learning Machine Learning Tableau 52

Pickl AI

JANUARY 15, 2025

Microsoft Power BI Microsoft Power BI integrates with various Microsoft products and offers robust reporting features. It is widely used by organizations such as Coca-Cola, which utilizes Power BI to streamline its sales processes by analysing customer purchase trends and inventory levels.

Business Intelligence 52

Business Intelligence Business Intelligence Power BI Data Visualization 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

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

Dataconomy

MARCH 24, 2023

Some of the common career opportunities in BI include: Entry-level roles Data analyst:  A data analyst is responsible for collecting and analyzing data, creating reports, and presenting insights to stakeholders. They may also be involved in data modeling and database design.

Business Intelligence 70

Business Intelligence Business Intelligence Data Analysis Data Analysis 70

Dataconomy

MARCH 24, 2023

Some of the common career opportunities in BI include: Entry-level roles Data analyst:  A data analyst is responsible for collecting and analyzing data, creating reports, and presenting insights to stakeholders. They may also be involved in data modeling and database design.

Business Intelligence 70

Business Intelligence Business Intelligence Data Analysis Data Analysis 70

ODSC - Open Data Science

APRIL 6, 2023

But its status as the go-between for programming and data professionals isn’t its only power. Within SQL you can also filter data, aggregate it and create valuations, manipulate data, update it, and even do data modeling. One set of tools that are becoming more important in our data-driven world is BI tools.

SQL 98

SQL Data Scientist Database Data Science 98

ODSC - Open Data Science

APRIL 26, 2023

Because they are the most likely to communicate data insights, they’ll also need to know SQL, and visualization tools such as Power BI and Tableau as well. Machine Learning Engineer Machine learning engineers will use data much differently than business analysts or data analysts.

Data Analyst 52

Data Analyst Machine Learning Machine Learning Power BI 52