Power BI Bootcamp
Drive a data culture and power a new class of data first dashboards with Power BI
Many people think that Power BI is just a visualization tool. Although it can be used for visualizing data, this business intelligence platform is a much more powerful tool, empowering nontechnical users and allowing them to build and automate their own reports.
Join experts Maria Florencia Hourcouripé and Nicolás Lagreste Zucchini to discover the benefits of Power BI. You’ll learn how to work with real end-to-end projects using real-life data, and put the tool into practice with hands-on exercises. You’ll leave with the skills and know-how that will help you to take full control of your data in your daily work.
Week 1: Introduction to Business Intelligence, Power BI, and Power Query
After an introduction to Power BI, you’ll begin an end-to-end project that starts with a connection to Excel’s data sources, cleaning transformations of data with Power Query, and a basic “star schema model.” By the end of Week 1, you’ll have created a visual report in Power BI.
Week 2: Advanced and Interactive Visuals
Week 2 will focus on “reports with impact.” You’ll learn many different functionalities for designing professional reports: tooltips and buttons, how to design and change the theme and the format of visuals, and how to create a stunning background.
Week 3: Calculated Measures, Columns, and Custom Tables with Power BI Programming Language (DAX)
In Week 3, you’ll dive deeper into DAX, the language that allows you to perform powerful KPIs to clearly understand your data. You’ll explore “evaluation context” and use some basic formulas like SUM, AVERAGE, DIVIDE, SWITCH and CALCULATE.
Week 4: Ways to collaborate and share in Power BI
In the final session, you’ll share your project with colleagues through Power BI service and explore its other capabilities such as exporting to a PDF or PowerPoint, building new reports from the same model, and connecting Power BI with data in SharePoint. And you’ll see how a scheduled update works.
