Welcome back to another installment of our Reporting Tuesday blog posts. In this article, we will delve into the fundamental Data Transformation Techniques in Power BI. This exciting journey will enable you to harness Power BI's capabilities to transform and visualize your data effectively. To create powerful and insightful reports and dashboards, you often need to clean and shape your data to make it suitable for analysis. In this piece, we will explore some essential data transformation techniques in Power BI to help you get started on this enriching journey. Enjoy!
Recent posts by Mads Bender
4 min read
Exploring the New FinancialReportVisual in Power BI for BPA
In this article, we're excited to introduce you to the latest addition to Power BI within Business Performance Analytics (BPA). This new visual, called FinancialReportVisual, is a matrix visualization that show promise to be a powerful tool for both reporting and in-depth exploration of financial data. Let's dive into the details and functionalities of this visual.
Topics: D365FO BPA Business Performance Analytics Reporting tuesdays
3 min read
Exploring Business Performance Analytics (BPA) in D365FO
In this post, we will delve into the intriguing realm of Business Performance Analytics (BPA), a promising new feature that holds the potential to revolutionize reporting within D365FO. BPA aims to provide profound insights into various business processes, all within the confines of D365FO. Microsoft has intelligently transformed the application's data into an intuitive dimensional data model, promising an enriching experience for users.
Topics: D365FO BPA Business Performance Analytics Reporting tuesdays
2 min read
A quick introduction to Microsoft Fabric
Welcome back to a new Reporting Tuesday blog post, where we explore Microsoft Fabric—a platform that has the potential to take your data processing to the next level.
Topics: D365FO PowerBI Fabric
3 min read
How to use & Ampersand in your number sequence
This post will explore the setup of number sequence in Dynamics 365 (D365), and how to use Ampersand (&) in the setup of a number sequence in D365 and its limitations. First, we will delve into what number sequences are and why they are important in D365.
Topics: Finance D365FO
4 min read
Exploring the Key Influencers visual
Welcome back to a new Reporting Tuesday blog post, in this post we will explore the Key Influencers visual. This is exciting because it allows you to rapidly find statistical trends in your data. Enjoy!
Topics: D365FO PowerBI
3 min read
Introduction to Smart Narrative in Power BI
Welcome back to a new Reporting Tuesday blog post, in this post we will explore Smart Narrative in Power BI. This is exciting because Smart Narrative provides a quick interpretation of your data that you can share with others. It can help you make sense of complex information and explain it in a way that everyone can understand. Enjoy!
Topics: D365FO PowerBI
4 min read
Create a Navigation/Filter bar in Power BI
Welcome back to a new Reporting Tuesday blog post, in this post we will explore how to create a navigation bar in Power BI. This is exciting because it allows you to add user interface to your reports without losing reporting area. Enjoy!
Topics: D365FO PowerBI
6 min read
Combine multiple web sources to one dataset
Welcome back to a new Reporting Tuesday blog post, in this post we will explore how to combine multiple web sources to one dataset in Power query. This is exciting because it allows you to mark comprehensive datasets using web sources. Enjoy!
In this blog post we are going to look at how to make a dataset in excel power query that combines data from multiple web sources. For this specifically we will look at how to get data from several stocks into excel and return it to one table.
Here when we talk about a web source, we refer to a source of data that can be accessed over the internet using a web browser or a programming language. Web sources can include websites, databases, and other online resources that provide data in a structured format, such as HTML, XML, or JSON. For this we will make a list of stocks to track and retrieve the data from yahoo finance.
First, we need to open a new excel document, and make a table with the following column headers: Ticker name, From, To, Interval, URL_hist, URL_summary and months of data. These will be used to collect data, and with proper setup you only need to fill in the ticker and the rest is done by formulars.
This is how we will fill in the table:
Topics: D365FO PowerBI
4 min read
Create custom toggle buttons in power BI
Power BI is a very powerful tool, however making a report that looks clean and still have usability in center can be difficult. In this article we will look at the possibility for using toggle buttons to help keep a report clean and simple, and still pack advanced features into it.
