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!
2 min read
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.
4 min read
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!
3 min read
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!
4 min read
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!
6 min read
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:
5 min read
Welcome back to a new Reporting Tuesday blog post, in this post we will explore the creation of buttons in Power BI. This is exciting because buttons make your Power BI reports more interactive and give your users more control over what they see. Enjoy!
5 min read
Welcome back to a new Reporting Tuesday blog post, in this post we will explore bookmarks in Power BI. This is exciting because bookmarks are a great way to quickly access different parts or views of a report in Power BI. They can save you a lot of time and make it easier to explore and understand your data. Enjoy!
6 min read
For this third part of Power BI Web sources, we will explore the use of Partner API in Power BI. This can be done in multiple ways;however, you must add code to your solution. Since, this relies on code no matter what I want to take this opportunity to combine Power BI with python query. Doing this demands that you have a python client installed on the computer and that you have installed the libraries Requests and Pandas.
3 min read
In the first part we looked at how to extract Stock data for Microsoft using Yahoo Finance. Yahoo Finance used to have their own API, today you can find third party APIs. However, because I want to go into the logic of an API, we will change to a different data set. First, we will look at covid tracking, that is an opensource dataset, and the process is exactly as we saw it from yahoo finance.