Data Visualization Skill, MDS Program 1, MDS Program 2, MDS Program 3
Power BI Data Visualization Base and Advanced Level
0( 0 REVIEWS )
0 STUDENTS
Instructors
Power BI Data Visualization Base and Advanced Level
0 STUDENTS ENROLLED
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Course Curriculum
Session - 1 | |||
My first dashboard in power bi and a demo | 00:00:00 | ||
Introduction to POWER BI as a data visualization tools and its objects for navigation | 00:00:00 | ||
Data importing | 00:00:00 | ||
<ul> <li>From flat file (.csv and .txt)</li> <li>From database file (.xlsx and .accdb)</li> <li>From Database connection ( ODBC and OLEDB)</li> <li>From folders</li> <li>From Web files</li> </ul> | |||
Data preparation | 00:00:00 | ||
<ul> <li>Cleansing data</li> <li>Formatting data</li> <li>Removing duplicates</li> <li>Adding columns and creating expression</li> </ul> | |||
Data Visualization- Designing Interactive dashboard | 00:00:00 | ||
<ul> <li>Bar chart</li> <li>Line Chart</li> <li>Pie Chart</li> <li>Stacked Bar Chart</li> <li>Clustered column chart</li> <li>Area chart</li> <li>Combo chart</li> <li>Scatter chart</li> <li>Tree map chart</li> <li>funnel chart</li> <li>Gauge chart</li> <li>KPIs</li> <li>Tables</li> <li>Slicers and connections</li> <li>Maps</li> </ul> | |||
Session - 2 | |||
Data Model | 00:00:00 | ||
<ul> <li>Joining and relationship</li> <li>Data model designing <ul> <li>Star schema</li> <li>Snowflakes</li> </ul> </li> <li>OLTP vs OLAP</li> </ul> | |||
Introduction to Data Analysis Expression ( DAX ) | 00:00:00 | ||
DAX data types, DAX operations and syntaxes, M vs DAX, Columns and measures (Aggregate functions) | 00:00:00 | ||
DAX time intelligence and master calendar using functions | 00:00:00 | ||
Session - 3 | |||
Adding Calculated field with DAX | 00:00:00 | ||
<ul> <li>Calculated Columns vs. Measures</li> <li>Row Context vs. Filter Context in Power BI</li> <li>DAX Syntax & Operators</li> <li>Common Power BI Functions</li> <li>Basic Date & Time Formulas</li> <li>Logical & Conditional Statements</li> <li>Text, Math & Stats Functions</li> <li>Joining Data with RELATED</li> <li>CALCULATE, ALL & FILTER Functions</li> <li>DAX Iterators (SUMX, AVERAGEX)</li> <li>Time Intelligence Formulas</li> <li>DAX & Power BI Best Practices</li> </ul> | |||
Session - 4 | |||
Personal – Enterprise Gateway | 00:00:00 | ||
Dashboard sharing and collaboration | 00:00:00 | ||
<ul> <li>Sharing and Collaboration</li> <li>Sharing Dashboard</li> <li>Sharing Workspaces</li> <li>Sharing App</li> <li>Publish To Web</li> </ul> |