“Big Data” uses Business Intelligence to organize, analyze, report and publish that data into reports, dashboards and info graphics. We have the tools: Excel, Smartsheet, Power BI.
Miles of Road and Thousands of Bridges
The Michigan Department of Transportation is responsible for keeping all bridges are designed, built, maintained and operated to ensure safety.
We can use Smartsheet to outline a bridge Project and use Dependencies to link one Task to another.
January 2022, Michigan’s Department of Transportation announced the purchase of 300 new snowplows and named them puny names.
Where’s Darth Blader? Smartsheet uses Forms to capture all of the required data on the equipment purchased, the cost, condition and maintenance.
Watching the game is way more fun with someone who gets really, really, loud!
Microsoft Excel: “The Power of the Grid”
Learn how to enter data and create formulas to analyze and present complex information.
Understanding Microsoft Excel is an important middle technical skill in data analysis, as well as the related fields of data management and engineering.
Excel and XML for Data Analysts
Learn how to understand XML documents in the context of commonly used companion codes for restricting content with XML Schema, navigating nodes with XPATH and transforming content with styles from XSLT.
