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 ProfessionalsWhat 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 Streaming)
Everything to Prepare You For Your Data InterviewWhat 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 the
Learn how to properly manage your companies dataWhat 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 How
Everything to get you started with SQLWhat 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 Tables
Save time in Excel with these awesome tips What you'll learn How to remove duplicates Finding the Max Length of Values in a Column Create metadata for importing to other programs (like Salesforce) Automatically Bring External Data from a Website Automating Tasks with Macros Analyzing Data with Pivot Tables Trapping