Module 1: Introduction to Power BI - Exploring the Power BI Desktop environment, Overview of the Power BI start screen, Understanding the four key views in Power BI
Module 2: Data Connections - Importing files into Power BI, Step-by-step guide to importing an Excel file, Importing a CSV/Text file, Connecting to data from a webpage, Managing and organizing file connections
Module 3: Data Preparation with Power Query Editor - Data cleaning process in Power Query Editor, Explaining applied steps in data preparation, Managing and setting data types, Utilizing filters and data filling techniques
Module 4: Visualizing Data - Understanding the concept of storytelling with data, Key considerations in data visualization, Creating and formatting maps in Power BI, Generating and customizing charts, Creating tree maps and organizing data, Designing tables and matrices, Implementing KPI cards in visuals, Incorporating images into reports, Enhancing reports with slicers for data filtering
Module 5: Power BI Service - Overview of the Power BI service ecosystem, Pinning visualizations to dashboards, Collaborating and sharing reports within the service
Module 6: Understanding Data Modeling - Exploring table relationships in the data model, Configuring relationship properties for data analysis
Module 7: Introduction to DAX New Column - Creating new columns and measures with DAX expressions, Adding calculated columns to tables for enhanced data insights
Module 8: DAX Measures - Implementing SUM functions for data aggregation, Applying measures to visualizations for analysis, Using COUNTROWS function for data counting, Utilizing DISTINCTCOUNT function for unique value computation, Understanding essential DAX rules, Incorporating CALCULATE function for advanced calculations, Syntax and application of CALCULATE function in Power BI
Module 9: DAX Time Intelligence - Significance of a calendar table in time analysis, Leveraging time intelligence functions for data evaluation, Implementing TOTALYTD function for year-to-date analysis, Visualizing time intelligence data in charts for meaningful insights.
Shareable on LinkedIn
You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.