Data god DATAMART PREPARATION

The first step in building out your Data god Model is to ensure that your data source is ready for consumption. These scripts will add to the AdventureWorksDW database to ensure you are ready. Follow the methods highlighted in these scripts to prepare your environment.

Data god MODEL DATASET

Updated: 10/19/2022

The next step in building out your Data god Model is to create your Dataset for consumption by the analytics mortals that you serve. The Data gods Dataset was built to showcase the many features available within the Data god Model. NOW INCLUDES MODEL WITH NO DQ!!

Data god WIREFRAME

When starting any Power BI project, it's important to gather basic requirements and wireframe the work that needs to be done. The Data god Power BI Wireframe Template will help you do that for any project - A shout out to Sue Bayes, Antony Catella, and the #SMLcrew for helping get this together!

Data god VALIDATION REPORT

The next step in building out your Data god Model is to ensure that your Data is Valid and usable. Use this Data Validation template to begin down the road to the Data god Heavens. 

Data god PAGINATED REPORT

The next step in building out your Data god Model is to ensure that your Data is consumable at a detailed level of granularity. This ensures your users that the future analytics can be counted upon because they know the details are right.

Data god ADVANCED ANALYTICS

The final step in building out your Data god Model is to drive action within your organization. Creating beautiful and insightful reports that allow people to find the proper next steps to take.

Data god ONE BIG TABLE (OBT)

The One Big Table (OBT) data model example and best practices for building models or reports off of a single table. 

Data god MY FIRST STAR

The transformation from a One Big Table (OBT) model into your first Star Schema.

Data god AUTO DOCS

Data without meaning is of low value. The Data god Model Auto Docs keeps your users up to date on everything in your model and the business purpose.

Data god Icons

Common Microsoft Icons for use with presentations and quick architecture diagrams in PowerPoint.



Data god Governance

Enabling users to consume content properly is key to any governance program. The first step in enabling is to set up a common naming conventions so users can easily access and explore content.

TBD

To be determined

Your guide to securing and sharing data and reports within Power BI. This Power BI Security Guide can be downloaded and shared broadly with your CoP

DOWNLOAD NOW - Updated 8/24/2022