Vancouver Power BI and Modern Excel User Group Meet-up
Title: One file to rule them all… and what is a Star Schema?
Session Outline:
First, we’ll learn about some of the newest features and updates in Power BI. Next, Excel and Power BI trainer, Anne Walsh, will help us understand how to use Star Schemas when data modeling.
If you are new to Power BI, you may already have tried to import your single Excel file and found that it didn’t go well. If so, you have likely heard about “Star Schemas” and “Time Intelligence” and why “A Calendar Is Really Important”, but you don’t really know how to set any of that up. In this session, we will start off in single file (see what Anne did there…?) and then use Power Query to get our data into separate tables. We will be using one of Ken Puls’ super recipes to create a dynamic calendar and then we will create a simple visualization from that. Who knows? We may go completely nuts and throw in a measure or two (not the thing you have in your kitchen cupboard) to add to the visualization.
Title: One file to rule them all… and what is a Star Schema?Session Outline:First, we’ll learn about some of the newest features and updates in Power BI. Next, Excel and Power BI trainer, Anne Walsh, will help us understand how to use Star Schemas when data modeling.If you are new to Power BI, you may already have tried to import your single Excel file and found that it didn’t go well. If so, you have likely heard about “Star Schemas” and “Time Intelligence” and why “A Calendar Is Really Important”, but you don’t really know how to set any of that up. In this session, we will start off in single file (see what Anne did there…?) and then use Power Query to get our data into separate tables. We will be using one of Ken Puls’ super recipes to create a dynamic calendar and then we will create a simple visualization from that. Who knows? We may go completely nuts and throw in a measure or two (not the thing you have in your kitchen cupboard) to add to the visualization. Read More