Discover essential resources for designing a successful Azure Data Solution Architecture in this comprehensive learning guide. Explore key aspects of data architecture, including logical data layers, technology choices, and best practices for data reporting and analytics solutions. With curated examples and real-world deployments, this guide is perfect for professionals seeking to optimize their Azure-based data solutions. Learn how to build scalable, secure, and cost-effective architectures using Azure's powerful tools and services. Ideal for data architects and engineers looking to deepen their Azure knowledge.

Once you have your data, the next big decision in your Power BI project is how you want to visualize it. The most significant part of the decision process could be the most important; choosing your Power BI color palette and data visualization color combination.

We are all busy and jumping between tasks and projects.  This makes it easy for your accomplishments to get left behind as you move on to the next thing.  Keeping an accomplishment log will help you track what you have completed, your successes and will also serve as a resource for items you can reuse later.

Data visualizations can become the vehicle that leads a reader through your narrative.  Having an infographic or series of visuals allows one to tell a story and provide greater understanding than simply having text alone.

Needing to Generate test data can be very stressful. I like to produce sample data that contains realistic values, such as professional names so that the people involved in the training have a frame of reference and do not get tripped up on the data. Realistic datasets can be created by following these steps and utilizing the resources listed below.

PowerBI has built-in date hierarchy features that seem to cause confusion in not only new users but experienced users. This article shows you how to avoid errors.  

How to use Excel Unpivot function to transform your data entry tables into fact tables for better data analysis. This comprehensive guide provides step-by-step instructions, making the process of converting Excel tables using Unpivot Columns functionality easy and efficient.

Are pie charts evil? Given the correct situation, pie charts can be used to your advantage in telling your data story.  The following case study uses Power BI samples to review examples and provide recommendations to get the most out of an often misused visualization in Excel or Power BI.

The Power BI Pulse Chart is a visualization tool that can help you take your data storytelling to the next level. Using time to tell a story can be one of the most valuable tools in your visualization toolbox to tell your data story.

I was looking for inspiration and some new ideas for dashboards.  What better way than finding inspiring examples of BI solutions from others. The following are some of the go-to links that I am certain you can find useful.

The date dimension is the table that controls your time analysis and is the most important to get right, especially with PowerBI, Excel, and other visualization tools. Having various tags and descriptors that aid in your analysis gives your end users several options in creating their visualizations in addition to a base for DAX time intelligence calculations.

There are many tools that you can purchase to generate documentation, however, also costs money or requires an install on client machines or servers. I wanted something fast which would not leave a foot print or require weeks of negotiations to get installed. The T-SQL script generates an HTML document out of the schema results that you can paste into Word to kickstart the documentation process.