The Data Architecture category provides a listing of various posts covering the design and organization of data structures and systems that support data management, storage, and retrieval. These would typically include the following types of articles; Introduction to Data Architecture, Data Modeling, Data Storage and Retrieval, and Data Management.
Power BI gives you the ability to use a wide variety of data sources in your data visualization project. This walkthrough shows you how to access files in a Azure Data Lake and import them into a Power BI data models.
It is easy to look at Power BI dashboards as static, but you can use some old school techniques to provide the ability the generate dynamic content using data-driven global settings that will be available to all your report developers. These techniques will allow your published reports to remain unchanged but allow the reports to dynamically reflect default information shown to the user, such as Current Month, Report Comments and even a time stamp of the last data source update.
An often overlooked, yet powerful feature of Power BI allows you to publish a report to a website using an embed code. This puts the report and underlying data out for everyone who has access to that web page. The sample page below shows a sample book I published for a training session. The following how-to will walk you through will the steps leverage this feature on your site.
The best place to start when learning to develop Power BI solutions is to review the logical architecture your Data Visualization projects will have. There are many moving parts and pieces to a Power BI solution, especially when looking at the varied data sources you can use. From on-premises to web-based, from public to confidential, you must make sure you expose your data securely. Having a good clear architecture will help you achieve a not only a good solution but also a secure one. The following article will show you how you can architect your own solution.
Using an Excel file in OneDrive for Business allows multiple users to update data, connect to a data source and schedule an automated refresh without having a lot of infrastructure. The following walkthrough will show you how to leverage this feature for your solution.
How do I make it easy for the end user to move the source Excel File around while making it easy to update the source location in PowerBI? Query Parameters solved that issue making the solution a lot easier to maintain.
