CONTACT US: 778-373-4422 | info@mackenziemackenzie.com
15-Apr-2020
For data engineers doing transformations, one common problem is how to show non-summary data
in one column to support things like summed totals. In this example, we'll use TSQL to sum up
sales totals, then add a column to show the colours of all cars sold for those totals in a delimited
list, in one column. See how this transformation is done! Best viewed on a larger screen.
Analytics
Want to implement some analytics in your company, but don't know where to start? Contact me today to get some
expert advice, or to have someone to bounce your ideas off of. Contact now
Coaching
Want top notch coaching to propel your career ahead? Get an hour of mentoring to ask your questions about
the industry and your path forward. Contact now
Find 3 big reasons why you should learn data techniques if you are a professional or business person.
Read article
About our workshop
Why do people constantly run into problems with their data, even when they are highly trained in their area?
Read article
About our workshop
Find out why keys and uniqueness are so important for data transformation and data analysis.
Read article
About our workshop
Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.
Read article
About our workshop