Welcome to Power BI Desktop course. This is completely built with lots of Practical that will make you work with any real-Life datasets Are you a data professional or aspiring analyst looking to learn the top business intelligence platform on the market, taking this course will build your confidence in data and analytics in general. Through out the course we will guide you through on how to approach real-life projects.
This is the scenario: You just got hired as a DATA analyst into a sales and distribution company. Your first task is to use POWER BI to get. insight from the company’s historical data.
Request from your Employer: Your employer needs you to help them TRACK KPI’s like: Revenue, Returns, Refunds & Profit etc. Create a dashboard that helps them find trend and other useful insights. They want to identify high profitable Product, Customer and Location etc You don’t need to worry about how to go through this project, we’ll be here to walk you through every single step with intuitive, crystal clear explanations and helpful resources you need to get better.
Step 1: Connecting to data and transformation: In this first stage we are going to look at how to get data, get it clean and transformed and load it into Power BI desktop. We will explore how to append data from csv and further use the advanced way to combine data from csv which is using the folder option to consolidate your yearly, weekly, quarterly or monthly data for easy update.
Step 2: Data modelling or Creating a Relationship: In this stage we will look at how to best connect your data table and the lookup tables together.
Step 3: Adding Calculated Fields with DAX: In this stage things will start to get more interesting. This is the stage you are going to get introduced to Data Analysis. Expressions (DAX) at this stage we will learn how to create calculated columns and measures, explore when to use calculated column and when to avoid it.
Step 4: Visualization (Dashboard): This final stage is where we bring our data to LIFE with report and dashboard. We will learn the best way to create an outstanding dashboard, create custom tooltips, explore bookmarks and Power BI What-If Parameters.
