Course details
Course Outline:
- Getting started
- Multidimensional Vs Tabular
- Separate Named Instances
- Visual Studio basics
- Visual Studio windows
- Setting startup options
- Creating a project
- Connecting to SQL Server
- Creating and using connections
- Filtering rows and column
- Creating a data model
- Hiding from client tools
- Renaming tables/columns
- How column storage works
- How processing works
- Relationships
- Diagram view
- Creating relationships
- Measures
- Creating measures
- SUMX, AVERAGEX, etc.
- Hierarchies
- Creating a hierarchy
- Viewing hierarchies
- KPIs
- The parts of a KPI
- Absolute and relative measures
- Creating and viewing KPIs
- Perspectives
- Creating perspectives
- Using in Excel
- Security
- How security works
- Creating roles
- Filtering rows by role
Eligibility / Requirements
for powerBI Developers it will be useful
Course Location
About Amaravati Analytics software services
Amaravati Analytics is software consulting company having office at bur dubai offering BI implementation srervices to the top customers in UAE /India/UK. We are offering consulting/outsourcing services on Power BI/Azure.
See all Amaravati Analytics software services coursesSQL Server Related Questions
Courses you can instantly connect with... Do an online course on SQL Server starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- IT Administration, Networking, Cyber Security Awareness NextGen LearningAED 449Duration: Upto 1 Hour
- CNC (Computer Numerical Control) Programming NextGen LearningAED 199Duration: Upto 20 Hours
- Master of Science in Applied Informatics Synergy University DubaiAED 73,400Duration: 2 Years Live virtual classroom
- AED 34,889Duration: 18 - 20 Months Live virtual classroom
