1.1 – What is Business Intelligence and Power BI?
1.2 – Installing PowerBI Desktop
1.3 – Exploring PowerBI Desktop
1.4 – Creating an online account on PowerBI Online
1.5 – What you will be able to do after this course?
1.6 – How this course support works?

2.1 – Understanding the data
2.2 – Importing Sales Data
2.3 – Creating the first visuals
2.4 – Exercise: Now it’s your turn to create other visuals
2.5 – Solution: Creating new visuals
2.6 – Importing and treating Targets Table
2.7 – How to treat errors on PowerQuery
2.8 – Exercise: Your turn to transform a dirty base
2.9 – Solution: Transforming the dirty database

3.1 – Understanding the necessity of Data Models
3.2 – What are Dimension Tables and Fact Tables
3.3 – Creating the dCalendar table on PowerQuery
3.4 – Establishing relationship between dCalendar with Sales and Targets
3.5 – Creating the other dimensions on Power Query
3.6 – How tables behave
3.7 – Exercise: it’s your time to create a new Data Model
3.8 – Solution: Creating a new Data Model

4.1 – What’s the DAX Language?
4.2 – Creating Calculated Columns
4.3 – Creating Aggregation Measures (SUM and AVERAGE)
4.4 – Exercise: it’s your turn to create counting measures
4.5 – Solution: Creating counting measures (COUNT, COUNTROWS and DISTINCTCOUNT)
4.6 – Creating measure tables and formating measures
4.7 – Iteration measures (SUMX)
4.8 – Exercise: Testing your knowledge about the iteration functions
4.9 – Filtering measures with CALCULATE function
4.10 – OR condition on a CALCULATE function
4.11 – Removing filters with ALL
4.12 – Removing filters with ALLSELECTED
4.13 – Exercise: Testing your knowledge about ALL and ALLSELECTED
4.14 – Solution: Testing your knowledge about ALL and ALLSELECTED
4.15 – When to use CALCULATE + FILTER?
4.16 – Advanced example: SUMMARIZE + FILTER Functions
4.17 – Context change with CALCULATE
4.18 – Review: FILTER, ALL, VALUES and SELECTEDVALUE
4.19 – Time intelligence: Comparison with PREVIOUSMONTH and DATEADD
4.20 – Time intelligence: Comparison with PREVIOUSYEAR and SAMEPERIODLASTYEAR – Year over Year
4.21 – Time intelligence: Inventing a function for LASTWEEK
4.22 – Time intelligence: DATESYTD – Year To Date

5.1 – Principles of Data Storytelling
5.1.1 – Identify the purpose and the audience
5.1.2 – Draw a sketch
5.1.3 – Choose the right visuals
5.1.4 – Choose a theme and keep the standards
5.1.5 – Create a personalized background
5.1.6 – Consider using icons and images to help the user understanding
5.1.7 – Align the visuals and check the texts
5.1.8 – Pick references to inspire you
5.1.9 – Evaluate using Power BI features such as tooltips and drill-down options
5.1.10 – Collect feedback from users and improve the improvement points
5.2 – Which visuals to create?
5.3 – ETL: Targets 2023
5.4 – Creating new visuals Pt.1
5.5 – Creating new visuals Pt.2
5.6 – Adding background images to pages + Theme Customization
5.7 – Formatting the Dashboard
5.8 – Slicers and Filter Pane
5.9 – Adding text and icons
5.10 – Bookmarks and Selection Pane
5.11 – Creating the Cover and adding buttons
5.12 – Exercise: Create a Bookmark to hide/show a chart/table
5.13 – Solution: Create a Bookmark to hide/show a chart/table
5.14 – Details page with Drill-through
5.15 – Solution: Sales Details by Products
5.16 – Editing visuals interactions
5.17 – Tooltips
5.18 – Conditional formatting
5.19 – Formatting tables and matrices
5.20 – New Drill-Drown and Drill-Through with buttons
5.21 – Smart visuals: Key Influencers
5.22 – Smart visuals: Decomposition Tree
5.23 – Smart visuals: Smart Narrative
5.24 – Now it’s your turn to create a page by yourself

6.1 – Publishing the Dashboard
6.2 – Publishing it publicly on the web
6.3 – Licenses and prices
6.4 – Creating Workspaces and listing the existing permissions
6.5 – The safe way of sharing
6.7 – Private link + SharePoint + Teams
6.8 – Publishing Application
6.9 – Gateway Installing and setting up the automatic refresh

7.1 – Intro
7.2 – What’s a Project? 
7.3 – Agility Concepts
7.4 – Understanding the actual state
7.5 – Planning the solution
7.6 – Executing
7.7 – Validating the solution
7.8 – Delivery and maintenance