Five years ago, we were mostly referred to as Power BI analysts but today companies want Power BI developers. In today’s business world, a tightly coupled data and IT units is a must-have for organizations. That is the only way they can achieve proper enterprise data management, data governance, cybersecurity, efficient IT operations and genuine business intelligence.

When working with large data sets with multiple dates (and times), it is important to find trends by comparing historical data. A calendar table is the best tool for analyzing time series data, as it provides an easy way to navigate and compare historical dates.

As an excel user, you are likely familiar with Excel’s powerful capabilities for data manipulation and visualization. But did you know that you can also use Excel for web scraping?

In this detailed guide, we’ll explore two methods: the traditional approach and the innovative “Add Table Using Examples” feature in Excel’s PowerQuery.

SQL is a powerful language for querying and manipulating data from relational databases. One of the most common tasks in SQL is to join data from multiple tables based on a related column or condition. Joining data allows you to create more complex and meaningful queries that can answer a variety of business questions.

In this blogpost, we will explore the different types of joins in SQL, when to use them, and some tips and best practices for writing efficient and readable join queries.

Slicers are great yeah! But with field parameters, you can do even more. Field Parameter enables a self-service BI experience for end users. It is a relatively new and highly effective feature in Power BI Desktop, released in May 2022. It allows the report developer as well as end-users switch the visual content without any hassle. In the past, we had to do this manually with tools like bookmarks, but since this feature was introduced, creating dynamic and user-friendly reports just got easier.

Michael Olafusi - 9x Microsoft Most Valuable Professional

Practical tips for hiring great consultants