dvanalytics whatsapp contact
dvanalytics whatsapp

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>