This course is designed to help you build the exact skills you need to ace the Microsoft PL-300 exam and become a certified Power BI Data Analyst Associate.With hands-on projects, downloadable study guides, and a full-length practice exam, this is the ONLY course you'll need to prepare for your Power BI certification!Throughout the course, you’ll play the role of Lead Business Intelligence Analyst for Maven Cycles, a boutique cycling shop. You’ll use Power BI Desktop and Power BI Service, along with the skills you learn throughout the course, to design and build an end-to-end business intelligence solution from the ground up. We'll guide you each step of the way, with crystal clear explanations and pro tips to help you build expert-level Power BI and DAX skills.Our project will incorporate all of the skills covered on the Power BI PL-300 exam, including data prep, data modeling, data analysis and visualization, along with deploying and maintaining reports and dashboards:Data Prep: Getting Data From Different SourcesConnect to data sources, choose a storage mode & define data source parametersData Prep: Basic Profiling Explore the view menu & data profiling tools like column quality and distributionData Prep: Data Cleaning, Transforming & LoadingClean data, apply table transformations, merge & append queries, and modify custom M codeData Modeling 101Design data models, identify keys, establish table relationships, and review model optimization tips
What you'll learn
build and deploy business intelligence solutions
perform data cleaning and transformation
design data models and establish table relationships
create and maintain data visualizations and dashboards
Course objectives
prepare for the Microsoft PL-300 certification exam
develop expert-level Power BI and DAX skills
execute end-to-end business intelligence processes