This class is ideal for students who are already using PowerBI or Excel and want to extend their knowledge and improve their skills in data modelling, report creation and visual report design. The course focuses entirely on real-life scenarios for data analysis, exploration and actionable reporting, where main goal is for students to level-up their DAX skills, optimize their report data modelling skills and enable better collaboration for report design in their company.

• Data Analysts, Financial Analysts, Cost Analysts, Revenue Analysts, Business Analysts, Performance analysts, Accountants, Financial controllers and everyone whose best-friend functionality is export to Excel, that need to consolidate data from different data sources, understand the data and derive actionable insights from it. Students should have at least 6 months experience with PowerBI

• Save time hunting down for the right data. Combine online, offline, spreadsheets, text files, database data in a single model with PowerBI
• Optimize repetitive manual data cleansing/transformation steps
• Provide actionable data insights to your stakeholders at the right time, in the right shape using compelling dashboard and report designs in minutes
• Quickly and easily share reports and dashboards with stakeholders, without sending spreadsheets over mail, storing them on file shares or document management systems
• Properly secure data by controlling access to individual rows in the model so users will see only the data they have permission to see
• Connect with peers and get tailored advice on your daily data issues
• Get additional ideas how to use your data, based on experience in the numerous real case labs, part of this training

Module 1: Data import and preparation with PowerBI Desktop

Module 2: Modeling your data for better analysis

Module 3: Visualization and report design with PowerBI

Module 4: Extending your model with DAX

Module 5: End to end sharing and collaboration with PowerBI

Business analysis and Data exploration - using PowerBI and Power Query