להשארת פרטים
דאטה ומסדי נתונים Advanced Power BI
מספר הקורס 9298 24 סה"כ שעות אקדמאיות
3 מפגשים
מעניין אותי לשמוע עוד 
המועדים הקרובים
ניתן לפתוח קורס בהתאמה אישית לארגונים במועד שיתואם עימנו
22/03/2020
קורס בוקר
סניף
תל אביב05/07/2020
קורס בוקר
סניף
תל אביב
Overview
This Advanced Power BI workshop is a powerful way to take your Power BI reports to the next level. Best Practices for ETL, Date modeling, visualizations and Navigation. Also, we will learn some particle Patterns.
On Completion, Delegates will be able to
Crate Datasets from multiple sources and make effective using Dax Patterns.
Who Should Attend
Analysts
IT
- Lesson One: Creating a data model
- ERD – Facts and Shared Dimensions
- Data cleaning and data preparation techniques
- Creating Date Dimension with DAX
- Creating a New table from Existing Table
- Data Visualization – Introduction
- Lesson Two: DAX functionality
- DAX Language overview
- Create parameters (What if)
- Time intelligence (MoM, YoY, YTD, LY YTD, Moving Average)
- IF, HASONEVALUE
- SWITCH, Switch( true())
- Lesson Three: Advanced Analytics
- Pareto Categories
- Segmentation - Customer Size
- Top 9 + Other (RANKX)
- Moving Averages
- Non Equal Date Periods
- Time KPI’s
- Lesson Four: creating an Application
- Data Visualization (choosing the right visual)
- Bookmarks and Buttons
- Slicers
- Filter Pane
- Drill-through
- Lesson Five: Distributing an Application on the Web
- New Role, Manage role
- Manage gateways
- App workspace
- Manage embedded code
- Advanced topics, publish and Share your data
- Experience of building Power BI Reports