Introduction to Power BI

Introduction to Power BI

0%

1. First Steps into Power BI

Dive into the world of Power BI and build a solid foundation. You'll cover everything from installation and setup to connecting data sources and creating your first report.

What is Power BI?

Installation and Setup

Overview of Power BI

Connecting to Data Sources

Basics of Power Query

Creating Your First Report

Power BI Basics Quiz

2. Data Preparation

Explore essential data preparation techniques, including cleaning, transforming, and combining multiple data sources. You'll also tackle handling missing values, data profiling, and various data manipulation methods.

Data Cleaning and Transformation

Data Profiling and Exploration

Handling Missing Values

Creating Columns

Handling Multiple Data Sources

Appending and Merging Data

Preparing Data Quiz

3. Building Robust Data Models and Calculations

Master the fundamentals of data modeling, from understanding data models and creating relationships to getting the hang of DAX basics. You'll also learn to create measures and calculated columns.

Introduction to Data Models

Creating Relationships

DAX (Data Analysis Expressions) Basics

Measures, Quick Measures, and Calculated Columns

Data Modeling Quiz

4. Visualizing Data

Discover various visualization techniques and customize visuals for better insights. You'll also explore advanced features like slicers, filters, and drill-down/drill-through capabilities to enhance your data analysis.

Creating Visualizations

Map and Tool Tips

Slicers and Filters

Drildown and Hierachies

Visualizing Data Quiz

5. Enhancing Reports for Impactful Storytelling

Boost the usability and storytelling power of your reports by using themes, configuring report pages, and leveraging advanced features like the Analyze feature and identifying outliers. You'll also create groups, bins, and clusters for deeper insights.

Configure Report Page

Using Shapes and Buttons

Creating Groups and Bins

Analyzing Features

Finding Anomalies

Enhancing Reports Quiz

Contenido del Curso

Introduction to Power BI

Introduction to Power BI

1. First Steps into Power BI

What is Power BI?Installation and Setup Overview of Power BI Connecting to Data Sources Basics of Power Query Creating Your First Report Power BI Basics Quiz

2. Data Preparation

Data Cleaning and Transformation Data Profiling and Exploration Handling Missing Values Creating Columns Handling Multiple Data Sources Appending and Merging Data Pivoting Data Preparing Data Quiz

3. Building Robust Data Models and Calculations

Introduction to Data Models Creating Relationships DAX (Data Analysis Expressions) Basics Measures, Quick Measures, and Calculated Columns Data Modeling Quiz

4. Visualizing Data

Creating Visualizations Map and Tool Tips Slicers and Filters Drildown and Hierachies Visualizing Data Quiz

5. Enhancing Reports for Impactful Storytelling

Using Themes Configure Report Page Using Shapes and Buttons Creating Groups and Bins Analyzing Features Finding Anomalies Enhancing Reports Quiz

DAX (Data Analysis Expressions) Basics

It's now time to dive into our first experience with DAX (Data Analysis Expressions) in the video. We'll start by creating our initial measures and then learn how to organize them within a calculation table. This will help us structure and manage our calculations effectively, making our data analysis and reporting workflows smoother in Power BI and Excel Power Pivot. In addition to aggregation functions, we will explore CALCULATE in DAX which helps to adjusts the context of a calculation by applying filters.

To create total riders from our two rider type columns, we will use DAX to combine the two columns with the SUM function and the + operator:

To create a filter calculation for riders in the winter, we will leverage the DAX function CALCULATE with our total riders measure:

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 3. Capítulo 3

some-alt