5 weeks Live Bootcamp: Data Visualization and Reporting with Power BIin Data Analytics with Microsoft Power BI
What you will learn?
Demonstrate proficiency in preparing and importing data into Power BI, as well as cleaning and transforming data.
Design and implement a data model using Power BI, including creating measures using DAX and optimizing the model for performance.
Create visually compelling and effective data visualizations using a variety of Power BI visuals.
Design comprehensive data-driven stories with Power BI reports, including reports and dashboards.
Apply the skills learned in the course to real-world scenarios, such as HR Analytics, Financial Analytics, and Hotel Booking Analysis.
About this course
Basic knowledge of Microsoft Excel.
Businesses need data analysts more than ever. In this module, you will learn about the life and journey of a data analyst and the skills, tasks, and processes they go through in order to tell a story with data so trusted business decisions can be made.
You will also learn how the suite of Power BI tools and services is used by a data analyst to tell a compelling story through reports and dashboards.
You will explore Power Query as you learn to extract data from different data sources and choose a storage mode and connectivity type. You will learn to profile, clean, and load data into Power BI in preparation for modeling your data.
Power Query has an incredible amount of features that are dedicated to helping you clean and prepare your data for analysis. You will learn how to simplify a complicated model, change data types, rename objects, and pivot data through a self-study online course.
In this module, you will learn how to design a data model that is intuitive, high-performing, and simple to maintain.
Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. In this module, you will learn how to analyze and perform custom business calculations using DAX.
You will learn how to perform advanced calculations such as running totals, year-on-year growth, etc. You will learn advanced concepts such as filter context, row context, virtual relationship etc.
Power BI has extraordinary visuals that can be used on Power BI reports and dashboards. In this module, you will learn when to use which visual to solve which problem. You will also learn how to choose appropriate charts for your data to tell a compelling, data-driven story in Power BI.
In this module, you will learn how to improve user experience in your Power BI reports using features such as bookmarks, navigation pages, tooltips, drill throughs, and buttons. You’ll also explore Power BI report themes to create a unified reporting experience across all reports.
Microsoft Power BI gives you a wide range of methods to analyze your data and get answers to your questions. In this module, we will explore some of the artificial intelligence capabilities in Power BI that you can leverage to get insights and tell an effective story with data.
In this module, you will put everything you have learned so far to develop interactive and dynamic reports for different stakeholders. We will look at best practices for designing reports and sharing insights
In this module, we will explore the options for publishing and sharing your Power BI reports and dashboards with teammates in your organization or with everyone on the web.
Learn how to develop interactive financial reports using Power BI. This is a self-study interactive guided project where you will learn fro,m our instructor(s)
Learn how to develop interactive HR reports using Power BI. This is a self-study interactive guided project where you will learn from our instructor(s)
Learn how to develop interactive Hotel booking reports using Power BI. This is a self-study interactive guided project where you will learn from our instructor(s)
Apply your new skills to analyze and visualize your own data using Power BI. Visit kaggle.com and download any data of your interest, analyze it, and share the insights with the team.