- Duration: 16 Hours
Course details
Day 1
- Introduction to Power BI
- Products of Power BI
- Installation of Power BI
- Walkthrough of POWER BI desktop
- Working with Data sources
- Different types of storage types /modes
- Difference b/w import /direct Query /live connection
- Working with SQL Server/SSAS/Excel/CSV
- Working with Visualizations
- Understanding of tool tips
- Configuration of Line/bar charts /table and matrix visuals
- Configuration of Pi/Donut /slicer/gauge/card/map visuals
- Remaining default visuals
- Working with custom visuals
- Working with UI-Drill down visuals
- Drill through
- Filters
- Cross filtering
- Alignment of visuals
- Bookmarks
- Sync Slicers
- Data drill/format tabs remaining options
- Security implementation
- Row level /row based security
- Introduction to dax
- Measure /column /table/quick measure /what if
- Home tab
- View tab
- Help/modeling remaining options
- Data cleaning
- Working with Grouping
- Pivot
- Unpivot
- Splitting
- Appending
- Merging
- Adding a column
- Removing duplicates
- Filtering
- Order by
- Having
- Transformations Number/string/date /time
- Configuring Power BI service
- Publishing a report
- Configuring gateways
- Performing a scheduled refresh
- Creating a report
- Creating a dashboard
- Configuring subscription
- Configuring Alerts
- Embedding
- Understanding of publishing
- Working with DAX functions Part 1
- Filter
- Sum
- Sumx
- If
- Is blank
- Contains
- Look up value
- Related
- variables
- Calculate
- All
- All Except
- Summarize
- YTD
- MTD
- QTD
- YOY
- Username
Eligibility / Requirements
No Pre requisites ;Online ,corporate training will be provided
Job roles this course is suitable for:
Power BI Developer , Power BI , Power BI Analyst , Power BI ConsultantAbout 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 courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel : VLOOKUP Formula Course DriveUSD 24
USD 160Duration: Upto 1 Hour - Microsoft Excel 2016 Complete Diploma One EducationUSD 18
USD 257Duration: Upto 62 Hours