What you'll learn * How to connect the data and leverage the abilities of Microsoft Power Query Editor to transform and modify the data * How to join tables and build a simple data model * How to visualize data and create insightful reports with KPI metrics scorecards, intuitive graphs, filters, and slicers
"Ben has a wealth of experience working in the data space, from low level configurations to beautiful visualizations"
"Ben provided rich insights on which technologies to learn to get hired, how to communicate with non-technical stakeholders, and solution design for successful data projects."
"Ben is the first person that I would go to in order to learn something data related. With all the times that I've followed Ben he's never led me astray."
Technical Foundations for Data Professionals What you'll learn A key outcome from this course is that you'll be able to build a project from start to finish which you can use in an interview Specifically, you'll have a working knowledge of the following technologies: Database Architectures (Relational, Big Data, and
Everything to Prepare You For Your Data Interview What you'll learn * Approaching the interview with a hiring manager mindset * Preparing a demo to illustrate your strengths * What to bring with you to the interview * Handling follow up communication * Countering offers and accepting the position Preview About this course This is
Learn how to properly manage your companies data What you'll learn * How to structure your Data Governance program * How to implement your Data Governance program * How to develop your Data Governance Charter * The roles you'll need to identify and formalize * How to measure the return on your Data Governance program
Everything to get you started with SQL What you'll learn * How to create and run SQL queiries to efficiently * Writing basic select statements * Limiting Results * Filtering Results with Where * More Ways to Filter Queries * Answering Analytical Questions with Aggregate Functions * Filtering Data with Aggregates * Handling NULL Values * Aliasing Columns and