Skip to content

3 Results

  • Introduction to Power BI

    Power BI (business intelligence) is a complete data analysis and report creation tool that you install for free. Discover how to quickly extract, transform, and load data with just a few clicks. Create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions. This course can be taken alone or as part of the 3 course Power BI Certificate. Class Details Unit 1: Overview Power BI Components Install Power BI Desktop (free software) Getting started Unit 2: Connect with Data Sources Types of data sources Import Excel and text files Connect to databases (Access) Import data from the Web Unit 3: Transform Data Introduction to Power Query Shape data Filter data Understand the Data Model Unit 4: Creating Reports Overview Create visuals Format reports Share your files For more information, visit our question and answer page - Click Here.
  • Intermediate Power BI

    Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports. This course can be taken alone or as part of the 3 course Power BI Certificate. Class Details Unit 1: Power Query Review the ETL Process Insert columns using different methods Group, Summarize, Pivot, and UnPivot data Merge and Append queries Unit 2: Data Modeling What Data Modeling is Modeling Options Create and manage relationships Create Date table Unit 3: DAX Introduction to DAX Calculate columns and measures Time Intelligence functions Quick Measures Unit 4: Reports Filters versus Slicers Visual Hierarchies and Drill downs Drillthrough Define visual interactions Apply conditional formatting For more information, visit our question and answer page - Click Here.
  • Advanced Power BI

    Expand your knowledge of Power BI Desktop to the highest level. Explore the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results. This course can be taken alone or as part of the 3 course Power BI Certificate. Class Details Unit 1: Power Query Utilize Column profile, distribution, and quality Perform fuzzy match Duplicate versus Reference queries Debug errors Unit 2: Data Modeling What a Star Schema is Understand relationship types Manage relationships Unit 3: DAX Understand contexts CALCULATE function COALESCE function Compute visual totals accurately Unit 4: Reports Insert Objects Create Bookmarks For more information, visit our question and answer page - Click Here.