Data Analytics Steve Young Data Analytics Steve Young

How To Create Tables in Excel: 5 Simple Steps

This tutorial and sample workbook demonstrate how to enhance Excel tables and improve data usability within 5 minutes. Users learn to convert AI-created CSV files into tables, name tables for easier reference, format columns, insert slicers, and create dynamic filtered graphs. The tutorial includes a sample workbook on GitHub for reference.

Read More
Data Analytics Steve Young Data Analytics Steve Young

Project Management for Data Visualization, Analytics & AI | Ensuring Success

Drive impactful insights with expert data project management. Learn more today!

Managing data visualization, analytics, and AI projects requires a unique approach. Success hinges on clearly defining project goals, ensuring data quality, and adopting an iterative, agile process. A customized strategy is essential for data collection to security, governance, and visualization.

Read More
Data Analytics Steve Young Data Analytics Steve Young

What is Data Wrangling vs Data Engineering

This article offers valuable insights into the difference between data wrangling and data engineering in data analytics with Power BI, emphasizing the collaborative nature of the process. It is recommended for those seeking to improve their knowledge of data analytics using Power BI.

Read More
Data Analytics Steve Young Data Analytics Steve Young

Use TSQL to Generate SQL Server Schema Documentation

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.

Read More